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