/// <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; }