/// <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)));
}
}
