/// <summary>
/// get chaxun
/// </summary>
/// <returns></returns>
EyouSoft.Model.MGongSiGuanXiChaXunInfo GetChaXunInfo()
{
var info = new EyouSoft.Model.MGongSiGuanXiChaXunInfo();
info.GongSiId = YongHuInfo.GongSiId;
info.LeiXing = EyouSoft.Model.GongSiLeiXing.供应商;
info.Name = Utils.GetQueryStringValue("txtName");
if (Utils.GetQueryStringValue("txtIsGuanXi") == "1")
{
info.IsGuanZhu = true;
}
if (Utils.GetQueryStringValue("txtIsGuanXi") == "0")
{
info.IsGuanZhu = false;
}
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.MGongSiGuanXiInfo> GetGongSiGuanXis(int pageSize, int pageIndex, ref int recordCount, EyouSoft.Model.MGongSiGuanXiChaXunInfo chaXun)
{
if (pageSize <= 0)
{
pageSize = 1;
}
if (pageIndex <= 0)
{
pageIndex = 1;
}
if (chaXun == null || string.IsNullOrEmpty(chaXun.GongSiId))
{
return(null);
}
var items = dal.GetGongSiGuanXis(pageSize, pageIndex, ref recordCount, chaXun);
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.MGongSiGuanXiInfo> GetGongSiGuanXis(int pageSize, int pageIndex, ref int recordCount, EyouSoft.Model.MGongSiGuanXiChaXunInfo chaXun)
{
var items = new List <EyouSoft.Model.MGongSiGuanXiInfo>();
string fields = "*";
if (chaXun != null)
{
if (!string.IsNullOrEmpty(chaXun.GongSiId))
{
fields += string.Format(",ISNULL((SELECT '1' FROM tbl_GongSiGuanXi AS A1 WHERE A1.GongSiId1='{0}' AND A1.GongSiId2=tbl_GongSi.GongSiId),'0') AS IsGuanZhu", chaXun.GongSiId);
}
}
StringBuilder sql = new StringBuilder();
string tableName = "tbl_GongSi";
string orderByString = " IssueTime DESC ";
string heJiString = "";
#region sql
sql.Append(" IsDelete='0' AND ShenHeStatus=1 ");
if (chaXun != null)
{
if (!string.IsNullOrEmpty(chaXun.Name))
{
sql.AppendFormat(" AND Name LIKE '%{0}%' ", chaXun.Name);
}
if (chaXun.IsGuanZhu.HasValue)
{
sql.AppendFormat(" AND {0} EXISTS(SELECT 1 FROM tbl_GongSiGuanXi AS A1 WHERE A1.GongSiId2=tbl_GongSi.GongSiId AND A1.GongSiId1='{1}') ", chaXun.IsGuanZhu.Value?"":"NOT", chaXun.GongSiId);
}
if (chaXun.LeiXing.HasValue)
{
sql.AppendFormat(" AND LeiXing={0} ", (int)chaXun.LeiXing.Value);
}
}
#endregion
using (IDataReader rdr = DbHelper.ExecuteReader1(_db, pageSize, pageIndex, ref recordCount, tableName, fields, sql.ToString(), orderByString, heJiString))
{
while (rdr.Read())
{
var item = new EyouSoft.Model.MGongSiGuanXiInfo();
item.FanRenName = rdr["FanRenName"].ToString();
item.GongSiId = rdr["GongSiId"].ToString();
item.IsGuanZhu = rdr["IsGuanZhu"].ToString() == "1";
item.LeiXing = (EyouSoft.Model.GongSiLeiXing)rdr.GetInt32(rdr.GetOrdinal("LeiXing"));
item.Name = rdr["Name"].ToString();
item.FuZeRenName = rdr["FuZeRenName"].ToString();
item.FuZeRenDianHua = rdr["FuZeRenDianHua"].ToString();
items.Add(item);
}
}
return(items);
}
