Esempio n. 1
0
 public void Update(ref QHEmptyTank QHEmptyTank)
 {
     object[] results = this.Invoke("Update", new object[] {
         QHEmptyTank
     });
     QHEmptyTank = ((QHEmptyTank)(results[0]));
 }
Esempio n. 2
0
 /// <remarks/>
 public void EndUpdate(System.IAsyncResult asyncResult, out QHEmptyTank QHEmptyTank)
 {
     object[] results = this.EndInvoke(asyncResult);
     QHEmptyTank = ((QHEmptyTank)(results[0]));
 }
Esempio n. 3
0
 /// <remarks/>
 public System.IAsyncResult BeginUpdate(QHEmptyTank QHEmptyTank, System.AsyncCallback callback, object asyncState)
 {
     return(this.BeginInvoke("Update", new object[] {
         QHEmptyTank
     }, callback, asyncState));
 }
Esempio n. 4
0
        private void menuItem1_Click(object sender, EventArgs e)
        {
            if (GrdDailyLoss == null)
            {
                MessageBox.Show("There is no record to register!");
            }
            else
            {
                Cursor.Current = Cursors.WaitCursor;

                try
                {
                    decimal countotal = 0;
                    bool    flagtemp  = false;
                    string  itemtemp;
                    string  locationtemp;
                    string  bincodetemp;

                    ItemJournalDailyLossQH.ItemJournalDailyLossQH_Service dlservice = new QHMobile.ItemJournalDailyLossQH.ItemJournalDailyLossQH_Service();
                    dlservice.Url         = WebServiceInstants.GetURL(ServiceType.ItemJournalDailyLossQH);
                    dlservice.Credentials = nc;

                    QHSalesReceivableSetup.QHSalesReceivableSetup_Service qhsalesev = new QHMobile.QHSalesReceivableSetup.QHSalesReceivableSetup_Service();
                    qhsalesev.Credentials = nc;
                    qhsalesev.Url         = WebServiceInstants.GetURL(ServiceType.QHSalesReceivableSetup);

                    QHSalesReceivableSetup.QHSalesReceivableSetup[] qhsaleGet = qhsalesev.ReadMultiple(null, null, 0);


                    for (int i = 0; i < dl_array.Count; i++)
                    {
                        ItemJournalDailyLossQH.ItemJournalDailyLossQH dl = new QHMobile.ItemJournalDailyLossQH.ItemJournalDailyLossQH();

                        dlservice.Create(qhsaleGet[0].Change_Size_Batch, ref dl); // Actual value should be DOA

                        dl.Posting_Date = DateTime.Now;

                        if (dl_array[i].entrytype.Equals("Positive Adjmt."))
                        {
                            dl.Entry_Type = ItemJournalDailyLossQH.Entry_Type.Positive_Adjmt;
                        }
                        else if (dl_array[i].entrytype.Equals("Negative Adjmt."))
                        {
                            dl.Entry_Type = ItemJournalDailyLossQH.Entry_Type.Negative_Adjmt;
                        }

                        dl.Entry_TypeSpecified = true;

                        dl.Item_No       = dl_array[i].itemno;
                        dl.Quantity      = Convert.ToInt32(dl_array[i].quantity);
                        dl.Location_Code = dl_array[i].location;
                        //dl.Posting_Date = dl_array[i].postdate;
                        dl.Staff_Dimension_Code = staffdim;
                        dl.Bin_Code             = dl_array[i].bincode;

                        dlservice.Update(qhsaleGet[0].Change_Size_Batch, ref dl);
                    }
                    //// to adjust ////

                    ArrayList tnk = new ArrayList();
                    for (int i = 0; i < dl_array.Count; i++)
                    {
                        if ((dl_array[i].EmptyTank == true) && (dl_array[i].entrytype.Equals("Negative Adjmt.")))
                        {
                            if (i == 0)
                            {
                                tnk.Add(dl_array[i].bincode);
                            }
                            else
                            {
                                if (!tnk.Contains(dl_array[i].bincode))
                                {
                                    tnk.Add(dl_array[i].bincode);
                                }
                            }
                        }
                    }

                    for (int j = 0; j < tnk.Count; j++)
                    {
                        countotal    = 0;
                        flagtemp     = false;
                        itemtemp     = "";
                        locationtemp = "";
                        bincodetemp  = "";

                        for (int k = 0; k < dl_array.Count; k++)
                        {
                            if ((dl_array[k].EmptyTank == true) && (dl_array[k].entrytype.Equals("Negative Adjmt.")))
                            {
                                if (tnk[j].ToString().Equals(dl_array[k].bincode))
                                {
                                    itemtemp     = dl_array[k].itemno;
                                    countotal    = countotal + Convert.ToDecimal(dl_array[k].quantity);
                                    locationtemp = dl_array[k].location;
                                    bincodetemp  = dl_array[k].bincode;

                                    if (dl_array[k].EmptyTank == true)
                                    {
                                        flagtemp = true;
                                    }
                                }
                            }
                        }

                        //QHBinContent.QHBinContent_Service qhsev = new QHMobile.QHBinContent.QHBinContent_Service();
                        //qhsev.Credentials = nc;
                        //qhsev.Url = WebServiceInstants.GetURL(ServiceType.QHBinContent);

                        //List<QHBinContent.QHBinContent_Filter> filterArr = new List<QHMobile.QHBinContent.QHBinContent_Filter>();

                        //QHBinContent.QHBinContent_Filter binfilter = new QHMobile.QHBinContent.QHBinContent_Filter();
                        //binfilter.Field = QHMobile.QHBinContent.QHBinContent_Fields.Bin_Code;
                        //binfilter.Criteria = bincodetemp;

                        ////QHBinContent.QHBinContent_Filter Qtyfilter = new QHMobile.QHBinContent.QHBinContent_Filter();
                        ////Qtyfilter.Field = QHMobile.QHBinContent.QHBinContent_Fields.Quantity_Base;
                        ////Qtyfilter.Criteria = "<>0";

                        //QHBinContent.QHBinContent_Filter itemFilter = new QHMobile.QHBinContent.QHBinContent_Filter();
                        //itemFilter.Field = QHMobile.QHBinContent.QHBinContent_Fields.Item_No;
                        //itemFilter.Criteria = itemtemp;

                        //filterArr.Add(binfilter);
                        ////filterArr.Add(Qtyfilter);
                        //filterArr.Add(itemFilter);

                        //QHBinContent.QHBinContent[] qhbincon = qhsev.ReadMultiple(filterArr.ToArray(), null, 5);

                        if (flagtemp == true) //qhbincon[0].Quantity_Base < countotal ||
                        {
                            //  qhfun.TankAdj_NAV(itemtemp, packworksheet, locationtemp, bincodetemp, countotal, flagtemp);
                            //qhfun.TankAdj_NAV(itemtemp, packworksheet, locationtemp, bincodetemp, countotal);

                            QHEmptyTank.QHEmptyTank_Service qhempty = new QHMobile.QHEmptyTank.QHEmptyTank_Service();
                            qhempty.Url         = WebServiceInstants.GetURL(ServiceType.QHEmptyTank);
                            qhempty.Credentials = nc;

                            QHEmptyTank.QHEmptyTank qhcheck = qhempty.Read(bincodetemp);
                            if (qhcheck == null)
                            {
                                QHEmptyTank.QHEmptyTank qhtnk = new QHMobile.QHEmptyTank.QHEmptyTank();
                                qhtnk.Bin_Code = bincodetemp;
                                qhempty.Create(ref qhtnk);


                                qhtnk.Batch_Name    = qhsaleGet[0].Change_Size_Batch;
                                qhtnk.Item_No       = itemtemp;
                                qhtnk.Location_Code = locationtemp;
                                qhempty.Update(ref qhtnk);
                            }
                        }
                        //else if (qhbincon[0].Quantity - qhbincon[0].PDA_Inv_Pick_Quantity < countotal)
                        //{
                        //    QH_Functions.QH_Functions qhfun = new QHMobile.QH_Functions.QH_Functions();
                        //    qhfun.Url = WebServiceInstants.GetURL(ServiceType.QH_Functions);
                        //    qhfun.Credentials = nc;
                        //    decimal updatecount = countotal - (qhbincon[0].Quantity - qhbincon[0].PDA_Inv_Pick_Quantity);
                        //    qhfun.InsertIJLPositiveAdjustment(itemtemp, "", locationtemp, bincodetemp, updatecount);
                        //    //qhfun.TankAdj_NAV(itemtemp, "", locationtemp, bincodetemp, countotal, flagtemp);
                        //}
                    }

                    //// to adjust ////
                    CompactSQL comsql = new CompactSQL();
                    comsql.deleteRecord("ChangeSize");

                    MessageBox.Show("Submitted.");


                    this.Close();
                    DailyLossTS dilts = new DailyLossTS(staffname, staffdim, stafflevel);
                    dilts.Show();
                }
                catch (Exception ex)
                {
                    MessageBox.Show("Error:" + ex);
                }
                Cursor.Current = Cursors.Default;

                //DailyLossTS dts = new DailyLossTS(staffname, staffdim, stafflevel);
            }
        }
