修改你的所有查询语句

时间：2011-01-05 来源：卑鄙De小贝

以下只是部分代码,但原理都在这啦~希望能帮到大家

 1         public static string xiugaiSqlStr(string sqlstr) {
 2             denglu mydenglu = new denglu();
 3             if (!sqlstr.Contains("T_Companyid")) {
 4                 if ((sqlstr.Contains("where") || sqlstr.Contains("Where") || sqlstr.Contains("WHERE")) && !sqlstr.Contains("insert")) {
 5                     sqlstr += " and F_Companyid = " + mydenglu.commderid() + "";
 6                 }
 7                 else {
 8                     sqlstr += " where F_Companyid = " + mydenglu.commderid() + "";
 9                 }
10                 if (sqlstr.Contains("insert")) {
11                     string[] sqlstr1 = sqlstr.Split(')');
12                     sqlstr = "";
13                     sqlstr = sqlstr1[0].ToString() + ",F_Companyid)" + sqlstr1[1].ToString() + "," + mydenglu.commderid() + ")";
14                 }
15             }
16             return sqlstr;
17         }