public DataTable SelectC_User(int rowcount, int pageindex, string emp_no, OleExec DB, DB_TYPE_ENUM DBType) { string strSql = (emp_no == "" ? $@"select * from c_user order by edit_time " : $@"select *from c_user where (factory,bu_name,dpt_name ) in (select factory, bu_name, dpt_name from c_user where emp_no = '{emp_no}')"); DataTable res = DB.ExecSelect_b(rowcount, pageindex, strSql); return(res); }
public List <c_user_model> SelectUserInfo(int rowcount, int pageindex, string SearchEmp, string EmpLevel, string DptName, string LoginEmp, string Factory, string Bu, OleExec DB) { string strSql = string.Empty; DataTable dt = new DataTable(); List <c_user_model> UsetInfolsit = new List <c_user_model>(); if (EmpLevel == "9") //9级用户取到本厂别所有部门的用户信息 { strSql = (SearchEmp == "" ? $@" select * from c_user where factory='{Factory}' order by edit_time " : $@" select * from c_user where factory='{Factory}' and emp_no like '%{SearchEmp}%' order by edit_time "); } else if (EmpLevel == "1") //1级用户取到本厂别本部门 的用户信息 { strSql = (SearchEmp == "" ? $@" select * from c_user where factory='{Factory}' and bu_name='{Bu}' and dpt_name='{DptName}' order by edit_time " : $@" select * from c_user where emp_no like '%{SearchEmp}%' and factory='{Factory}' and bu_name='{Bu}' and dpt_name='{DptName}' order by edit_time "); } else if (EmpLevel == "0") //0级用户取到本人 的用户信息 { strSql = $@" select * from c_user where emp_no like '%{LoginEmp}%' order by edit_time "; } else { return(UsetInfolsit); } dt = DB.ExecSelect_b(rowcount, pageindex, strSql); foreach (DataRow item in dt.Rows) { UsetInfolsit.Add(new c_user_model { ID = item["ID"].ToString(), FACTORY = item["FACTORY"].ToString(), BU_NAME = item["BU_NAME"].ToString(), EMP_NO = item["EMP_NO"].ToString(), EMP_NAME = item["EMP_NAME"].ToString(), EMP_PASSWORD = item["EMP_PASSWORD"].ToString(), EMP_LEVEL = item["EMP_LEVEL"].ToString(), DPT_NAME = item["DPT_NAME"].ToString(), POSITION_NAME = item["POSITION_NAME"].ToString(), MAIL_ADDRESS = item["MAIL_ADDRESS"].ToString(), PHONE_NUMBER = item["PHONE_NUMBER"].ToString(), LOCATION = item["LOCATION"].ToString(), LOCK_FLAG = item["LOCK_FLAG"].ToString(), AGENT_EMP_NO = item["AGENT_EMP_NO"].ToString(), EMP_DESC = item["EMP_DESC"].ToString(), EDIT_EMP = item["EDIT_EMP"].ToString(), EMP_EN_NAME = item["EMP_EN_NAME"].ToString() }); } return(UsetInfolsit); }