public string ImportLisence(string PoNo, List <LisenceProperty> Property_ListModel)
{
string MessageStr = "匯入成功";
DateTime ImportTime = DateTime.Now;
for (int i = 0; i < Property_ListModel.Count; i++)
{
var AddLisenceItem = new Models.LisenceManagement()
{
LicID = Guid.NewGuid(),
PoNo = PoNo,
EmpName = Property_ListModel[i].EmpName,
LicName = Property_ListModel[i].LicName,
EndDate = Convert.ToDateTime(Property_ListModel[i].EndDate),
LicPossess = true,
UpDateTime = ImportTime,
EditID = Guid.NewGuid(),
DeleteID = Guid.NewGuid(),
};
_db.MXIC_LisenceManagements.Add(AddLisenceItem);
}
_db.SaveChanges();
return(MessageStr);
}
public string DeleteLisence(string DeleteID)
{
string MessageStr = "刪除失敗";
try
{
if (!string.IsNullOrWhiteSpace(DeleteID))
{
string[] DeleteIDList = null;
DeleteID = DeleteID.Replace("jqg_grid_gb1_", "").TrimEnd(',');
DeleteIDList = DeleteID.Split(',');
foreach (var item in DeleteIDList)
{
Models.LisenceManagement DeleteLisenceList = _db.MXIC_LisenceManagements.Where(x => x.DeleteID.ToString() == item).FirstOrDefault();
_db.MXIC_LisenceManagements.Remove(DeleteLisenceList);
}
_db.SaveChanges();
MessageStr = "刪除成功";
}
else
{
MessageStr = "刪除失敗!請勾選刪除資料。";
}
}
catch (Exception ex)
{
MessageStr = ex.ToString();
}
return(MessageStr);
}
public string AddLisence(string PoNo, string EmpName, string LicName, DateTime EndDate)
{
string MessageStr;
if (!string.IsNullOrWhiteSpace(PoNo) && !string.IsNullOrWhiteSpace(EmpName) && !string.IsNullOrWhiteSpace(LicName))
{
var check = _db.MXIC_LisenceManagements.Where(x => x.PoNo == PoNo && x.EmpName == EmpName && x.LicName == LicName);
if (check.Any())
{
MessageStr = "資料重複";
}
else
{
var AddLisenceItem = new Models.LisenceManagement()
{
LicID = Guid.NewGuid(),
PoNo = PoNo,
EmpName = EmpName,
LicName = LicName,
EndDate = EndDate,
LicPossess = true,
UpDateTime = DateTime.Now,
EditID = Guid.NewGuid(),
DeleteID = Guid.NewGuid()
};
_db.MXIC_LisenceManagements.Add(AddLisenceItem);
_db.SaveChanges();
MessageStr = "新增成功";
}
}
else
{
MessageStr = "新增失敗，請輸入所有資料。";
}
return(MessageStr);
}
