public string DeleteVendor(string DeleteID)
{
string Str = "刪除失敗";
try
{
if (!string.IsNullOrWhiteSpace(DeleteID))
{
string[] DeleteIDList = null;
DeleteID = DeleteID.Replace("jqg_grid_gb1_", "").TrimEnd(',');
DeleteIDList = DeleteID.Split(',');
foreach (var item in DeleteIDList)
{
Models.VendorManagement Vendor = _db.MXIC_VendorManagements.Where(x => x.DeleteID.ToString() == item).FirstOrDefault();
//User.UserDisable = false;
_db.MXIC_VendorManagements.Remove(Vendor);
}
_db.SaveChanges();
Str = "刪除成功";
}
else
{
Str = "刪除失敗!請勾選刪除資料。";
}
}
catch (Exception e)
{
Str = e.ToString();
}
return(Str);
}
public string AddVendor(string PoNo, string VendorName, string EmpID, string EmpName, string Shifts)
{
string Str = "新增成功";
if (!string.IsNullOrWhiteSpace(PoNo) && !string.IsNullOrWhiteSpace(VendorName) && !string.IsNullOrWhiteSpace(EmpID) && !string.IsNullOrWhiteSpace(EmpName))
{
var OriginalEmp = _db.MXIC_VendorManagements.Where(x => x.EmpID == EmpID);
if (OriginalEmp.Any())
{
Str = "此駐廠人員編號已存在";
}
else
{
var AddUser = new Models.VendorManagement()
{
VenID = Guid.NewGuid(),
PoNo = PoNo,
VendorName = VendorName,
EmpID = EmpID,
EmpName = EmpName,
Shifts = Shifts,
DeleteID = Guid.NewGuid(),
EditID = Guid.NewGuid()
};
_db.MXIC_VendorManagements.Add(AddUser);
_db.SaveChanges();
}
}
else
{
Str = "新增失敗，請輸入所有資料。";
}
return(Str);
}
