private void BtnSave_Click(object sender, EventArgs e) { try { bs.EndEdit(); if (_bill.单据类型 != (int)BillType.OtherInOut) { MessageHelper.ShowError("请输入有效的单据类型!其他出入库单据类型为:" + (int)BillType.OtherInOut); return; } if (_bill.子单据类型 != (int)SubBillType.OtherIn) { MessageHelper.ShowError("维护的子单据类型无效!其他入库类型为:" + (int)SubBillType.OtherIn); return; } var detailList = (List <TB_OTHER_IN>)bs.DataSource; if (detailList.Count == 0) { MessageHelper.ShowError("请维护其他入库明细!"); return; } SpareEntities db = EntitiesFactory.CreateSpareInstance(); BillHandler.AddOtherIn(db, _bill.VWToBill(GlobalVar.Oper.DeptCode), detailList); EntitiesFactory.SaveDb(db); NotifyController.AddStockSafeQty(db, GlobalVar.Oper.OperName); MessageHelper.ShowInfo("保存成功!"); } catch (Exception ex) { MessageHelper.ShowInfo(ex.ToString()); } }
private void BtnSave_Click(object sender, EventArgs e) { try { bs.EndEdit(); if (_bill.单据类型 != (int)BillType.StockMove) { MessageHelper.ShowError("请输入有效的单据类型!移库单据类型为:" + (int)BillType.StockMove); return; } var detailList = (List <TB_STOCK_MOVE>)bs.DataSource; if (detailList.Count == 0) { MessageHelper.ShowError("请维护移动明细!"); return; } SpareEntities db = EntitiesFactory.CreateSpareInstance(); BillHandler.AddStockMove(db, _bill.VWToBill(GlobalVar.Oper.DeptCode), detailList); EntitiesFactory.SaveDb(db); MessageHelper.ShowInfo("保存成功!"); } catch (Exception ex) { MessageHelper.ShowInfo(ex.ToString()); } }
private void BtnSave_Click(object sender, EventArgs e) { try { bs.EndEdit(); if (_bill.单据类型 != (int)BillType.SpareReturn) { MessageHelper.ShowError("请输入有效的单据类型!领用归还单据类型为:" + (int)BillType.SpareReturn); return; } var detailList = (List <TB_RETURN>)bs.DataSource; if (detailList.Count == 0) { MessageHelper.ShowError("请维护领用还回明细!"); return; } //List<TB_RETURN> detailList = (from TB_RETURN d in _list select d).ToList(); SpareEntities db = EntitiesFactory.CreateSpareInstance(); BillHandler.AddMaterialReturn(db, _bill.VWToBill(GlobalVar.Oper.DeptCode), detailList); EntitiesFactory.SaveDb(db); MessageHelper.ShowInfo("保存成功!"); } catch (Exception ex) { MessageHelper.ShowInfo(ex.ToString()); } }
private void BtnDeliver_Click(object sender, EventArgs e) { if (_bill == null || _bill.单据编号 == null) { MessageHelper.ShowInfo("请选择单据"); return; } if (MessageHelper.ShowQuestion("确定要执行选定的领用单?") == DialogResult.Yes) { SpareEntities db = EntitiesFactory.CreateSpareInstance(); var outlist = SpareOutController.GetList(db, _bill.单据编号); foreach (var spout in outlist) { if (string.IsNullOrEmpty(spout.TakeUser)) { MessageHelper.ShowError("领用详细中的领用人信息不能为空!"); return; } } BillHandler.FinishMaterialOut(db, _bill.VWToBill(GlobalVar.Oper.DeptCode), outlist); EntitiesFactory.SaveDb(db); NotifyController.AddStockSafeQty(db, GlobalVar.Oper.OperName); MessageHelper.ShowInfo("保存成功!"); } }
private void BtnSave_Click(object sender, EventArgs e) { try { bs.EndEdit(); if (_bill.单据类型 != (int)BillType.MaterialAsk) { MessageHelper.ShowError("请输入有效的单据类型!申请单单据类型为:" + (int)BillType.MaterialAsk); return; } if (_bill.子单据类型 != (int)SubBillType.SpareLoan && _bill.子单据类型 != (int)SubBillType.SpareOut) { MessageHelper.ShowError("维护的子单据类型无效!领用出库类型为:" + (int)SubBillType.SpareOut + "借用出库类型为:" + (int)SubBillType.SpareLoan); return; } var detailList = (List <TB_ASK>)bs.DataSource; if (detailList.Count == 0) { MessageHelper.ShowError("请维护领用申请明细!"); return; } var bill = _bill.VWToBill(GlobalVar.Oper.DeptCode); //List<TB_ASK> detailList = (from TB_ASK d in _list select d).ToList(); SpareEntities db = EntitiesFactory.CreateSpareInstance(); BillHandler.AddMaterialAsk(db, bill, detailList); EntitiesFactory.SaveDb(db); MessageHelper.ShowInfo("保存成功!"); } catch (Exception ex) { MessageHelper.ShowInfo(ex.ToString()); } }
private void ItemBtnReturn_Click(object sender, EventArgs e) { if (_bill == null || _bill.单据编号 == null) { MessageHelper.ShowInfo("请选择单据"); return; } if (_bill.状态 != (int)BillState.Finished) { MessageHelper.ShowInfo("选中单据状态错误,无法执行"); return; } var details = SpareOutController.GetList(_db, _bill.单据编号); try { string strInfo = BillHandler.HandleMaterialReturn(_db, _bill.VWToBill(GlobalVar.Oper.DeptCode), details); if (strInfo != "OK") { MessageHelper.ShowError(strInfo); } else { MessageHelper.ShowInfo("生成领用还回单成功"); EntitiesFactory.SaveDb(_db); } } catch (Exception ex) { MessageHelper.ShowError(ex.ToString()); throw; } }
private void btnCancel_Click(object sender, EventArgs e) { try { BillHandler.CancelMaterialAsk(_db, _bill.VWToBill(GlobalVar.Oper.DeptCode)); NotifyController.AddNotify(_db, _bill.操作者, NotifyType.MaterialOutCancel, _bill.单据编号, ""); EntitiesFactory.SaveDb(_db); SetMasterDataSource(grid.PageIndex, grid.PageSize); } catch (Exception ex) { MessageHelper.ShowError(ex.ToString()); } }
private ServiceState UpdateBill(BillType billType, DataSet ds) { ServiceState state = ServiceState.NoError; DataTable dt = new DataTable(); switch (billType) { case BillType.SortedDeliver: dt = ds.Tables[0]; var sortBill = ConvertHelper.DataTableToEntity <TS_SORT_BILL>(dt); BillHandler.UpdateSortBill("", sortBill); break; } return(state); }
private void btnExecute_Click(object sender, EventArgs e) { if (_bill == null || _bill.单据编号 == null) { MessageHelper.ShowInfo("请选择单据!"); return; } if (MessageHelper.ShowQuestion("确定要执行选定的领用还回单?") == DialogResult.Yes) { SpareEntities db = EntitiesFactory.CreateSpareInstance(); BillHandler.ExecuteSpareReturn(db, _bill.VWToBill(GlobalVar.Oper.DeptCode), (List <TB_RETURN>)(grid.Detail1DataSource)); EntitiesFactory.SaveDb(db); MessageHelper.ShowInfo("保存成功!"); } }
private static void ReadRCPFile(List <string> dataList, string filename, SpareEntities db) { Console.WriteLine(@"接收采购订单收货数据开始"); var partList = new List <TA_PART>(); var billList = new List <TB_BILL>(); var MIList = new List <TB_IN>(); for (int i = 0; i < dataList.Count; i++) { string strErr = "采购订单收货文件 " + filename + " 第 " + i + " 行 \t"; string data = dataList[i]; var cols = data.Split(';'); if (cols.Length != 11) { Console.WriteLine(strErr + @" 格式错误" + Environment.NewLine + "\t\t\t\t" + data); continue; } //添加TB_BILL表数据 var bill = new TB_BILL(); var BillNum = ""; var SourceBillNum = cols[0]; if (billList.FirstOrDefault(p => p.SourceBillNum == SourceBillNum) == null) { bill.BillNum = BillNum; bill.BillTime = DateTime.Now; bill.BillType = (int)BillType.MaterialIn; bill.OperName = GlobalVar.OperName; bill.SourceBillNum = SourceBillNum; billList.Add(bill); } //添加TB_IN表记录 var MI = new TB_IN() { BillNum = BillNum, PoBillNum = SourceBillNum, PoLineNum = Convert.ToInt32(cols[1]), PartCode = cols[3], Batch = GetBatch(), ToLocCode = _defaultLoc, Qty = Convert.ToInt32(cols[4]), UnitPrice = Convert.ToDecimal(cols[5]), ProduceDate = DateTime.Now }; MIList.Add(MI); } BillHandler.AddMaterialIn(db, billList, MIList); Console.WriteLine(@"接收采购订单收货数据完成"); }
private void btnSave_Click(object sender, EventArgs e) { try { bs.EndEdit(); var detailList = (List <TB_INVENTORY_DETAIL>)bs.DataSource; SpareEntities db = EntitiesFactory.CreateSpareInstance(); BillHandler.AddOrUpdateInventoryDetail(db, _bill.VWToBill(GlobalVar.Oper.DeptCode), detailList); EntitiesFactory.SaveDb(db); MessageHelper.ShowInfo("保存成功!"); } catch (Exception ex) { MessageHelper.ShowInfo(ex.ToString()); } }
private ServiceState AddBill(BillType billType, DataSet ds) { ServiceState state = ServiceState.NoError; DataTable dt = new DataTable(); switch (billType) { case BillType.MaterialIn: dt = ds.Tables[0]; var bill = ConvertHelper.DataTableToEntity <TB_BILL>(dt); dt = ds.Tables[1]; var details = ConvertHelper.DataTableToList <TB_MATERIAL_IN>(dt); state = BillHandler.AddMaterialIn(bill, details); break; } return(state); }
private void btnExecute_Click(object sender, EventArgs e) { if (_bill == null || _bill.单据编号 == null) { MessageHelper.ShowInfo("请选择单据!"); return; } if (MessageHelper.ShowQuestion("确定要执行选定的领用还回单?") == DialogResult.Yes) { SpareEntities db = EntitiesFactory.CreateSpareInstance(); var returnlist = db.TB_RETURN.Where(p => p.BillNum == _bill.单据编号).ToList(); BillHandler.ExecuteSpareReturn(db, _bill.VWToBill(GlobalVar.Oper.DeptCode), returnlist); EntitiesFactory.SaveDb(db); NotifyController.AddStockSafeQty(db, GlobalVar.Oper.OperName); MessageHelper.ShowInfo("保存成功!"); } }
private void btnCancel_Click(object sender, EventArgs e) { if (_inventoryLoc == null || _inventoryLoc.BillNum == null) { MessageHelper.ShowInfo("请选择单据!"); return; } try { BillHandler.CancelInventoryLoc(_db, _inventoryLoc); MessageHelper.ShowInfo("取消盘点库位:" + _inventoryLoc.BillNum + "." + _inventoryLoc.LocCode); } catch (Exception ex) { MessageHelper.ShowError(ex.ToString()); throw; } }
private void btnSave_Click(object sender, EventArgs e) { try { bs.EndEdit(); if (_bill.单据类型 != (int)BillType.InventoryPlan) { MessageHelper.ShowError("请输入有效的单据类型!盘点单据类型为:" + (int)BillType.InventoryPlan); return; } var detailList = new List <TB_INVENTORY_LOC>(); foreach (var group in _listGroup) { if (group.IsCheck) { var loclist = _db.TA_STORE_LOCATION.Where(p => p.GroupCode == group.GroupCode).ToList(); foreach (var loc in loclist) { var detail = new TB_INVENTORY_LOC() { LocCode = loc.LocCode, BillTime = DateTime.Now, State = 0 }; detailList.Add(detail); } } } if (detailList.Count == 0) { MessageHelper.ShowError("请选择要盘点的库位!"); return; } //List<TB_ASK> detailList = (from TB_ASK d in _list select d).ToList(); SpareEntities db = EntitiesFactory.CreateSpareInstance(); BillHandler.AddInventoryLoc(db, _bill.VWToBill(GlobalVar.Oper.DeptCode), detailList); EntitiesFactory.SaveDb(db); MessageHelper.ShowInfo("保存成功!"); } catch (Exception ex) { MessageHelper.ShowInfo(ex.ToString()); } }
private void btnAdjust_Click(object sender, EventArgs e) { if (_bill == null || _bill.单据编号 == null) { MessageHelper.ShowInfo("请选择单据!"); return; } if (_bill.状态 != (int)BillState.New && _bill.状态 != (int)BillState.Handling) { MessageHelper.ShowError("非新建或执行中单据,禁止对库存进行调整!"); return; } if (MessageHelper.ShowQuestion("是否确定要对库存进行调整?") == DialogResult.Yes) { BillHandler.AdjustStockByInventoryLoc(_db, _bill.VWToBill(GlobalVar.Oper.DeptCode)); EntitiesFactory.SaveDb(_db); NotifyController.AddStockSafeQty(_db, GlobalVar.Oper.OperName); MessageHelper.ShowInfo("调整库存成功!"); SetMasterDataSource(grid.PageSize); } }
public void UpdateSortBill(TS_SORT_BILL sortBill) { BillHandler.UpdateSortBill("", sortBill); }
public BillHandler setNext(BillHandler next) { this.next = next; return(this.next); }
private static void GetOAData(InterfaceEntities OAdb, SpareEntities db) { var SparePartlist = new List <TA_PART>(); var SpareBillList = new List <TB_BILL>(); var SparePOList = new List <TB_PO>(); //同步零件号 var partlist = OAdb.OA_PART.Where(p => p.IsSyn == 0).ToList(); if (partlist.Count > 0) { foreach (var part in partlist) { var SparePart = PartController.GetPartByPartCode(db, part.code); if (SparePart == null) { SparePart = new TA_PART(); } SparePart.PartCode = part.code; SparePart.ErpPartCode = part.code; SparePart.PartDesc1 = part.engname; SparePart.PartDesc2 = part.name; SparePart.Unit = part.unit; SparePart.BM = "B"; SparePartlist.Add(SparePart); } PartController.AddOrUpdate(db, SparePartlist); NotifyController.AddNotify(db, GlobalVar.OperName, NotifyType.OAInterfaceBase, "", ""); } //同步采购订单 var OAPOBill = OAdb.OA_PO_MAIN.FirstOrDefault(p => p.IsSyn == 0); if (OAPOBill != null) { var _bill = new TB_BILL() { BillNum = OAPOBill.orderno, BillType = (int)BillType.PuchaseOrder, BillTime = DateTime.Now, OperName = OAPOBill.@operator, SplyId = OAPOBill.suppliername, Remark = OAPOBill.remark }; SpareBillList.Add(_bill); OAPOBill.IsSyn = 1; OAdb.OA_PO_MAIN.AddOrUpdate(OAPOBill); var OAPOList = OAdb.OA_PO_SUB.Where(p => p.OAMainID == OAPOBill.OAID); foreach (var oaPoSub in OAPOList) { var SparePo = new TB_PO() { BillNum = _bill.BillNum, Line = Convert.ToInt32(oaPoSub.prln), PartCode = oaPoSub.itemnumber, BillQty = (decimal)oaPoSub.qty }; SparePOList.Add(SparePo); } BillHandler.AddPO(db, SpareBillList, SparePOList); NotifyController.AddNotify(db, GlobalVar.OperName, NotifyType.OAInterfacePO, "", ""); } }
public InPlacePizzaOrder() { this.billHandler = new BillHandler(10, 10, 10, 10, 10); }