Пример #1
0
        private void FillTruck()
        {
            try
            {
                DataTable dtTrucks = JTruck.GetDataTable(0);
                //lsTrucks.DataSource = dtTrucks;
                //lsTrucks.DisplayMember = "FullName";
                //lsTrucks.ValueMember = "Code";
                _Shortcut = new string[dtTrucks.Rows.Count, 2];
                for (int i = 0; i < dtTrucks.Rows.Count; i++)
                {
                    _Shortcut[i, 0] = dtTrucks.Rows[i]["Code"].ToString();
                    _Shortcut[i, 1] = dtTrucks.Rows[i]["Shortcut"].ToString();
                }

                dtTrucks.Rows.Add(-1, " ", 0, DateTime.Now, DateTime.Now, "", " ");
                cmbTruck.DataSource    = dtTrucks;
                cmbTruck.DisplayMember = "FullName";
                cmbTruck.ValueMember   = "Code";
                //JProductss JCCs = new JProductss();
                //JCCs.SetComboBox(cmbProduct, 1);

                DataTable dtProduct = JProductss.GetDataTable();
                dtProduct.Rows.Add(-1, 901, "");
                dtProduct.Select("", "Code");
                cmbProduct.DataSource    = dtProduct;
                cmbProduct.DisplayMember = "Name";
                cmbProduct.ValueMember   = "Code";
            }
            catch (Exception ex)

            {
                JSystem.Except.AddException(ex);
            }
        }
Пример #2
0
        private void FillList()
        {
            DataTable tmpdt = JTruck.GetDataTable(0);

            JKeyValue[] M     = new JKeyValue[tmpdt.Rows.Count];
            int         count = 0;

            foreach (DataRow dr in tmpdt.Rows)
            {
                M[count]       = new JKeyValue();
                M[count].Key   = dr["Name"].ToString();
                M[count].Value = dr["Code"];
                count++;
            }
            chklistTrucks.Items.AddRange(M);

            tmpdt = JReport.GetBascols(0);
            JKeyValue[] B = new JKeyValue[tmpdt.Rows.Count];
            count = 0;
            foreach (DataRow dr in tmpdt.Rows)
            {
                B[count]       = new JKeyValue();
                B[count].Key   = dr["Code"].ToString();
                B[count].Value = dr["Code"];
                count++;
            }
            chkListBascol.Items.AddRange(B);

            tmpdt = JReport.GetUsersBascols(0);
            JKeyValue[] U = new JKeyValue[tmpdt.Rows.Count];
            count = 0;
            foreach (DataRow dr in tmpdt.Rows)
            {
                U[count]       = new JKeyValue();
                U[count].Key   = dr["Name"].ToString();
                U[count].Value = dr["Code"];
                count++;
            }
            chklistUsers.Items.AddRange(U);
            listUsers.Items.AddRange(U);

            tmpdt = JProductss.GetDataTable();
            JKeyValue[] T = new JKeyValue[tmpdt.Rows.Count];
            count = 0;
            foreach (DataRow dr in tmpdt.Rows)
            {
                T[count]       = new JKeyValue();
                T[count].Key   = dr["Name"].ToString();
                T[count].Value = dr["Code"];
                count++;
            }
            chklistTozin.Items.AddRange(T);
        }
