def save(self):
params = "'" + str(self.orderid) +"'"
params += ",'" + str(self.orderitemstatusid) + "'"
params += ",'" + str(self.colorid) + "'"
params += ",'" + str(self.carttypeid) + "'"
params += ",'" + self.quantity + "'"
params += ",'" + self.description + "'"
params += ",'" + self.specialinstructions + "'"
params += ",'" + str(self.qtyofcarts) + "'"
params += ",'" + self.oversize + "'"
params += ",'" + self.priority + "'"
params += ",'" + self.requriesmaskorplug + "'"
params += ",'" + self.requiressandblasting + "'"
params += ",'" + str(self.priceper) + "'"
params += ",'" + self.createdate + "'"
params += ",'" + str(self.subtotal)+"'"
if self.id < 1:
# insert
row = DataClass.selectSproc(self, "Order_Item_Insert", "One", params)
self.id = row[0]
else:
# update
params = str(self.id)+","+params
DataClass.executeSproc(self, "Order_Item_Update", params)
def save(self):
params = "'" + self.description + "'"
params += ",'" + self.status + "'"
if self.id < 1:
# insert
row = DataClass.selectSproc(self, "Order_Status_Insert", params)
self.id = row[0]
else:
# update
params = str(self.id) + "," + params
DataClass.executeSproc(self, "Order_Status_Update", params)
def save(self):
params = "'" + self.colorid + "'"
params += ",'" + self.startdatetime + "'"
params += ",'" + self.enddatetime + "'"
params += ",'" + self.status + "'"
if self.id < 1:
# insert
row = DataClass.selectSproc(self, "Color_Time_Insert", "One", params)
self.id = row[0]
else:
# update
params = str(self.id) + "," + params
DataClass.executeSproc(self, "Color_Time_Update", params)
def delete(self):
DataClass.executeSproc(self, "Customer_Type_Delete", str(self.id))
def delete(self):
DataClass.executeSproc(self, "Activity_Delete", str(self.id))
def delete(self):
DataClass.executeSproc(self, "Color_Delete", str(self.id))
def delete(self):
DataClass.executeSproc(self, "Order_Item_Status_Delete", str(self.id))