Esempio n. 5
0
        private void menuItem1_Click(object sender, EventArgs e)
        {
            if (GrdDailyLoss.DataSource == null)
            {
                MessageBox.Show("There is no record to register!");
            }
            else
            {
                Cursor.Current = Cursors.WaitCursor;

                try
                {
                    decimal countotal = 0;
                    bool    flagtemp  = false;
                    string  itemtemp;
                    string  locationtemp;
                    string  bincodetemp;


                    ItemJournalDailyLossQH.ItemJournalDailyLossQH_Service dlservice = new QHMobile.ItemJournalDailyLossQH.ItemJournalDailyLossQH_Service();
                    dlservice.Url         = WebServiceInstants.GetURL(ServiceType.ItemJournalDailyLossQH);
                    dlservice.Credentials = nc;

                    for (int i = 0; i < array_daily.Count; i++)
                    {
                        if (array_daily[i].lineNum.Equals("") || array_daily[i].lineNum == 0)
                        {
                            ItemJournalDailyLossQH.ItemJournalDailyLossQH dl = new QHMobile.ItemJournalDailyLossQH.ItemJournalDailyLossQH();

                            dlservice.Create("DOA", ref dl);     // Actual value should be DOA

                            ItemJournalDailyLossQH.ItemJournalDailyLossQH dlupdate = new QHMobile.ItemJournalDailyLossQH.ItemJournalDailyLossQH();
                            dlupdate = dlservice.Read("DOA", dl.Line_No);

                            //added by Hsu 23 april 2013//
                            array_daily[i].lineNum = dl.Line_No;

                            // added by Hsu 23 april 2013 //
                            dlupdate.Posting_Date          = Convert.ToDateTime(array_daily[i].postingDate);
                            dlupdate.Posting_DateSpecified = true;
                            dlupdate.Entry_Type            = ItemJournalDailyLossQH.Entry_Type.Negative_Adjmt;
                            dlupdate.Entry_TypeSpecified   = true;
                            dlupdate.Item_No = array_daily[i].itemno;

                            st = DateTime.Now.ToString("ddMMyyyy");
                            dlupdate.Document_No = st;

                            //dlservice.Update("DOA", ref dlupdate);

                            dlupdate.Quantity             = Convert.ToInt32(array_daily[i].quantity);
                            dlupdate.Location_Code        = array_daily[i].location;
                            dlupdate.Staff_Dimension_Code = staffdim;
                            dlupdate.Bin_Code             = array_daily[i].bincode;

                            dlservice.Update("DOA", ref dlupdate);
                            //array_daily.RemoveAt(i);
                        }

                        CompactSQL comsql = new CompactSQL();
                        comsql.DeleteOneRecord(array_daily[i].sqlLineNum, "DailyLoss");
                    }
                    //// to adjust ////

                    ArrayList tnk = new ArrayList();
                    for (int i = 0; i < array_daily.Count; i++)
                    {
                        if (i == 0)
                        {
                            tnk.Add(array_daily[i].bincode);
                        }
                        else
                        {
                            if (!tnk.Contains(array_daily[i].bincode))
                            {
                                tnk.Add(array_daily[i].bincode);
                            }
                        }
                    }

                    for (int j = 0; j < tnk.Count; j++)
                    {
                        countotal    = 0;
                        flagtemp     = false;
                        itemtemp     = "";
                        locationtemp = "";
                        bincodetemp  = "";

                        for (int k = 0; k < array_daily.Count; k++)
                        {
                            if (tnk[j].ToString().Equals(array_daily[k].bincode))
                            {
                                itemtemp     = array_daily[k].itemno;
                                countotal    = countotal + Convert.ToDecimal(array_daily[k].quantity);
                                locationtemp = array_daily[k].location;
                                bincodetemp  = array_daily[k].bincode;

                                if (array_daily[k].emptyTank == true)
                                {
                                    flagtemp = true;
                                }
                            }
                        }

                        if (flagtemp == true)     //qhbincon[0].Quantity_Base < countotal ||
                        {
                            QHEmptyTank.QHEmptyTank_Service qhempty = new QHMobile.QHEmptyTank.QHEmptyTank_Service();
                            qhempty.Url         = WebServiceInstants.GetURL(ServiceType.QHEmptyTank);
                            qhempty.Credentials = nc;

                            QHEmptyTank.QHEmptyTank qhcheck = qhempty.Read(bincodetemp);
                            if (qhcheck == null)
                            {
                                QHEmptyTank.QHEmptyTank qhtnk = new QHMobile.QHEmptyTank.QHEmptyTank();
                                qhtnk.Bin_Code = bincodetemp;

                                qhempty.Create(ref qhtnk);


                                qhtnk.Batch_Name    = "DOA";
                                qhtnk.Item_No       = itemtemp;
                                qhtnk.Location_Code = locationtemp;
                                qhempty.Update(ref qhtnk);
                            }
                        }
                    }

                    //// to adjsut ////

                    //CompactSQL comsql = new CompactSQL();
                    //comsql.deleteRecord("DailyLoss");

                    MessageBox.Show("Submitted.");
                    Cursor.Current          = Cursors.Default;
                    GrdDailyLoss.DataSource = null;
                    this.Close();
                    DailyLoss dlf = new DailyLoss(username, staffdim, userlevel);
                    dlf.Show();
                }
                catch (Exception ex)
                {
                    MessageBox.Show("Error:" + ex);
                    Cursor.Current = Cursors.Default;
                }
            }
        }
