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