protected void btnSumit_Click(object sender, EventArgs e) { lgk.Model.tb_userPro upModel = new lgk.Model.tb_userPro(); lgk.Model.tb_user userInfo = userBLL.GetModelByUserCode(TxtCode.Text.Trim()); if (userInfo == null) { ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('会员不存在!');", true); return; } upModel.ProMoney = 0;//Convert.ToInt32(txtMoney.Text); int endLevl = Convert.ToInt32(dropLevel.SelectedValue); if (endLevl == userInfo.LevelID) { ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('选择与当前不同的等级!');", true); return; } if (flag_pro(userInfo.UserID, endLevl, 1)) { ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('操作成功!');", true); bind_pro(); } else { ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('操作失败!');", true); return; } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(lgk.Model.tb_userPro model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tb_userPro("); strSql.Append("UserID,LastLevel,EndLevel,ProMoney,AddDate,FlagDate,Remark,Flag,Pro001,Pro002,Pro003,Pro004,Pro005,Pro006,Pro007,Pro008)"); strSql.Append(" values ("); strSql.Append("@UserID,@LastLevel,@EndLevel,@ProMoney,@AddDate,@FlagDate,@Remark,@Flag,@Pro001,@Pro002,@Pro003,@Pro004,@Pro005,@Pro006,@Pro007,@Pro008)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@UserID", SqlDbType.BigInt, 8), new SqlParameter("@LastLevel", SqlDbType.Int, 4), new SqlParameter("@EndLevel", SqlDbType.Int, 4), new SqlParameter("@ProMoney", SqlDbType.Decimal, 9), new SqlParameter("@AddDate", SqlDbType.DateTime), new SqlParameter("@FlagDate", SqlDbType.DateTime), new SqlParameter("@Remark", SqlDbType.VarChar, 100), new SqlParameter("@Flag", SqlDbType.Int, 4), new SqlParameter("@Pro001", SqlDbType.Int, 4), new SqlParameter("@Pro002", SqlDbType.Int, 4), new SqlParameter("@Pro003", SqlDbType.Decimal, 9), new SqlParameter("@Pro004", SqlDbType.Decimal, 9), new SqlParameter("@Pro005", SqlDbType.Decimal, 9), new SqlParameter("@Pro006", SqlDbType.VarChar, 50), new SqlParameter("@Pro007", SqlDbType.VarChar, 50), new SqlParameter("@Pro008", SqlDbType.VarChar, 50) }; parameters[0].Value = model.UserID; parameters[1].Value = model.LastLevel; parameters[2].Value = model.EndLevel; parameters[3].Value = model.ProMoney; parameters[4].Value = model.AddDate; parameters[5].Value = model.FlagDate; parameters[6].Value = model.Remark; parameters[7].Value = model.Flag; parameters[8].Value = model.Pro001; parameters[9].Value = model.Pro002; parameters[10].Value = model.Pro003; parameters[11].Value = model.Pro004; parameters[12].Value = model.Pro005; parameters[13].Value = model.Pro006; parameters[14].Value = model.Pro007; parameters[15].Value = model.Pro008; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
protected void btnSumit_Click(object sender, EventArgs e) { lgk.Model.tb_userPro upModel = new lgk.Model.tb_userPro(); lgk.Model.tb_user userInfo = userBLL.GetModel(" UserCode='" + TxtCode.Text + "'"); if (userInfo == null) { ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('会员不存在!');", true); return; } upModel.ProMoney = Convert.ToInt32(txtMoney.Text); int endLevl = Convert.ToInt32(dropLevel.SelectedValue); //加入用户升级表 upModel.UserID = userInfo.UserID; upModel.AddDate = DateTime.Now; upModel.LastLevel = userInfo.LevelID; upModel.EndLevel = endLevl; upModel.Remark = "后台晋升"; upModel.Flag = 1; upModel.FlagDate = DateTime.Now; //lgk.Model.tb_remit remit = new lgk.Model.tb_remit(); //remit.UserID = userInfo.UserID; //remit.RemitMoney = Convert.ToDecimal(txtMoney.Text); //remit.BankAccountUser = ""; //remit.BankAccount =""; //remit.BankName = ""; //remit.RechargeableDate = DateTime.Now; //remit.AddDate = DateTime.Now; //remit.State = 1; //remit.PassDate = DateTime.Now; //remit.Remit001 = 3; //1-激活会员 2-复投 3-会员升级 //remit.Remark = ""; //remit.Remit003 = ""; //remit.Remit004 = ""; //remit.Remit005 = ""; if (userInfo.LevelID > endLevl)//降级 { userInfo.RegMoney = getParamAmount("Level" + endLevl); //userInfo.Emoney = getParamAmount("consume" + endLevl); } userInfo.LevelID = endLevl; long pro = proBLL.Add(upModel); userBLL.Update(userInfo); // long uid = remitbll.Add(remit); if (pro > 0) { add_userRecord(userInfo.UserCode, DateTime.Now, upModel.ProMoney, 2); ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('操作成功!');", true); bind_pro(); } }
/// <summary> /// 得到一个对象实体 /// </summary> public lgk.Model.tb_userPro GetModelByUserID(int UserID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,UserID,LastLevel,EndLevel,ProMoney,AddDate,FlagDate,Remark,Flag,Pro001,Pro002,Pro003,Pro004,Pro005,Pro006,Pro007,Pro008 from tb_userPro"); strSql.Append(" where UserID=@UserID order by ID desc"); SqlParameter[] parameters = { new SqlParameter("@UserID", SqlDbType.Int, 4) }; parameters[0].Value = UserID; lgk.Model.tb_userPro model = new lgk.Model.tb_userPro(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["ID"] != null && ds.Tables[0].Rows[0]["ID"].ToString() != "") { model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].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]["LastLevel"] != null && ds.Tables[0].Rows[0]["LastLevel"].ToString() != "") { model.LastLevel = int.Parse(ds.Tables[0].Rows[0]["LastLevel"].ToString()); } if (ds.Tables[0].Rows[0]["EndLevel"] != null && ds.Tables[0].Rows[0]["EndLevel"].ToString() != "") { model.EndLevel = int.Parse(ds.Tables[0].Rows[0]["EndLevel"].ToString()); } if (ds.Tables[0].Rows[0]["ProMoney"] != null && ds.Tables[0].Rows[0]["ProMoney"].ToString() != "") { model.ProMoney = decimal.Parse(ds.Tables[0].Rows[0]["ProMoney"].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]["FlagDate"] != null && ds.Tables[0].Rows[0]["FlagDate"].ToString() != "") { model.FlagDate = DateTime.Parse(ds.Tables[0].Rows[0]["FlagDate"].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]["Flag"] != null && ds.Tables[0].Rows[0]["Flag"].ToString() != "") { model.Flag = int.Parse(ds.Tables[0].Rows[0]["Flag"].ToString()); } if (ds.Tables[0].Rows[0]["Pro001"] != null && ds.Tables[0].Rows[0]["Pro001"].ToString() != "") { model.Pro001 = int.Parse(ds.Tables[0].Rows[0]["Pro001"].ToString()); } if (ds.Tables[0].Rows[0]["Pro002"] != null && ds.Tables[0].Rows[0]["Pro002"].ToString() != "") { model.Pro002 = int.Parse(ds.Tables[0].Rows[0]["Pro002"].ToString()); } if (ds.Tables[0].Rows[0]["Pro003"] != null && ds.Tables[0].Rows[0]["Pro003"].ToString() != "") { model.Pro003 = decimal.Parse(ds.Tables[0].Rows[0]["Pro003"].ToString()); } if (ds.Tables[0].Rows[0]["Pro004"] != null && ds.Tables[0].Rows[0]["Pro004"].ToString() != "") { model.Pro004 = decimal.Parse(ds.Tables[0].Rows[0]["Pro004"].ToString()); } if (ds.Tables[0].Rows[0]["Pro005"] != null && ds.Tables[0].Rows[0]["Pro005"].ToString() != "") { model.Pro005 = decimal.Parse(ds.Tables[0].Rows[0]["Pro005"].ToString()); } if (ds.Tables[0].Rows[0]["Pro006"] != null && ds.Tables[0].Rows[0]["Pro006"].ToString() != "") { model.Pro006 = ds.Tables[0].Rows[0]["Pro006"].ToString(); } if (ds.Tables[0].Rows[0]["Pro007"] != null && ds.Tables[0].Rows[0]["Pro007"].ToString() != "") { model.Pro007 = ds.Tables[0].Rows[0]["Pro007"].ToString(); } if (ds.Tables[0].Rows[0]["Pro008"] != null && ds.Tables[0].Rows[0]["Pro008"].ToString() != "") { model.Pro008 = ds.Tables[0].Rows[0]["Pro008"].ToString(); } return(model); } else { return(null); } }
public lgk.Model.tb_userPro GetModel(string strwhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,UserID,LastLevel,EndLevel,ProMoney,AddDate,FlagDate,Remark,Flag,Pro001,Pro002,Pro003,Pro004,Pro005,Pro006,Pro007,Pro008 from tb_userPro "); if (strwhere != "") { strSql.Append(" where " + strwhere); } lgk.Model.tb_userPro model = new lgk.Model.tb_userPro(); 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 = int.Parse(ds.Tables[0].Rows[0]["ID"].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]["LastLevel"] != null && ds.Tables[0].Rows[0]["LastLevel"].ToString() != "") { model.LastLevel = int.Parse(ds.Tables[0].Rows[0]["LastLevel"].ToString()); } if (ds.Tables[0].Rows[0]["EndLevel"] != null && ds.Tables[0].Rows[0]["EndLevel"].ToString() != "") { model.EndLevel = int.Parse(ds.Tables[0].Rows[0]["EndLevel"].ToString()); } if (ds.Tables[0].Rows[0]["ProMoney"] != null && ds.Tables[0].Rows[0]["ProMoney"].ToString() != "") { model.ProMoney = decimal.Parse(ds.Tables[0].Rows[0]["ProMoney"].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]["FlagDate"] != null && ds.Tables[0].Rows[0]["FlagDate"].ToString() != "") { model.FlagDate = DateTime.Parse(ds.Tables[0].Rows[0]["FlagDate"].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]["Flag"] != null && ds.Tables[0].Rows[0]["Flag"].ToString() != "") { model.Flag = int.Parse(ds.Tables[0].Rows[0]["Flag"].ToString()); } if (ds.Tables[0].Rows[0]["Pro001"] != null && ds.Tables[0].Rows[0]["Pro001"].ToString() != "") { model.Pro001 = int.Parse(ds.Tables[0].Rows[0]["Pro001"].ToString()); } if (ds.Tables[0].Rows[0]["Pro002"] != null && ds.Tables[0].Rows[0]["Pro002"].ToString() != "") { model.Pro002 = int.Parse(ds.Tables[0].Rows[0]["Pro002"].ToString()); } if (ds.Tables[0].Rows[0]["Pro003"] != null && ds.Tables[0].Rows[0]["Pro003"].ToString() != "") { model.Pro003 = decimal.Parse(ds.Tables[0].Rows[0]["Pro003"].ToString()); } if (ds.Tables[0].Rows[0]["Pro004"] != null && ds.Tables[0].Rows[0]["Pro004"].ToString() != "") { model.Pro004 = decimal.Parse(ds.Tables[0].Rows[0]["Pro004"].ToString()); } if (ds.Tables[0].Rows[0]["Pro005"] != null && ds.Tables[0].Rows[0]["Pro005"].ToString() != "") { model.Pro005 = decimal.Parse(ds.Tables[0].Rows[0]["Pro005"].ToString()); } if (ds.Tables[0].Rows[0]["Pro006"] != null && ds.Tables[0].Rows[0]["Pro006"].ToString() != "") { model.Pro006 = ds.Tables[0].Rows[0]["Pro006"].ToString(); } if (ds.Tables[0].Rows[0]["Pro007"] != null && ds.Tables[0].Rows[0]["Pro007"].ToString() != "") { model.Pro007 = ds.Tables[0].Rows[0]["Pro007"].ToString(); } if (ds.Tables[0].Rows[0]["Pro008"] != null && ds.Tables[0].Rows[0]["Pro008"].ToString() != "") { model.Pro008 = ds.Tables[0].Rows[0]["Pro008"].ToString(); } return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(lgk.Model.tb_userPro model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tb_userPro set "); strSql.Append("UserID=@UserID,"); strSql.Append("LastLevel=@LastLevel,"); strSql.Append("EndLevel=@EndLevel,"); strSql.Append("ProMoney=@ProMoney,"); strSql.Append("AddDate=@AddDate,"); strSql.Append("FlagDate=@FlagDate,"); strSql.Append("Remark=@Remark,"); strSql.Append("Flag=@Flag,"); strSql.Append("Pro001=@Pro001,"); strSql.Append("Pro002=@Pro002,"); strSql.Append("Pro003=@Pro003,"); strSql.Append("Pro004=@Pro004,"); strSql.Append("Pro005=@Pro005,"); strSql.Append("Pro006=@Pro006,"); strSql.Append("Pro007=@Pro007,"); strSql.Append("Pro008=@Pro008"); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@UserID", SqlDbType.BigInt, 8), new SqlParameter("@LastLevel", SqlDbType.Int, 4), new SqlParameter("@EndLevel", SqlDbType.Int, 4), new SqlParameter("@ProMoney", SqlDbType.Decimal, 9), new SqlParameter("@AddDate", SqlDbType.DateTime), new SqlParameter("@FlagDate", SqlDbType.DateTime), new SqlParameter("@Remark", SqlDbType.VarChar, 100), new SqlParameter("@Flag", SqlDbType.Int, 4), new SqlParameter("@Pro001", SqlDbType.Int, 4), new SqlParameter("@Pro002", SqlDbType.Int, 4), new SqlParameter("@Pro003", SqlDbType.Decimal, 9), new SqlParameter("@Pro004", SqlDbType.Decimal, 9), new SqlParameter("@Pro005", SqlDbType.Decimal, 9), new SqlParameter("@Pro006", SqlDbType.VarChar, 50), new SqlParameter("@Pro007", SqlDbType.VarChar, 50), new SqlParameter("@Pro008", SqlDbType.VarChar, 50), new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = model.UserID; parameters[1].Value = model.LastLevel; parameters[2].Value = model.EndLevel; parameters[3].Value = model.ProMoney; parameters[4].Value = model.AddDate; parameters[5].Value = model.FlagDate; parameters[6].Value = model.Remark; parameters[7].Value = model.Flag; parameters[8].Value = model.Pro001; parameters[9].Value = model.Pro002; parameters[10].Value = model.Pro003; parameters[11].Value = model.Pro004; parameters[12].Value = model.Pro005; parameters[13].Value = model.Pro006; parameters[14].Value = model.Pro007; parameters[15].Value = model.Pro008; parameters[16].Value = model.ID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
protected void btnSubmit_Click(object sender, EventArgs e) { lgk.Model.tb_user userInfo = userBLL.GetModel(LoginUser.UserID); if (userInfo != null) { if (userInfo.IsOpend == 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; } else if (proBLL.GetModelByUserID(Convert.ToInt32(userInfo.UserID)) != null) { if (proBLL.GetModelByUserID(Convert.ToInt32(userInfo.UserID)).Flag == 0) { ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('" + GetLanguage("audit") + "');", true);//您已提交申请,请等待审核 return; } } else { //判断会员级别是否开启 //var leveOpen = getParamAmount("Leve_open" + ddlLevel.SelectedValue); //if (leveOpen == 0) //{ // ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('" + GetLanguage("membershipClosed") + "');", true);//该会员级别已关闭 // return; //} //var billMoney = getParamAmount("billMoney"); //decimal money = getParamAmount("Level" + ddlLevel.SelectedValue) * billMoney; decimal money = getParamAmount("Level" + ddlLevel.SelectedValue); lgk.Model.tb_userPro upModel = new lgk.Model.tb_userPro(); if (userInfo.StockAccount >= money) { upModel.ProMoney = money; upModel.Pro003 = userInfo.StockAccount - upModel.ProMoney; //所剩奖金积分(此时为月静态钱包奖金积分) upModel.Pro001 = 1; //扣除的奖金积分类型( 1表示月静态钱包奖金积分 2表示月动态钱包奖金积分 ) } else if (userInfo.StockMoney >= money) { upModel.ProMoney = money; upModel.Pro003 = userInfo.StockMoney - upModel.ProMoney; //所剩奖金积分(此时为月分红动态钱包奖金积分) upModel.Pro001 = 2; //扣除的奖金积分类型( 1表示月静态钱包奖金积分 2表示月动态钱包奖金积分 ) } else { ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('您的奖金积分不足,无法晋升');", true);//奖金积分不足,无法晋升 return; } int endLevl = Convert.ToInt32(ddlLevel.SelectedValue); //加入用户升级表 upModel.UserID = userInfo.UserID; upModel.AddDate = DateTime.Now; upModel.LastLevel = userInfo.LevelID; upModel.EndLevel = endLevl; upModel.Remark = "自身晋升"; upModel.FlagDate = DateTime.Now; upModel.Flag = 0; if (proBLL.Add(upModel) > 0) { add_userRecord(LoginUser.UserCode, DateTime.Now, upModel.ProMoney, 2); ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('升级申请成功!请等待审核..');window.location.href='Pro.aspx';", true);// } else { ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('" + GetLanguage("checkPage") + "');", true);//操作失败!请检查页面! } bind_pro(); } } else { ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('" + GetLanguage("checkPage") + "');", 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); } }