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