private void InputDatas(DataTable dt) { foreach (DataRow row in dt.Rows) { if (row[2] != null && row[2].ToString().Trim() != "") { string workNo = ""; try { 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 { 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); } } } } } catch (Exception e) { continue; } } } }