public string Put([FromBody] tbEmployee employee)
{
try
{
tbEmployee tbEmployee = _db.tbEmployee.Where(b => b.EmployeeNo == employee.EmployeeNo).First();
tbEmployee.EmployeeName = employee.EmployeeName;
_db.SaveChanges();
}
catch (Exception ex)
{
return(ex.Message);
}
return("success");
}
public string Put([FromBody] ProductInfoes product)
{
try
{
ProductInfoes productInfoes = _db.ProductInfoes.Where(b => b.ProductNo == product.ProductNo).First();
productInfoes.Capcity = Convert.ToInt32(product.Capcity);
productInfoes.EffectiveMonth = Convert.ToInt32(product.EffectiveMonth);
productInfoes.EffectiveDay = Convert.ToInt32(product.EffectiveDay);
_db.SaveChanges();
}
catch (Exception ex)
{
return(ex.Message);
}
return("success");
}
public string Post([FromBody] List <ProductVendorSettle> listProductVendorSettl)
{
try
{
string vendorNo = "";
if (listProductVendorSettl.Count > 0)
{
vendorNo = listProductVendorSettl[0].VendorNo;
List <VendorProducts> listVendorProducts = _db.VendorProducts.Where(x => x.VendorNo == vendorNo).ToList();
foreach (VendorProducts vendorProducts in listVendorProducts)
{
_db.VendorProducts.Remove(vendorProducts);
}
_db.SaveChanges();
}
else
{
return("接收設定資料失敗!!");
}
foreach (ProductVendorSettle productVendorSettle in listProductVendorSettl)
{
if (productVendorSettle.Manufacture.Equals("1"))
{
VendorProducts insertVendorProducts = new VendorProducts();
insertVendorProducts.VendorNo = vendorNo;
insertVendorProducts.ProductNo = productVendorSettle.ProductNo;
insertVendorProducts.ProductName = productVendorSettle.ProductName;
insertVendorProducts.spec = productVendorSettle.Spec;
_db.VendorProducts.Add(insertVendorProducts);
_db.SaveChanges();
}
}
}
catch (Exception ex)
{
return(ex.Message);
}
return("success");
}
public string Post(string InventoryDate, string InventoryNo, string PalletsNo, string CaseNo, string BagNo)
{
try
{
IEnumerable <InventoryBody> InventoryBag = _db.InventoryBody.Where(e => e.InventoryNo == InventoryNo && e.BagNo == BagNo).AsEnumerable();
if (InventoryBag.Count() > 0)
{
return("新增失敗，已盤過此袋號!");
}
PackingLists PackingLists = _db.PackingLists.Where(e => e.BagNo == BagNo).FirstOrDefault();
if (PackingLists == null)
{
return("新增失敗，不合法的袋子!");
}
PackingLists = _db.PackingLists.Where(e => e.PalletsNo == PalletsNo && e.CaseNo == CaseNo).First();
InventoryBody InventoryPallets = _db.InventoryBody.Where(e => e.InventoryNo == InventoryNo).FirstOrDefault();
if (true)
{
InventoryBody Add_Bag = new InventoryBody();
Add_Bag.InventoryNo = InventoryNo;
Add_Bag.BagNo = BagNo;
Add_Bag.CaseNo = CaseNo;
Add_Bag.PalletsNo = PalletsNo;
Add_Bag.Lot = PackingLists.Lot;
Add_Bag.StockNo = InventoryPallets.StockNo;
Add_Bag.InventoryDate = DateTime.Now.ToString("yyyyMMdd");
Add_Bag.InventoryTime = DateTime.Now.ToString("hhmmss");
Add_Bag.InventoryMan = InventoryPallets.InventoryMan;
_db.InventoryBody.Add(Add_Bag);
_db.SaveChanges();
}
return("success");
}
catch (Exception ex)
{
return(ex.Message);
}
}
public string Post([FromBody] tbGroup group)
{
try
{
tbGroup tbGroup = _db.tbGroup.Where(x => x.GroupID == group.GroupID).FirstOrDefault();
if (tbGroup != null)
{
return("已存在此群組ID!!");
}
_db.tbGroup.Add(group);
_db.SaveChanges();
}
catch (Exception ex)
{
return(ex.Message);
}
return("success");
}
public string Put([FromBody] tbEmpGroup empGroup)
{
try
{
string[] arrGroupID = empGroup.GroupID.Split(','); //更改過後的GroupID
List <string> listDGroupID = new List <string>(); //需要刪除的GroupID
List <string> listAGroupID = new List <string>(); //需要新增的GroupID
bool flag = true;
List <tbEmpGroup> listTbEmpGroup = _db.tbEmpGroup.Where(b => b.EmployeeNo == empGroup.EmployeeNo).ToList();
//紀錄刪除項目
foreach (tbEmpGroup mtbEmpGroup in listTbEmpGroup)
{
flag = true;
for (int i = 0; i < arrGroupID.Length; i++)
{
if (mtbEmpGroup.GroupID.Equals(arrGroupID[i]))
{
flag = false;
break;
}
}
if (flag == true)
{
listDGroupID.Add(mtbEmpGroup.GroupID);
}
}
//紀錄新增項目
for (int i = 0; i < arrGroupID.Length; i++)
{
flag = true;
foreach (tbEmpGroup mtbEmpGroup in listTbEmpGroup)
{
if (arrGroupID[i].Equals(mtbEmpGroup.GroupID))
{
flag = false;
break;
}
}
if (flag == true)
{
listAGroupID.Add(arrGroupID[i]);
}
}
//資料庫刪除
foreach (string groupID in listDGroupID)
{
tbEmpGroup tbEmpGroup = _db.tbEmpGroup.Where(b => b.EmployeeNo == empGroup.EmployeeNo).Where(c => c.GroupID == groupID).First();
_db.tbEmpGroup.Remove(tbEmpGroup);
}
//資料庫新增
foreach (string groupID in listAGroupID)
{
tbEmpGroup tbEmpGroup = new tbEmpGroup();
tbEmpGroup.EmployeeNo = empGroup.EmployeeNo;
tbEmpGroup.GroupID = groupID;
_db.tbEmpGroup.Add(tbEmpGroup);
_db.SaveChanges();
}
}
catch (Exception ex)
{
return(ex.Message);
}
return("success");
}
public string Post(string InventoryDate, string InventoryNo)
{
try
{
InventoryHead Inventory = _db.InventoryHead.Where(e => e.InventoryNo == InventoryNo && e.InventoryDate == InventoryDate).FirstOrDefault();
string InventoryMan = (from a in _db.InventoryBody.Where(e => e.InventoryNo == InventoryNo) select new { a.InventoryMan }).First().InventoryMan;
if (Inventory.IsSummary == "N" || Inventory.IsSummary == "0")
{
//應盤項目
var Should = (from a in _db.vRecords
join b in (from w in _db.InventoryBody.Where(e => e.InventoryNo == InventoryNo)
group w by new { w.StockNo } into Stock
select new
{
Stock.Key.StockNo
})
on a.WarehouseNo equals b.StockNo
join c in _db.PackingLists
on a.BagNo equals c.BagNo
select new
{
a.BagNo,
c.CaseNo,
c.PalletsNo,
a.Lot,
StockNo = a.WarehouseNo
}).Distinct().ToList();
//實盤項目
var Actual = (from a in _db.InventoryBody.Where(e => e.InventoryNo == InventoryNo)
select new
{
a.BagNo,
a.CaseNo,
a.PalletsNo,
a.Lot,
a.StockNo
}).ToList();
var Loss = Should.Except(Actual);
List <InventoryAdjust> LossAdj = (from a in Loss
select new InventoryAdjust
{
InventoryNo = InventoryNo,
BagNo = a.BagNo,
CaseNo = a.CaseNo,
PalletsNo = a.PalletsNo,
Lot = a.Lot,
StockNo = a.StockNo,
OriQty = 1,
InventoryQty = 0,
AdjQty = 1,
InventoryDate = Inventory.InventoryDate,
InventoryTime = Inventory.InventoryTime,
InventoryMan = InventoryMan
}).ToList();
var Surplus = Actual.Except(Should);
List <InventoryAdjust> SurplusAdj = (from b in Surplus
select new InventoryAdjust
{
InventoryNo = InventoryNo,
BagNo = b.BagNo,
CaseNo = b.CaseNo,
PalletsNo = b.PalletsNo,
Lot = b.Lot,
StockNo = b.StockNo,
OriQty = 0,
InventoryQty = 1,
AdjQty = 1,
InventoryDate = Inventory.InventoryDate,
InventoryTime = Inventory.InventoryTime,
InventoryMan = InventoryMan,
}).ToList();
using (var dbContextTransaction = _db.Database.BeginTransaction())
{
try
{
foreach (InventoryAdjust Insert_loss in LossAdj)
{
_db.InventoryAdjust.Add(Insert_loss);
}
foreach (InventoryAdjust Insert_loss in SurplusAdj)
{
_db.InventoryAdjust.Add(Insert_loss);
}
Inventory.IsSummary = "Y";
_db.SaveChanges();
dbContextTransaction.Commit();
}
catch (Exception ex)
{
dbContextTransaction.Rollback();
return(ex.Message);
}
}
}
else
{
return("盤點底稿-" + InventoryNo + "已彙總，無法再彙總!");
}
}
catch (Exception ex)
{
return(ex.Message);
}
return("success");
}
