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