public List <T_FB_SUBJECT> GetSubjectListByOrgType(string strOwnerID, string strOrgType, string strOrgId) { SubjectBLL bllSubject = new SubjectBLL(); List <T_FB_SUBJECT> entList = bllSubject.GetSubjectListByOrgType(strOwnerID, strOrgType, strOrgId); return(entList.Count() > 0 ? entList : null); }
public void ShowSubject() { this.dgvSubject.AutoGenerateColumns = false; if (this.tvGrade.SelectedNode.Level == 0) { try { this.dgvSubject.DataSource = SubjectBLL.GetSubject(); } catch (Exception ex) { MessageBox.Show("查询全部科目信息出现异常\n" + ex.Message, "系统提示 ", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else if (this.tvGrade.SelectedNode.Level == 1) { int gradeId = Convert.ToInt32(this.tvGrade.SelectedNode.Tag); try { this.dgvSubject.DataSource = SubjectBLL.GetSubject(gradeId); } catch (Exception ex) { MessageBox.Show("根据年级查询科目信息出现异常\n" + ex.Message, "系统提示 ", MessageBoxButtons.OK, MessageBoxIcon.Information); } } }
public ActionResult Report1(int PlanID) { infoHead.LeftURL = Url.Action("index", "Research", new { ID = PlanID, PlanID = PlanID }); ResearchPlanInfo info = ResearchPlanBLL.GetList(a => a.ID == PlanID).FirstOrDefault(); List <int> listDepartmentTypeID = info.DepartmentInfo.DepartmentTypeInfo.Select(a => a.ID).ToList(); var listSubject = SubjectBLL.GetList(a => listDepartmentTypeID.Contains(a.DepartmentTypeID)).ToList(); var listValuableSubjectResearch = info.ResearchInfo.Where(a => a.UserInfo.SubjectInfo.Select(u => u.ID).Contains(a.SubjectID)); var result = listSubject.Select(subject => new { ID = subject.ID, Name = subject.Name, CountTeacher = listValuableSubjectResearch.Where(r => r.SubjectID == subject.ID).GroupBy(r => r.lectureUserID).Count(), CountItems = listValuableSubjectResearch.Where(r => r.SubjectID == subject.ID).Count() }).OrderByDescending(a => a.CountItems).ToList(); result.Add(new { ID = 0, Name = "小计", CountTeacher = result.Sum(r => r.CountTeacher), CountItems = result.Sum(r => r.CountItems) }); ViewBag.listResult = result; return(View(info)); }
public void ChangeSubjectTest() //+ { // given var repository = new Repository(); var subjectBll = new SubjectBLL(repository); var workWeekBll = new WorkWeekBLL(repository); var workWeek = workWeekBll.CreateWorkWeek("test"); var source = subjectBll.CreateNew("testName", Day.Monday, DateTime.Now, 1234, "Ivanov A. V.", workWeek); var dest = new Subject("NewTestName", Day.Wednesday, DateTime.Now, 1248, "Ivanov A.V."); subjectBll.ChangeSubjectInfo(source, dest); // when var res = repository.GetWorkWeekById(workWeek.Id); var collection = res.Subjects; var resSubject = new List <Subject>(collection)[0]; // then var resSubjects = collection; Assert.AreEqual(resSubject.Name, source.Name); Assert.AreEqual(resSubject.FullName, source.FullName); Assert.AreEqual(resSubject.WorkWeek.Id, source.WorkWeek.Id); Assert.AreEqual(resSubject.DayOfWeek, source.DayOfWeek); Assert.AreEqual(resSubject.AudienceNumber, dest.AudienceNumber); }
public void CreateSubjectTest() //+ { // given var repository = new Repository(); var subjectBll = new SubjectBLL(repository); var workWeekBll = new WorkWeekBLL(repository); var workWeek = workWeekBll.CreateWorkWeek("test"); var subject = subjectBll.CreateNew("testName", Day.Monday, DateTime.Now, 1234, "Ivanov A. V.", workWeek); workWeek.Subjects.Add(subject); var workWeek2 = workWeekBll.CreateWorkWeek("test2"); // whenд var res = repository.GetWorkWeekById(workWeek.Id); // then Assert.AreEqual(workWeek.Id, res.Id); var resSubjects = res.Subjects; var workWeekSubject = new List <Subject>(workWeek.Subjects)[0]; var resSubject = new List <Subject>(resSubjects)[0]; Assert.AreEqual(res.Id, workWeek.Id); Assert.AreNotEqual(res.Id, workWeek2.Id); Assert.AreEqual(resSubject.Id, workWeekSubject.Id); Assert.AreEqual(resSubject.Name, workWeekSubject.Name); Assert.AreEqual(resSubject.AudienceNumber, workWeekSubject.AudienceNumber); Assert.AreEqual(resSubject.FullName, workWeekSubject.FullName); Assert.AreEqual(resSubject.WorkWeek.Id, workWeekSubject.WorkWeek.Id); Assert.AreEqual(resSubject.DayOfWeek, workWeekSubject.DayOfWeek); }
public void CreateSubjectTest() { //Arrange var repository = new Mock <IRepository>(); var subjectBll = new SubjectBLL(repository.Object); var workWeekBLL = new Mock <IWorkWeekBLL>(); workWeekBLL.Setup(w => w.CreateWorkWeek("test")) .Returns(ForMockWorkWeek()); var workWeek = workWeekBLL.Object.CreateWorkWeek("test"); //repository.Setup(x => x.Save()).Returns() // var subject = new Subject("testName", Day.Monday, DateTime.Now, 1234, "Vedenin A. V."); //subject.WorkWeek = workWeek; //Act //var subjectTest = subjectBll.CreateNew("testName", Day.Monday, DateTime.Now, 1234, "Vedenin A. V.", workWeek); Assert.Throws <ArgumentOutOfRangeException>(() => subjectBll.CreateNew("testName", Day.Monday, DateTime.Now, 1234, "Vedenin A. V.", workWeek)); //Assert //var res = repository.Object.GetWorkWeekById(workWeek.Id); }
public void GetSubjectTest() { var repository = new Mock <IRepository>(); var subjectBll = new SubjectBLL(repository.Object); new Action(() => subjectBll.GetSubjectById(new Guid())).Should().Throw <ArgumentOutOfRangeException>(); }
private void GetSelectList() { ViewBag.listDepartment = DepartmentBLL.GetList(a => a.Enable).OrderBy(a => a.Name) .Select(a => new SelectListItem() { Text = a.Name, Value = a.ID.ToString() }).ToList(); ViewBag.listTemplate = EvalTemplateBLL.GetList(a => a.Enable).OrderByDescending(a => a.SortID).ThenByDescending(a => a.ID) .Select(a => new SelectListItem() { Text = a.Name, Value = a.ID.ToString() }).ToList(); ViewBag.listSubject = SubjectBLL.GetList(a => a.Enable)// CurrentUser.SubjectInfo .Select(a => new SelectListItem() { Text = a.Name, Value = a.ID.ToString() }).ToList(); ViewBag.listLessionNumber = Common.GetListOrderID(); ViewBag.listGrade = Common.EnumToSelectListItem(typeof(SysEnum.LessionGrade)); ViewBag.listArea = Common.EnumToSelectListItem(typeof(SysEnum.ResearchArea)); List <SelectListItem> listClass = new List <SelectListItem>(); for (int i = 1; i < 50; i++) { listClass.Add(new SelectListItem() { Text = i + "班", Value = i + "班" }); } ViewBag.listClass = listClass; }
public UCtrlExam() { InitializeComponent(); _subjectBLL = new SubjectBLL(); _subjectList = _subjectBLL.GetSubjectList(); cboSubject.ValueMember = "SubjectId"; cboSubject.DisplayMember = "SubjectName"; cboSubject.DataSource = _subjectList; cboSubject.SelectedIndex = -1; List <KeyValuePair <ExamType, string> > kvp = new List <KeyValuePair <ExamType, string> >(); kvp.Add(new KeyValuePair <ExamType, string>(ExamType.MultipleChoice, "Multiple Choice")); kvp.Add(new KeyValuePair <ExamType, string>(ExamType.TrueOrFalse, "True or False")); kvp.Add(new KeyValuePair <ExamType, string>(ExamType.TypeTheAnswer, "Type the Answer")); cboExamType.ValueMember = "Key"; cboExamType.DisplayMember = "Value"; cboExamType.DataSource = kvp; cboExamType.SelectedIndex = -1; _examBLL = new ExamBLL(); dgvExam.AutoGenerateColumns = false; dgvTotal.AutoGenerateColumns = false; }
public UCtrlSubject() { InitializeComponent(); _subjectBLL = new SubjectBLL(); dgvSubject.AutoGenerateColumns = false; PopulateSubjectDatagridView(); }
public ActionResult SelectUser(int ID) { var info = ResearchPlanBLL.GetList(a => a.ID == ID).FirstOrDefault(); ViewBag.listMemberGroup = MemberGroupBLL.GetList(a => a.Enable).OrderByDescending(a => a.SortID).ThenByDescending(a => a.ID) .Select(a => new SelectListItem() { Text = a.Name, Value = a.ID.ToString() }).ToList(); ViewBag.listSubject = SubjectBLL.GetList(a => true).ToList().Where(a => info.DepartmentInfo.DepartmentTypeInfo.Contains(a.DepartmentTypeInfo)) .Select(a => new SelectListItem() { Text = a.Name, Value = a.ID.ToString() }).ToList(); WechatHeaderInfo infoHead = new WechatHeaderInfo(); infoHead.HeadText = "人员选择"; infoHead.LeftURL = Url == null ? "" : Url.Action("Detail", new { ID = ID }); ViewBag.WechatHeaderInfo = infoHead; ViewBag.SelectedUserJSON = Newtonsoft.Json.JsonConvert.SerializeObject(info.ResearchPlanUserInfo.Select(u => new { u.ID, u.UserID, Name = u.UserInfo.Name, u.IsConfirmed, subjectName = string.Join(",", u.UserInfo.SubjectInfo.Select(s => s.Name)), DepartmentName = u.UserInfo.DepartmentInfo.Name })); ViewBag.info = info; int MemberGroupID = Function.GetRequestInt("MemberGroupID"); int SubjectID = Function.GetRequestInt("SubjectID"); string Name = Function.GetRequestString("Name"); var listUser = UserBLL.GetList(a => a.Enable && a.RuleInfo.Any(r => r.PowerActionInfo.Any(p => p.NewID == PowerInfo.P_评课管理.PP组织调研.PPP听评课管理.添加))); if (MemberGroupID > 0) { listUser = listUser.Where(a => a.MemberGroupInfo.Any(mg => mg.ID == MemberGroupID)); ViewBag.DdlMemberGroup = MemberGroupID; } if (SubjectID > 0) { listUser = listUser.Where(a => a.SubjectInfo.Any(s => s.ID == SubjectID)); ViewBag.DdlSubject = SubjectID; } if (!string.IsNullOrEmpty(Name)) { listUser = listUser.Where(a => (a.Name.Contains(Name) || a.Tel.Contains(Name) || a.Code.Contains(Name))); ViewBag.TxtName = Name; } listUser = listUser.OrderBy(a => a.Name); return(View(listUser)); }
public void GetSubjectByIdTest_Throw_ArgumentOutOfRangeException() { var repository = new Repository(); var workWeek = new WorkWeekBLL(repository).CreateWorkWeek("test1"); var subjectBLL = new SubjectBLL(repository); var source = subjectBLL.CreateNew("testName", Day.Monday, DateTime.Now, 1234, "Vedenin A.V.", workWeek); subjectBLL.RemoveSubject(source.Id); Assert.Throws <ArgumentOutOfRangeException>(() => subjectBLL.GetSubjectById(source.Id)); }
public void RemoveSubjectTest() { var repository = new Repository(); var subjectBLL = new SubjectBLL(repository); var workWeekBLL = new WorkWeekBLL(repository); var workWeek = workWeekBLL.CreateWorkWeek("test 1"); var source = subjectBLL.CreateNew("testName", Day.Monday, DateTime.Now, 1234, "Vedenin A.V.", workWeek); Assert.True(subjectBLL.RemoveSubject(source.Id)); Assert.False(subjectBLL.RemoveSubject(source.Id)); }
public ResponseSubjectTotalGet SubjectFormulaGet([FromBody] RequestSubjectTotalGet request) { try { SubjectBLL bll = new SubjectBLL(); return(bll.SubjectFormulaGet(request)); } catch (Exception ex) { throw new HttpResponseException( Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.Message)); } }
public ResponseSubjectListSearch CheckSubjectIsReadonly([FromBody] RequestSubjectListSearch request) { try { SubjectBLL bll = new SubjectBLL(); return(bll.CheckSubjectIsReadonly(request)); } catch (Exception ex) { throw new HttpResponseException( Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.Message)); } }
public void RemoveWorkWeekTest() { var repository = new Repository(); var workWeekBLL = new WorkWeekBLL(repository); var subjectBll = new SubjectBLL(repository); var workWeek = workWeekBLL.CreateWorkWeek("test"); var subj1 = subjectBll.CreateNew("subj1", Day.Thursday, DateTime.Now, 1250, "qwerty", workWeek); var subj2 = subjectBll.CreateNew("subj2", Day.Wednesday, DateTime.Now, 1251, "asd", workWeek); var subj3 = subjectBll.CreateNew("subj3", Day.Wednesday, DateTime.Now, 1251, "asd", workWeek); Assert.True(workWeekBLL.Remove(workWeek.Id)); Assert.False(workWeekBLL.Remove(workWeek.Id)); }
public void GetAllTest() { var repository = new Repository(); var workWeekBLL = new WorkWeekBLL(repository); var subjectBll = new SubjectBLL(repository); var workWeek = workWeekBLL.CreateWorkWeek("test"); var workWeek2 = workWeekBLL.CreateWorkWeek("test2"); var subj0 = subjectBll.CreateNew("subj0", Day.Wednesday, DateTime.Now, 1249, "jh", workWeek2); var subj1 = subjectBll.CreateNew("subj1", Day.Thursday, DateTime.Now, 1250, "qwerty", workWeek); var subj2 = subjectBll.CreateNew("subj2", Day.Wednesday, DateTime.Now, 1251, "asd", workWeek); //сравнить списки var weeks = workWeekBLL.GetAll(); }
private void cbMaMH_SelectedIndexChanged(object sender, EventArgs e) { string mamh = this.cbMaMH.SelectedItem.ToString(); SubjectBLL subjectBll = new SubjectBLL(); DataTable dt1 = subjectBll.GetTENMH(mamh); DataTable dt2 = subjectBll.GetSOTIET(mamh); DataRow row1 = dt1.Rows[0]; DataRow row2 = dt2.Rows[0]; if (row1 != null && row2 != null) { this.txtTenMh.Text = (string)row1.ItemArray[0]; this.txtSotiet.Text = row2.ItemArray[0].ToString(); } }
public void ChangeSubjectTest() { var repository = new Repository(); var subjectBLL = new SubjectBLL(repository); var workWeekBLL = new WorkWeekBLL(repository); var workWeek = workWeekBLL.CreateWorkWeek("test 1"); var source = subjectBLL.CreateNew("testName", Day.Monday, DateTime.Now, 1234, "Vedenin A.V.", workWeek); var dest = new Subject("NewTestName", Day.Wednesday, DateTime.Now, 1248, "Ivanov A.V."); subjectBLL.ChangeSubjectInfo(source, dest); var res = repository.GetWorkWeekById(workWeek.Id); }
private void Form1_Load(object sender, EventArgs e) { try { SubjectBLL subjectBll = new SubjectBLL(); DataTable dt = subjectBll.GetAllCombo(); foreach (DataRow row in dt.Rows) { this.cbMaMH.Items.Add(row.ItemArray[0]); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public void CreateWorkWeekTest() { //Arrange var repository = new Repository(); var workWeekBLL = new WorkWeekBLL(repository); var subjectBll = new SubjectBLL(repository); //Act var workWeek = workWeekBLL.CreateWorkWeek("test"); var subj1 = subjectBll.CreateNew("subj1", Day.Thursday, DateTime.Now, 1252, "qwerty", workWeek); var subj2 = subjectBll.CreateNew("subj2", Day.Wednesday, DateTime.Now, 1253, "asd", workWeek); //Assert var res = repository.GetWorkWeekById(workWeek.Id); var res1 = repository.GetSubjectById(subj1.Id); var res2 = repository.GetSubjectById(subj2.Id); }
public void CreateSubjectTest() { //Arrange var repository = new Repository(); var subjectBll = new SubjectBLL(repository); var workWeekBLL = new WorkWeekBLL(repository); var workWeek = workWeekBLL.CreateWorkWeek("test"); //Act var subject = subjectBll.CreateNew("testName", Day.Monday, DateTime.Now, 1234, "Vedenin A. V.", workWeek); //Assert var res = repository.GetWorkWeekById(workWeek.Id); }
protected void btnGenXml_Click(object sender, EventArgs e) { string typeName = ""; string keyName = ""; var orderID = this.orderIDForXmlQuery.Text.Split(':')[0]; var entityInfo = EntityInfoList.First(item => item.Type == this.ddlOrderType.SelectedValue); typeName = entityInfo.Type; keyName = entityInfo.KeyName; var codeName = entityInfo.CodeName; string qName = codeName; Guid tempGuidID = Guid.Empty; if (Guid.TryParse(orderID, out tempGuidID)) { qName = keyName; } QueryExpression qe = QueryExpression.Equal(qName, orderID); qe.QueryType = typeName; SubjectBLL sbll = new SubjectBLL(); var data = qe.Query(sbll); var order = data.FirstOrDefault(); if (order != null) { this.orderIDForXmlQuery.Text += ":" + order.GetValue(keyName); FBEntity dataFBEntity = sbll.GetFBEntityByEntityKey(order.EntityKey); FBEntity fbEntity = new FBEntity(); VirtualAudit auditEntity = new VirtualAudit { ModelCode = typeName }; fbEntity.Entity = auditEntity; fbEntity.ReferencedEntity.Add(new RelationOneEntity() { FBEntity = dataFBEntity }); AuditBLL bll = new AuditBLL(); xmlConent.Value = bll.GetAuditXmlForMobile(auditEntity.ModelCode, dataFBEntity); } else { Response.Write("没有可操作的数据"); } }
private void frmAddResult_Load(object sender, EventArgs e) { this.cboSub.DisplayMember = "SubjectName"; this.cboSub.ValueMember = "SubjectId"; try { this.cboSub.DataSource = new BindingList <Subject>(SubjectBLL.GetSubject(this.Stu.Grade.GradeId)); } catch (Exception ex) { MessageBox.Show("绑定科目下拉框出现异常\n" + ex.Message, "系统提示 ", MessageBoxButtons.OK, MessageBoxIcon.Information); } ShowStudentResultSeach();//使用扩展类显示 //ShowStudentResult();//使用重写ToString()实现 }
public void RemoveSubjectTest() { // given var repository = new Repository(); var subjectBLL = new SubjectBLL(repository); var workWeekBLL = new WorkWeekBLL(repository); var workWeek = workWeekBLL.CreateWorkWeek("test 1"); var source = subjectBLL.CreateNew("testName", Day.Monday, DateTime.Now, 1234, "Vedenin A.V.", workWeek); Assert.True(subjectBLL.RemoveSubject(source.Id)); Assert.False(subjectBLL.RemoveSubject(source.Id)); var res = repository.GetWorkWeekById(workWeek.Id); Assert.AreEqual(0, res.Subjects.Count); }
public ActionResult Edit(int id) { UserInfo info = UserBLL.GetList(p => p.ID == id).FirstOrDefault(); if (null == info) { return(RedirectToAction("E404", "Error", new { Msg = "参数有误" })); } GetSelectList(); ViewBag.listSubject = SubjectBLL.GetList(a => a.Enable).ToList().Where(a => info.DepartmentInfo.DepartmentTypeInfo.Any(dt => dt.ID == a.DepartmentTypeID)) .Select(p => new SelectListItem() { Text = p.Name, Value = p.ID.ToString() }).ToList(); ViewBag.listRuleJSON = Newtonsoft.Json.JsonConvert.SerializeObject(info.RuleInfo.Select(a => new { a.ID, a.Name })); ViewBag.listSubjectJSON = Newtonsoft.Json.JsonConvert.SerializeObject(info.SubjectInfo.Select(a => new { a.ID, a.Name })); return(View(info)); }
public ActionResult Report3(int PlanID, int SubjectID) { //infoHead.LeftURL = Url.Action("ReportA", new { PlanID = PlanID }); infoHead.LeftURL = Url.Action("index", "Research", new { ID = PlanID, PlanID = PlanID }); ResearchPlanInfo info = ResearchPlanBLL.GetList(a => a.ID == PlanID).FirstOrDefault(); var infoSubject = SubjectBLL.GetList(a => a.ID == SubjectID).FirstOrDefault(); ViewBag.infoSubject = infoSubject; foreach (var item in info.EvalTemplateInfo.TemplateSubjectSummaryInfo) { var infoItemSummary = info.ResearchPlanSubjectSummaryInfo.Where(s => s.SubjectID == SubjectID) .SelectMany(s => s.ResearchPlanSubjectSummaryItemInfo).FirstOrDefault(i => i.TemplateSummaryID == item.ID); if (null != infoItemSummary) { ViewData["Detail" + item.ID] = infoItemSummary.Detail; } } return(View(info)); }
public ActionResult ResearchS_Detail(int SubjectID, int UserID, SysEnum.ResearchPlanType researchPlanType, DateTime?DateBegin = null, DateTime?DateEnd = null) { ViewBag.SubjectInfo = SubjectBLL.GetList(a => a.ID == SubjectID).FirstOrDefault(); ViewBag.UserInfo = UserBLL.GetList(a => a.ID == UserID).FirstOrDefault(); ViewBag.researchPlanType = researchPlanType; var list = ResearchBLL.GetList(a => true); list = list.Where(a => a.SubjectID == SubjectID); list = list.Where(a => a.UserID == UserID); if (null != DateBegin) { list = list.Where(a => DbFunctions.DiffDays(a.ResearchPlanInfo.DateBegin, DateBegin) <= 0); } if (null != DateEnd) { list = list.Where(a => DbFunctions.DiffDays(a.ResearchPlanInfo.DateEnd, DateEnd) >= 0); } list = list.Where(a => a.ResearchPlanInfo.TypeEnum == (int)researchPlanType); return(View(list)); }
public ActionResult InportPost2() { bool HidenIsInport = Function.GetRequestString("HidenIsInport").ToLower() == "true"; string DdlWorkSheet = Function.GetRequestString("DdlWorkSheet"); string HidenFileURL = Function.GetRequestString("HidenFileURL"); int ActivityID = Function.GetRequestInt("ActivityID"); HidenFileURL = Server.MapPath(HidenFileURL); DataTable dt = new DataTable(); try { dt = Tool.ExcelHelper.ExcelToDatatable(HidenFileURL, DdlWorkSheet); } catch (Exception ex) { return(Json(new APIJson(-1, "系统出错:" + ex.Message))); } for (int i = dt.Rows.Count - 1; i >= 0; i--) { if (string.IsNullOrEmpty(dt.Rows[i][0].ToString().Trim())) { dt.Rows.RemoveAt(i); } } var ErrorMsg = CheckDataTableHead(dt); if (!string.IsNullOrEmpty(ErrorMsg)) { return(Json(new APIJson(-1, ErrorMsg))); } if (!HidenIsInport) { return(Json(new APIJson(dt.DataTableToList()))); } var ListSubject = SubjectBLL.GetList(a => true).ToList(); var ListRule = RuleBLL.GetList(a => true).ToList(); List <string> listInportResult = new List <string>(); foreach (DataRow item in dt.Rows) { var HelpText1 = item["登录名"].ToString().Trim(); UserInfo info = UserBLL.GetList(a => a.Code == HelpText1).FirstOrDefault(); if (null == info) { info = new UserInfo(); info.PassWord = Md5Helper.Md5("qwe123"); info.Email = string.Empty; info.Tel = string.Empty; info.CreateDate = DateTime.Now; info.LastDate = DateTime.Now; info.LocationX = info.LocationY = 0; info.WechatOpenID = info.WechatNameNick = info.WechatHeadImg = string.Empty; info.Sex = "未知"; info.IDCard = string.Empty; info.TypeID = 0; info.DefaultSubjectID = 0; } HelpText1 = item["单位名称"].ToString().Trim(); DepartmentInfo infoDepartment = DepartmentBLL.GetList(a => a.Name == HelpText1).FirstOrDefault(); if (null == infoDepartment) { return(Json(new APIJson(-1, string.Format("提交失败,ID:{0}所在行中,单位名称在系统不存在", item["ID"].ToString())))); } info.DepartmentID = infoDepartment.ID; info.Enable = item["是否启用"].ToString().Trim() == "可用"; if (info.ID > 0) { if (item["学科"].ToString().Trim() != "忽略") { info.SubjectInfo.Clear(); } if (item["角色"].ToString().Trim() != "忽略") { info.RuleInfo.Clear(); } } foreach (var itemSubject in ListSubject.Where(a => item["学科"].ToString().Trim().Split('/').Contains(a.Name))) { info.SubjectInfo.Add(itemSubject); } foreach (var itemRule in ListRule.Where(a => item["角色"].ToString().Trim().Split('/').Contains(a.Name))) { info.RuleInfo.Add(itemRule); } listInportResult.Add(string.Format("ID:{0}验证成功", item["ID"].ToString())); if (info.ID == 0) { UserBLL.Create(info); } else { UserBLL.Edit(info); } } listInportResult.Add("导入完成!"); return(Json(new APIJson(1, "提交成功", listInportResult))); }
protected void btnGenXml_Click(object sender, EventArgs e) { string typeName = ""; string keyName = ""; var orderID = this.orderIDForXmlQuery.Text.Split(':')[0]; var entityInfo = EntityInfoList.First(item => item.Type == this.ddlOrderType.SelectedValue); typeName = entityInfo.Type; keyName = entityInfo.KeyName; var codeName = entityInfo.CodeName; string qName = codeName; Guid tempGuidID = Guid.Empty; if (Guid.TryParse(orderID, out tempGuidID)) { qName = keyName; } QueryExpression qe = QueryExpression.Equal(qName, orderID); qe.QueryType = typeName; SubjectBLL sbll = new SubjectBLL(); var data = qe.Query(sbll); var order = data.FirstOrDefault(); if (order != null) { this.orderIDForXmlQuery.Text += ":" + order.GetValue(keyName); FBEntity dataFBEntity = sbll.GetFBEntityByEntityKey(order.EntityKey); FBEntity fbEntity = new FBEntity(); VirtualAudit auditEntity = new VirtualAudit{ModelCode = typeName}; fbEntity.Entity = auditEntity; fbEntity.ReferencedEntity.Add(new RelationOneEntity(){FBEntity = dataFBEntity}); AuditBLL bll = new AuditBLL(); xmlConent.Value = bll.GetAuditXmlForMobile(auditEntity.ModelCode, dataFBEntity); } else { Response.Write("没有可操作的数据"); } }
public ActionResult InportLightPost2() { bool HidenIsInport = Function.GetRequestString("HidenIsInport").ToLower() == "true"; string DdlWorkSheet = Function.GetRequestString("DdlWorkSheet"); string HidenFileURL = Function.GetRequestString("HidenFileURL"); HidenFileURL = Server.MapPath(HidenFileURL); DataTable dt = new DataTable(); try { dt = Tool.ExcelHelper.ExcelToDatatable(HidenFileURL, DdlWorkSheet); } catch (Exception ex) { return(Json(new APIJson(-1, "系统出错:" + ex.Message))); } for (int i = dt.Rows.Count - 1; i >= 0; i--) { if (string.IsNullOrEmpty(dt.Rows[i][0].ToString().Trim())) { dt.Rows.RemoveAt(i); } } var ErrorMsg = CheckDataTableHeadLight(dt); if (!string.IsNullOrEmpty(ErrorMsg)) { return(Json(new APIJson(-1, ErrorMsg))); } if (!HidenIsInport) { return(Json(new APIJson(0, "解析成功", dt.DataTableToList()))); } var ListSubject = SubjectBLL.GetList(a => true).ToList(); int DefaultRuleIDWhenInport = Function.ConverToInt(ProfilesBLL.GetValue(ProfilesInfo.InportSetting.DefaultRuleIDWhenInport)); RuleInfo infoRule = RuleBLL.GetList(a => a.ID == DefaultRuleIDWhenInport).FirstOrDefault(); List <string> listInportResult = new List <string>(); List <UserInfo> listUserInport = new List <UserInfo>(); foreach (DataRow item in dt.Rows) { UserInfo infoUser = new UserInfo(); infoUser.DepartmentID = CurrentUser.DepartmentID; infoUser.Name = item["真实姓名"].ToString().Trim(); infoUser.Code = item["登录名"].ToString().Trim(); infoUser.PassWord = item["初始密码"].ToString().Trim(); infoUser.Email = string.Empty; infoUser.Tel = string.Empty; infoUser.CreateDate = DateTime.Now; infoUser.LastDate = DicInfo.DateZone; infoUser.Enable = true; infoUser.LocationX = 0; infoUser.LocationY = 0; infoUser.WechatOpenID = string.Empty; infoUser.WechatNameNick = string.Empty; infoUser.WechatHeadImg = string.Empty; infoUser.Sex = string.Empty; infoUser.IDCard = string.Empty; infoUser.TypeID = -3; infoUser.DefaultSubjectID = 0; infoUser.Email = string.Empty; var HelpText1 = item["学科"].ToString().Trim(); var UserSubjectinfo = ListSubject.Where(a => HelpText1.Split('|').Contains(a.Name)); if (UserSubjectinfo.Count() > 0) { infoUser.DefaultSubjectID = UserSubjectinfo.FirstOrDefault().ID; infoUser.SubjectInfo = new List <SubjectInfo>(); foreach (var itemSubject in UserSubjectinfo) { infoUser.SubjectInfo.Add(itemSubject); } } else { return(Json(new APIJson(-1, string.Format("提交失败,序号:{0}所在行中,对应学科数据无法识别", item["序号"].ToString())))); } infoUser.RuleInfo.Add(infoRule); if (string.IsNullOrEmpty(infoUser.Name) || string.IsNullOrEmpty(infoUser.Code)) { return(Json(new APIJson(-1, string.Format("提交失败,序号:{0}所在行中,用户名或登录名为空白,请先补填完整", item["序号"].ToString())))); } UserInfo infoDb = UserBLL.GetList(a => a.Code == infoUser.Code || a.Name == infoUser.Name).FirstOrDefault(); if (null != infoDb) { return(Json(new APIJson(-1, string.Format("提交失败,序号:{0}所在行中,用户名或登录名被占用,请为更改【可以登录名后加上数字或字母】", item["序号"].ToString())))); } if (infoUser.PassWord.Length < 6 || !ValidatePassWord(infoUser)) { return(Json(new APIJson(-1, string.Format("提交失败,序号:{0}所在行中,密码不符合要求,必需包括数字和字母,并且长度在6位数以上", item["序号"].ToString())))); } listUserInport.Add(infoUser); } foreach (var item in listUserInport) { UserBLL.Create(item); } listInportResult.Add("导入完成!"); return(Json(new APIJson(2, "提交成功," + listUserInport.Count() + "个帐户成功导入"))); }