/// <summary>
/// get chaxun
/// </summary>
/// <returns></returns>
EyouSoft.Model.MCaiGouDanChaXunInfo GetChaXunInfo()
{
var info = new EyouSoft.Model.MCaiGouDanChaXunInfo();
info.CaiGouDanName = Utils.GetQueryStringValue("txtCgdName");
info.FaBuTime1 = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("txtFaBuTime1"));
info.FaBuTime2 = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("txtFaBuTime2"));
info.CgsId = YongHuInfo.GongSiId;
return(info);
}
/// <summary>
/// 获取采购单信息集合
/// </summary>
/// <param name="pageSize">页记录数</param>
/// <param name="pageIndex">页序号</param>
/// <param name="recordCount">总记录数</param>
/// <param name="chaXun">查询</param>
/// <returns></returns>
public IList <EyouSoft.Model.MCaiGouDanInfo> GetCaiGouDans(int pageSize, int pageIndex, ref int recordCount, EyouSoft.Model.MCaiGouDanChaXunInfo chaXun)
{
IList <EyouSoft.Model.MCaiGouDanInfo> items = new List <EyouSoft.Model.MCaiGouDanInfo>();
string fields = "*,(SELECT A1.Name FROM tbl_YongHu AS A1 WHERE A1.YongHuId=tbl_CaiGouDan.CaoZuoRenId) AS CaoZuoRenName,(SELECT A1.Name FROM tbl_YongHu AS A1 WHERE A1.YongHuId=tbl_CaiGouDan.FaBuRenId) AS FaBuRenName";
StringBuilder sql = new StringBuilder();
string tableName = "tbl_CaiGouDan";
string orderByString = " IssueTime DESC ";
string heJiString = "";
#region sql
sql.Append(" IsDelete='0' ");
if (chaXun != null)
{
if (!string.IsNullOrEmpty(chaXun.CaiGouDanName))
{
sql.AppendFormat(" AND CaiGouDanName LIKE '%{0}%' ", chaXun.CaiGouDanName);
}
if (!string.IsNullOrEmpty(chaXun.CaiGouDanHao))
{
sql.AppendFormat(" AND CaiGouDanHao LIKE '%{0}%' ", chaXun.CaiGouDanHao);
}
if (chaXun.FaBuTime1.HasValue)
{
sql.AppendFormat(" AND IssueTime>'{0}' ", chaXun.FaBuTime1.Value.AddMinutes(-1));
}
if (chaXun.FaBuTime2.HasValue)
{
sql.AppendFormat(" AND IssueTime<'{0}' ", chaXun.FaBuTime2.Value.AddDays(1).AddMinutes(-1));
}
if (!string.IsNullOrEmpty(chaXun.CgsId))
{
sql.AppendFormat(" AND CgsId='{0}' ", chaXun.CgsId);
}
}
#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.MCaiGouDanInfo();
info.CaiGouBuMen = rdr["CaiGouBuMen"].ToString();
info.CaiGouDanHao = rdr["CaiGouDanHao"].ToString();
info.CaiGouDanId = rdr["CaiGouDanId"].ToString();
info.CaiGouDanName = rdr["CaiGouDanName"].ToString();
info.CaoZuoRenId = rdr["CaoZuoRenId"].ToString();
info.CgsId = rdr["CgsId"].ToString();
info.IssueTime = rdr.GetDateTime(rdr.GetOrdinal("IssueTime"));
info.MoBanId = rdr["MoBanId"].ToString();
info.ShouHuoDiZhi = rdr["ShouHuoDiZhi"].ToString();
info.ShouHuoRenDianHua = rdr["ShouHuoRenDianHua"].ToString();
info.ShouHuoRenName = rdr["ShouHuoRenName"].ToString();
info.Status = (EyouSoft.Model.CaiGouDanStatus)rdr.GetInt32(rdr.GetOrdinal("Status"));
info.CaoZuoRenName = rdr["CaoZuoRenName"].ToString();
info.FaBuRenId = rdr["FaBuRenId"].ToString();
if (!rdr.IsDBNull(rdr.GetOrdinal("FaBuTime")))
{
info.FaBuTime = rdr.GetDateTime(rdr.GetOrdinal("FaBuTime"));
}
info.FaBuRenName = rdr["FaBuRenName"].ToString();
info.ChanPins = null;
info.CaiGouDanShuoMing = rdr["CaiGouDanShuoMing"].ToString();
if (!rdr.IsDBNull(rdr.GetOrdinal("YaoQiuDaoHuoTime")))
{
info.YaoQiuDaoHuoTime = rdr.GetDateTime(rdr.GetOrdinal("YaoQiuDaoHuoTime"));
}
items.Add(info);
}
}
return(items);
}
/// <summary>
/// 获取采购单信息集合
/// </summary>
/// <param name="pageSize">页记录数</param>
/// <param name="pageIndex">页序号</param>
/// <param name="recordCount">总记录数</param>
/// <param name="chaXun">查询</param>
/// <returns></returns>
public IList <EyouSoft.Model.MCaiGouDanInfo> GetCaiGouDans(int pageSize, int pageIndex, ref int recordCount, EyouSoft.Model.MCaiGouDanChaXunInfo chaXun)
{
if (pageSize <= 0)
{
pageSize = 1;
}
if (pageIndex <= 0)
{
pageIndex = 1;
}
var items = dal.GetCaiGouDans(pageSize, pageIndex, ref recordCount, chaXun);
return(items);
}
