/// <summary>
/// get chaxun info
/// </summary>
/// <returns></returns>
EyouSoft.Model.YlStructure.MHangQiDingDanChaXunInfo GetChaXunInfo()
{
var info = new EyouSoft.Model.YlStructure.MHangQiDingDanChaXunInfo();
info.DingDanHao = Utils.GetQueryStringValue("dingdanhao");
info.XiaDanShiJian1 = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("sxiadan"));
info.XiaDanShiJian2 = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("exiadan"));
info.DingDanStatus = (EyouSoft.Model.EnumType.YlStructure.HangQiDingDanStatus?)Utils.GetEnumValueNull(typeof(EyouSoft.Model.EnumType.YlStructure.HangQiDingDanStatus), Utils.GetQueryStringValue("dingdanzhuangtai"));
info.FuKuanStatus = (EyouSoft.Model.EnumType.YlStructure.FuKuanStatus?)Utils.GetEnumValueNull(typeof(EyouSoft.Model.EnumType.YlStructure.FuKuanStatus), Utils.GetQueryStringValue("fukuanzhuangtai"));
info.DingDanLeiXing = 1;
return(info);
}
/// <summary>
/// 获取订单信息集合
/// </summary>
/// <param name="companyId">公司编号</param>
/// <param name="pageSize">页记录数</param>
/// <param name="pageIndex">页序号</param>
/// <param name="recordCount">总记录数</param>
/// <param name="chaXun">查询</param>
/// <returns></returns>
public IList <EyouSoft.Model.YlStructure.MHangQiDingDanInfo> GetDingDans(string companyId, int pageSize, int pageIndex, ref int recordCount, EyouSoft.Model.YlStructure.MHangQiDingDanChaXunInfo chaXun)
{
if (string.IsNullOrEmpty(companyId))
{
return(null);
}
return(dal.GetDingDans(companyId, pageSize, pageIndex, ref recordCount, chaXun));
}
/// <summary>
/// 获取订单信息集合
/// </summary>
/// <param name="companyId">公司编号</param>
/// <param name="pageSize">页记录数</param>
/// <param name="pageIndex">页序号</param>
/// <param name="recordCount">总记录数</param>
/// <param name="chaXun">查询</param>
/// <returns></returns>
public IList <EyouSoft.Model.YlStructure.MHangQiDingDanInfo> GetDingDans(string companyId, int pageSize, int pageIndex, ref int recordCount, EyouSoft.Model.YlStructure.MHangQiDingDanChaXunInfo chaXun)
{
IList <EyouSoft.Model.YlStructure.MHangQiDingDanInfo> items = new List <EyouSoft.Model.YlStructure.MHangQiDingDanInfo>();
string tableName = "view_YL_HangQiDingDan";
string fields = "*";
string orderByString = "IssueTime DESC";
string sumString = string.Empty;
StringBuilder sql = new StringBuilder();
sql.AppendFormat(" CompanyId='{0}' AND IsDelete='0' ", companyId);
if (chaXun != null)
{
if (!string.IsNullOrEmpty(chaXun.HuiYuanId))
{
sql.AppendFormat(" AND XiaDanRenId='{0}' ", chaXun.HuiYuanId);
}
if (!string.IsNullOrEmpty(chaXun.DingDanHao))
{
sql.AppendFormat(" AND JiaoYiHao LIKE '%{0}%' ", chaXun.DingDanHao);
}
if (chaXun.DingDanStatus.HasValue)
{
sql.AppendFormat(" AND DingDanStatus={0} ", (int)chaXun.DingDanStatus.Value);
}
if (chaXun.FuKuanStatus.HasValue)
{
sql.AppendFormat(" AND FuKuanStatus={0} ", (int)chaXun.FuKuanStatus.Value);
}
if (chaXun.XiaDanShiJian1.HasValue)
{
sql.AppendFormat(" AND IssueTime>='{0}' ", chaXun.XiaDanShiJian1.Value);
}
if (chaXun.XiaDanShiJian2.HasValue)
{
sql.AppendFormat(" AND IssueTime<='{0}' ", chaXun.XiaDanShiJian2.Value.AddDays(1).AddMinutes(-1));
}
if (chaXun.DingDanLeiXing.HasValue)
{
switch (chaXun.DingDanLeiXing)
{
case 0: sql.AppendFormat(" AND LeiXing=0 AND IsTuanGou='0' "); break;
case 1: sql.AppendFormat(" AND LeiXing=1 AND IsTuanGou='0' "); break;
case 2: sql.AppendFormat(" AND IsTuanGou='1' "); break;
}
}
}
using (IDataReader rdr = DbHelper.ExecuteReader1(_db, pageSize, pageIndex, ref recordCount, tableName, fields.ToString(), sql.ToString(), orderByString, sumString))
{
while (rdr.Read())
{
var info = new EyouSoft.Model.YlStructure.MHangQiDingDanInfo();
info.CompanyId = rdr["CompanyId"].ToString();
info.DiKouInfo = null;
info.DingDanId = rdr["DingDanId"].ToString();
info.DingDanStatus = (EyouSoft.Model.EnumType.YlStructure.HangQiDingDanStatus)rdr.GetByte(rdr.GetOrdinal("DingDanStatus"));
info.FaPiaoDiZhiId = rdr["FaPiaoDiZhiId"].ToString();
info.FaPiaoKuaiDiJinE = rdr.GetDecimal(rdr.GetOrdinal("FaPiaoKuaiDiJinE"));
info.FaPiaoLeiXing = rdr["FaPiaoLeiXing"].ToString();
info.FaPiaoMingXi = rdr["FaPiaoMingXi"].ToString();
info.FaPiaoPeiSongFangShi = (EyouSoft.Model.EnumType.YlStructure.FaPiaoPeiSongFangShi)rdr.GetByte(rdr.GetOrdinal("FaPiaoPeiSongFangShi"));
info.FaPiaoTaiTou = rdr["FaPiaoTaiTou"].ToString();
info.FuJiaChanPins = null;
info.FuKuanStatus = (EyouSoft.Model.EnumType.YlStructure.FuKuanStatus)rdr.GetByte(rdr.GetOrdinal("FuKuanStatus"));
info.HangQiId = rdr["HangQiId"].ToString();
info.IssueTime = rdr.GetDateTime(rdr.GetOrdinal("IssueTime"));
info.IsTuanGou = rdr["IsTuanGou"].ToString() == "1";
info.IsXuYaoFaPiao = rdr["IsXuYaoFaPiao"].ToString() == "1";
info.JiaGes = null;
info.JiaoYiHao = rdr["JiaoYiHao"].ToString();
info.JinE = rdr.GetDecimal(rdr.GetOrdinal("JinE"));
info.LiuWeiDaoQiShiJian = rdr.GetDateTime(rdr.GetOrdinal("LiuWeiDaoQiShiJian"));
info.RenShu = rdr.GetInt32(rdr.GetOrdinal("RenShu"));
info.RiQiId = rdr["RiQiId"].ToString();
info.TuanGouId = rdr["TuanGouId"].ToString();
info.XiaDanBeiZhu = rdr["XiaDanBeiZhu"].ToString();
info.XiaDanRenId = rdr["XiaDanRenId"].ToString();
info.YouHuis = null;
info.YouKes = null;
info.YuDingRenDianHua = rdr["YuDingRenDianHua"].ToString();
info.YuDingRenName = rdr["YuDingRenName"].ToString();
info.YuDingRenShouJi = rdr["YuDingRenShouJi"].ToString();
info.YuDingRenYouXiang = rdr["YuDingRenYouXiang"].ToString();
info.JiFenLeiJiBiLi = rdr.GetDecimal(rdr.GetOrdinal("JiFenLeiJiBiLi"));
info.MingCheng = rdr["MingCheng"].ToString();
info.GysName = rdr["GysName"].ToString();
info.GongSiName = rdr["GongSiName"].ToString();
info.XiLieName = rdr["XiLieName"].ToString();
info.ChuanZhiName = rdr["ChuanZhiName"].ToString();
items.Add(info);
}
}
return(items);
}
