protected void Button1_Click(object sender, EventArgs e) { DataTable dt = RemittancesBLL.Quertystore(ViewState["table"].ToString(), ViewState["condition"].ToString()); if (dt == null) { Page.ClientScript.RegisterStartupScript(GetType(), "", "<script language='javascript'>alert('" + GetTran("000053", "没有数据,不能导出Excel!") + "')</script>"); return; } if (dt.Rows.Count < 1) { Page.ClientScript.RegisterStartupScript(GetType(), "", "<script language='javascript'>alert('" + GetTran("000053", "没有数据,不能导出Excel!") + "')</script>"); return; } foreach (DataRow row in dt.Rows) { row[2] = Encryption.Encryption.GetDecipherName(row[2].ToString()); //解密姓名 row[3] = Encryption.Encryption.GetDecipherName(row[3].ToString()); //解密店铺姓名 CityModel info = CommonDataDAL.GetCPCCode(row[5].ToString()); row[4] = info.Country + info.Province + info.City + Encryption.Encryption.GetDecipherAddress(row[4].ToString());//解密店铺地址 } Excel.OutToExcel(dt, GetTran("000388", "店铺"), new string[] { "id=ID", "StoreID=" + GetTran("000150", "店铺编号"), "Name=" + GetTran("000107", "姓名"), "StoreName=" + GetTran("000040", "店铺名称"), "StoreAddress=" + GetTran("001038", "店铺地址") }); }
public void getTotal() { Label1.Text = GetTran("007825", "提现金额总计") + ":<font color='red'>" + RemittancesBLL.GetTotalMoney("withdrawMoney", "MemberCash", "") + "</font>"; Label3.Text = GetTran("007826", "已汇出提现金额总计") + ":<font color='red'>" + RemittancesBLL.GetTotalMoney("withdrawMoney", "MemberCash", " where isauditing=2") + "</font>"; Label4.Text = GetTran("007827", "待审核提现金额总计") + ":<font color='red'>" + RemittancesBLL.GetTotalMoney("withdrawMoney", "MemberCash", " where isauditing=0") + "</font>"; Label5.Text = GetTran("007828", "开始处理提现金额总计") + ":<font color='red'>" + RemittancesBLL.GetTotalMoney("withdrawMoney", "MemberCash", " where isauditing=1") + "</font>"; }
protected void Page_Load(object sender, EventArgs e) { Permissions.MemRedirect(Page, Permissions.redirUrl); if (!IsPostBack) { //绑定银行 BindBank(); //绑定汇款用途 BindDeclarationType(); //绑定币种 BindCurrency(); setStoreInfo(); search_rsj(); if (this.LabCurrency1.Items.Count != 0) { this.LabCurrency.Text = RemittancesBLL.GetCurrencyNameByStoreID(); this.LabCurrency2.Text = this.LabCurrency1.SelectedValue; } this.FKBirthday.Text = CommonDataBLL.GetDateEnd().ToString(); this.HCBirthday.Text = CommonDataBLL.GetDateEnd().ToString(); if (Session["MemberRemittancesModel"] != null && Request.QueryString["isclick"] != null) { set_value(); } } }
/// <summary> /// 取消 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Btn_click(object sender, EventArgs e) { fanhuiz.Value = "1"; var hkid = Request.QueryString["HkID"]; int res = 0; SqlParameter[] parm = new SqlParameter[] { new SqlParameter("@hkid", hkid), new SqlParameter("@err", res) }; parm[1].Direction = ParameterDirection.Output; DAL.DBHelper.ExecuteNonQuery("zfpp_cx", parm, CommandType.StoredProcedure); if (parm[1].Value.ToString() == "0") { int fanhui = RemittancesBLL.jiliuZZ(hkid); fanhuiz.Value = fanhui.ToString(); ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + GetTran("009055", "取消成功") + "!');location.href='OnlinePayment.aspx'</script>", false); } else { fanhuiz.Value = "0"; ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + GetTran("009056", "取消失败") + "!');</script>", false); } }
//绑定银行 private void BindBank() { DataTable dt = RemittancesBLL.GetBank(); BankName.DataSource = dt; BankName.DataTextField = "BankName"; BankName.DataValueField = "ID"; BankName.DataBind(); }
//绑定国家 private void BindCountry_List() { IList <CountryModel> list = RemittancesBLL.BindCountry_List(); this.DropDownList1.DataSource = list; this.DropDownList1.DataTextField = "Name"; this.DropDownList1.DataValueField = "CountryCode"; this.DropDownList1.DataBind(); Translations(); }
//绑定币种 private void BindCurrency() { IList <CurrencyModel> list = RemittancesBLL.GetCurrency(); foreach (CurrencyModel info in list) { string str = CommonDataBLL.GetLanguageStr(info.ID, "Currency", "Name"); this.Currency.Items.Add(new ListItem(str, info.ID.ToString())); } }
//绑定国家 private void BindCountry_List() { IList <CountryModel> list = RemittancesBLL.BindCountry_List(); this.DropDownList1.DataSource = list; this.DropDownList1.DataTextField = "Name"; this.DropDownList1.DataValueField = "CountryCode"; this.DropDownList1.DataBind(); this.DropDownList1.Items.Add(new ListItem(GetTran("000633", "全部"), "-1")); this.DropDownList1.SelectedValue = "-1"; }
public void getTotalMoney(string number) { Label1.Text = "<b>" + GetTran("007591", "已支付付款金额") + "</b>" + ":<span style=\"color:red\">" + (Convert.ToDouble(RemittancesBLL.GetTotalMoney("RemitMoney", " Remittances a left join Withdraw c on a.ID=c.hkid ", " where isgsqr=1 and isnull(c.shenhestate,-1)<>-1 and RemitStatus=1 and relationorderid='' and RemitNumber='" + number + "'")) * (AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString()))) ).ToString("f2") + "</span>"; Label2.Text = "<b>" + GetTran("007592", "未支付付款金额") + "</b>" + ":<span style=\"color:red\">" + (Convert.ToDouble(RemittancesBLL.GetTotalMoney("RemitMoney", " Remittances a left join Withdraw c on a.ID=c.hkid ", " where isgsqr=0 and isnull(c.shenhestate,-1)<>-1 and RemitStatus=1 and relationorderid='' and RemitNumber='" + number + "'")) / (AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString()))) ).ToString("f2") + "</span>"; }
protected void Btn_Click(object sender, EventArgs e) { fanhuiz.Value = "1"; var hkid = Request.QueryString["hkid"]; int fanhui = RemittancesBLL.jiliuZZ(hkid); fanhuiz.Value = fanhui.ToString(); if (fanhui == 0) { ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + GetTran("009013", "终止成功") + "!');location.href='OnlinePayment.aspx'</script>", false); } else { ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + GetTran("009012", "终止失败!") + "');</script>", false); } }
public void getTotal() { string sqlwhere = ""; if (DropDownExpectNum.SelectedValue != "-1") { sqlwhere = " where expectnum=" + DropDownExpectNum.SelectedValue; } Label2.Text = GetTran("007859", "组织奖总计") + ":<font color='red'>" + RemittancesBLL.GetTotalMoney("Bonus0", "BalanceToPurseDetail", sqlwhere) + "</font>"; Label3.Text = GetTran("007860", "管理奖总计") + ":<font color='red'>" + RemittancesBLL.GetTotalMoney("Bonus1", "BalanceToPurseDetail", sqlwhere) + "</font>"; Label4.Text = GetTran("007861", "复消累计奖总计") + ":<font color='red'>" + RemittancesBLL.GetTotalMoney("Bonus2", "BalanceToPurseDetail", sqlwhere) + "</font>"; Label5.Text = GetTran("007756", "扣款总计") + ":<font color='red'>" + RemittancesBLL.GetTotalMoney("DeductMoney", "BalanceToPurseDetail", sqlwhere) + "</font>"; Label6.Text = GetTran("007862", "扣税总计") + ":<font color='red'>" + RemittancesBLL.GetTotalMoney("DeductTax", "BalanceToPurseDetail", sqlwhere) + "</font>"; Label7.Text = GetTran("007863", "补款总计") + ":<font color='red'>" + RemittancesBLL.GetTotalMoney("bqbukuan", "BalanceToPurseDetail", sqlwhere) + "</font>"; Label8.Text = GetTran("007864", "实发总计") + ":<font color='red'>" + RemittancesBLL.GetTotalMoney("CurrentSolidSend", "BalanceToPurseDetail", sqlwhere) + "</font>"; }
protected void Page_Load(object sender, EventArgs e) { Permissions.MemRedirect(Page, Permissions.redirUrl); if (!IsPostBack) { this.Currency.Visible = false; ViewState.Add("Currency", RemittancesBLL.GetCurrencyNameByStoreID()); this.LabCurrency.Text = ViewState["Currency"].ToString(); BindBank(); BindDeclarationType(); BindCurrency(); set_get_value(); } Translations(); }
/// <summary> /// 导出excel /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Button1_Click(object sender, EventArgs e) { string cmd = ""; cmd = "select Remittances.RemitNumber,id,IsGSQR, RemitStatus,cast(Remittances.RemitMoney as numeric(10,2)) as RemitMoney,Remittances.StandardCurrency,Remittances.[Use],CONVERT(varchar(100), Remittances.ReceivablesDate, 23) as ReceivablesDate,Remittances.PayExpectNum, Remittances.PayWay,Remittances.ConfirmType,Remittances.ImportBank,Remittances.Managers, Remittances.Sender, Remittances.SenderID,Remittances.Remark,Remittances.RemittancesCurrency,cast(Remittances.RemittancesMoney as numeric(10,2)) as RemittancesMoney,Remittances.id, case IsGSQR when '0' then '未审核' when '1' then '审核' else '未知' end from remittances where " + ViewState["condition"] + ""; DataTable dt1 = DBHelper.ExecuteDataTable(cmd); if (dt1 == null) { Page.ClientScript.RegisterStartupScript(GetType(), "", "<script language='javascript'>alert('" + GetTran("000053", "没有数据,不能导出Excel!") + "')</script>"); return; } if (dt1.Rows.Count < 1) { Page.ClientScript.RegisterStartupScript(GetType(), "", "<script language='javascript'>alert('" + GetTran("000053", "没有数据,不能导出Excel!") + "')</script>"); return; } DataTable dt = new DataTable(); dt = dt1.Clone(); dt.Columns[2].DataType = typeof(String); dt.Columns[3].DataType = typeof(String); dt.Columns[6].DataType = typeof(String); dt.Columns[7].DataType = typeof(String); dt.Columns[10].DataType = typeof(String); dt.Columns[11].DataType = typeof(String); dt.Columns[12].DataType = typeof(String); dt.Columns[13].DataType = typeof(String); foreach (DataRow r in dt1.Rows) { DataRow newrow = dt.NewRow(); newrow["RemitNumber"] = r["RemitNumber"]; newrow["RemitMoney"] = r["RemitMoney"]; newrow["StandardCurrency"] = r["StandardCurrency"]; newrow["Use"] = r["Use"]; newrow["ReceivablesDate"] = r["ReceivablesDate"]; newrow["PayExpectNum"] = r["PayExpectNum"]; newrow["PayWay"] = r["PayWay"]; newrow["ConfirmType"] = r["ConfirmType"]; newrow["ImportBank"] = r["ImportBank"]; newrow["Managers"] = r["Managers"]; newrow["Sender"] = Encryption.Encryption.GetDecipherName(r["Sender"].ToString()); //解密汇款人姓名 newrow["SenderID"] = Encryption.Encryption.GetDecipherNumber(r["SenderID"].ToString()); //解密汇款人身份证 newrow["Remark"] = r["Remark"]; newrow["RemittancesCurrency"] = r["RemittancesCurrency"]; newrow["RemittancesMoney"] = r["RemittancesMoney"]; newrow["id"] = r["id"]; dt.Rows.Add(newrow); } foreach (DataRow row in dt.Rows) { row[3] = GetUse(row[3].ToString()); //判断店铺汇款是否审核 if (row[6].ToString() == "2") { Object obj = RemittancesBLL.IsGSQR(int.Parse(row[15].ToString())); bool blean = Convert.ToBoolean(obj); if (blean == false) { row[4] = ""; } } //获得支付方式 //row[6] = D_AccountBLL.GetPaymentstr((PaymentEnum)int.Parse(row[6].ToString())); } Excel.OutToExcel(dt, GetTran("000388", "店铺"), new string[] { "RemitNumber=" + GetTran("000000", "编号"), "IsGSQR=" + GetTran("001593", "状态"), "RemitMoney=" + GetTran("001970", "汇款金额"), "Use=" + GetTran("000588", "用途"), "ReceivablesDate=" + GetTran("000901", "付款时间"), "PayexpectNum=" + GetTran("000739", "付款期数"), "PayWay=" + GetTran("000698", "付款方式"), "ImportBank=" + GetTran("000601", "汇入银行"), "Managers=" + GetTran("000519", "经办人"), "Sender=" + GetTran("000602", "汇款人"), "SenderID=" + GetTran("000782", "汇款人身份证"), "Remark=" + GetTran("000078", "备注"), "RemittancesMoney=" + GetTran("000789", "支付金额") }); StringBuilder sb = Excel.GetExcelTable(dt, GetTran("000599", "会员"), new string[] { "RemitNumber=" + GetTran("000024", "会员编号"), "RemitMoney=" + GetTran("000896", "付款金额"), "StandardCurrency=" + GetTran("000562", "币种"), "ReceivablesDate=" + GetTran("000901", "付款时间"), "PayexpectNum=" + GetTran("000739", "付款期数"), "PayWay=" + GetTran("000698", "付款方式"), "ImportBank=" + GetTran("000601", "汇入银行"), "Managers=" + GetTran("000519", "经办人"), "Sender=" + GetTran("000602", "汇款人"), "SenderID=" + GetTran("000743", "汇款人身份证"), "Remark=" + GetTran("000078", "备注"), "RemittancesCurrency=" + GetTran("000185", "支付币种"), "RemittancesMoney=" + GetTran("000789", "支付金额") }); Response.Write(sb.ToString()); Response.Flush(); Response.End(); }
protected void GridView2_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "Del") { ChangeLogs cl = new ChangeLogs("Remittances", "ltrim(rtrim(str(id)))"); if (e.CommandArgument.ToString() == string.Empty) { return; } //得到更新的id //string updId = ((HtmlInputHidden)this.GridView1.SelectedRow.FindControl("HidId")).Value; GridViewRow gvrow = (GridViewRow)(((Image)e.CommandSource).NamingContainer); string updId = (this.GridView2.Rows[gvrow.RowIndex].FindControl("HidId") as HtmlInputHidden).Value; //判断汇款是否被删除 bool blean = RemittancesBLL.MemberIsExist(int.Parse(updId)); if (blean == false) { Page.ClientScript.RegisterStartupScript(GetType(), "", "<script language='javascript'>alert('" + GetTran("000861", "不能重复删除!") + "')</script>"); return; } cl.AddRecord(updId); if (updId == "" || updId == null) { Page.ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('" + GetTran("000855", "参数出错!") + "')</script>"); return; } //判断是否审核,不能删除已审核的单子 Object obj = RemittancesBLL.IsMemberGSQR(int.Parse(updId)); try { bool b = bool.Parse(obj.ToString()); if (b == true) { Page.ClientScript.RegisterStartupScript(GetType(), "", "<script language='javascript'>alert('" + GetTran("000867", "不能删除已审核的单子!") + "')</script>"); return; } } catch { Page.ClientScript.RegisterStartupScript(GetType(), "", "<script language='javascript'>alert('" + GetTran("000852", "类型转换错误!") + "')</script>"); return; } //删除未审核的单子 RemittancesBLL.DeleteMemberMoney(Convert.ToInt32(updId)); Page.ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('" + GetTran("000874", "成功删除!") + "')</script>"); BtnConfirm_Click(null, null); cl.AddRecord(updId); cl.ModifiedIntoLogs(ChangeCategory.member1, updId, ENUM_USERTYPE.objecttype5); } else if (e.CommandName == "Pay") { string billid = EncryKey.GetEncryptstr(e.CommandArgument.ToString(), 2, 1); ScriptManager.RegisterStartupScript(this, GetType(), "mag", "var formobj=document.createElement('form');" + "formobj.action='../payserver/chosepay.aspx?blif=" + billid + "';" + "formobj.method='post';formobj.target='_blank';document.body.appendChild(formobj); formobj.submit();", true); // Page.ClientScript.RegisterStartupScript(GetType(), null, "<script language='javascript'>window.open('../payserver/chosepay.aspx?blif=" + billid + "');</script>"); return; } }
public void getTotal() { Label1.Text = GetTran("007755", "退货总价总计") + ":<font color='red'>" + RemittancesBLL.GetTotalMoney("TotalMoney", "InventoryDoc", "") + "</font>"; Label2.Text = GetTran("007756", "扣款总计") + ":<font color='red'>" + RemittancesBLL.GetTotalMoney("Charged", "InventoryDoc", "") + "</font>"; Label3.Text = GetTran("007757", "退货积分总计") + ":<font color='red'>" + RemittancesBLL.GetTotalMoney("TotalPV", "InventoryDoc", "") + "</font>"; }
public void getTotal(double money) { Label4.Text = "汇兑金额总计:<font color='red'>" + RemittancesBLL.GetTotalMoney("Jackpot-MemberInfo.Out", "memberinfo", " where (Jackpot-Out)>=" + money) + "</font>"; }
protected void Button5_Click(object sender, EventArgs e) { //验证店铺是否选择 if (this.Number.Text.Trim().Length == 0) { Page.ClientScript.RegisterStartupScript(GetType(), "", "<script language='javascript'>alert('" + GetTran("002289", "请输入店铺!") + "')</script>"); return; } //验证金额是否输入正确 if (this.Money.Text.Trim().Length > 0) { double d = 0; bool b = double.TryParse(this.Money.Text.Trim(), out d); if (!b) { Page.ClientScript.RegisterStartupScript(GetType(), "", "<script language='javascript'>alert('" + GetTran("001094", "金额输入不正确!") + "')</script>"); return; } if (d <= 0) { Page.ClientScript.RegisterStartupScript(GetType(), "", "<script language='javascript'>alert('" + GetTran("001313", "申报的金额必须大于0!") + "')</script>"); return; } } else { Page.ClientScript.RegisterStartupScript(GetType(), "", "<script language='javascript'>alert('" + GetTran("001096", "请输入金额!") + "')</script>"); return; } //验证付款日期是否输入 if (this.FKBirthday.Text.Trim().Length > 0) { DateTime time = DateTime.Now.ToUniversalTime(); bool b = DateTime.TryParse(this.FKBirthday.Text.Trim(), out time); if (!b) { Page.ClientScript.RegisterStartupScript(GetType(), "", "<script language='javascript'>alert('" + GetTran("001097", "付款日期格式输入不正确!") + "')</script>"); return; } } else { Page.ClientScript.RegisterStartupScript(GetType(), "", "<script language='javascript'>alert('" + GetTran("001098", "请输入日期!") + "')</script>"); return; } //验证汇出日期 if (this.HCBirthday.Text.Trim().Length > 0) { DateTime time = DateTime.Now.ToUniversalTime(); bool b = DateTime.TryParse(this.HCBirthday.Text.Trim(), out time); if (!b) { Page.ClientScript.RegisterStartupScript(GetType(), "", "<script language='javascript'>alert('" + GetTran("001099", "汇出日期格式输入不正确!") + "')</script>"); return; } } else { Page.ClientScript.RegisterStartupScript(GetType(), "", "<script language='javascript'>alert('" + GetTran("001100", "请输入汇出日期!") + "')</script>"); return; } //验证是否有汇入银行及帐号 if (this.BankName.Items.Count == 0) { Page.ClientScript.RegisterStartupScript(GetType(), "", "<script language='javascript'>alert('" + GetTran("001101", "没有汇入银行及帐号!") + "')</script>"); return; } if (this.PayeeNum.Text.Trim().Length == 0) { Page.ClientScript.RegisterStartupScript(GetType(), "", "<script language='javascript'>alert('" + GetTran("001105", "请输入汇单号!") + "')</script>"); return; } if (this.IdentityCard.Text.Trim().Length == 0) { Page.ClientScript.RegisterStartupScript(GetType(), "", "<script language='javascript'>alert('" + GetTran("005900", " 请输入汇款人证件号!") + "')</script>"); return; } if (System.Text.RegularExpressions.Regex.IsMatch(this.PayeeNum.Text, @"^[0-9]+$") == false) { Page.ClientScript.RegisterStartupScript(GetType(), "", "<script language='javascript'>alert('" + GetTran("001108", "汇单号码必须是数字!") + "')</script>"); return; } if (System.Text.RegularExpressions.Regex.IsMatch(this.IdentityCard.Text, @"^[0-9]+$") == false) { Page.ClientScript.RegisterStartupScript(GetType(), "", "<script language='javascript'>alert('" + GetTran("001109", "汇款人证件号必须是数字!") + "')</script>"); return; } if (System.Text.RegularExpressions.Regex.IsMatch(this.RemitNum.Text, @"^[0-9]+$") == false) { Page.ClientScript.RegisterStartupScript(GetType(), "", "<script language='javascript'>alert('" + GetTran("001110", "汇出方帐号必须是数字!") + "')</script>"); return; } if (Convert.ToDouble(this.Money.Text.Trim()) > 9999999) { Page.ClientScript.RegisterStartupScript(GetType(), "", "<script language='javascript'>alert('" + GetTran("006912", "输入金额太大!") + "')</script>"); return; } if (this.Money.Text.IndexOf(",") != -1) { Page.ClientScript.RegisterStartupScript(GetType(), "", "<script language='javascript'>alert('" + GetTran("001094", "金额输入不正确!") + "')</script>"); return; } if (this.Remark.Text.Length > 500) { System.Web.UI.ScriptManager.RegisterStartupScript(Page, GetType(), "success2", "alert('" + GetTran("006708", "对不起,备注输入的字符太多,最多500个字符!") + "');", true); return; } ; RemittancesModel info = new RemittancesModel(); info.ReceivablesDate = DateTime.Now;//收款时间 info.RemitNumber = this.Number.Text; info.RemitMoney = decimal.Parse(this.Money.Text); info.StandardCurrency = int.Parse(this.LabCurrency.Text); //标准币种 info.Use = int.Parse(this.DeclarationType.SelectedValue); //用途:1.报单,2. info.PayexpectNum = BLL.CommonClass.CommonDataBLL.getMaxqishu(); //付款期数 info.PayWay = (int)PaymentEnum.BankTransfer; //付款方式 info.Managers = Session["Member"].ToString(); //经办人 info.ConfirmType = 0; //确认方式(已经去掉) info.Remark = this.Remark.Text; //备注 info.RemittancesCurrency = int.Parse(this.LabCurrency2.Text); //汇出币种 info.RemittancesMoney = decimal.Parse(this.Money.Text); //汇出金额 info.OperateIp = CommonDataBLL.OperateIP; //操作者IP info.OperateNum = Session["Member"].ToString(); //操作者编号 info.Remittancesid = ""; //汇款单号 string zw_hr_kfh = BankName.SelectedItem.Text.Substring(0, BankName.SelectedItem.Text.IndexOf("—", 0)); //银行 string zw_hr_zh = BankName.SelectedItem.Text.Substring(BankName.SelectedItem.Text.IndexOf("—", 0) + 1, BankName.SelectedItem.Text.Length - BankName.SelectedItem.Text.IndexOf("—", 0) - 1); //开户名 zw_hr_zh = zw_hr_zh.Substring(zw_hr_zh.IndexOf("——") + 2); //账号 info.ImportBank = zw_hr_kfh; //汇入银行 info.ImportNumber = Encryption.Encryption.GetEncryptionCard(zw_hr_zh); //加密汇入账号 info.RemittancesAccount = Encryption.Encryption.GetEncryptionCard(this.RemitNum.Text); //加密汇款账号 info.RemittancesDate = DateTime.Parse(FKBirthday.Text); //汇出时间 info.RemittancesBank = this.RemitBank.Text; //汇出银行 info.SenderID = Encryption.Encryption.GetEncryptionNumber(this.IdentityCard.Text); //加密汇款人身份证 info.Sender = Encryption.Encryption.GetEncryptionName(this.Remitter.Text); //加密汇款人姓名 info.Remittancesid = this.PayeeNum.Text; //汇款单号 info.RemitStatus = 1; //类型(0店铺,1会员) info.IsGSQR = false; //是否确认审核 RemittancesBLL.RemitDeclare(info, this.LabCurrency.Text, this.LabCurrency2.Text); //汇款申报 Session["MemberRemittancesModel"] = null; Page.ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('" + GetTran("002290", "录入成功!请等待公司审核!") + "');window.location.href='OnlinePayment.aspx';</script>"); }
protected void sub_Click(object sender, EventArgs e) { //设置特定值防止重复提交 hid_fangzhi.Value = "0"; string hkxz = " select value from JLparameter where jlcid=6"; DataTable dthkxz = DAL.DBHelper.ExecuteDataTable(hkxz); string value = dthkxz.Rows[0]["value"].ToString(); //验证店铺是否选择 //if (this.Number.Text.Trim().Length == 0) //{ // Page.ClientScript.RegisterStartupScript(GetType(), "", "<script language='javascript'>alert('" + GetTran("002289", "请输入店铺!") + "')</script>"); // return; //} //验证金额是否输入正确 double d = 0; bool b = double.TryParse(this.buysz.Text.Trim(), out d); if (!b) { Page.ClientScript.RegisterStartupScript(GetType(), "", "<script language='javascript'>alert('" + GetTran("001094", "金额输入不正确!") + "')</script>"); return; } if (d <= 0) { Page.ClientScript.RegisterStartupScript(GetType(), "", "<script language='javascript'>alert('" + GetTran("001313", "申报的金额必须大于0!") + "')</script>"); return; } if (d > 9999999) { Page.ClientScript.RegisterStartupScript(GetType(), "", "<script language='javascript'>alert('" + GetTran("006912", "输入金额太大!") + "')</script>"); return; } if (Convert.ToDecimal(d) % Convert.ToDecimal(value) != 0) { Page.ClientScript.RegisterStartupScript(GetType(), "", "<script language='javascript'>alert('" + GetTran("009052", "汇款金额只能为") + value + GetTran("009053", "的倍数") + "!')</script>"); buysz.Text = ""; return; } string zw_dian; zw_dian = Session["Member"].ToString(); string Bank = ""; string BankName = ""; string BankBook = ""; string aa = " select top(1)* from companybank order by ID desc"; DataTable dt = DAL.DBHelper.ExecuteDataTable(aa); if (dt != null && dt.Rows.Count > 0) { Bank = dt.Rows[0]["Bank"].ToString(); BankName = dt.Rows[0]["BankName"].ToString(); BankBook = dt.Rows[0]["BankBook"].ToString(); } string rnumber = Session["member"].ToString(); RemittancesModel info = new RemittancesModel(); info.ReceivablesDate = DateTime.UtcNow; info.RemittancesDate = DateTime.UtcNow; info.IsJL = 1; info.ImportBank = Bank; info.ImportNumber = BankBook; info.name = BankName; info.RemittancesAccount = ""; info.RemittancesBank = ""; info.SenderID = ""; info.Sender = ""; info.RemitNumber = rnumber; info.RemitMoney = Convert.ToDecimal(Convert.ToDouble(this.buysz.Text)); info.StandardCurrency = bzCurrency; info.Use = 0; /*int.Parse(this.DeclarationType.SelectedValue)*/ info.PayexpectNum = BLL.CommonClass.CommonDataBLL.getMaxqishu(); info.Managers = zw_dian; info.ConfirmType = 0; info.Remark = ""; info.RemittancesCurrency = int.Parse(Session["Default_Currency"].ToString()); info.RemittancesMoney = Convert.ToDecimal(Convert.ToDouble(this.buysz.Text)); info.OperateIp = CommonDataBLL.OperateIP; info.OperateNum = Session["Member"].ToString(); //获取汇单号 string huidan = "HK" + Model.Other.MYDateTime.ToYYMMDDHHmmssString(); //判断汇单号是否存在:true存在,false不存在 bool isExist = RemittancesBLL.isMemberExistsHuiDan(huidan); while (isExist) { huidan = "HK" + Model.Other.MYDateTime.ToYYMMDDHHmmssString(); isExist = RemittancesBLL.isMemberExistsHuiDan(huidan); } info.RemitStatus = 1; info.IsGSQR = false; info.Remittancesid = huidan; RemittancesBLL.RemitDeclare(info, bzCurrency.ToString(), Session["Default_Currency"].ToString()); DataTable dt_one = DAL.DBHelper.ExecuteDataTable("select ID from remittances where RemittancesID='" + huidan + "'"); string HkID = dt_one.Rows[0]["ID"].ToString();//汇款ID int bishu = 4; string billid = EncryKey.GetEncryptstr(huidan, 2, 1); string url = "OnlinePayQD.aspx?HkID=" + HkID + "&bishu=" + bishu + "&RemitMoney=" + info.RemitMoney; Response.Redirect(url); //Page.ClientScript.RegisterStartupScript(GetType(), null, @"<script type='text/javascript'>var formobj=document.createElement('form');formobj.action='"+url+"';formobj.method='post';formobj.target='_blank';document.body.appendChild(formobj);formobj.submit(); </script>"); this.buysz.Text = ""; }
protected void Button5_Click(object sender, EventArgs e) { //验证店铺是否选择 if (this.Number.Text.Trim().Length == 0) { Page.ClientScript.RegisterStartupScript(GetType(), "", "<script language='javascript'>alert('" + GetTran("002289", "请输入店铺!") + "')</script>"); return; } //验证金额是否输入正确 if (this.Money.Text.Trim().Length > 0) { try { if (Convert.ToDouble(this.Money.Text.Trim()) <= 0) { Page.ClientScript.RegisterStartupScript(GetType(), "", "<script language='javascript'>alert('" + GetTran("001313", "申报的金额必须大于0!") + "')</script>"); return; } } catch { Page.ClientScript.RegisterStartupScript(GetType(), "", "<script language='javascript'>alert('" + GetTran("001094", "金额输入不正确!") + "')</script>"); return; } } else { Page.ClientScript.RegisterStartupScript(GetType(), "", "<script language='javascript'>alert('" + GetTran("001096", "请输入金额!") + "')</script>"); return; } if (Convert.ToDouble(this.Money.Text.Trim()) > 9999999) { Page.ClientScript.RegisterStartupScript(GetType(), "", "<script language='javascript'>alert('" + GetTran("006912", "输入金额太大!") + "')</script>"); return; } if (this.Money.Text.IndexOf(",") != -1) { Page.ClientScript.RegisterStartupScript(GetType(), "", "<script language='javascript'>alert('" + GetTran("001094", "金额输入不正确!") + "')</script>"); return; } //验证付款日期是否输入 if (this.FKBirthday.Text.Trim().Length > 0) { try { DateTime time = Convert.ToDateTime(this.FKBirthday.Text.Trim()); } catch { Page.ClientScript.RegisterStartupScript(GetType(), "", "<script language='javascript'>alert('" + GetTran("001097", "付款日期格式输入不正确!") + "')</script>"); return; } } else { Page.ClientScript.RegisterStartupScript(GetType(), "", "<script language='javascript'>alert('" + GetTran("001098", "请输入日期!") + "')</script>"); return; } if (this.Remark.Text.Length > 500) { System.Web.UI.ScriptManager.RegisterStartupScript(Page, GetType(), "success2", "alert('" + GetTran("006708", "对不起,备注输入的字符太多,最多500个字符!") + "');", true); return; } ; this.Button5.Enabled = false; //读取当前期数和当前登录的管理员编号 string zw_dian; zw_dian = Session["Member"].ToString(); string use = this.DeclarationType.SelectedValue; RemittancesModel info = new RemittancesModel(); info.ReceivablesDate = DateTime.Now; info.RemittancesDate = DateTime.Now; info.ImportBank = ""; info.ImportNumber = ""; info.RemittancesAccount = ""; info.RemittancesBank = ""; info.SenderID = ""; info.Sender = ""; info.RemitNumber = this.Number.Text; info.RemitMoney = decimal.Parse(this.Money.Text); info.StandardCurrency = int.Parse(this.LabCurrency.Text); info.Use = int.Parse(this.DeclarationType.SelectedValue); info.PayexpectNum = BLL.CommonClass.CommonDataBLL.getMaxqishu(); info.PayWay = int.Parse(this.RadPayFashion.SelectedValue); info.Managers = zw_dian; info.ConfirmType = 0; info.Remark = this.Remark.Text; info.IsGSQR = false; info.RemittancesCurrency = int.Parse(this.LabCurrency2.Text); info.RemittancesMoney = decimal.Parse(this.Money.Text); info.OperateIp = CommonDataBLL.OperateIP; info.OperateNum = Session["Member"].ToString(); info.Remittancesid = ""; //支付宝支付 string huidan = ""; string payType = this.RadPayFashion.SelectedValue.Trim(); if (payType == "3") { string isStore = "M"; //获取汇单号 huidan = Model.Other.MYDateTime.ToYYMMDDHHmmssString(); //判断汇单号是否存在:true存在,false不存在 bool isExist = RemittancesBLL.isMemberExistsHuiDan(huidan); while (isExist) { huidan = Model.Other.MYDateTime.ToYYMMDDHHmmssString(); isExist = RemittancesBLL.isMemberExistsHuiDan(huidan); } huidan = isStore + huidan; info.RemitStatus = 1; info.IsGSQR = false; info.Remittancesid = huidan; RemittancesBLL.RemitDeclare(info, this.LabCurrency.Text, this.LabCurrency2.Text); decimal huilv = info.RemitMoney / (decimal.Parse(RemittancesBLL.GetCurrency(info.StandardCurrency).ToString())) * decimal.Parse(RemittancesBLL.GetCurrency(info.RemittancesCurrency).ToString()); string url = "../Store/payment/default.aspx?zongMoney=(" + info.RemitMoney + huilv + ")&TotalMoney=" + info.RemitMoney + "&TotalComm=" + huilv + "&HuiDanID=" + huidan; Response.Write("<script language='javascript'>alert('" + GetTran("001127", "录入成功!请到网上银行付款页面。") + "');window.open('" + url + "')</script>"); } else if (payType == "4") { //获取汇单号 huidan = Model.Other.MYDateTime.ToYYMMDDHHmmssString(); //判断汇单号是否存在:true存在,false不存在 bool isExist = RemittancesBLL.isMemberExistsHuiDan(huidan); while (isExist) { huidan = Model.Other.MYDateTime.ToYYMMDDHHmmssString(); isExist = RemittancesBLL.isMemberExistsHuiDan(huidan); } info.RemitStatus = 1; info.IsGSQR = false; info.Remittancesid = huidan; RemittancesBLL.RemitDeclare(info, this.LabCurrency.Text, this.LabCurrency2.Text); decimal huilv = info.RemitMoney / (decimal.Parse(RemittancesBLL.GetCurrency(info.StandardCurrency).ToString())) * decimal.Parse(RemittancesBLL.GetCurrency(info.RemittancesCurrency).ToString()); string url = "../Store/quickPay/quickPay.aspx?RemittanceType=" + (int)Model.Enum_RemittancesType.enum_MemberRemittance + "&hkid=" + huidan; Response.Write("<script language='javascript'>alert('" + GetTran("001127", "录入成功!请到网上银行付款页面。") + "');window.open('" + url + "');</script>"); } }
//赋值 private void set_get_value() { string ReceivablesDate = Convert.ToDateTime(FKBirthday.Text).ToString("yyyy-MM-dd") + " " + this.ddlHour.SelectedValue + ":" + this.ddlMinute.SelectedValue + ":00"; string zw_hcr = Convert.ToDateTime(HCBirthday.Text).ToString("yyyy-MM-dd") + " " + this.DropDownList1.SelectedValue + ":" + this.DropDownList2.SelectedValue + ":00"; RemittancesModel info = new RemittancesModel(); info.ReceivablesDate = DateTime.Parse(ReceivablesDate).ToUniversalTime(); info.RemittancesDate = DateTime.Parse(zw_hcr).ToUniversalTime(); info.ImportBank = ""; info.ImportNumber = ""; info.RemittancesAccount = ""; info.RemittancesBank = ""; info.SenderID = ""; info.Sender = ""; info.RemitNumber = this.Number.Text; info.RemitMoney = decimal.Parse(this.Money.Text); info.StandardCurrency = CommonDataBLL.GetStandard(); info.ConfirmType = int.Parse(Way.SelectedValue); info.Remark = this.Remark.Text; info.RemittancesCurrency = CommonDataBLL.GetStandard(); info.PayWay = (int)PayWayType.RecAdvance; info.RemittancesMoney = decimal.Parse(this.Money.Text); info.Managers = Session["Company"].ToString(); info.PhotoPath = ""; info.OperateIp = Request.UserHostAddress; info.OperateNum = Session["Company"].ToString(); info.IsGSQR = true; info.PayexpectNum = BLL.CommonClass.CommonDataBLL.GetMaxqishu(); //获取汇单号 string huidan = "HK" + Model.Other.MYDateTime.ToYYMMDDHHmmssString(); //判断汇单号是否存在:true存在,false不存在 bool isExist = RemittancesBLL.isMemberExistsHuiDan(huidan); while (isExist) { huidan = "HK" + Model.Other.MYDateTime.ToYYMMDDHHmmssString(); isExist = RemittancesBLL.isMemberExistsHuiDan(huidan); } info.Remittancesid = huidan; if (this.RadPayFashion.SelectedIndex == 1) { string zw_hr_kfh = BankName.SelectedItem.Text.Substring(0, BankName.SelectedItem.Text.IndexOf("—", 0)); string zw_hr_zh = BankName.SelectedItem.Text.Substring(BankName.SelectedItem.Text.IndexOf("—", 0) + 1, BankName.SelectedItem.Text.Length - BankName.SelectedItem.Text.IndexOf("—", 0) - 1); string zw_skr = ReceivablesDate; info.RemittancesDate = DateTime.Parse(zw_hcr).ToUniversalTime(); info.ImportBank = zw_hr_kfh; info.ImportNumber = zw_hr_zh; info.RemittancesAccount = this.RemitNum.Text; info.ReceivablesDate = DateTime.Parse(zw_skr).ToUniversalTime(); info.RemittancesBank = this.RemitBank.Text; info.SenderID = this.IdentityCard.Text; info.Sender = this.Remitter.Text; } if (ViewState["Type"].ToString() == "Member") { info.RemitStatus = 1; info.Use = int.Parse(member_type.SelectedValue); } else if (ViewState["Type"].ToString() == "Store") { info.RemitStatus = 0; info.Use = int.Parse(store_type.SelectedValue); } int ret = 0; SqlTransaction tran = null; SqlConnection conn = DAL.DBHelper.SqlCon(); conn.Open(); tran = conn.BeginTransaction(); //添加汇款记录,并更新对应的金额 int id = 0; RemittancesBLL.AddMemberRemittancesTran(info, CommonDataBLL.GetStandard().ToString(), CommonDataBLL.GetStandard().ToString(), out id, tran); if (id > 0) { if (info.Use == 0)//现金账户对账单 { ret = D_AccountBLL.AddAccountTran(info.RemitNumber, Double.Parse(info.RemitMoney.ToString()) * RemittancesBLL.GetCurrency(info.RemittancesCurrency), D_AccountSftype.MemberType, D_Sftype.BounsAccount, D_AccountKmtype.RechargeByManager, DirectionEnum.AccountsIncreased, " " + "~007214", tran); } else if (info.Use == 1)//消费账户对账单 { ret = D_AccountBLL.AddAccountTran(info.RemitNumber, Double.Parse(info.RemitMoney.ToString()) * RemittancesBLL.GetCurrency(info.RemittancesCurrency), D_AccountSftype.MemberCoshType, D_Sftype.EleAccount, D_AccountKmtype.RechargeByManager, DirectionEnum.AccountsIncreased, " " + "~007214", tran); } else if (info.Use == 2)//复消账户对账单 { ret = D_AccountBLL.AddAccountTran(info.RemitNumber, Double.Parse(info.RemitMoney.ToString()) * RemittancesBLL.GetCurrency(info.RemittancesCurrency), D_AccountSftype.MemberTypeFx, D_Sftype.CancellationAccount, D_AccountKmtype.RechargeByManager, DirectionEnum.AccountsIncreased, " " + "~007214", tran); } //店铺订货款 else if (info.Use == 10) { ret = D_AccountBLL.AddStoreAccount(info.RemitNumber, Double.Parse(info.RemitMoney.ToString()) * RemittancesBLL.GetCurrency(info.RemittancesCurrency), D_AccountSftype.StoreDingHuokuan, S_Sftype.dianhuo, D_AccountKmtype.RechargeByManager, DirectionEnum.AccountsIncreased, " " + "~003079", tran); }//店铺周转款 else if (info.Use == 11) { ret = D_AccountBLL.AddStoreAccount(info.RemitNumber, Double.Parse(info.RemitMoney.ToString()) * RemittancesBLL.GetCurrency(info.RemittancesCurrency), D_AccountSftype.StoreZhouZhuankuan, S_Sftype.zhouzhuan, D_AccountKmtype.RechargeByManager, DirectionEnum.AccountsIncreased, " " + "~003079", tran); } if (ret > 0) { //发送短信 //string receiverName = "", storeidnumber = "", mobile = ""; //if (ViewState["Type"].ToString() == "Store") //{ // StoreInfoModel storeinfo = StoreInfoDAL.GetStoreInfoByStoreId(this.Number.Text); // receiverName = Encryption.Encryption.GetDecipherName(storeinfo.Name); // storeidnumber = storeinfo.Number; // mobile = Encryption.Encryption.GetDecipherTele(storeinfo.MobileTele); //} //else if (ViewState["Type"].ToString() == "Member") //{ // MemberInfoModel storeinfo = MemberInfoDAL.getMemberInfo(Number.Text.Trim()); // receiverName = Encryption.Encryption.GetDecipherName(storeinfo.Name); // storeidnumber = storeinfo.Number; // mobile = Encryption.Encryption.GetDecipherTele(storeinfo.MobileTele); //} //Session["RemittancesModel"] = null; //string hkid = id.ToString(); //try //{ // BLL.MobileSMS.SendMsgMode(tran, receiverName, "收到" + info.RemittancesMoney + RemittancesBLL.GetCurrencyByID(info.RemittancesCurrency), storeidnumber, mobile, hkid, Model.SMSCategory.sms_Receivables); // tran.Commit(); //} //catch //{ // tran.Rollback(); //} if (ViewState["Type"].ToString() == "Member") { tran.Commit(); conn.Close(); Page.ClientScript.RegisterStartupScript(GetType(), "", "<script language='javascript'>alert('" + GetTran("001126", "汇款成功!") + "');location.href='AuditingStoreAccount.aspx?type=Member';</script>"); } else { tran.Commit(); conn.Close(); Page.ClientScript.RegisterStartupScript(GetType(), "", "<script language='javascript'>alert('" + GetTran("001126", "汇款成功!") + "');location.href='AuditingStoreAccount.aspx';</script>"); } } else { tran.Rollback(); conn.Close(); Page.ClientScript.RegisterStartupScript(GetType(), "", "<script language='javascript'>alert('" + GetTran("008020", "汇款失败") + "!');</script>"); } } else { tran.Rollback(); conn.Close(); Page.ClientScript.RegisterStartupScript(GetType(), "", "<script language='javascript'>alert('" + GetTran("008020", "汇款失败") + "!');</script>"); } }
public void getTotalMoney(string number) { Label1.Text = "<b>" + GetTran("007591", "已支付付款金额") + "</b>" + ":<span style=\"color:red\">" + RemittancesBLL.GetTotalMoney("RemitMoney", "Remittances", " where isgsqr=1 and RemitStatus=1 and relationorderid='' and RemitNumber='" + number + "'") + "</span>"; Label2.Text = "<b>" + GetTran("007592", "未支付付款金额") + "</b>" + ":<span style=\"color:red\">" + RemittancesBLL.GetTotalMoney("RemitMoney", "Remittances", " where isgsqr=0 and RemitStatus=1 and relationorderid='' and RemitNumber='" + number + "'") + "</span>"; }