Ejemplo n.º 1
0
 private void btnReturnConfirm_Click(object sender, EventArgs e)
 {
     if (jJanusGrid1.SelectedRow == null)
     {
         return;
     }
     _Code = Convert.ToInt32(jJanusGrid1.SelectedRow.Row["Code"]);
     if (_Code == 0)
     {
         JMessages.Information(" از لیست رکوردی را انتخاب کنید ", "");
         return;
     }
     if (JMessages.Question(" آیا می خواهید تایید برگشت شود ؟ ", "") == DialogResult.Yes)
     {
         JWeight tmpWeight = new JWeight();
         foreach (DataRow dr in jJanusGrid1.DefaultView.Rows)
         {
             tmpWeight.GetData(Convert.ToInt32(dr["Code"]));
             tmpWeight.verify = false;
             if (!(tmpWeight.Update()))
             {
                 JMessages.Error(" ویرایش با خطا مواجه شد ", "");
                 return;
             }
         }
         JMessages.Information(" ویرایش با موفقیت انجام شد ", "");
         btnSearch_Click(null, null);
     }
 }
Ejemplo n.º 2
0
        private void btnReg_Click(object sender, EventArgs e)
        {
            JWeight tmp = new JWeight();

            tmp.AddBlackList(txtSerial.IntValue);
            Fill();
        }
Ejemplo n.º 3
0
 private void btnback_del_Click(object sender, EventArgs e)
 {
     if (jJanusGrid1.SelectedRow == null)
     {
         return;
     }
     _Code = Convert.ToInt32(jJanusGrid1.SelectedRow.Row["Code"]);
     if (_Code == 0)
     {
         JMessages.Information(" از لیست رکوردی را انتخاب کنید ", "");
         return;
     }
     if (JMessages.Question(" آیا می خواهید عملیات حذف برگشت شود ؟ ", "") == DialogResult.Yes)
     {
         JWeight tmpWeight = new JWeight(_Code);
         tmpWeight.dele = false;
         if (tmpWeight.Update())
         {
             JMessages.Information(" ویرایش با موفقیت انجام شد ", "");
             btnSearch_Click(null, null);
         }
         else
         {
             JMessages.Error(" ویرایش با خطا مواجه شد ", "");
         }
     }
 }
Ejemplo n.º 4
0
        private void btnPrint2_Click(object sender, EventArgs e)
        {
            if (jJanusGrid1.SelectedRow == null)
            {
                return;
            }
            JWeight tmpWeight = new JWeight(Convert.ToInt32(jJanusGrid1.SelectedRow.Row["Code"]));

            tmpWeight.PrintNo = tmpWeight.PrintNo + 1;
            tmpWeight.Update();
        }
Ejemplo n.º 5
0
        private void btnDel_Click(object sender, EventArgs e)
        {
            if (jJanusGrid1.SelectedRow == null)
            {
                JMessages.Error(" لطفا سطری را انتخاب کنید ", "");
                return;
            }
            JWeight tmp = new JWeight();

            tmp.DelBlackList(Convert.ToInt32(jJanusGrid1.SelectedRow.Row["BascoolID"].ToString()));
            Fill();
        }