Пример #3
0
        public bool Transfer()
        {
            if (!(CreateConnectionServer()))
            {
                JMessages.Error(" ارتباط با بانک اصلی برقرار نمی شود ", "");
                return(false);
            }

            if (!(ClassLibrary.JPing.Ping("192.168.3.1")))
            {
                JMessages.Error(" ارتباط با بانک اصلی برقرار نمی شود ", "");
                return(false);
            }

            ClassLibrary.JDataBase MyDB      = new JDataBase(_Config);
            ClassLibrary.JDataBase CurrentDB = new JDataBase();
            try
            {
                if (CurrentDB.DataBaseName == MyDB.DataBaseName)//"ERP_Sepad")
                {
                    JMessages.Error(" بانک جاری با بانک اصلی یکی است امکان انتقال اطلاعات نیست ", "");
                    return(false);
                }

                string StrPlok = "";
                //int Count = 0;
                //ماشین ها پلاک
                CurrentDB.setQuery(@"select distinct PlokNo,TruckCode from BascolWeights ");
                foreach (DataRow dr4 in CurrentDB.Query_DataTable().Rows) //+ @"' And TruckCode = " + dr4["TruckCode"]
                {
                    StrPlok = @"
declare  @Count int
select @Count=(Select COUNT(*) From BascolPlakTruck  where plokno = N'" + dr4["PlokNo"].ToString().Trim() + @"')
select @Count
if (@Count = 0)
INSERT INTO BascolPlakTruck Values('" + dr4["PlokNo"].ToString().Trim() + "'," + dr4["TruckCode"] + @")";
                    //Count++;
                    //if (Count == 10)
                    //{
                    //    //MyDB.CommandTimeout = 5;
                    //    MyDB.setQuery(StrPlok);
                    //    MyDB.Query_Execute();
                    //    StrPlok = "";
                    //    Count = 0;
                    //}
                    MyDB.CommandTimeout = 2;
                    MyDB.setQuery(StrPlok);
                    MyDB.Query_Execute();
                }


                MyDB.beginTransaction("MainDB");
                CurrentDB.beginTransaction("CurrentDB");

                DataTable _DtAccess = JWeights.GetData();
                JWeight   tmpWeight = new JWeight();
                foreach (DataRow dr in _DtAccess.Rows)
                {
                    tmpWeight.TruckCode    = Convert.ToInt32(dr["TruckCode"]);
                    tmpWeight.UserPostCode = Convert.ToInt32(dr["UserPostCode"]);
                    tmpWeight.PersonCode   = Convert.ToInt32(dr["PersonCode"]);
                    tmpWeight.pay          = Convert.ToInt32(dr["Pay"]);
                    tmpWeight.pay_h        = Convert.ToInt32(dr["pay_h"]);
                    tmpWeight.BascoolCode  = Convert.ToInt32(dr["BascoolCode"]);
                    tmpWeight.WDate        = Convert.ToDateTime(dr["WDate"]);
                    tmpWeight.WTime        = dr["WTime"].ToString();
                    tmpWeight.PlokNo       = dr["PlokNo"].ToString();
                    tmpWeight.Weights      = Convert.ToInt32(dr["Weights"]);
                    tmpWeight.Duty         = Convert.ToDecimal(dr["Duty"]); //(tmpWeight.pay / (100 + _Duty + _Tax)) * _Tax;
                    tmpWeight.Tax          = Convert.ToDecimal(dr["Tax"]);  //(tmpWeight.pay / (100 + _Duty + _Tax)) * _Duty;
                    tmpWeight.hamrahno     = Convert.ToInt32(dr["hamrahNo"]);
                    tmpWeight.ProductCode  = Convert.ToInt32(dr["ProductCode"]);
                    tmpWeight.BascoolID    = Convert.ToInt32(dr["BascoolID"]);
                    tmpWeight.FullW        = Convert.ToInt32(dr["FullW"]);
                    tmpWeight.PrintNo      = Convert.ToInt32(dr["PrintNo"]);
                    //tmpWeight.dele = Convert.ToBoolean(dr["dele"]);
                    //tmpWeight.verify = Convert.ToBoolean(dr["verify"]);

                    if (tmpWeight.Insert(MyDB) > 0)
                    {
                        if (!(tmpWeight.DeleteTransfer(Convert.ToInt32(dr["Code"]), CurrentDB)))
                        {
                            MyDB.Rollback("MainDB");
                            CurrentDB.Rollback("CurrentDB");
                            JMessages.Error(" خطا در همگام سازی ", "");
                            return(false);
                        }
                    }
                    else
                    {
                        MyDB.Rollback("MainDB");
                        CurrentDB.Rollback("CurrentDB");
                        JMessages.Error(" خطا در همگام سازی ", "");
                        return(false);
                    }
                }


                _DtAccess = JEmptyWeight.GetDataTable(-1);
                JEmptyWeight tmpEmptyWeight = new JEmptyWeight();
                foreach (DataRow dr in _DtAccess.Rows)
                {
                    tmpEmptyWeight.Code           = 0;
                    tmpEmptyWeight.BascoolNo      = Convert.ToInt32(dr["BascoolNo"]);
                    tmpEmptyWeight.WeightID       = Convert.ToInt32(dr["WeightID"]);
                    tmpEmptyWeight.EmptyBascoolNo = Convert.ToInt32(dr["EmptyBascoolNo"]);
                    tmpEmptyWeight.WeightSerial   = Convert.ToInt32(dr["WeightSerial"]);
                    tmpEmptyWeight.DateWeight     = Convert.ToDateTime(dr["DateWeight"]);
                    tmpEmptyWeight.EmptyWeight    = Convert.ToInt32(dr["EmptyWeight"]);
                    tmpEmptyWeight.EmptyID        = Convert.ToInt32(dr["EmptyID"]);
                    if (tmpEmptyWeight.Insert(MyDB) > 0)
                    {
                        tmpEmptyWeight.Code = Convert.ToInt32(dr["Code"]);
                        if (!(tmpEmptyWeight.Delete(CurrentDB)))
                        {
                            MyDB.Rollback("MainDB");
                            CurrentDB.Rollback("CurrentDB");
                            JMessages.Error(" خطا در همگام سازی ", "");
                            return(false);
                        }
                    }
                    else
                    {
                        MyDB.Rollback("MainDB");
                        CurrentDB.Rollback("CurrentDB");
                        JMessages.Error(" خطا در همگام سازی ", "");
                        return(false);
                    }
                }

                if (MyDB.Commit())
                {
                    if (CurrentDB.Commit())
                    {
                    }
                    else
                    {
                        MyDB.Rollback("MainDB");
                        CurrentDB.Rollback("CurrentDB");
                        JMessages.Error(" خطا در همگام سازی ", "");
                        return(false);
                    }
                }
                else
                {
                    MyDB.Rollback("MainDB");
                    CurrentDB.Rollback("CurrentDB");
                    JMessages.Error(" خطا در همگام سازی ", "");
                    return(false);
                }

                //  باسکول
                CurrentDB.setQuery(@" delete From Bascols ");
                CurrentDB.Query_Execute();
                //if (CurrentDB.Query_Execute() > 0)
                {
                    foreach (DataRow dr1 in JReport.GetBascols(0, MyDB).Rows)
                    {
                        //MyDB.setQuery(@" Insert Into Bascols Values(" + dr1["Code"] + ",'" + dr1["Location"] + "'," + dr1["Capacity"] + ",'" + dr1["BDesc"] + "'," + dr1["Active"]+ ")");
                        CurrentDB.setQuery(@" Insert Into Bascols Values(" + dr1["Code"] + ",NULL," + dr1["Capacity"] + ",'" + dr1["BDesc"] + "',NULL)");
                        if (CurrentDB.Query_Execute() <= 0)
                        {
                            return(false);
                        }
                    }
                }

                //  محصول
                CurrentDB.setQuery(@" delete From Subdefine Where bCode=901");
                CurrentDB.Query_Execute();
                //if (CurrentDB.Query_Execute() > 0)
                {
                    foreach (DataRow dr3 in JProductss.GetDataTable(MyDB).Rows)
                    {
                        CurrentDB.setQuery(@" Insert Into Subdefine Values(" + dr3["Code"] + ",901,'" + dr3["Name"] + "',0,NULL)");
                        if (CurrentDB.Query_Execute() <= 0)
                        {
                            return(false);
                        }
                    }
                }

                //  ماشینها
                CurrentDB.setQuery(@" delete From BascolTruck ");
                CurrentDB.Query_Execute();
                //if (CurrentDB.Query_Execute() > 0)
                {
                    foreach (DataRow dr2 in JTruck.GetDataTransfer(MyDB).Rows)
                    {
                        CurrentDB.setQuery(@"INSERT INTO BascolTruck Values(" + dr2["Code"] + ",'" + dr2["Name"] + "'," + dr2["Price"] + ",'" + Convert.ToDateTime(dr2["StartDate"]).ToShortDateString() + "' ,'" + Convert.ToDateTime(dr2["EndDate"]).ToShortDateString() + "','" + dr2["Shortcut"].ToString().Trim() + "')");
                        if (CurrentDB.Query_Execute() <= 0)
                        {
                            return(false);
                        }
                    }
                }

                //ماشین ها پلاک
                CurrentDB.setQuery(@" Select Max(Code) From BascolPlakTruck ");
                int MaxCode = Convert.ToInt32(CurrentDB.Query_ExecutSacler());
                //if (CurrentDB.Query_Execute() > 0)
                //{
                MyDB.setQuery(@"select Code,PlokNo,TruckCode from BascolPlakTruck Where Code > " + MaxCode);
                foreach (DataRow dr4 in MyDB.Query_DataTable().Rows)
                {
                    CurrentDB.setQuery("INSERT INTO BascolPlakTruck Values( " + dr4["Code"] + ",'" + dr4["PlokNo"] + "'," + dr4["TruckCode"] + ")");
                    if (CurrentDB.Query_Execute() <= 0)
                    {
                        return(false);
                    }
                }
                CurrentDB.setQuery(@"delete from BascolPlakTruck Where Code in
(select B.Code from BascolPlakTruck A inner join BascolPlakTruck B on A.PlokNo=B.PlokNo And A.Code > B.Code)");
                CurrentDB.Query_Execute();
                //return false;
                //}

                //  لیست سیاه
                //CurrentDB.setQuery(@" delete From BascoolBlackList ");
                //if (CurrentDB.Query_Execute() > 0)
                //{
                //    MyDB.setQuery("select * from BascoolBlackList ");
                //    foreach (DataRow dr5 in MyDB.Query_DataTable().Rows)
                //    {
                //        CurrentDB.setQuery(@" Insert Into BascoolBlackList Values(" + dr5["Code"] + ")");
                //        if (CurrentDB.Query_Execute() <= 0)
                //            return false;
                //    }
                //}

                //
                //CurrentDB.setQuery(@" delete From BascolTaxFormula ");
                //if (CurrentDB.Query_Execute() > 0)
                //{
                //    MyDB.setQuery(@"Select top 1 Duty From BascolTaxFormula ");
                //    _Duty = Convert.ToDecimal(MyDB.Query_ExecutSacler());
                //    MyDB.setQuery(@"Select top 1 Tax From BascolTaxFormula ");
                //    _Tax = Convert.ToDecimal(MyDB.Query_ExecutSacler());
                //    CurrentDB.setQuery(@"INSERT INTO BascolTaxFormula values(" + _Duty + "," + _Tax + ")");
                //    if (CurrentDB.Query_Execute() <= 0)
                //        return false;
                //}
                return(true);
            }
            catch (Exception ex)
            {
                JSystem.Except.AddException(ex);
                MyDB.Rollback("MainDB");
                CurrentDB.Rollback("CurrentDB");
                return(false);
            }
            finally
            {
                MyDB.Dispose();
                CurrentDB.Dispose();
            }
        }
Пример #4
0
        public bool TransferAccess()
        {
            try
            {
                if (CreateConnectionServer())
                {
                    JMessages.Error(" ارتباط با بانک اصلی برقرار نمی شود ", "");
                    return(false);
                }
                ClassLibrary.JDataBase MyDB = new JDataBase(_Config);
                //ClassLibrary.JOLeDbDataBase MyDB = new ClassLibrary.JOLeDbDataBase();
                JWeights tmpWeights = new JWeights();
                //MyDB.setQuery(@"Select * From Weight");
                DataTable _DtAccess = tmpWeights.GetDataTable();
                DataTable _DtSQL;
                foreach (DataRow dr in _DtAccess.Rows)
                {
                    JWeight tmpWeight = new JWeight();
                    tmpWeight.TruckCode    = Convert.ToInt32(dr["TruckNo"]);
                    tmpWeight.UserPostCode = Convert.ToInt32(dr["UserPostCode"]);
                    tmpWeight.PersonCode   = Convert.ToInt32(dr["UserNo"]);
                    tmpWeight.pay          = Convert.ToInt32(dr["Pay"]);
                    tmpWeight.pay_h        = Convert.ToInt32(dr["pay_h"]);
                    tmpWeight.BascoolCode  = Convert.ToInt32(dr["BascoolCode"]);
                    tmpWeight.WDate        = Convert.ToDateTime(dr["WDate"]);
                    tmpWeight.WTime        = dr["WTime"].ToString();
                    tmpWeight.PlokNo       = dr["PlokNo"].ToString();
                    tmpWeight.Weights      = Convert.ToInt32(dr["Weights"]);
                    tmpWeight.Duty         = Convert.ToDecimal(dr["Duty"]); //(tmpWeight.pay / (100 + _Duty + _Tax)) * _Tax;
                    tmpWeight.Tax          = Convert.ToDecimal(dr["Tax"]);  //(tmpWeight.pay / (100 + _Duty + _Tax)) * _Duty;
                    tmpWeight.hamrahno     = Convert.ToInt32(dr["hamrahNo"]);
                    tmpWeight.ProductCode  = Convert.ToInt32(dr["ProductNo"]);

                    if (tmpWeight.Insert(MyDB) > 0)
                    {
                        tmpWeight.Delete(tmpWeight.Code);
                        MyDB.setQuery(@"Delete From Weight Where id = " + dr["Code"]);
                        if (MyDB.Query_Execute() <= 0)
                        {
                            JMessages.Error(" خطا در همگام سازی ", "");
                            return(false);
                        }
                    }
                }

                MyDB.setQuery(@"SELECT ID, WeightSerial, BascoolNo, DateWeight, EmptyWeight, WeightID  FROM EmptyTruck");
                _DtAccess = MyDB.Query_DataTable();
                foreach (DataRow dr in _DtAccess.Rows)
                {
                    JEmptyWeight tmpEmptyWeight = new JEmptyWeight();
                    tmpEmptyWeight.BascoolNo      = Convert.ToInt32(dr["BascoolNo"]);
                    tmpEmptyWeight.WeightID       = Convert.ToInt32(dr["WeightID"]);
                    tmpEmptyWeight.EmptyBascoolNo = Convert.ToInt32(dr["EmptyBascoolNo"]);
                    tmpEmptyWeight.WeightSerial   = Convert.ToInt32(dr["WeightSerial"]);
                    tmpEmptyWeight.DateWeight     = Convert.ToDateTime(dr["DateWeight"]);
                    tmpEmptyWeight.EmptyWeight    = Convert.ToInt32(dr["EmptyWeight"]);
                    tmpEmptyWeight.EmptyID        = Convert.ToInt32(dr["EmptyID"]);

                    if (tmpEmptyWeight.Insert() > 0)
                    {
                        MyDB.setQuery(@"Delete From Weight Where id = " + dr["Code"]);
                        if (MyDB.Query_Execute() <= 0)
                        {
                            JMessages.Error(" خطا در همگام سازی ", "");
                            return(false);
                        }
                    }
                }
                //  باسکول
                MyDB.setQuery(@" delete From Bascools ");
                if (MyDB.Query_Execute() > 0)
                {
                    foreach (DataRow dr1 in JReport.GetBascols(0).Rows)
                    {
                        MyDB.setQuery(@" Insert Into Bascools (" + dr1["Code"] + ",'" + dr1["Location"] + "'," + dr1["Capacity"] + ",'" + dr1["BDesc"] + "'," + dr1["Active"]);
                        if (MyDB.Query_Execute() <= 0)
                        {
                            return(false);
                        }
                    }
                }

                //  محصول
                MyDB.setQuery(@" delete From Product ");
                if (MyDB.Query_Execute() > 0)
                {
                    foreach (DataRow dr3 in JProductss.GetDataTable().Rows)
                    {
                        MyDB.setQuery(@" Insert Into Product (" + dr3["Code"] + ",'" + dr3["Name"] + "'");
                        if (MyDB.Query_Execute() <= 0)
                        {
                            return(false);
                        }
                    }
                }

                //  ماشینها
                MyDB.setQuery(@" delete From Truck ");
                if (MyDB.Query_Execute() > 0)
                {
                    foreach (DataRow dr2 in JTruck.GetDataTable(0).Rows)
                    {
                        MyDB.setQuery(@"INSERT INTO Truck(TruckId,Name,wp)values(" + dr2["Code"] + ",'" + dr2["Name"] + "'," + dr2["Price"] + ")");
                        if (MyDB.Query_Execute() <= 0)
                        {
                            return(false);
                        }
                    }
                }

                //
                MyDB.setQuery(@" delete From TaxFormula ");
                if (MyDB.Query_Execute() > 0)
                {
                    //GetTaxDuty();
                    //MyDB.setQuery(@"INSERT INTO (Duty, Tax) values(" + _Duty + "," + _Tax + ")");
                    if (MyDB.Query_Execute() <= 0)
                    {
                        return(false);
                    }
                }
                return(true);
            }
            catch (Exception ex)
            {
                JSystem.Except.AddException(ex);
                return(false);
            }
        }