/// <summary> /// 添加账户——ds2012——tianfeng /// </summary> /// <returns></returns> public static int AddCompanyBank(CompanyBankModel companyBank) { SqlParameter [] parameter = new SqlParameter[] { new SqlParameter("@Bank", companyBank.Bank), new SqlParameter("@BankBook", companyBank.BankBook), new SqlParameter("@CountryID", companyBank.CountryID), new SqlParameter("@Bankname", companyBank.Bankname) }; return(DBHelper.ExecuteNonQuery("AddcompanyBank", parameter, CommandType.StoredProcedure)); }
/// <summary> /// 验证账户是否已存在——ds2012——tianfeng /// </summary> /// <param name="company"></param> /// <returns></returns> public static int ValidateCompanyBank(CompanyBankModel company) { SqlParameter[] parameter = new SqlParameter[] { new SqlParameter("@Bank", SqlDbType.VarChar, 50), new SqlParameter("@BankBook", SqlDbType.VarChar, 50), new SqlParameter("@CountryID", SqlDbType.VarChar, 50), new SqlParameter("@count", SqlDbType.Int) }; parameter[0].Value = company.Bank; parameter[1].Value = company.BankBook; parameter[2].Value = company.CountryID; parameter[3].Direction = ParameterDirection.Output; DBHelper.ExecuteNonQuery("validateCompanyBank", parameter, CommandType.StoredProcedure); return(int.Parse(parameter[3].Value.ToString())); }
/// <summary> /// 修改账户 ——ds2012——tianfeng /// </summary> /// <param name="bank"></param> /// <returns></returns> public static int UpdCompanyBank(CompanyBankModel bank) { SqlParameter[] parameter = new SqlParameter[] { new SqlParameter("@id", SqlDbType.Int), new SqlParameter("@Bank", SqlDbType.VarChar, 50), new SqlParameter("@BankBook", SqlDbType.VarChar, 50), new SqlParameter("@CountryID", SqlDbType.Int), new SqlParameter("@Bankname", SqlDbType.VarChar, 50) }; parameter[0].Value = bank.ID; parameter[1].Value = bank.Bank; parameter[2].Value = bank.BankBook; parameter[3].Value = bank.CountryID; parameter[4].Value = bank.Bankname; return(DBHelper.ExecuteNonQuery("update CompanyBank set bank=@bank,bankbook=@bankbook,countryid=@countryid,bankname=@Bankname where id=@id", parameter, CommandType.Text)); }
/// <summary> /// 查询账户——ds2012——tianfeng /// </summary> /// <param name="countryID">国家ID</param> /// <returns></returns> public List <CompanyBankModel> GetCompanyBank(int countryID) { List <CompanyBankModel> list = new List <CompanyBankModel>(); //按国家查询公司账户信息 string sql = "select id,Bank,countryID,BankBook from companybank where countryID=" + countryID; SqlDataReader read = DBHelper.ExecuteReader(sql, CommandType.Text); while (read.Read()) { CompanyBankModel company = new CompanyBankModel(); company.ID = int.Parse(read["ID"].ToString()); company.Bank = read["Bank"].ToString(); company.CountryID = int.Parse(read["countryID"].ToString()); company.BankBook = read["BankBook"].ToString(); list.Add(company); } read.Close(); return(list); }
public static List <CompanyBankModel> GetCompanyBanks() { List <CompanyBankModel> list = new List <CompanyBankModel>(); //按国家查询公司账户信息 string sql = "select * from companybank order by id "; DataTable dt = DBHelper.ExecuteDataTable(sql, CommandType.Text); CompanyBankModel company = null; foreach (DataRow dr in dt.Rows) { company = new CompanyBankModel(); company.ID = int.Parse(dr["ID"].ToString()); company.Bank = dr["Bank"].ToString(); company.CountryID = int.Parse(dr["countryID"].ToString()); company.BankBook = dr["BankBook"].ToString(); company.Bankname = dr["bankname"].ToString(); list.Add(company); } return(list); }
/// <summary> /// 验证账户是否已存在了——ds2012——tianfeng /// </summary> /// <param name="ID"></param> /// <returns></returns> public static Boolean ValidateCompanyBank(CompanyBankModel company) { return(CompanyBankDAL.ValidateCompanyBank(company) == 0 ? false : true); }
/// <summary> /// 修改账户——ds2012——tianfeng /// </summary> /// <param name="bank"></param> /// <returns></returns> public static int UpdCompanyBank(CompanyBankModel model) { return(CompanyBankDAL.UpdCompanyBank(model)); }
/// <summary> /// 添加账户——ds2012——tianfeng /// </summary> /// <returns></returns> public static Boolean AddCompanyBank(CompanyBankModel companyBank) { return(CompanyBankDAL.AddCompanyBank(companyBank) == 0 ? false : true); }
/// <summary> /// 添加和修改功能 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void but1_Click(object sender, EventArgs e) { DropDownList ddlCountry = (DropDownList)CountryUC.FindControl("ddlCountry"); if (this.txtbank.Text.Trim().Length <= 0) { ClientScript.RegisterStartupScript(this.GetType(), "", "<script language='javascript'>alert('" + GetTran("004092", "银行不能为空!") + "')</script>"); return; } if (this.txtname.Text.Trim().Length <= 0) { ClientScript.RegisterStartupScript(this.GetType(), "", "<script language='javascript'>alert('" + GetTran("004090", "开户名不能为空!") + "')</script>"); return; } if (this.txtcard.Text.Trim().Length <= 0) { ClientScript.RegisterStartupScript(this.GetType(), "", "<script language='javascript'>alert('" + GetTran("004089", "账号不能为空!") + "')</script>"); return; } CompanyBankModel mode = new CompanyBankModel(); mode.Bank = this.txtbank.Text.Trim(); mode.Bankname = this.txtname.Text.Trim(); mode.BankBook = this.txtcard.Text.Trim(); mode.CountryID = int.Parse(ddlCountry.SelectedItem.Value); //当为空时,此操作为添加;否则,修改操作 if (ViewState["ID"] != null) { mode.ID = int.Parse(ViewState["ID"].ToString()); string card = ViewState["bnakbook"].ToString(); //修改账号 ChangeLogs cl = new ChangeLogs("companybank", "ltrim(rtrim(str(id)))"); cl.AddRecord(mode.ID); if (CompanyBankBLL.UpdCompanyBank(mode) == 1) { cl.AddRecord(mode.ID); cl.ModifiedIntoLogs(ChangeCategory.company13, Session["Company"].ToString(), ENUM_USERTYPE.objecttype3); ClientScript.RegisterStartupScript(this.GetType(), "", "<script language='javascript'>alert('" + GetTran("004086", "修改账户成功!") + "')</script>"); } else { ClientScript.RegisterStartupScript(this.GetType(), "", "<script language='javascript'>alert('" + GetTran("004084", "修改账户失败!") + "')</script>"); } } else //添加 { //验证账号 if (CompanyBankBLL.ValidateCompanyBank(mode)) { ClientScript.RegisterStartupScript(this.GetType(), "", "<script language='javascript'>alert('" + GetTran("004083", "此账号已存在!!!") + "')</script>"); return; } else { //添加账户 if (CompanyBankBLL.AddCompanyBank(mode)) { ViewState["ID"] = null; ClientScript.RegisterStartupScript(this.GetType(), "", "<script language='javascript'>alert('" + GetTran("004081", "帐户添加成功!") + "')</script>"); } } } this.TranControls(this.but1, new string[][] { new string[] { "002047", "添 加" } }); this.txtcard.Text = string.Empty; ViewState["ID"] = null; bindcontrol(null, null); }