private void SetAuth(string rid) { string connStr = ConfigurationManager.AppSettings["ConStr"].ToString(); SqlConnection sqlConn = new SqlConnection(connStr); sqlConn.Open(); IList <string> entStrList_Dept = RequestData.GetList <string>("DeptData"); if (entStrList_Dept.Count > 0) { DataTable deptDt = GetTableSchema("dept"); IList <Rule_Regulation_BrowseDept> ents_Dept = entStrList_Dept.Select(tent => Aim.JsonHelper.GetObject <Rule_Regulation_BrowseDept>(tent) as Rule_Regulation_BrowseDept).ToList(); foreach (Rule_Regulation_BrowseDept item in ents_Dept) { DataRow dr = deptDt.NewRow(); dr[0] = Guid.NewGuid(); dr[1] = rid; dr[2] = item.DeptId; dr[3] = item.DeptName; deptDt.Rows.Add(dr); } Rule_Regulation_BrowseDept.DeleteAll("Rule_Regulation='" + rid + "'"); DataHelper.CopyDataToDatabase(deptDt, sqlConn, "BJKY_IntegratedManage..Rule_Regulation_BrowseDept"); } IList <string> entStrList_User = RequestData.GetList <string>("UserData"); if (entStrList_User.Count > 0) { DataTable deptDt = GetTableSchema("user"); IList <Rule_Regulation_BrowseAuth> ents_Dept = entStrList_User.Select(tent => Aim.JsonHelper.GetObject <Rule_Regulation_BrowseAuth>(tent) as Rule_Regulation_BrowseAuth).ToList(); foreach (Rule_Regulation_BrowseAuth item in ents_Dept) { DataRow dr = deptDt.NewRow(); dr[0] = Guid.NewGuid(); dr[1] = rid; dr[2] = item.UserId; dr[3] = item.UserName; deptDt.Rows.Add(dr); } Rule_Regulation_BrowseAuth.DeleteAll("Rule_Regulation='" + rid + "'"); DataHelper.CopyDataToDatabase(deptDt, sqlConn, "BJKY_IntegratedManage..Rule_Regulation_BrowseAuth"); } }
string type = String.Empty; // 对象类型 #endregion #region ASP.NET 事件 protected void Page_Load(object sender, EventArgs e) { op = RequestData.Get <string>("op"); id = RequestData.Get <string>("id"); type = RequestData.Get <string>("type"); Rule_Regulation ent = null; switch (this.RequestAction) { case RequestActionEnum.Update: ent = Rule_Regulation.Find(id); ent.AuthType = RequestData.Get <string>("AuthType"); if (ent.AuthType == "specify") { SetAuth(); } ent.LastModifyId = UserInfo.UserID; ent.LastModifyName = UserInfo.Name; ent.LastModifyTime = System.DateTime.Now; ent.DoUpdate(); this.SetMessage("修改成功!"); break; return; } if (op != "c" && op != "cs") { if (!String.IsNullOrEmpty(id)) { ent = Rule_Regulation.Find(id); } this.SetFormData(ent); if (!string.IsNullOrEmpty(id)) { this.PageState.Add("DeptList", Rule_Regulation_BrowseDept.FindAllByProperties("Rule_Regulation", id)); this.PageState.Add("UserList", Rule_Regulation_BrowseAuth.FindAllByProperties("Rule_Regulation", id)); } } }
string type = String.Empty; // 对象类型 #endregion #region ASP.NET 事件 protected void Page_Load(object sender, EventArgs e) { op = RequestData.Get <string>("op"); id = RequestData.Get <string>("id"); type = RequestData.Get <string>("type"); Rule_Regulation ent = null; switch (this.RequestAction) { case RequestActionEnum.Update: ent = this.GetMergedData <Rule_Regulation>(); ent.AuthType = RequestData.Get <string>("AuthType"); ent.ReleaseState = RequestData.Get <string>("IsRelease"); if (ent.ReleaseState == "已发布") { ent.ReleaseId = UserInfo.UserID; ent.ReleaseName = UserInfo.Name; ent.ReleaseTime = System.DateTime.Now; } ent.LastModifyId = UserInfo.UserID; ent.LastModifyName = UserInfo.Name; ent.LastModifyTime = System.DateTime.Now; ent.DoUpdate(); if (ent.AuthType == "specify") { SetAuth(ent.Id); } this.SetMessage("修改成功!"); break; case RequestActionEnum.Insert: case RequestActionEnum.Create: ent = this.GetPostedData <Rule_Regulation>(); ent.AuthType = RequestData.Get <string>("AuthType"); ent.ReleaseState = RequestData.Get <string>("IsRelease"); if (ent.ReleaseState == "已发布") { ent.ReleaseId = UserInfo.UserID; ent.ReleaseName = UserInfo.Name; ent.ReleaseTime = System.DateTime.Now; } ent.LastModifyId = UserInfo.UserID; ent.LastModifyName = UserInfo.Name; ent.LastModifyTime = System.DateTime.Now; ent.DoCreate(); if (ent.AuthType == "specify") { SetAuth(ent.Id); } this.SetMessage("新建成功!"); break; case RequestActionEnum.Delete: ent = this.GetTargetData <Rule_Regulation>(); ent.DoDelete(); this.SetMessage("删除成功!"); return; } if (op != "c" && op != "cs") { if (!String.IsNullOrEmpty(id)) { ent = Rule_Regulation.Find(id); } this.SetFormData(ent); if (!string.IsNullOrEmpty(id)) { this.PageState.Add("DeptList", Rule_Regulation_BrowseDept.FindAllByProperties("Rule_Regulation", id)); this.PageState.Add("UserList", Rule_Regulation_BrowseAuth.FindAllByProperties("Rule_Regulation", id)); } } else { string sql = ""; // sql = @"select top 1 case [Type] when 3 then ParentDeptName when 2 then ChildDeptName end as DeptName, // case [Type] when 3 then ParentId when 2 then DeptId end as DeptId // from View_SysUserGroup where UserId='{0}'"; sql = @"select DeptId,ChildDeptName as DeptName from View_SysUserGroup where UserId='{0}' and Type<>'3'"; sql = string.Format(sql, UserInfo.UserID); IList <EasyDictionary> deptDics = DataHelper.QueryDictList(sql); if (deptDics.Count > 0) { var obj = new { DeptId = string.Join(",", deptDics.Select(s => s.Get <string>("DeptId")).ToArray()), DeptName = string.Join(",", deptDics.Select(s => s.Get <string>("DeptName")).ToArray()), CreateId = UserInfo.UserID, CreateName = UserInfo.Name }; SetFormData(obj); } } }