Esempio n. 6
0
        private void menuItem2_Click(object sender, EventArgs e)
        {
            if (GrdTO == null)
            {
                MessageBox.Show("There is no record to register!");
            }
            else
            {
                Cursor.Current = Cursors.WaitCursor;

                try
                {
                    ItemJournalQH.ItemJournalQH_Service journalService = new QHMobile.ItemJournalQH.ItemJournalQH_Service();
                    journalService.Url         = WebServiceInstants.GetURL(ServiceType.ItemJournalQH);
                    journalService.Credentials = nc;

                    for (int i = 0; i < journalarray.Count; i++)
                    {
                        ItemJournalQH.ItemJournalQH journal = new QHMobile.ItemJournalQH.ItemJournalQH();
                        journalService.Create("DEFAULT", ref journal);
                        journal.Document_Date          = journalarray[i].postingDate;
                        journal.Document_DateSpecified = true;
                        journal.Posting_Date           = journalarray[i].postingDate;


                        journalService.Update("DEFAULT", ref journal);

                        journal.Item_No              = journalarray[i].ItemNo;
                        journal.Location_Code        = journalarray[i].location;
                        journal.Bin_Code             = journalarray[i].frombin;
                        journal.New_Location_Code    = journalarray[i].location;
                        journal.New_Bin_Code         = journalarray[i].tobin;
                        journal.Quantity             = journalarray[i].quantity;
                        journal.Staff_Dimension_Code = journalarray[i].staffdimension;



                        journalService.Update("DEFAULT", ref journal);
                    }


                    ArrayList tnk = new ArrayList();
                    for (int i = 0; i < journalarray.Count; i++)
                    {
                        if (i == 0)
                        {
                            tnk.Add(journalarray[i].frombin);
                        }
                        else
                        {
                            if (!tnk.Contains(journalarray[i].frombin))
                            {
                                tnk.Add(journalarray[i].frombin);
                            }
                        }
                    }

                    decimal countotal = 0;
                    bool    flagtemp  = false;
                    string  itemtemp;
                    string  locationtemp;
                    string  bincodetemp;

                    for (int j = 0; j < tnk.Count; j++)
                    {
                        countotal    = 0;
                        flagtemp     = false;
                        itemtemp     = "";
                        locationtemp = "";
                        bincodetemp  = "";

                        for (int k = 0; k < journalarray.Count; k++)
                        {
                            if (tnk[j].ToString().Equals(journalarray[k].frombin))
                            {
                                itemtemp     = journalarray[k].ItemNo;
                                countotal    = countotal + Convert.ToDecimal(journalarray[k].quantity);
                                locationtemp = journalarray[k].location;
                                bincodetemp  = journalarray[k].frombin;

                                if (journalarray[k].emptyBin == true)
                                {
                                    flagtemp = true;
                                }
                            }
                        }

                        if (flagtemp == true) //qhbincon[0].Quantity_Base < countotal ||
                        {
                            QHEmptyTank.QHEmptyTank_Service qhempty = new QHMobile.QHEmptyTank.QHEmptyTank_Service();
                            qhempty.Url         = WebServiceInstants.GetURL(ServiceType.QHEmptyTank);
                            qhempty.Credentials = nc;

                            QHEmptyTank.QHEmptyTank qhcheck = qhempty.Read(bincodetemp);
                            if (qhcheck == null)
                            {
                                QHEmptyTank.QHEmptyTank qhtnk = new QHMobile.QHEmptyTank.QHEmptyTank();
                                qhtnk.Bin_Code = bincodetemp;

                                qhempty.Create(ref qhtnk);


                                qhtnk.Batch_Name    = "IReclass";
                                qhtnk.Item_No       = itemtemp;
                                qhtnk.Location_Code = locationtemp;
                                qhempty.Update(ref qhtnk);
                            }
                        }
                    }

                    CompactSQL comsql = new CompactSQL();
                    comsql.deleteRecord("ItemReclass");

                    MessageBox.Show("Submitted to Journal.");

                    TransferOrder tro = new TransferOrder(staffname, staffdimension, stafflevel);
                    tro.Show();
                    GrdTO.DataSource = null;

                    Cursor.Current = Cursors.Default;
                }
                catch (Exception ex)
                {
                    MessageBox.Show("Eorror:" + ex);
                }
                Cursor.Current = Cursors.Default;
            }
        }