/// <summary> /// 获取采购商、供应商信息集合 /// </summary> /// <param name="chaXun">查询</param> /// <returns></returns> public IList <EyouSoft.Model.MGongSiInfo> GetGongSis(EyouSoft.Model.MGongSiChaXunInfo chaXun) { int recordCount = 0; var items = GetGongSis(2000, 1, ref recordCount, chaXun); //var items = dal.GetGongSis(chaXun); return(items); }
/// <summary> /// getautocompletegongsi /// </summary> void GetAutocompleteGongSi() { var chaXun = new EyouSoft.Model.MGongSiChaXunInfo(); chaXun.ShenHeStatus = EyouSoft.Model.ShenHeStatus.已审核; chaXun.Name = Utils.GetQueryStringValue("q"); chaXun.LeiXing = (EyouSoft.Model.GongSiLeiXing?)Utils.GetEnumValueNullable(typeof(EyouSoft.Model.GongSiLeiXing), Utils.GetQueryStringValue("gslx")); var recordCount = 0; var items = new EyouSoft.BLL.BGongSi().GetGongSis(10, 1, ref recordCount, chaXun); var items1 = new List <MAjaxAutocompleteGongSiInfo>(); if (items != null && items.Count > 0) { foreach (var item in items) { var item1 = new MAjaxAutocompleteGongSiInfo(); item1.GongSiId = item.GongSiId; item1.GongSiName = item.Name; items1.Add(item1); } } if (items1 == null || items1.Count == 0) { items1 = new List <MAjaxAutocompleteGongSiInfo>(); items1.Add(new MAjaxAutocompleteGongSiInfo() { GongSiName = "未匹配到公司信息" }); } Utils.RCWE(Newtonsoft.Json.JsonConvert.SerializeObject(items1)); }
/// <summary> /// 获取采购商、供应商信息集合 /// </summary> /// <param name="pageSize">页记录数</param> /// <param name="pageIndex">页序号</param> /// <param name="recordCount">总记录数</param> /// <param name="chaXun">查询</param> /// <returns></returns> public IList <EyouSoft.Model.MGongSiInfo> GetGongSis(int pageSize, int pageIndex, ref int recordCount, EyouSoft.Model.MGongSiChaXunInfo chaXun) { if (pageSize <= 0) { pageSize = 1; } if (pageIndex <= 0) { pageIndex = 1; } object[] heJi; var items = dal.GetGongSis(pageSize, pageIndex, ref recordCount, chaXun, out heJi); return(items); }
/// <summary> /// 获取采购商、供应商信息集合 /// </summary> /// <param name="pageSize">页记录数</param> /// <param name="pageIndex">页序号</param> /// <param name="recordCount">总记录数</param> /// <param name="chaXun">查询</param> /// <param name="heJi">合计信息</param> /// <returns></returns> public IList <EyouSoft.Model.MGongSiInfo> GetGongSis(int pageSize, int pageIndex, ref int recordCount, EyouSoft.Model.MGongSiChaXunInfo chaXun, out object[] heJi) { heJi = new object[] { }; IList <EyouSoft.Model.MGongSiInfo> items = new List <EyouSoft.Model.MGongSiInfo>(); string fields = "*,(SELECT A1.Name FROM tbl_YongHu AS A1 WHERE A1.YongHuId=tbl_GongSi.CaoZuoRenId) AS CaoZuoRenName"; StringBuilder sql = new StringBuilder(); string tableName = "tbl_GongSi"; 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.CgsId)) { sql.AppendFormat(" AND EXISTS(SELECT 1 FROM tbl_GongSiGuanXi AS A1 WHERE A1.GongSiId2=tbl_GongSi.GongSiId AND A1.GongSiId1='{0}') ", chaXun.CgsId); } if (chaXun.LaiYuan.HasValue) { sql.AppendFormat(" AND LaiYuan={0} ", (int)chaXun.LaiYuan.Value); } 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.MGongSiInfo(); info.CaiWuDianHua = rdr["CaiWuDianHua"].ToString(); info.CaiWuName = rdr["CaiWuName"].ToString(); info.CaiWuShenFenZhengHao = rdr["CaiWuShenFenZhengHao"].ToString(); info.CaiWuZhaoPianFilepath = rdr["CaiWuZhaoPianFilepath"].ToString(); info.CaoZuoRenId = rdr["CaoZuoRenId"].ToString(); info.ChengShiId = rdr.GetInt32(rdr.GetOrdinal("ChengShiId")); info.DiZhi = rdr["DiZhi"].ToString(); info.FanRenName = rdr["FanRenName"].ToString(); info.FuZeRenDianHua = rdr["FuZeRenDianHua"].ToString(); info.FuZeRenName = rdr["FuZeRenName"].ToString(); info.FuZeRenShenFenZhengHao = rdr["FuZeRenShenFenZhengHao"].ToString(); info.FuZeRenZhaoPianFilepath = rdr["FuZeRenZhaoPianFilepath"].ToString(); info.GongSiId = rdr["GongSiId"].ToString(); info.IssueTime = rdr.GetDateTime(rdr.GetOrdinal("IssueTime")); info.LeiXing = (EyouSoft.Model.GongSiLeiXing)rdr.GetInt32(rdr.GetOrdinal("LeiXing")); info.Name = rdr["Name"].ToString(); info.ShengFenId = rdr.GetInt32(rdr.GetOrdinal("ShengFenId")); info.YingYeZhiZhaoFilepath = rdr["YingYeZhiZhaoFilepath"].ToString(); info.ZuZhiJiGouFilepath = rdr["ZuZhiJiGouFilepath"].ToString(); info.CaoZuoRenName = rdr["CaoZuoRenName"].ToString(); info.LogoFilepath = rdr["LogoFilepath"].ToString(); info.LxQQ = rdr["LxQQ"].ToString(); info.LaiYuan = (EyouSoft.Model.LaiYuan)rdr.GetInt32(rdr.GetOrdinal("LaiYuan")); info.ShenHeStatus = (EyouSoft.Model.ShenHeStatus)rdr.GetInt32(rdr.GetOrdinal("ShenHeStatus")); items.Add(info); } /* * rdr.NextResult(); * * if (rdr.Read()) * { * if (!rdr.IsDBNull(0)) heJi[0] = rdr.GetDecimal(0); * }*/ } return(items); }