Ejemplo n.º 1
0
        private void loadCompanyAndBranchList()
        {
            try
            {
                string strMainDB    = System.Configuration.ConfigurationManager.AppSettings["MainDB"].ToString();
                string strInterface = System.Configuration.ConfigurationManager.AppSettings["InterDB"].ToString();

                sQuery  = " Select 'ALL' As 'Company' ";
                sQuery += " Union All ";
                sQuery += " Select T1.U_COMPANY As 'Company' From  ";
                sQuery += " [@Z_INBOUNDMAPPING] T1 Where ISNULL(T1.U_COMPANY,'') <> '' ";
                //sQuery += " Where T0.U_SHOPID = '" + dgv_S_OINV.Rows[i].Cells["ShopID"].Value.ToString().Trim() + "'";
                oCompanyDT = Armada_Sync.Singleton.objSqlDataAccess.ExecuteReader(sQuery, strMainDB);

                sQuery  = " Select T1.U_COMPANY As 'Company' ,T0.U_SHOPID As 'Shop' From  ";
                sQuery += " [@Z_INBOUNDMAPPINGC] T0 JOIN [@Z_INBOUNDMAPPING] T1 On T0.Code = T1.Code ";
                oShopDT = Armada_Sync.Singleton.objSqlDataAccess.ExecuteReader(sQuery, strMainDB);

                sQuery    = " SELECT DISTINCT Shop As 'Shop' ";
                sQuery   += " FROM RETN T0  ";
                sQuery   += " Where ISNULL([Status],'') = '' ";
                oShopDT_O = Armada_Sync.Singleton.objSqlDataAccess.ExecuteReader(sQuery, strInterface);

                cmbCompany.DataSource    = oCompanyDT;
                cmbCompany.DisplayMember = "Company";
                cmbCompany.ValueMember   = "Company";
                cmbCompany.SelectedIndex = 0;
                filterShops(cmbCompany.SelectedValue.ToString());
            }
            catch (Exception ex)
            {
                TransLog.traceService(" Error : " + ex.Message);
            }
        }
Ejemplo n.º 2
0
        private void loadLocationAndLocationList()
        {
            try
            {
                string strInterface = System.Configuration.ConfigurationManager.AppSettings["InterDB"].ToString();
                sQuery     = " Select 'ALL' As 'FLocation' ";
                sQuery    += " Union All ";
                sQuery    += " Select Distinct FrmLoc As 'FLocation' From INTR Where ISNULL(Status,'') <> 'Success'  ";
                oCompanyDT = Armada_Sync.Singleton.objSqlDataAccess.ExecuteReader(sQuery, strInterface);
                cmbFLocation.DataSource    = oCompanyDT;
                cmbFLocation.DisplayMember = "FLocation";
                cmbFLocation.ValueMember   = "FLocation";
                cmbFLocation.SelectedIndex = 0;

                sQuery  = " Select Distinct ToLoc As 'TLocation' From INTR   ";
                sQuery += " Where ISNULL(Status,'') <> 'Success'  ";
                //sQuery += " And FrmLoc = '" + cmbFLocation.SelectedValue.ToString() + "'";
                oLocationDT = Armada_Sync.Singleton.objSqlDataAccess.ExecuteReader(sQuery, strInterface);
                chkLocationID.Items.Clear();
                foreach (DataRow dr in oLocationDT.Rows)
                {
                    chkLocationID.Items.Add(dr["TLocation"], false);
                }
                chkLocationID.DisplayMember = "TLocation";
                chkLocationID.ValueMember   = "TLocation";

                //filterTLocations(cmbFLocation.SelectedValue.ToString());
            }
            catch (Exception ex)
            {
                TransLog.traceService(" Error : " + ex.Message);
            }
        }
Ejemplo n.º 3
0
        private void btnSync_Click(object sender, EventArgs e)
        {
            try
            {
                btnFilter.Enabled             = false;
                toolStripProgressBar1.Maximum = dgv_S_OCRD.RowCount;
                m_oWorker.RunWorkerAsync();

                //string[] strValues = new string[4];
                //Hashtable htCCDet = new Hashtable();
                //string strInterface = System.Configuration.ConfigurationManager.AppSettings["InterDB"].ToString();
                //string strMainDB = System.Configuration.ConfigurationManager.AppSettings["MainDB"].ToString();
                //oDtTransLog = Armada_Sync.Singleton.objSqlDataAccess.ExecuteReader(TRANSACTIONLOG, strInterface);
                //if (oDtTransLog != null && oDtTransLog.Rows.Count > 0)
                //{
                //    foreach (DataRow dr in oDtTransLog.Rows)
                //    {
                //        try
                //        {
                //            foreach (SAPbobsCOM.Company item in TransLog.objCompany)
                //            {
                //                TransLog.traceService(" Transaction Type : " + dr["Scenario"].ToString());
                //                TransLog.traceService(" Transaction Key : " + dr["Key"].ToString());
                //                TransLog.traceService("Company DB : " + item.CompanyDB);
                //                if (item.Connected)
                //                {
                //                    string strCountry = item.GetCompanyService().GetAdminInfo().Country;
                //                    if (dr["Country"].ToString() == strCountry)
                //                    {
                //                        if (strMainDB != item.CompanyDB)
                //                        {
                //                            Singleton.obj_S_OCRD.Sync((dr["Key"].ToString()), TransType.A, item, strInterface, "", strValues, htCCDet);
                //                        }
                //                    }
                //                    else
                //                    {
                //                        TransLog.traceService(" Error : Company Not Connected.");
                //                    }
                //                }
                //            }
                //        }
                //        catch (Exception ex)
                //        {
                //            TransLog.traceService(" Error : " + ex.Message);
                //        }
                //    }
                //}
                //MessageBox.Show("Manual Sync Completed...");
            }
            catch (Exception ex)
            {
                TransLog.traceService("Error Message : " + ex.Message);
                TransLog.traceService(" Error Source : " + ex.Source);
                MessageBox.Show(ex.Message.ToString());
            }
        }
Ejemplo n.º 4
0
 private void btnFilter_Click(object sender, EventArgs e)
 {
     try
     {
         LoadAll();
     }
     catch (Exception ex)
     {
         TransLog.traceService("Error Message : " + ex.Message);
     }
 }
