/*/// <summary>
* /// 获取消息集合
* /// </summary>
* /// <param name="chaXun">查询</param>
* /// <returns></returns>
* public IList<EyouSoft.Model.MXiaoXiInfo> GetXiaoXis(EyouSoft.Model.MXiaoXiChaXunInfo chaXun)
* {
* int pageSize = 2000;
* int recordCount = 0;
*
* return GetXiaoXis(pageSize, 1, ref recordCount, chaXun);
* }*/
/// <summary>
/// 获取消息数
/// </summary>
/// <param name="chaXun">查询</param>
/// <returns></returns>
public int GetXiaoXiShu(EyouSoft.Model.MXiaoXiChaXunInfo chaXun)
{
int recordCount = 0;
var items = GetXiaoXis(1, 1, ref recordCount, chaXun);
return(recordCount);
}
/// <summary>
/// init xiaoxi shu
/// </summary>
void InitXiaoXiShu()
{
IList <EyouSoft.Model.XiaoXiLeiXing> leixings = new List <EyouSoft.Model.XiaoXiLeiXing>();
leixings.Add(EyouSoft.Model.XiaoXiLeiXing.公司注册待审核);
var chaXun = new EyouSoft.Model.MXiaoXiChaXunInfo();
chaXun.Status = EyouSoft.Model.XiaoXiStatus.未读;
chaXun.LeiXings = leixings;
chaXun.JieShouGongSiId = YongHuInfo.GongSiId;
XiaoXiShu = new BLL.BXiaoXi().GetXiaoXiShu(chaXun);
}
/// <summary>
/// get chaxun
/// </summary>
/// <returns></returns>
EyouSoft.Model.MXiaoXiChaXunInfo GetChaXunInfo()
{
var info = new EyouSoft.Model.MXiaoXiChaXunInfo();
info.JieShouGongSiId = YongHuInfo.GongSiId;
info.LeiXings = new List <EyouSoft.Model.XiaoXiLeiXing>();
info.LeiXings.Add(EyouSoft.Model.XiaoXiLeiXing.公司注册待审核);
info.Status = (EyouSoft.Model.XiaoXiStatus?)Utils.GetEnumValueNullable(typeof(EyouSoft.Model.XiaoXiStatus), Utils.GetQueryStringValue("txtStatus"));
if (Utils.GetQueryStringValue("txtIsChaXun") != "1")
{
info.Status = EyouSoft.Model.XiaoXiStatus.未读;
XiaoXiStatus = ((int)EyouSoft.Model.XiaoXiStatus.未读).ToString();
}
return(info);
}
/// <summary>
/// 获取采购商消息数量
/// </summary>
void GetCgsXiaoXi()
{
var info = new MAjaxXiaoXiInfo();
var chaXun = new EyouSoft.Model.MXiaoXiChaXunInfo();
EyouSoft.Model.SSO.MYongHuInfo loginYongHuInfo;
bool isLogin = EyouSoft.Security.Membership.YongHuProvider.IsLogin(out loginYongHuInfo);
if (isLogin && loginYongHuInfo.LeiXing == EyouSoft.Model.YongHuLeiXing.采购商)
{
chaXun.JieShouGongSiId = loginYongHuInfo.GongSiId;
chaXun.Status = EyouSoft.Model.XiaoXiStatus.未读;
chaXun.LeiXings = new List <EyouSoft.Model.XiaoXiLeiXing>();
chaXun.LeiXings.Add(EyouSoft.Model.XiaoXiLeiXing.采购商待确认报价);
chaXun.LeiXings.Add(EyouSoft.Model.XiaoXiLeiXing.采购商待确认收货);
var xiaoXiShuLiang = new EyouSoft.BLL.BXiaoXi().GetXiaoXiShu(chaXun);
info.ShuLiang = xiaoXiShuLiang;
}
Utils.RCWE_AJAX("1", "", 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.MXiaoXiInfo> GetXiaoXis(int pageSize, int pageIndex, ref int recordCount, EyouSoft.Model.MXiaoXiChaXunInfo chaXun)
{
IList <EyouSoft.Model.MXiaoXiInfo> items = new List <EyouSoft.Model.MXiaoXiInfo>();
string fields = "*";
StringBuilder sql = new StringBuilder();
string tableName = "tbl_XiaoXi";
string orderByString = " Status ASC,FaChuTime DESC ";
string heJiString = "";
#region sql
sql.Append(" 1=1 ");
if (chaXun != null)
{
if (!string.IsNullOrEmpty(chaXun.FaChuGongSiId))
{
sql.AppendFormat(" AND FaChuGongSiId='{0}' ", chaXun.FaChuGongSiId);
}
if (!string.IsNullOrEmpty(chaXun.FaChuRenId))
{
sql.AppendFormat(" AND FaChuRenId='{0}' ", chaXun.FaChuRenId);
}
if (!string.IsNullOrEmpty(chaXun.JieShouGongSiId))
{
sql.AppendFormat(" AND JieShouGongSiId='{0}' ", chaXun.JieShouGongSiId);
}
if (!string.IsNullOrEmpty(chaXun.JieShouRenId))
{
sql.AppendFormat(" AND JieShouRenId='{0}' ", chaXun.JieShouRenId);
}
if (chaXun.LeiXing.HasValue)
{
sql.AppendFormat(" AND LeiXing={0} ", (int)chaXun.LeiXing.Value);
}
if (chaXun.Status.HasValue)
{
sql.AppendFormat(" AND Status={0} ", (int)chaXun.Status.Value);
}
if (chaXun.LeiXings != null && chaXun.LeiXings.Count > 0)
{
sql.AppendFormat(" AND LeiXing IN({0}) ", GetSqlIn(chaXun.LeiXings));
}
}
#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.MXiaoXiInfo();
info.BiaoTi = rdr["BiaoTi"].ToString();
info.ChuLiRenId = rdr["ChuLiRenId"].ToString();
if (!rdr.IsDBNull(rdr.GetOrdinal("ChuLiTime")))
{
info.ChuLiTime = rdr.GetDateTime(rdr.GetOrdinal("ChuLiTime"));
}
info.FaChuGongSiId = rdr["FaChuGongSiId"].ToString();
info.FaChuRenId = rdr["FaChuRenId"].ToString();
info.FaChuTime = rdr.GetDateTime(rdr.GetOrdinal("FaChuTime"));
info.GuanLianId = rdr["GuanLianId"].ToString();
info.JieShouGongSiId = rdr["JieShouGongSiId"].ToString();
info.JieShouRenId = rdr["JieShouRenId"].ToString();
info.LeiXing = (EyouSoft.Model.XiaoXiLeiXing)rdr.GetInt32(rdr.GetOrdinal("LeiXing"));
info.NeiRong = rdr["NeiRong"].ToString();
info.Status = (EyouSoft.Model.XiaoXiStatus)rdr.GetInt32(rdr.GetOrdinal("Status"));
info.XiaoXiId = rdr["XiaoXiId"].ToString();
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.MXiaoXiInfo> GetXiaoXis(int pageSize, int pageIndex, ref int recordCount, EyouSoft.Model.MXiaoXiChaXunInfo chaXun)
{
if (pageSize <= 0)
{
pageSize = 1;
}
if (pageIndex <= 0)
{
pageIndex = 1;
}
var items = dal.GetXiaoXis(pageSize, pageIndex, ref recordCount, chaXun);
return(items);
}