Ejemplo n.º 6
0
        private void Bedehi()
        {
            if ((txtPlak1.Text != "") && (cmbPlak.Text != "") && (txtPlak2.Text != "") && (txtPlak3.Text != "") &&
                (txtPlak1.Text.Length == 2) && (txtPlak2.Text.Length == 3) && (txtPlak3.Text.Length == 2))
            {
                string str = txtPlak1.Text + cmbPlak.Text + txtPlak2.Text + "-" + txtPlak3.Text;
                lblBedehkari.Text     = JWeight.GetBedehi(str, Convert.ToInt32(cmbTruck.SelectedValue.ToString())).ToString();
                lblBedehkariName.Text = "";
                lblB.Text             = "";
                if (Convert.ToInt32(lblBedehkari.Text) > 0)
                {
                    lblB.Text = lblB.Text + " بدهکار به آقای";
                }
                else if (Convert.ToInt32(lblBedehkari.Text) < 0)
                {
                    lblB.Text = lblB.Text + "طلبکار از آقای ";
                }
                if (lblBedehkari.Text != "0")
                {
                    txtPay.Text           = (Convert.ToInt32(_Price) + Convert.ToInt32(lblBedehkari.Text)).ToString();
                    lblBedehkariName.Text = JWeight.GetBedehiName(str);
                    lblBedehkariName.Text = lblB.Text + lblBedehkariName.Text + " می باشد ";
                    if (lblBedehkariName.Text != "")
                    {
                        if (Convert.ToInt32(lblBedehkari.Text) < 0)
                        {
                            JMessages.Information(" این ماشین  " + lblBedehkariName.Text + " ", "طلبکاری");
                        }
                        else
                        {
                            JMessages.Information(" این ماشین  " + lblBedehkariName.Text + " ", "بدهکاری");
                        }
                    }
                }
                if (Convert.ToInt32(lblBedehkari.Text) < 0)
                {
                    Talab             = -1;
                    lblBedehkari.Text = (Convert.ToInt32(lblBedehkari.Text)).ToString(); //* Talab
                }
                else
                {
                    Talab = 1;
                }

                //if (ClassLibrary.JPing.Ping("192.168.3.38"))
                //{
                //    if (JReport.GetBlackList(str).Rows.Count > 0)
                //        JMessages.Error(" این ماشین در لیست سیاه است ", "");
                //}
            }
        }
Ejemplo n.º 7
0
 private void SetForm()
 {
     try
     {
         JWeight tmpWeight = new JWeight(_Code);
         //lsTrucks.SelectedValue = tmpWeight.TruckCode;
         _Price      = Convert.ToInt32(tmpWeight.pay.ToString());
         txtPay.Text = tmpWeight.pay_h.ToString();
         //tmpWeight.BascoolCode = tssBascol.Text;
         //txtDate.Text = tmpWeight.WDate.ToString();
         lblDate.Text = tmpWeight.WDate.ToString();
         //txtTime.Text = tmpWeight.WTime;
         lblTime.Text   = tmpWeight.WTime;
         txtPlak1.Text  = tmpWeight.PlokNo.Substring(0, 3);
         txtPlak2.Text  = tmpWeight.PlokNo.Substring(0, 3);
         cmbPlak.Text   = tmpWeight.PlokNo.Substring(3, 1);
         lblWeight.Text = tmpWeight.Weights.ToString();
     }
     catch (Exception ex)
     {
         JSystem.Except.AddException(ex);
     }
 }
Ejemplo n.º 8
0
        private void btnClear_Click(object sender, EventArgs e)
        {
            JWeight   tmpWeight = new JWeight();
            DataTable tmpdt;

            try
            {
                tmpdt = JWeights.GetLastDataTable();
                if ((tmpdt != null) && (tmpdt.Rows.Count > 0))
                {
                    tmpWeight.GetData(Convert.ToInt32(tmpdt.Rows[0]["Code"]));
                    if (tmpWeight.verify == true)
                    {
                        JMessages.Error(" این تورین تایید مالی شده و قابل تغییر نمی باشد ", "");
                        return;
                    }
                    tmpWeight.pay_h = Convert.ToInt32(txtPay.Text);
                    if (tmpWeight.Update())
                    {
                        JMessages.Information(" ویرایش با موفقیت انجام شد ", "");
                    }
                    else
                    {
                        JMessages.Error(" خطا در ویرایش ", "");
                    }
                }
                else
                {
                    JMessages.Error(" رکوردی با این کاربری پیدا نشد ", "");
                }
            }
            catch (Exception ex)
            {
                JSystem.Except.AddException(ex);
            }
        }
