//public static TicketInfoEntity CommonHotelGroupSelect(TicketInfoEntity ticketInfoEntity)
//{
// ticketInfoEntity.LogMessages.MsgType = MessageType.INFO;
// ticketInfoEntity.LogMessages.Content = _nameSpaceClass + "CommonHotelGroupSelect";
// LoggerHelper.LogWriter(ticketInfoEntity.LogMessages);
// try
// {
// return TicketInfoDA.CommonHotelGroupSelect(ticketInfoEntity);
// }
// catch (Exception ex)
// {
// ticketInfoEntity.LogMessages.MsgType = MessageType.ERROR;
// ticketInfoEntity.LogMessages.Content = _nameSpaceClass + "CommonHotelGroupSelect Error: " + ex.Message;
// LoggerHelper.LogWriter(ticketInfoEntity.LogMessages);
// throw ex;
// }
//}
public static TicketInfoEntity BindTicketInfoList(TicketInfoEntity ticketInfoEntity)
{
ticketInfoEntity.LogMessages.MsgType = MessageType.INFO;
ticketInfoEntity.LogMessages.Content = _nameSpaceClass + "BindTicketInfoList";
LoggerHelper.LogWriter(ticketInfoEntity.LogMessages);
try
{
return TicketInfoDA.BindTicketInfoList(ticketInfoEntity);
}
catch (Exception ex)
{
ticketInfoEntity.LogMessages.MsgType = MessageType.ERROR;
ticketInfoEntity.LogMessages.Content = _nameSpaceClass + "BindTicketInfoList Error: " + ex.Message;
LoggerHelper.LogWriter(ticketInfoEntity.LogMessages);
throw ex;
}
}
private void SetTicketTypeAreaData()
{
string packageName = ViewState["packagename"].ToString();//优惠券礼包名
string amountFrom = ViewState["amountfrom"].ToString();
string amountTo = ViewState["amountto"].ToString();
string pickFromDate = ViewState["pickfromdate"].ToString();
string pickToDate = ViewState["picktodate"].ToString();
string packagetype = ViewState["packagetype"].ToString();
string tickettime = ViewState["tickettime"].ToString();
TicketInfoEntity _ticketInfoEntity = new TicketInfoEntity();
_ticketInfoEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_ticketInfoEntity.LogMessages.Userid = UserSession.Current.UserAccount;
_ticketInfoEntity.LogMessages.Username = UserSession.Current.UserDspName;
_ticketInfoEntity.LogMessages.IpAddress = UserSession.Current.UserIP;
_ticketInfoEntity.TicketInfoDBEntity = new List<TicketInfoDBEntity>();
TicketInfoDBEntity ticketInfoDBEntity = new TicketInfoDBEntity();
ticketInfoDBEntity.PackageName = packageName;
ticketInfoDBEntity.AmountFrom = amountFrom;
ticketInfoDBEntity.AmountTo = amountTo;
ticketInfoDBEntity.Pickfromdate = pickFromDate;
ticketInfoDBEntity.Picktodate = pickToDate;
ticketInfoDBEntity.PackageType = packagetype;
ticketInfoDBEntity.TicketTime = tickettime;
_ticketInfoEntity.TicketInfoDBEntity.Add(ticketInfoDBEntity);
DataSet dsResult = TicketInfoBP.BindTicketInfoList(_ticketInfoEntity).QueryResult;
decimal decTpOperate = 0;
decimal decTpMarket = 0;
decimal decTpOther = 0;
decimal decAuOperate = 0;
decimal decAuMarket = 0;
decimal decAuOther = 0;
decimal decOuOperate = 0;
decimal decOuMarket = 0;
decimal decOuOther = 0;
if (dsResult.Tables.Count > 0)
{
#region 运营 优惠券
foreach (DataRow drpg in dsResult.Tables["ALLPG"].Rows)
{
if ("0".Equals(drpg["packagetype"].ToString().Trim()))
{
decTpOperate = decTpOperate + ConverDataDec(drpg["ALLPG"].ToString().Trim());
}
else if ("1".Equals(drpg["packagetype"].ToString().Trim()))
{
decTpMarket = decTpMarket + ConverDataDec(drpg["ALLPG"].ToString().Trim());
}
else
{
decTpOther = decTpOther + ConverDataDec(drpg["ALLPG"].ToString().Trim());
}
}
#endregion
#region 领取用户总数
foreach (DataRow drUr in dsResult.Tables["ALLUSER"].Rows)
{
if ("0".Equals(drUr["packagetype"].ToString().Trim()))
{
decAuOperate = decAuOperate + ConverDataDec(drUr["ALLUSER"].ToString().Trim());
}
else if ("1".Equals(drUr["packagetype"].ToString().Trim()))
{
decAuMarket = decAuMarket + ConverDataDec(drUr["ALLUSER"].ToString().Trim());
}
else
{
decAuOther = decAuOther + ConverDataDec(drUr["ALLUSER"].ToString().Trim());
}
}
#endregion
#region 使用用户总数
foreach (DataRow drOUr in dsResult.Tables["ORDUSER"].Rows)
{
if ("0".Equals(drOUr["packagetype"].ToString().Trim()))
{
decOuOperate = decOuOperate + ConverDataDec(drOUr["ORDUSER"].ToString().Trim());
}
else if ("1".Equals(drOUr["packagetype"].ToString().Trim()))
{
decOuMarket = decOuMarket + ConverDataDec(drOUr["ORDUSER"].ToString().Trim());
}
else
{
decOuOther = decOuOther + ConverDataDec(drOUr["ORDUSER"].ToString().Trim());
}
}
#endregion
// 运营
// 共有优惠券活动
lbTicketOperate.Text = decTpOperate.ToString();
// 共领用用户数
lbOperateAllUser.Text = decAuOperate.ToString();
// 共使用用户数
lbOperateUsed.Text = decOuOperate.ToString();
// 市场
// 共有优惠券活动
lbTickeMarket.Text = decTpMarket.ToString();
// 共领用用户数
lbMarketAllUser.Text = decAuMarket.ToString();
// 共使用用户数
lbMarketUsed.Text = decOuMarket.ToString();
// 其他
// 共有优惠券活动
lbTicketOther.Text = decTpOther.ToString();
// 共领用用户数
lbOtherAllUser.Text = decAuOther.ToString();
// 共使用用户数
lbOtherUsed.Text = decOuOther.ToString();
#region 优惠券订单总数
decimal decOrLm = 0;
decimal decOrLm2 = 0;
decimal decOrbarb = 0;
if (dsResult.Tables["ALLORD"].Rows.Count > 0)
{
DataRow[] drListOp = dsResult.Tables["ALLORD"].Select("packagetype='0'");
foreach (DataRow drOp in drListOp)
{
if ("lmbar".Equals(drOp["price_code"].ToString().Trim().ToLower()))
{
decOrLm = decOrLm + ConverDataDec(drOp["ALLORD"].ToString().Trim());
}
else if ("lmbar2".Equals(drOp["price_code"].ToString().Trim().ToLower()))
{
decOrLm2 = decOrLm2 + ConverDataDec(drOp["ALLORD"].ToString().Trim());
}
else
{
decOrbarb = decOrbarb + ConverDataDec(drOp["ALLORD"].ToString().Trim());
}
}
lbOperateLmOrder.Text = decOrLm.ToString();
lbOperateLm2Order.Text = decOrLm2.ToString();
lbOperateBarbOrder.Text = decOrbarb.ToString();
decOrLm = 0;
decOrLm2 = 0;
decOrbarb = 0;
DataRow[] drListMt = dsResult.Tables["ALLORD"].Select("packagetype='1'");
foreach (DataRow drMt in drListMt)
{
if ("lmbar".Equals(drMt["price_code"].ToString().Trim().ToLower()))
{
decOrLm = decOrLm + ConverDataDec(drMt["ALLORD"].ToString().Trim());
}
else if ("lmbar2".Equals(drMt["price_code"].ToString().Trim().ToLower()))
{
decOrLm2 = decOrLm2 + ConverDataDec(drMt["ALLORD"].ToString().Trim());
}
else
{
decOrbarb = decOrbarb + ConverDataDec(drMt["ALLORD"].ToString().Trim());
}
}
lbMarketLmOrder.Text = decOrLm.ToString();
lbMarketLm2Order.Text = decOrLm2.ToString();
lbMarketBarbOrder.Text = decOrbarb.ToString();
decOrLm = 0;
decOrLm2 = 0;
decOrbarb = 0;
DataRow[] drListOt = dsResult.Tables["ALLORD"].Select("packagetype='2'");
foreach (DataRow drOt in drListOt)
{
if ("lmbar".Equals(drOt["price_code"].ToString().Trim().ToLower()))
{
decOrLm = decOrLm + ConverDataDec(drOt["ALLORD"].ToString().Trim());
}
else if ("lmbar2".Equals(drOt["price_code"].ToString().Trim().ToLower()))
{
decOrLm2 = decOrLm2 + ConverDataDec(drOt["ALLORD"].ToString().Trim());
}
else
{
decOrbarb = decOrbarb + ConverDataDec(drOt["ALLORD"].ToString().Trim());
}
}
lbOtherLmOrder.Text = decOrLm.ToString();
lbOtherLm2Order.Text = decOrLm2.ToString();
lbOtherBarbOrder.Text = decOrbarb.ToString();
}
else
{
lbOperateLmOrder.Text = "0";
lbOperateLm2Order.Text = "0";
lbOperateBarbOrder.Text = "0";
lbMarketLmOrder.Text = "0";
lbMarketLm2Order.Text = "0";
lbMarketBarbOrder.Text = "0";
lbOtherLmOrder.Text = "0";
lbOtherLm2Order.Text = "0";
lbOtherBarbOrder.Text = "0";
}
#endregion
#region 优惠券成功订单总数
decimal decSuOrLm = 0;
decimal decSuOrLm2 = 0;
decimal decSuOrbarb = 0;
if (dsResult.Tables["SUCORD"].Rows.Count > 0)
{
DataRow[] drSuOp = dsResult.Tables["SUCORD"].Select("packagetype='0'");
foreach (DataRow drAOr in drSuOp)
{
if ("lmbar".Equals(drAOr["price_code"].ToString().Trim().ToLower()))
{
decSuOrLm = decSuOrLm + ConverDataDec(drAOr["SUCORD"].ToString().Trim());
}
else if ("lmbar2".Equals(drAOr["price_code"].ToString().Trim().ToLower()))
{
decSuOrLm2 = decSuOrLm2 + ConverDataDec(drAOr["SUCORD"].ToString().Trim());
}
else
{
decSuOrbarb = decSuOrbarb + ConverDataDec(drAOr["SUCORD"].ToString().Trim());
}
}
lbOperateLmSuOrder.Text = decSuOrLm.ToString();
lbOperateLm2SuOrder.Text = decSuOrLm2.ToString();
lbOperateBarbSuOrder.Text = decSuOrbarb.ToString();
decSuOrLm = 0;
decSuOrLm2 = 0;
decSuOrbarb = 0;
DataRow[] drSuOr = dsResult.Tables["SUCORD"].Select("packagetype='1'");
foreach (DataRow drAOr in drSuOr)
{
if ("lmbar".Equals(drAOr["price_code"].ToString().Trim().ToLower()))
{
decSuOrLm = decSuOrLm + ConverDataDec(drAOr["SUCORD"].ToString().Trim());
}
else if ("lmbar2".Equals(drAOr["price_code"].ToString().Trim().ToLower()))
{
decSuOrLm2 = decSuOrLm2 + ConverDataDec(drAOr["SUCORD"].ToString().Trim());
}
else
{
decSuOrbarb = decSuOrbarb + ConverDataDec(drAOr["SUCORD"].ToString().Trim());
}
}
lbMarketLmSuOrder.Text = decSuOrLm.ToString();
lbMarketLm2SuOrder.Text = decSuOrLm2.ToString();
lbMarketBarbSuOrder.Text = decSuOrbarb.ToString();
decSuOrLm = 0;
decSuOrLm2 = 0;
decSuOrbarb = 0;
DataRow[] drSuOt = dsResult.Tables["SUCORD"].Select("packagetype='2'");
foreach (DataRow drAOr in drSuOt)
{
if ("lmbar".Equals(drAOr["price_code"].ToString().Trim().ToLower()))
{
decSuOrLm = decSuOrLm + ConverDataDec(drAOr["SUCORD"].ToString().Trim());
}
else if ("lmbar2".Equals(drAOr["price_code"].ToString().Trim().ToLower()))
{
decSuOrLm2 = decSuOrLm2 + ConverDataDec(drAOr["SUCORD"].ToString().Trim());
}
else
{
decSuOrbarb = decSuOrbarb + ConverDataDec(drAOr["SUCORD"].ToString().Trim());
}
}
lbOtherLmSuOrder.Text = decSuOrLm.ToString();
lbOtherLm2SuOrder.Text = decSuOrLm2.ToString();
lbOtherBarbSuOrder.Text = decSuOrbarb.ToString();
}
else
{
lbOperateLmSuOrder.Text = "0";
lbOperateLm2SuOrder.Text = "0";
lbOperateBarbSuOrder.Text = "0";
lbMarketLmSuOrder.Text = "0";
lbMarketLm2SuOrder.Text = "0";
lbMarketBarbSuOrder.Text = "0";
lbOtherLmSuOrder.Text = "0";
lbOtherLm2SuOrder.Text = "0";
lbOtherBarbSuOrder.Text = "0";
}
#endregion
}
else
{
lbTicketOperate.Text = "0";
lbOperateAllUser.Text = "0";
lbOperateUsed.Text = "0";
lbOperateLmOrder.Text = "0";
lbOperateLm2Order.Text = "0";
lbOperateBarbOrder.Text = "0";
lbOperateLmSuOrder.Text = "0";
lbOperateLm2SuOrder.Text = "0";
lbOperateBarbSuOrder.Text = "0";
lbTickeMarket.Text = "0";
lbMarketAllUser.Text = "0";
lbMarketUsed.Text = "0";
lbMarketLmOrder.Text = "0";
lbMarketLm2Order.Text = "0";
lbMarketBarbOrder.Text = "0";
lbMarketLmSuOrder.Text = "0";
lbMarketLm2SuOrder.Text = "0";
lbMarketBarbSuOrder.Text = "0";
lbTicketOther.Text = "0";
lbOtherAllUser.Text = "0";
lbOtherUsed.Text = "0";
lbOtherLmOrder.Text = "0";
lbOtherLm2Order.Text = "0";
lbOtherBarbOrder.Text = "0";
lbOtherLmSuOrder.Text = "0";
lbOtherLm2SuOrder.Text = "0";
lbOtherBarbSuOrder.Text = "0";
}
// 运营
// 共有优惠券活动
//lbTicketOperate.Text = decTpOperate.ToString();
// 共领用用户数
//lbOperateAllUser.Text = decAuOperate.ToString();
// 共使用用户数
//lbOperateUsed.Text = decOuOperate.ToString();
//// 总产生订单
//lbOperateLmOrder.Text = "";
//lbOperateLm2Order.Text = "";
//lbOperateBarbOrder.Text = "";
//// 总产生成功订单
//lbOperateLmSuOrder.Text = "";
//lbOperateLm2SuOrder.Text = "";
//lbOperateBarbSuOrder.Text = "";
// 市场
// 共有优惠券活动
//lbTickeMarket.Text = decTpMarket.ToString();
//// 共领用用户数
//lbMarketAllUser.Text = decAuMarket.ToString();
//// 共使用用户数
//lbMarketUsed.Text = decOuMarket.ToString();
//// 总产生订单
//lbMarketLmOrder.Text = "";
//lbMarketLm2Order.Text = "";
//lbMarketBarbOrder.Text = "";
//// 总产生成功订单
//lbMarketLmSuOrder.Text = "";
//lbMarketLm2SuOrder.Text = "";
//lbMarketBarbSuOrder.Text = "";
// 其他
// 共有优惠券活动
//lbTicketOther.Text = decTpOther.ToString();
//// 共领用用户数
//lbOtherAllUser.Text = decAuOther.ToString();
//// 共使用用户数
//lbOtherUsed.Text = decOuOther.ToString();
// 总产生订单
//lbOtherLmOrder.Text = "";
//lbOtherLm2Order.Text = "";
//lbOtherBarbOrder.Text = "";
//// 总产生成功订单
//lbOtherLmSuOrder.Text = "";
//lbOtherLm2SuOrder.Text = "";
//lbOtherBarbSuOrder.Text = "";
}
//public static TicketInfoEntity CommonHotelGroupSelect(TicketInfoEntity ticketInfoEntity)
//{
// ticketInfoEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("TicketInfo", "t_lm_b_common_hotelgrouplist", false);
// return ticketInfoEntity;
//}
public static TicketInfoEntity BindTicketInfoList(TicketInfoEntity ticketInfoEntity)
{
OracleParameter[] parm ={
new OracleParameter("PACKAGENAME",OracleType.VarChar),
new OracleParameter("AMOUNTFROM",OracleType.Int32),
new OracleParameter("AMOUNTTO",OracleType.Int32),
new OracleParameter("STARTDATE",OracleType.VarChar),
new OracleParameter("ENDDATE",OracleType.VarChar),
new OracleParameter("PACKAGETYPE",OracleType.VarChar),
new OracleParameter("TICKETDT",OracleType.VarChar)
};
TicketInfoDBEntity dbParm = (ticketInfoEntity.TicketInfoDBEntity.Count > 0) ? ticketInfoEntity.TicketInfoDBEntity[0] : new TicketInfoDBEntity();
if (String.IsNullOrEmpty(dbParm.PackageName))
{
parm[0].Value = DBNull.Value;
}
else
{
parm[0].Value = dbParm.PackageName;
}
if (String.IsNullOrEmpty(dbParm.AmountFrom))
{
parm[1].Value = DBNull.Value;
}
else
{
parm[1].Value = dbParm.AmountFrom;
}
if (String.IsNullOrEmpty(dbParm.AmountTo))
{
parm[2].Value = DBNull.Value;
}
else
{
parm[2].Value = dbParm.AmountTo;
}
if (String.IsNullOrEmpty(dbParm.Pickfromdate))
{
parm[3].Value = DBNull.Value;
}
else
{
parm[3].Value = dbParm.Pickfromdate;
}
if (String.IsNullOrEmpty(dbParm.Picktodate))
{
parm[4].Value = DBNull.Value;
}
else
{
parm[4].Value = dbParm.Picktodate;
}
if (String.IsNullOrEmpty(dbParm.PackageType))
{
parm[5].Value = DBNull.Value;
}
else
{
parm[5].Value = dbParm.PackageType;
}
if (String.IsNullOrEmpty(dbParm.TicketTime))
{
parm[6].Value = DBNull.Value;
}
else
{
parm[6].Value = dbParm.TicketTime;
}
//已过领用期 0 > 领用最大时间
//已过使用期 1 > 使用最大时间
//当前可领用 2 领用开始 < 当前时间 < 领用结束
//当前可使用 3 使用开始 < 当前时间 < 使用结束
DataSet dsResult = new DataSet();
DataTable dtAllPg = new DataTable();
dtAllPg = DbManager.Query("Ticket", "t_lm_ticket_all_type", true, parm).Tables[0].Copy();
dtAllPg.TableName = "ALLPG";
DataTable dtAllUser = new DataTable();
dtAllUser = DbManager.Query("Ticket", "t_lm_ticket_all_user", true, parm).Tables[0].Copy();
dtAllUser.TableName = "ALLUSER";
DataTable dtOrdUser = new DataTable();
dtOrdUser = DbManager.Query("Ticket", "t_lm_ticket_ord_user", true, parm).Tables[0].Copy();
dtOrdUser.TableName = "ORDUSER";
DataTable dtAllOrd = new DataTable();
dtAllOrd = DbManager.Query("Ticket", "t_lm_ticket_all_ord", true, parm).Tables[0].Copy();
dtAllOrd.TableName = "ALLORD";
DataTable dtSucOrd = new DataTable();
dtSucOrd = DbManager.Query("Ticket", "t_lm_ticket_suc_ord", true, parm).Tables[0].Copy();
dtSucOrd.TableName = "SUCORD";
dsResult.Tables.Add(dtAllPg);
dsResult.Tables.Add(dtAllUser);
dsResult.Tables.Add(dtOrdUser);
dsResult.Tables.Add(dtAllOrd);
dsResult.Tables.Add(dtSucOrd);
ticketInfoEntity.QueryResult = dsResult;
return ticketInfoEntity;
}