public static MasterInfoEntity CommonSelectTodayLoginUserNew(MasterInfoEntity masterInfoEntity)
{
masterInfoEntity.LogMessages.MsgType = MessageType.INFO;
masterInfoEntity.LogMessages.Content = _nameSpaceClass + "CommonSelectTodayLoginUserNew";
LoggerHelper.LogWriter(masterInfoEntity.LogMessages);
try
{
return MasterInfoDA.CommonSelectTodayLoginUserNew(masterInfoEntity);
}
catch (Exception ex)
{
masterInfoEntity.LogMessages.MsgType = MessageType.ERROR;
masterInfoEntity.LogMessages.Content = _nameSpaceClass + "CommonSelectTodayLoginUserNew Error: " + ex.Message;
LoggerHelper.LogWriter(masterInfoEntity.LogMessages);
throw ex;
}
}
public void BindUser(string StartDate, string EndDate)
{
#region
MasterInfoEntity _masterInfoEntity = new MasterInfoEntity();
CommonEntity _commonEntity = new CommonEntity();
_masterInfoEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_masterInfoEntity.LogMessages.Userid = UserSession.Current.UserAccount;
_masterInfoEntity.LogMessages.Username = UserSession.Current.UserDspName;
_masterInfoEntity.LogMessages.IpAddress = UserSession.Current.UserIP;
_masterInfoEntity.MasterInfoDBEntity = new List<MasterInfoDBEntity>();
MasterInfoDBEntity msterInfoDBEntity = new MasterInfoDBEntity();
_masterInfoEntity.MasterInfoDBEntity.Add(msterInfoDBEntity);
msterInfoDBEntity.RegistStart = StartDate;
msterInfoDBEntity.RegistEnd = EndDate;
DataSet dsDetailResult = MasterInfoBP.CommonSelectUser(_masterInfoEntity).QueryResult;
if (dsDetailResult.Tables["UserCount"].Rows.Count > 0)
{
//if ("0".Equals(strToDay))
//{
// lbUserTitle.Text = "昨日用户简报";
// lbYesterDate.Text = "昨日（" + dsDetailResult.Tables["UserCount"].Rows[0]["YESTERDATE"].ToString() + "）";
//}
//else
//{
// lbUserTitle.Text = "今日用户简报";
// lbYesterDate.Text = "今日（" + dsDetailResult.Tables["UserCount"].Rows[0]["YESTERDATE"].ToString() + "）";
//}
lbUserTitle.Text = "用户简报";
lbYesterDate.Text = dsDetailResult.Tables["UserCount"].Rows[0]["StartDate"].ToString() + "--" + dsDetailResult.Tables["UserCount"].Rows[0]["EndDate"].ToString();
decimal decUserAll = 0;
decimal decIOSUR = 0;
decimal decANDUR = 0;
decimal decWAPUR = 0;
decimal decWP7UR = 0;
decimal decW8UR = 0;
decimal decOther = 0;
foreach (DataRow drRow in dsDetailResult.Tables["UserCount"].Rows)
{
decUserAll = decUserAll + ((String.IsNullOrEmpty(drRow["COLVALUE"].ToString())) ? 0 : decimal.Parse(drRow["COLVALUE"].ToString()));
switch (drRow["COLNMS"].ToString().ToLower())
{
case "ios":
decIOSUR = decIOSUR + ((String.IsNullOrEmpty(drRow["COLVALUE"].ToString())) ? 0 : decimal.Parse(drRow["COLVALUE"].ToString()));
break;
case "lm_ios":
decIOSUR = decIOSUR + ((String.IsNullOrEmpty(drRow["COLVALUE"].ToString())) ? 0 : decimal.Parse(drRow["COLVALUE"].ToString()));
break;
case "lm_android":
decANDUR = decANDUR + ((String.IsNullOrEmpty(drRow["COLVALUE"].ToString())) ? 0 : decimal.Parse(drRow["COLVALUE"].ToString()));
break;
case "android":
decANDUR = decANDUR + ((String.IsNullOrEmpty(drRow["COLVALUE"].ToString())) ? 0 : decimal.Parse(drRow["COLVALUE"].ToString()));
break;
case "wap":
decWAPUR = decWAPUR + ((String.IsNullOrEmpty(drRow["COLVALUE"].ToString())) ? 0 : decimal.Parse(drRow["COLVALUE"].ToString()));
break;
case "wp":
decWP7UR = decWP7UR + ((String.IsNullOrEmpty(drRow["COLVALUE"].ToString())) ? 0 : decimal.Parse(drRow["COLVALUE"].ToString()));
break;
case "w8":
decW8UR = decW8UR + ((String.IsNullOrEmpty(drRow["COLVALUE"].ToString())) ? 0 : decimal.Parse(drRow["COLVALUE"].ToString()));
break;
default:
decOther = decOther + ((String.IsNullOrEmpty(drRow["COLVALUE"].ToString())) ? 0 : decimal.Parse(drRow["COLVALUE"].ToString()));
break;
}
}
lbUserAll.Text = decUserAll.ToString("#,##0");
lbIOSUR.Text = decIOSUR.ToString("#,##0");
lbANDUR.Text = decANDUR.ToString("#,##0");
lbWAPUR.Text = decWAPUR.ToString("#,##0");
lbWP7.Text = decWP7UR.ToString("#,##0");
lbW8.Text = decW8UR.ToString("#,##0");
lbOther.Text = decOther.ToString("#,##0");
}
else
{
//if ("0".Equals(strToDay))
//{
// lbUserTitle.Text = "昨日用户简报";
// lbYesterDate.Text = "昨日（）";
//}
//else
//{
// lbUserTitle.Text = "今日用户简报";
// lbYesterDate.Text = "今日（）";
//}
lbUserTitle.Text = "用户简报";
lbYesterDate.Text = "";
lbUserAll.Text = "0";
lbIOSUR.Text = "0";
lbANDUR.Text = "0";
lbWAPUR.Text = "0";
lbWP7.Text = "0";
lbW8.Text = "0";
lbOther.Text = "0";
}
#endregion
BindUserNew(StartDate, EndDate);
}
private void BindViewCSUserListDetail(string strToDay)
{
MasterInfoEntity _masterInfoEntity = new MasterInfoEntity();
CommonEntity _commonEntity = new CommonEntity();
_masterInfoEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_masterInfoEntity.LogMessages.Userid = UserSession.Current.UserAccount;
_masterInfoEntity.LogMessages.Username = UserSession.Current.UserDspName;
_masterInfoEntity.LogMessages.IpAddress = UserSession.Current.UserIP;
_masterInfoEntity.MasterInfoDBEntity = new List<MasterInfoDBEntity>();
MasterInfoDBEntity msterInfoDBEntity = new MasterInfoDBEntity();
_masterInfoEntity.MasterInfoDBEntity.Add(msterInfoDBEntity);
msterInfoDBEntity.Today = strToDay;
//DataSet dsDetailResult = MasterInfoBP.CommonSelect(_masterInfoEntity).QueryResult;
//以下代码 注释
//lbYesterDate2.Text = "";
//lbYesterDate.Text = "";
//lbTitle.Text = "昨日订单简报";
//以下代码 注释
#region
//if (dsDetailResult.Tables.Count > 0)
//{
// if (dsDetailResult.Tables["OrderAll"].Rows.Count > 0)
// {
// decimal decOrderInAll = String.IsNullOrEmpty(dsDetailResult.Tables["OrderAll"].Rows[0][0].ToString().Trim()) ? 0 : decimal.Parse(dsDetailResult.Tables["OrderAll"].Rows[0][0].ToString().Trim());
// lbOrderInAll.Text = decOrderInAll.ToString("#,##0");
// }
// else
// {
// lbOrderInAll.Text = "0";
// }
// if (dsDetailResult.Tables["AllTic"].Rows.Count > 0)
// {
// decimal decSUTicket = String.IsNullOrEmpty(dsDetailResult.Tables["AllTic"].Rows[0]["SUTicket"].ToString().Trim()) ? 0 : decimal.Parse(dsDetailResult.Tables["AllTic"].Rows[0]["SUTicket"].ToString().Trim());
// decimal decALTicket = String.IsNullOrEmpty(dsDetailResult.Tables["AllTic"].Rows[0]["ALTicket"].ToString().Trim()) ? 0 : decimal.Parse(dsDetailResult.Tables["AllTic"].Rows[0]["ALTicket"].ToString().Trim());
// lbSUTicket.Text = (decSUTicket > 0 ) ? " (" + decSUTicket.ToString("#,##0") + ")" : "";
// lbALTicket.Text = (decALTicket > 0 ) ? " (" + decALTicket.ToString("#,##0") + ")" : "";
// }
// else
// {
// lbSUTicket.Text = "";
// lbALTicket.Text = "";
// }
// if (dsDetailResult.Tables["OrderTic"].Rows.Count > 0)
// {
// string ticpricecode = string.Empty;
// string ticcolvalue = string.Empty;
// decimal decYFTicAll = 0;
// decimal decXFTicAll = 0;
// decimal decCXFTicAll = 0;
// foreach (DataRow drRow in dsDetailResult.Tables["OrderTic"].Rows)
// {
// ticpricecode = drRow["PRICECODE"].ToString().Trim().ToLower();
// ticcolvalue = drRow["COLVALUE"].ToString().Trim();
// if ("lmbar".Equals(ticpricecode))
// {
// decYFTicAll = decYFTicAll + (String.IsNullOrEmpty(ticcolvalue) ? 0 : decimal.Parse(ticcolvalue));
// }
// else if ("lmbar2".Equals(ticpricecode))
// {
// decXFTicAll = decXFTicAll + (String.IsNullOrEmpty(ticcolvalue) ? 0 : decimal.Parse(ticcolvalue));
// }
// else if ("barb".Equals(ticpricecode) || "bar".Equals(ticpricecode))
// {
// decCXFTicAll = decCXFTicAll + (String.IsNullOrEmpty(ticcolvalue) ? 0 : decimal.Parse(ticcolvalue));
// }
// }
// lbYFTicAll.Text = (decYFTicAll > 0) ? " (" + decYFTicAll.ToString("#,##0") + ")" : "";
// lbXFTicAll.Text = (decXFTicAll > 0) ? " (" + decXFTicAll.ToString("#,##0") + ")" : "";
// lbCXFTicAll.Text = (decCXFTicAll > 0) ? " (" + decCXFTicAll.ToString("#,##0") + ")" : "";
// }
// else
// {
// lbYFTicAll.Text = "";
// lbXFTicAll.Text = "";
// lbCXFTicAll.Text = "";
// }
// if (dsDetailResult.Tables["RoomTic"].Rows.Count > 0)
// {
// decimal decRoomTicAll = String.IsNullOrEmpty(dsDetailResult.Tables["RoomTic"].Rows[0]["COLVALUE"].ToString().Trim()) ? 0 : decimal.Parse(dsDetailResult.Tables["RoomTic"].Rows[0]["COLVALUE"].ToString().Trim());
// lbRoomTicAll.Text = (decRoomTicAll > 0) ? " (" + decRoomTicAll.ToString("#,##0") + ")" : "";
// }
// else
// {
// lbRoomTicAll.Text = "";
// }
// #region
// decimal decOrderSum = 0;
// if (dsDetailResult.Tables["OrderSum"].Rows.Count > 0)
// {
// if ("0".Equals(strToDay))
// {
// lbTitle.Text = "昨日订单简报";
// lbYesterDate2.Text = "昨日（" + dsDetailResult.Tables["OrderSum"].Rows[0]["YESTERDATE2"].ToString() + "）";
// hidDate.Value = dsDetailResult.Tables["OrderSum"].Rows[0]["YESTERDATE2"].ToString();
// hidDateType.Value = "0";
// }
// else
// {
// lbTitle.Text = "今日订单简报";
// lbYesterDate2.Text = "今日（" + dsDetailResult.Tables["OrderSum"].Rows[0]["YESTERDATE2"].ToString() + "）";
// hidDate.Value = dsDetailResult.Tables["OrderSum"].Rows[0]["YESTERDATE2"].ToString();
// hidDateType.Value = "1";
// }
// //lbOrderAll.Text = (String.IsNullOrEmpty(dsDetailResult.Tables["OrderSum"].Rows[0]["SUMPRICE"].ToString())) ? "0" : decimal.Parse(dsDetailResult.Tables["OrderSum"].Rows[0]["SUMPRICE"].ToString()).ToString("#,##0");
// decOrderSum = (String.IsNullOrEmpty(dsDetailResult.Tables["OrderSum"].Rows[0]["SUMPRICE"].ToString())) ? 0 : decimal.Parse(dsDetailResult.Tables["OrderSum"].Rows[0]["SUMPRICE"].ToString());
// }
// else
// {
// if ("0".Equals(strToDay))
// {
// lbTitle.Text = "昨日订单简报";
// lbYesterDate2.Text = "昨日（）";
// }
// else
// {
// lbTitle.Text = "今日订单简报";
// lbYesterDate2.Text = "今日（）";
// }
// lbOrderAll.Text = "0";
// lbUnvOrderPr.Text = "0";
// }
// #endregion
// decimal decOrderAll = 0;
// decimal decYFOrderIOS = 0;
// decimal decYFOrderAND = 0;
// decimal decYFOrderWAP = 0;
// decimal decYFOrderWP7 = 0;
// decimal decYFOrderHTK = 0;
// decimal decYFOrderQER = 0;
// decimal decXFOrderIOS = 0;
// decimal decXFOrderAND = 0;
// decimal decXFOrderWAP = 0;
// decimal decXFOrderWP7 = 0;
// decimal decXFOrderHTK = 0;
// decimal decXFOrderQER = 0;
// decimal decCXFOrderIOS = 0;
// decimal decCXFOrderAND = 0;
// decimal decCXFOrderWAP = 0;
// decimal decCXFOrderWP7 = 0;
// decimal decCXFOrderHTK = 0;
// decimal decCXFOrderQER = 0;
// #region
// if (dsDetailResult.Tables["OrderList"].Rows.Count > 0)
// {
// string pricecode = "";
// string booksource = "";
// string colvalue = "";
// foreach (DataRow drRow in dsDetailResult.Tables["OrderList"].Rows)
// {
// pricecode = drRow["PRICECODE"].ToString().Trim().ToLower();
// booksource = drRow["BOOKSOURCE"].ToString().Trim().ToLower();
// colvalue = drRow["COLVALUE"].ToString().Trim().ToLower();
// if ("lmbar".Equals(pricecode))
// {
// if ("lm_ios".Equals(booksource) || "ios".Equals(booksource))
// {
// decYFOrderIOS = decYFOrderIOS + (String.IsNullOrEmpty(colvalue) ? 0 : decimal.Parse(colvalue));
// }
// else if ("lm_android".Equals(booksource) || "android".Equals(booksource))
// {
// decYFOrderAND = decYFOrderAND + (String.IsNullOrEmpty(colvalue) ? 0 : decimal.Parse(colvalue));
// }
// else if ("lm_web".Equals(booksource) || "lm_116114web".Equals(booksource))
// {
// decYFOrderWAP = decYFOrderWAP + (String.IsNullOrEmpty(colvalue) ? 0 : decimal.Parse(colvalue));
// }
// else if ("wp".Equals(booksource))
// {
// decYFOrderWP7 = decYFOrderWP7 + (String.IsNullOrEmpty(colvalue) ? 0 : decimal.Parse(colvalue));
// }
// else if ("htk".Equals(booksource))
// {
// decYFOrderHTK = decYFOrderHTK + (String.IsNullOrEmpty(colvalue) ? 0 : decimal.Parse(colvalue));
// }
// else if ("qunar".Equals(booksource))
// {
// decYFOrderQER = decYFOrderQER + (String.IsNullOrEmpty(colvalue) ? 0 : decimal.Parse(colvalue));
// }
// }
// else if ("lmbar2".Equals(pricecode))
// {
// if ("lm_ios".Equals(booksource) || "ios".Equals(booksource))
// {
// decXFOrderIOS = decXFOrderIOS + (String.IsNullOrEmpty(colvalue) ? 0 : decimal.Parse(colvalue));
// }
// else if ("lm_android".Equals(booksource) || "android".Equals(booksource))
// {
// decXFOrderAND = decXFOrderAND + (String.IsNullOrEmpty(colvalue) ? 0 : decimal.Parse(colvalue));
// }
// else if ("lm_web".Equals(booksource) || "lm_116114web".Equals(booksource))
// {
// decXFOrderWAP = decXFOrderWAP + (String.IsNullOrEmpty(colvalue) ? 0 : decimal.Parse(colvalue));
// }
// else if ("wp".Equals(booksource))
// {
// decXFOrderWP7 = decXFOrderWP7 + (String.IsNullOrEmpty(colvalue) ? 0 : decimal.Parse(colvalue));
// }
// else if ("htk".Equals(booksource))
// {
// decXFOrderHTK = decXFOrderHTK + (String.IsNullOrEmpty(colvalue) ? 0 : decimal.Parse(colvalue));
// }
// else if ("qunar".Equals(booksource))
// {
// decXFOrderQER = decXFOrderQER + (String.IsNullOrEmpty(colvalue) ? 0 : decimal.Parse(colvalue));
// }
// }
// else if ("barb".Equals(pricecode) || "bar".Equals(pricecode))
// {
// if ("lm_ios".Equals(booksource) || "ios".Equals(booksource))
// {
// decCXFOrderIOS = decCXFOrderIOS + (String.IsNullOrEmpty(colvalue) ? 0 : decimal.Parse(colvalue));
// }
// else if ("lm_android".Equals(booksource) || "android".Equals(booksource))
// {
// decCXFOrderAND = decCXFOrderAND + (String.IsNullOrEmpty(colvalue) ? 0 : decimal.Parse(colvalue));
// }
// else if ("lm_web".Equals(booksource) || "lm_116114web".Equals(booksource))
// {
// decCXFOrderWAP = decCXFOrderWAP + (String.IsNullOrEmpty(colvalue) ? 0 : decimal.Parse(colvalue));
// }
// else if ("wp".Equals(booksource))
// {
// decCXFOrderWP7 = decCXFOrderWP7 + (String.IsNullOrEmpty(colvalue) ? 0 : decimal.Parse(colvalue));
// }
// else if ("htk".Equals(booksource))
// {
// decCXFOrderHTK = decCXFOrderHTK + (String.IsNullOrEmpty(colvalue) ? 0 : decimal.Parse(colvalue));
// }
// else if ("qunar".Equals(booksource))
// {
// decCXFOrderQER = decCXFOrderQER + (String.IsNullOrEmpty(colvalue) ? 0 : decimal.Parse(colvalue));
// }
// }
// }
// lbYFOrderAll.Text = (decYFOrderIOS + decYFOrderAND + decYFOrderWAP + decYFOrderWP7 + decYFOrderHTK + decYFOrderQER).ToString("#,##0");
// lbYFOrderIOS.Text = decYFOrderIOS.ToString("#,##0");
// lbYFOrderAND.Text = decYFOrderAND.ToString("#,##0");
// lbYFOrderWAP.Text = decYFOrderWAP.ToString("#,##0");
// lbYFOrderWP7.Text = decYFOrderWP7.ToString("#,##0");
// lbYFOrderHTK.Text = decYFOrderHTK.ToString("#,##0");
// lbYFOrderQER.Text = decYFOrderQER.ToString("#,##0");
// lbXFOrderAll.Text = (decXFOrderIOS + decXFOrderAND + decXFOrderWAP + decXFOrderWP7 + decXFOrderHTK + decXFOrderQER).ToString("#,##0");
// lbXFOrderIOS.Text = decXFOrderIOS.ToString("#,##0");
// lbXFOrderAND.Text = decXFOrderAND.ToString("#,##0");
// lbXFOrderWAP.Text = decXFOrderWAP.ToString("#,##0");
// lbXFOrderWP7.Text = decXFOrderWP7.ToString("#,##0");
// lbXFOrderHTK.Text = decXFOrderHTK.ToString("#,##0");
// lbXFOrderQER.Text = decXFOrderQER.ToString("#,##0");
// lbCXFOrderAll.Text = (decCXFOrderIOS + decCXFOrderAND + decCXFOrderWAP + decCXFOrderWP7 + decCXFOrderHTK + decCXFOrderQER).ToString("#,##0");
// lbCXFOrderIOS.Text = decCXFOrderIOS.ToString("#,##0");
// lbCXFOrderAND.Text = decCXFOrderAND.ToString("#,##0");
// lbCXFOrderWAP.Text = decCXFOrderWAP.ToString("#,##0");
// lbCXFOrderWP7.Text = decCXFOrderWP7.ToString("#,##0");
// lbCXFOrderHTK.Text = decCXFOrderHTK.ToString("#,##0");
// lbCXFOrderQER.Text = decCXFOrderQER.ToString("#,##0");
// }
// else
// {
// lbYFOrderAll.Text = "0";
// lbYFOrderIOS.Text = "0";
// lbYFOrderAND.Text = "0";
// lbYFOrderWAP.Text = "0";
// lbYFOrderWP7.Text = "0";
// lbYFOrderHTK.Text = "0";
// lbYFOrderQER.Text = "0";
// lbXFOrderAll.Text = "0";
// lbXFOrderIOS.Text = "0";
// lbXFOrderAND.Text = "0";
// lbXFOrderWAP.Text = "0";
// lbXFOrderWP7.Text = "0";
// lbXFOrderHTK.Text = "0";
// lbXFOrderQER.Text = "0";
// lbCXFOrderAll.Text = "0";
// lbCXFOrderIOS.Text = "0";
// lbCXFOrderAND.Text = "0";
// lbCXFOrderWAP.Text = "0";
// lbCXFOrderWP7.Text = "0";
// lbCXFOrderHTK.Text = "0";
// lbCXFOrderQER.Text = "0";
// }
// #endregion
// SetChartPic();
// decOrderAll = decYFOrderIOS + decYFOrderAND + decYFOrderWAP + decYFOrderWP7 + decYFOrderHTK + decYFOrderQER + decXFOrderIOS + decXFOrderAND + decXFOrderWAP + decXFOrderWP7 + decXFOrderHTK + decXFOrderQER + decCXFOrderIOS + decCXFOrderAND + decCXFOrderWAP + decCXFOrderWP7 + decCXFOrderHTK + decCXFOrderQER;
// if (decOrderAll == 0)
// {
// lbOrderAll.Text = "0";
// lbUnvOrderPr.Text = "0";
// }
// else
// {
// lbOrderAll.Text = decOrderAll.ToString("#,##0");
// lbUnvOrderPr.Text = (decOrderSum / decOrderAll).ToString("#,###.##");
// }
// #region
// if (dsDetailResult.Tables["UserCount"].Rows.Count > 0)
// {
// if ("0".Equals(strToDay))
// {
// lbUserTitle.Text = "昨日用户简报";
// //lbYesterDate2.Text = "昨日（）";
// lbYesterDate.Text = "昨日（" + dsDetailResult.Tables["UserCount"].Rows[0]["YESTERDATE"].ToString() + "）";
// }
// else
// {
// lbUserTitle.Text = "今日用户简报";
// //lbYesterDate2.Text = "昨日（）";
// lbYesterDate.Text = "今日（" + dsDetailResult.Tables["UserCount"].Rows[0]["YESTERDATE"].ToString() + "）";
// }
// decimal decUserAll = 0;
// decimal decIOSUR = 0;
// decimal decANDUR = 0;
// decimal decWAPUR = 0;
// decimal decWP7UR = 0;
// decimal decOther = 0;
// foreach (DataRow drRow in dsDetailResult.Tables["UserCount"].Rows)
// {
// decUserAll = decUserAll + ((String.IsNullOrEmpty(drRow["COLVALUE"].ToString())) ? 0 : decimal.Parse(drRow["COLVALUE"].ToString()));
// switch (drRow["COLNMS"].ToString().ToLower())
// {
// case "ios":
// decIOSUR = decIOSUR + ((String.IsNullOrEmpty(drRow["COLVALUE"].ToString())) ? 0 : decimal.Parse(drRow["COLVALUE"].ToString()));
// break;
// case "lm_ios":
// decIOSUR = decIOSUR + ((String.IsNullOrEmpty(drRow["COLVALUE"].ToString())) ? 0 : decimal.Parse(drRow["COLVALUE"].ToString()));
// break;
// case "lm_android":
// decANDUR = decANDUR + ((String.IsNullOrEmpty(drRow["COLVALUE"].ToString())) ? 0 : decimal.Parse(drRow["COLVALUE"].ToString()));
// break;
// case "android":
// decANDUR = decANDUR + ((String.IsNullOrEmpty(drRow["COLVALUE"].ToString())) ? 0 : decimal.Parse(drRow["COLVALUE"].ToString()));
// break;
// case "wap":
// decWAPUR = decWAPUR + ((String.IsNullOrEmpty(drRow["COLVALUE"].ToString())) ? 0 : decimal.Parse(drRow["COLVALUE"].ToString()));
// break;
// case "wp":
// decWP7UR = decWP7UR + ((String.IsNullOrEmpty(drRow["COLVALUE"].ToString())) ? 0 : decimal.Parse(drRow["COLVALUE"].ToString()));
// break;
// default:
// decOther = decOther + ((String.IsNullOrEmpty(drRow["COLVALUE"].ToString())) ? 0 : decimal.Parse(drRow["COLVALUE"].ToString()));
// break;
// }
// }
// lbUserAll.Text = decUserAll.ToString("#,##0");
// lbIOSUR.Text = decIOSUR.ToString("#,##0");
// lbANDUR.Text = decANDUR.ToString("#,##0");
// lbWAPUR.Text = decWAPUR.ToString("#,##0");
// lbWP7.Text = decWP7UR.ToString("#,##0");
// lbOther.Text = decOther.ToString("#,##0");
// }
// else
// {
// if ("0".Equals(strToDay))
// {
// lbUserTitle.Text = "昨日用户简报";
// //lbYesterDate2.Text = "昨日（）";
// lbYesterDate.Text = "昨日（）";
// }
// else
// {
// lbUserTitle.Text = "今日用户简报";
// //lbYesterDate2.Text = "昨日（）";
// lbYesterDate.Text = "今日（）";
// }
// lbUserAll.Text = "0";
// lbIOSUR.Text = "0";
// lbANDUR.Text = "0";
// lbWAPUR.Text = "0";
// lbWP7.Text = "0";
// lbOther.Text = "0";
// }
// #endregion
// string strPlanDetail = "";
// strPlanDetail = strPlanDetail + "<table width='60%'><tr>";
// if (dsDetailResult.Tables["ProcCount"].Rows.Count > 0)
// {
// foreach (DataRow drRow in dsDetailResult.Tables["ProcCount"].Rows)
// {
// strPlanDetail = strPlanDetail + "<td style='width:2%'><font color='blue'>" + drRow["COLNMS"].ToString() + "：</font></td><td style='width:2%'><font color='red'>" + drRow["COLVALUE"].ToString() + "</font><font color='blue'> 条</font></td>";
// }
// }
// else
// {
// strPlanDetail = strPlanDetail + "<td style='width:2%'><font color='blue'>酒店上下线计划：</font></td><td style='width:2%'><font color='red'>0 条</font></td><td style='width:2%'><font color='blue'>修改目的地类型：</font></td><td style='width:2%'><font color='red'>0 条</font></td><td style='width:2%'><font color='blue'>修改酒店详情：</font></td><td style='width:2%'><font color='red'>0 条</font></td>";
// }
// strPlanDetail = strPlanDetail + "</tr></table>";
// dvPlanDetail.InnerHtml = strPlanDetail;
// //lbPlanOnOff.Text = "";
// //lbFtType.Text = "";
// //lbHotelInfo.Text = "";
// decimal decInRoomAll = 0;
// decimal decInRoomIOS = 0;
// decimal decInRoomAND = 0;
// decimal decInRoomWAP = 0;
// if (dsDetailResult.Tables["InRoomCount"].Rows.Count > 0)
// {
// foreach (DataRow drRow in dsDetailResult.Tables["InRoomCount"].Rows)
// {
// decInRoomAll = decInRoomAll + ((String.IsNullOrEmpty(drRow["COLVALUE"].ToString())) ? 0 : decimal.Parse(drRow["COLVALUE"].ToString()));
// switch (drRow["BOOKSOURCE"].ToString().ToLower())
// {
// case "ios":
// decInRoomIOS = decInRoomIOS + ((String.IsNullOrEmpty(drRow["COLVALUE"].ToString())) ? 0 : decimal.Parse(drRow["COLVALUE"].ToString()));
// break;
// case "lm_ios":
// decInRoomIOS = decInRoomIOS + ((String.IsNullOrEmpty(drRow["COLVALUE"].ToString())) ? 0 : decimal.Parse(drRow["COLVALUE"].ToString()));
// break;
// case "lm_android":
// decInRoomAND = decInRoomAND + ((String.IsNullOrEmpty(drRow["COLVALUE"].ToString())) ? 0 : decimal.Parse(drRow["COLVALUE"].ToString()));
// break;
// case "android":
// decInRoomAND = decInRoomAND + ((String.IsNullOrEmpty(drRow["COLVALUE"].ToString())) ? 0 : decimal.Parse(drRow["COLVALUE"].ToString()));
// break;
// case "wap":
// decInRoomWAP = decInRoomWAP + ((String.IsNullOrEmpty(drRow["COLVALUE"].ToString())) ? 0 : decimal.Parse(drRow["COLVALUE"].ToString()));
// break;
// default:
// break;
// }
// }
// lbInRoomAll.Text = decInRoomAll.ToString("#,##0");
// lbInRoomIOS.Text = decInRoomIOS.ToString("#,##0");
// lbInRoomAND.Text = decInRoomAND.ToString("#,##0");
// lbInRoomWAP.Text = decInRoomWAP.ToString("#,##0");
// }
// else
// {
// lbInRoomAll.Text = "0";
// lbInRoomIOS.Text = "0";
// lbInRoomAND.Text = "0";
// lbInRoomWAP.Text = "0";
// }
//}
//else
//{
// lbOrderAll.Text = "0";
// lbUnvOrderPr.Text = "0";
// lbYFOrderAll.Text = "0";
// lbYFOrderIOS.Text = "0";
// lbYFOrderAND.Text = "0";
// lbYFOrderWAP.Text = "0";
// lbXFOrderAll.Text = "0";
// lbXFOrderIOS.Text = "0";
// lbXFOrderAND.Text = "0";
// lbXFOrderWAP.Text = "0";
// lbCXFOrderAll.Text = "0";
// lbCXFOrderIOS.Text = "0";
// lbCXFOrderAND.Text = "0";
// lbCXFOrderWAP.Text = "0";
// lbUserAll.Text = "0";
// lbIOSUR.Text = "0";
// lbANDUR.Text = "0";
// lbWAPUR.Text = "0";
// lbOther.Text = "0";
// lbInRoomAll.Text = "0";
// lbInRoomIOS.Text = "0";
// lbInRoomAND.Text = "0";
// lbInRoomWAP.Text = "0";
// dvPlanDetail.InnerHtml = "<table width='60%'><tr><td style='width:2%'><font color='blue'>酒店上下线计划：</font></td><td style='width:2%'><font color='red'>0 条</font></td><td style='width:2%'><font color='blue'>修改目的地类型：</font></td><td style='width:2%'><font color='red'>0 条</font></td><td style='width:2%'><font color='blue'>修改酒店详情：</font></td><td style='width:2%'><font color='red'>0 条</font></td></tr></table>";
// //lbPlanOnOff.Text = "0";
// //lbFtType.Text = "0";
// //lbHotelInfo.Text = "0";
//}
#endregion
}
public void GetResultData(string StartDate, string EndDate)
{
try
{
dsResult.Clear();
MasterInfoEntity _masterInfoEntity = new MasterInfoEntity();
CommonEntity _commonEntity = new CommonEntity();
_masterInfoEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_masterInfoEntity.LogMessages.Userid = UserSession.Current.UserAccount;
_masterInfoEntity.LogMessages.Username = UserSession.Current.UserDspName;
_masterInfoEntity.LogMessages.IpAddress = UserSession.Current.UserIP;
_masterInfoEntity.MasterInfoDBEntity = new List<MasterInfoDBEntity>();
MasterInfoDBEntity msterInfoDBEntity = new MasterInfoDBEntity();
_masterInfoEntity.MasterInfoDBEntity.Add(msterInfoDBEntity);
msterInfoDBEntity.RegistStart = StartDate;
msterInfoDBEntity.RegistEnd = EndDate;
dsResult = MasterInfoBP.CommonSelectOrderChannelData(_masterInfoEntity).QueryResult;
}
catch (Exception ex)
{
System.IO.File.AppendAllText("C:\\ConsultLog\\" + UserSession.Current.UserAccount + "-Default-Order-GetResultData.txt", "Default-Order异常信息：" + ex.Message.ToString(), System.Text.Encoding.GetEncoding("GB2312"));
}
}
public void CommonSelectTodayLoginUserNew(string StartDate, string EndDate)
{
MasterInfoEntity _masterInfoEntity = new MasterInfoEntity();
CommonEntity _commonEntity = new CommonEntity();
_masterInfoEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_masterInfoEntity.LogMessages.Userid = UserSession.Current.UserAccount;
_masterInfoEntity.LogMessages.Username = UserSession.Current.UserDspName;
_masterInfoEntity.LogMessages.IpAddress = UserSession.Current.UserIP;
_masterInfoEntity.MasterInfoDBEntity = new List<MasterInfoDBEntity>();
MasterInfoDBEntity msterInfoDBEntity = new MasterInfoDBEntity();
_masterInfoEntity.MasterInfoDBEntity.Add(msterInfoDBEntity);
msterInfoDBEntity.RegistStart = StartDate;
msterInfoDBEntity.RegistEnd = EndDate;
DataSet dsTodayLoginResult = MasterInfoBP.CommonSelectTodayLoginUserNew(_masterInfoEntity).QueryResult;
decimal decLogUserAll = 0;
decimal decLogUserAllYK = 0;
if (dsTodayLoginResult.Tables["TodayLoginUserDataNew"].Rows.Count > 0)
{
decLogUserAll = decLogUserAll + ((String.IsNullOrEmpty(dsTodayLoginResult.Tables["TodayLoginUserDataNew"].Rows[0]["OUSER"].ToString())) ? 0 : decimal.Parse(dsTodayLoginResult.Tables["TodayLoginUserDataNew"].Rows[0]["OUSER"].ToString()));
decLogUserAllYK = decLogUserAllYK + ((String.IsNullOrEmpty(dsTodayLoginResult.Tables["TodayLoginUserDataNew"].Rows[0]["NUSER"].ToString())) ? 0 : decimal.Parse(dsTodayLoginResult.Tables["TodayLoginUserDataNew"].Rows[0]["NUSER"].ToString()));
lbTodayLoginAll.Text = (decLogUserAll + decLogUserAllYK).ToString("#,##0");
lbLgALLYK.Text = decLogUserAllYK.ToString("#,##0");
}
else
{
lbTodayLoginAll.Text = "0";
lbLgALLYK.Text = "0";
}
}
public void BingTodayLoginUser(string StartDate, string EndDate)
{
MasterInfoEntity _masterInfoEntity = new MasterInfoEntity();
CommonEntity _commonEntity = new CommonEntity();
_masterInfoEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_masterInfoEntity.LogMessages.Userid = UserSession.Current.UserAccount;
_masterInfoEntity.LogMessages.Username = UserSession.Current.UserDspName;
_masterInfoEntity.LogMessages.IpAddress = UserSession.Current.UserIP;
_masterInfoEntity.MasterInfoDBEntity = new List<MasterInfoDBEntity>();
MasterInfoDBEntity msterInfoDBEntity = new MasterInfoDBEntity();
_masterInfoEntity.MasterInfoDBEntity.Add(msterInfoDBEntity);
msterInfoDBEntity.RegistStart = StartDate;
msterInfoDBEntity.RegistEnd = EndDate;
DataSet dsTodayLoginResult = MasterInfoBP.CommonSelectTodayLoginUser(_masterInfoEntity).QueryResult;
if (dsTodayLoginResult.Tables["TodayLoginUserData"].Rows.Count > 0)
{
lbYesterDate.Text = "(" + dsTodayLoginResult.Tables["TodayLoginUserData"].Rows[0]["StartDate"].ToString() + "--" + dsTodayLoginResult.Tables["TodayLoginUserData"].Rows[0]["EndDate"].ToString() + ")";
decimal decLogUserAll = 0;
decimal decLogIOSUR = 0;
decimal decLogANDUR = 0;
decimal decLogWAPUR = 0;
decimal decLogWP7UR = 0;
decimal decLogW8UR = 0;
decimal decLogOther = 0;
foreach (DataRow drRow in dsTodayLoginResult.Tables["TodayLoginUserData"].Rows)
{
decLogUserAll = decLogUserAll + ((String.IsNullOrEmpty(drRow["COLVALUE"].ToString())) ? 0 : decimal.Parse(drRow["COLVALUE"].ToString()));
switch (drRow["use_code"].ToString().ToLower())
{
case "ios":
decLogIOSUR = decLogIOSUR + ((String.IsNullOrEmpty(drRow["COLVALUE"].ToString())) ? 0 : decimal.Parse(drRow["COLVALUE"].ToString()));
break;
case "lm_ios":
decLogIOSUR = decLogIOSUR + ((String.IsNullOrEmpty(drRow["COLVALUE"].ToString())) ? 0 : decimal.Parse(drRow["COLVALUE"].ToString()));
break;
case "lm_android":
decLogANDUR = decLogANDUR + ((String.IsNullOrEmpty(drRow["COLVALUE"].ToString())) ? 0 : decimal.Parse(drRow["COLVALUE"].ToString()));
break;
case "android":
decLogANDUR = decLogANDUR + ((String.IsNullOrEmpty(drRow["COLVALUE"].ToString())) ? 0 : decimal.Parse(drRow["COLVALUE"].ToString()));
break;
case "wap":
decLogWAPUR = decLogWAPUR + ((String.IsNullOrEmpty(drRow["COLVALUE"].ToString())) ? 0 : decimal.Parse(drRow["COLVALUE"].ToString()));
break;
case "wp":
decLogWP7UR = decLogWP7UR + ((String.IsNullOrEmpty(drRow["COLVALUE"].ToString())) ? 0 : decimal.Parse(drRow["COLVALUE"].ToString()));
break;
case "w8":
decLogW8UR = decLogW8UR + ((String.IsNullOrEmpty(drRow["COLVALUE"].ToString())) ? 0 : decimal.Parse(drRow["COLVALUE"].ToString()));
break;
default:
decLogOther = decLogOther + ((String.IsNullOrEmpty(drRow["COLVALUE"].ToString())) ? 0 : decimal.Parse(drRow["COLVALUE"].ToString()));
break;
}
}
lbTodayLoginAll.Text = decLogUserAll.ToString("#,##0");
lblLogIOSUR.Text = decLogIOSUR.ToString("#,##0");
lbLogANDUR.Text = decLogANDUR.ToString("#,##0");
lbLogWAPUR.Text = decLogWAPUR.ToString("#,##0");
lbLogWP7.Text = decLogWP7UR.ToString("#,##0");
lbLogW8.Text = decLogW8UR.ToString("#,##0");
lbLogOther.Text = decLogOther.ToString("#,##0");
}
else
{
lbTodayLoginAll.Text = "0";
lblLogIOSUR.Text = "0";
lbLogANDUR.Text = "0";
lbLogWAPUR.Text = "0";
lbLogWP7.Text = "0";
lbLogW8.Text = "0";
lbLogOther.Text = "0";
}
CommonSelectTodayLoginUserNew(StartDate, EndDate);
}
public static MasterInfoEntity CommonSelectUserNew(MasterInfoEntity masterInfoEntity)
{
DataSet dsResult = new DataSet();
OracleParameter[] parm ={
new OracleParameter("StartDate",OracleType.VarChar),
new OracleParameter("EndDate",OracleType.VarChar)
};
MasterInfoDBEntity dbParm = (masterInfoEntity.MasterInfoDBEntity.Count > 0) ? masterInfoEntity.MasterInfoDBEntity[0] : new MasterInfoDBEntity();
string sumUserSql = "t_lm_master_user_info_today_new";
if (String.IsNullOrEmpty(dbParm.RegistStart))
{
parm[0].Value = DBNull.Value;
}
else
{
parm[0].Value = dbParm.RegistStart;
}
if (String.IsNullOrEmpty(dbParm.RegistEnd))
{
parm[1].Value = DBNull.Value;
}
else
{
parm[1].Value = dbParm.RegistEnd;
}
DataTable dtUser = HotelVp.Common.DBUtility.DbManager.Query("MasterInfo", sumUserSql, true, parm).Tables[0].Copy();
dtUser.TableName = "UserCount";
dsResult.Tables.Add(dtUser);
masterInfoEntity.QueryResult = dsResult;
return masterInfoEntity;
}
public static MasterInfoEntity CommonSelect(MasterInfoEntity masterInfoEntity)
{
DataSet dsResult = new DataSet();
MasterInfoDBEntity dbParm = (masterInfoEntity.MasterInfoDBEntity.Count > 0) ? masterInfoEntity.MasterInfoDBEntity[0] : new MasterInfoDBEntity();
string sumSql = string.Empty;
string listSql = string.Empty;
string userSql = string.Empty;
string roomSql = string.Empty;
string allSql = string.Empty;
string allticSql = string.Empty;
string ordticSql = string.Empty;
string roomticSql = string.Empty;
if (!String.IsNullOrEmpty(dbParm.Today) && "1".Equals(dbParm.Today))
{
sumSql = "t_lm_master_order_sum_info_today";
listSql = "t_lm_master_order_list_info_today";
userSql = "t_lm_master_user_info_today";
roomSql = "t_lm_master_in_room_info_today";
allSql = "t_lm_master_order_all_info_today";
allticSql = "t_lm_master_ticket_info_today";
ordticSql = "t_lm_order_ticket_info_today";
roomticSql = "t_lm_order_ticket_in_room_info_today";
}
else
{
sumSql = "t_lm_master_order_sum_info";
listSql = "t_lm_master_order_list_info";
userSql = "t_lm_master_user_info";
roomSql = "t_lm_master_in_room_info";
allSql = "t_lm_master_order_all_info";
allticSql = "t_lm_master_ticket_info";
ordticSql = "t_lm_order_ticket_info";
roomticSql = "t_lm_order_ticket_in_room_info";
}
DataTable dtOrderSum = HotelVp.Common.DBUtility.DbManager.Query("MasterInfo", sumSql, true).Tables[0].Copy();
dtOrderSum.TableName = "OrderSum";
DataTable dtOrderList = HotelVp.Common.DBUtility.DbManager.Query("MasterInfo", listSql, true).Tables[0].Copy();
dtOrderList.TableName = "OrderList";
DataTable dtUser = HotelVp.Common.DBUtility.DbManager.Query("MasterInfo", userSql, true).Tables[0].Copy();
dtUser.TableName = "UserCount";
DataTable dtProc = new DataTable();// HotelVp.Common.DBUtility.DbManager.Query("MasterInfo", "t_lm_master_proc_info").Tables[0].Copy();
dtProc.TableName = "ProcCount";
DataTable dtInRoom = HotelVp.Common.DBUtility.DbManager.Query("MasterInfo", roomSql, true).Tables[0].Copy();
dtInRoom.TableName = "InRoomCount";
DataTable dtOrderAll = HotelVp.Common.DBUtility.DbManager.Query("MasterInfo", allSql, true).Tables[0].Copy();
dtOrderAll.TableName = "OrderAll";
DataTable dtAllTic = HotelVp.Common.DBUtility.DbManager.Query("MasterInfo", allticSql, true).Tables[0].Copy();
dtAllTic.TableName = "AllTic";
DataTable dtOrderTic = HotelVp.Common.DBUtility.DbManager.Query("MasterInfo", ordticSql, true).Tables[0].Copy();
dtOrderTic.TableName = "OrderTic";
DataTable dtRoomTic = HotelVp.Common.DBUtility.DbManager.Query("MasterInfo", roomticSql, true).Tables[0].Copy();
dtRoomTic.TableName = "RoomTic";
dsResult.Tables.Add(dtOrderSum);
dsResult.Tables.Add(dtOrderList);
dsResult.Tables.Add(dtUser);
dsResult.Tables.Add(dtProc);
dsResult.Tables.Add(dtInRoom);
dsResult.Tables.Add(dtOrderAll);
dsResult.Tables.Add(dtAllTic);
dsResult.Tables.Add(dtOrderTic);
dsResult.Tables.Add(dtRoomTic);
masterInfoEntity.QueryResult = dsResult;
return masterInfoEntity;
}
/// <summary>
/// 订单、渠道统计
/// </summary>
/// <param name="masterInfoEntity"></param>
/// <returns></returns>
public static MasterInfoEntity CommonSelectOrderChannelData(MasterInfoEntity masterInfoEntity)
{
DataSet dsResult = new DataSet();
OracleParameter[] parm ={
new OracleParameter("StartDate",OracleType.VarChar),
new OracleParameter("EndDate",OracleType.VarChar)
};
MasterInfoDBEntity dbParm = (masterInfoEntity.MasterInfoDBEntity.Count > 0) ? masterInfoEntity.MasterInfoDBEntity[0] : new MasterInfoDBEntity();
string sumChannelSql = "t_lm_orderchannel_days_info";
if (String.IsNullOrEmpty(dbParm.RegistStart))
{
parm[0].Value = DBNull.Value;
}
else
{
parm[0].Value = dbParm.RegistStart.Replace("/","-");
}
if (String.IsNullOrEmpty(dbParm.RegistEnd))
{
parm[1].Value = DBNull.Value;
}
else
{
parm[1].Value = dbParm.RegistEnd.Replace("/", "-");
}
DataTable dtOrderSum = HotelVp.Common.DBUtility.DbManager.Query("MasterPageInfo", sumChannelSql, true, parm).Tables[0].Copy();
dtOrderSum.TableName = "OrderAll";
dsResult.Tables.Add(dtOrderSum);
masterInfoEntity.QueryResult = dsResult;
return masterInfoEntity;
}