/// <summary> /// 获得列表SQL /// </summary> private string GetSql(Dictionary <string, string> dict) { StringBuilder strb = new StringBuilder(); strb.Append(" select t.* "); strb.Append(" from bas_user t where 1=1"); //单位名称 string dep_name = DataBase.GetDictionaryValue(dict, "orgname"); if (!string.IsNullOrEmpty(dep_name)) { strb.Append(" and org_name like '%" + dep_name + "%'"); } //姓名 string user_name = DataBase.GetDictionaryValue(dict, "orgname"); if (!string.IsNullOrEmpty(user_name)) { strb.Append(" and Realname like '%" + user_name + "%'"); } return(strb.ToString()); }
private string DepartmentSql(Dictionary <string, string> dict) { StringBuilder strb = new StringBuilder(); strb.Append("select t.*," + Hi.Common.Db.DbUtils.GetPageRowNum("id") + " from bas_org t"); strb.Append(" where 1=1 "); //名称 string dep_name = DataBase.GetDictionaryValue(dict, "org_name"); if (!string.IsNullOrEmpty(dep_name)) { strb.Append(" and org_name like '%" + dep_name + "%'"); } return(strb.ToString()); }