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