public void UpdateSQL(FrameBaseFunction.Model.ClsUserInfoMod model, DataTable dt) { ArrayList arrList = new ArrayList(); string sSQL = UpdateUser(model); arrList.Add(sSQL); sSQL = "delete dbo._UserRoleInfo " + "where vchrUserID = '" + model.vchrUid + "' "; arrList.Add(sSQL); for (int i = 0; i < dt.Rows.Count; i++) { FrameBaseFunction.Model.ClsUserRoleMod clsMod = new FrameBaseFunction.Model.ClsUserRoleMod(); if (dt.Rows[i]["bChoosed"].ToString().Trim() == "√") { clsMod.vchrUserID = model.vchrUid; clsMod.vchrRoleID = dt.Rows[i]["vchrRoleID"].ToString().Trim(); string s = AddUserRole(clsMod); arrList.Add(s); } } clsSQL.ExecSqlTran(arrList); }
/// <summary> /// 增加一条数据 /// </summary> private string AddUserRole(FrameBaseFunction.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()); }