public void UpdateSQL(ClsU8.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++) { ClsU8.Model.ClsUserRoleMod clsMod = new ClsU8.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 UpdateUser(ClsU8.Model.ClsUserInfoMod model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update _UserInfo set "); strSql.Append("vchrPwd='" + clsDES.Encrypt(model.vchrPwd) + "',"); strSql.Append("vchrName='" + model.vchrName + "',"); strSql.Append("vchrRemark='" + model.vchrRemark + "',"); strSql.Append("dtmCreate='" + model.dtmCreate + "',"); strSql.Append("dtmClose='" + model.dtmClose + "'"); strSql.Append(" where vchrUid='" + model.vchrUid + "'"); strSql.Append("declare @num as int select @num =MAX(iID)+1 from Person "); strSql.Append("IF EXISTS(select PersonCode From Person with (XLOCK) Where PersonCode='" + model.vchrUid + "') "); strSql.Append("update Person set PersonName='" + model.vchrName + "',isUserInfo=1 where PersonName='" + model.vchrUid + "'"); strSql.Append(" else insert into Person(iID,PersonCode,PersonName,isUserInfo) values(@num,'" + model.vchrUid + "','" + model.vchrName + "',1)"); return(strSql.ToString()); }