/// <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());
}
