static Admin() { // Initialize the dataset dsSale = new ReceiptDataSet(); dsWeekly = new WeeklyReviewDataSet(); // Initialize the table adapters receiptTableAdapter daSales = new receiptTableAdapter(); WeeklyReviewTableAdapter daWeekly = new WeeklyReviewTableAdapter(); try { // Fill the data adapter with data from the dataset daSales.Fill(dsSale.receipt); } catch { } }
public void GetNewRcvDtl(Epicor.Mfg.Core.Session epiSession, ReceiptDataSet dsReceipt) { try { Receipt myReceipt = new Receipt(epiSession.ConnectionPool); //ReceiptDataSet dsReceipt = new ReceiptDataSet(); //myReceipt.GetNewRcvDtl(dsReceipt, model.VendorNum, "", model.StoreInNum); myReceipt.GetNewRcvDtl(dsReceipt, 5, "", "IN00002-3"); DataRow drReceipt = dsReceipt.Tables[0].Rows[0]; drReceipt.BeginEdit(); drReceipt["VendorNum"] = 5; // model.VendorNum; drReceipt["PackSlip"] = "IN00002-3";//model.StoreInNum + "-2"; //drReceipt["PackLine"] = 1; //drReceipt["PartNum"] = DateTime.Now; drReceipt["WareHouseCode"] = "600"; drReceipt["OurQty"] = 10; // model.Quantity; drReceipt["PONum"] = 272; // model.PONum; drReceipt["POLine"] = 1; // model.POLine; drReceipt["PORelNum"] = 1; // model.POLine; drReceipt.EndEdit(); myReceipt.Update(dsReceipt); //IsSucces = true; //msgError = ""; } catch (Exception ex) { //IsSucces = false; //msgError = ex.Message; } }
public void GetRowsToNewRcvDetail(int storeInPlantId, SessionInfo epiSession, ReceiptDataSet dsReceipt) { IEnumerable<StoreInDetail> result; bool IsSucces; string msgError; string sql = string.Format(@"SELECT dtl.StoreInPlanId, max(dtl.LineId) as LineId,poh.PONum, poh.ShortChar10 as PONumber, pod.POLine, poh.ShortChar02 as SaleContract , 0 as WeightBalnce, 0 as RemainingWeight, pod.ShortChar01 as CommodityCode, pod.ShortChar02 as SpecCode , pod.Number01 as Thick, pod.Number02 as Width, pod.Number03 as Length, max(dtl.ArticleNo) as ArticleNo , sum(dtl.Quantity) as Quantity, sum(dtl.Weight) as Weight,max(dtl.Place) as Place, dtl.Note, GETDATE() as ReceiptDate , 0 as TaxPaid, dtl.Charactor02 as PackingNumber, pod.Number05 as DutyRate,pod.XOrderQty as OpenBalance , stin.StoreInId, '' as StockNo , '' as Location, poh.VendorNum , pod.Character02 as Enduser, pod.Character03 as ActualEndUser, stin.StoreInNum FROM dbo.ucc_ic_StoreInPlanDtl dtl LEFT JOIN POHeader poh ON(dtl.PONum = poh.ShortChar10) INNER JOIN PODetail pod ON(poh.PONum = pod.PONum and dtl.POLine = pod.POLine) LEFT JOIN ucc_ic_StoreInHead stin ON(dtl.StoreInPlanId = stin.StoreInPlanId) WHERE dtl.StoreInPlanId = {0} GROUP BY dtl.StoreInPlanId, stin.StoreInId, stin.StoreInNum , poh.PONum, poh.ShortChar10, pod.POLine, poh.ShortChar02 , pod.ShortChar01, pod.Character01 , pod.Number01, pod.Number02, pod.Number03, poh.VendorNum , dtl.Note, pod.Character02, pod.Character03 , dtl.Charactor02, pod.Number05,pod.XOrderQty", storeInPlantId); result = Repository.Instance.GetMany<StoreInDetail>(sql); //foreach (var t in result) //{ // this.GetNewRcvDtl(t, epiSession, dsReceipt, out IsSucces, out msgError); //} }
/// <summary> /// ******************Important!***************** /// </summary> /// <param name="model"></param> /// <param name="epiSession"></param> /// <param name="IsSucces"></param> /// <param name="msgError"></param> /// <returns></returns> public bool GetNewRcv(RecieptHeadModel head, List<ReceiptDetailModel> model, Epicor.Mfg.Core.Session epiSession, out bool IsSucces, out string msgError) { msgError = ""; ReceiptDataSet dsReceipt = new ReceiptDataSet(); try { Receipt myReceipt = new Receipt(epiSession.ConnectionPool); myReceipt.ValidateMRPONum(head.PONum, head.VendorNum, out msgError); #region PO no error. if (string.IsNullOrEmpty(msgError)) { /*This OK*/ myReceipt.GetNewRcvHead(dsReceipt, head.VendorNum, ""); /*Fix for testing myReceipt.GetNewRcvHead(dsReceipt, 5, ""); */ DataRow drReceipt = dsReceipt.Tables[0].Rows[0]; drReceipt.BeginEdit(); string PackSlip = head.StoreInNum + "-RCV"; /* This OK */ drReceipt["VendorNum"] = head.VendorNum; drReceipt["PackSlip"] = PackSlip; drReceipt["ReceiptDate"] = DateTime.Now; drReceipt["ReceivePerson"] = epiSession.UserID; drReceipt["ShipViaCode"] = "UC02"; drReceipt["PONum"] = head.PONum; /*Fix for testing drReceipt["VendorNum"] = 5; drReceipt["PackSlip"] = "IN00002-5"; drReceipt["ReceiptDate"] = DateTime.Now; drReceipt["ReceivePerson"] = "manager"; drReceipt["ShipViaCode"] = "UC02"; drReceipt["PONum"] = 272; */ drReceipt.EndEdit(); myReceipt.Update(dsReceipt); //myReceipt.CreateMassReceipts(model.VendorNum, "", model.StoreInNum, 0, model.PONum.ToString(), dsReceipt); myReceipt.CreateMassReceipts(head.VendorNum, "", PackSlip, 0, head.PONum.ToString(), dsReceipt); myReceipt.ReceiveAll(dsReceipt); int i = 0; foreach (DataRow dr in dsReceipt.Tables["RcvDtl"].Rows) { //myReceipt.GetNewRcvDtl(dsReceipt, model.VendorNum, "", model.StoreInNum); //DataRow drDtl = dsReceipt.Tables["RcvDtl"].Rows[i]; //myReceipt.GetDtlQtyInfo(dsReceipt, model.VendorNum, "", model.StoreInNum, dr["PackLine"].GetInt(), 1, "KG", "", out msgError); ReceiptDetailModel result = model.Where<ReceiptDetailModel>(p => p.PONum.ToString().Equals(dr["PONum"].ToString()) && p.POLine.ToString().Equals(dr["POLine"].ToString())).Single<ReceiptDetailModel>(); dr.BeginEdit(); dr["OurQty"] = result.Weight; dr["OurUnitCost"] = 1; //dr["VendorQty"] = result.Weight; dr["ReceivedComplete"] = false; dr["DocUnitCost"] = 20; //ถ้าเป็น PO Sample จะเป็น 0 (Else result.UnitPrice) dr["POTransValue"] = 20; dr["ExtTransValue"] = 20; dr["InputOurQty"] = result.Weight; dr["Number01"] = result.Weight; //Weight dr["Received"] = true; dr.EndEdit(); i++; } myReceipt.Update(dsReceipt); myReceipt.ReceiveAllLines(true, dsReceipt); //myReceipt.CommitRcvDtl(model.VendorNum, "", model.StoreInNum, dsReceipt); IsSucces = true; msgError = ""; return IsSucces; } #endregion PO no error. IsSucces = false; return IsSucces; } catch (Exception ex) { IsSucces = false; msgError = ex.Message; return IsSucces; } }