public static ReportCenterEntity FRCancelDataReportSelect(ReportCenterEntity ReportCenterEntity)
{
ReportCenterEntity.LogMessages.MsgType = MessageType.INFO;
ReportCenterEntity.LogMessages.Content = _nameSpaceClass + "FRCancelDataReportSelect";
LoggerHelper.LogWriter(ReportCenterEntity.LogMessages);
try
{
return ReportCenterDA.FRCancelDataReportSelect(ReportCenterEntity);
}
catch (Exception ex)
{
ReportCenterEntity.LogMessages.MsgType = MessageType.ERROR;
ReportCenterEntity.LogMessages.Content = _nameSpaceClass + "FRCancelDataReportSelect Error: " + ex.Message;
LoggerHelper.LogWriter(ReportCenterEntity.LogMessages);
throw ex;
}
}
//导出Excel文件
protected void btnExport_Click(object sender, EventArgs e)
{
ReportCenterEntity _reportCenterEntity = new ReportCenterEntity();
CommonEntity _commonEntity = new CommonEntity();
_reportCenterEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_reportCenterEntity.LogMessages.Userid = UserSession.Current.UserAccount;
_reportCenterEntity.LogMessages.Username = UserSession.Current.UserDspName;
_reportCenterEntity.LogMessages.IpAddress = UserSession.Current.UserIP;
_reportCenterEntity.StartDTime = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["StartDTime"].ToString())) ? null : ViewState["StartDTime"].ToString();
_reportCenterEntity.EndDTime = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["EndDTime"].ToString())) ? null : ViewState["EndDTime"].ToString();
DataSet dsResult = ReportCenterBP.CCCancelDataReportSelect(_reportCenterEntity).QueryResult;
if (dsResult.Tables.Count == 0 && dsResult.Tables[0].Rows.Count ==0)
{
messageContent.InnerHtml = GetLocalResourceObject("WarningMessage").ToString();
return;
}
CommonFunction.ExportExcelForLM(dsResult);
}
public static ReportCenterEntity GeneralDataReportSelect(ReportCenterEntity reportCenterEntity)
{
//OracleParameter[] parm ={
// new OracleParameter("ID",OracleType.VarChar),
// new OracleParameter("StartDTime",OracleType.VarChar),
// new OracleParameter("EndDTime",OracleType.VarChar)
// };
//if (String.IsNullOrEmpty(lmSystemLogEntity.EventID))
//{
// parm[0].Value = DBNull.Value;
//}
//else
//{
// parm[0].Value = lmSystemLogEntity.EventID;
//}
//if (String.IsNullOrEmpty(lmSystemLogEntity.StartDTime))
//{
// parm[1].Value = DBNull.Value;
//}
//else
//{
// parm[1].Value = lmSystemLogEntity.StartDTime;
//}
//if (String.IsNullOrEmpty(lmSystemLogEntity.EndDTime))
//{
// parm[2].Value = DBNull.Value;
//}
//else
//{
// parm[2].Value = lmSystemLogEntity.EndDTime;
//}
reportCenterEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("ReportCenter", "GeneralDataReport", true);
return reportCenterEntity;
}
public static ReportCenterEntity GetSqlOrderList(ReportCenterEntity ReportCenterEntity)
{
ReportCenterEntity.LogMessages.MsgType = MessageType.INFO;
ReportCenterEntity.LogMessages.Content = _nameSpaceClass + "OrderSearchDataReport";
LoggerHelper.LogWriter(ReportCenterEntity.LogMessages);
try
{
return ReportCenterDA.GetSqlOrderList(ReportCenterEntity);
}
catch (Exception ex)
{
ReportCenterEntity.LogMessages.MsgType = MessageType.ERROR;
ReportCenterEntity.LogMessages.Content = _nameSpaceClass + "OrderSearchDataReport Error: " + ex.Message;
LoggerHelper.LogWriter(ReportCenterEntity.LogMessages);
throw ex;
}
}
public static ReportCenterEntity GeneralDataReportSelectList(ReportCenterEntity reportCenterEntity)
{
OracleParameter[] parm ={
new OracleParameter("StartDTime",OracleType.VarChar),
new OracleParameter("EndDTime",OracleType.VarChar)
};
if (String.IsNullOrEmpty(reportCenterEntity.StartDTime))
{
parm[0].Value = DBNull.Value;
}
else
{
parm[0].Value = reportCenterEntity.StartDTime;
}
if (String.IsNullOrEmpty(reportCenterEntity.EndDTime))
{
parm[1].Value = DBNull.Value;
}
else
{
parm[1].Value = reportCenterEntity.EndDTime;
}
reportCenterEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("ReportCenter", "GeneralDataReportSelectList", true, parm);
return reportCenterEntity;
}
public static ReportCenterEntity FRCancelDataReportSelect(ReportCenterEntity reportCenterEntity)
{
reportCenterEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("ReportCenter", "FRCancelDataReport", true);
return reportCenterEntity;
}
public static ReportCenterEntity CohortAnalysisReportSelect(ReportCenterEntity reportCenterEntity)
{
reportCenterEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("ReportCenter", "CohortAnalysisReport", true);
return reportCenterEntity;
}
public static ReportCenterEntity OrderSearchDataReport(ReportCenterEntity reportCenterEntity)
{
OracleParameter[] parm ={
new OracleParameter("CREATEDATE",OracleType.VarChar),
new OracleParameter("ENDDATE",OracleType.VarChar),
new OracleParameter("CITYID",OracleType.VarChar),
new OracleParameter("SALES",OracleType.VarChar)
};
if (String.IsNullOrEmpty(reportCenterEntity.StartDTime))
{
parm[0].Value = DBNull.Value;
}
else
{
parm[0].Value = reportCenterEntity.StartDTime;
}
if (String.IsNullOrEmpty(reportCenterEntity.EndDTime))
{
parm[1].Value = DBNull.Value;
}
else
{
parm[1].Value = reportCenterEntity.EndDTime;
}
if (String.IsNullOrEmpty(reportCenterEntity.CityID))
{
parm[2].Value = DBNull.Value;
}
else
{
parm[2].Value = reportCenterEntity.CityID;
}
if (String.IsNullOrEmpty(reportCenterEntity.Sales))
{
parm[3].Value = DBNull.Value;
}
else
{
parm[3].Value = reportCenterEntity.Sales;
}
reportCenterEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("ReportCenter", "OrderSearchDataReport", true, parm);
return reportCenterEntity;
}
public static ReportCenterEntity GetSqlOrderList(ReportCenterEntity reportCenterEntity)
{
DataCommand cmd = DataCommandManager.GetDataCommand("GetOrderManageSearchDataHistory");
cmd.SetParameterValue("@EVENTUSER", reportCenterEntity.Sales);
cmd.SetParameterValue("@STARTDATE", reportCenterEntity.StartDTime);
cmd.SetParameterValue("@ENDDATE", reportCenterEntity.EndDTime);
reportCenterEntity.QueryResult = cmd.ExecuteDataSet();
return reportCenterEntity;
}
public static ReportCenterEntity GetOracleOrderList(ReportCenterEntity reportCenterEntity)
{
OracleParameter[] parm ={
new OracleParameter("STARTDTIME",OracleType.VarChar),
new OracleParameter("ENDDTIME",OracleType.VarChar),
new OracleParameter("PRICECODE",OracleType.VarChar)
};
if (String.IsNullOrEmpty(reportCenterEntity.StartDTime))
{
parm[0].Value = DBNull.Value;
}
else
{
parm[0].Value = reportCenterEntity.StartDTime;
}
if (String.IsNullOrEmpty(reportCenterEntity.EndDTime))
{
parm[1].Value = DBNull.Value;
}
else
{
parm[1].Value = reportCenterEntity.EndDTime;
}
if (String.IsNullOrEmpty(reportCenterEntity.PriceCode))
{
parm[2].Value = DBNull.Value;
}
else
{
parm[2].Value = reportCenterEntity.PriceCode;
}
reportCenterEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("ReportCenter", "OrderManageSearchDataReport", true, parm);
return reportCenterEntity;
}