Ejemplo n.º 5
0
 private void btnSync_Click(object sender, EventArgs e)
 {
     try
     {
         string[]  strValues    = new string[4];
         Hashtable htCCDet      = new Hashtable();
         string    strInterface = System.Configuration.ConfigurationManager.AppSettings["InterDB"].ToString();
         string    strMainDB    = System.Configuration.ConfigurationManager.AppSettings["MainDB"].ToString();
         oDtTransLog = Armada_Sync.Singleton.objSqlDataAccess.ExecuteReader(TRANSACTIONLOG, strInterface);
         if (oDtTransLog != null && oDtTransLog.Rows.Count > 0)
         {
             foreach (DataRow dr in oDtTransLog.Rows)
             {
                 try
                 {
                     foreach (SAPbobsCOM.Company item in TransLog.objCompany)
                     {
                         TransLog.traceService(" Transaction Type : " + dr["Scenario"].ToString());
                         TransLog.traceService(" Transaction Key : " + dr["Key"].ToString());
                         TransLog.traceService("Company DB : " + item.CompanyDB);
                         if (item.Connected)
                         {
                             string strCountry = item.GetCompanyService().GetAdminInfo().Country;
                             if (dr["Country"].ToString() == strCountry)
                             {
                                 if (strMainDB != item.CompanyDB)
                                 {
                                     Singleton.obj_S_OCRD.Sync((dr["Key"].ToString()), TransType.A, item, strInterface, "", strValues, htCCDet);
                                 }
                             }
                             else
                             {
                                 TransLog.traceService(" Error : Company Not Connected.");
                             }
                         }
                     }
                 }
                 catch (Exception ex)
                 {
                     TransLog.traceService(" Error : " + ex.Message);
                 }
             }
         }
         MessageBox.Show("Manual Sync Completed...");
         LoadAll();
     }
     catch (Exception ex)
     {
         TransLog.traceService("Error Message : " + ex.Message);
         TransLog.traceService(" Error Source : " + ex.Source);
         MessageBox.Show(ex.Message.ToString());
     }
 }
Ejemplo n.º 6
0
 private void btnSync_Click(object sender, EventArgs e)
 {
     try
     {
         btnFilter.Enabled = false;
         m_oWorker.RunWorkerAsync();
     }
     catch (Exception ex)
     {
         TransLog.traceService("Error Message : " + ex.Message);
         TransLog.traceService(" Error Source : " + ex.Source);
     }
 }
Ejemplo n.º 7
0
 private void S_OINV_Load(object sender, EventArgs e)
 {
     try
     {
         UXUTIL.clsUtilities.setAllControlsThemes(this);
         this.WindowState = FormWindowState.Maximized;
         LoadAll();
     }
     catch (Exception ex)
     {
         TransLog.traceService(" Error : " + ex.Message);
     }
 }
Ejemplo n.º 8
0
        private void btnImport_Click(object sender, EventArgs e)
        {
            if (txtFilePath.Text == string.Empty || txtFilePath.Text == "")
            {
                MessageBox.Show("Please select a file");
            }
            else
            {
                string strProvider = ConfigurationManager.AppSettings["oledbProvider"].ToString();

                bool   hasHeaders = true;
                String connString = String.Format(strProvider, txtFilePath.Text, hasHeaders ? "Yes" : "No");


                OleDbConnection oledbConn = new OleDbConnection(connString);
                try
                {
                    // Open connection
                    oledbConn.Open();

                    // Create OleDbCommand object and select data from worksheet Sheet1
                    OleDbCommand cmd = new OleDbCommand("SELECT * FROM " + ConfigurationManager.AppSettings["Sheet"].ToString(), oledbConn);

                    // Create new OleDbDataAdapter
                    OleDbDataAdapter oleda = new OleDbDataAdapter();

                    oleda.SelectCommand = cmd;

                    // Create a DataSet which will hold the data extracted from the worksheet.
                    oDS = new DataSet();

                    // Fill the DataSet from the data extracted from the worksheet.
                    oleda.Fill(oDS, "OITM");

                    // Bind the data to the GridView
                    dataGridView1.DataSource = oDS.Tables[0].DefaultView;

                    MessageBox.Show("Data Imported Sucessfully...");
                    //txtFilePath.Text = string.Empty;
                }
                catch (Exception ex)
                {
                    TransLog.traceService(" Error : " + ex.Message);
                }
                finally
                {
                    // Close connection
                    oledbConn.Close();
                }
            }
        }
Ejemplo n.º 9
0
 void m_oWorker_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e)
 {
     try
     {
         StatusLabel.Text  = "Sync Process Completed...";
         btnFilter.Enabled = true;
         LoadAll();
     }
     catch (Exception ex)
     {
         TransLog.traceService(ex.StackTrace.ToString());
         TransLog.traceService(ex.Message.ToString());
     }
 }
Ejemplo n.º 10
0
 private void btnSelectAll_Click(object sender, EventArgs e)
 {
     try
     {
         for (int index = 0; index <= chkShopID.Items.Count - 1; index++)
         {
             chkShopID.SetItemChecked(index, true);
         }
     }
     catch (Exception ex)
     {
         TransLog.traceService(" Error : " + ex.Message);
     }
 }
Ejemplo n.º 11
0
 private void LoadAll()
 {
     try
     {
         string    strInterface = System.Configuration.ConfigurationManager.AppSettings["InterDB"].ToString();
         DataTable oDS_M_S_OINV = null;
         string    str_M_S_OINV = "Exec Armada_Service_M_S_OINV_s";
         oDS_M_S_OINV          = Armada_Sync.Singleton.objSqlDataAccess.ExecuteReader(str_M_S_OINV, strInterface);
         dgv_S_OINV.DataSource = oDS_M_S_OINV;
     }
     catch (Exception ex)
     {
         TransLog.traceService(" Error : " + ex.Message);
     }
 }
