/// <summary>
/// 查询条件
/// </summary>
/// <param name="hs"></param>
/// <returns></returns>
public static TB_User[] findUserByCondition(Hashtable hs)
{
try
{
List <ICriterion> list = new List <ICriterion>();
//List<EqExpression> list = new List<EqExpression>();
//List<LikeExpression> list2 = new List<LikeExpression>();
if (hs.ContainsKey("Name"))
{
list.Add(new LikeExpression("Name", "%" + hs["Name"] + "%"));
}
if (hs.ContainsKey("Logid"))
{
list.Add(new EqExpression("LogName", hs["Logid"]));
}
if (hs.ContainsKey("role"))
{
list.Add(new EqExpression("Role", hs["role"]));
}
if (hs.ContainsKey("Isdeleted"))
{
list.Add(new EqExpression("Isdeleted", hs["Isdeleted"]));
}
TB_User[] users = TB_UserDao.FindAll(list.ToArray());
return(users);
}
catch (Exception ex)
{
Log.Error(ex.Message);
MessageHelper.ShowMessage("E999");
return(null);
}
}
private void bindUserData()
{
TB_User[] arr = TB_UserDao.FindAll(new EqExpression("STATUS", 1));
List <TB_User> list = new List <TB_User>(arr);
if (arr.Length > 0)
{
dgUser.ItemsSource = list;
//dgUser.SelectedIndex = 0;
}
}
private void BindUserData()
{
TB_User[] arr = TB_UserDao.FindAll(new EqExpression("STATUS", 1));
List <TB_User> list = new List <TB_User>(arr);
if (arr.Length > 0)
{
list = list.FindAll(a => a.USER_CODE != "财务" && a.USER_CODE != "系统管理员");
dgUser.ItemsSource = list;
dgUser.SelectedIndex = 0;
}
}
public static int isRepeatUserId(string number, int id)
{
try
{
TB_User[] user = TB_UserDao.FindAll(new EqExpression("LogName", number), new NotExpression(new EqExpression("Id", id)));
return(user.Length);
}
catch (Exception ex)
{
MessageHelper.ShowMessage("E999", "保存数据发生错误。");
return(-1);
}
}
public static TB_User[] getAllSalers()
{
try
{
TB_User[] salers = TB_UserDao.FindAll(new Order("Id", true), new EqExpression("Isdeleted", (int)EnmIsdeleted.使用中), new EqExpression("Role", (int)EnmUserRole.销售渠道));
return(salers);
}
catch (Exception ex)
{
Log.Error(ex.Message);
MessageHelper.ShowMessage("E999", "销售渠道信息获取发生错误。");
return(null);
}
}
private void BindUserData(string str)
{
TB_User[] arr = TB_UserDao.FindAll(new EqExpression("STATUS", 1), new EqExpression("DEPT", str));
if (!string.IsNullOrEmpty(txtName.Text))
{
arr = TB_UserDao.FindAll(new EqExpression("STATUS", 1), new LikeExpression("USER_CODE", "%" + txtName.Text + "%"), new EqExpression("DEPT", str));
}
List <TB_User> list = new List <TB_User>(arr);
if (arr.Length > 0)
{
dgUser.ItemsSource = list;
dgUser.SelectedIndex = 0;
}
}
public static TB_User[] getAllSalersAndWrite()
{
try
{
Order[] orders = { new Order("Id", true), new Order("Role", true) }; //排序规则
TB_User[] salers = TB_UserDao.FindAll(orders, new EqExpression("Isdeleted", (int)EnmIsdeleted.使用中),
new OrExpression(new EqExpression("Role", (int)EnmUserRole.销售渠道),
new EqExpression("Role", (int)EnmUserRole.录入人员)));
return(salers);
}
catch (Exception ex)
{
Log.Error(ex.Message);
MessageHelper.ShowMessage("E999", "人员信息获取发生错误。");
return(null);
}
}