public static OrderFeedbackEntity BindOrderFeedBackList(OrderFeedbackEntity OrderFeedbackEntity)
{
OrderFeedbackDBEntity dbParm = (OrderFeedbackEntity.orderFeedbackDBEntity.Count > 0) ? OrderFeedbackEntity.orderFeedbackDBEntity[0] : new OrderFeedbackDBEntity();
string strSQL = XmlSqlAnalyze.GotSqlTextFromXml("OrderFeedback", "t_lm_order_feedback_list");
if (!String.IsNullOrEmpty(dbParm.OrderNum))
{
strSQL += " and lf.ORDER_NUM='" + dbParm.OrderNum + "'";
}
else
{
if (!String.IsNullOrEmpty(dbParm.CreateTimeStart))
{
strSQL += " and lf.CREATE_TIME BETWEEN TO_DATE('" + dbParm.CreateTimeStart + "', 'yyyy-mm-dd') AND TO_DATE('" + dbParm.CreateTimeEnd + "', 'yyyy-mm-dd')";
}
if (!String.IsNullOrEmpty(dbParm.UpdateTimeStart))
{
strSQL += " and lf.UPDATE_TIME BETWEEN TO_DATE('" + dbParm.UpdateTimeStart + "', 'yyyy-mm-dd') AND TO_DATE('" + dbParm.UpdateTimeEnd + "', 'yyyy-mm-dd')";
}
if (dbParm.IsProcess == "1")
{
strSQL += " and lf.IS_PROCESS='1'";
}
else if (dbParm.IsProcess == "")
{
strSQL += " and lf.IS_PROCESS is null ";
}
}
OrderFeedbackEntity.QueryResult = DbHelperOra.Query(strSQL, true);
return OrderFeedbackEntity;
}
public static OrderFeedbackEntity UpdateOrderBookStatusOther(OrderFeedbackEntity orderFeedbackEntity)
{
orderFeedbackEntity.LogMessages.MsgType = MessageType.INFO;
orderFeedbackEntity.LogMessages.Content = _nameSpaceClass + "UpdateOrderBookStatusOther";
LoggerHelper.LogWriter(orderFeedbackEntity.LogMessages);
try
{
return OrderFeedbackDA.UpdateOrderBookStatusOther(orderFeedbackEntity);
}
catch (Exception ex)
{
orderFeedbackEntity.LogMessages.MsgType = MessageType.ERROR;
orderFeedbackEntity.LogMessages.Content = _nameSpaceClass + "UpdateOrderBookStatusOther Error: " + ex.Message;
LoggerHelper.LogWriter(orderFeedbackEntity.LogMessages);
throw ex;
}
}
public static string GetUserTel(OrderFeedbackEntity orderFeedbackEntity, string userAccount)
{
orderFeedbackEntity.LogMessages.MsgType = MessageType.INFO;
orderFeedbackEntity.LogMessages.Content = _nameSpaceClass + "GetUserTel";
LoggerHelper.LogWriter(orderFeedbackEntity.LogMessages);
try
{
return OrderFeedbackDA.GetUserTel(userAccount);
}
catch (Exception ex)
{
orderFeedbackEntity.LogMessages.MsgType = MessageType.ERROR;
orderFeedbackEntity.LogMessages.Content = _nameSpaceClass + "GetUserTel Error: " + ex.Message;
LoggerHelper.LogWriter(orderFeedbackEntity.LogMessages);
throw ex;
}
}
public static OrderFeedbackEntity BindOrderFeedBackList(OrderFeedbackEntity orderFeedbackEntity)
{
orderFeedbackEntity.LogMessages.MsgType = MessageType.INFO;
orderFeedbackEntity.LogMessages.Content = _nameSpaceClass + "BindOrderFeedBackList";
LoggerHelper.LogWriter(orderFeedbackEntity.LogMessages);
try
{
return OrderFeedbackDA.BindOrderFeedBackList(orderFeedbackEntity);
}
catch (Exception ex)
{
orderFeedbackEntity.LogMessages.MsgType = MessageType.ERROR;
orderFeedbackEntity.LogMessages.Content = _nameSpaceClass + "BindOrderFeedBackList Error: " + ex.Message;
LoggerHelper.LogWriter(orderFeedbackEntity.LogMessages);
throw ex;
}
}
public static OrderFeedbackEntity BindOrderDetailsByOrderNum(OrderFeedbackEntity OrderFeedbackEntity)
{
OracleParameter[] parm ={
new OracleParameter("FOGORDERNUM",OracleType.VarChar)
};
OrderFeedbackDBEntity dbParm = (OrderFeedbackEntity.orderFeedbackDBEntity.Count > 0) ? OrderFeedbackEntity.orderFeedbackDBEntity[0] : new OrderFeedbackDBEntity();
if (String.IsNullOrEmpty(dbParm.OrderNum))
{
parm[0].Value = DBNull.Value;
}
else
{
parm[0].Value = dbParm.OrderNum;
}
OrderFeedbackEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("OrderFeedback", "t_lm_order_by_nsusercomplain", true, parm);
return OrderFeedbackEntity;
}
public static OrderFeedbackEntity UpdateOrderBookStatusOther(OrderFeedbackEntity OrderFeedbackEntity)
{
OracleParameter[] parm ={
new OracleParameter("BOOKSTATUSOTHER",OracleType.VarChar),
new OracleParameter("ORDERNUM",OracleType.VarChar)
};
OrderFeedbackDBEntity dbParm = (OrderFeedbackEntity.orderFeedbackDBEntity.Count > 0) ? OrderFeedbackEntity.orderFeedbackDBEntity[0] : new OrderFeedbackDBEntity();
if (String.IsNullOrEmpty(dbParm.Content))
{
parm[0].Value = DBNull.Value;
}
else
{
parm[0].Value = dbParm.Content;
}
if (String.IsNullOrEmpty(dbParm.OrderNum))
{
parm[1].Value = DBNull.Value;
}
else
{
parm[1].Value = dbParm.OrderNum;
}
OrderFeedbackEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("OrderFeedback", "update_t_lm_order_bookstatusother", false, parm);
return OrderFeedbackEntity;
}
public static OrderFeedbackEntity UpdateOrderFeedBack(OrderFeedbackEntity OrderFeedbackEntity)
{
OracleParameter[] parm ={
new OracleParameter("ISPROCESS",OracleType.VarChar),
new OracleParameter("OPERATOR",OracleType.VarChar),
new OracleParameter("ORDERNUM",OracleType.VarChar)
};
OrderFeedbackDBEntity dbParm = (OrderFeedbackEntity.orderFeedbackDBEntity.Count > 0) ? OrderFeedbackEntity.orderFeedbackDBEntity[0] : new OrderFeedbackDBEntity();
if (String.IsNullOrEmpty(dbParm.IsProcess))
{
parm[0].Value = DBNull.Value;
}
else
{
parm[0].Value = dbParm.IsProcess;
}
if (String.IsNullOrEmpty(dbParm.OperatorZH1))
{
parm[1].Value = DBNull.Value;
}
else
{
parm[1].Value = dbParm.OperatorZH1;
}
if (String.IsNullOrEmpty(dbParm.OrderNum))
{
parm[2].Value = DBNull.Value;
}
else
{
parm[2].Value = dbParm.OrderNum;
}
OrderFeedbackEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("OrderFeedback", "update_t_lm_order_feedback", false, parm);
return OrderFeedbackEntity;
}