Ejemplo n.º 12
0
        private void filterShops(string strCompany)
        {
            try
            {
                //bool Checked = false;
                DataTable oFilterCompany = null;
                DataView  dv             = new DataView();
                dv = oShopDT.DefaultView;
                DataTable dt = dv.Table;
                if (strCompany != "ALL")
                {
                    dt.DefaultView.RowFilter = "Company = '" + strCompany + "'";
                }
                else
                {
                    dt.DefaultView.RowFilter = " 1 = 1";
                }
                //chkShopID.Items.Clear();
                //foreach (DataRow dr in dt.DefaultView.ToTable().Rows)
                //{
                //    chkShopID.Items.Add(dr["Shop"], false);
                //}

                oFilterCompany = dt.DefaultView.ToTable();
                var query =
                    from shop in oFilterCompany.AsEnumerable()
                    join shop_o in oShopDT_O.AsEnumerable()
                    on shop.Field <string>("Shop") equals
                    shop_o.Field <string>("Shop")
                    select new
                {
                    shop = shop_o.Field <string>("Shop")
                };

                chkShopID.Items.Clear();
                foreach (var shop_o in query)
                {
                    chkShopID.Items.Add(shop_o.shop, false);
                }

                chkShopID.DisplayMember = "Shop";
                chkShopID.ValueMember   = "Shop";
            }
            catch (Exception ex)
            {
                TransLog.traceService(" Error : " + ex.Message);
            }
        }
Ejemplo n.º 13
0
 private void S_OCRD_Load(object sender, EventArgs e)
 {
     try
     {
         UXUTIL.clsUtilities.setAllControlsThemes(this);
         this.WindowState = FormWindowState.Maximized;
         loadCountry();
         //LoadAll();
         //loadError();
         //S_OCRD.CheckForIllegalCrossThreadCalls = true;
     }
     catch (Exception ex)
     {
         TransLog.traceService(" Error : " + ex.Message);
     }
 }
Ejemplo n.º 14
0
 private void loadCountry()
 {
     try
     {
         string strInterface = System.Configuration.ConfigurationManager.AppSettings["InterDB"].ToString();
         string str_Qry      = " Select Distinct Country From Customers Where Status Is Null ";
         oDtCountry               = Armada_Sync.Singleton.objSqlDataAccess.ExecuteReader(str_Qry, strInterface);
         CmbCountry.DataSource    = oDtCountry;
         CmbCountry.DisplayMember = "Country";
         CmbCountry.ValueMember   = "Country";
         CmbCountry.SelectedIndex = 0;
     }
     catch (Exception ex)
     {
         TransLog.traceService(" Error : " + ex.Message);
     }
 }
Ejemplo n.º 15
0
 private void LoadAll()
 {
     try
     {
         string    strInterface = System.Configuration.ConfigurationManager.AppSettings["InterDB"].ToString();
         DataTable oDS_OCRD     = null;
         string    strCountry   = CmbCountry.SelectedValue.ToString();
         string    str_M_S_OCRD = "Exec [Armada_Service_M_S_OCRD_s] '" + strCountry + "'";
         oDS_OCRD = Armada_Sync.Singleton.objSqlDataAccess.ExecuteReader(str_M_S_OCRD, strInterface);
         dgv_S_OCRD.DataSource = oDS_OCRD;
         loadError();
     }
     catch (Exception ex)
     {
         TransLog.traceService(" Error : " + ex.Message);
     }
 }
Ejemplo n.º 16
0
 private void LoadAll()
 {
     try
     {
         string    strInterface = System.Configuration.ConfigurationManager.AppSettings["InterDB"].ToString();
         DataTable oDS_M_S_OINV = null;
         DateTime  oFDate       = Fromdate.Value;
         DateTime  oTDate       = ToDate.Value;
         LoadShopXML();
         string str_M_S_OINV = "Exec Armada_Service_M_S_OINV_s '" + oFDate.ToString("yyyyMMdd") + "','" + oTDate.ToString("yyyyMMdd") + "','" + strShopXML + "'";
         oDS_M_S_OINV          = Armada_Sync.Singleton.objSqlDataAccess.ExecuteReader(str_M_S_OINV, strInterface);
         dgv_S_OINV.DataSource = oDS_M_S_OINV;
         loadError();
     }
     catch (Exception ex)
     {
         TransLog.traceService(" Error : " + ex.Message);
     }
 }
Ejemplo n.º 17
0
 private void LoadShopXML()
 {
     try
     {
         int      arrcnt  = 0;
         string   Shop    = null;
         string   Code    = null;
         string[] ShopArr = new string[chkShopID.CheckedItems.Count];
         for (arrcnt = 0; arrcnt <= chkShopID.CheckedItems.Count - 1; arrcnt++)
         {
             ShopArr[arrcnt] = chkShopID.CheckedItems[arrcnt].ToString();
         }
         Shop       = "Shop";
         Code       = "ShopID";
         strShopXML = ShopStringArrayToXML(ShopArr, Shop, Code);
     }
     catch (Exception ex)
     {
         TransLog.traceService(" Error : " + ex.Message);
     }
 }
Ejemplo n.º 18
0
        private String ShopStringArrayToXML(String[] Array, String Element, String Attribute)
        {
            XElement identity = new XElement(Element);

            try
            {
                for (int i = 0; i <= Array.Length - 1; i++)
                {
                    if (Array[i] != null)
                    {
                        XElement elm = new XElement(Attribute, Array[i].Trim());
                        identity.Add(elm);
                    }
                }
            }
            catch (Exception ex)
            {
                TransLog.traceService(" Error : " + ex.Message);
            }

            return(identity.ToString());
        }
Ejemplo n.º 19
0
 private void loadError()
 {
     try
     {
         for (int i = 0; i < dgv_S_OCRD.RowCount; i++)
         {
             if (dgv_S_OCRD.Rows[i].Cells[1].Value.ToString() == "-1")
             {
                 Image image = Armada_App.Properties.Resources.Create1;
                 dgv_S_OCRD.Rows[i].Cells["Image"].Value = image;
             }
             else
             {
                 Image image = Armada_App.Properties.Resources.Red_mark;
                 dgv_S_OCRD.Rows[i].Cells["Image"].Value = image;
             }
         }
     }
     catch (Exception ex)
     {
         TransLog.traceService(" Error : " + ex.Message);
     }
 }
