internal int InsertOrUpdate(B2b_Finance model) { var cmd = sqlHelper.PrepareStoredSqlCommand(SQLInsertOrUpdate); cmd.AddParam("@Id", model.Id); cmd.AddParam("@Com_id", model.Com_id); cmd.AddParam("@Agent_id", model.Agent_id); cmd.AddParam("@Eid", model.Eid); cmd.AddParam("@Order_id", model.Order_id); cmd.AddParam("@Servicesname", model.Servicesname); cmd.AddParam("@SerialNumber", model.SerialNumber); cmd.AddParam("@Money", model.Money); cmd.AddParam("@Money_come", model.Money_come); cmd.AddParam("@Over_money", model.Over_money); cmd.AddParam("@Payment", model.Payment); cmd.AddParam("@Payment_type", model.Payment_type); cmd.AddParam("@Paychannelstate", model.Paychannelstate); cmd.AddParam("@Channelid", model.Channelid); var parm = cmd.AddReturnValueParameter("ReturnValue"); cmd.ExecuteNonQuery(); //修改预付款+ UpdateImprest(model.Com_id, model.Money); return((int)parm.Value); }
internal int InsertOrUpdateFinancePayType(B2b_Finance model) { var cmd = sqlHelper.PrepareStoredSqlCommand(SQLInsertOrUpdatePayType); cmd.AddParam("@Id", model.Id); cmd.AddParam("@Com_id", model.Com_id); cmd.AddParam("@Paytype", model.Paytype); var parm = cmd.AddReturnValueParameter("ReturnValue"); cmd.ExecuteNonQuery(); return((int)parm.Value); }
public int InsertOrUpdateFinancePayType(B2b_Finance payinfo) { using (var sql = new SqlHelper()) { try { var internalData = new InternalB2BFinance(sql); int result = internalData.InsertOrUpdateFinancePayType(payinfo); return(result); } catch { throw; } } }
public static string ModifyFinancePayType(B2b_Finance fdateinfo) { try { B2bFinanceData fdate = new B2bFinanceData(); var id = fdate.InsertOrUpdateFinancePayType(fdateinfo); return(JsonConvert.SerializeObject(new { type = 100, msg = id })); } catch (Exception ex) { return(JsonConvert.SerializeObject(new { type = 1, msg = ex.Message })); throw; } }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; string oper = context.Request["oper"].ConvertTo <string>(""); if (oper != "") { if (oper == "selhotelprojectlist") { var comid = context.Request["comid"].ConvertTo <int>(0); string data = FinanceJsonData.Selhotelprojectlist(comid); context.Response.Write(data); } if (oper == "selhotelproductlist") { var comid = context.Request["comid"].ConvertTo <int>(0); var projectid = context.Request["projectid"].ConvertTo <int>(0); string data = FinanceJsonData.Selhotelproductlist(comid, projectid); context.Response.Write(data); } if (oper == "selprojectlist") { var comid = context.Request["comid"].ConvertTo <int>(0); string data = FinanceJsonData.Selprojectlist(comid); context.Response.Write(data); } if (oper == "HotelOrderlist") { var comid = context.Request["comid"].ConvertTo <int>(0); var begindate = context.Request["begindate"].ConvertTo <string>(""); var enddate = context.Request["enddate"].ConvertTo <string>(""); var productid = context.Request["productid"].ConvertTo <int>(0); var orderstate = context.Request["orderstate"].ConvertTo <string>(""); string data = FinanceJsonData.HotelOrderlist(comid, begindate, enddate, productid, orderstate); context.Response.Write(data); } if (oper == "HotelOrderStat") { var comid = context.Request["comid"].ConvertTo <int>(0); var begindate = context.Request["begindate"].ConvertTo <string>(""); var enddate = context.Request["enddate"].ConvertTo <string>(""); var projectid = context.Request["projectid"].ConvertTo <int>(0); var productid = context.Request["productid"].ConvertTo <int>(0); var key = context.Request["key"].ConvertTo <string>(""); var orderstate = context.Request["orderstate"].ConvertTo <string>(""); string data = FinanceJsonData.HotelOrderStat(comid, begindate, enddate, projectid, productid, key, orderstate); context.Response.Write(data); } if (oper == "FinanceStat") { var comid = context.Request["comid"].ConvertTo <int>(0); var begindate = context.Request["begindate"].ConvertTo <string>(""); var enddate = context.Request["enddate"].ConvertTo <string>(""); var projectid = context.Request["projectid"].ConvertTo <int>(0); var productid = context.Request["productid"].ConvertTo <int>(0); string data = FinanceJsonData.FinanceStat(comid, begindate, enddate, projectid, productid); context.Response.Write(data); } if (oper == "Selpayment_type") { string data = FinanceJsonData.Selpayment_type(); context.Response.Write(data); } if (oper == "Selmoney_come") { string data = FinanceJsonData.Selmoney_come(); context.Response.Write(data); } if (oper == "issetfinancepaytype") { var comid = context.Request["comid"].ConvertTo <int>(0); var data = "{\"type\":\"1\",\"msg\":\"\"}"; if (comid == 0) { data = "{\"type\":\"1\",\"msg\":\"传参数失败\"}"; } B2b_finance_paytype model = new B2b_finance_paytypeData().GetFinancePayTypeByComid(comid); if (model != null) { //TxtHelper.WriteFile("D:\\site\\b2betown\\ETS2.WebApp\\Log.txt", "c"); //商家微信支付的所有参数都存在 if (model.Wx_appid != "" && model.Wx_appkey != "" && model.Wx_partnerid != "" && model.Wx_paysignkey != "") { data = "{\"type\":\"100\",\"msg\":\"\"}"; } else { data = "{\"type\":\"1\",\"msg\":\"微信财务参数设置不完全\"}"; } } else { data = "{\"type\":\"1\",\"msg\":\"微信财务参数没有设置\"}"; } TxtHelper.WriteFile("D:\\site\\b2betown\\ETS2.WebApp\\Log.txt", data); context.Response.Write(data); } if (oper == "Financelist") { var comid = context.Request["comid"]; var pageindex = context.Request["pageindex"].ConvertTo <int>(1); var pagesize = context.Request["pagesize"].ConvertTo <int>(10); var key = context.Request["key"].ConvertTo <string>(""); string data = FinanceJsonData.FinancePageList(comid, pageindex, pagesize, key); context.Response.Write(data); } if (oper == "Financecount") { var comid = context.Request["comid"]; var stardate = context.Request["stardate"].ConvertTo <string>(DateTime.Now.ToString("yyyy-MM-dd")); var enddate = context.Request["enddate"].ConvertTo <string>(DateTime.Now.ToString("yyyy-MM-dd")); string data = FinanceJsonData.Financecount(comid, stardate, enddate); context.Response.Write(data); } if (oper == "ChannelFlist") { var comid = context.Request["comid"]; var pageindex = context.Request["pageindex"].ConvertTo <int>(1); var pagesize = context.Request["pagesize"].ConvertTo <int>(10); var channelcompanyid = context.Request["channelcompanyid"].ConvertTo <int>(0); var key = context.Request["key"].ConvertTo <string>(""); string data = FinanceJsonData.ChannelFPageList(comid, pageindex, pagesize, key, channelcompanyid); context.Response.Write(data); } if (oper == "ChannelFcount") { var comid = context.Request["comid"].ConvertTo <int>(0); var channelcompanyid = context.Request["channelcompanyid"].ConvertTo <int>(0); string data = FinanceJsonData.GetChannelFinanceCount(comid, channelcompanyid); context.Response.Write(data); } if (oper == "MasterFinancelist") { var comid = "999999"; var pageindex = context.Request["pageindex"].ConvertTo <int>(1); var pagesize = context.Request["pagesize"].ConvertTo <int>(10); var key = context.Request["key"].ConvertTo <string>(""); string data = FinanceJsonData.FinancePageList(comid, pageindex, pagesize, key); context.Response.Write(data); } //获取所有财务记录,并获取 支付宝财务通对账号 if (oper == "ComFinancelist") { var comid = "999999"; var pageindex = context.Request["pageindex"].ConvertTo <int>(1); var pagesize = context.Request["pagesize"].ConvertTo <int>(10); var key = context.Request["key"].ConvertTo <string>(""); var oid = context.Request["oid"].ConvertTo <int>(0); var payment_type = context.Request["payment_type"].ConvertTo <string>(""); var money_come = context.Request["money_come"].ConvertTo <string>(""); var starttime = context.Request["starttime"].ConvertTo <string>(""); var endtime = context.Request["endtime"].ConvertTo <string>(""); string data = FinanceJsonData.ComFinancePageList(comid, pageindex, pagesize, key, oid, payment_type, money_come, starttime, endtime); context.Response.Write(data); } if (oper == "WithdrawConf") { int comid = context.Request["comid"].ConvertTo <int>(0); int id = context.Request["id"].ConvertTo <int>(0); string remarks = context.Request["remarks"].ConvertTo <string>(""); int printscreen = context.Request["printscreen"].ConvertTo <int>(0); string data = ""; try { data = FinanceJsonData.WithdrawConf(id, comid, remarks, printscreen); } catch { data = ""; } context.Response.Write(data); } if (oper == "getpaytype") { int comid = context.Request["comid"].ConvertTo <int>(0); string data = "";//获取公司基本信息和扩展信息 try { data = FinanceJsonData.FinancePayType(comid); } catch { data = ""; } context.Response.Write(data); } //修改支付方式 if (oper == "editpaytype") { int id = context.Request["id"].ConvertTo <int>(0); int comid = context.Request["comid"].ConvertTo <int>(0); int act = context.Request["act"].ConvertTo <int>(0); int paytype = Int32.Parse(context.Request["paytype"]); B2b_Finance findate = new B2b_Finance() { Id = id, Com_id = comid, Act = act, Paytype = paytype }; var data = FinanceJsonData.ModifyFinancePayType(findate); context.Response.Write(data); } //提现 if (oper == "Withdraw") { int id = context.Request["id"].ConvertTo <int>(0); int comid = context.Request["comid"].ConvertTo <int>(0); decimal money = 0 - context.Request["money"].ConvertTo <decimal>(0);//提现直接为负数 string bank_account = context.Request["bank_account"]; string bank_card = context.Request["bank_card"]; string bank_name = context.Request["bank_name"]; //得到商家信息,账户余额 B2b_company modelcom = B2bCompanyData.GetCompany(comid); decimal Over_money = modelcom.Imprest + money; B2b_Finance findate = new B2b_Finance() { Id = id, Com_id = comid, Money = money, Money_come = bank_account, Servicesname = bank_account + ":" + bank_card + ":" + bank_name, Payment = 1, SerialNumber = DateTime.Now.ToString("yyyyMMddhhmmssfff"), Payment_type = "商家提现", Over_money = Over_money }; var data = FinanceJsonData.ModifyFinanceWithdraw(findate); context.Response.Write(data); } //修改支付银行状态 if (oper == "Upbanktype") { int comid = context.Request["comid"].ConvertTo <int>(0); int type = context.Request["type"].ConvertTo <int>(0); var data = ""; B2bFinanceData fdate = new B2bFinanceData(); B2b_finance_paytype com = fdate.FinancePayType(comid); if (com != null) { com.Uptype = type; data = FinanceJsonData.ModifyFinancePayBank(com); } context.Response.Write(data); } //修改支付银行 if (oper == "editpaybank") { int id = context.Request["id"].ConvertTo <int>(0); int comid = context.Request["comid"].ConvertTo <int>(0); int paytype = Int32.Parse(context.Request["paytype"]); string bank_account = context.Request["bank_account"]; string bank_card = context.Request["bank_card"]; string bank_name = context.Request["bank_name"]; string alipay_account = context.Request["alipay_account"]; string alipay_id = context.Request["alipay_id"]; string alipay_key = context.Request["alipay_key"]; bool type = context.Request["type"].ConvertTo <bool>(false); int Uptype = 0; if (type == true) { Uptype = 1; } B2b_finance_paytype findate = new B2b_finance_paytype() { Id = id, Com_id = comid, Bank_account = bank_account, Bank_card = bank_card, Bank_name = bank_name, Alipay_account = alipay_account, Alipay_id = alipay_id, Alipay_key = alipay_key, Paytype = paytype, Uptype = Uptype, }; var data = FinanceJsonData.ModifyFinancePayBank(findate); context.Response.Write(data); } //修改微信支付设置 if (oper == "editpaywx") { int id = context.Request["id"].ConvertTo <int>(0); int comid = context.Request["comid"].ConvertTo <int>(0); string appid = context.Request["appid"]; string appkey = context.Request["appkey"]; string paysignkey = context.Request["paysignkey"]; string partnerid = context.Request["partnerid"]; string partnerkey = context.Request["partnerkey"]; string wx_SSLCERT_PATH = context.Request["wx_SSLCERT_PATH"].ConvertTo <string>(""); string wx_SSLCERT_PASSWORD = context.Request["wx_SSLCERT_PASSWORD"].ConvertTo <string>(""); B2b_finance_paytype findate2 = new B2b_finance_paytype() { Id = id, Com_id = comid, Wx_appid = appid, Wx_appkey = appkey, Wx_partnerid = partnerid, Wx_paysignkey = paysignkey, Wx_partnerkey = partnerkey, wx_SSLCERT_PATH = wx_SSLCERT_PATH, wx_SSLCERT_PASSWORD = wx_SSLCERT_PASSWORD }; var data = FinanceJsonData.ModifyFinancePayWX(findate2); context.Response.Write(data); } if (oper == "integrallist") { var comid = context.Request["comid"].ConvertTo <int>(0); int pageindex = context.Request["pageindex"].ConvertTo <int>(1); int pagesize = context.Request["pagesize"].ConvertTo <int>(10); string key = context.Request["key"].ConvertTo <string>(""); string data = FinanceJsonData.IntegralList(pageindex, pagesize, comid, key); context.Response.Write(data); //context.Response.Write("Hello World"); } if (oper == "integralcount") { var comid = context.Request["comid"].ConvertTo <int>(0); string data = FinanceJsonData.IntegralCount(comid); context.Response.Write(data); //context.Response.Write("Hello World"); } if (oper == "imprestlist") { var comid = context.Request["comid"].ConvertTo <int>(0); int pageindex = context.Request["pageindex"].ConvertTo <int>(1); int pagesize = context.Request["pagesize"].ConvertTo <int>(10); string key = context.Request["key"].ConvertTo <string>(""); string data = FinanceJsonData.ImprestList(pageindex, pagesize, comid, key); context.Response.Write(data); //context.Response.Write("Hello World"); } if (oper == "imprestcount") { var comid = context.Request["comid"].ConvertTo <int>(0); string data = FinanceJsonData.ImprestCount(comid); context.Response.Write(data); //context.Response.Write("Hello World"); } if (oper == "shougongqueren") { var trade_no = context.Request["trade_no"].ConvertTo <string>(""); var order_no = context.Request["order_no"].ConvertTo <int>(0); var total_fee = context.Request["total_fee"].ConvertTo <decimal>(0); string data = FinanceJsonData.shougongqueren(trade_no, order_no, total_fee); context.Response.Write(data); //context.Response.Write("Hello World"); } } }