def load(self):
row = DataClass.selectSproc(self, "Activity_Get", "One", str(self.id))
self.id = row[0]
self.name = row[1]
self.description = row[2]
self.status = row[3]
def load(self):
row = DataClass.selectSproc(self, "Customer_Type_Get", 'One',
str(self.id))
self.id = row[0]
self.description = row[1]
self.status = row[2]
def load(self):
row = DataClass.selectSproc(self, "Order_Item_Status_Get", 'One',
str(self.id))
self.id = row[0]
self.description = row[1]
self.status = row[2]
def load(self):
row = DataClass.selectSproc(self, "Color_Get", "One", str(self.id))
self.code = row[1]
self.description = row[2]
self.hexcode = row[3]
self.status = row[4]
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 load(self):
row = DataClass.selectSproc(self, "Color_Time_Get", "One", str(self.id))
self.colorid = row[1]
self.startdatetime = str(row[5])
self.enddatetime = str(row[6])
self.status = row[7]
color = Color(self.colorid, '', '', '', '')
color.load()
self.color = color
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 load(self):
row = DataClass.selectSproc(self,"Order_Item_Get", "One", str(self.id))
self.orderid = row[1]
self.orderitemstatusid = row[2]
self.orderitemstatus = row[3]
self.colorid = row[4]
self.colorcode = row[5]
self.colordesc = row[6]
self.carttypeid = row[7]
self.carttype = row[8]
self.quantity = row[9]
self.description = row[10]
self.specialinstructions = row[11]
self.qtyofcarts = row[12]
self.oversize = row[13]
self.priority = row[14]
self.requriesmaskorplug = row[15]
self.requiressandblasting = row[16]
self.priceper = str(row[17])
self.createdate = row[18]
self.subtotal = str(row[19])
def search(self):
params = "'" + self.status + "'"
self.rows = DataClass.selectSproc(self,"Order_Search", "All", params)
def search(self):
params = "'" + self.startdatetime + "','" + self.enddatetime + "','" + self.status + "'"
self.rows = DataClass.selectSproc(self, "Color_Time_Search", "All",
params)
def search(self):
params = str(self.orderid)
self.rows = DataClass.selectSproc(self,
"Order_Item_Search_By_Order_Id",
"All", params)
def search(self):
params = "'" + self.priority + "'"
self.rows = DataClass.selectSproc(self,"Customer_Search", "All", params)