private void DoCreateSubByRole() { IList <string> idList = RequestData.GetList <string>("IdList"); SysGroup tent = SysGroup.Find(id); if (idList != null && idList.Count > 0) { SysRole[] duties = SysRole.FindAllByPrimaryKeys(idList.ToArray()); foreach (SysRole tduty in duties) { if (!SysGroup.Exists("Name=? and Type=21 and ParentID = ?", tduty.Name, tent.ID)) { SysGroup tgrp = new SysGroup() { Name = tduty.Name, Code = tduty.Code, Type = 3, //角色 Status = 1, SortIndex = 9999, CreateDate = DateTime.Now }; tgrp.CreateAsChild(tent); } } } }
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"); SysGroup ent = null; switch (this.RequestAction) { case RequestActionEnum.Update: ent = this.GetMergedData <SysGroup>(); ent.DoUpdate(); this.SetMessage("修改成功!"); break; case RequestActionEnum.Insert: case RequestActionEnum.Create: ent = this.GetPostedData <SysGroup>(); //ent.CreaterID = UserInfo.UserID; //ent.CreaterName = UserInfo.Name; if (ent.SortIndex == null) { ent.SortIndex = 9999; } ent.CreateDate = DateTime.Now; if (String.IsNullOrEmpty(id)) { ent.CreateAsRoot(); } else { ent.CreateAsSibling(SysGroup.Find(id)); } this.SetMessage("新建成功!"); break; default: if (RequestActionString == "createsub") { ent = this.GetPostedData <SysGroup>(); //ent.CreaterID = UserInfo.UserID; //ent.CreaterName = UserInfo.Name; ent.LastModifiedDate = DateTime.Now; if (!SysGroup.Exists("Name=? and code=? and Type=2 and ParentID = ?", ent.Name, ent.Code, id)) { ent.CreateAsChild(SysGroup.Find(id)); } this.SetMessage("新建成功!"); } break; } if (op != "c" && op != "cs") { if (!String.IsNullOrEmpty(id)) { ent = SysGroup.Find(id); } this.SetFormData(ent); } else { PageState.Add("CreaterName", UserInfo.Name); PageState.Add("CreatedDate", DateTime.Now); } }
private void InputDatasV2(DataTable dt) { //DataHelper.ExecSql("delete from SysUser where LoginName<>'admin'"); foreach (DataRow row in dt.Rows) { if (row[2] != null && row[2].ToString().Trim() != "") { string workNo = row[1].ToString().Trim();; try { if (!SysGroup.Exists(Expression.Eq(SysGroup.Prop_Name, row[4].ToString()))) { continue; } using (new SessionScope()) { if (row[4].ToString().Trim() == "昆山飞力仓储服务有限公司") { string dept = row[4].ToString(); } SysGroup group = SysGroup.FindAllByProperties("Name", row[4].ToString())[0]; SysGroup Fact = null; if (row[6].ToString().Trim() != "") { if (group.ChildGroups.Count(tt => tt.Name == row[6].ToString()) == 0) { SysGroup group1 = new SysGroup(); group1.Name = row[6].ToString(); group1.Code = row[7].ToString(); group1.SortIndex = int.Parse(row[7].ToString()); group1.Type = 2; group1.Status = 1; group1.CreateAsChild(group); Fact = group1; if (row[6].ToString().Trim() != row[8].ToString().Trim()) { SysGroup group2 = new SysGroup(); group2.Name = row[8].ToString(); group2.Code = row[9].ToString(); group2.SortIndex = int.Parse(row[9].ToString()); group2.Type = 2; group2.Status = 1; group2.Save(); group2.CreateAsChild(group1); Fact = group2; } } else { Fact = group.ChildGroups.FirstOrDefault(ent => ent.Name == row[6].ToString()); if (row[6].ToString().Trim() != row[8].ToString().Trim()) { if (Fact.ChildGroups.Count(tt => tt.Name == row[8].ToString()) == 0) { SysGroup group2 = new SysGroup(); group2.Name = row[8].ToString(); group2.Code = row[9].ToString(); group2.SortIndex = int.Parse(row[9].ToString()); group2.Type = 2; group2.Status = 1; group2.Save(); group2.CreateAsChild(Fact); Fact = group2; } else { Fact = Fact.ChildGroups.FirstOrDefault(ent => ent.Name == row[8].ToString()); } } } } else { Fact = group; } SysUser sysUser = new SysUser(); sysUser.WorkNo = row[1].ToString().Trim(); sysUser.Name = row[2].ToString().Trim(); if (row[3].ToString().Trim() == "") { sysUser.LoginName = GetPingyin(row[2].ToString().Trim()); } else { sysUser.LoginName = row[3].ToString(); } sysUser.Status = 1; sysUser.CreateDate = DateTime.Now; sysUser.Save(); IList <string> userIDs = new List <string>(); userIDs.Add(sysUser.UserID); Fact.AddUsers(userIDs); } } catch (Exception) { workNumbers += workNo + ";"; continue; //throw e; } /*if (SysUser.FindAllByProperties("WorkNo", row[1].ToString().Trim()).Length == 0) * { * SysUser sysUser = new SysUser(); * sysUser.WorkNo = row[1].ToString().Trim(); * sysUser.Name = row[2].ToString().Trim(); * if (row[3].ToString().Trim() == "") * { * sysUser.LoginName = GetPingyin(row[2].ToString().Trim()); * } * else * { * sysUser.LoginName = row[3].ToString(); * } * sysUser.Email = row[5].ToString(); * sysUser.Remark = row[6].ToString(); * sysUser.Status = 1; * sysUser.CreateDate = DateTime.Now; * sysUser.Save(); * if (SysGroup.FindAllByProperties("Name", row[4].ToString().Trim()).Length > 0) * { * using (new SessionScope()) * { * SysGroup grp = SysGroup.FindAllByProperties("Name", row[4].ToString().Trim())[0]; * * IList<string> userIDs = new List<string>(); * userIDs.Add(sysUser.UserID); * grp.AddUsers(userIDs); * } * } * else * { * * } * } * else * { * if (SysGroup.FindAllByProperties("Name", row[4].ToString().Trim()).Length > 0) * { * SysUser sysUser = SysUser.FindAllByProperties("WorkNo", row[1].ToString().Trim())[0]; * using (new SessionScope()) * { * if (sysUser.RetrieveAllGroup().Where(en => en.Type == 2 && en.Name != row[4].ToString()).Count() == 0) * { * if (sysUser.RetrieveAllGroup().Where(en => en.Type == 2).Count() > 0) * { * foreach (SysGroup gp in sysUser.RetrieveAllGroup().Where(en => en.Type == 2)) * gp.User.Remove(sysUser); * } * SysGroup grp = SysGroup.FindAllByProperties("Name", row[4].ToString().Trim())[0]; * IList<string> userIDs = new List<string>(); * userIDs.Add(sysUser.UserID); * grp.AddUsers(userIDs); * } * } * } * }*/ } } }