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