예제 #1
0
        public int AddSaleLine(Int32 SaleID, Int32 ProductID, double Price, string Notes)
        {
            clsDBConnection db = new clsDBConnection();

            //add the parameters
            db.AddParameter("@saleID", SaleID);
            //add the parameters
            db.AddParameter("@productID", ProductID);
            //add the parameters
            db.AddParameter("@price", Price);
            //add the parameters
            db.AddParameter("@notes", Notes);
            //execute the stored procedure
            int Result = db.Execute("AddSaleLineProcedure");


            return(Result);
        }
예제 #2
0
 public clsDBRepair()
 {
     db = new clsDBConnection();
 }
예제 #3
0
 public clsDBSupplier()
 {
     db = new clsDBConnection();
 }
예제 #4
0
 public clsDBLogin()
 {
     db = new clsDBConnection();
 }
예제 #5
0
 public clsDBDevice()
 {
     db = new clsDBConnection();
 }
예제 #6
0
 public claDBSale()
 {
     db = new clsDBConnection();
 }
예제 #7
0
 public clsDBProductRecord()
 {
     db = new clsDBConnection();
 }
예제 #8
0
 public clsDBSaleSearchSP()
 {
     db = new clsDBConnection();
 }