Ejemplo n.º 9
0
 private void GetPlak()
 {
     if ((txtPlak1.Text != "") && (cmbPlak.Text != "") && (txtPlak2.Text != "") && (txtPlak3.Text != "") &&
         (txtPlak1.Text.Length == 2) && (txtPlak2.Text.Length == 3) && (txtPlak3.Text.Length == 2))
     {
         string str     = txtPlak1.Text + cmbPlak.Text + txtPlak2.Text + "-" + txtPlak3.Text;
         int    TruckNo = JWeight.GetPlak(str);
         if (TruckNo.ToString() != "0")
         {
             //this.label4.ForeColor = System.Drawing.Color.Black;
             //this.cmbTruck.ForeColor = System.Drawing.Color.Black;
             cmbTruck.SelectedValue = TruckNo;
         }
         else
         {
             cmbTruck.SelectedValue = -1;
             //this.label4.ForeColor = System.Drawing.Color.Red;
             //this.cmbTruck.ForeColor = System.Drawing.Color.Red;
         }
         //lsTrucks.SelectedValue = TruckNo;
         //else
         //    cmbPlak.ForeColor = System.Drawing.Color.Red;
     }
 }
Ejemplo n.º 10
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();
            }
        }
Ejemplo n.º 11
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);
            }
        }
Ejemplo n.º 12
0
        //dele,verify,pay,Duty,Tax,
        private void btnPrint2_Click(object sender, EventArgs e)
        {
            if (jJanusGrid1.DataSource == null)
            {
                JMessages.Error(" ابتدا دکمه جستجو را بزنید ", "");
                return;
            }
            if (jJanusGrid1.SelectedRow == null)
            {
                JMessages.Error(" لطفا سطری را انتخاب کنید ", "");
                return;
            }
            _Code = Convert.ToInt32(jJanusGrid1.SelectedRow.Row["Code"].ToString());
            DataTable dt    = JWeights.GetDataTableAll(_Code, true);
            string    State = "این برگه المثنی" + " قبض شماره " + dt.Rows[0]["BascoolID"].ToString() + " مورخ " + dt.Rows[0]["WDate"].ToString() + "ساعت" + dt.Rows[0]["WTime"].ToString().Trim() + "می باشد";

            JWeight tmpWeight = new JWeight();

            tmpWeight.TruckCode    = Convert.ToInt32(dt.Rows[0]["TruckCode"].ToString());
            tmpWeight.UserPostCode = JMainFrame.CurrentPostCode;
            tmpWeight.PersonCode   = JMainFrame.CurrentPersonCode;
            tmpWeight.pay          = Convert.ToInt32(dt.Rows[0]["pay"].ToString());
            tmpWeight.pay_h        = Convert.ToInt32(dt.Rows[0]["pay"].ToString());
            tmpWeight.BascoolCode  = Convert.ToInt32(dt.Rows[0]["BascoolCode"].ToString());
            tmpWeight.PlokNo       = dt.Rows[0]["P1"].ToString() + dt.Rows[0]["P2"].ToString() + dt.Rows[0]["P3"].ToString() + dt.Rows[0]["P4"].ToString();
            tmpWeight.Weights      = Convert.ToInt32(dt.Rows[0]["Weights"].ToString());
            //tmpWeight.Duty = Convert.ToDecimal(dt.Rows[0]["Duty"].ToString());
            //tmpWeight.Tax = Convert.ToDecimal(dt.Rows[0]["Tax"].ToString());
            JTransferData tmpT = new JTransferData();

            tmpT.GetTaxDuty();
            tmpWeight.Duty = (tmpWeight.pay / (100 + tmpT._Duty + tmpT._Tax)) * tmpT._Duty;
            tmpWeight.Tax  = (tmpWeight.pay / (100 + tmpT._Duty + tmpT._Tax)) * tmpT._Tax;

            tmpWeight.hamrahno    = Convert.ToInt32(dt.Rows[0]["hamrahno"].ToString());
            tmpWeight.ProductCode = Convert.ToInt32(dt.Rows[0]["ProductCode"].ToString());
            tmpWeight.PrintNo     = 2;
            string Min = "";

            if (DateTime.Now.Minute.ToString().Length == 1)
            {
                Min = "0" + DateTime.Now.Minute.ToString();
            }
            else
            {
                Min = DateTime.Now.Minute.ToString();
            }
            string Hour = "";

            if (DateTime.Now.Hour.ToString().Length == 1)
            {
                Hour = "0" + DateTime.Now.Hour.ToString();
            }
            else
            {
                Hour = DateTime.Now.Hour.ToString();
            }
            tmpWeight.WTime = Hour + ":" + Min;

            tmpWeight.BascoolID = JWeights.GetCounter();
            tmpWeight.WDate     = DateTime.Now;

            JTransferData tmpJTransferData = new JTransferData();
            JDataBase     dbMain           = tmpJTransferData.CreateConMainServer(false);

            if (tmpWeight.Insert() > 0)//dbMain
            {
                dt = JWeights.GetDataTableAll(tmpWeight.Code, false);
            }
            dt.Columns.Add("State");
            dt.Columns.Add("StateHamrah");
            dt.Rows[0]["State"] = State;
            if (Convert.ToInt32(dt.Rows[0]["HamrahNO"]) != 0)
            {
                dt.Rows[0]["StateHamrah"] = dt.Rows[0]["HamrahNO"] + "    تعداد همراه  ";
            }
            else
            {
                dt.Rows[0]["StateHamrah"] = "";
            }
            if (dt != null)
            {
                //JDynamicReportForm DRF = new JDynamicReportForm(JReportDesignCodes.Bascool.GetHashCode());
                JDynamicReports DRF = new JDynamicReports(JReportDesignCodes.BillGoods.GetHashCode());
                DRF.Add(dt);
                //DRF.ShowDialog();
                DRF.Print("چاپ قبض", false, false);
            }

            try
            {
                dbMain.setQuery("Update BascolWeights set PrintNo=PrintNo+1 Where Code=" + _Code);
                dbMain.Query_Execute();
            }
            catch (Exception ex)
            {
                JSystem.Except.AddException(ex);
            }
            finally
            {
                dbMain.Dispose();
            }
        }
