/// <summary> /// 初始化科室类别. /// </summary> /// <exception cref="NotImplementedException"></exception> internal void InitialDepartmentCategory() { var fileName = HttpContext.Current.Server.MapPath(System.Configuration.ConfigurationManager .AppSettings["DepartmentCategory"]); //第一列为类别的名称,第二列开始为Guid ReadFromExcel readFromExcel = new ReadFromExcel(); //按Row获取当前行的所有数据 int rowCount = readFromExcel.GetRowCount(fileName); for (int i = 2; i <= rowCount; i++) { var columnData = readFromExcel.ReadRowFromExcel((uint)i, fileName); //获取第一个数为类别 //第二列为类别的Guid,数据必须大于等2才是正确的 if (columnData.Count >= 2) { //var firstData = columnData.First(); WriteBaseData writeBaseData = new WriteBaseData(); DepartmentCategory departmentCategory = new DepartmentCategory(); departmentCategory.Name = columnData.ElementAt(0); departmentCategory.DepartmentCategoryID = Guid.Parse(columnData.ElementAt(1)); //写入数据库 departmentCategory = writeBaseData.AddDepartmentCategory(departmentCategory); } } }
public DepartmentCategory AddDepartmentCategory(DepartmentCategory departmentCategory) { //查重,如果数据库中已存在,返回该项 DepartmentCategory item = null; if (departmentCategory != null && departmentCategory.Name == null) { return(item); } using (ImsDbContext context = new ImsDbContext()) { //先用ID查重 if (departmentCategory.DepartmentCategoryID != null) { item = context.DepartmentCategories.Find(departmentCategory.DepartmentCategoryID); } //或用Name查重 else { if (departmentCategory.Name != null) { item = context.DepartmentCategories.Where(d => d.Name == departmentCategory.Name).FirstOrDefault(); } } if (item == null) { //如果为null,说明数据库不存在该项,添加 item = departmentCategory; context.DepartmentCategories.Add(item); context.SaveChanges(); } } return(item); }
public ActionResult DeleteConfirmed(int id) { DepartmentCategory departmentCategory = db.DepartmentCategories.Find(id); db.DepartmentCategories.Remove(departmentCategory); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "Id,Name,Logo,Text")] DepartmentCategory departmentCategory) { if (ModelState.IsValid) { db.Entry(departmentCategory).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(departmentCategory)); }
public ActionResult Create([Bind(Include = "Id,Name,Logo,Text")] DepartmentCategory departmentCategory) { if (ModelState.IsValid) { db.DepartmentCategories.Add(departmentCategory); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(departmentCategory)); }
public DepartmentCategory FindDepartmentCategoryByName(string name) { DepartmentCategory item = null; if (name != null) { using (ImsDbContext context = new ImsDbContext()) { item = context.DepartmentCategories.Where(d => d.Name == name).FirstOrDefault(); } } return(item); }
// GET: Manage/DepartmentCategories/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } DepartmentCategory departmentCategory = db.DepartmentCategories.Find(id); if (departmentCategory == null) { return(HttpNotFound()); } return(View(departmentCategory)); }
public void InitialDepartmentCategoryIndicatorMap() { var fileName = HttpContext.Current.Server.MapPath(System.Configuration.ConfigurationManager.AppSettings["DepartmentCategoryIndicatorMap"]); ReadFromExcel readFromExcel = new ReadFromExcel(); //按Row获取当前行的所有数据 //第一行为列标题,第二行开始是数据 int rowCount = readFromExcel.GetRowCount(fileName); for (int i = 2; i <= rowCount; i++) { var columnData = readFromExcel.ReadRowFromExcel((uint)i, fileName); //获取第一个数为科室类别 if (columnData.Count >= 2) { var firstData = columnData.First(); WriteBaseData writeBaseData = new WriteBaseData(); DepartmentCategory departmentCategory = new DepartmentCategory(); //将第一个数当作类别,找到科室类别 departmentCategory.Name = firstData; departmentCategory = writeBaseData.FindDepartmentCategoryByName(departmentCategory.Name); if (departmentCategory == null) { return; } columnData.Remove(firstData); //第二列及之后的数据为项目名称 foreach (var data in columnData) { //依次将第二个列之后的项目插入到科室类别项目表中 //如果该项目不在数据库,继续下一个数据 var indicator = writeBaseData.FindIndicatorByName(data); if (indicator == null) { continue; } //将Indicator添加进去 DepartmentCategoryIndicatorMap item = new DepartmentCategoryIndicatorMap(); item.DepartmentCategoryID = departmentCategory.DepartmentCategoryID; item.IndicatorID = indicator.IndicatorID; writeBaseData.AddDepartmentCategoryIndicatorMap(item); } } } }
/// <summary> /// 初始化科室与科室类别 /// </summary> public void InitialDepartmentAndCategory() { var departmentCategoryFile = HttpContext.Current.Server.MapPath(System.Configuration.ConfigurationManager.AppSettings["DepartmentCategory"]); //第一列为Category,先获取,再填充到 //从第二列开始,每列为科室,所属类别为第一列 //获取当前表格的总共Row数 ReadFromExcel readFromExcel = new ReadFromExcel(); //按Row获取当前行的所有数据 int rowCount = readFromExcel.GetRowCount(departmentCategoryFile); for (int i = 2; i <= rowCount; i++) { var columnData = readFromExcel.ReadRowFromExcel((uint)i, departmentCategoryFile); //获取第一个数为类别 if (columnData.Count >= 2) { var firstData = columnData.First(); WriteBaseData writeBaseData = new WriteBaseData(); DepartmentCategory departmentCategory = new DepartmentCategory(); //将第一个数当作类别,插入科室类别表中 departmentCategory.Name = firstData; departmentCategory = writeBaseData.AddDepartmentCategory(departmentCategory); if (departmentCategory == null) { return; } columnData.Remove(firstData); foreach (var data in columnData) { //依次将第二个列之后的科室名插入到科室表中 Department department = new Department(); department.DepartmentName = data; department.DepartmentCategoryID = departmentCategory.DepartmentCategoryID; writeBaseData.AddDepartment(department); } } } }
//Not sure what I'm meant to put in here static public bool InsertDepartmentCategory(int depID, int catID) { try { var db = Connection(); DepartmentCategory dc = new DepartmentCategory { DepartmentID = depID, CategoryID = catID }; db.DepartmentCategories.InsertOnSubmit(dc); db.SubmitChanges(); return(true); } catch (Exception e) { Console.WriteLine(e); return((bool)GetDefaultReturn(typeof(bool))); } }