#region 动态获取sql语句 根据形参来动态返回sql private string GetSql(string xiaoshouid, string wuliaoid, string selkey) { string init_sql = "select distinct(rollid) from zh1_rool where state='n' and "; System.Text.StringBuilder sb = new StringBuilder(); System.Collections.Hashtable hs = new System.Collections.Hashtable(); hs["soid"] = xiaoshouid; hs["itemid"] = wuliaoid; hs["rollid"] = selkey == string.Empty ? selkey : selkey + "%"; sb.Append(init_sql); foreach (DictionaryEntry de in hs) { if (string.IsNullOrEmpty(de.Value.ToString()) == true) { continue; } else { if (de.Key.ToString() == "rollid") { sb.Append(de.Key); sb.Append(" like "); sb.Append("'"); sb.Append(de.Value); sb.Append("'"); sb.Append(" and "); } else { sb.Append(de.Key); sb.Append("="); sb.Append("'"); sb.Append(de.Value); sb.Append("'"); sb.Append(" and "); } } } string sbs = sb.ToString(); sbs = sbs.Remove(sbs.LastIndexOf("and")); return sbs; } #endregion