public void UpdateSQL(系统服务.Model.ClsRoleInfoMod model, DataTable dt)
{
ArrayList arrList = new ArrayList();
string sSQL = UpdateRole(model);
arrList.Add(sSQL);
sSQL = "delete dbo._UserRoleInfo " +
"where vchrRoleID = '" + model.vchrRoleID + "' ";
arrList.Add(sSQL);
for (int i = 0; i < dt.Rows.Count; i++)
{
系统服务.Model.ClsUserRoleMod clsMod = new 系统服务.Model.ClsUserRoleMod();
if (dt.Rows[i]["bChoosed"].ToString().Trim() == "√")
{
clsMod.vchrUserID = dt.Rows[i]["vchrUID"].ToString().Trim();
clsMod.vchrRoleID = model.vchrRoleID;
string s = AddUserRole(clsMod);
arrList.Add(s);
}
}
clsSQL.ExecSqlTran(arrList);
}
/// <summary>
/// 增加一条数据
/// </summary>
private string AddUserRole(系统服务.Model.ClsUserRoleMod model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into _UserRoleInfo(");
strSql.Append("vchrUserID,vchrRoleID");
strSql.Append(")");
strSql.Append(" values (");
strSql.Append("'" + model.vchrUserID + "',");
strSql.Append("'" + model.vchrRoleID + "'");
strSql.Append(")");
return(strSql.ToString());
}