Ejemplo n.º 20
0
 private void S_OITM_Load(object sender, EventArgs e)
 {
     try
     {
         UXUTIL.clsUtilities.setAllControlsThemes(this);
         this.WindowState = FormWindowState.Maximized;
         //this.CheckForIllegalCrossThreadCalls = false;
         oDtCompany = new DataTable();
         oDtCompany.Columns.Add("Company", typeof(string));
         oDtCompany.Columns.Add("Company Name", typeof(string));
         string strMaiDB = System.Configuration.ConfigurationManager.AppSettings["MainDB"].ToString();
         oCompany = (SAPbobsCOM.Company)TransLog.GetCompany(strMaiDB);
         SAPbobsCOM.Recordset oRecordSet;
         oRecordSet = oCompany.GetCompanyList();
         DataRow oDr;
         while (!oRecordSet.EoF)
         {
             oDr                 = oDtCompany.NewRow();
             oDr["Company"]      = oRecordSet.Fields.Item(0).Value;
             oDr["Company Name"] = oRecordSet.Fields.Item(1).Value;
             oDtCompany.Rows.Add(oDr);
             oRecordSet.MoveNext();
         }
         BindingSource bs = new BindingSource();
         bs.DataSource           = oDtCompany;
         comboBox1.DataSource    = oDtCompany;
         comboBox1.DisplayMember = "Company Name";
         comboBox1.ValueMember   = "Company";
         comboBox1.SelectedIndex = 0;
         System.Windows.Forms.Control.CheckForIllegalCrossThreadCalls = false;
     }
     catch (Exception ex)
     {
         TransLog.traceService(" Error : " + ex.Message);
     }
 }
Ejemplo n.º 21
0
        void m_oWorker_DoWork(object sender, DoWorkEventArgs e)
        {
            try
            {
                string[]  strValues    = new string[4];
                Hashtable htCCDet      = new Hashtable();
                string    strInterface = System.Configuration.ConfigurationManager.AppSettings["InterDB"].ToString();
                string    strMainDB    = System.Configuration.ConfigurationManager.AppSettings["MainDB"].ToString();

                for (int i = 0; i < dgv_S_OCRD.RowCount; i++)
                {
                    try
                    {
                        //dgv_S_OCRD.FirstDisplayedScrollingRowIndex = i;
                        //m_oWorker.ReportProgress(i);

                        bool blnSync = false;
                        foreach (SAPbobsCOM.Company item in TransLog.objCompany)
                        {
                            TransLog.traceService(" Transaction Type : " + dgv_S_OCRD.Rows[i].Cells["Scenario"].Value.ToString().Trim());
                            TransLog.traceService(" Transaction Key : " + dgv_S_OCRD.Rows[i].Cells["Source_Key"].Value.ToString().Trim());
                            TransLog.traceService("Company DB : " + item.CompanyDB);

                            if (item.Connected)
                            {
                                string strCountry = item.GetCompanyService().GetAdminInfo().Country;
                                if (dgv_S_OCRD.Rows[i].Cells["Country"].Value.ToString() == strCountry)
                                {
                                    if (strMainDB != item.CompanyDB)
                                    {
                                        Image image = Armada_App.Properties.Resources.Sync1;
                                        dgv_S_OCRD.Rows[i].Cells["Image"].Value = image;

                                        Singleton.obj_S_OCRD.Sync((dgv_S_OCRD.Rows[i].Cells["Source_Key"].Value.ToString().Trim()), TransType.A, item, strInterface, "", strValues, htCCDet);

                                        string strQuery = "Select Status,Remarks From dbo.Z_OTXN Where Scenario = '" + dgv_S_OCRD.Rows[i].Cells["Scenario"].Value.ToString().Trim() + "' ";
                                        strQuery += " And S_DocNo = '" + dgv_S_OCRD.Rows[i].Cells["Source_Key"].Value.ToString().Trim() + "' ";
                                        DataTable oStatus = Armada_Sync.Singleton.objSqlDataAccess.ExecuteReader(strQuery, strInterface);
                                        if (oStatus != null && oStatus.Rows.Count > 0)
                                        {
                                            if (oStatus.Rows[0][0].ToString() == "1")
                                            {
                                                blnSync = true;
                                                dgv_S_OCRD.Rows[i].Cells["Remarks"].Value = string.Empty;
                                            }
                                            else
                                            {
                                                blnSync = false;
                                                dgv_S_OCRD.Rows[i].Cells["Remarks"].Value = oStatus.Rows[0][1].ToString();
                                            }
                                        }
                                        else
                                        {
                                            blnSync = false;
                                        }
                                    }
                                }
                                if (blnSync)
                                {
                                    Image image = Armada_App.Properties.Resources.Yes1;
                                    dgv_S_OCRD.Rows[i].Cells["Image"].Value = image;
                                    //System.Threading.Thread.Sleep(100);
                                }
                                else
                                {
                                    Image image = Armada_App.Properties.Resources.Error1;
                                    dgv_S_OCRD.Rows[i].Cells["Image"].Value = image;
                                    //System.Threading.Thread.Sleep(100);
                                }
                            }
                            else
                            {
                                TransLog.traceService(" Error : Company Not Connected.");
                                //Image image = Armada_App.Properties.Resources.Error1;
                                //dgv_S_OCRD.Rows[i].Cells["Image"].Value = image;
                                //System.Threading.Thread.Sleep(100);
                            }
                            //toolStripProgressBar1.Value = i;
                        }
                        //toolStripProgressBar1.Value = 0;
                    }
                    catch (Exception ex)
                    {
                        TransLog.traceService(ex.StackTrace.ToString());
                        TransLog.traceService(ex.Message.ToString());
                    }
                }
                m_oWorker.CancelAsync();
            }
            catch (Exception ex)
            {
                TransLog.traceService(ex.StackTrace.ToString());
                TransLog.traceService(ex.Message.ToString());
            }
            finally
            {
                toolStripProgressBar1.Value = 0;
            }
        }
Ejemplo n.º 22
0
        private void btnSync_Click(object sender, EventArgs e)
        {
            try
            {
                //thread = new System.Threading.Thread(import_Products);
                //thread.Start();
                //if (!thread.IsAlive)
                //{
                //    thread.Abort();
                //}

                //int i = 1;
                int intThreadRecords = oDS.Tables[0].Rows.Count / 100;
                //int acount = 0;
                Hashtable aListHash = new Hashtable();
                aList_C = new ArrayList(intThreadRecords);

                for (int intRow = 0; intRow < oDS.Tables[0].Rows.Count; intRow++)
                {
                    //acount += 1;

                    if (!aListHash.Contains(oDS.Tables[0].Rows[intRow]["ItemCode"]))
                    {
                        aListHash.Add(oDS.Tables[0].Rows[intRow]["ItemCode"], oDS.Tables[0].Rows[intRow]);
                    }

                    if (aListHash.Count == intThreadRecords)
                    {
                        aList_C.Add(aListHash);
                    }
                    else if (oDS.Tables[0].Rows.Count - 1 == intRow)
                    {
                        aList_C.Add(aListHash);
                    }

                    if (aListHash.Count == intThreadRecords)
                    {
                        aListHash = new Hashtable();
                    }
                }
                string strMaiDB = comboBox1.SelectedValue.ToString();

                //System.Threading.Thread[] ThreadCollections = new System.Threading.Thread[aList_C.Count + 1];

                for (int index = 0; index <= aList_C.Count - 1; index++)
                {
                    Hashtable oHT        = (Hashtable)aList_C[index];
                    Multitask oMultiTask = new Multitask(strMaiDB, this, oDS, oHT);
                    thread                = new Thread(oMultiTask.import_Products);
                    thread.Priority       = ThreadPriority.Highest;
                    thread.IsBackground   = true;
                    thread.ApartmentState = System.Threading.ApartmentState.STA;
                    thread.Start();

                    //ThreadCollections[index) = thread;
                }
            }
            catch (Exception ex)
            {
                TransLog.traceService(" Error : " + ex.Message);
            }
        }
