/// <summary>
/// 初始化列表
/// </summary>
protected void InitOrders()
{
Eyousoft_yhq.BLL.Order bll = new Eyousoft_yhq.BLL.Order();
#region 查询实体
var memeber = new Eyousoft_yhq.BLL.Member().GetModel(HuiYuanInfo.UserID);
if (memeber == null || !memeber.IsAgent) return;
Eyousoft_yhq.Model.MSearchOrder serchModel = new Eyousoft_yhq.Model.MSearchOrder();
serchModel.MemberID = memeber.UserID;
serchModel.PromotionCode = memeber.PollCode == "" ? "未知" : memeber.PromotionCode;
serchModel.PaymentState = Eyousoft_yhq.Model.PaymentState.已支付;
pageIndex = UtilsCommons.GetPagingIndex("Page");
#endregion
var list = bll.GetFYList(pageSize, pageIndex, ref recordCount, serchModel);
if (list != null && list.Count > 0)
{
rpt_orders.DataSource = list;
rpt_orders.DataBind();
this.ExporPageInfoSelect1.PageLinkURL = Request.ServerVariables["SCRIPT_NAME"].ToString() + "?";
this.ExporPageInfoSelect1.intPageSize = pageSize;
this.ExporPageInfoSelect1.CurrencyPage = pageIndex;
this.ExporPageInfoSelect1.intRecordCount = recordCount;
this.ExporPageInfoSelect1.UrlParams = Request.QueryString;
litMsg.Visible = false;
}
else
{
rpt_orders.Visible = false;
}
}
protected void InitOrders(string Type)
{
Eyousoft_yhq.BLL.Order bll = new Eyousoft_yhq.BLL.Order();
Eyousoft_yhq.Model.MSearchOrder serchModel = new Eyousoft_yhq.Model.MSearchOrder();
serchModel.PaymentState = (Eyousoft_yhq.Model.PaymentState?)Utils.GetEnumValueNull(typeof(Eyousoft_yhq.Model.PaymentState), Utils.GetQueryStringValue("OrderType"), (int)Eyousoft_yhq.Model.PaymentState.未支付);
serchModel.MemberID = userInfo.UserID;
pageIndex = Utils.GetInt(Utils.GetQueryStringValue("pageindex"));
var list = bll.GetList(pageSize, pageIndex, ref recordCount, serchModel);
int isPage = 0;
if (recordCount % pageSize != 0)
{
isPage = recordCount / pageSize + 1;
}
else
{
isPage = recordCount / pageSize;
}
if (list != null && list.Count > 0)
{
if (isPage >= pageIndex)
{
rpt_orders.DataSource = list;
rpt_orders.DataBind();
}
}
}
/// <summary>
/// 初始化列表
/// </summary>
protected void InitOrders()
{
Eyousoft_yhq.BLL.Order bll = new Eyousoft_yhq.BLL.Order();
#region 查询实体
Eyousoft_yhq.Model.MSearchOrder serchModel = new Eyousoft_yhq.Model.MSearchOrder();
serchModel.OrderCode = Utils.GetQueryStringValue("orderCode");
serchModel.ConfirmCode = Utils.GetQueryStringValue("ConfirmCode");
serchModel.STime = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("StartTime"));
serchModel.ETime = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("EndTime"));
serchModel.AppUser = Utils.GetQueryStringValue("AppUser");
serchModel.ConSumState = Eyousoft_yhq.Model.ConSumState.已消费;
pageIndex = UtilsCommons.GetPagingIndex("Page");
if (HuiYuanInfo.LeiXing == Eyousoft_yhq.Model.WebmasterLeiXing.供应商)
{
serchModel.ChanPinFaBuRenId = HuiYuanInfo.UserId;
}
#endregion
var list = bll.GetScanList(pageSize, pageIndex, ref recordCount, serchModel);
if (list != null && list.Count > 0)
{
rpt_orders.DataSource = list;
rpt_orders.DataBind();
BindPage();
litMsg.Visible = false;
}
else
{
rpt_orders.Visible = false;
}
}
/// <summary>
/// 页面初始化
/// </summary>
private void PageInit()
{
Eyousoft_yhq.BLL.Order bll = new Eyousoft_yhq.BLL.Order();
#region 查询实体
Eyousoft_yhq.Model.MSearchOrder serchModel = new Eyousoft_yhq.Model.MSearchOrder();
serchModel.STime = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("txtStartTime"));
serchModel.ETime = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("txtEndTime") + " 23:59:59");
serchModel.XSTime = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("txtXStartTime"));
serchModel.XETime = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("txtXEndTime") + " 23:59:59");
serchModel.OrderCode = Utils.GetQueryStringValue("txtOrderCode");
serchModel.AppUserId = HuiYuanInfo.UserID;
serchModel.ConSumState = Eyousoft_yhq.Model.ConSumState.已消费;
pageIndex = UtilsCommons.GetPagingIndex("Page");
#endregion
var list = bll.GetScanList(pageSize, pageIndex, ref recordCount, serchModel);
if (list != null && list.Count > 0)
{
this.rpOrder.DataSource = list;
this.rpOrder.DataBind();
BindPage();
}
else
{
Literal1.Text = "<tr align=\"center\"> <td colspan=\"11\">没有相关数据</td></tr>";
}
}
/// <summary>
/// 页面初始化
/// </summary>
private void PageInit()
{
Eyousoft_yhq.BLL.Order bll = new Eyousoft_yhq.BLL.Order();
#region 查询实体
Eyousoft_yhq.Model.MSearchOrder serchModel = new Eyousoft_yhq.Model.MSearchOrder();
serchModel.STime = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("txtStartTime"));
serchModel.ETime = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("txtEndTime") + " 23:59:59");
serchModel.RouteName = Utils.GetQueryStringValue("txtRouteName");
serchModel.OrderPrice = Utils.GetDecimal(Utils.GetQueryStringValue("txtOrderPrice"));
serchModel.MemberID = HuiYuanInfo.UserID;
pageIndex = UtilsCommons.GetPagingIndex("Page");
#endregion
btnAppUser.Visible = EyouSoft.Common.Page.HuiyuanPage.GetUserInfo().IsAdmin == "1";
var list = bll.GetList(pageSize, pageIndex, ref recordCount, serchModel);
if (list != null && list.Count > 0)
{
this.rpOrder.DataSource = list;
this.rpOrder.DataBind();
BindPage();
}
else
{
Literal1.Text = "<tr align=\"center\"> <td colspan=\"11\">没有相关数据</td></tr>";
}
}
/// <summary>
/// 初始化列表
/// </summary>
protected void InitOrders()
{
Eyousoft_yhq.BLL.Order bll = new Eyousoft_yhq.BLL.Order();
#region 查询实体
Eyousoft_yhq.Model.MSearchOrder serchModel = new Eyousoft_yhq.Model.MSearchOrder();
serchModel.OrderCode = Utils.GetQueryStringValue("orderCode");
serchModel.ConfirmCode = Utils.GetQueryStringValue("ConfirmCode");
serchModel.STime = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("StartTime"));
serchModel.ETime = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("EndTime"));
serchModel.AppUser = Utils.GetQueryStringValue("AppUser");
serchModel.ConSumState = Eyousoft_yhq.Model.ConSumState.已消费;
pageIndex = UtilsCommons.GetPagingIndex("Page");
if (HuiYuanInfo.LeiXing == Eyousoft_yhq.Model.WebmasterLeiXing.供应商)
{
serchModel.ChanPinFaBuRenId = HuiYuanInfo.UserId;
}
#endregion
var list = bll.GetScanList(pageSize, pageIndex, ref recordCount, serchModel);
if (list != null && list.Count > 0)
{
rpt_orders.DataSource = list;
rpt_orders.DataBind();
BindPage();
litMsg.Visible = false;
}
else
{
rpt_orders.Visible = false;
}
}
/// <summary>
/// 初始化列表
/// </summary>
protected void InitOrders()
{
Eyousoft_yhq.BLL.Order bll = new Eyousoft_yhq.BLL.Order();
#region 查询实体
Eyousoft_yhq.Model.MSearchOrder serchModel = new Eyousoft_yhq.Model.MSearchOrder();
serchModel.MemberID = Utils.GetQueryStringValue("userid");
serchModel.PromotionCode = Utils.GetQueryStringValue("Code") == "" ? "未知" : Utils.GetQueryStringValue("Code");
serchModel.PaymentState = Eyousoft_yhq.Model.PaymentState.已支付;
pageIndex = UtilsCommons.GetPagingIndex("Page");
#endregion
var list = bll.GetFYList(pageSize, pageIndex, ref recordCount, serchModel);
if (list != null && list.Count > 0)
{
rpt_orders.DataSource = list;
rpt_orders.DataBind();
this.ExporPageInfoSelect1.PageLinkURL = Request.ServerVariables["SCRIPT_NAME"].ToString() + "?";
this.ExporPageInfoSelect1.intPageSize = pageSize;
this.ExporPageInfoSelect1.CurrencyPage = pageIndex;
this.ExporPageInfoSelect1.intRecordCount = recordCount;
this.ExporPageInfoSelect1.UrlParams = Request.QueryString;
litMsg.Visible = false;
var Countlist = bll.GetList(serchModel);
for (int i = 0; i < Countlist.Count; i++)
{
sumPayED += Countlist[i].RebackMoney;
sumBacK += Countlist[i].backMoney;
}
lblPayED.Text = sumPayED.ToString("C2");
lblBacK.Text = sumBacK.ToString("C2");
}
else
{
plaHJ.Visible = false;
rpt_orders.Visible = false;
}
}
/// <summary>
/// 初始化列表
/// </summary>
protected void InitOrders()
{
Eyousoft_yhq.BLL.Order bll = new Eyousoft_yhq.BLL.Order();
#region 查询实体
Eyousoft_yhq.Model.MSearchOrder serchModel = new Eyousoft_yhq.Model.MSearchOrder();
serchModel.MemberID = Utils.GetQueryStringValue("userid");
serchModel.PromotionCode = Utils.GetQueryStringValue("Code") == "" ? "未知" : Utils.GetQueryStringValue("Code");
serchModel.PaymentState = Eyousoft_yhq.Model.PaymentState.已支付;
pageIndex = UtilsCommons.GetPagingIndex("Page");
#endregion
var list = bll.GetFYList(pageSize, pageIndex, ref recordCount, serchModel);
if (list != null && list.Count > 0)
{
rpt_orders.DataSource = list;
rpt_orders.DataBind();
this.ExporPageInfoSelect1.PageLinkURL = Request.ServerVariables["SCRIPT_NAME"].ToString() + "?";
this.ExporPageInfoSelect1.intPageSize = pageSize;
this.ExporPageInfoSelect1.CurrencyPage = pageIndex;
this.ExporPageInfoSelect1.intRecordCount = recordCount;
this.ExporPageInfoSelect1.UrlParams = Request.QueryString;
litMsg.Visible = false;
var Countlist = bll.GetList(serchModel);
for (int i = 0; i < Countlist.Count; i++)
{
sumPayED += Countlist[i].RebackMoney;
sumBacK += Countlist[i].backMoney;
}
lblPayED.Text = sumPayED.ToString("C2");
lblBacK.Text = sumBacK.ToString("C2");
}
else
{
plaHJ.Visible = false;
rpt_orders.Visible = false;
}
}
protected void InitOrders(string Type)
{
Eyousoft_yhq.BLL.Order bll = new Eyousoft_yhq.BLL.Order();
Eyousoft_yhq.Model.MSearchOrder serchModel = new Eyousoft_yhq.Model.MSearchOrder();
serchModel.PaymentState = (Eyousoft_yhq.Model.PaymentState?)Utils.GetEnumValueNull(typeof(Eyousoft_yhq.Model.PaymentState), Utils.GetQueryStringValue("OrderType"), (int)Eyousoft_yhq.Model.PaymentState.未支付);
serchModel.MemberID = userInfo.UserID;
var list = bll.GetList(pageSize, pageIndex, ref recordCount, serchModel);
if (list != null && list.Count > 0)
{
rpt_orders.DataSource = list;
rpt_orders.DataBind();
litMsg.Visible = false;
}
else
{
PlaceHolder1.Visible = false;
litMsg.Visible = true;
}
}
/// <summary>
/// 初始化列表
/// </summary>
protected void InitOrders()
{
Eyousoft_yhq.BLL.Order bll = new Eyousoft_yhq.BLL.Order();
#region 查询实体
Eyousoft_yhq.Model.MSearchOrder serchModel = new Eyousoft_yhq.Model.MSearchOrder();
serchModel.OrderCode = Utils.GetQueryStringValue("orderCode");
serchModel.ConfirmCode = Utils.GetQueryStringValue("ConfirmCode");
serchModel.STime = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("StartTime"));
serchModel.ETime = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("EndTime"));
serchModel.OrderState = (Eyousoft_yhq.Model.OrderState?)Utils.GetEnumValueNull(typeof(Eyousoft_yhq.Model.OrderState), Utils.GetQueryStringValue("sleorderstatus"));
serchModel.PaymentState = (Eyousoft_yhq.Model.PaymentState?)Utils.GetEnumValueNull(typeof(Eyousoft_yhq.Model.PaymentState), Utils.GetQueryStringValue("slepaystatus"));
if (!string.IsNullOrEmpty(Utils.GetQueryStringValue("jiesuan")))
{
serchModel.jiesuan = (Eyousoft_yhq.Model.JSfangshi)Utils.GetInt(Utils.GetQueryStringValue("jiesuan"));
}
pageIndex = UtilsCommons.GetPagingIndex("Page");
if (HuiYuanInfo.LeiXing == Eyousoft_yhq.Model.WebmasterLeiXing.供应商)
{
serchModel.ChanPinFaBuRenId = HuiYuanInfo.UserId;
phSMDZD.Visible = false;
}
#endregion
var list = bll.GetList(pageSize, pageIndex, ref recordCount, serchModel);
if (list != null && list.Count > 0)
{
rpt_orders.DataSource = list;
rpt_orders.DataBind();
BindPage();
litMsg.Visible = false;
}
else
{
rpt_orders.Visible = false;
}
}
/// <summary>
/// 初始化列表
/// </summary>
protected void InitOrders()
{
Eyousoft_yhq.BLL.Order bll = new Eyousoft_yhq.BLL.Order();
#region 查询实体
Eyousoft_yhq.Model.MSearchOrder serchModel = new Eyousoft_yhq.Model.MSearchOrder();
serchModel.OrderCode = Utils.GetQueryStringValue("orderCode");
serchModel.ConfirmCode = Utils.GetQueryStringValue("ConfirmCode");
serchModel.STime = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("StartTime"));
serchModel.ETime = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("EndTime"));
serchModel.OrderState = (Eyousoft_yhq.Model.OrderState?)Utils.GetEnumValueNull(typeof(Eyousoft_yhq.Model.OrderState), Utils.GetQueryStringValue("sleorderstatus"));
serchModel.PaymentState = (Eyousoft_yhq.Model.PaymentState?)Utils.GetEnumValueNull(typeof(Eyousoft_yhq.Model.PaymentState), Utils.GetQueryStringValue("slepaystatus"));
if (!string.IsNullOrEmpty(Utils.GetQueryStringValue("jiesuan"))) serchModel.jiesuan = (Eyousoft_yhq.Model.JSfangshi)Utils.GetInt(Utils.GetQueryStringValue("jiesuan"));
pageIndex = UtilsCommons.GetPagingIndex("Page");
if (HuiYuanInfo.LeiXing == Eyousoft_yhq.Model.WebmasterLeiXing.供应商)
{
serchModel.ChanPinFaBuRenId = HuiYuanInfo.UserId;
phSMDZD.Visible = false;
}
#endregion
var list = bll.GetList(pageSize, pageIndex, ref recordCount, serchModel);
if (list != null && list.Count > 0)
{
rpt_orders.DataSource = list;
rpt_orders.DataBind();
BindPage();
litMsg.Visible = false;
}
else
{
rpt_orders.Visible = false;
}
}
/// <summary>
/// 初始化列表
/// </summary>
protected void InitOrders()
{
Eyousoft_yhq.BLL.Order bll = new Eyousoft_yhq.BLL.Order();
#region 查询实体
var memeber = new Eyousoft_yhq.BLL.Member().GetModel(HuiYuanInfo.UserID);
if (memeber == null || !memeber.IsAgent)
{
return;
}
Eyousoft_yhq.Model.MSearchOrder serchModel = new Eyousoft_yhq.Model.MSearchOrder();
serchModel.MemberID = memeber.UserID;
serchModel.PromotionCode = memeber.PollCode == "" ? "未知" : memeber.PromotionCode;
serchModel.PaymentState = Eyousoft_yhq.Model.PaymentState.已支付;
pageIndex = UtilsCommons.GetPagingIndex("Page");
#endregion
var list = bll.GetFYList(pageSize, pageIndex, ref recordCount, serchModel);
if (list != null && list.Count > 0)
{
rpt_orders.DataSource = list;
rpt_orders.DataBind();
this.ExporPageInfoSelect1.PageLinkURL = Request.ServerVariables["SCRIPT_NAME"].ToString() + "?";
this.ExporPageInfoSelect1.intPageSize = pageSize;
this.ExporPageInfoSelect1.CurrencyPage = pageIndex;
this.ExporPageInfoSelect1.intRecordCount = recordCount;
this.ExporPageInfoSelect1.UrlParams = Request.QueryString;
litMsg.Visible = false;
}
else
{
rpt_orders.Visible = false;
}
}
/// <summary>
/// 页面初始化
/// </summary>
private void PageInit()
{
Eyousoft_yhq.BLL.Order bll = new Eyousoft_yhq.BLL.Order();
#region 查询实体
Eyousoft_yhq.Model.MSearchOrder serchModel = new Eyousoft_yhq.Model.MSearchOrder();
serchModel.STime = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("txtStartTime"));
serchModel.ETime = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("txtEndTime") + " 23:59:59");
serchModel.RouteName = Utils.GetQueryStringValue("txtRouteName");
serchModel.OrderPrice = Utils.GetDecimal(Utils.GetQueryStringValue("txtOrderPrice"));
serchModel.MemberID = HuiYuanInfo.UserID;
pageIndex = UtilsCommons.GetPagingIndex("Page");
#endregion
btnAppUser.Visible = EyouSoft.Common.Page.HuiyuanPage.GetUserInfo().IsAdmin == "1";
var list = bll.GetList(pageSize, pageIndex, ref recordCount, serchModel);
if (list != null && list.Count > 0)
{
this.rpOrder.DataSource = list;
this.rpOrder.DataBind();
BindPage();
}
else
{
Literal1.Text = "<tr align=\"center\"> <td colspan=\"11\">没有相关数据</td></tr>";
}
}
/// <summary>
/// 获取分页列表
/// </summary>
/// <param name="PageSize"></param>
/// <param name="PageIndex"></param>
/// <param name="RecordCount"></param>
/// <param name="serModel"></param>
/// <returns></returns>
public IList <Eyousoft_yhq.Model.Order> GetList(Eyousoft_yhq.Model.MSearchOrder serModel)
{
IList <Eyousoft_yhq.Model.Order> list = new List <Eyousoft_yhq.Model.Order>();
StringBuilder query = new StringBuilder();
query.Append("select * from view_Order where 1=1");
if (serModel != null)
{
if (!string.IsNullOrEmpty(serModel.MemberID))
{
query.AppendFormat(" and MemberID = '{0}' ", serModel.MemberID);
}
if (!string.IsNullOrEmpty(serModel.OrderCode))
{
query.AppendFormat(" and OrderCode like '%{0}%' ", serModel.OrderCode);
}
if (!string.IsNullOrEmpty(serModel.ConfirmCode))
{
query.AppendFormat(" and ConfirmCode like '%{0}%' ", serModel.ConfirmCode);
}
if (serModel.OrderState.HasValue)
{
query.AppendFormat(" AND OrderState = '{0}' ", (int)serModel.OrderState.Value);
}
if (serModel.PaymentState.HasValue)
{
query.AppendFormat(" AND PayState = '{0}' ", (int)serModel.PaymentState.Value);
}
if (serModel.STime.HasValue)
{
query.AppendFormat(" AND IssueTime>='{0}' ", serModel.STime.Value);
}
if (serModel.ETime.HasValue)
{
query.AppendFormat(" AND IssueTime< '{0}' ", serModel.ETime.Value.AddDays(1));
}
if (!string.IsNullOrEmpty(serModel.RouteName))
{
query.AppendFormat(" AND ProductName like '%{0}%' ", serModel.RouteName);
}
if (serModel.OrderPrice != 0)
{
query.AppendFormat(" AND OrderPrice = '{0}' ", serModel.OrderPrice);
}
if (!string.IsNullOrEmpty(serModel.PromotionCode))
{
query.AppendFormat(" and (PollCode = '{0}' OR PromotionCode= '{0}' )", serModel.PromotionCode);
}
}
query.Append(" order by IssueTime DESC ");
DbCommand cmd = this._db.GetSqlStringCommand(query.ToString());
using (IDataReader dr = DbHelper.ExecuteReader(cmd, this._db))
{
while (dr.Read())
{
Eyousoft_yhq.Model.Order model = new Eyousoft_yhq.Model.Order();
model.OrderID = dr.GetString(dr.GetOrdinal("OrderId"));
model.ProductID = dr.IsDBNull(dr.GetOrdinal("ProductID")) ? "" : dr.GetString(dr.GetOrdinal("ProductID"));
model.ProductName = dr.IsDBNull(dr.GetOrdinal("ProductName")) ? "" : dr.GetString(dr.GetOrdinal("ProductName"));
model.OrderCode = dr.GetString(dr.GetOrdinal("OrderCode"));
model.MemberID = dr.GetString(dr.GetOrdinal("MemberID"));
model.MemberName = dr.GetString(dr.GetOrdinal("MemberName"));
model.MemberTel = dr.IsDBNull(dr.GetOrdinal("MemberTel")) ? "" : dr.GetString(dr.GetOrdinal("MemberTel"));
model.MemberSex = (Eyousoft_yhq.Model.sexType)dr.GetByte(dr.GetOrdinal("MemberSex"));
model.OrderState = (Eyousoft_yhq.Model.OrderState)dr.GetByte(dr.GetOrdinal("OrderState"));
model.PayState = (Eyousoft_yhq.Model.PaymentState)dr.GetByte(dr.GetOrdinal("PayState"));
model.IsCheck = this.GetBoolean(dr.GetString(dr.GetOrdinal("ProductName")));
model.ConfirmCode = dr.IsDBNull(dr.GetOrdinal("ConfirmCode")) ? "" : dr.GetString(dr.GetOrdinal("ConfirmCode"));
model.Remark = dr.IsDBNull(dr.GetOrdinal("Remark")) ? "" : dr.GetString(dr.GetOrdinal("Remark"));
model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime"));
model.OrderPrice = dr.GetDecimal(dr.GetOrdinal("OrderPrice"));
model.TourDate = dr.IsDBNull(dr.GetOrdinal("TourDate")) ? null : Utils.GetDateTimeNullable(dr.GetDateTime(dr.GetOrdinal("TourDate")).ToString());
model.FavourCode = dr.GetString(dr.GetOrdinal("FavourCode"));
model.isEvery = this.GetBoolean(dr.GetString(dr.GetOrdinal("isEvery")));
model.ProductType = dr.GetInt32(dr.GetOrdinal("ProductType"));
model.ContractType = dr.IsDBNull(dr.GetOrdinal("ContractType")) ? Eyousoft_yhq.Model.ContractType.国内合同 : (Eyousoft_yhq.Model.ContractType)dr.GetByte(dr.GetOrdinal("ContractType")); model.OrderPrice = dr.GetDecimal(dr.GetOrdinal("OrderPrice"));
model.PeopleNum = dr.GetInt32(dr.GetOrdinal("PeopleNum"));
model.ContractText = dr.IsDBNull(dr.GetOrdinal("ContractText")) ? "" : dr.GetString(dr.GetOrdinal("ContractText"));
model.IsealCheck = GetBoolean(dr.GetString(dr.GetOrdinal("IsealCheck")));
model.FYJE = dr.IsDBNull(dr.GetOrdinal("fyje")) ? 0 : dr.GetDecimal(dr.GetOrdinal("fyje"));
model.SendFile = this.GetAttachList(dr["ComAttachXML"].ToString(), model.OrderID);
model.AddressID = dr.IsDBNull(dr.GetOrdinal("AddressID")) ? "" : dr.GetString(dr.GetOrdinal("AddressID"));
model.RebackMoney = dr.IsDBNull(dr.GetOrdinal("RebackMoney")) ? 0 : dr.GetDecimal(dr.GetOrdinal("RebackMoney"));
model.backMoney = dr.IsDBNull(dr.GetOrdinal("backMoney")) ? 0 : dr.GetDecimal(dr.GetOrdinal("backMoney"));
model.ProductOpState = (Eyousoft_yhq.Model.ProductOp)dr.GetByte(dr.GetOrdinal("ProductOpState"));
model.ZCodeViaDate = dr.IsDBNull(dr.GetOrdinal("ZCodeViaDate")) ? DateTime.Now : dr.GetDateTime(dr.GetOrdinal("ZCodeViaDate"));
model.XiaoFei = (Eyousoft_yhq.Model.XFstate)dr.GetByte(dr.GetOrdinal("ConSumState"));
model.JIESUAN = (Eyousoft_yhq.Model.JSfangshi)dr.GetByte(dr.GetOrdinal("JState"));
list.Add(model);
}
};
return(list);
}
protected void InitOrders(string Type)
{
Eyousoft_yhq.BLL.Order bll = new Eyousoft_yhq.BLL.Order();
Eyousoft_yhq.Model.MSearchOrder serchModel = new Eyousoft_yhq.Model.MSearchOrder();
serchModel.PaymentState = (Eyousoft_yhq.Model.PaymentState?)Utils.GetEnumValueNull(typeof(Eyousoft_yhq.Model.PaymentState), Utils.GetQueryStringValue("OrderType"), (int)Eyousoft_yhq.Model.PaymentState.未支付);
serchModel.MemberID = userInfo.UserID;
var list = bll.GetList(pageSize, pageIndex, ref recordCount, serchModel);
if (list != null && list.Count > 0)
{
rpt_orders.DataSource = list;
rpt_orders.DataBind();
litMsg.Visible = false;
}
else
{
PlaceHolder1.Visible = false;
litMsg.Visible = true;
}
}
/// <summary>
/// 获取分页列表
/// </summary>
/// <param name="PageSize"></param>
/// <param name="PageIndex"></param>
/// <param name="RecordCount"></param>
/// <param name="serModel"></param>
/// <returns></returns>
public IList <Eyousoft_yhq.Model.Order> GetScanList(int PageSize, int PageIndex, ref int RecordCount, Eyousoft_yhq.Model.MSearchOrder serModel)
{
IList <Eyousoft_yhq.Model.Order> list = new List <Eyousoft_yhq.Model.Order>();
string tableName = "view_OrderScan";
string fileds = " * ";
string orderByString = " AppTime desc ";
StringBuilder query = new StringBuilder();
query.Append(" 1=1 ");
if (serModel != null)
{
if (serModel.ConSumState.HasValue)
{
query.AppendFormat(" AND ConSumState = '{0}' ", (int)serModel.ConSumState.Value);
}
if (!string.IsNullOrEmpty(serModel.OrderCode))
{
query.AppendFormat(" and OrderCode like '%{0}%' ", serModel.OrderCode);
}
if (!string.IsNullOrEmpty(serModel.ConfirmCode))
{
query.AppendFormat(" and ConfirmCode like '%{0}%' ", serModel.ConfirmCode);
}
if (!string.IsNullOrEmpty(serModel.AppUserId))
{
query.AppendFormat(" and AppUserId = '{0}' ", serModel.AppUserId);
}
if (!string.IsNullOrEmpty(serModel.AppUser))
{
query.AppendFormat(" and AppUserName like '%{0}%' ", serModel.ConfirmCode);
}
if (serModel.STime.HasValue)
{
query.AppendFormat(" AND IssueTime>='{0}' ", serModel.STime.Value);
}
if (serModel.ETime.HasValue)
{
query.AppendFormat(" AND IssueTime< '{0}' ", serModel.ETime.Value.AddDays(1));
}
if (serModel.XSTime.HasValue)
{
query.AppendFormat(" AND AppTime>='{0}' ", serModel.XSTime.Value);
}
if (serModel.XETime.HasValue)
{
query.AppendFormat(" AND AppTime< '{0}' ", serModel.XETime.Value.AddDays(1));
}
if (!string.IsNullOrEmpty(serModel.RouteName))
{
query.AppendFormat(" AND ProductName like '%{0}%' ", serModel.RouteName);
}
}
using (IDataReader dr = DbHelper.ExecuteReader1(this._db, PageSize, PageIndex, ref RecordCount, tableName, fileds, query.ToString(), orderByString, null))
{
while (dr.Read())
{
Eyousoft_yhq.Model.Order model = new Eyousoft_yhq.Model.Order();
model.OrderID = dr.GetString(dr.GetOrdinal("OrderId"));
model.ProductID = dr.IsDBNull(dr.GetOrdinal("ProductID")) ? "" : dr.GetString(dr.GetOrdinal("ProductID"));
model.ProductName = dr.IsDBNull(dr.GetOrdinal("ProductName")) ? "" : dr.GetString(dr.GetOrdinal("ProductName"));
model.OrderCode = dr.GetString(dr.GetOrdinal("OrderCode"));
model.MemberID = dr.GetString(dr.GetOrdinal("MemberID"));
model.MemberName = dr.GetString(dr.GetOrdinal("MemberName"));
model.OrderState = (Eyousoft_yhq.Model.OrderState)dr.GetByte(dr.GetOrdinal("OrderState"));
model.PayState = (Eyousoft_yhq.Model.PaymentState)dr.GetByte(dr.GetOrdinal("PayState"));
model.IsCheck = this.GetBoolean(dr.GetString(dr.GetOrdinal("ProductName")));
model.ConfirmCode = dr.IsDBNull(dr.GetOrdinal("ConfirmCode")) ? "" : dr.GetString(dr.GetOrdinal("ConfirmCode"));
model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime"));
model.ProductType = dr.GetInt32(dr.GetOrdinal("ProductType"));
model.AppTime = dr.IsDBNull(dr.GetOrdinal("AppTime")) ? DateTime.MinValue : dr.GetDateTime(dr.GetOrdinal("AppTime"));
model.AppUserName = dr.IsDBNull(dr.GetOrdinal("AppUserName")) ? string.Empty : dr.GetString(dr.GetOrdinal("AppUserName"));
model.AppMobNo = dr.IsDBNull(dr.GetOrdinal("AppMobNo")) ? "" : dr.GetString(dr.GetOrdinal("AppMobNo"));
list.Add(model);
}
};
return(list);
}
/// <summary>
/// 获取返佣
/// </summary>
/// <param name="PageSize"></param>
/// <param name="PageIndex"></param>
/// <param name="RecordCount"></param>
/// <param name="serModel"></param>
/// <returns></returns>
public IList <Eyousoft_yhq.Model.Order> GetFYList(int PageSize, int PageIndex, ref int RecordCount, Eyousoft_yhq.Model.MSearchOrder serModel)
{
IList <Eyousoft_yhq.Model.Order> list = new List <Eyousoft_yhq.Model.Order>();
string tableName = "view_Order";
string fileds = " * ";
string orderByString = " IssueTime desc ";
StringBuilder query = new StringBuilder();
query.Append(" PayState=2 ");
if (serModel != null)
{
if (!string.IsNullOrEmpty(serModel.MemberID))
{
query.AppendFormat(" and (PollCode = '{0}' OR PromotionCode= '{0}' OR MemberID = '{1}' ) ", serModel.PromotionCode, serModel.MemberID);
}
}
using (IDataReader dr = DbHelper.ExecuteReader1(this._db, PageSize, PageIndex, ref RecordCount, tableName, fileds, query.ToString(), orderByString, null))
{
while (dr.Read())
{
Eyousoft_yhq.Model.Order model = new Eyousoft_yhq.Model.Order();
model.OrderID = dr.GetString(dr.GetOrdinal("OrderId"));
model.ProductID = dr.IsDBNull(dr.GetOrdinal("ProductID")) ? "" : dr.GetString(dr.GetOrdinal("ProductID"));
model.ProductName = dr.IsDBNull(dr.GetOrdinal("ProductName")) ? "" : dr.GetString(dr.GetOrdinal("ProductName"));
model.OrderCode = dr.GetString(dr.GetOrdinal("OrderCode"));
model.MemberID = dr.GetString(dr.GetOrdinal("MemberID"));
model.MemberName = dr.GetString(dr.GetOrdinal("MemberName"));
model.MemberTel = dr.IsDBNull(dr.GetOrdinal("MemberTel")) ? "" : dr.GetString(dr.GetOrdinal("MemberTel"));
model.MemberSex = (Eyousoft_yhq.Model.sexType)dr.GetByte(dr.GetOrdinal("MemberSex"));
model.OrderState = (Eyousoft_yhq.Model.OrderState)dr.GetByte(dr.GetOrdinal("OrderState"));
model.PayState = (Eyousoft_yhq.Model.PaymentState)dr.GetByte(dr.GetOrdinal("PayState"));
model.IsCheck = this.GetBoolean(dr.GetString(dr.GetOrdinal("ProductName")));
model.ConfirmCode = dr.IsDBNull(dr.GetOrdinal("ConfirmCode")) ? "" : dr.GetString(dr.GetOrdinal("ConfirmCode"));
model.Remark = dr.IsDBNull(dr.GetOrdinal("Remark")) ? "" : dr.GetString(dr.GetOrdinal("Remark"));
model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime"));
model.OrderPrice = dr.GetDecimal(dr.GetOrdinal("OrderPrice"));
model.TourDate = dr.IsDBNull(dr.GetOrdinal("TourDate")) ? null : Utils.GetDateTimeNullable(dr.GetDateTime(dr.GetOrdinal("TourDate")).ToString());
model.FavourCode = dr.GetString(dr.GetOrdinal("FavourCode"));
model.isEvery = this.GetBoolean(dr.GetString(dr.GetOrdinal("isEvery")));
model.ProductType = dr.GetInt32(dr.GetOrdinal("ProductType"));
model.ContractType = dr.IsDBNull(dr.GetOrdinal("ContractType")) ? Eyousoft_yhq.Model.ContractType.国内合同 : (Eyousoft_yhq.Model.ContractType)dr.GetByte(dr.GetOrdinal("ContractType")); model.OrderPrice = dr.GetDecimal(dr.GetOrdinal("OrderPrice"));
model.PeopleNum = dr.GetInt32(dr.GetOrdinal("PeopleNum"));
model.ContractText = dr.IsDBNull(dr.GetOrdinal("ContractText")) ? "" : dr.GetString(dr.GetOrdinal("ContractText"));
model.IsealCheck = GetBoolean(dr.GetString(dr.GetOrdinal("IsealCheck")));
model.FYJE = dr.IsDBNull(dr.GetOrdinal("fyje")) ? 0 : dr.GetDecimal(dr.GetOrdinal("fyje"));
model.AddressID = dr.IsDBNull(dr.GetOrdinal("AddressID")) ? "" : dr.GetString(dr.GetOrdinal("AddressID"));
model.RebackMoney = dr.IsDBNull(dr.GetOrdinal("RebackMoney")) ? 0 : dr.GetDecimal(dr.GetOrdinal("RebackMoney"));
model.backMoney = dr.IsDBNull(dr.GetOrdinal("backMoney")) ? 0 : dr.GetDecimal(dr.GetOrdinal("backMoney"));
model.ProductOpState = (Eyousoft_yhq.Model.ProductOp)dr.GetByte(dr.GetOrdinal("ProductOpState"));
model.ZCodeViaDate = dr.IsDBNull(dr.GetOrdinal("ZCodeViaDate")) ? DateTime.Now : dr.GetDateTime(dr.GetOrdinal("ZCodeViaDate"));
model.XiaoFei = (Eyousoft_yhq.Model.XFstate)dr.GetByte(dr.GetOrdinal("ConSumState"));
model.JIESUAN = (Eyousoft_yhq.Model.JSfangshi)dr.GetByte(dr.GetOrdinal("JState"));
list.Add(model);
}
};
return(list);
}
/// <summary>
/// 获取返佣
/// </summary>
/// <param name="PageSize"></param>
/// <param name="PageIndex"></param>
/// <param name="RecordCount"></param>
/// <param name="serModel"></param>
/// <returns></returns>
public IList <Eyousoft_yhq.Model.Order> GetFYList(int PageSize, int PageIndex, ref int RecordCount, Eyousoft_yhq.Model.MSearchOrder serModel)
{
return(dal.GetFYList(PageSize, PageIndex, ref RecordCount, serModel));
}
public IList <Eyousoft_yhq.Model.Order> GetList(Eyousoft_yhq.Model.MSearchOrder serModel)
{
return(dal.GetList(serModel));
}
/// <summary>
/// 页面初始化
/// </summary>
private void PageInit()
{
Eyousoft_yhq.BLL.Order bll = new Eyousoft_yhq.BLL.Order();
#region 查询实体
Eyousoft_yhq.Model.MSearchOrder serchModel = new Eyousoft_yhq.Model.MSearchOrder();
serchModel.STime = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("txtStartTime"));
serchModel.ETime = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("txtEndTime") + " 23:59:59");
serchModel.XSTime = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("txtXStartTime"));
serchModel.XETime = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("txtXEndTime") + " 23:59:59");
serchModel.OrderCode = Utils.GetQueryStringValue("txtOrderCode");
serchModel.AppUserId = HuiYuanInfo.UserID;
serchModel.ConSumState = Eyousoft_yhq.Model.ConSumState.已消费;
pageIndex = UtilsCommons.GetPagingIndex("Page");
#endregion
var list = bll.GetScanList(pageSize, pageIndex, ref recordCount, serchModel);
if (list != null && list.Count > 0)
{
this.rpOrder.DataSource = list;
this.rpOrder.DataBind();
BindPage();
}
else
{
Literal1.Text = "<tr align=\"center\"> <td colspan=\"11\">没有相关数据</td></tr>";
}
}
protected void InitOrders(string Type)
{
Eyousoft_yhq.BLL.Order bll = new Eyousoft_yhq.BLL.Order();
Eyousoft_yhq.Model.MSearchOrder serchModel = new Eyousoft_yhq.Model.MSearchOrder();
serchModel.PaymentState = (Eyousoft_yhq.Model.PaymentState?)Utils.GetEnumValueNull(typeof(Eyousoft_yhq.Model.PaymentState), Utils.GetQueryStringValue("OrderType"), (int)Eyousoft_yhq.Model.PaymentState.未支付);
serchModel.MemberID = userInfo.UserID;
pageIndex = Utils.GetInt(Utils.GetQueryStringValue("pageindex"));
var list = bll.GetList(pageSize, pageIndex, ref recordCount, serchModel);
int isPage = 0;
if (recordCount % pageSize != 0)
{
isPage = recordCount / pageSize + 1;
}
else
{
isPage = recordCount / pageSize;
}
if (list != null && list.Count > 0)
{
if (isPage >= pageIndex)
{
rpt_orders.DataSource = list;
rpt_orders.DataBind();
}
}
}
/// <summary>
/// 获取分页列表
/// </summary>
/// <param name="PageSize"></param>
/// <param name="PageIndex"></param>
/// <param name="RecordCount"></param>
/// <param name="serModel"></param>
/// <returns></returns>
public IList <Eyousoft_yhq.Model.Order> GetList(int PageSize, int PageIndex, ref int RecordCount, Eyousoft_yhq.Model.MSearchOrder serModel)
{
IList <Eyousoft_yhq.Model.Order> list = new List <Eyousoft_yhq.Model.Order>();
string tableName = "view_Order";
string fileds = " * ";
string orderByString = " IssueTime desc ";
StringBuilder query = new StringBuilder();
query.Append(" 1=1 ");
if (serModel != null)
{
if (!string.IsNullOrEmpty(serModel.MemberID))
{
query.AppendFormat(" and MemberID = '{0}' ", serModel.MemberID);
}
if (!string.IsNullOrEmpty(serModel.OrderCode))
{
query.AppendFormat(" and OrderCode like '%{0}%' ", serModel.OrderCode);
}
if (!string.IsNullOrEmpty(serModel.ConfirmCode))
{
query.AppendFormat(" and ConfirmCode like '%{0}%' ", serModel.ConfirmCode);
}
if (!string.IsNullOrEmpty(serModel.AppUserId))
{
query.AppendFormat(" and AppUserId = '{0}' ", serModel.AppUserId);
}
if (!string.IsNullOrEmpty(serModel.AppUser))
{
query.AppendFormat(" and AppUserName like '%{0}%' ", serModel.ConfirmCode);
}
if (serModel.OrderState.HasValue)
{
query.AppendFormat(" AND OrderState = '{0}' ", (int)serModel.OrderState.Value);
}
if (serModel.ConSumState.HasValue)
{
query.AppendFormat(" AND ConSumState = '{0}' ", (int)serModel.ConSumState.Value);
}
if (serModel.PaymentState.HasValue)
{
query.AppendFormat(" AND PayState = '{0}' ", (int)serModel.PaymentState.Value);
}
if (serModel.STime.HasValue)
{
query.AppendFormat(" AND IssueTime>='{0}' ", serModel.STime.Value);
}
if (serModel.ETime.HasValue)
{
query.AppendFormat(" AND IssueTime< '{0}' ", serModel.ETime.Value.AddDays(1));
}
if (serModel.XSTime.HasValue)
{
query.AppendFormat(" AND AppTime>='{0}' ", serModel.XSTime.Value);
}
if (serModel.XETime.HasValue)
{
query.AppendFormat(" AND AppTime< '{0}' ", serModel.XETime.Value.AddDays(1));
}
if (!string.IsNullOrEmpty(serModel.RouteName))
{
query.AppendFormat(" AND ProductName like '%{0}%' ", serModel.RouteName);
}
if (serModel.OrderPrice != 0)
{
query.AppendFormat(" AND OrderPrice = '{0}' ", serModel.OrderPrice);
}
if (!string.IsNullOrEmpty(serModel.PromotionCode))
{
query.AppendFormat(" and (PollCode = '{0}' OR PromotionCode= '{0}' )", serModel.PromotionCode);
}
if (serModel.jiesuan.HasValue)
{
query.AppendFormat(" AND JState = '{0}' ", (int)serModel.jiesuan.Value);
}
if (!string.IsNullOrEmpty(serModel.ChanPinFaBuRenId))
{
query.AppendFormat(" AND ChanPinFaBuRenId='{0}' ", serModel.ChanPinFaBuRenId);
}
}
using (IDataReader dr = DbHelper.ExecuteReader1(this._db, PageSize, PageIndex, ref RecordCount, tableName, fileds, query.ToString(), orderByString, null))
{
while (dr.Read())
{
Eyousoft_yhq.Model.Order model = new Eyousoft_yhq.Model.Order();
model.OrderID = dr.GetString(dr.GetOrdinal("OrderId"));
model.ProductID = dr.IsDBNull(dr.GetOrdinal("ProductID")) ? "" : dr.GetString(dr.GetOrdinal("ProductID"));
model.ProductName = dr.IsDBNull(dr.GetOrdinal("ProductName")) ? "" : dr.GetString(dr.GetOrdinal("ProductName"));
model.OrderCode = dr.GetString(dr.GetOrdinal("OrderCode"));
model.MemberID = dr.GetString(dr.GetOrdinal("MemberID"));
model.MemberName = dr.GetString(dr.GetOrdinal("MemberName"));
model.MemberTel = dr.IsDBNull(dr.GetOrdinal("MemberTel")) ? "" : dr.GetString(dr.GetOrdinal("MemberTel"));
model.MemberSex = (Eyousoft_yhq.Model.sexType)dr.GetByte(dr.GetOrdinal("MemberSex"));
model.OrderState = (Eyousoft_yhq.Model.OrderState)dr.GetByte(dr.GetOrdinal("OrderState"));
model.PayState = (Eyousoft_yhq.Model.PaymentState)dr.GetByte(dr.GetOrdinal("PayState"));
model.IsCheck = this.GetBoolean(dr.GetString(dr.GetOrdinal("ProductName")));
model.ConfirmCode = dr.IsDBNull(dr.GetOrdinal("ConfirmCode")) ? "" : dr.GetString(dr.GetOrdinal("ConfirmCode"));
model.Remark = dr.IsDBNull(dr.GetOrdinal("Remark")) ? "" : dr.GetString(dr.GetOrdinal("Remark"));
model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime"));
model.OrderPrice = dr.GetDecimal(dr.GetOrdinal("OrderPrice"));
model.TourDate = dr.IsDBNull(dr.GetOrdinal("TourDate")) ? null : Utils.GetDateTimeNullable(dr.GetDateTime(dr.GetOrdinal("TourDate")).ToString());
model.FavourCode = dr.GetString(dr.GetOrdinal("FavourCode"));
model.isEvery = this.GetBoolean(dr.GetString(dr.GetOrdinal("isEvery")));
model.ProductType = dr.GetInt32(dr.GetOrdinal("ProductType"));
model.ContractType = dr.IsDBNull(dr.GetOrdinal("ContractType")) ? Eyousoft_yhq.Model.ContractType.国内合同 : (Eyousoft_yhq.Model.ContractType)dr.GetByte(dr.GetOrdinal("ContractType")); model.OrderPrice = dr.GetDecimal(dr.GetOrdinal("OrderPrice"));
model.PeopleNum = dr.GetInt32(dr.GetOrdinal("PeopleNum"));
model.ContractText = dr.IsDBNull(dr.GetOrdinal("ContractText")) ? "" : dr.GetString(dr.GetOrdinal("ContractText"));
model.IsealCheck = GetBoolean(dr.GetString(dr.GetOrdinal("IsealCheck")));
model.FYJE = dr.IsDBNull(dr.GetOrdinal("fyje")) ? 0 : dr.GetDecimal(dr.GetOrdinal("fyje"));
model.SendFile = this.GetAttachList(dr["ComAttachXML"].ToString(), model.OrderID);
model.AddressID = dr.IsDBNull(dr.GetOrdinal("AddressID")) ? "" : dr.GetString(dr.GetOrdinal("AddressID"));
model.RebackMoney = dr.IsDBNull(dr.GetOrdinal("RebackMoney")) ? 0 : dr.GetDecimal(dr.GetOrdinal("RebackMoney"));
model.backMoney = dr.IsDBNull(dr.GetOrdinal("backMoney")) ? 0 : dr.GetDecimal(dr.GetOrdinal("backMoney"));
model.ProductOpState = (Eyousoft_yhq.Model.ProductOp)dr.GetByte(dr.GetOrdinal("ProductOpState"));
model.ZCodeViaDate = dr.IsDBNull(dr.GetOrdinal("ZCodeViaDate")) ? DateTime.Now : dr.GetDateTime(dr.GetOrdinal("ZCodeViaDate"));
model.XiaoFei = (Eyousoft_yhq.Model.XFstate)dr.GetByte(dr.GetOrdinal("ConSumState"));
model.AppTime = dr.IsDBNull(dr.GetOrdinal("AppTime")) ? DateTime.MinValue : dr.GetDateTime(dr.GetOrdinal("AppTime"));
model.AppUserName = dr.IsDBNull(dr.GetOrdinal("AppUserName")) ? string.Empty : dr.GetString(dr.GetOrdinal("AppUserName"));
model.JIESUAN = (Eyousoft_yhq.Model.JSfangshi)dr.GetByte(dr.GetOrdinal("JState"));
model.WeiDianName = dr["WeiDianName"].ToString();
list.Add(model);
}
};
return(list);
}
