/// <summary>
/// 支付宝充值接口
/// </summary>
/// <returns></returns>
public static CashBackEntity autoPay(CashBackEntity cashBackEntity)
{
string DataString = string.Empty;
CashBackDBEntity dbParm = (cashBackEntity.CashBackDBEntity.Count > 0) ? cashBackEntity.CashBackDBEntity[0] : new CashBackDBEntity();
if (dbParm.BackCashType == "3")//手机充值
{
DataString = "{\"loginMobile\":\"" + dbParm.LoginMobile + "\",\"amount\":" + dbParm.BackCashAmount + ",\"applyType\":\"" + dbParm.BackCashType + "\",\"rechargePhoneNumber\":\"" + dbParm.Phone + "\",\"sn\":\"" + dbParm.Sn + "\",\"Remark\":\"" + dbParm.Remark + "\",\"operater\":\"" + dbParm.CreateUser + "\"}";
}
else if (dbParm.BackCashType == "2")//支付宝返还
{
DataString = "{\"loginMobile\":\"" + dbParm.LoginMobile + "\",\"amount\":" + dbParm.BackCashAmount + ",\"applyType\":\"" + dbParm.BackCashType + "\",\"alipayAccount\":\"" + dbParm.AlipayAccount + "\",\"userName\":\"" + dbParm.AlipayName + "\",\"sn\":\"" + dbParm.Sn + "\",\"Remark\":\"" + dbParm.Remark + "\",\"operater\":\"" + dbParm.CreateUser + "\"}";
}
string SaveCashBackRequestUrl = JsonRequestURLBuilder.autoPay();
CallWebPage callWebPage = new CallWebPage();
string strSaveCashBack = callWebPage.CallWebByURL(SaveCashBackRequestUrl, DataString);
JObject oSaveCashBack = JObject.Parse(strSaveCashBack);
if ("200".Equals(JsonRequestURLBuilder.GetJsonStringValue(oSaveCashBack, "code").Trim('"')))
{
//成功
cashBackEntity.Result = 1;
cashBackEntity.ErrorMSG = JsonRequestURLBuilder.GetJsonStringValue(oSaveCashBack, "message").Trim('"');
}
else
{
cashBackEntity.Result = 2;
cashBackEntity.ErrorMSG = JsonRequestURLBuilder.GetJsonStringValue(oSaveCashBack, "message").Trim('"');
}
return cashBackEntity;
}
public static CashBackEntity BindOrderInfo(CashBackEntity cashBackEntity)
{
CashBackDBEntity dbParm = (cashBackEntity.CashBackDBEntity.Count > 0) ? cashBackEntity.CashBackDBEntity[0] : new CashBackDBEntity();
OracleParameter[] parm ={
new OracleParameter("ORDERNO",OracleType.VarChar)
};
parm[0].Value = dbParm.OrderNo;
DataSet dsResult = HotelVp.Common.DBUtility.DbManager.Query("CashBack", "t_lm_b_order_info_list_by_order", false, parm);
if (dsResult.Tables.Count > 0 && dsResult.Tables[0].Rows.Count > 0)
{
DataSet dsCash = GetCashBackByOrderNoStatus(dbParm.OrderNo);
if (dsCash.Tables.Count > 0 && dsCash.Tables[0].Rows.Count > 0)
{
dsResult.Tables[0].Rows[0]["CashTaskStatus"] = dsCash.Tables[0].Rows[0]["status"].ToString();
dsResult.Tables[0].Rows[0]["CashSN"] = dsCash.Tables[0].Rows[0]["CashSN"].ToString();
}
else
{
dsResult.Tables[0].Rows[0]["CashTaskStatus"] = "2";
dsResult.Tables[0].Rows[0]["CashSN"] = "";
}
}
cashBackEntity.QueryResult = dsResult;
return cashBackEntity;
}
public static CashBackEntity BindOrderInfoByUser(CashBackEntity cashBackEntity)
{
CashBackDBEntity dbParm = (cashBackEntity.CashBackDBEntity.Count > 0) ? cashBackEntity.CashBackDBEntity[0] : new CashBackDBEntity();
OracleParameter[] parm ={
new OracleParameter("USERID",OracleType.VarChar)
};
parm[0].Value = dbParm.UserID;
cashBackEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("CashBack", "t_lm_b_order_info_list_by_user", false, parm);
return cashBackEntity;
}
public static CashBackEntity BindHotelList(CashBackEntity cashBackEntity)
{
OracleParameter[] parm ={
new OracleParameter("HOTELID",OracleType.VarChar)
};
CashBackDBEntity dbParm = (cashBackEntity.CashBackDBEntity.Count > 0) ? cashBackEntity.CashBackDBEntity[0] : new CashBackDBEntity();
parm[0].Value = dbParm.HotelID;
cashBackEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("CashBack", "t_lm_b_hotelinfo_bind", false, parm);
return cashBackEntity;
}
public static CashBackEntity BindOrderInfo(CashBackEntity cashBackEntity)
{
cashBackEntity.LogMessages.MsgType = MessageType.INFO;
cashBackEntity.LogMessages.Content = _nameSpaceClass + "BindOrderInfo";
LoggerHelper.LogWriter(cashBackEntity.LogMessages);
try
{
return CashBackDA.BindOrderInfo(cashBackEntity);
}
catch (Exception ex)
{
cashBackEntity.LogMessages.MsgType = MessageType.ERROR;
cashBackEntity.LogMessages.Content = _nameSpaceClass + "BindOrderInfo Error: " + ex.Message;
LoggerHelper.LogWriter(cashBackEntity.LogMessages);
throw ex;
}
}
public static CashBackEntity autoPay(CashBackEntity cashBackEntity)
{
cashBackEntity.LogMessages.MsgType = MessageType.INFO;
cashBackEntity.LogMessages.Content = _nameSpaceClass + "autoPay";
LoggerHelper.LogWriter(cashBackEntity.LogMessages);
try
{
return CashBackSA.autoPay(cashBackEntity);
}
catch (Exception ex)
{
cashBackEntity.LogMessages.MsgType = MessageType.ERROR;
cashBackEntity.LogMessages.Content = _nameSpaceClass + "autoPay Error: " + ex.Message;
LoggerHelper.LogWriter(cashBackEntity.LogMessages);
throw ex;
}
}
public static bool CheckHistoryUpdate(CashBackEntity cashBackEntity)
{
CashBackDBEntity dbParm = (cashBackEntity.CashBackDBEntity.Count > 0) ? cashBackEntity.CashBackDBEntity[0] : new CashBackDBEntity();
OracleParameter[] dlmParm ={
new OracleParameter("HOTELID",OracleType.VarChar),
new OracleParameter("SALESID",OracleType.VarChar)
};
dlmParm[0].Value = dbParm.HotelID;
if (String.IsNullOrEmpty(dbParm.SalesID))
{
dlmParm[1].Value = DBNull.Value;
}
else
{
dlmParm[1].Value = dbParm.SalesID;
}
DataSet dsResult = DbManager.Query("CashBack", "t_lm_sales_history_select", false, dlmParm);
if (dsResult.Tables.Count > 0 && dsResult.Tables[0].Rows.Count > 0)
{
return true;
}
return false;
}
public static CashBackEntity GetBalanceRoomList(CashBackEntity cashBackEntity)
{
CashBackDBEntity dbParm = (cashBackEntity.CashBackDBEntity.Count > 0) ? cashBackEntity.CashBackDBEntity[0] : new CashBackDBEntity();
DataSet dsResult = new DataSet();
dsResult.Tables.Add(new DataTable());
dsResult.Tables[0].Columns.Add(new DataColumn("ROOMCODE"));
dsResult.Tables[0].Columns.Add(new DataColumn("ROOMNM"));
try
{
string url = JsonRequestURLBuilder.queryHotelBalRoomV2();
url = url + dbParm.HotelID;
CallWebPage callWebPage = new CallWebPage();
string strJson = callWebPage.CallWebByURL(url, "roomcode");
//解析json数据
JObject o = JObject.Parse(strJson);
//JArray jsa = (JArray)o.SelectToken("result");
string oRoomList = o.SelectToken("result").ToString();
JArray jsa = (JArray)JsonConvert.DeserializeObject(oRoomList);
string roomtypecode = string.Empty;
string roomtypename = string.Empty;
for (int i = 0; i < jsa.Count; i++)
{
JObject jso = (JObject)jsa[i];
roomtypecode = JsonRequestURLBuilder.GetJsonStringValue(jso, "roomcode").Trim('"');
roomtypename = JsonRequestURLBuilder.GetJsonStringValue(jso, "roomname").Trim('"');
DataRow drRow = dsResult.Tables[0].NewRow();
drRow["ROOMCODE"] = roomtypecode;
drRow["ROOMNM"] = roomtypename;
dsResult.Tables[0].Rows.Add(drRow);
}
}
catch
{
}
cashBackEntity.QueryResult = dsResult;
return cashBackEntity;
}
protected void btnSave_Click(object sender, EventArgs e)
{
messageContent.InnerHtml = "";
if (String.IsNullOrEmpty(lbUserID.Text.Trim()))
{
messageContent.InnerHtml = GetLocalResourceObject("SaveError2").ToString();
this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "key", "RestLoadStyle('0');", true);
return;
}
string strBackCashAmount = (!String.IsNullOrEmpty(lbBackCashAmount.Text.Trim()) && lbBackCashAmount.Text.Trim().IndexOf('.') >= 0) ? lbBackCashAmount.Text.Trim().Substring(0, lbBackCashAmount.Text.Trim().IndexOf('.')) : lbBackCashAmount.Text.Trim();
if (String.IsNullOrEmpty(lbBackCashAmount.Text.Trim()) || !ChkNumber(strBackCashAmount))
{
messageContent.InnerHtml = GetLocalResourceObject("SaveError7").ToString();
this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "key", "RestLoadStyle('0');", true);
return;
}
string errMsg = string.Empty;
if ("0".Equals(hidCommonType.Value.Trim()) && (String.IsNullOrEmpty(txtBankOwner.Text.Trim()) || String.IsNullOrEmpty(txtBankName.Text.Trim()) || String.IsNullOrEmpty(txtBankBranch.Text.Trim()) || String.IsNullOrEmpty(txtBankCardNumber.Text.Trim())))
{
errMsg = GetLocalResourceObject("SaveError3").ToString();
}
else if ("1".Equals(hidCommonType.Value.Trim()) && (String.IsNullOrEmpty(txtBackTel.Text.Trim())))
{
errMsg = GetLocalResourceObject("SaveError4").ToString();
}
else if ("2".Equals(hidCommonType.Value.Trim()) && (String.IsNullOrEmpty(txtBao.Text.Trim())))
{
errMsg = GetLocalResourceObject("SaveError5").ToString();
}
else if ("2".Equals(hidCommonType.Value.Trim()) && (String.IsNullOrEmpty(txtBaoName.Text.Trim())))
{
errMsg = GetLocalResourceObject("SaveError8").ToString();
}
if (!String.IsNullOrEmpty(errMsg))
{
messageContent.InnerHtml = errMsg;
this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "key", "RestLoadStyle('0');", true);
return;
}
_cashbackEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_cashbackEntity.LogMessages.Userid = UserSession.Current.UserAccount;
_cashbackEntity.LogMessages.Username = UserSession.Current.UserDspName;
_cashbackEntity.LogMessages.IpAddress = UserSession.Current.UserIP;
_cashbackEntity.CashBackDBEntity = new List<CashBackDBEntity>();
CashBackDBEntity cashbackDBEntity = new CashBackDBEntity();
cashbackDBEntity.UserID = lbUserID.Text.Trim();
cashbackDBEntity.OrderNo = lbOrderNo.Text.Trim();
cashbackDBEntity.BackCashAmount = lbBackCashAmount.Text.Trim();
cashbackDBEntity.BackCashType = hidCommonType.Value.Trim();
cashbackDBEntity.BankOwner = txtBankOwner.Text.Trim();
cashbackDBEntity.BankName = txtBankName.Text.Trim();
cashbackDBEntity.BankBranch = txtBankBranch.Text.Trim();
cashbackDBEntity.BankCardNumber = txtBankCardNumber.Text.Trim();
cashbackDBEntity.BackTel = txtBackTel.Text.Trim();
cashbackDBEntity.BackBao = txtBao.Text.Trim();
cashbackDBEntity.BackBaoName = txtBaoName.Text.Trim();
cashbackDBEntity.Remark = txtRemark.Text.Trim();
cashbackDBEntity.BackInType = "0";
_cashbackEntity.CashBackDBEntity.Add(cashbackDBEntity);
_cashbackEntity = CashBackBP.SaveCashBackRequest(_cashbackEntity);
int iResult = _cashbackEntity.Result;
_commonEntity.LogMessages = _cashbackEntity.LogMessages;
_commonEntity.CommonDBEntity = new List<CommonDBEntity>();
CommonDBEntity commonDBEntity = new CommonDBEntity();
commonDBEntity.Event_Type = "创建提现申请-保存";
commonDBEntity.Event_ID = lbUserID.Text.Trim();
string conTent = GetLocalResourceObject("EventInsertMessage").ToString();
conTent = string.Format(conTent, cashbackDBEntity.UserID, cashbackDBEntity.BackCashAmount, cashbackDBEntity.BackCashType, cashbackDBEntity.BankName, cashbackDBEntity.BankBranch, cashbackDBEntity.BankCardNumber, cashbackDBEntity.BackTel, cashbackDBEntity.BackBao, cashbackDBEntity.Remark, cashbackDBEntity.BackInType);
commonDBEntity.Event_Content = conTent;
if (iResult == 1)
{
commonDBEntity.Event_Result = GetLocalResourceObject("SaveSuccess").ToString();
messageContent.InnerHtml = GetLocalResourceObject("SaveSuccess").ToString();
}
else
{
commonDBEntity.Event_Result = GetLocalResourceObject("SaveError1").ToString() + _cashbackEntity.ErrorMSG;
messageContent.InnerHtml = GetLocalResourceObject("SaveError1").ToString() + _cashbackEntity.ErrorMSG;
}
_commonEntity.CommonDBEntity.Add(commonDBEntity);
CommonBP.InsertEventHistory(_commonEntity);
this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "key", "RestLoadStyle('0');", true);
}
//public static int Insert(CashBackEntity cashBackEntity)
//{
// if (cashBackEntity.CashBackDBEntity.Count == 0)
// {
// return 0;
// }
// if (cashBackEntity.LogMessages == null)
// {
// return 0;
// }
// if (CheckInsert(cashBackEntity) > 0)
// {
// return 2;
// }
// CashBackDBEntity dbParm = (cashBackEntity.CashBackDBEntity.Count > 0) ? cashBackEntity.CashBackDBEntity[0] : new CashBackDBEntity();
// CommandInfo InsertLmPaymentInfo = new CommandInfo();
// OracleParameter[] lmParm ={
// new OracleParameter("ID",OracleType.Number),
// new OracleParameter("NAMECN",OracleType.VarChar),
// new OracleParameter("TYPE",OracleType.VarChar),
// new OracleParameter("CODE",OracleType.VarChar),
// };
// lmParm[0].Value = getMaxIDfromSeq("t_lm_b_facilities_SEQ");
// lmParm[1].Value = dbParm.Name_CN;
// if (dbParm.Type.Equals("0"))
// {
// lmParm[2].Value = "S";
// }
// else
// {
// lmParm[2].Value = "F";
// }
// lmParm[3].Value = 'P' + lmParm[0].Value.ToString().PadLeft(4, '0');
// DbManager.ExecuteSql("CashBack", "t_lm_b_hotel_facilities_insert", lmParm);
// return 1;
//}
//public static int HotelInsert(CashBackEntity cashBackEntity)
//{
// if (cashBackEntity.CashBackDBEntity.Count == 0)
// {
// return 0;
// }
// if (cashBackEntity.LogMessages == null)
// {
// return 0;
// }
// CashBackDBEntity dbParm = (cashBackEntity.CashBackDBEntity.Count > 0) ? cashBackEntity.CashBackDBEntity[0] : new CashBackDBEntity();
// List<CommandInfo> sqlList = new List<CommandInfo>();
// CommandInfo UpdateCsHotelInfo = new CommandInfo();
// OracleParameter[] lmParm ={
// new OracleParameter("HOTELID",OracleType.VarChar)
// };
// lmParm[0].Value = dbParm.HotelID;
// UpdateCsHotelInfo.SqlName = "CashBack";
// UpdateCsHotelInfo.SqlId = "t_lm_b_hotel_service_save_update";
// UpdateCsHotelInfo.Parameters = lmParm;
// sqlList.Add(UpdateCsHotelInfo);
// //OracleParameter[] lmParm ={
// // new OracleParameter("ID",OracleType.Number),
// // new OracleParameter("NAMECN",OracleType.VarChar)
// // };
// //lmParm[0].Value = getMaxIDfromSeq("t_lm_b_facilities_hotel_SEQ");
// //lmParm[1].Value = dbParm.Name_CN;
// //DbManager.ExecuteSql("CashBack", "t_lm_b_hotel_service_save", lmParm);
// DbManager.ExecuteSqlTran(sqlList);
// return 1;
//}
//public static int Update(CashBackEntity cashBackEntity)
//{
// if (cashBackEntity.CashBackDBEntity.Count == 0)
// {
// return 0;
// }
// if (cashBackEntity.LogMessages == null)
// {
// return 0;
// }
// if (CheckUpdate(cashBackEntity) > 0)
// {
// return 2;
// }
// CashBackDBEntity dbParm = (cashBackEntity.CashBackDBEntity.Count > 0) ? cashBackEntity.CashBackDBEntity[0] : new CashBackDBEntity();
// OracleParameter[] parm ={
// new OracleParameter("ID",OracleType.Number),
// new OracleParameter("NAMECN",OracleType.VarChar),
// new OracleParameter("ONLINESTATUS",OracleType.VarChar)
// };
// parm[0].Value = dbParm.ID;
// parm[1].Value = dbParm.Name_CN;
// parm[2].Value = dbParm.Status;
// DbManager.ExecuteSql("CashBack", "t_lm_b_hotel_facilities_update", parm);
// return 1;
//}
//public static int CheckUpdate(CashBackEntity cashBackEntity)
//{
// OracleParameter[] parm ={
// new OracleParameter("ID",OracleType.Number),
// new OracleParameter("CHKNAME",OracleType.VarChar),
// new OracleParameter("TYPE",OracleType.VarChar)
// };
// CashBackDBEntity dbParm = (cashBackEntity.CashBackDBEntity.Count > 0) ? cashBackEntity.CashBackDBEntity[0] : new CashBackDBEntity();
// parm[0].Value = int.Parse(dbParm.ID.ToString());
// parm[1].Value = dbParm.Name_CN;
// if (dbParm.Type.Equals("0"))
// {
// parm[2].Value = "S";
// }
// else
// {
// parm[2].Value = "F";
// }
// cashBackEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("CashBack", "t_lm_b_hotel_facilities_update_check", parm);
// if (cashBackEntity.QueryResult.Tables.Count > 0 && cashBackEntity.QueryResult.Tables[0].Rows.Count > 0)
// {
// return 1;
// }
// return 0;
//}
public static int UpdateHotelSalesList(CashBackEntity cashBackEntity)
{
if (cashBackEntity.CashBackDBEntity.Count == 0)
{
return 0;
}
if (cashBackEntity.LogMessages == null)
{
return 0;
}
if (!CheckUpdate(cashBackEntity))
{
return 2;
}
CashBackDBEntity dbParm = (cashBackEntity.CashBackDBEntity.Count > 0) ? cashBackEntity.CashBackDBEntity[0] : new CashBackDBEntity();
OracleParameter[] lmParm ={
new OracleParameter("PHONE",OracleType.VarChar),
new OracleParameter("FAX",OracleType.VarChar),
new OracleParameter("CONTACTPER",OracleType.VarChar),
new OracleParameter("CONTACTEMAIL",OracleType.VarChar),
new OracleParameter("HOTELID",OracleType.VarChar)
//,
//new OracleParameter("USERCODE",OracleType.VarChar)
};
if (String.IsNullOrEmpty(dbParm.Phone))
{
lmParm[0].Value = DBNull.Value;
}
else
{
lmParm[0].Value = dbParm.Phone;
}
if (String.IsNullOrEmpty(dbParm.Fax))
{
lmParm[1].Value = DBNull.Value;
}
else
{
lmParm[1].Value = dbParm.Fax;
}
if (String.IsNullOrEmpty(dbParm.ContactPer))
{
lmParm[2].Value = DBNull.Value;
}
else
{
lmParm[2].Value = dbParm.ContactPer;
}
if (String.IsNullOrEmpty(dbParm.ContactEmail))
{
lmParm[3].Value = DBNull.Value;
}
else
{
lmParm[3].Value = dbParm.ContactEmail;
}
lmParm[4].Value = dbParm.HotelID;
//if (String.IsNullOrEmpty(dbParm.SalesID))
//{
// lmParm[5].Value = DBNull.Value;
//}
//else
//{
// lmParm[5].Value = dbParm.SalesID;
//}
DbManager.ExecuteSql("CashBack", "t_lm_b_hotel_sales_update", lmParm);
InsertSalesAndHistory(cashBackEntity);
UpdateLMSalesHistory(cashBackEntity);
return 1;
}
public static CashBackEntity EditAlipayName(CashBackEntity cashBackEntity)
{
OracleParameter[] parm ={
new OracleParameter("ALIPAYACCOUNTNAME",OracleType.VarChar),
new OracleParameter("SN",OracleType.VarChar)
};
CashBackDBEntity dbParm = (cashBackEntity.CashBackDBEntity.Count > 0) ? cashBackEntity.CashBackDBEntity[0] : new CashBackDBEntity();
if (String.IsNullOrEmpty(dbParm.AlipayName))
{
parm[0].Value = DBNull.Value;
}
else
{
parm[0].Value = dbParm.AlipayName;
}
if (String.IsNullOrEmpty(dbParm.Sn))
{
parm[1].Value = DBNull.Value;
}
else
{
parm[1].Value = dbParm.Sn;
}
cashBackEntity.Result= HotelVp.Common.DBUtility.DbManager.ExecuteSql("CashBack", "t_lm_cash_edit_alipayname", parm);
return cashBackEntity;
}
public static CashBackEntity EditAlipayName(CashBackEntity cashBackEntity)
{
cashBackEntity.LogMessages.MsgType = MessageType.INFO;
cashBackEntity.LogMessages.Content = _nameSpaceClass + "EditAlipayName";
LoggerHelper.LogWriter(cashBackEntity.LogMessages);
try
{
return CashBackDA.EditAlipayName(cashBackEntity);
}
catch (Exception ex)
{
cashBackEntity.LogMessages.MsgType = MessageType.ERROR;
cashBackEntity.LogMessages.Content = _nameSpaceClass + "EditAlipayName Error: " + ex.Message;
LoggerHelper.LogWriter(cashBackEntity.LogMessages);
throw ex;
}
}
public static CashBackEntity SaveCashBackRequest(CashBackEntity cashBackEntity)
{
cashBackEntity.LogMessages.MsgType = MessageType.INFO;
cashBackEntity.LogMessages.Content = _nameSpaceClass + "SaveCashBackRequest";
LoggerHelper.LogWriter(cashBackEntity.LogMessages);
try
{
CashBackDBEntity dbParm = (cashBackEntity.CashBackDBEntity.Count > 0) ? cashBackEntity.CashBackDBEntity[0] : new CashBackDBEntity();
if ("0".Equals(dbParm.BackInType))
{
DataSet dsResult = BindOrderInfo(cashBackEntity).QueryResult;
if (!"8".Equals(dsResult.Tables[0].Rows[0]["FOG_AUDITSTATUS"].ToString()))
{
cashBackEntity.Result = 2;
cashBackEntity.ErrorMSG = "该订单状态为非离店，不能提交申请，请确认！";
return cashBackEntity;
}
if (!"2".Equals(dsResult.Tables[0].Rows[0]["CashTaskStatus"].ToString()))
{
cashBackEntity.Result = 2;
cashBackEntity.ErrorMSG = "该订单已提交申请，不能重复提交，请确认！";
return cashBackEntity;
}
}
if (!CashBackDA.ChkBackCashVal(cashBackEntity))
{
cashBackEntity.Result = 2;
cashBackEntity.ErrorMSG = "申请提现金额不能大于用户可提现余额，请确认！";
return cashBackEntity;
}
cashBackEntity = CashBackSA.SaveCashBackRequest(cashBackEntity);
if (cashBackEntity.Result == 1)
{
CashBackDA.UpdateCashBackRequest(cashBackEntity);
//CashBackDA.UpdateCashBackHis(cashBackEntity);
CashBackDA.InsertCashBackHistory(cashBackEntity);
}
return cashBackEntity;
}
catch (Exception ex)
{
cashBackEntity.LogMessages.MsgType = MessageType.ERROR;
cashBackEntity.LogMessages.Content = _nameSpaceClass + "SaveCashBackRequest Error: " + ex.Message;
LoggerHelper.LogWriter(cashBackEntity.LogMessages);
throw ex;
}
}
public static CashBackEntity SaveCashBackRequest(CashBackEntity cashBackEntity)
{
string DataString = string.Empty;
CashBackDBEntity dbParm = (cashBackEntity.CashBackDBEntity.Count > 0) ? cashBackEntity.CashBackDBEntity[0] : new CashBackDBEntity();
//if ("0".Equals(dbParm.BackCashType))
//{
// DataString = "{\"loginMobile\":\"" + dbParm.UserID + "\"," + "\"amount\":" + dbParm.BackCashAmount + "," + "\"bankBranch\":\"" + dbParm.BankBranch + "\"," + "\"bankCardNumber\":\"" + dbParm.BankCardNumber + "\"," + "\"bankCardOwner\":\"" + dbParm.BankOwner + "\"}";
//}
//else
//{
// DataString = "{\"loginMobile\":\"" + dbParm.UserID + "\"," + "\"amount\":" + dbParm.BackCashAmount + "," + "\"bankBranch\":\"" + "999999" + "\"," + "\"bankCardNumber\":\"" + "999999" + "\"," + "\"bankCardOwner\":\"" + "999999" + "\"}";
//}
if ("0".Equals(dbParm.BackCashType))
{
DataString = "{\"loginMobile\":\"" + dbParm.UserID + "\"," + "\"amount\":" + dbParm.BackCashAmount + "," + "\"applyType\":" + "1" + "," + "\"bankBranch\":\"" + dbParm.BankBranch + "\"," + "\"bankCardNumber\":\"" + dbParm.BankCardNumber + "\"," + "\"bankCardOwner\":\"" + dbParm.BankOwner + "\"}";
}
else if ("1".Equals(dbParm.BackCashType))
{
DataString = "{\"loginMobile\":\"" + dbParm.UserID + "\"," + "\"amount\":" + dbParm.BackCashAmount + "," + "\"applyType\":" + "3" + "," + "\"rechargePhoneNumber\":\"" + dbParm.BackTel + "\"}";
}
else
{
DataString = "{\"loginMobile\":\"" + dbParm.UserID + "\"," + "\"amount\":" + dbParm.BackCashAmount + "," + "\"applyType\":" + "2" + "," + "\"alipayAccount\":\"" + dbParm.BackBao + "\"}";
}
string SaveCashBackRequestUrl = JsonRequestURLBuilder.SaveCashBackRequestV2() + PostSignKey(DataString);
CallWebPage callWebPage = new CallWebPage();
string strSaveCashBack = callWebPage.CallWebByURL(SaveCashBackRequestUrl, DataString);
JObject oSaveCashBack = JObject.Parse(strSaveCashBack);
if ("success".Equals(JsonRequestURLBuilder.GetJsonStringValue(oSaveCashBack, "message").Trim('"')))
{
cashBackEntity.Result = 1;
string oIDs = oSaveCashBack.SelectToken("result").ToString();
JObject oID = JObject.Parse(oIDs);
cashBackEntity.CashBackDBEntity[0].ID = oID.SelectToken("sn").ToString().Trim('"');
}
else
{
string ErrorMSG = JsonRequestURLBuilder.GetJsonStringValue(oSaveCashBack, "message").Trim('"');
cashBackEntity.ErrorMSG = ErrorMSG;
cashBackEntity.Result = 2;
}
return cashBackEntity;
}
public static CashBackEntity ExportBalanceRoomHistory(CashBackEntity cashBackEntity)
{
OracleParameter[] parm ={
new OracleParameter("HOTELID",OracleType.VarChar),
new OracleParameter("ROOMCD",OracleType.VarChar),
new OracleParameter("STARTDT",OracleType.VarChar),
new OracleParameter("ENDDT",OracleType.VarChar)
};
CashBackDBEntity dbParm = (cashBackEntity.CashBackDBEntity.Count > 0) ? cashBackEntity.CashBackDBEntity[0] : new CashBackDBEntity();
parm[0].Value = dbParm.HotelID;
if (String.IsNullOrEmpty(dbParm.HRoomList))
{
parm[1].Value = DBNull.Value;
}
else
{
parm[1].Value = dbParm.HRoomList;
}
if (String.IsNullOrEmpty(dbParm.InDateFrom))
{
parm[2].Value = DBNull.Value;
}
else
{
parm[2].Value = dbParm.InDateFrom;
}
if (String.IsNullOrEmpty(dbParm.InDateTo))
{
parm[3].Value = DBNull.Value;
}
else
{
parm[3].Value = dbParm.InDateTo;
}
DataSet dsResult = new DataSet();
DataSet dsRoomList = HotelVp.Common.DBUtility.DbManager.Query("CashBack", "t_lm_b_balancerom_roomlist", true, parm);
DataSet dsDataList = HotelVp.Common.DBUtility.DbManager.Query("CashBack", "t_lm_b_balancerom_select", true, parm);
System.Collections.Hashtable htRoomNm = new System.Collections.Hashtable();
dsResult.Tables.Add(new DataTable());
dsResult.Tables[0].Columns.Add("EFFECTDT");
foreach (DataRow drCol in dsRoomList.Tables[0].Rows)
{
dsResult.Tables[0].Columns.Add(drCol["rate_code"].ToString().ToUpper() + "-" + drCol["room_type_code"].ToString().ToUpper());
if (!htRoomNm.ContainsKey(drCol["rate_code"].ToString().ToUpper() + "-" + drCol["room_type_code"].ToString().ToUpper()))
{
htRoomNm.Add(drCol["rate_code"].ToString().ToUpper() + "-" + drCol["room_type_code"].ToString().ToUpper(), GetColsNameByRoomTypeCode(dbParm.HotelID, drCol["room_type_code"].ToString()));
}
}
string strDate = string.Empty;
foreach (DataRow drVal in dsDataList.Tables[0].Rows)
{
if (!strDate.Equals(drVal["EFFECTDATE"].ToString()))
{
strDate = drVal["EFFECTDATE"].ToString();
DataRow[] drList = dsDataList.Tables[0].Select("EFFECTDATE='" + strDate + "'");
if (drList.Count() == 0)
{
continue;
}
DataRow drRow = dsResult.Tables[0].NewRow();
drRow["EFFECTDT"] = strDate;
string strColNM = string.Empty;
foreach (DataRow drTemp in drList)
{
strColNM = drTemp["rate_code"].ToString().ToUpper() + "-" + drTemp["room_type_code"].ToString().ToUpper();
drRow[strColNM] = ("42".Equals(drTemp["commision_mode"].ToString())) ? drTemp["commision"].ToString() + "%" : drTemp["commision"].ToString() + "元";
}
dsResult.Tables[0].Rows.Add(drRow);
}
}
dsResult.Tables[0].Columns["EFFECTDT"].ColumnName = "日期/房型";
for (int i = 1; i < dsResult.Tables[0].Columns.Count; i++)
{
dsResult.Tables[0].Columns[i].ColumnName = dsResult.Tables[0].Columns[i].ColumnName.Substring(0, dsResult.Tables[0].Columns[i].ColumnName.IndexOf('-') + 1) + htRoomNm[dsResult.Tables[0].Columns[i].ColumnName].ToString();
}
cashBackEntity.QueryResult = dsResult;
return cashBackEntity;
}
public static int InsertBalanceHistory(CashBackEntity cashBackEntity)
{
CashBackDBEntity dbParm = (cashBackEntity.CashBackDBEntity.Count > 0) ? cashBackEntity.CashBackDBEntity[0] : new CashBackDBEntity();
string[] RoomList = dbParm.HRoomList.Split(',');
DateTime InDateFrom = DateTime.Parse(dbParm.InDateFrom);
DateTime InDateTo = DateTime.Parse(dbParm.InDateTo);
//dbParm.InDateFrom dbParm.InDateTo
while (InDateFrom <= InDateTo)
{
foreach (string room in RoomList)
{
if (String.IsNullOrEmpty(room.Trim()))
{
continue;
}
DataCommand cmd = DataCommandManager.GetDataCommand("InsertBalanceHistory");
cmd.SetParameterValue("@HotelID", dbParm.HotelID);
cmd.SetParameterValue("@PriceCode", dbParm.PriceCode);
cmd.SetParameterValue("@RoomCode", room);
cmd.SetParameterValue("@InDate", InDateFrom.ToShortDateString());
cmd.SetParameterValue("@BalType", dbParm.BalType);
cmd.SetParameterValue("@BalValue", dbParm.BalValue);
cmd.SetParameterValue("@CreateUser", cashBackEntity.LogMessages.Username);
cmd.ExecuteNonQuery();
}
InDateFrom = InDateFrom.AddDays(1);
}
return 1;
}
public static int HotelSave(CashBackEntity cashBackEntity)
{
if (cashBackEntity.CashBackDBEntity.Count == 0)
{
return 0;
}
if (cashBackEntity.LogMessages == null)
{
return 0;
}
string strSQLString = "";
if (CheckInsert(cashBackEntity) > 0)
{
strSQLString = "t_lm_b_hotelinfo_update";
}
else
{
strSQLString = "t_lm_b_hotelinfo_insert";
}
CashBackDBEntity dbParm = (cashBackEntity.CashBackDBEntity.Count > 0) ? cashBackEntity.CashBackDBEntity[0] : new CashBackDBEntity();
OracleParameter[] lmParm ={
new OracleParameter("HOTELID",OracleType.VarChar),
new OracleParameter("HOTELNM",OracleType.VarChar),
new OracleParameter("GROUPID",OracleType.VarChar),
new OracleParameter("STARRATING",OracleType.VarChar),
new OracleParameter("DIAMONDRATING",OracleType.VarChar),
new OracleParameter("CITYID",OracleType.VarChar),
new OracleParameter("OPENDATE",OracleType.VarChar),
new OracleParameter("REPAIRDATE",OracleType.VarChar),
new OracleParameter("ADDRESS",OracleType.VarChar),
new OracleParameter("WEBSITE",OracleType.VarChar),
//new OracleParameter("PHONE",OracleType.VarChar),
//new OracleParameter("FAX",OracleType.VarChar),
//new OracleParameter("CONTACTPER",OracleType.VarChar),
//new OracleParameter("CONTACTEMAIL",OracleType.VarChar),
new OracleParameter("SIMPLEDESCZH",OracleType.VarChar),
new OracleParameter("DESCZH",OracleType.VarChar),
new OracleParameter("EVALUATION",OracleType.VarChar),
new OracleParameter("ONLINESTATUS",OracleType.VarChar),
new OracleParameter("AUTOTRUST",OracleType.VarChar),
new OracleParameter("FOGSTATUS",OracleType.VarChar),
new OracleParameter("HOTELNMEN",OracleType.VarChar),
new OracleParameter("LONGITUDE",OracleType.VarChar),
new OracleParameter("LATITUDE",OracleType.VarChar)
};
lmParm[0].Value = dbParm.HotelID;
lmParm[1].Value = dbParm.Name_CN;
lmParm[2].Value = dbParm.HotelGroup;
lmParm[3].Value = dbParm.StarRating;
lmParm[4].Value = dbParm.DiamondRating;
lmParm[5].Value = dbParm.City;
lmParm[6].Value = dbParm.OpenDate;
lmParm[7].Value = dbParm.RepairDate;
if (String.IsNullOrEmpty(dbParm.AddRess))
{
lmParm[8].Value = DBNull.Value;
}
else
{
lmParm[8].Value = dbParm.AddRess;
}
if (String.IsNullOrEmpty(dbParm.WebSite))
{
lmParm[9].Value = DBNull.Value;
}
else
{
lmParm[9].Value = dbParm.WebSite;
}
//if (String.IsNullOrEmpty(dbParm.Phone))
//{
// lmParm[10].Value = DBNull.Value;
//}
//else
//{
// lmParm[10].Value = dbParm.Phone;
//}
//if (String.IsNullOrEmpty(dbParm.Fax))
//{
// lmParm[11].Value = DBNull.Value;
//}
//else
//{
// lmParm[11].Value = dbParm.Fax;
//}
//if (String.IsNullOrEmpty(dbParm.ContactPer))
//{
// lmParm[12].Value = DBNull.Value;
//}
//else
//{
// lmParm[12].Value = dbParm.ContactPer;
//}
//if (String.IsNullOrEmpty(dbParm.ContactEmail))
//{
// lmParm[13].Value = DBNull.Value;
//}
//else
//{
// lmParm[13].Value = dbParm.ContactEmail;
//}
if (String.IsNullOrEmpty(dbParm.SimpleDescZh))
{
lmParm[10].Value = DBNull.Value;
}
else
{
lmParm[10].Value = dbParm.SimpleDescZh;
}
if (String.IsNullOrEmpty(dbParm.DescZh))
{
lmParm[11].Value = DBNull.Value;
}
else
{
lmParm[11].Value = dbParm.DescZh;
}
if (String.IsNullOrEmpty(dbParm.Evaluation))
{
lmParm[12].Value = DBNull.Value;
}
else
{
lmParm[12].Value = dbParm.Evaluation;
}
if (String.IsNullOrEmpty(dbParm.Status))
{
lmParm[13].Value = DBNull.Value;
}
else
{
lmParm[13].Value = dbParm.Status;
}
lmParm[14].Value = dbParm.AutoTrust;
lmParm[15].Value = dbParm.FogStatus;
if (String.IsNullOrEmpty(dbParm.Name_EN))
{
lmParm[16].Value = DBNull.Value;
}
else
{
lmParm[16].Value = dbParm.Name_EN;
}
lmParm[17].Value = dbParm.Longitude;
lmParm[18].Value = dbParm.Latitude;
DbManager.ExecuteSql("CashBack", strSQLString, lmParm);
return 1;
}
public static CashBackEntity GetSalesManagerSettingHistory(CashBackEntity cashBackEntity)
{
CashBackDBEntity dbParm = (cashBackEntity.CashBackDBEntity.Count > 0) ? cashBackEntity.CashBackDBEntity[0] : new CashBackDBEntity();
DataCommand cmd = DataCommandManager.GetDataCommand("GetSalesManagerSettingHistory");
cmd.SetParameterValue("@HotelID", dbParm.HotelID);
cashBackEntity.QueryResult = cmd.ExecuteDataSet();
return cashBackEntity;
}
public static CashBackEntity GetSalesManager(CashBackEntity cashBackEntity)
{
DataCommand cmd = DataCommandManager.GetDataCommand("GetSalesManagerHistory");
cmd.SetParameterValue("@HotelID", cashBackEntity.CashBackDBEntity[0].HotelID);
cashBackEntity.QueryResult = cmd.ExecuteDataSet();
return cashBackEntity;
}
public static CashBackEntity GetCashBackHistoryByEventHistory(CashBackEntity cashBackEntity)
{
CashBackDBEntity dbParm = (cashBackEntity.CashBackDBEntity.Count > 0) ? cashBackEntity.CashBackDBEntity[0] : new CashBackDBEntity();
DataCommand cmd = DataCommandManager.GetDataCommand("GetCashBackHistoryByEventHistory");
cmd.SetParameterValue("@EVENTID", dbParm.Sn);
cmd.SetParameterValue("@EVENTTYPE", dbParm.Type);
cashBackEntity.QueryResult = cmd.ExecuteDataSet();
return cashBackEntity;
}
public static CashBackEntity SetBalanceRoomList(CashBackEntity cashBackEntity)
{
CashBackDBEntity dbParm = (cashBackEntity.CashBackDBEntity.Count > 0) ? cashBackEntity.CashBackDBEntity[0] : new CashBackDBEntity();
string[] strRoomList = dbParm.HRoomList.Split(',');
string HotelID = dbParm.HotelID;
string RoomCode = "";
string msg = string.Empty;
foreach (string strRoomCode in strRoomList)
{
if (String.IsNullOrEmpty(strRoomCode))
{
continue;
}
RoomCode = RoomCode + strRoomCode + "-" + dbParm.PriceCode + ",";
}
RoomCode = RoomCode.Trim(',');
string DataString = "{\"dateType\":\"" + "1" + "\"," + "\"beginDate\":\"" + dbParm.InDateFrom + "\"," + "\"endDate\":\"" + dbParm.InDateTo + "\"," + "\"hotelIds\":\"" + dbParm.HotelID + "\"," + "\"roomCodes\":\"" + RoomCode + "\"," + "\"commisionMode\":\"" + dbParm.BalType + "\"," + "\"commision\":\"" + dbParm.BalValue + "\"}";
string HotelBalRoomUrl = JsonRequestURLBuilder.applyHotelBalRoomV2();
CallWebPage callWebPage = new CallWebPage();
string strHotelBalRoom = callWebPage.CallWebByURL(HotelBalRoomUrl, DataString);
JObject oHotelBalRoom = JObject.Parse(strHotelBalRoom);
if ("success".Equals(JsonRequestURLBuilder.GetJsonStringValue(oHotelBalRoom, "message").Trim('"')))
{
cashBackEntity.Result = 1;
}
else
{
string ErrorMSG = JsonRequestURLBuilder.GetJsonStringValue(oHotelBalRoom, "message").Trim('"');
cashBackEntity.ErrorMSG = ErrorMSG;
cashBackEntity.Result = 2;
}
return cashBackEntity;
}
public static int InsertCashBackHistory(CashBackEntity cashBackEntity)
{
CashBackDBEntity dbParm = (cashBackEntity.CashBackDBEntity.Count > 0) ? cashBackEntity.CashBackDBEntity[0] : new CashBackDBEntity();
DataCommand cmd = DataCommandManager.GetDataCommand("InsertCashBackHistory");
cmd.SetParameterValue("@HotelID", dbParm.HotelID);
cmd.SetParameterValue("@OrderNo", dbParm.OrderNo);
cmd.SetParameterValue("@UserID", dbParm.UserID);
cmd.SetParameterValue("@CashSN", dbParm.ID);
cmd.SetParameterValue("@CreateUser", cashBackEntity.LogMessages.Username);
return cmd.ExecuteNonQuery();
}
public static CashBackEntity BindHotelImagesList(CashBackEntity cashBackEntity)
{
ArrayList ayHotelImage = new ArrayList();
CashBackDBEntity dbParm = (cashBackEntity.CashBackDBEntity.Count > 0) ? cashBackEntity.CashBackDBEntity[0] : new CashBackDBEntity();
string phoneUser = ConfigurationManager.AppSettings["phoneUser"]; //全局User
string phoneKey = ConfigurationManager.AppSettings["phoneKey"]; //全局Key
string checkInDate = string.Format("{0:yyyy-MM-dd}", DateTime.Now);
//// 酒店图片信息取得
//string HotelImagesUrl = JsonRequestURLBuilder.queryHotelImages(dbParm.HotelID, "200");
//string strHotelImages = CommonCallWebUrl(HotelImagesUrl);
//JObject oimage = JObject.Parse(strHotelImages);
//JObject oHotelImages = (JObject)oimage.SelectToken("HotelImageRS[0]");
//string oHotelImagesDetail = (oimage.SelectToken("HotelImageRS[0].gallery")!= null) ? oimage.SelectToken("HotelImageRS[0].gallery").ToString() : "";
//if (!String.IsNullOrEmpty(oHotelImagesDetail))
//{
// int index0 = oHotelImagesDetail.IndexOf("[");
// if (index0 == 0)
// {
// JArray jsa = (JArray)JsonConvert.DeserializeObject(oHotelImagesDetail);
// int iCount = 0;
// for (int i = 0; i < jsa.Count; i++)
// {
// JObject jso = (JObject)jsa[i];
// ayHotelImage.Add(JsonRequestURLBuilder.GetJsonStringValue(jso, "imageurl").Trim('"'));
// iCount = iCount + 1;
// if (iCount == 10)
// {
// break;
// }
// }
// }
// else
// {
// JObject jsooHotelImagesDetail = (JObject)JsonConvert.DeserializeObject(oHotelImagesDetail);
// ayHotelImage.Add(JsonRequestURLBuilder.GetJsonStringValue(jsooHotelImagesDetail, "imageurl").Trim('"'));
// }
//}
//cashBackEntity.CashBackDBEntity[0].HotelImage = ayHotelImage;
//return cashBackEntity;
// 酒店图片信息取得
string HotelImagesUrl = JsonRequestURLBuilder.queryHotelImagesV2(dbParm.HotelID, "200");
string strHotelImages = CommonCallWebUrl(HotelImagesUrl);
JObject oimage = JObject.Parse(strHotelImages);
string oHotelImagesDetail = (oimage.SelectToken("result") != null) ? oimage.SelectToken("result").ToString() : "";
if (!String.IsNullOrEmpty(oHotelImagesDetail))
{
int index0 = oHotelImagesDetail.IndexOf("[");
if (index0 == 0)
{
JArray jsa = (JArray)JsonConvert.DeserializeObject(oHotelImagesDetail);
int iCount = 0;
for (int i = 0; i < jsa.Count; i++)
{
JObject jso = (JObject)jsa[i];
ayHotelImage.Add(JsonRequestURLBuilder.GetJsonStringValue(jso, "imageurl").Trim('"'));
iCount = iCount + 1;
if (iCount == 10)
{
break;
}
}
}
else
{
JObject jsooHotelImagesDetail = (JObject)JsonConvert.DeserializeObject(oHotelImagesDetail);
ayHotelImage.Add(JsonRequestURLBuilder.GetJsonStringValue(jsooHotelImagesDetail, "imageurl").Trim('"'));
}
}
cashBackEntity.CashBackDBEntity[0].HotelImage = ayHotelImage;
return cashBackEntity;
}
public static int InsertLMSalesHistory(CashBackEntity cashBackEntity)
{
CashBackDBEntity dbParm = (cashBackEntity.CashBackDBEntity.Count > 0) ? cashBackEntity.CashBackDBEntity[0] : new CashBackDBEntity();
OracleParameter[] lmParm ={
new OracleParameter("HOTELID",OracleType.VarChar),
new OracleParameter("SALESID",OracleType.VarChar)
};
lmParm[0].Value = dbParm.HotelID;
if (String.IsNullOrEmpty(dbParm.SalesID))
{
lmParm[1].Value = DBNull.Value;
}
else
{
lmParm[1].Value = dbParm.SalesID;
}
DbManager.ExecuteSql("CashBack", "t_lm_sales_history_save", lmParm);
return 1;
}
public static CashBackEntity GetCashBackHistoryByEventHistory(CashBackEntity cashBackEntity)
{
cashBackEntity.LogMessages.MsgType = MessageType.INFO;
cashBackEntity.LogMessages.Content = _nameSpaceClass + "GetCashBackHistoryByEventHistory";
LoggerHelper.LogWriter(cashBackEntity.LogMessages);
try
{
return CashBackDA.GetCashBackHistoryByEventHistory(cashBackEntity);
}
catch (Exception ex)
{
cashBackEntity.LogMessages.MsgType = MessageType.ERROR;
cashBackEntity.LogMessages.Content = _nameSpaceClass + "GetCashBackHistoryByEventHistory Error: " + ex.Message;
LoggerHelper.LogWriter(cashBackEntity.LogMessages);
throw ex;
}
}
public static int InsertSalesAndHistory(CashBackEntity cashBackEntity)
{
CashBackDBEntity dbParm = (cashBackEntity.CashBackDBEntity.Count > 0) ? cashBackEntity.CashBackDBEntity[0] : new CashBackDBEntity();
DataCommand cmd = DataCommandManager.GetDataCommand("InsertSalesAndHistory");
cmd.SetParameterValue("@HotelID", dbParm.HotelID);
cmd.SetParameterValue("@UserCode", dbParm.SalesID);
cmd.SetParameterValue("@StartDTime", dbParm.SalesStartDT);
cmd.SetParameterValue("@EndDTime", dbParm.SalesEndDT);
cmd.SetParameterValue("@CreateUser", cashBackEntity.LogMessages.Username);
cmd.SetParameterValue("@Fax", dbParm.Fax);
cmd.SetParameterValue("@Per", dbParm.ContactPer);
cmd.SetParameterValue("@Tel", dbParm.Phone);
cmd.SetParameterValue("@Email", dbParm.ContactEmail);
return cmd.ExecuteNonQuery(); ;
}
public static int UpdateHotelSalesList(CashBackEntity cashBackEntity)
{
cashBackEntity.LogMessages.MsgType = MessageType.INFO;
cashBackEntity.LogMessages.Content = _nameSpaceClass + "UpdateHotelSalesList";
LoggerHelper.LogWriter(cashBackEntity.LogMessages);
try
{
return CashBackDA.UpdateHotelSalesList(cashBackEntity);
}
catch (Exception ex)
{
cashBackEntity.LogMessages.MsgType = MessageType.ERROR;
cashBackEntity.LogMessages.Content = _nameSpaceClass + "UpdateHotelSalesList Error: " + ex.Message;
throw ex;
}
}
public static CashBackEntity UpdateCashBackHis(CashBackEntity cashBackEntity)
{
CashBackDBEntity dbParm = (cashBackEntity.CashBackDBEntity.Count > 0) ? cashBackEntity.CashBackDBEntity[0] : new CashBackDBEntity();
OracleParameter[] parm ={
new OracleParameter("SN",OracleType.VarChar)
};
parm[0].Value = dbParm.ID;
DbManager.ExecuteSql("CashBack", "t_lm_cash_his_info_update", parm);
return cashBackEntity;
}
public static CashBackEntity UpdateCashBackRequest(CashBackEntity cashBackEntity)
{
CashBackDBEntity dbParm = (cashBackEntity.CashBackDBEntity.Count > 0) ? cashBackEntity.CashBackDBEntity[0] : new CashBackDBEntity();
OracleParameter[] parm ={
new OracleParameter("SN",OracleType.VarChar),
new OracleParameter("BANKNAME",OracleType.VarChar),
new OracleParameter("BANKBRANCH",OracleType.VarChar),
new OracleParameter("BANKCARDNUMBER",OracleType.VarChar),
new OracleParameter("BANKCARDOWNER",OracleType.VarChar),
new OracleParameter("PHONENUMBER",OracleType.VarChar),
new OracleParameter("ALIPAYACCOUNT",OracleType.VarChar),
new OracleParameter("REMARK",OracleType.VarChar),
new OracleParameter("APPLYTYPE",OracleType.VarChar),
new OracleParameter("USERNAME",OracleType.VarChar)
};
parm[0].Value = dbParm.ID;
if ("0".Equals(dbParm.BackCashType))
{
parm[1].Value = dbParm.BankName;
parm[2].Value = dbParm.BankBranch;
parm[3].Value = dbParm.BankCardNumber;
parm[4].Value = dbParm.BankOwner;
parm[5].Value = DBNull.Value;
parm[6].Value = DBNull.Value;
parm[9].Value = DBNull.Value;
}
else if ("1".Equals(dbParm.BackCashType))
{
parm[1].Value = DBNull.Value;
parm[2].Value = DBNull.Value;
parm[3].Value = DBNull.Value;
parm[4].Value = DBNull.Value;
parm[5].Value = dbParm.BackTel;
parm[6].Value = DBNull.Value;
parm[9].Value = DBNull.Value;
}
else if ("2".Equals(dbParm.BackCashType))
{
parm[1].Value = DBNull.Value;
parm[2].Value = DBNull.Value;
parm[3].Value = DBNull.Value;
parm[4].Value = DBNull.Value;
parm[5].Value = DBNull.Value;
parm[6].Value = dbParm.BackBao;
parm[9].Value = dbParm.BackBaoName;
}
parm[7].Value = dbParm.Remark;
if ("0".Equals(dbParm.BackCashType))
{
parm[8].Value = "1";
}
else if ("1".Equals(dbParm.BackCashType))
{
parm[8].Value = "3";
}
else if ("2".Equals(dbParm.BackCashType))
{
parm[8].Value = "2";
}
DbManager.ExecuteSql("CashBack", "t_lm_cash_info_update", parm);
return cashBackEntity;
}
public static CashBackEntity CommonProvincialSelect(CashBackEntity cashBackEntity)
{
cashBackEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("CashBack", "t_lm_b_common_provinciallist", false);
return cashBackEntity;
}