Ejemplo n.º 23
0
        public void import_Products()
        {
            try
            {
                System.Reflection.Assembly oItem_R = System.Reflection.Assembly.LoadFrom(Application.StartupPath + "\\Interop.SAPbobsCOM.dll");
                string strMaiDB = strCompany_S.ToString();//System.Configuration.ConfigurationManager.AppSettings["MainDB"].ToString();
                oCompany = (SAPbobsCOM.Company)TransLog.GetCompany(strMaiDB);
                SAPbobsCOM.Items oItem = (SAPbobsCOM.Items)oCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.oItems);

                foreach (DictionaryEntry entry in oHT_S)
                {
                    DataRow row = (DataRow)entry.Value;
                    try
                    {
                        bool   blnItemExist = false;
                        string strItemCode  = row["ItemCode"].ToString();
                        TransLog.traceService(" Product : " + strItemCode);

                        //Thread.Sleep(100);
                        //oForm_S.label1.Text = "Creation Item No : " + " - :" + strItemCode;
                        //Application.DoEvents();

                        //oForm_S.Invoke((MethodInvoker)delegate
                        //{
                        //    oForm_S.label1.Text = strItemCode; // runs on UI thread
                        //});

                        //oForm_S.label1.Invoke(new Action(() => Control.text = ""));
                        if (oItem.GetByKey(row["ItemCode"].ToString()))
                        {
                            blnItemExist = true;
                        }

                        foreach (DataColumn column in oDS_S.Tables[0].Columns)
                        {
                            string DESTF = column.ColumnName;
                            if (!DESTF.StartsWith("U_"))
                            {
                                try
                                {
                                    if (DESTF != "ItemsGroupCode")
                                    {
                                        oItem_R.GetType("SAPbobsCOM.IItems").GetProperty(DESTF).SetValue(oItem, row[DESTF].ToString(), null);
                                    }
                                    else
                                    {
                                        oItem_R.GetType("SAPbobsCOM.IItems").GetProperty(DESTF).SetValue(oItem, Convert.ToInt32(row[DESTF].ToString()), null);
                                    }
                                }
                                catch (Exception ex)
                                {
                                    TransLog.traceService(" Error : " + ex.Message + "--> Field  : " + DESTF);
                                }
                            }
                            else
                            {
                                oItem.UserFields.Fields.Item(DESTF).Value = row[column.ColumnName.ToString()].ToString();
                            }
                        }

                        int intStatus = 0;
                        if (!blnItemExist)
                        {
                            intStatus = oItem.Add();
                            if (intStatus != 0)
                            {
                                TransLog.traceService(" Error : " + oCompany.GetLastErrorDescription());
                            }
                            else
                            {
                                TransLog.traceService(" Success  ");
                            }
                        }
                        else
                        {
                            intStatus = oItem.Update();
                            if (intStatus != 0)
                            {
                                TransLog.traceService(" Error : " + oCompany.GetLastErrorDescription());
                            }
                            else
                            {
                                TransLog.traceService(" Success  ");
                            }
                        }
                    }
                    catch (Exception ex)
                    {
                        TransLog.traceService(" Error : " + ex.Message);
                    }
                }
            }
            catch (Exception ex)
            {
                TransLog.traceService(" Error : " + ex.Message);
            }
        }
Ejemplo n.º 24
0
        private void btnSync_Click(object sender, EventArgs e)
        {
            try
            {
                string strInterface = System.Configuration.ConfigurationManager.AppSettings["InterDB"].ToString();
                string strMainDB    = System.Configuration.ConfigurationManager.AppSettings["MainDB"].ToString();
                oDtTransLog = Armada_Sync.Singleton.objSqlDataAccess.ExecuteReader(TRANSACTIONLOG, strInterface);
                if (oDtTransLog != null && oDtTransLog.Rows.Count > 0)
                {
                    foreach (DataRow dr in oDtTransLog.Rows)
                    {
                        try
                        {
                            string[] strValues = new string[4];

                            sQuery  = " Select T1.U_COMPANY,T0.U_WAREHOUSE From  ";
                            sQuery += " [@Z_INBOUNDMAPPINGC] T0 JOIN [@Z_INBOUNDMAPPING] T1 On T0.Code = T1.Code ";
                            sQuery += " Where T0.U_SHOPID = '" + dr["ShopID"].ToString() + "'";
                            oCompDT = Armada_Sync.Singleton.objSqlDataAccess.ExecuteReader(sQuery, strMainDB);
                            if (oCompDT != null)
                            {
                                if (oCompDT.Rows.Count > 0)
                                {
                                    strCompany   = oCompDT.Rows[0][0].ToString();
                                    strWareHouse = oCompDT.Rows[0][1].ToString();
                                    oGetCompany  = TransLog.GetCompany(strCompany);
                                }
                            }

                            sQuery  = " Select T1.U_COMPANY,T0.U_WAREHOUSE,T0.U_PRICELIST From  ";
                            sQuery += " [@Z_INBOUNDMAPPINGC] T0 JOIN [@Z_INBOUNDMAPPING] T1 On T0.Code = T1.Code ";
                            sQuery += " Where T0.U_SHOPID = '" + dr["ShopID_T"].ToString() + "'";
                            oCompDT = Armada_Sync.Singleton.objSqlDataAccess.ExecuteReader(sQuery, strMainDB);
                            if (oCompDT != null)
                            {
                                if (oCompDT.Rows.Count > 0)
                                {
                                    strCompany_T   = oCompDT.Rows[0][0].ToString();
                                    strWareHouse_T = oCompDT.Rows[0][1].ToString();
                                    oGetCompany_T  = TransLog.GetCompany(strCompany_T);
                                    strValues[0]   = oCompDT.Rows[0][2].ToString();
                                }
                            }


                            TransLog.traceService(" Transaction Type : " + dr["Scenario"].ToString());
                            TransLog.traceService(" Transaction Key : " + dr["Key"].ToString());

                            if (oGetCompany != null && oGetCompany_T != null)
                            {
                                TransLog.traceService("From Company DB : " + oGetCompany.CompanyDB);
                                TransLog.traceService("To Company DB : " + oGetCompany_T.CompanyDB);

                                if (oGetCompany.Connected && oGetCompany_T.Connected)
                                {
                                    Singleton.obj_S_OWTR.Sync((dr["Key"].ToString()), TransType.A, oGetCompany, oGetCompany_T, strInterface, strWareHouse, strWareHouse_T, strValues);
                                }
                                else
                                {
                                    TransLog.traceService(" Error : Either One of the Company Not Connected.");
                                }
                            }
                            else
                            {
                                TransLog.traceService(" Error : Either One of the Company Not Found.");
                            }
                        }
                        catch (Exception ex)
                        {
                            TransLog.traceService(" Error : " + ex.Message);
                        }
                    }
                }
                MessageBox.Show("Manual Sync Completed...");
                LoadAll();
            }
            catch (Exception ex)
            {
                TransLog.traceService("Error Message : " + ex.Message);
                TransLog.traceService(" Error Source : " + ex.Source);
                MessageBox.Show(ex.Message.ToString());
            }
        }
