public IHttpActionResult Delete(string ID)
{
CnDrug model = service.Get(ID);
if (model != null)
{
model.IsDeleted = true;
service.Edit(model);
}
return(Ok("ok"));
}
public bool Edit(CnDrug model)
{
using (CnDrugDAL dal = new CnDrugDAL())
{
if (model == null)
{
return(false);
}
DUG_CNDRUG entitys = ModelToEntity(model);
entitys.CREATEDATETIME = DateTime.Now;
return(dal.Edit(entitys));
}
}
/// <summary>
/// 新增
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public string Add(CnDrug model)
{
if (model == null)
{
return(string.Empty);
}
using (CnDrugDAL dal = new CnDrugDAL())
{
DUG_CNDRUG entity = ModelToEntity(model);
entity.ID = string.IsNullOrEmpty(model.ID) ? Guid.NewGuid().ToString("N") : model.ID;
entity.CREATEDATETIME = (model.CreateDateTime != null && model.CreateDateTime.HasValue) ? model.CreateDateTime.Value : DateTime.Now;
return(dal.Add(entity));
}
}
public IHttpActionResult Post([FromBody] Request <CnDrug> request)
{
CnDrug model = request.Data as CnDrug;
if (string.IsNullOrEmpty(model.ID))
{
service.Add(model);
}
else
{
service.Edit(model);
}
return(Ok("ok"));
}
/// <summary>
/// Entity转Model
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
private CnDrug EntityToModel(DUG_CNDRUG entity)
{
if (entity != null)
{
CnDrug model = new CnDrug()
{
ID = entity.ID,
DrugBankID = entity.DRUGBANKID,
Name = entity.NAME,
PinyinCode = entity.PINYINCODE,
EnName = entity.ENNAME,
CommonName = entity.COMMONNAME,
TypeName = entity.TYPENAME,
KindName = entity.KINDNAME,
IsPrescription = entity.ISPRESCRIPTION,
IsMedicalInsurance = entity.ISMEDICALINSURANCE,
Company = entity.COMPANY,
Pack = entity.PACK,
DosageForms = entity.DOSAGEFORMS,
Dosage = entity.DOSAGE,
Description = entity.DESCRIPTION,
Indication = entity.INDICATION,
Content = entity.CONTENT,
Price = entity.PRICE,
Contraindication = entity.CONTRAINDICATION,
Notice = entity.NOTICE,
Adverse = entity.ADVERSE,
CreateUserID = entity.CREATEUSERID,
CreateUserName = entity.CREATEUSERNAME,
CreateDateTime = entity.CREATEDATETIME,
EditUserID = entity.EDITUSERID,
EditUserName = entity.EDITUSERNAME,
EditTime = entity.EDITDATETIME,
OwnerID = entity.OWNERID,
OwnerName = entity.OWNERNAME,
IsDeleted = entity.ISDELETED
};
return(model);
}
return(null);
}
/// <summary>
/// Model转Entity
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
private DUG_CNDRUG ModelToEntity(CnDrug model)
{
if (model != null)
{
DUG_CNDRUG entity = new DUG_CNDRUG()
{
ID = model.ID,
DRUGBANKID = model.DrugBankID,
NAME = model.Name,
PINYINCODE = model.PinyinCode,
ENNAME = model.EnName,
COMMONNAME = model.CommonName,
TYPENAME = model.TypeName,
KINDNAME = model.KindName,
ISPRESCRIPTION = model.IsPrescription,
ISMEDICALINSURANCE = model.IsMedicalInsurance,
COMPANY = model.Company,
PACK = model.Pack,
DOSAGEFORMS = model.DosageForms,
DOSAGE = model.Dosage,
DESCRIPTION = model.Description,
INDICATION = model.Indication,
CONTENT = model.Content,
PRICE = model.Price,
CONTRAINDICATION = model.Contraindication,
NOTICE = model.Notice,
ADVERSE = model.Adverse,
CREATEUSERID = model.CreateUserID,
CREATEUSERNAME = model.CreateUserName,
CREATEDATETIME = model.CreateDateTime,
EDITUSERID = model.EditUserID,
EDITUSERNAME = model.EditUserName,
EDITDATETIME = model.EditTime,
OWNERID = model.OwnerID,
OWNERNAME = model.OwnerName,
ISDELETED = model.IsDeleted
};
return(entity);
}
return(null);
}
public IHttpActionResult Get(string ID)
{
CnDrug model = service.Get(ID);
return(Ok(model));
}
public IHttpActionResult Post()
{
//接受文件
if (HttpContext.Current.Request.Files.Count <= 0)
{
return(BadRequest("异常"));
}
HttpPostedFile file = HttpContext.Current.Request.Files[0];
try
{
//文件保存路径
string filePath = HttpContext.Current.Server.MapPath("~/Upload/XLS/");
if (!Directory.Exists(filePath))
{
Directory.CreateDirectory(filePath);
}
//文件格式判断
string[] exts = new string[] { ".xls", ".xlsx", ".doc", ".docx", ".jpg", ".gif", ".png", ".jpeg" };
string fileName = file.FileName;
string fileExt = file.FileName.Substring(file.FileName.LastIndexOf("."));
if (!exts.Contains(fileExt))
{
return(BadRequest("非法文件！"));
}
//文件保存
string newName = System.Guid.NewGuid().ToString("N") + fileExt;
string strPath = filePath + newName;
file.SaveAs(strPath);
FileStream fs = File.OpenRead(strPath);
IWorkbook wk = null;
try
{
wk = new HSSFWorkbook(fs); //把xls文件中的数据写入wk中
}
catch
{
fs = File.OpenRead(strPath);
wk = new XSSFWorkbook(fs);
}
fs.Dispose();
for (int i = 0; i < wk.NumberOfSheets; i++) //NumberOfSheets是myxls.xls中总共的表数
{
ISheet sheet = wk.GetSheetAt(i); //读取当前表数据
for (int j = 1; j <= sheet.LastRowNum; j++) //LastRowNum 是当前表的总行数
{
IRow row = sheet.GetRow(j); //读取当前行数据
if (row != null)
{
CnDrug model;
string name = GetCellValue(row.GetCell(0));
if (string.IsNullOrEmpty(name))
{
continue;
}
model = service.Get(p => p.NAME == name).FirstOrDefault();
if (model != null)
{
continue;
}
model = new CnDrug();
model.Name = name;
model.CommonName = GetCellValue(row.GetCell(1));
model.EnName = GetCellValue(row.GetCell(2), 100);
model.IsDeleted = false;
model.TypeName = GetCellValue(row.GetCell(3));
model.KindName = GetCellValue(row.GetCell(4));
model.IsMedicalInsurance = false;
model.IsPrescription = false;
model.Pack = GetCellValue(row.GetCell(5), 200);
model.Dosage = GetCellValue(row.GetCell(6), 300);
model.DosageForms = GetCellValue(row.GetCell(7));
model.Indication = GetCellValue(row.GetCell(8), 300);
model.Description = GetCellValue(row.GetCell(9), 300);
model.Content = GetCellValue(row.GetCell(10), 300);
model.DrugBankID = GetCellValue(row.GetCell(11));
service.Add(model);
}
}
}
}
catch
{
return(BadRequest("异常"));
}
return(Ok());
}
