public DataTable GetList(UserQueryModel model) { DataTable dt = null; if (model != null) { String sql = "SELECT U.ID, U.LOGINNAME, U.NAME, U.PHONE, U.STATUS,CASE U.STATUS WHEN 1 THEN '有效' ELSE '无效' END AS STA, S.NAME AS SNAME,U.PASSWORD,U.STOREID FROM BPSYS_USER U INNER JOIN BPSYS_STORE S ON U.STOREID = S.ID"; sql += " WHERE 1=1"; //where u.[Name] like '%%' or u.Phone ='' or s.[Name] like '%%' if (!String.IsNullOrEmpty(model.Name)) { sql += String.Format(" AND U.NAME LIKE '%{0}%'", model.Name); } if (!String.IsNullOrEmpty(model.Phone)) { sql += String.Format(" AND U.PHONE ='{0}'", model.Phone); } if (model.Store != null && model.Store != Guid.Empty) { sql += String.Format(" AND S.ID='{0}'", model.Store.ToString()); } using (DataBaseProcess process=new DataBaseProcess()) { dt = process.Query(sql); } } return dt; }
private void LoadData() { UserQueryModel model=new UserQueryModel(); model.Name = textBoxQName.Text.TrimStart().TrimEnd(); model.Phone = textBoxQPhone.Text.TrimStart().TrimEnd(); if (comboBoxQStore.SelectedValue != null) { model.Store = Guid.Parse(comboBoxQStore.SelectedValue.ToString()); } DataTable dt= _action.GetList(model); Bind(dt); }