Ejemplo n.º 25
0
        private void btnSync_Click(object sender, EventArgs e)
        {
            try
            {
                string strInterface = System.Configuration.ConfigurationManager.AppSettings["InterDB"].ToString();
                string strMainDB    = System.Configuration.ConfigurationManager.AppSettings["MainDB"].ToString();
                oDtTransLog = Armada_Sync.Singleton.objSqlDataAccess.ExecuteReader(TRANSACTIONLOG, strInterface);
                if (oDtTransLog != null && oDtTransLog.Rows.Count > 0)
                {
                    foreach (DataRow dr in oDtTransLog.Rows)
                    {
                        try
                        {
                            Hashtable htCCDet   = new Hashtable();
                            string[]  strValues = new string[4];

                            sQuery  = " Select T1.U_COMPANY,T0.U_WAREHOUSE From  ";
                            sQuery += " [@Z_INBOUNDMAPPINGC] T0 JOIN [@Z_INBOUNDMAPPING] T1 On T0.Code = T1.Code ";
                            sQuery += " Where T0.U_SHOPID = '" + dr["ShopID"].ToString() + "'";
                            oCompDT = Armada_Sync.Singleton.objSqlDataAccess.ExecuteReader(sQuery, strMainDB);
                            if (oCompDT != null)
                            {
                                if (oCompDT.Rows.Count > 0)
                                {
                                    strCompany   = oCompDT.Rows[0]["U_COMPANY"].ToString();
                                    strWareHouse = oCompDT.Rows[0]["U_WAREHOUSE"].ToString();
                                    oGetCompany  = TransLog.GetCompany(strCompany);

                                    sQuery  = " Select T0.U_SCREDITCARD,T0.U_CREDITCARD,T0.U_CARDNUMBER,T0.U_CARDVALID,T0.U_PAYMENTMETHOD From  ";
                                    sQuery += " [@Z_INBOUNDMAPPINGC1] T0 JOIN [@Z_INBOUNDMAPPING] T1 On T0.Code = T1.Code ";
                                    sQuery += " Where T1.U_COMPANY = '" + strCompany + "'";
                                    oCCDT   = Armada_Sync.Singleton.objSqlDataAccess.ExecuteReader(sQuery, strMainDB);
                                    if (oCCDT != null)
                                    {
                                        if (oCCDT.Rows.Count > 0)
                                        {
                                            foreach (DataRow dr1 in oCCDT.Rows)
                                            {
                                                htCCDet.Add(dr1["U_SCREDITCARD"], dr1);
                                            }
                                        }
                                    }
                                }
                            }

                            TransLog.traceService(" Transaction Type : " + dr["Scenario"].ToString());
                            TransLog.traceService(" Transaction Key : " + dr["Key"].ToString());
                            if (oGetCompany != null)
                            {
                                TransLog.traceService("Company DB : " + oGetCompany.CompanyDB);
                                if (oGetCompany.Connected)
                                {
                                    Singleton.obj_S_OINV.Sync((dr["Key"].ToString()), TransType.A, oGetCompany, strInterface, strWareHouse, strValues, htCCDet);
                                }
                                else
                                {
                                    TransLog.traceService(" Error : Company Not Connected.");
                                }
                            }
                            else
                            {
                                TransLog.traceService(" Error : Company Not Found.");
                            }
                        }
                        catch (Exception ex)
                        {
                            TransLog.traceService(" Error : " + ex.Message);
                        }
                    }
                }
                MessageBox.Show("Manual Sync Completed...");
                LoadAll();
            }
            catch (Exception ex)
            {
                TransLog.traceService("Error Message : " + ex.Message);
                TransLog.traceService(" Error Source : " + ex.Source);
                MessageBox.Show(ex.Message.ToString());
            }
        }
