public void fillMemberInCompany(Guid IDUser) { ViewModel.Search searchRealUser = new ViewModel.Search(); searchRealUser.Filter = " and tblRealUser.IDLegalUser='******'"; DataSet ds = BisRealUser.GetRealUserSupplierData(searchRealUser); grdMember.DataSource = ds; grdMember.DataBind(); Session["dsRealUser"] = ds; Session["dsRealUserIndex"] = ds; }
public List <string> getPersonelINLegalSupplier(Guid IDLegal, string prefix) { Bis.RealUserMethod bisRealuser = new Bis.RealUserMethod(); ViewModel.Search searchRealUser = new ViewModel.Search(); searchRealUser.Filter = " and tblRealUser.IDLegalUser ='******' and ( tblRealUser.FName like N'%" + prefix.FixFarsi() + "%' or tblRealUser.LName like N'%" + prefix.FixFarsi() + "%' ) "; DataSet dsRealUser = bisRealuser.GetRealUserSupplierData(searchRealUser); List <string> RealUserNames = new List <string>(); if (!dsRealUser.Null_Ds()) { for (int i = 0; i < dsRealUser.Tables[0].Rows.Count; i++) { RealUserNames.Add(string.Format("{0}~{1}", dsRealUser.Tables[0].Rows[i]["FullName"].ToString(), dsRealUser.Tables[0].Rows[i]["IDUser"].ToString())); } return(RealUserNames); } else { RealUserNames.Add(string.Format("{0}~{1}", "اطلاعاتی یافت نشد", Guid.Empty)); return(RealUserNames); } }