public void UpdateSQL(ClsU8.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++) { ClsU8.Model.ClsUserRoleMod clsMod = new ClsU8.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 AddRole(ClsU8.Model.ClsRoleInfoMod model) { int iClose = 0; StringBuilder strSql = new StringBuilder(); strSql.Append("insert into _RoleInfo("); strSql.Append("vchrRoleID,vchrRoleText,vchrRemark,bClosed,dtmCreate"); strSql.Append(")"); strSql.Append(" values ("); strSql.Append("'" + model.vchrRoleID + "',"); strSql.Append("'" + model.vchrRoleText + "',"); strSql.Append("'" + model.vchrRemark + "',"); if (model.bClosed) { iClose = 1; } else { iClose = 0; } strSql.Append("" + iClose + ","); strSql.Append("'" + model.dtmCreate + "'"); strSql.Append(")"); return(strSql.ToString()); }
/// <summary> /// 更新一条数据 /// </summary> private string UpdateRole(ClsU8.Model.ClsRoleInfoMod model) { int iClose; StringBuilder strSql = new StringBuilder(); strSql.Append("update _RoleInfo set "); strSql.Append("vchrRoleText='" + model.vchrRoleText + "',"); strSql.Append("vchrRemark='" + model.vchrRemark + "',"); if (model.bClosed) { iClose = 1; } else { iClose = 0; } strSql.Append("bClosed=" + iClose + ","); strSql.Append("dtmCreate='" + model.dtmCreate + "'"); strSql.Append(" where vchrRoleID='" + model.vchrRoleID + "'"); return(strSql.ToString()); }