/// <summary>
/// 初始化模板信息
/// </summary>
void InitMoBans()
{
var chaXun = new EyouSoft.Model.MCaiGouMoBanChaXunInfo();
chaXun.CgsId = YongHuInfo.GongSiId;
var items = new EyouSoft.BLL.BCaiGouMoBan().GetMoBans(chaXun);
StringBuilder s = new StringBuilder();
if (items != null && items.Count > 0)
{
foreach (var item in items)
{
s.AppendFormat("<option value=\"{0}\">{1}</option>", item.MoBanId, item.Name);
if (item.IsMoRen)
{
MoRenMoBanId = item.MoBanId;
}
}
}
ltrMoBanOption.Text = s.ToString();
}
/// <summary>
/// 获取采购模板信息信息
/// </summary>
/// <param name="chaXun">查询</param>
/// <returns></returns>
public IList <EyouSoft.Model.MCaiGouMoBanInfo> GetMoBans(EyouSoft.Model.MCaiGouMoBanChaXunInfo chaXun)
{
int pageSize = 2000;
int pageIndex = 1;
int recordCount = 0;
return(GetMoBans(pageSize, pageIndex, ref recordCount, chaXun));
}
/// <summary>
/// get chaxun
/// </summary>
/// <returns></returns>
EyouSoft.Model.MCaiGouMoBanChaXunInfo GetChaXunInfo()
{
var info = new EyouSoft.Model.MCaiGouMoBanChaXunInfo();
info.CgsId = YongHuInfo.GongSiId;
info.Name = Utils.GetQueryStringValue("txtName");
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.MCaiGouMoBanInfo> GetMoBans(int pageSize, int pageIndex, ref int recordCount, EyouSoft.Model.MCaiGouMoBanChaXunInfo chaXun)
{
IList <EyouSoft.Model.MCaiGouMoBanInfo> items = new List <EyouSoft.Model.MCaiGouMoBanInfo>();
string fields = "*,(SELECT A1.Name FROM tbl_YongHu AS A1 WHERE A1.YongHuId=tbl_CaiGouMoBan.CaoZuoRenId) AS CaoZuoRenName,(SELECT A1.Name FROM tbl_GongSi AS A1 WHERE A1.GongSiId=tbl_CaiGouMoBan.CgsId) AS CgsName";
StringBuilder sql = new StringBuilder();
string tableName = "tbl_CaiGouMoBan";
string orderByString = " IssueTime DESC ";
string heJiString = "";
#region sql
sql.Append(" IsDelete='0' ");
if (chaXun != null)
{
if (!string.IsNullOrEmpty(chaXun.CgsId))
{
sql.AppendFormat(" AND (CgsId='{0}') ", chaXun.CgsId);
}
if (!string.IsNullOrEmpty(chaXun.Name))
{
sql.AppendFormat(" AND Name LIKE '%{0}%' ", chaXun.Name);
}
}
#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.MCaiGouMoBanInfo();
info.CaoZuoRenId = rdr["CaoZuoRenId"].ToString();
info.CgsId = rdr["CgsId"].ToString();
info.ChanPins = null;
info.IssueTime = rdr.GetDateTime(rdr.GetOrdinal("IssueTime"));
info.MoBanId = rdr["MoBanId"].ToString();
info.Name = rdr["Name"].ToString();
info.CaoZuoRenName = rdr["CaoZuoRenName"].ToString();
info.CgsName = rdr["CgsName"].ToString();
info.IsMoRen = rdr["IsMoRen"].ToString() == "1";
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.MCaiGouMoBanInfo> GetMoBans(int pageSize, int pageIndex, ref int recordCount, EyouSoft.Model.MCaiGouMoBanChaXunInfo chaXun)
{
if (pageSize <= 0)
{
pageSize = 1;
}
if (pageIndex <= 0)
{
pageIndex = 1;
}
var items = dal.GetMoBans(pageSize, pageIndex, ref recordCount, chaXun);
return(items);
}
