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