/// <summary> /// 获取采购商、供应商、平台用户信息集合 /// </summary> /// <param name="pageSize">页记录数</param> /// <param name="pageIndex">页序号</param> /// <param name="recordCount">总记录数</param> /// <param name="chaXun">查询</param> /// <returns></returns> public IList <EyouSoft.Model.MYongHuInfo> GetYongHus(int pageSize, int pageIndex, ref int recordCount, EyouSoft.Model.MYongHuChaXunInfo chaXun) { IList <EyouSoft.Model.MYongHuInfo> items = new List <EyouSoft.Model.MYongHuInfo>(); string fields = "*,(SELECT G.Name FROM tbl_GongSi G WHERE G.GongSiId=tbl_YongHu.GongSiId) GongSiName"; StringBuilder sql = new StringBuilder(); string tableName = "tbl_YongHu"; string orderByString = " IssueTime DESC "; string heJiString = ""; #region sql sql.Append(" IsDelete='0' "); if (chaXun != null) { if (chaXun.LeiXing.HasValue) { sql.AppendFormat(" AND LeiXing={0} ", (int)chaXun.LeiXing.Value); } if (!string.IsNullOrEmpty(chaXun.Name)) { sql.AppendFormat(" AND Name LIKE '%{0}%' ", chaXun.Name); } if (!string.IsNullOrEmpty(chaXun.GongSiId)) { sql.AppendFormat(" AND GongSiId='{0}' ", chaXun.GongSiId); } else if (!string.IsNullOrEmpty(chaXun.GongSiName)) { sql.AppendFormat(" AND EXISTS(SELECT 1 FORM tbl_GongSi AS A1 WHERE A1.GongSiId=tbl_YongHu.GongSiId AND A1.Name LIKE '%{0}%') ", chaXun.GongSiName); } if (!string.IsNullOrEmpty(chaXun.Username)) { sql.AppendFormat(" AND Username LIKE '%{0}%' ", chaXun.Username); } if (chaXun.Status.HasValue) { sql.AppendFormat(" AND Status={0} ", (int)chaXun.Status.Value); } if (!string.IsNullOrEmpty(chaXun.BuMen)) { sql.AppendFormat(" AND BuMenName LIKE '%{0}%' ", chaXun.BuMen); } if (chaXun.ShenHeStatus.HasValue) { sql.AppendFormat(" AND ShenHeStatus={0} ", (int)chaXun.ShenHeStatus.Value); } } #endregion using (IDataReader rdr = DbHelper.ExecuteReader1(_db, pageSize, pageIndex, ref recordCount, tableName, fields, sql.ToString(), orderByString, heJiString)) { while (rdr.Read()) { var info = new EyouSoft.Model.MYongHuInfo(); info.BuMenName = rdr["BuMenName"].ToString(); info.CaoZuoRenId = rdr["CaoZuoRenId"].ToString(); info.ChuShengRiQi = rdr.GetDateTime(rdr.GetOrdinal("ChuShengRiQi")); info.DianHua = rdr["DianHua"].ToString(); info.DiZhi = rdr["DiZhi"].ToString(); info.Email = rdr["Email"].ToString(); info.Fax = rdr["Fax"].ToString(); info.GongSiId = rdr["GongSiId"].ToString(); info.IssueTime = rdr.GetDateTime(rdr.GetOrdinal("IssueTime")); info.JueSeId = rdr["JueSeId"].ToString(); info.LeiXing = (EyouSoft.Model.YongHuLeiXing)rdr.GetInt32(rdr.GetOrdinal("LeiXing")); info.Name = rdr["Name"].ToString(); info.PasswordMD5 = rdr["PasswordMD5"].ToString(); info.RuZhiRiQi = rdr.GetDateTime(rdr.GetOrdinal("RuZhiRiQi")); info.ShouJi = rdr["ShouJi"].ToString(); info.Status = (EyouSoft.Model.YongHuStatus)rdr.GetInt32(rdr.GetOrdinal("Status")); info.Username = rdr["Username"].ToString(); info.XingBie = (EyouSoft.Model.XingBie)rdr.GetInt32(rdr.GetOrdinal("XingBie")); info.YongHuId = rdr["YongHuId"].ToString(); info.ZhaoPianFilepath = rdr["ZhaoPianFilepath"].ToString(); info.ZhiWu = rdr["ZhiWu"].ToString(); info.GongSiName = rdr["GongSiName"].ToString(); items.Add(info); } } return(items); }