/// <summary>
/// 向会员使用银行表中插入相关记录
/// </summary>
/// <param name="memberBank">会员使用银行模型</param>
/// <returns>返回向会员使用银行表中插入相关记录所影响的行数</returns>
public static int AddMemberBank(MemberBankModel memberBank)
{
int zc = 0;
string zcode = "";
string sql1 = "select countrycode from country where id=@num";
SqlParameter spa = new SqlParameter("@num", SqlDbType.Int);
spa.Value = memberBank.CountryCode;
string bcode = DBHelper.ExecuteScalar(sql1, spa, CommandType.Text).ToString();
zcode = bcode + "0001";
string sql2 = "select count(0) from memberbank where substring(bankcode,1,2)=@num";
SqlParameter spa2 = new SqlParameter("@num", SqlDbType.NVarChar, 10);
spa2.Value = bcode;
if (Convert.ToInt32(DBHelper.ExecuteScalar(sql2, spa2, CommandType.Text)) > 0)
{
string sql3 = "select top 1 bankcode from memberbank where substring(bankcode,1,2)=@num order by bankcode desc";
SqlParameter spa3 = new SqlParameter("@num", SqlDbType.NVarChar, 10);
spa3.Value = bcode;
bcode = DBHelper.ExecuteScalar(sql3, spa3, CommandType.Text).ToString();
zc = Convert.ToInt32(bcode) + 1;
if (zc.ToString().Length == 5)
{
zcode = "0" + zc.ToString();
}
else if (zc.ToString().Length == 4)
{
zcode = "00" + zc.ToString();
}
else if (zc.ToString().Length == 3)
{
zcode = "000" + zc.ToString();
}
else if (zc.ToString().Length == 2)
{
zcode = "0000" + zc.ToString();
}
else if (zc.ToString().Length == 1)
{
zcode = "00000" + zc.ToString();
}
else
{
zcode = zc.ToString();
}
}
SqlParameter[] sparams = new SqlParameter[]
{
new SqlParameter("@bankName", SqlDbType.VarChar, 30),
new SqlParameter("@countryCode", SqlDbType.Int),
new SqlParameter("@bankcode", SqlDbType.VarChar, 20)
};
sparams[0].Value = memberBank.BankName;
sparams[1].Value = memberBank.CountryCode;
sparams[2].Value = zcode;
return(DBHelper.ExecuteNonQuery("AddMemberBank", sparams, CommandType.StoredProcedure));
}
/// <summary>
/// 获取指定的会员使用银行行数
/// </summary>
/// <param name="memberBank">会员使用银行模型</param>
/// <returns>返回获取指定的会员使用银行行数</returns>
public static int GetMemberBankCountByNameCountryCode(MemberBankModel memberBank)
{
SqlParameter[] sparams = new SqlParameter[]
{
new SqlParameter("@bankName", SqlDbType.VarChar, 30),
new SqlParameter("@countryCode", SqlDbType.Int)
};
sparams[0].Value = memberBank.BankName;
sparams[1].Value = memberBank.CountryCode;
return(Convert.ToInt32(DBHelper.ExecuteScalar("GetMemberBankCountByNameCountryCode", sparams, CommandType.StoredProcedure)));
}
/// <summary>
/// 更新指定的银行信息
/// </summary>
/// <param name="memberBank">会员使用银行模型</param>
/// <returns>返回更新指定的银行信息所影响的行数</returns>
public static int UpdMemberBankByID(MemberBankModel memberBank)
{
SqlParameter[] sparams = new SqlParameter[]
{
new SqlParameter("@bankID", SqlDbType.Int),
new SqlParameter("@bankName", SqlDbType.VarChar, 30),
new SqlParameter("@countryCode", SqlDbType.Int)
};
sparams[0].Value = memberBank.BankID;
sparams[1].Value = memberBank.BankName;
sparams[2].Value = memberBank.CountryCode;
return(DBHelper.ExecuteNonQuery("UpdMemberBankByID", sparams, CommandType.StoredProcedure));
}
//绑定银行
public IList <MemberBankModel> BindBank_List()
{
IList <MemberBankModel> list = new List <MemberBankModel>();
string sql = "SELECT BankID,BankName FROM MemberBank ";
SqlDataReader reader = DBHelper.ExecuteReader(sql);
while (reader.Read())
{
MemberBankModel info = new MemberBankModel(int.Parse(reader["BankID"].ToString()));
info.BankName = reader["BankName"].ToString();
list.Add(info);
}
reader.Close();
return(list);
}
/// <summary>
/// 通过城市ID绑定银行
/// </summary>
/// <param name="countryId"></param>
/// <returns></returns>
public List <MemberBankModel> GetBank(int countryCode, string language)
{
List <MemberBankModel> model = new List <MemberBankModel>();
MemberBankModel bankModel = null;
string SQL = null;
if (language.ToLower() == "chinese" || language.ToLower() == "中文")
{
SQL = "select BankID, BankName,BankCode, CountryCode from MemberBank where CountryCode=@countryCode";
}
else
{
int languageID = LanguageDAL.GetLanguageIDByName(language);
SQL = @"select BankID,
(
select LanguageName
from LanguageTrans
where LanguageTrans.OldID=MemberBank.BankID
and LanguageTrans.ColumnsName='BankName'
and LanguageID=" + languageID + ")as BankName,CountryCode,BankCode from MemberBank";
}
SqlParameter[] para =
{
new SqlParameter("@countryCode", SqlDbType.Int)
};
para[0].Value = countryCode;
SqlDataReader reader = DBHelper.ExecuteReader(SQL, para, CommandType.Text);
while (reader.Read())
{
bankModel = new MemberBankModel();
bankModel.BankID = Convert.ToInt32(reader["BankID"]);
bankModel.BankName = reader["BankName"].ToString();
bankModel.CountryCode = Convert.ToInt32(reader["CountryCode"]);
bankModel.BankCode = reader["BankCode"].ToString();
model.Add(bankModel);
}
reader.Close();
return(model);
}
/// <summary>
/// 获取指定的会员使用银行行数
/// </summary>
/// <param name="memberBank">会员使用银行模型</param>
/// <returns>返回获取指定的会员使用银行行数</returns>
public static int GetMemberBankCountByNameCountryCode(MemberBankModel memberBank)
{
return(MemberBankDAL.GetMemberBankCountByNameCountryCode(memberBank));
}
/// <summary>
/// 更新指定的银行信息
/// </summary>
/// <param name="memberBank">会员使用银行模型</param>
/// <returns>返回更新指定的银行信息所影响的行数</returns>
public static int UpdMemberBankByID(MemberBankModel memberBank)
{
return(MemberBankDAL.UpdMemberBankByID(memberBank));
}
/// <summary>
/// 向会员使用银行表中插入相关记录
/// </summary>
/// <param name="memberBank">会员使用银行模型</param>
/// <returns>返回向会员使用银行表中插入相关记录所影响的行数</returns>
public static int AddMemberBank(MemberBankModel memberBank)
{
return(MemberBankDAL.AddMemberBank(memberBank));
}
/// <summary>
/// 获取指定的会员使用银行行数
/// </summary>
/// <param name="memberBank">会员使用银行模型</param>
/// <returns>返回获取指定的会员使用银行行数</returns>
public static int GetMemberBankCountByAll(MemberBankModel memberBank)
{
return(MemberBankDAL.GetMemberBankCountByAll(memberBank));
}