Ejemplo n.º 26
0
        void m_oWorker_DoWork(object sender, DoWorkEventArgs e)
        {
            try
            {
                string strInterface = System.Configuration.ConfigurationManager.AppSettings["InterDB"].ToString();
                string strMainDB    = System.Configuration.ConfigurationManager.AppSettings["MainDB"].ToString();


                int intCount     = 0;
                int intCompleted = dgv_S_OWTR.RowCount;

                for (int i = 0; i < dgv_S_OWTR.RowCount; i++)
                {
                    intCount += 1;
                    if (intCount == (intCompleted / 10))
                    {
                        toolStripProgressBar1.PerformStep();
                        intCount = 0;
                    }

                    try
                    {
                        bool     blnSync   = false;
                        string[] strValues = new string[4];

                        sQuery  = " Select T1.U_COMPANY,T0.U_WAREHOUSE,T0.U_GIACCT From  ";
                        sQuery += " [@Z_INBOUNDMAPPINGC] T0 JOIN [@Z_INBOUNDMAPPING] T1 On T0.Code = T1.Code ";
                        sQuery += " Where T0.U_LOCATION = '" + dgv_S_OWTR.Rows[i].Cells["ShopID"].Value.ToString().Trim() + "'";
                        oCompDT = Armada_Sync.Singleton.objSqlDataAccess.ExecuteReader(sQuery, strMainDB);
                        if (oCompDT != null)
                        {
                            if (oCompDT.Rows.Count > 0)
                            {
                                strCompany   = oCompDT.Rows[0][0].ToString();
                                strWareHouse = oCompDT.Rows[0][1].ToString();
                                strValues[1] = oCompDT.Rows[0]["U_GIACCT"].ToString();
                                oGetCompany  = TransLog.GetCompany(strCompany);
                            }
                        }

                        sQuery  = " Select T1.U_COMPANY,T0.U_WAREHOUSE,T0.U_PRICELIST,T0.U_GRACCT From  ";
                        sQuery += " [@Z_INBOUNDMAPPINGC] T0 JOIN [@Z_INBOUNDMAPPING] T1 On T0.Code = T1.Code ";
                        sQuery += " Where T0.U_LOCATION = '" + dgv_S_OWTR.Rows[i].Cells["ToShop"].Value.ToString().Trim() + "'";
                        oCompDT = Armada_Sync.Singleton.objSqlDataAccess.ExecuteReader(sQuery, strMainDB);
                        if (oCompDT != null)
                        {
                            if (oCompDT.Rows.Count > 0)
                            {
                                strCompany_T   = oCompDT.Rows[0][0].ToString();
                                strWareHouse_T = oCompDT.Rows[0][1].ToString();
                                oGetCompany_T  = TransLog.GetCompany(strCompany_T);
                                strValues[0]   = oCompDT.Rows[0]["U_PRICELIST"].ToString();
                                strValues[2]   = oCompDT.Rows[0]["U_GRACCT"].ToString();
                            }
                        }

                        TransLog.traceService(" Transaction Type : " + dgv_S_OWTR.Rows[i].Cells["Scenario"].Value.ToString().Trim());
                        TransLog.traceService(" Transaction Key : " + dgv_S_OWTR.Rows[i].Cells["Source_Key"].Value.ToString().Trim());

                        if (oGetCompany != null && oGetCompany_T != null)
                        {
                            TransLog.traceService("Source Company DB : " + oGetCompany.CompanyDB);
                            TransLog.traceService("Destination Company DB : " + oGetCompany_T.CompanyDB);

                            if (oGetCompany.Connected && oGetCompany_T.Connected)
                            {
                                if (oGetCompany.CompanyDB != oGetCompany_T.CompanyDB)
                                {
                                    //Overriding the Good Issue Account if transaction happening from Main Company
                                    if (oGetCompany.CompanyDB == strMainDB)
                                    {
                                        sQuery  = " Select T0.U_GIACCT From  ";
                                        sQuery += " [@Z_INBOUNDMAPPINGC2] T0 JOIN [@Z_INBOUNDMAPPING] T1 On T0.Code = T1.Code ";
                                        sQuery += " Where T1.U_COMPANY = '" + strMainDB + "'";
                                        sQuery += " And T0.U_COMPANY = '" + oGetCompany_T.CompanyDB + "'";
                                        DataTable oCompDT1 = Armada_Sync.Singleton.objSqlDataAccess.ExecuteReader(sQuery, strMainDB);
                                        if (oCompDT1 != null)
                                        {
                                            if (oCompDT1.Rows.Count > 0)
                                            {
                                                strValues[1] = oCompDT1.Rows[0]["U_GIACCT"].ToString();
                                            }
                                        }
                                    }

                                    //Overriding the Good Recipt Account if transaction happening from Main Company
                                    if (oGetCompany_T.CompanyDB == strMainDB)
                                    {
                                        sQuery  = " Select T0.U_GRACCT From  ";
                                        sQuery += " [@Z_INBOUNDMAPPINGC2] T0 JOIN [@Z_INBOUNDMAPPING] T1 On T0.Code = T1.Code ";
                                        sQuery += " Where T1.U_COMPANY = '" + strMainDB + "'";
                                        sQuery += " And T0.U_COMPANY = '" + oGetCompany.CompanyDB + "'";
                                        DataTable oCompDT1 = Armada_Sync.Singleton.objSqlDataAccess.ExecuteReader(sQuery, strMainDB);
                                        if (oCompDT1 != null)
                                        {
                                            if (oCompDT1.Rows.Count > 0)
                                            {
                                                strValues[2] = oCompDT1.Rows[0]["U_GRACCT"].ToString();
                                            }
                                        }
                                    }
                                }


                                Singleton.obj_S_OWTR.Sync((dgv_S_OWTR.Rows[i].Cells["Source_Key"].Value.ToString().Trim()), TransType.A, oGetCompany, oGetCompany_T, strInterface, strWareHouse, strWareHouse_T, strValues);

                                string strQuery = "Select Status,Remarks From dbo.Z_OTXN Where Scenario = '" + dgv_S_OWTR.Rows[i].Cells["Scenario"].Value.ToString().Trim() + "' ";
                                strQuery += " And S_DocNo = '" + dgv_S_OWTR.Rows[i].Cells["Source_Key"].Value.ToString().Trim() + "' ";
                                DataTable oStatus = Armada_Sync.Singleton.objSqlDataAccess.ExecuteReader(strQuery, strInterface);
                                if (oStatus != null && oStatus.Rows.Count > 0)
                                {
                                    if (oStatus.Rows[0][0].ToString() == "1")
                                    {
                                        blnSync = true;
                                        dgv_S_OWTR.Rows[i].Cells["Remarks"].Value = string.Empty;
                                    }
                                    else
                                    {
                                        blnSync = false;
                                        dgv_S_OWTR.Rows[i].Cells["Remarks"].Value = oStatus.Rows[0][1].ToString();
                                    }
                                }
                                else
                                {
                                    blnSync = false;
                                }
                            }
                            else
                            {
                                TransLog.traceService(" Error : Company Not Connected.");
                            }
                        }
                        else
                        {
                            TransLog.traceService(" Error : Company Not Connected.");
                        }

                        if (blnSync)
                        {
                            Image image = Armada_App.Properties.Resources.Yes1;
                            dgv_S_OWTR.Rows[i].Cells["Image"].Value = image;
                        }
                        else
                        {
                            Image image = Armada_App.Properties.Resources.Error1;
                            dgv_S_OWTR.Rows[i].Cells["Image"].Value = image;
                        }
                    }
                    catch (Exception ex)
                    {
                        TransLog.traceService(ex.StackTrace.ToString());
                        TransLog.traceService(ex.Message.ToString());
                    }
                }
                m_oWorker.CancelAsync();
            }
            catch (Exception ex)
            {
                TransLog.traceService(ex.StackTrace.ToString());
                TransLog.traceService(ex.Message.ToString());
            }
            finally
            {
                toolStripProgressBar1.Value = 0;
            }
        }
