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