/// <summary> /// 更新一条数据 /// </summary> public static bool Check(UserPayBankAppInfo model) { try { int rowsAffected = 0; SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4), new SqlParameter("@status", SqlDbType.TinyInt, 1), new SqlParameter("@SureTime", SqlDbType.DateTime), new SqlParameter("@SureUser", SqlDbType.Int, 4) }; parameters[0].Value = model.id; parameters[1].Value = (int)model.status; parameters[2].Value = model.SureTime; parameters[3].Value = model.SureUser; rowsAffected = DataBase.ExecuteNonQuery(CommandType.StoredProcedure, "proc_userspaybankapp_Check", parameters); if (rowsAffected > 0) { UserFactory.ClearCache(model.userid); return(true); } else { return(false); } } catch (Exception ex) { ExceptionHandler.HandleException(ex); return(false); } }
protected void rptApps_ItemCommand(object source, RepeaterCommandEventArgs e) { int appId = int.Parse(e.CommandArgument.ToString()); UserPayBankAppInfo info = viviapi.BLL.User.SettlementAccountApply.GetModel(appId); //info.id = appId; if (e.CommandName == "pass") { info.status = AcctChangeEnum.审核成功; } else if (e.CommandName == "fail") { info.status = AcctChangeEnum.审核失败; } info.SureTime = DateTime.Now; info.SureUser = currentManage.id; if (viviapi.BLL.User.SettlementAccountApply.Check(info)) { AlertAndRedirect("操作成功", "SettleAccountBill.aspx"); } else { AlertAndRedirect("操作失败", "SettleAccountBill.aspx"); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(UserPayBankAppInfo model) { var strSql = new StringBuilder(); strSql.Append("insert into userspaybankapp("); strSql.Append( "userid,accoutType,pmode,account,payeeName,payeeBank,bankProvince,bankCity,bankAddress,status,AddTime,SureTime,SureUser,BankCode,provinceCode,cityCode,Reason)"); strSql.Append(" values ("); strSql.Append( "@userid,@accoutType,@pmode,@account,@payeeName,@payeeBank,@bankProvince,@bankCity,@bankAddress,@status,@AddTime,@SureTime,@SureUser,@BankCode,@provinceCode,@cityCode,@Reason)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@userid", SqlDbType.Int, 4), new SqlParameter("@accoutType", SqlDbType.TinyInt, 1), new SqlParameter("@pmode", SqlDbType.TinyInt, 1), new SqlParameter("@account", SqlDbType.VarChar, 50), new SqlParameter("@payeeName", SqlDbType.VarChar, 50), new SqlParameter("@payeeBank", SqlDbType.VarChar, 50), new SqlParameter("@bankProvince", SqlDbType.VarChar, 50), new SqlParameter("@bankCity", SqlDbType.VarChar, 50), new SqlParameter("@bankAddress", SqlDbType.VarChar, 100), new SqlParameter("@status", SqlDbType.TinyInt, 1), new SqlParameter("@AddTime", SqlDbType.DateTime), new SqlParameter("@SureTime", SqlDbType.DateTime), new SqlParameter("@SureUser", SqlDbType.Int, 4), new SqlParameter("@BankCode", SqlDbType.VarChar, 50), new SqlParameter("@provinceCode", SqlDbType.VarChar, 50), new SqlParameter("@cityCode", SqlDbType.VarChar, 50), new SqlParameter("@Reason", SqlDbType.NVarChar, 500) }; parameters[0].Value = model.userid; parameters[1].Value = model.accoutType; parameters[2].Value = model.pmode; parameters[3].Value = model.account; parameters[4].Value = model.payeeName; parameters[5].Value = model.payeeBank; parameters[6].Value = model.bankProvince; parameters[7].Value = model.bankCity; parameters[8].Value = model.bankAddress; parameters[9].Value = model.status; parameters[10].Value = model.AddTime; parameters[11].Value = model.SureTime; parameters[12].Value = model.SureUser; parameters[13].Value = model.BankCode; parameters[14].Value = model.provinceCode; parameters[15].Value = model.cityCode; parameters[16].Value = model.Reason; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } return(Convert.ToInt32(obj)); }
/// <summary> /// /// </summary> /// <param name="id"></param> /// <returns></returns> public static UserPayBankAppInfo GetModel(int id) { SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; UserPayBankAppInfo model = new UserPayBankAppInfo(); DataSet ds = DataBase.ExecuteDataset(CommandType.StoredProcedure, "proc_userspaybankapp_GetModel", parameters); if (ds.Tables[0].Rows.Count > 0) { if (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"].ToString() != "") { model.userid = int.Parse(ds.Tables[0].Rows[0]["userid"].ToString()); } if (ds.Tables[0].Rows[0]["pmode"].ToString() != "") { model.pmode = int.Parse(ds.Tables[0].Rows[0]["pmode"].ToString()); } model.account = ds.Tables[0].Rows[0]["account"].ToString(); model.payeeName = ds.Tables[0].Rows[0]["payeeName"].ToString(); model.payeeBank = ds.Tables[0].Rows[0]["payeeBank"].ToString(); model.bankProvince = ds.Tables[0].Rows[0]["bankProvince"].ToString(); model.bankCity = ds.Tables[0].Rows[0]["bankCity"].ToString(); model.bankAddress = ds.Tables[0].Rows[0]["bankAddress"].ToString(); if (ds.Tables[0].Rows[0]["status"].ToString() != "") { model.status = (AcctChangeEnum)int.Parse(ds.Tables[0].Rows[0]["status"].ToString()); } if (ds.Tables[0].Rows[0]["AddTime"].ToString() != "") { model.AddTime = DateTime.Parse(ds.Tables[0].Rows[0]["AddTime"].ToString()); } if (ds.Tables[0].Rows[0]["SureTime"].ToString() != "") { model.SureTime = DateTime.Parse(ds.Tables[0].Rows[0]["SureTime"].ToString()); } if (ds.Tables[0].Rows[0]["SureUser"].ToString() != "") { model.SureUser = int.Parse(ds.Tables[0].Rows[0]["SureUser"].ToString()); } return(model); } else { return(null); } }
public static int Insert(UserPayBankAppInfo model) { try { return(_dal.Insert(model)); } catch (Exception ex) { ExceptionHandler.HandleException(ex); return(0); } }
/// <summary> /// 更新一条数据 /// </summary> public static bool Update(UserPayBankAppInfo model) { try { int rowsAffected = 0; SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4), new SqlParameter("@userid", SqlDbType.Int, 4), new SqlParameter("@pmode", SqlDbType.TinyInt, 1), new SqlParameter("@account", SqlDbType.VarChar, 50), new SqlParameter("@payeeName", SqlDbType.VarChar, 50), new SqlParameter("@payeeBank", SqlDbType.VarChar, 50), new SqlParameter("@bankProvince", SqlDbType.VarChar, 50), new SqlParameter("@bankCity", SqlDbType.VarChar, 50), new SqlParameter("@bankAddress", SqlDbType.VarChar, 100), new SqlParameter("@status", SqlDbType.TinyInt, 1), new SqlParameter("@AddTime", SqlDbType.DateTime), new SqlParameter("@SureTime", SqlDbType.DateTime), new SqlParameter("@SureUser", SqlDbType.Int, 4) }; parameters[0].Value = model.id; parameters[1].Value = model.userid; parameters[2].Value = model.pmode; parameters[3].Value = model.account; parameters[4].Value = model.payeeName; parameters[5].Value = model.payeeBank; parameters[6].Value = model.bankProvince; parameters[7].Value = model.bankCity; parameters[8].Value = model.bankAddress; parameters[9].Value = model.status; parameters[10].Value = model.AddTime; parameters[11].Value = model.SureTime; parameters[12].Value = model.SureUser; rowsAffected = DataBase.ExecuteNonQuery(CommandType.StoredProcedure, "proc_userspaybankapp_Update", parameters); if (rowsAffected > 0) { return(true); } else { return(false); } } catch (Exception ex) { ExceptionHandler.HandleException(ex); return(false); } }
public int Insert(UserPayBankAppInfo model) { SqlParameter[] parameters = { new SqlParameter("@userid", SqlDbType.Int, 4), new SqlParameter("@accoutType", SqlDbType.TinyInt, 1), new SqlParameter("@pmode", SqlDbType.TinyInt, 1), new SqlParameter("@account", SqlDbType.VarChar, 50), new SqlParameter("@payeeName", SqlDbType.VarChar, 50), new SqlParameter("@payeeBank", SqlDbType.VarChar, 50), new SqlParameter("@bankProvince", SqlDbType.VarChar, 50), new SqlParameter("@bankCity", SqlDbType.VarChar, 50), new SqlParameter("@bankAddress", SqlDbType.VarChar, 100), new SqlParameter("@status", SqlDbType.TinyInt, 1), new SqlParameter("@AddTime", SqlDbType.DateTime), new SqlParameter("@SureTime", SqlDbType.DateTime), new SqlParameter("@SureUser", SqlDbType.Int, 4), new SqlParameter("@BankCode", SqlDbType.VarChar, 50), new SqlParameter("@provinceCode", SqlDbType.VarChar, 50), new SqlParameter("@cityCode", SqlDbType.VarChar, 50), new SqlParameter("@Reason", SqlDbType.NVarChar, 500) }; parameters[0].Value = model.userid; parameters[1].Value = model.accoutType; parameters[2].Value = model.pmode; parameters[3].Value = model.account; parameters[4].Value = model.payeeName; parameters[5].Value = model.payeeBank; parameters[6].Value = model.bankProvince; parameters[7].Value = model.bankCity; parameters[8].Value = model.bankAddress; parameters[9].Value = (int)model.status; parameters[10].Value = model.AddTime; parameters[11].Value = model.SureTime; parameters[12].Value = model.SureUser; parameters[13].Value = model.BankCode; parameters[14].Value = model.provinceCode; parameters[15].Value = model.cityCode; parameters[16].Value = model.Reason; object obj = DataBase.ExecuteScalar(CommandType.StoredProcedure, "proc_userspaybankapp_insert", parameters); if (obj == null) { return(0); } return(Convert.ToInt32(obj)); }
/// <summary> /// 得到一个对象实体 /// </summary> public UserPayBankAppInfo GetModel(int id) { var strSql = new StringBuilder(); strSql.Append( "select top 1 id,userid,accoutType,pmode,account,payeeName,payeeBank,bankProvince,bankCity,bankAddress,status,AddTime,SureTime,SureUser,BankCode,provinceCode,cityCode,Reason from userspaybankapp "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; var model = new UserPayBankAppInfo(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } return(null); }
protected void btnSave_Click(object sender, EventArgs e) { string msg = ""; int pmode = 1; if (rb_alipay.Checked) { pmode = 2; } else if (rb_tenpay.Checked) { pmode = 3; } string oldaccount = this.txtoldaccount.Value.Trim(); string bankname = this.ddlbankName.Items[ddlbankName.SelectedIndex].Text; string bankAddress = this.txtbankAddress.Value; string account = txtaccount.Value; string reaccount = txtreaccount.Value; if (Model != null) { if (!string.IsNullOrEmpty(Model.Account)) { if (string.IsNullOrEmpty(oldaccount)) { msg = "原银行卡号不能为空"; } else if (oldaccount != Model.Account) { msg = "原银行卡号不正确"; } else if (this.txtoldaccount.Value != Model.Account) { msg = "原银行卡号不正确"; } } } if (pmode == 1) { if (string.IsNullOrEmpty(this.ddlprovince.SelectedValue)) { msg = "请选择省份"; } else if (string.IsNullOrEmpty(this.ddlcity.SelectedValue)) { msg = "请选择城市"; } else if (string.IsNullOrEmpty(bankname)) { msg = "开户银行不能为空"; } else if (string.IsNullOrEmpty(bankAddress)) { msg = "支行名称不能为空"; } } if (string.IsNullOrEmpty(account)) { msg = "个人银行帐号不能为空"; } if (account != reaccount) { msg = "个人银行帐号与确认个人银行帐号必须一致"; } if (string.IsNullOrEmpty(msg)) { int accoutType = 0; if (rb_accoutType1.Checked) { accoutType = 1; } var appmodel = new UserPayBankAppInfo { userid = CurrentUser.ID, accoutType = accoutType, pmode = pmode, account = account, payeeName = this.CurrentUser.full_name, payeeBank = string.Empty, bankProvince = string.Empty, bankCity = string.Empty, bankAddress = string.Empty, BankCode = string.Empty, provinceCode = string.Empty, cityCode = string.Empty }; if (pmode == 1) { string bankCode = ddlbankName.Items[ddlbankName.SelectedIndex].Value; if (!string.IsNullOrEmpty(bankCode)) { appmodel.BankCode = ddlbankName.Items[ddlbankName.SelectedIndex].Value; appmodel.payeeBank = ddlbankName.Items[ddlbankName.SelectedIndex].Text; } string bankProvince = ddlprovince.Items[ddlprovince.SelectedIndex].Text; if (!string.IsNullOrEmpty(bankProvince)) { appmodel.bankProvince = bankProvince; appmodel.provinceCode = ddlprovince.Items[ddlprovince.SelectedIndex].Value; } string bankCity = ddlcity.Items[ddlcity.SelectedIndex].Text; if (!string.IsNullOrEmpty(bankCity)) { appmodel.bankCity = ddlcity.Items[ddlcity.SelectedIndex].Text; appmodel.cityCode = ddlcity.Items[ddlcity.SelectedIndex].Value; } appmodel.bankAddress = bankAddress; } else if (pmode == 2) { appmodel.BankCode = "0002"; appmodel.payeeBank = "支付宝"; } else if (pmode == 3) { appmodel.BankCode = "0003"; appmodel.payeeBank = "财付通"; } appmodel.status = AcctChangeEnum.待审核; appmodel.AddTime = DateTime.Now; appmodel.SureTime = DateTime.Now; appmodel.SureUser = 0; int id = viviapi.BLL.User.SettlementAccountApply.Insert(appmodel); if (id > 0) { UserPayBankAppInfo info = viviapi.BLL.User.SettlementAccountApply.GetModel(id); info.status = AcctChangeEnum.审核成功; info.SureTime = DateTime.Now; info.SureUser = 0; bool suc = viviapi.BLL.User.SettlementAccountApply.Check(info); viviapi.BLL.User.SettlementAccountApply.Delete(id); this.btnSave.Enabled = false; msg = "结算账户修改成功"; } else { msg = "操作失败"; } } this.callinfo.InnerText = msg; string script = "<script language='javascript'>alert('" + msg + "');</script>"; Page.ClientScript.RegisterStartupScript(Page.GetType(), "costinfo", script); InitForm(); }
/// <summary> /// 得到一个对象实体 /// </summary> public UserPayBankAppInfo DataRowToModel(DataRow row) { var model = new UserPayBankAppInfo(); if (row != null) { if (row["id"] != null && row["id"].ToString() != "") { model.id = int.Parse(row["id"].ToString()); } if (row["userid"] != null && row["userid"].ToString() != "") { model.userid = int.Parse(row["userid"].ToString()); } if (row["accoutType"] != null && row["accoutType"].ToString() != "") { model.accoutType = int.Parse(row["accoutType"].ToString()); } if (row["pmode"] != null && row["pmode"].ToString() != "") { model.pmode = int.Parse(row["pmode"].ToString()); } if (row["account"] != null) { model.account = row["account"].ToString(); } if (row["payeeName"] != null) { model.payeeName = row["payeeName"].ToString(); } if (row["payeeBank"] != null) { model.payeeBank = row["payeeBank"].ToString(); } if (row["bankProvince"] != null) { model.bankProvince = row["bankProvince"].ToString(); } if (row["bankCity"] != null) { model.bankCity = row["bankCity"].ToString(); } if (row["bankAddress"] != null) { model.bankAddress = row["bankAddress"].ToString(); } if (row["status"] != null && row["status"].ToString() != "") { model.status = (AcctChangeEnum)int.Parse(row["status"].ToString()); } if (row["AddTime"] != null && row["AddTime"].ToString() != "") { model.AddTime = DateTime.Parse(row["AddTime"].ToString()); } if (row["SureTime"] != null && row["SureTime"].ToString() != "") { model.SureTime = DateTime.Parse(row["SureTime"].ToString()); } if (row["SureUser"] != null && row["SureUser"].ToString() != "") { model.SureUser = int.Parse(row["SureUser"].ToString()); } if (row["BankCode"] != null) { model.BankCode = row["BankCode"].ToString(); } if (row["provinceCode"] != null) { model.provinceCode = row["provinceCode"].ToString(); } if (row["cityCode"] != null) { model.cityCode = row["cityCode"].ToString(); } if (row["Reason"] != null) { model.Reason = row["Reason"].ToString(); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(UserPayBankAppInfo model) { var strSql = new StringBuilder(); strSql.Append("update userspaybankapp set "); strSql.Append("userid=@userid,"); strSql.Append("accoutType=@accoutType,"); strSql.Append("pmode=@pmode,"); strSql.Append("account=@account,"); strSql.Append("payeeName=@payeeName,"); strSql.Append("payeeBank=@payeeBank,"); strSql.Append("bankProvince=@bankProvince,"); strSql.Append("bankCity=@bankCity,"); strSql.Append("bankAddress=@bankAddress,"); strSql.Append("status=@status,"); strSql.Append("AddTime=@AddTime,"); strSql.Append("SureTime=@SureTime,"); strSql.Append("SureUser=@SureUser,"); strSql.Append("BankCode=@BankCode,"); strSql.Append("provinceCode=@provinceCode,"); strSql.Append("cityCode=@cityCode,"); strSql.Append("Reason=@Reason"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@userid", SqlDbType.Int, 4), new SqlParameter("@accoutType", SqlDbType.TinyInt, 1), new SqlParameter("@pmode", SqlDbType.TinyInt, 1), new SqlParameter("@account", SqlDbType.VarChar, 50), new SqlParameter("@payeeName", SqlDbType.VarChar, 50), new SqlParameter("@payeeBank", SqlDbType.VarChar, 50), new SqlParameter("@bankProvince", SqlDbType.VarChar, 50), new SqlParameter("@bankCity", SqlDbType.VarChar, 50), new SqlParameter("@bankAddress", SqlDbType.VarChar, 100), new SqlParameter("@status", SqlDbType.TinyInt, 1), new SqlParameter("@AddTime", SqlDbType.DateTime), new SqlParameter("@SureTime", SqlDbType.DateTime), new SqlParameter("@SureUser", SqlDbType.Int, 4), new SqlParameter("@BankCode", SqlDbType.VarChar, 50), new SqlParameter("@provinceCode", SqlDbType.VarChar, 50), new SqlParameter("@cityCode", SqlDbType.VarChar, 50), new SqlParameter("@Reason", SqlDbType.NVarChar, 500), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.userid; parameters[1].Value = model.accoutType; parameters[2].Value = model.pmode; parameters[3].Value = model.account; parameters[4].Value = model.payeeName; parameters[5].Value = model.payeeBank; parameters[6].Value = model.bankProvince; parameters[7].Value = model.bankCity; parameters[8].Value = model.bankAddress; parameters[9].Value = (int)model.status; parameters[10].Value = model.AddTime; parameters[11].Value = model.SureTime; parameters[12].Value = model.SureUser; parameters[13].Value = model.BankCode; parameters[14].Value = model.provinceCode; parameters[15].Value = model.cityCode; parameters[16].Value = model.Reason; parameters[17].Value = model.id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } return(false); }