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