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