public List<BussinessRoleOR> selectAllRole()
{
string sql = "select * from t_BussinessRole";
DataTable dt = null;
try
{
dt = dbMySql.ExecuteQuery(sql);
}
catch (Exception ex)
{
throw ex;
}
if (dt == null)
{
return null;
}
List<BussinessRoleOR> listBuss = new List<BussinessRoleOR>();
foreach (DataRow dr in dt.Rows)
{
BussinessRoleOR obj = new BussinessRoleOR(dr);
listBuss.Add(obj);
}
return listBuss;
}
public List<BussinessRoleOR> selectBussinessRoleData(string orgbhWhere)
{
if (string.IsNullOrEmpty(orgbhWhere))
return null;
string sql = @"select bu.* from t_BussinessRole bu
inner join t_Bank b on b.orgbh= bu.orgbh where " + orgbhWhere;
DataTable dt = null;
try
{
dt = dbMsSql.ExecuteQuery(sql);
}
catch (Exception ex)
{
throw ex;
}
if (dt == null)
return null;
List<BussinessRoleOR> listBuss = new List<BussinessRoleOR>();
foreach (DataRow dr in dt.Rows)
{
BussinessRoleOR obj = new BussinessRoleOR(dr);
listBuss.Add(obj);
}
return listBuss;
}
/// <summary>
/// 获取插入数据
/// </summary>
public string GetInsertSql(BussinessRoleOR bussinessRole)
{
string sql = @"insert into t_BussinessRole (Id,Name,Description,OrgBH)
values ('@Id','@Name','@Description','@OrgBH')";
sql = sql.Replace("@Id", bussinessRole.Id); //
sql = sql.Replace("@Name", bussinessRole.Name); //业务角色名称
sql = sql.Replace("@Description", bussinessRole.Description); //描述
sql = sql.Replace("@OrgBH", bussinessRole.Orgbh); //
return sql;
}