Ejemplo n.º 13
0
        //public bool InsertAccess()
        //{
        //    ClassLibrary.JOLeDbDataBase MyDB = new ClassLibrary.JOLeDbDataBase();
        //    try
        //    {
        //        string txtplok = txtPlak1.Text + cmbPlak.Text + txtPlak2.Text + "-" + txtPlak3.Text;
        //        MyDB.setQuery(@"INSERT INTO Weight (WDate,WTime,Plokno,UserNo,ProductNo,Weights,TruckNo,PrintNo,hamrahno,pay_h, BascoolNo,UserPostCode,Pay) VALUES ('" +
        //    txtDate.Date + "','" + txtTime.Text + "','" + txtplok + "'," + JMainFrame.CurrentPersonCode + "," + cmbProduct.SelectedValue.ToString() + "," +
        //    lblWeight.Text + "," + lsTrucks.SelectedValue.ToString() + ",1," + txtHamrah.Text + "," + (Convert.ToInt32(txtPay.Text)+ Convert.ToInt32(lblBedehkari.Text)).ToString()
        //    + "," + lblBascolNum.Text + "," + JMainFrame.CurrentPostCode + "," + _Price+ ")");

        //        if (MyDB.Query_Execute() > 0)
        //        {
        //            Print();
        //            btnClear_Click(null, null);
        //            JMessages.Error(" با موفقیت ثبت شد ", "");
        //            return true;
        //        }
        //        else
        //        {
        //            JMessages.Error(" با موفقیت ثبت نشد ", "");
        //            return false;
        //        }
        //    }
        //    finally
        //    {
        //        MyDB.Dispose();
        //    }
        //}

        private void btnSabt_Click(object sender, EventArgs e)
        {
            try
            {
                #region CheckData
                if (Convert.ToInt32(cmbTruck.SelectedValue) == -1)
                {
                    JMessages.Error(" ماشین را وارد کنید ", "");
                    cmbTruck.Focus();
                    return;
                }
                if (txtPay.Text == "")
                {
                    JMessages.Error(" قیمت را وارد کنید ", "");
                    txtPay.Focus();
                    return;
                }
                if ((txtPlak1.Text == "") || (txtPlak1.Text.Length < 2))
                {
                    JMessages.Error(" شماره پلاک را وارد کنید ", "");
                    txtPlak1.Focus();
                    return;
                }
                if ((txtPlak2.Text == "") || (txtPlak2.Text.Length < 3))
                {
                    JMessages.Error(" شماره پلاک را وارد کنید ", "");
                    txtPlak2.Focus();
                    return;
                }
                if ((txtPlak3.Text == "") || (txtPlak3.Text.Length < 2))
                {
                    JMessages.Error(" شماره پلاک را وارد کنید ", "");
                    txtPlak2.Focus();
                    return;
                }
                if (cmbPlak.Text == "")
                {
                    JMessages.Error(" شماره پلاک را وارد کنید ", "");
                    txtPlak2.Focus();
                    return;
                }
                if (lblBascolNum.Text == "0")
                {
                    JMessages.Error(" شماره باسکول وجود ندارد در قسمت تنظیمات شماره باسکول را تنظیم کنید ", "");
                    return;
                }
                if (lblWeight.Text == "0")
                {
                    JMessages.Error(" توزینی روی باسکول وجود ندارد ", "");
                    return;
                }
                #endregion

                string  txtplok   = txtPlak1.Text + cmbPlak.Text + txtPlak2.Text + "-" + txtPlak3.Text;
                JWeight tmpWeight = new JWeight();
                //tmpWeight.TruckCode = Convert.ToInt32(lsTrucks.SelectedValue.ToString());
                tmpWeight.TruckCode    = Convert.ToInt32(cmbTruck.SelectedValue.ToString());
                tmpWeight.UserPostCode = JMainFrame.CurrentPostCode;
                tmpWeight.PersonCode   = JMainFrame.CurrentPersonCode;
                tmpWeight.pay          = _Price;//Convert.ToInt32(txtPay.Text);
                tmpWeight.pay_h        = Convert.ToInt32(txtPay.Text);
                tmpWeight.BascoolCode  = Convert.ToInt32(lblBascolNum.Text);
                //tmpWeight.WDate = txtDate.Date;
                tmpWeight.WDate   = DateTime.Now;
                tmpWeight.WTime   = lblTime.Text;
                tmpWeight.PlokNo  = txtplok;
                tmpWeight.Weights = Convert.ToInt32(lblWeight.Text);
                tmpWeight.Duty    = (tmpWeight.pay / (100 + _Duty + _Tax)) * _Duty;
                tmpWeight.Tax     = (tmpWeight.pay / (100 + _Duty + _Tax)) * _Tax;
                if (txtHamrah.Text == "")
                {
                    txtHamrah.Text = "0";
                }
                tmpWeight.hamrahno    = Convert.ToInt32(txtHamrah.Text);
                tmpWeight.ProductCode = Convert.ToInt32(cmbProduct.SelectedValue.ToString());
                tmpWeight.PrintNo     = 1;
                if (_Counter == 0)
                {
                    tmpWeight.BascoolID = JWeights.GetCounter();
                }
                else
                {
                    tmpWeight.BascoolID = _Counter;
                }
                if (tmpWeight.BascoolID == 0)
                {
                    JMessages.Error(" خطا در شماره سریال قبض ", "");
                    return;
                }
                if ((JSystem.Nodes.DataTable.Rows.Count > 0) && ((JSystem.Nodes.DataTable.Rows.Count % 5) == 0) && (FlagKhales))
                {
                    Transfer(false);
                    lblWeight.Visible = false;
                    lblWeight.Visible = true;
                }
                _Code = tmpWeight.Insert();
                if (_Code > 0)
                {
                    //InsertAccess();
                    txtPlak1.Text = "";
                    Print();
                    //if (JSystem.Nodes.DefaultView.Rows.Count > 20)
                    //    btnHamgam_Click(null,null);
                    Clear();
                    txtPlak1.Focus();
                }
                else
                {
                    JMessages.Error(" با موفقیت ثبت نشد ", "");
                }
            }
            catch (Exception ex)
            {
                JSystem.Except.AddException(ex);
                JMessages.Error(" با موفقیت ثبت نشد ", "");
            }
        }