/// <summary>
/// 获取所有仓库
/// </summary>
/// <param name="tum"></param>
/// <returns></returns>
public List <StoreCode> QueryStore(t_ADMM_UsrMst tum)
{
try
{
var list = (from u in db.t_ADMM_UsrItem
join g in db.t_ADMM_UsrDataRightMst on u.fGrpCode equals g.fUsrID
join k in db.t_ADMM_UsrDataRightItem on g.fUsrID equals k.fUsrID
where u.fUsrID == tum.fUsrID & k.fItemCode == "13"
select new
{
fValue = k.fValue,
fValueDesc = k.fValueDesc
}).ToList().Distinct();
List <StoreCode> data = new List <StoreCode>();
foreach (var item in list)
{
StoreCode n = new StoreCode();
n.fValue = item.fValue;
n.fValueDesc = item.fValueDesc;
data.Add(n);
}
return(data);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
private void login()
{
if (Usrid.Text.Trim() != "" & Pwd.Text.Trim() != "")
{
try
{
t_ADMM_UsrMst admin = n.LoginHandle(Usrid.Text.Trim(), Pwd.Text.Trim());
if (admin != null)
{
this.Hide();
new Form2(admin).ShowDialog();
}
else
{
DevExpress.XtraEditors.XtraMessageBox.Show("用户名或密码错误");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
};
}
else
{
DevExpress.XtraEditors.XtraMessageBox.Show("用户名或密码不能为空");
}
}
public Form2(t_ADMM_UsrMst t)
{
InitializeComponent();
lookUpEdit1.Properties.ValueMember = "fValue";
lookUpEdit1.Properties.DisplayMember = "fValueDesc";
searchLookUpEdit1.Properties.NullText = "";
lookUpEdit1.Properties.DataSource = n.GetStore(t);
}
/// <summary>
/// 根据用户获取信息
/// </summary>
/// <returns></returns>
public t_ADMM_UsrMst Query()
{
try
{
t_ADMM_UsrMst tum = db.t_ADMM_UsrMst.Where(u => u.fUsrID == t.fUsrID & u.C_x_f010 == t.C_x_f010).FirstOrDefault();
return(tum);
}catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public List <StoreCode> GetStore(t_ADMM_UsrMst tsm)
{
return(new Login().QueryStore(tsm));
}
