private void DoImpUser() { string FileName = RequestData.Get("FileId") + ""; string SurveyId = RequestData.Get("SurveyId") + ""; string Sign = RequestData.Get("Sign") + ""; //区分导入对象 Surveyed Reader FileName = MapPath("../Document/") + FileName; DataTable dt = ImpUser(FileName); if (Sign.Contains("Reader")) { for (int i = 0; i < dt.Rows.Count; i++) { SurveyCanReaderUsr Usr = new SurveyCanReaderUsr(); Usr.SurveyId = SurveyId; Usr.WorkNo = dt.Rows[i]["工号"].ToString(); Usr.UserName = dt.Rows[i]["姓名"].ToString(); Usr.DeptName = GetOrgs(dt.Rows[i]["工号"].ToString()); try { var User = SysUser.FindFirstByProperties(SysUser.Prop_WorkNo, dt.Rows[i]["工号"].ToString(), SysUser.Prop_Status, 1); Usr.UserId = User.UserID; } catch { } Usr.CreateWay = "0"; //表示导入 Usr.DoCreate(); } DataHelper.ExecSql("Delete from FL_Culture..SurveyCanReaderUsr where UserId='' or WorkNo='' "); } else if (Sign.Contains("Surveyed")) { for (int i = 0; i < dt.Rows.Count; i++) { SurveyFinallyUsr Usr = new SurveyFinallyUsr(); Usr.SurveyId = SurveyId; Usr.WorkNo = dt.Rows[i]["工号"].ToString(); Usr.UserName = dt.Rows[i]["姓名"].ToString(); Usr.DeptName = GetOrgs(dt.Rows[i]["工号"].ToString()); try { //这里还需处理 工号错误 var User = SysUser.FindFirstByProperties(SysUser.Prop_WorkNo, dt.Rows[i]["工号"].ToString(), SysUser.Prop_Status, 1); Usr.UserId = User.UserID; } catch { } Usr.CreateWay = "0"; //表示导入 Usr.DoCreate(); } DataHelper.ExecSql("Delete from FL_Culture..SurveyFinallyUsr where UserId='' or WorkNo='' "); } this.PageState.Add("State", "1"); }
private void DoBatchDelete() { IList <object> idList = RequestData.GetList <object>("IdList"); if (idList != null && idList.Count > 0) { SurveyFinallyUsr.DoBatchDelete(idList.ToArray()); } }
private void DoBatchDelete() { IList <object> idList = RequestData.GetList <object>("IdList"); if (idList != null && idList.Count > 0) { // SurveyQuestion.DoBatchDelete(idList.ToArray()); for (var v = 0; v < idList.Count; v++) { // 人员 问卷 QuestionItem[] Qent = QuestionItem.FindAllByProperties(QuestionItem.Prop_SurveyId, idList[v].ToString()); QuestionAnswerItem[] Aent = QuestionAnswerItem.FindAllByProperties(QuestionAnswerItem.Prop_SurveyId, idList[v].ToString()); SurveyFinallyUsr[] FuEnt = SurveyFinallyUsr.FindAllByProperties(SurveyFinallyUsr.Prop_SurveyId, idList[v].ToString()); SurveyCanReaderUsr[] Ruent = SurveyCanReaderUsr.FindAllByProperties(SurveyCanReaderUsr.Prop_SurveyId, idList[v].ToString()); SurveyedObj[] SoEnt = SurveyedObj.FindAllByProperties(SurveyedObj.Prop_SurveyId, idList[v].ToString()); SurveyReaderObj[] RoEnt = SurveyReaderObj.FindAllByProperties(SurveyReaderObj.Prop_SurveyId, idList[v].ToString()); foreach (var ent in Qent) { ent.DoDelete(); } foreach (var ent in Aent) { ent.DoDelete(); } foreach (var ent in FuEnt) { ent.DoDelete(); } foreach (var ent in Ruent) { ent.DoDelete(); } foreach (var ent in SoEnt) { ent.DoDelete(); } foreach (var ent in RoEnt) { ent.DoDelete(); } } SurveyQuestion.DoBatchDelete(idList.ToArray()); } }
/// <summary> /// 生成被调查人员 /// </summary> /// <param name="SurveyId"></param> /// <returns></returns> public bool CreateSurveyedUser(string SurveyId) { SurveyedObj Ent = SurveyedObj.FindFirstByProperties(SurveyedObj.Prop_SurveyId, SurveyId); // 根据条件筛选的人员 string where = string.Empty; if (string.IsNullOrEmpty(Ent.OrgIds) || string.IsNullOrEmpty(Ent.OrgNames)) { where = " and 1<>1 "; //组织结构为空情况 } else { where = AnalyzeSQL(Ent); } var FilterUsrDt = FilterUser(SurveyId, where); //筛选职位 if (!string.IsNullOrEmpty(Ent.PostionNames)) { string split = string.Empty; string[] tempArr = Ent.PostionNames.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries); for (int j = 0; j < tempArr.Length; j++) { if (j > 0) { split += " or "; } split += " JobName like '%" + tempArr[j] + "%' "; } DataRow[] rows = FilterUsrDt.Select(split); //查询gw DataTable tempDt = new DataTable(); DataColumn D_UserId = new DataColumn("UserId"); tempDt.Columns.Add(D_UserId); DataColumn D_UserName = new DataColumn("UserName"); tempDt.Columns.Add(D_UserName); DataColumn D_WorkNo = new DataColumn("WorkNo"); tempDt.Columns.Add(D_WorkNo); DataColumn D_JobName = new DataColumn("JobName"); tempDt.Columns.Add(D_JobName); for (int i = 0; i < rows.Length; i++) { DataRow dr = tempDt.NewRow(); dr["UserId"] = rows[i]["UserId"]; dr["UserName"] = rows[i]["UserName"]; dr["WorkNo"] = rows[i]["WorkNo"]; dr["JobName"] = rows[i]["JobName"]; tempDt.Rows.Add(dr); } if (tempDt.Rows.Count > 0) { FilterUsrDt = tempDt; } } //Modify By WGM 8/9 string SQL = @"with SurObjUsr As ( select CA.* from FL_Culture..SurveyedObj As A cross apply( select Filed As UsrID from FL_Culture..GetTblByJson(A.AddUserNames,'Id') ) As CA where SurveyId='{0}' ), UserInfo As ( select T.UserID,T.Name,T.WorkNo from SurObjUsr As A left join FL_PortalHR..Sysuser As T on A.UsrID=T.UserID ) select distinct * from UserInfo"; SQL = SQL.Replace("FL_PortalHR", Global.AimPortalDB); SQL = string.Format(SQL, SurveyId); SQL = "select '' where 1<>1 "; //Change BY WGM 9-30 DataTable AddUsrDt = DataHelper.QueryDataTable(SQL); //排除的人员 string ReMoveSQL = @" select CA.* from FL_Culture..SurveyedObj As A cross apply( select Filed As UserID from FL_Culture..GetTblByJson(A.AddUserNames,'Id') ) As CA where SurveyId='{0}'"; ReMoveSQL = string.Format(ReMoveSQL, SurveyId); ReMoveSQL = "select '' where 1<>1 "; //Change BY WGM 9-30 DataTable RemoveDt = DataHelper.QueryDataTable(ReMoveSQL); if (RemoveDt.Rows.Count > 0) { for (int i = 0; i < FilterUsrDt.Rows.Count; i++) { for (int j = 0; j < RemoveDt.Rows.Count; j++) { if (FilterUsrDt.Rows[i]["UserID"].ToString() == RemoveDt.Rows[j]["UserID"].ToString()) { FilterUsrDt.Rows.Remove(FilterUsrDt.Rows[i]); } } } } //---------------------------生成DataTable----------------------------- DataTable FinalDt = new DataTable(); DataColumn Dc_UserId = new DataColumn("UserId"); FinalDt.Columns.Add(Dc_UserId); DataColumn Dc_UserName = new DataColumn("UserName"); FinalDt.Columns.Add(Dc_UserName); DataColumn Dc_DeptId = new DataColumn("DeptId"); FinalDt.Columns.Add(Dc_DeptId); DataColumn Dc_DeptName = new DataColumn("DeptName"); FinalDt.Columns.Add(Dc_DeptName); DataColumn Dc_WorkNo = new DataColumn("WorkNo"); FinalDt.Columns.Add(Dc_WorkNo); // string FindSQL = @"select FL_Culture.dbo.GetGroupIds('{0}') As DeptId,FL_Culture.dbo.GetGroupNames('{0}') As DeptName"; for (int i = 0; i < FilterUsrDt.Rows.Count; i++) { //string tempSQL = string.Format(FindSQL, FilterUsrDt.Rows[i]["UserID"].ToString()); //DataTable tempDt = DataHelper.QueryDataTable(tempSQL); DataRow dr = FinalDt.NewRow(); //dr["DeptId"] = FilterUsrDt.Rows[i]["GroupIds"]; //dr["DeptName"] = FilterUsrDt.Rows[i]["GroupNames"]; string FullDept = WFHelper.getZzjg(FilterUsrDt.Rows[i]["UserID"].ToString(), true); dr["DeptName"] = FullDept; dr["UserId"] = FilterUsrDt.Rows[i]["UserID"]; //* dr["UserName"] = FilterUsrDt.Rows[i]["UserName"]; //* dr["WorkNo"] = FilterUsrDt.Rows[i]["WorkNo"]; FinalDt.Rows.Add(dr); } for (int i = 0; i < AddUsrDt.Rows.Count; i++) { DataRow dr = FinalDt.NewRow(); //dr["DeptId"] = AddUsrDt.Rows[i]["GroupID"]; //dr["DeptName"] = AddUsrDt.Rows[i]["GroupName"]; string FullDept = WFHelper.getZzjg(AddUsrDt.Rows[i]["UserID"].ToString(), true); dr["DeptName"] = FullDept; dr["UserId"] = AddUsrDt.Rows[i]["UserID"]; //* dr["UserName"] = AddUsrDt.Rows[i]["Name"]; //* dr["WorkNo"] = AddUsrDt.Rows[i]["WorkNo"]; FinalDt.Rows.Add(dr); } //添加问卷发起者 DataRow CreateRow = FinalDt.NewRow(); CreateRow["UserId"] = Ent.CreateId; CreateRow["UserName"] = Ent.CreateName; FinalDt.Rows.Add(CreateRow); //---------------------------------------------------------------------------- //生成调查用户 for (int i = 0; i < FinalDt.Rows.Count; i++) { SurveyFinallyUsr UserEnt = new SurveyFinallyUsr(); UserEnt.CreateWay = "1"; //1 表示生成的用户而非创建 UserEnt.SurveyId = SurveyId; UserEnt.DeptName = FinalDt.Rows[i]["DeptName"].ToString(); //UserEnt.DeptId = FinalDt.Rows[i]["DeptId"].ToString(); UserEnt.WorkNo = FinalDt.Rows[i]["WorkNo"].ToString(); UserEnt.UserId = FinalDt.Rows[i]["UserId"].ToString(); UserEnt.UserName = FinalDt.Rows[i]["UserName"].ToString(); UserEnt.DoCreate(); } return(true); }