Ejemplo n.º 27
0
        void m_oWorker_DoWork(object sender, DoWorkEventArgs e)
        {
            try
            {
                string strInterface = System.Configuration.ConfigurationManager.AppSettings["InterDB"].ToString();
                string strMainDB    = System.Configuration.ConfigurationManager.AppSettings["MainDB"].ToString();

                int intCount     = 0;
                int intCompleted = dgv_S_OINV.RowCount;

                for (int i = 0; i < dgv_S_OINV.RowCount; i++)
                {
                    intCount += 1;
                    if (intCount == (intCompleted / 10))
                    {
                        toolStripProgressBar1.PerformStep();
                        intCount = 0;
                    }

                    try
                    {
                        bool      blnSync   = false;
                        Hashtable htCCDet   = new Hashtable();
                        string[]  strValues = new string[4];

                        sQuery  = " Select T1.U_COMPANY,T0.U_WAREHOUSE,ISNULL(T0.U_COSTCEN,'') As U_COSTCEN From  ";
                        sQuery += " [@Z_INBOUNDMAPPINGC] T0 JOIN [@Z_INBOUNDMAPPING] T1 On T0.Code = T1.Code ";
                        sQuery += " Where T0.U_SHOPID = '" + dgv_S_OINV.Rows[i].Cells["ShopID"].Value.ToString().Trim() + "'";
                        oCompDT = Armada_Sync.Singleton.objSqlDataAccess.ExecuteReader(sQuery, strMainDB);
                        if (oCompDT != null)
                        {
                            if (oCompDT.Rows.Count > 0)
                            {
                                strCompany   = oCompDT.Rows[0]["U_COMPANY"].ToString();
                                strWareHouse = oCompDT.Rows[0]["U_WAREHOUSE"].ToString();
                                strValues[0] = oCompDT.Rows[0]["U_COSTCEN"].ToString();
                                oGetCompany  = TransLog.GetCompany(strCompany);

                                sQuery  = " Select T0.U_SCREDITCARD,T0.U_CREDITCARD,T0.U_CARDNUMBER,T0.U_CARDVALID,T0.U_PAYMENTMETHOD From  ";
                                sQuery += " [@Z_INBOUNDMAPPINGC1] T0 JOIN [@Z_INBOUNDMAPPING] T1 On T0.Code = T1.Code ";
                                sQuery += " Where T1.U_COMPANY = '" + strCompany + "'";
                                oCCDT   = Armada_Sync.Singleton.objSqlDataAccess.ExecuteReader(sQuery, strMainDB);
                                if (oCCDT != null)
                                {
                                    if (oCCDT.Rows.Count > 0)
                                    {
                                        foreach (DataRow dr1 in oCCDT.Rows)
                                        {
                                            htCCDet.Add(dr1["U_SCREDITCARD"], dr1);
                                        }
                                    }
                                }
                            }
                        }

                        TransLog.traceService(" Transaction Type : " + dgv_S_OINV.Rows[i].Cells["Scenario"].Value.ToString().Trim());
                        TransLog.traceService(" Transaction Key : " + dgv_S_OINV.Rows[i].Cells["Source_Key"].Value.ToString().Trim());
                        if (oGetCompany != null)
                        {
                            TransLog.traceService("Company DB : " + oGetCompany.CompanyDB);
                            if (oGetCompany.Connected)
                            {
                                Singleton.obj_S_OINV.Sync((dgv_S_OINV.Rows[i].Cells["Source_Key"].Value.ToString().Trim()), TransType.A, oGetCompany, strInterface, strWareHouse, strValues, htCCDet);

                                string strQuery = "Select Status,Remarks From dbo.Z_OTXN Where Scenario = '" + dgv_S_OINV.Rows[i].Cells["Scenario"].Value.ToString().Trim() + "' ";
                                strQuery += " And S_DocNo = '" + dgv_S_OINV.Rows[i].Cells["Source_Key"].Value.ToString().Trim() + "' ";
                                DataTable oStatus = Armada_Sync.Singleton.objSqlDataAccess.ExecuteReader(strQuery, strInterface);
                                if (oStatus != null && oStatus.Rows.Count > 0)
                                {
                                    if (oStatus.Rows[0][0].ToString() == "1")
                                    {
                                        blnSync = true;
                                        dgv_S_OINV.Rows[i].Cells["Remarks"].Value = string.Empty;
                                    }
                                    else
                                    {
                                        blnSync = false;
                                        dgv_S_OINV.Rows[i].Cells["Remarks"].Value = oStatus.Rows[0][1].ToString();
                                    }
                                }
                                else
                                {
                                    blnSync = false;
                                }
                            }
                            else
                            {
                                TransLog.traceService(" Error : Company Not Connected.");
                            }
                        }
                        else
                        {
                            TransLog.traceService(" Error : Company Not Found.");
                        }

                        if (blnSync)
                        {
                            Image image = Armada_App.Properties.Resources.Yes1;
                            dgv_S_OINV.Rows[i].Cells["Image"].Value = image;
                        }
                        else
                        {
                            Image image = Armada_App.Properties.Resources.Error1;
                            dgv_S_OINV.Rows[i].Cells["Image"].Value = image;
                        }
                    }
                    catch (Exception ex)
                    {
                        TransLog.traceService(ex.StackTrace.ToString());
                        TransLog.traceService(ex.Message.ToString());
                    }
                }
                m_oWorker.CancelAsync();
            }
            catch (Exception ex)
            {
                TransLog.traceService(ex.StackTrace.ToString());
                TransLog.traceService(ex.Message.ToString());
            }
            finally
            {
                toolStripProgressBar1.Value = 0;
            }
        }