public bool AddCooperativeBank(CooperativeBank bank) { bool IsDesplay = false; if (bank.IsDesplay == 0) { IsDesplay = false; } else { IsDesplay = true; } string sql = @"insert into CooperativeBank(BankName,logo1,logo2,BankDesc,Sort,Leader,Phone,IsDesplay)values(@BankName,@logo1,@logo2,@BankDesc,@sort,@Leader,@Phone,@IsDesplay)"; int? id = DBHelper.Execute(sql, new SqlParameter("@BankName", bank.BankName.Trim()), new SqlParameter("@logo1", bank.logo1), new SqlParameter("@logo2", bank.logo2), new SqlParameter("@BankDesc", bank.BankDesc), new SqlParameter("@sort", bank.sort), new SqlParameter("@Leader", bank.Leader), new SqlParameter("@Phone", bank.Phone), new SqlParameter("@IsDesplay", IsDesplay)) as int?; if (id > 0) { return(true); } else { return(false); } }
static public void SetBank(ListOfBank bankBrand, IBank bank) { switch (bankBrand) { case ListOfBank.TaiwanBank: bank = new TaiwanBank(); break; case ListOfBank.FirstBank: bank = new FirstBank(); break; case ListOfBank.CooperativeBank: bank = new CooperativeBank(); break; } }
public bool EditCooperativeBank(CooperativeBank bank) { int? id = 0; bool IsDesplay = false; if (bank.IsDesplay == 0) { IsDesplay = false; } else { IsDesplay = true; } if (bank.logo1.Length == 0 && bank.logo2.Length == 0) { string sql = @"update CooperativeBank set BankName=@BankName,BankDesc=@BankDesc,Sort=@sort,Leader=@Leader,Phone=@Phone,IsDesplay =@IsDesplay where Id = @Id"; id = DBHelper.Execute(sql, new SqlParameter("@Id", bank.Id), new SqlParameter("@BankName", bank.BankName.Trim()), new SqlParameter("@BankDesc", bank.BankDesc), new SqlParameter("@sort", bank.sort), new SqlParameter("@Leader", bank.Leader), new SqlParameter("@Phone", bank.Phone), new SqlParameter("@IsDesplay", IsDesplay)) as int?; } else if (bank.logo1.Length > 0 && bank.logo2.Length == 0) { string sql = @"update CooperativeBank set BankName=@BankName,logo1=@logo1,BankDesc=@BankDesc,Sort=@sort,Leader=@Leader,Phone=@Phone,IsDesplay =@IsDesplay where Id = @Id"; id = DBHelper.Execute(sql, new SqlParameter("@Id", bank.Id), new SqlParameter("@BankName", bank.BankName.Trim()), new SqlParameter("@logo1", bank.logo1), new SqlParameter("@BankDesc", bank.BankDesc), new SqlParameter("@sort", bank.sort), new SqlParameter("@Leader", bank.Leader), new SqlParameter("@Phone", bank.Phone), new SqlParameter("@IsDesplay", IsDesplay)) as int?; } else if (bank.logo2.Length > 0 && bank.logo1.Length == 0) { string sql = @"update CooperativeBank set BankName=@BankName,logo2=@logo2,BankDesc=@BankDesc,Sort=@sort,Leader=@Leader,Phone=@Phone,IsDesplay =@IsDesplay where Id = @Id"; id = DBHelper.Execute(sql, new SqlParameter("@Id", bank.Id), new SqlParameter("@BankName", bank.BankName.Trim()), new SqlParameter("@logo2", bank.logo2), new SqlParameter("@BankDesc", bank.BankDesc), new SqlParameter("@sort", bank.sort), new SqlParameter("@Leader", bank.Leader), new SqlParameter("@Phone", bank.Phone), new SqlParameter("@IsDesplay", IsDesplay)) as int?; } else if (bank.logo2.Length > 0 && bank.logo1.Length > 0) { string sql = @"update CooperativeBank set BankName=@BankName,logo1=@logo1,logo2=@logo2,BankDesc=@BankDesc,Sort=@sort,Leader=@Leader,Phone=@Phone,IsDesplay =@IsDesplay where Id = @Id"; id = DBHelper.Execute(sql, new SqlParameter("@Id", bank.Id), new SqlParameter("@BankName", bank.BankName.Trim()), new SqlParameter("@logo1", bank.logo1), new SqlParameter("@logo2", bank.logo2), new SqlParameter("@BankDesc", bank.BankDesc), new SqlParameter("@sort", bank.sort), new SqlParameter("@Leader", bank.Leader), new SqlParameter("@Phone", bank.Phone), new SqlParameter("@IsDesplay", IsDesplay)) as int?; } if (id > 0) { return(true); } else { return(false); } }