/// <summary>
/// 增加一条数据
/// </summary>
public long Add(lgk.Model.tb_remit model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_remit(");
strSql.Append("BankName,BankAccount,BankAccountUser,RechargeableDate,AddDate,State,RemitMoney,YuAmount,Remark,UserID,Remit001,Remit002,Remit003,Remit004,Remit005,Remit006,Remit007");
strSql.Append(") values (");
strSql.Append("@BankName,@BankAccount,@BankAccountUser,@RechargeableDate,@AddDate,@State,@RemitMoney,@YuAmount,@Remark,@UserID,@Remit001,@Remit002,@Remit003,@Remit004,@Remit005,@Remit006,@Remit007");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@BankName", SqlDbType.VarChar, 50),
new SqlParameter("@BankAccount", SqlDbType.VarChar, 50),
new SqlParameter("@BankAccountUser", SqlDbType.VarChar, 50),
new SqlParameter("@RechargeableDate", SqlDbType.DateTime),
new SqlParameter("@AddDate", SqlDbType.DateTime),
new SqlParameter("@State", SqlDbType.Int, 4),
new SqlParameter("@RemitMoney", SqlDbType.Decimal, 9),
new SqlParameter("@YuAmount", SqlDbType.Decimal, 9),
new SqlParameter("@Remark", SqlDbType.VarChar, 500),
new SqlParameter("@UserID", SqlDbType.BigInt, 8),
new SqlParameter("@Remit001", SqlDbType.Int, 4),
new SqlParameter("@Remit002", SqlDbType.Int, 4),
new SqlParameter("@Remit003", SqlDbType.VarChar, 50),
new SqlParameter("@Remit004", SqlDbType.VarChar, 200),
new SqlParameter("@Remit005", SqlDbType.VarChar, 500),
new SqlParameter("@Remit006", SqlDbType.Decimal, 9),
new SqlParameter("@Remit007", SqlDbType.Int, 4)
};
parameters[0].Value = model.BankName;
parameters[1].Value = model.BankAccount;
parameters[2].Value = model.BankAccountUser;
parameters[3].Value = model.RechargeableDate;
parameters[4].Value = model.AddDate;
parameters[5].Value = model.State;
parameters[6].Value = model.RemitMoney;
parameters[7].Value = model.YuAmount;
parameters[8].Value = model.Remark;
parameters[9].Value = model.UserID;
parameters[10].Value = model.Remit001;
parameters[11].Value = model.Remit002;
parameters[12].Value = model.Remit003;
parameters[13].Value = model.Remit004;
parameters[14].Value = model.Remit005;
parameters[15].Value = model.Remit006;
parameters[16].Value = model.Remit007;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(long.Parse(obj.ToString()));
}
}
protected void Page_Load(object sender, EventArgs e)
{
long id = Convert.ToInt32(Request.Params["ID"]);
if (id != 0)
{
lgk.Model.tb_remit remit = remitBLL.GetModel(id);
remitimg.ImageUrl = name + remit.Remit005;
}
}
/// <summary>
/// 生成随机订单号
/// </summary>
/// <returns></returns>
public static string BuildOuterOrderNumber(int UserID)
{
lgk.BLL.tb_remit remitbll = new lgk.BLL.tb_remit();
string payId = "1"; //支付编号
var len = 20 - 15 - payId.ToString().Length;
var orderNumber = GetUniqueIndentifier(len) + payId + DateTime.Now.ToString("yyMMddHHmmssfff");
lgk.Model.tb_remit me = remitbll.GetModel(" UserID=" + UserID + " and Remit004='" + orderNumber + "'");
if (me != null)
{
return(BuildOuterOrderNumber(UserID));
}
else
{
return(orderNumber);
}
}
protected void btn_Open_Click(object sender, EventArgs e)
{
try
{
if (ourbankname.SelectedValue == "")
{
MessageBox.ShowBox(this.Page, GetLanguage("banksEmpty"), Library.Enums.ModalTypes.warning);//汇出银行不能为空
return;
}
if (ourbankaccount.Text == "")
{
MessageBox.ShowBox(this.Page, GetLanguage("accountEmpty"), Library.Enums.ModalTypes.warning);//汇出账户不能为空
return;
}
if (bank.Text == "")
{
MessageBox.ShowBox(this.Page, GetLanguage("Bank"), Library.Enums.ModalTypes.warning);//公司开户银行不能为空
return;
}
if (bankAccount.Text == "")
{
MessageBox.ShowBox(this.Page, GetLanguage("OpeningEmpty"), Library.Enums.ModalTypes.warning);//公司开户账户不能为空
return;
}
if (bankUserName.Text == "")
{
MessageBox.ShowBox(this.Page, GetLanguage("OpenAccount"), Library.Enums.ModalTypes.warning);//公司开户名不能为空
return;
}
if (Image1.ImageUrl == "")
{
MessageBox.ShowBox(this.Page, GetLanguage("Moneyempty"), Library.Enums.ModalTypes.warning);//打款凭证不能为空
return;
}
string money = txtMoney.Text.Trim();
decimal dmoney = 0;
if (string.IsNullOrEmpty(money))
{
MessageBox.ShowBox(this.Page, GetLanguage("EnterAmount"), Library.Enums.ModalTypes.warning);//请输入充值金额
return;
}
decimal.TryParse(money, out dmoney);
if (dmoney <= 0)
{
MessageBox.ShowBox(this.Page, GetLanguage("EnterAmount"), Library.Enums.ModalTypes.warning);//请输入充值金额
return;
}
if (bz.Text == "")
{
MessageBox.ShowBox(this.Page, GetLanguage("RemittanceEmpty"), Library.Enums.ModalTypes.warning);//汇款备注不能为空
return;
}
string bankname = "";
lgk.Model.tb_remit remit = new lgk.Model.tb_remit();
remit.UserID = LoginUser.UserID;
remit.RemitMoney = dmoney;
remit.BankAccountUser = bankUserName.Text;
remit.BankAccount = bankAccount.Text;
remit.BankName = bank.Text;
remit.RechargeableDate = DateTime.Now;
remit.AddDate = DateTime.Now;
//remit.PassDate = DateTime.Now;
remit.Remark = barmk.Text;
remit.State = 0; //0-付款中 1-付款成功 2-付款失败
remit.Remit001 = 1; //1-激活会员 2-复投
remit.Remit002 = 0;
remit.Remit006 = 0; //支付方式
string orderCode = Util.GetUniqueIndentifier(20);
remit.Remit004 = orderCode; //订单号
remit.Remit005 = Image1.ImageUrl;
remit.Remit007 = 1; //是否提交成功 0-是 1-否
remit.Remit003 = ourbankname.SelectedValue; //打款银行
bankname = ourbankname.SelectedItem.Text;
long uid = remitbll.Add(remit);
if (uid > 0)
{
MessageBox.ShowBox(this.Page, GetLanguage("ApplySuccess"), Library.Enums.ModalTypes.success, "TransRemit.aspx");//申请充值成功
// BindData();
}
else
{
MessageBox.ShowBox(this.Page, GetLanguage("ApplyError"), Library.Enums.ModalTypes.error);//申请充值失败
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('" + ex.Message + "!');", true);
}
}
public lgk.Model.tb_remit GetModel(string where)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,BankName,BankAccount,BankAccountUser,RechargeableDate,AddDate,State,RemitMoney,YuAmount,Remark,UserID,PassDate,Remit001,Remit002,Remit003,Remit004,Remit005,Remit006,Remit007 from tb_remit ");
if (where != "")
{
strSql.Append(" where " + where);
}
lgk.Model.tb_remit model = new lgk.Model.tb_remit();
DataSet ds = DbHelperSQL.Query(strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["ID"] != null && ds.Tables[0].Rows[0]["ID"].ToString() != "")
{
model.ID = long.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
}
if (ds.Tables[0].Rows[0]["BankName"] != null && ds.Tables[0].Rows[0]["BankName"].ToString() != "")
{
model.BankName = ds.Tables[0].Rows[0]["BankName"].ToString();
}
if (ds.Tables[0].Rows[0]["BankAccount"] != null && ds.Tables[0].Rows[0]["BankAccount"].ToString() != "")
{
model.BankAccount = ds.Tables[0].Rows[0]["BankAccount"].ToString();
}
if (ds.Tables[0].Rows[0]["BankAccountUser"] != null && ds.Tables[0].Rows[0]["BankAccountUser"].ToString() != "")
{
model.BankAccountUser = ds.Tables[0].Rows[0]["BankAccountUser"].ToString();
}
if (ds.Tables[0].Rows[0]["RechargeableDate"] != null && ds.Tables[0].Rows[0]["RechargeableDate"].ToString() != "")
{
model.RechargeableDate = DateTime.Parse(ds.Tables[0].Rows[0]["RechargeableDate"].ToString());
}
if (ds.Tables[0].Rows[0]["AddDate"] != null && ds.Tables[0].Rows[0]["AddDate"].ToString() != "")
{
model.AddDate = DateTime.Parse(ds.Tables[0].Rows[0]["AddDate"].ToString());
}
if (ds.Tables[0].Rows[0]["State"] != null && ds.Tables[0].Rows[0]["State"].ToString() != "")
{
model.State = int.Parse(ds.Tables[0].Rows[0]["State"].ToString());
}
if (ds.Tables[0].Rows[0]["RemitMoney"] != null && ds.Tables[0].Rows[0]["RemitMoney"].ToString() != "")
{
model.RemitMoney = decimal.Parse(ds.Tables[0].Rows[0]["RemitMoney"].ToString());
}
if (ds.Tables[0].Rows[0]["YuAmount"] != null && ds.Tables[0].Rows[0]["YuAmount"].ToString() != "")
{
model.YuAmount = decimal.Parse(ds.Tables[0].Rows[0]["YuAmount"].ToString());
}
if (ds.Tables[0].Rows[0]["Remark"] != null && ds.Tables[0].Rows[0]["Remark"].ToString() != "")
{
model.Remark = ds.Tables[0].Rows[0]["Remark"].ToString();
}
if (ds.Tables[0].Rows[0]["UserID"] != null && ds.Tables[0].Rows[0]["UserID"].ToString() != "")
{
model.UserID = long.Parse(ds.Tables[0].Rows[0]["UserID"].ToString());
}
if (ds.Tables[0].Rows[0]["PassDate"] != null && ds.Tables[0].Rows[0]["PassDate"].ToString() != "")
{
model.PassDate = DateTime.Parse(ds.Tables[0].Rows[0]["PassDate"].ToString());
}
if (ds.Tables[0].Rows[0]["Remit001"] != null && ds.Tables[0].Rows[0]["Remit001"].ToString() != "")
{
model.Remit001 = int.Parse(ds.Tables[0].Rows[0]["Remit001"].ToString());
}
if (ds.Tables[0].Rows[0]["Remit002"] != null && ds.Tables[0].Rows[0]["Remit002"].ToString() != "")
{
model.Remit002 = int.Parse(ds.Tables[0].Rows[0]["Remit002"].ToString());
}
if (ds.Tables[0].Rows[0]["Remit003"] != null && ds.Tables[0].Rows[0]["Remit003"].ToString() != "")
{
model.Remit003 = ds.Tables[0].Rows[0]["Remit003"].ToString();
}
if (ds.Tables[0].Rows[0]["Remit004"] != null && ds.Tables[0].Rows[0]["Remit004"].ToString() != "")
{
model.Remit004 = ds.Tables[0].Rows[0]["Remit004"].ToString();
}
if (ds.Tables[0].Rows[0]["Remit005"] != null && ds.Tables[0].Rows[0]["Remit005"].ToString() != "")
{
model.Remit005 = ds.Tables[0].Rows[0]["Remit005"].ToString();
}
if (ds.Tables[0].Rows[0]["Remit006"] != null && ds.Tables[0].Rows[0]["Remit006"].ToString() != "")
{
model.Remit006 = decimal.Parse(ds.Tables[0].Rows[0]["Remit006"].ToString());
}
if (ds.Tables[0].Rows[0]["Remit007"] != null && ds.Tables[0].Rows[0]["Remit007"].ToString() != "")
{
model.Remit007 = int.Parse(ds.Tables[0].Rows[0]["Remit007"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(lgk.Model.tb_remit model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_remit set ");
strSql.Append("BankName=@BankName,");
strSql.Append("BankAccount=@BankAccount,");
strSql.Append("BankAccountUser=@BankAccountUser,");
strSql.Append("RechargeableDate=@RechargeableDate,");
strSql.Append("AddDate=@AddDate,");
strSql.Append("State=@State,");
strSql.Append("RemitMoney=@RemitMoney,");
strSql.Append("YuAmount=@YuAmount,");
strSql.Append("Remark=@Remark,");
strSql.Append("UserID=@UserID,");
strSql.Append("PassDate=@PassDate,");
strSql.Append("Remit001=@Remit001,");
strSql.Append("Remit002=@Remit002,");
strSql.Append("Remit003=@Remit003,");
strSql.Append("Remit004=@Remit004,");
strSql.Append("Remit005=@Remit005,");
strSql.Append("Remit006=@Remit006,");
strSql.Append("Remit007=@Remit007");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@BankName", SqlDbType.VarChar, 50),
new SqlParameter("@BankAccount", SqlDbType.VarChar, 50),
new SqlParameter("@BankAccountUser", SqlDbType.VarChar, 50),
new SqlParameter("@RechargeableDate", SqlDbType.DateTime),
new SqlParameter("@AddDate", SqlDbType.DateTime),
new SqlParameter("@State", SqlDbType.Int, 4),
new SqlParameter("@RemitMoney", SqlDbType.Decimal, 9),
new SqlParameter("@YuAmount", SqlDbType.Decimal, 9),
new SqlParameter("@Remark", SqlDbType.VarChar, 50),
new SqlParameter("@UserID", SqlDbType.BigInt, 8),
new SqlParameter("@PassDate", SqlDbType.DateTime),
new SqlParameter("@Remit001", SqlDbType.Int, 4),
new SqlParameter("@Remit002", SqlDbType.Int, 4),
new SqlParameter("@Remit003", SqlDbType.VarChar, 50),
new SqlParameter("@Remit004", SqlDbType.VarChar, 200),
new SqlParameter("@Remit005", SqlDbType.VarChar, 500),
new SqlParameter("@Remit006", SqlDbType.Decimal, 9),
new SqlParameter("@Remit007", SqlDbType.Int, 4),
new SqlParameter("@ID", SqlDbType.BigInt, 8)
};
parameters[0].Value = model.BankName;
parameters[1].Value = model.BankAccount;
parameters[2].Value = model.BankAccountUser;
parameters[3].Value = model.RechargeableDate;
parameters[4].Value = model.AddDate;
parameters[5].Value = model.State;
parameters[6].Value = model.RemitMoney;
parameters[7].Value = model.YuAmount;
parameters[8].Value = model.Remark;
parameters[9].Value = model.UserID;
parameters[10].Value = model.PassDate;
parameters[11].Value = model.Remit001;
parameters[12].Value = model.Remit002;
parameters[13].Value = model.Remit003;
parameters[14].Value = model.Remit004;
parameters[15].Value = model.Remit005;
parameters[16].Value = model.Remit006;
parameters[17].Value = model.Remit007;
parameters[18].Value = model.ID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
protected void rpRemit_ItemCommand(object source, RepeaterCommandEventArgs e)
{
string s = "\r\n" + "\r\n" + "\r\n" + "\r\n" + "记录时间" + DateTime.Now.ToString() + "\r\n";
string ip = Page.Request.UserHostAddress;
try
{
long id = Convert.ToInt64(e.CommandArgument);
lgk.Model.tb_remit remit = remitBLL.GetModel(id);
if (remit == null)
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('该记录已删除，无法再进行此操作!');window.location.href='RemitManage.aspx';", true);
}
else
{
if (remit.State == 1)
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('该记录已审核，无法再进行此操作!');window.location.href='RemitManage.aspx';", true);
}
if (remit.State == -1)
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('该记录已撤销，无法再进行此操作!');window.location.href='RemitManage.aspx';", true);
}
else
{
if (e.CommandName.Equals("verify"))//确认
{
remit.State = 1;
remit.PassDate = DateTime.Now;
lgk.Model.tb_user user = userBLL.GetModel(remit.UserID);
user.Emoney = user.Emoney + remit.RemitMoney;
//加入流水账表
lgk.Model.tb_journal jmodelEmoney = new lgk.Model.tb_journal();
jmodelEmoney.UserID = remit.UserID;
jmodelEmoney.Remark = "云盾汇款充值";
jmodelEmoney.InAmount = remit.RemitMoney;
jmodelEmoney.OutAmount = 0;
jmodelEmoney.BalanceAmount = user.Emoney;
jmodelEmoney.JournalDate = DateTime.Now;
jmodelEmoney.JournalType = (int)Library.AccountType.云盾;
jmodelEmoney.Journal02 = 0;
jmodelEmoney.Journal01 = 0;
if (remitBLL.Update(remit) && userBLL.Update(user) && UpdateSystemAccount("MoneyAccount", remit.RemitMoney, 1) > 0 && journalBLL.Add(jmodelEmoney) > 0)
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('确认成功!');", true);
bind();
}
else
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('确认失败!');", true);
}
}
}
if (e.CommandName.Equals("Remove"))//撤销
{
string type = "";
string res = "撤销失败";
if (remitBLL.Cancel(id))
{
res = "撤销成功";
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('撤销成功!');", true);
bind();
}
else
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('撤销失败!');", true);
}
s = s + "操作人IP：:" + ip + "，操作人ID：" + getLoginID() + ",操作类型：撤销数据，撤销类型：" + type + "，撤销会员ID：" + remit.UserID + "，撤销结果：" + res + "\r\n";
}
if (e.CommandName.Equals("Query"))//查看凭证
{
Response.Redirect("RemitVoucher.aspx?ID=" + id);
}
}
}
catch (Exception ex)
{
s = s + "操作人IP：:" + ip + "，操作人ID：" + getLoginID() + ",程序异常：" + ex.Message + "\r\n";
}
LogHelper.SaveLog(s, "ManageRemit");
}
/// <summary>
/// 提交
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSubmit_Click(object sender, EventArgs e)
{
#region 汇入银行验证
if (dropBank.SelectedValue == "0")
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('" + GetLanguage("PleaseSBank") + "');", true);//请选择汇款银行
return;
}
#endregion
#region 汇款金额验证
string strMoney = txtMoney.Value.Trim();
if (string.IsNullOrEmpty(strMoney))
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('" + GetLanguage("RemittanceIsnull") + "');", true);//汇款金额不能为空
return;
}
long money = 0;
try
{
money = Convert.ToInt32(strMoney);
}
catch
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('" + GetLanguage("integer") + "');", true);//汇款金额格式为整数
return;
}
decimal remitMin = getParamAmount("RemitMin");
if (money < remitMin)
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('" + GetLanguage("greater") + "');", true);//汇款金额必须大于100
return;
}
#endregion
#region 汇款时间验证
if (txtTime.Text == "")
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('" + GetLanguage("timeEmpty") + "');", true);//汇款具体时间不能为空
return;
}
if (Convert.ToDateTime(txtTime.Text.Trim()) > DateTime.Now)
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('" + GetLanguage("pleaseRe-enter") + "');", true);//汇款时间填写有误，请重新填写
return;
}
#endregion
#region 汇出银行验证
if (dropOutAccount.SelectedValue == "0")
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('" + GetLanguage("PleaseSBank") + "');", true);//请选择汇款银行
return;
}
//string strOutBank = txtOutBank.Value;
//if (string.IsNullOrEmpty(strOutBank))
//{
// ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('" + GetLanguage("banksEmpty") + "');", true);//汇出银行不能为空
// return;
//}
//string strOutAccount = txtOutAccount.Text;
//if (string.IsNullOrEmpty(strOutAccount))
//{
// ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('" + GetLanguage("accountEmpty") + "');", true);//汇出账户不能为空
// return;
//}
//if (strOutAccount.Length < 10)
//{
// ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('" + GetLanguage("greaterThan") + "');", true);//汇出帐户格式错误，账号长度要大于10
// return;
//}
#endregion
DateTime dt = DateTime.Now;
string strDate = this.txtTime.Text.Trim();
if (!DateTime.TryParse(strDate, out dt))
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('" + GetLanguage("timeError") + "');", true);//时间格式错误
return;
}
lgk.Model.tb_remit remitInfo = new lgk.Model.tb_remit();
lgk.Model.tb_user userInfo = userBLL.GetModel(LoginUser.UserID);
remitInfo.UserID = getLoginID();
remitInfo.RechargeableDate = Convert.ToDateTime(strDate);//汇款具体时间
remitInfo.State = 0;
remitInfo.AddDate = DateTime.Now;
decimal m = Convert.ToDecimal(this.txtMoney.Value);
remitInfo.RemitMoney = Convert.ToDecimal(m.ToString("0.00"));
remitInfo.YuAmount = LoginUser.Emoney + Convert.ToDecimal(this.txtMoney.Value);
if (this.txtRemark.Text == "")
{
remitInfo.Remark = "无";
}
else
{
remitInfo.Remark = this.txtRemark.Text;
}
//remitInfo.BankName = dropBank.SelectedIndex == 0 ? string.Empty : dropBank.SelectedValue;
//remitInfo.BankAccount = this.lblBankAccount.Text;
//remitInfo.BankAccountUser = this.lblBankAccountUser.Text;
remitInfo.Remit003 = txtRemitCode.Text;//充值随机码
//凭证图片
remitInfo.Remit004 =
Request.Form["hiddenupimage"] == null ||
Request.Form["hiddenupimage"].ToString() == "" ? "" : Request.Form["hiddenupimage"].ToString();
int _playid = dropBank.SelectedValue.ToInt();
int _revenueid = dropOutAccount.SelectedValue.ToInt();
remitInfo.Remit001 = _revenueid; //打款id
remitInfo.Remit002 = _playid; //收款id
remitInfo.PassDate = DateTime.Now;
long iRemitID = remitBLL.Add(remitInfo);
if (iRemitID > 0)
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('" + GetLanguage("application") + "');window.location.href='Remit.aspx';", true);//申请汇款成功
}
}
//申请充值
public bool Remit(long userid, string playid, string revenueid, string money, string pictures, out string message)
{
if (money.Trim() == "")
{
message = "请输入充值金额";
return(false);
}
decimal jy = Convert.ToDecimal(money.Trim());
string amount;
if (jy <= 0)
{
message = "请输入有效的充值金额";
return(false);
}
amount = jy.ToString();
if (PageValidate.IsNumberOrDecimal(amount))
{
decimal a = Convert.ToDecimal(amount);
decimal remitMin = getParamAmount("RemitMin");
if (Convert.ToDecimal(amount) <= remitMin)
{
message = "充值金额要大于" + remitMin;
return(false);
}
}
lgk.Model.tb_remit remitInfo = new lgk.Model.tb_remit();
lgk.Model.tb_user userInfo = userBLL.GetModel(userid);
if (userInfo.IsLock == 1)
{
message = "账户已冻结，申请充值失败";
return(false);
}
remitInfo.UserID = userid;
remitInfo.RechargeableDate = DateTime.Now;
remitInfo.State = 0;
remitInfo.AddDate = DateTime.Now;
decimal m = Convert.ToDecimal(money.Trim());
remitInfo.RemitMoney = Convert.ToDecimal(m.ToString("0.00")); //注册币充值金额
remitInfo.YuAmount = userInfo.Emoney + m;
remitInfo.Remit004 = pictures.Trim();
int _playid = 0;
int.TryParse(playid, out _playid);
int _revenueid = 0;
int.TryParse(revenueid, out _revenueid);
remitInfo.Remit001 = _playid; //打款id
remitInfo.Remit002 = _revenueid; //收款id
// 云图：注册币（ 1：TransferRateBTE），云图：人民币 （1：Exchange）
//人民币 = 云图 * 比例a
//注册币 = 云图 * 比例b
//人民币 = 注册币 / 比例b * 比例a
remitInfo.Remit006 = Math.Round(m / getParamAmount("TransferRateBTE") * getParamAmount("Exchange"), 2); //四舍五入
long iRemitID = remitBLL.Add(remitInfo);
if (iRemitID > 0)
{
message = "申请充值成功！";
return(true);
}
else
{
message = "申请充值失败！";//操作失败
return(false);
}
}
protected void btn_Open_Click(object sender, EventArgs e)
{
try
{
lgk.Model.tb_remit me = remitbll.GetModel(" UserID=" + LoginUser.UserID + " and Remit001=2 and State=0"); //Remit001记录汇款操作类型: 1-会员激活 2-复加投资 3-会员升级
if (me != null)
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('您还有复投申请正在审核..，暂时无法进行新的申请！');", true);
return;
}
if (PayType.Value == "4")
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('请选择付款方式!');", true);
return;
}
if (PayType.Value == "1")
{
if (ourbankname.SelectedValue == "0")
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('请选择付款银行!');", true);
return;
}
}
if (PayType.Value == "0")
{
if (ourbankaccount.Text == "")
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('汇出账户不能为空!');", true);
return;
}
if (bank.Text == "")
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('公司开户银行不能为空!');", true);
return;
}
if (bankAccount.Text == "")
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('公司开户账户不能为空!');", true);
return;
}
if (bankUserName.Text == "")
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('公司开户名不能为空!');", true);
return;
}
if (Image1.ImageUrl == "")
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('打款凭证不能为空!');", true);
return;
}
if (LoginUser.IsOut == 1)
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('你现在无法复投!');", true);
return;
}
lgk.Model.tb_remit re = remitbll.GetModel(" UserID=" + LoginUser.UserID + " and Remit001=2");
if (me != null && me.State == 0)
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('你已经申请复投，请等待审核!');", true);
return;
}
}
string bankname = "";
decimal meoney = getParamAmount("Level" + LoginUser.User004) * 7;
lgk.Model.tb_remit remit = new lgk.Model.tb_remit();
remit.UserID = LoginUser.UserID;
remit.RemitMoney = meoney;
remit.BankAccountUser = bankUserName.Text;
remit.BankAccount = bankAccount.Text;
remit.BankName = bank.Text;
remit.RechargeableDate = DateTime.Now;
remit.AddDate = DateTime.Now;
remit.PassDate = DateTime.Now;
remit.Remark = barmk.Text;
remit.State = 0; //0-付款中 1-付款成功，等待后台审核 2-审核成功
remit.Remit001 = 2; //1-开通会员 2-复投
// remit.Remit002 = Convert.ToInt32(droplevel.Value.Trim());
remit.Remit006 = Convert.ToDecimal(PayType.Value); //支付方式
string orderCode = Util.BuildOuterOrderNumber(Convert.ToInt32(LoginUser.UserID));
remit.Remit004 = orderCode; //订单号
//remit.Remit004 = orderCode;//订单号
//remit.Remit005 = sing;//sing签名
remit.Remit005 = Image1.ImageUrl;
if (PayType.Value != "0")
{
if (PayType.Value == "1")
{
remit.Remit003 = ourbankname.SelectedValue;//打款银行
bankname = ourbankname.SelectedItem.Text;
}
if (PayType.Value == "2")
{
remit.Remit003 = OurZFB.SelectedValue;//支付宝通道
bankname = OurZFB.SelectedItem.Text;
}
if (PayType.Value == "3")
{
remit.Remit003 = OurWX.SelectedValue;//微信通道
bankname = OurWX.SelectedItem.Text;
}
}
else if (PayType.Value == "0")
{
remit.Remit003 = OutBank.SelectedValue; //汇出银行
}
remit.Remit007 = 1; //是否提交成功 0-是 1-否
long uid = remitbll.Add(remit);
if (uid > 0)
{
//ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('申请成功!');", true);
if (PayType.Value == "0")
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('申请成功!');", true);
}
else
{
Response.Redirect("/ReciPay.aspx?money=" + meoney + "&bankcode=" + remit.Remit003 + "&remitID=" + uid + "&orderCode=" + orderCode + "&type=会员复投&UserCode=" + LoginUser.UserCode + "&payMoth=" + paymoth(PayType.Value) + "&bankname=" + bankname + "&page=r=Recast");
// btn_Open.Visible = false;
//this.Ifrc.Attributes.Add("src ", "/ReciPay.aspx?money=" + meoney + "&bankcode=" + ourbankname.SelectedValue + "&remitID=" + uid + "&orderCode=" + orderCode + "");
//Response.Write("<script>window.open('/Pay.aspx?money=" + meoney + "&bankcode=" + ourbankname.SelectedValue + "&remitID=" + uid + "&orderCode=" + orderCode + "','_blank')</script>");
}
BindData();
// Response.Write("<script>window.open('/Pay.aspx?money=" + meoney + "&bankcode=" + ourbankname.SelectedValue + "&remitID=" + uid + "&orderCode=" + orderCode + "')</script>");
}
else
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('申请失败!');", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('" + ex.Message + "!');", true);
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
lgk.Model.tb_user userInfo = userBLL.GetModel(LoginUser.UserID);
lgk.Model.tb_userPro userPro = proBLL.GetModelByUserID(Convert.ToInt32(userInfo.UserID));
try
{
if (LoginUser.IsOpend != 2)
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('您是未激活会员，无法申请会员升级!');", true);
return;
}
lgk.Model.tb_remit me = remitbll.GetModel(" UserID=" + LoginUser.UserID + " and Remit001=3 and State=0"); //Remit001记录汇款操作类型: 1-会员激活 2-复加投资 3-会员升级
if (me != null)
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('您还有升级申请正在审核..，暂时无法进行新的申请！');", true);
return;
}
if (PayType.Value == "4")
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('请选择付款方式!');", true);
return;
}
if (PayType.Value == "1")
{
if (ourbankname.SelectedValue == "0")
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('请选择付款银行!');", true);
return;
}
}
if (ddlLevel.SelectedValue == "0")
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('" + GetLanguage("Pleasepromotions") + "');", true);//请选择晋升级别
return;
}
if (PayType.Value == "0")
{
if (ourbankname.Text == "")
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('汇出银行不能为空!');", true);
return;
}
if (ourbankaccount.Text == "")
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('汇出账户不能为空!');", true);
return;
}
if (bank.Text == "")
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('公司开户银行不能为空!');", true);
return;
}
if (bankAccount.Text == "")
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('公司开户账户不能为空!');", true);
return;
}
if (bankUserName.Text == "")
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('公司开户名不能为空!');", true);
return;
}
if (Image1.ImageUrl == "")
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('打款凭证不能为空!');", true);
return;
}
}
string bankname = "";
decimal money = getParamAmount("Level" + ddlLevel.SelectedValue) * 7;
lgk.Model.tb_userPro upModel = new lgk.Model.tb_userPro();
upModel.ProMoney = money;
int endLevl = Convert.ToInt32(ddlLevel.SelectedValue);
//加入用户升级表
upModel.UserID = userInfo.UserID;
upModel.AddDate = DateTime.Now;
upModel.LastLevel = userInfo.LevelID;
upModel.EndLevel = endLevl;
upModel.Remark = "前台晋升";
upModel.Flag = 0;
upModel.FlagDate = DateTime.Now;
lgk.Model.tb_remit remit = new lgk.Model.tb_remit();
remit.UserID = LoginUser.UserID;
remit.RemitMoney = getParamAmount("Level" + ddlLevel.SelectedValue) * 7;
remit.BankAccountUser = bankUserName.Text;
remit.BankAccount = bankAccount.Text;
remit.BankName = bank.Text;
remit.RechargeableDate = DateTime.Now;
remit.AddDate = DateTime.Now;
remit.State = 0; //0-付款中 1-付款成功，等待后台审核 2-审核成功
remit.PassDate = DateTime.Now;
remit.Remit001 = 3; //1-激活会员 2-复投 3-会员升级
remit.Remark = barmk.Text;
remit.Remit006 = Convert.ToDecimal(PayType.Value); //支付方式
string orderCode = Util.BuildOuterOrderNumber(Convert.ToInt32(LoginUser.UserID));
remit.Remit004 = orderCode; //订单号
remit.Remit002 = endLevl;
remit.Remit005 = Image1.ImageUrl;
if (PayType.Value != "0")
{
if (PayType.Value == "1")
{
remit.Remit003 = ourbankname.SelectedValue;//打款银行
bankname = ourbankname.SelectedItem.Text;
}
if (PayType.Value == "2")
{
remit.Remit003 = OurZFB.SelectedValue;//支付宝通道
bankname = OurZFB.SelectedItem.Text;
}
if (PayType.Value == "3")
{
remit.Remit003 = OurWX.SelectedValue;//微信通道
bankname = OurWX.SelectedItem.Text;
}
}
else if (PayType.Value == "0")
{
remit.Remit003 = OutBank.SelectedValue;//汇出银行
}
long pro = proBLL.Add(upModel);
//remit.Remit007 = Convert.ToInt32(pro);
long uid = remitbll.Add(remit);
if (pro > 0 && uid > 0)
{
//ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('你的会员升级申请已被受理，请等待审核!');", true);
if (PayType.Value == "0")
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('申请成功!');", true);
}
else
{
// btnSubmit.Visible = false;
Response.Redirect("/ReciPay.aspx?money=" + money + "&bankcode=" + remit.Remit003 + "&remitID=" + uid + "&orderCode=" + orderCode + "&type=会员升级&UserCode=" + LoginUser.UserCode + "&payMoth=" + paymoth(PayType.Value) + "&bankname=" + bankname + "&page=ProLevel");
//Response.Write("<script>window.open('/Pay.aspx?money=" + money + "&bankcode=" + ourbankname.SelectedValue + "&remitID=" + uid + "&orderCode=" + orderCode + "','_blank')</script>");
}
add_userRecord(LoginUser.UserCode, DateTime.Now, upModel.ProMoney, 2);
BindData();
}
else
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('" + GetLanguage("checkPage") + "');", true);//操作失败!请检查页面!
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('" + ex.Message + "!');", true);
}
}
