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