/// <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);
}
