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() + "个帐户成功导入")));
}
