public DataTable ReadPosList()
        {
            DataTable ReadListTable = null;

            CConnectSQL ConnectSQL = new CConnectSQL();

            ReadListTable = ConnectSQL.SQLReadData("select dl_id, dl_artname, dl_qua, dl_pricenet, dl_pricebrt, dl_dhid, MAX(dl_id) as maxID from dl_mdokl where dl_dhid = " + ID + " GROUP BY dl_id order by dl_id ");
            SaveTableAsList(ReadListTable);
            ReadMaxID();
            return(ReadListTable);
        }
Beispiel #2
0
        public DataTable ReadList()
        {
            DataTable ReadListTable = null;

            CConnectSQL ConnectSQL = new CConnectSQL();

            ReadListTable = ConnectSQL.SQLReadData("select * from dh_mdokh where dh_id > 0 order by dh_id");
            SaveTableAsList(ReadListTable);

            return(ReadListTable);
        }
Beispiel #3
0
 public bool EditPosLine(int ID, int MAINID, string ArtName, int Quantity, double PriceNet, double PriceBrt)
 {
     if (ID == 0)
     {
         return(false);
     }
     else
     {
         string      Request    = "Update dl_mdokl SET dl_id = " + ID + " , dl_dhid = " + MAINID + ", dl_artname = '" + ArtName + "', dl_qua = " + Quantity + " , dl_pricenet = " + PriceNet.ToString().Replace(",", ".") + ", dl_pricebrt = " + PriceBrt.ToString().Replace(",", ".") + " where dl_id = " + ID + " ;";
         CConnectSQL ConnectSQL = new CConnectSQL();
         return(ConnectSQL.SQLQueryExc(Request));
     }
 }
Beispiel #4
0
 public bool EditListLine(int ID, DateTime DATIN, string Name, int CustNR, double PriceNET, double PriceBRT)
 {
     if (ID == 0)
     {
         return(false);
     }
     else
     {
         string      Request    = "Update dh_mdokh SET dh_id = " + ID + " , dh_datin = '" + DATIN + "', dh_name = '" + Name + "', dh_custnr = " + CustNR + " , dh_pricenet = " + PriceNET.ToString().Replace(",", ".") + ", dh_pricebrt = " + PriceBRT.ToString().Replace(",", ".") + " where dh_id = " + ID + " ;";
         CConnectSQL ConnectSQL = new CConnectSQL();
         return(ConnectSQL.SQLQueryExc(Request));
     }
 }
Beispiel #5
0
 public bool CreatePosLine(int ID, int MAINID, string ArtName, int Quantity, double PriceNet, double PriceBrt)
 {
     if (ID == 0)
     {
         return(false);
     }
     else
     {
         string      Request    = "insert into dl_mdokl(dl_id, dl_artname, dl_qua, dl_dhid , dl_pricenet, dl_pricebrt) values(" + ID + ",'" + ArtName + "'," + Quantity + "," + MAINID + " ," + PriceNet.ToString().Replace(",", ".") + "," + PriceBrt.ToString().Replace(",", ".") + ");";
         CConnectSQL ConnectSQL = new CConnectSQL();
         return(ConnectSQL.SQLQueryExc(Request));
     }
 }
Beispiel #6
0
 public bool CreateListLine(int ID, DateTime DATIN, string Name, int CustNR, double PriceNET, double PriceBRT)
 {
     if (ID == 0)
     {
         return(false);
     }
     else
     {
         string Request = "insert into dh_mdokh(dh_id,dh_datin, dh_name, dh_custnr , dh_pricenet, dh_pricebrt) values(" + ID + ",'" + DATIN + "','" + Name + "'," + CustNR + " ," + PriceNET.ToString().Replace(",", ".") + "," + PriceBRT.ToString().Replace(",", ".") + ");";
         MessageBox.Show(Request);
         CConnectSQL ConnectSQL = new CConnectSQL();
         return(ConnectSQL.SQLQueryExc(Request));
     }
 }
Beispiel #7
0
        public bool DeletePosLine(int RowLine)
        {
            int DeletedID = RowLine;

            if (DeletedID == 0)
            {
                return(false);
            }
            else
            {
                string      Request    = "DELETE FROM dl_mdokl WHERE dl_id = " + DeletedID + ";";
                CConnectSQL ConnectSQL = new CConnectSQL();
                return(ConnectSQL.SQLQueryExc(Request));
            }
        }
Beispiel #8
0
        public bool DeletePosLines(int RowLine)
        {
            int DeletedID = TransactionListLine[RowLine].ID;

            if (DeletedID == 0)
            {
                return(false);
            }
            else
            {
                string      Request    = "DELETE FROM dl_mdokl WHERE dl_dhid = " + DeletedID + ";";
                CConnectSQL ConnectSQL = new CConnectSQL();
                return(ConnectSQL.SQLQueryExc(Request));
            }
        }
        private void ReadMaxID()
        {
            DataTable ReadListTable = null;

            CConnectSQL ConnectSQL = new CConnectSQL();

            ReadListTable = ConnectSQL.SQLReadData("select MAX(dl_id) as maxID from dl_mdokl GROUP BY dl_id order by dl_id ");

            foreach (DataRow dr2 in ReadListTable.Rows)
            {
                if (!DBNull.Value.Equals(dr2["maxID"]))
                {
                    MaxID = Convert.ToInt32(dr2["maxID"]);
                }
            }
        }