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 __init__(self, id, code, description, hexcode, status):
DataClass.__init__(self)
self.id = id
self.code = code
self.description = description
self.hexcode = hexcode
self.status = status
def __init__(self, id, description, status):
"""Return a Customer object whose name is *name* and starting
balance is *balance*."""
DataClass.__init__(self)
self.id = id
self.description = description
self.status = status
print "Order Status init"
def __init__(self, id, colorid, startdatetime, enddatetime, status):
DataClass.__init__(self)
self.id = id
self.colorid = colorid
self.startdatetime = startdatetime
self.enddatetime = enddatetime
self.status = status
self.color = Color(0, '', '', '', '')
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_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, "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, "Activity_Get", "One", str(self.id))
self.id = row[0]
self.name = row[1]
self.description = row[2]
self.status = row[3]
def toJson(self,
jsonHeader='Self',
openingBrace=True,
asArray=False,
closeJson=True):
return DataClass._toJson(self, jsonHeader, openingBrace, asArray,
closeJson)
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 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 __init__(self, id, orderid, orderitemstatusid, colorid, carttypeid, quantity, description, specialinstructions,
qtyofcarts, oversize, priority, requriesmaskorplug, requiressandblasting, priceper, createdate, subtotal):
DataClass.__init__(self)
self.id = id
self.orderid = orderid
self.orderitemstatusid = orderitemstatusid
self.orderitemstatus = ""
self.colorid = colorid
self.colorcode = ""
self.colordesc = ""
self.carttypeid = carttypeid
self.carttype = ""
self.quantity = quantity
self.description = description
self.specialinstructions = specialinstructions
self.qtyofcarts = qtyofcarts
self.oversize = oversize
self.priority = priority
self.requriesmaskorplug = requriesmaskorplug
self.requiressandblasting = requiressandblasting
self.priceper = priceper
self.createdate = createdate
self.subtotal = subtotal
def toJson(self, jsonHeader='Self', openingBrace=True, asArray=False, closeJson=True):
self._Json = DataClass._toJson(self, jsonHeader, openingBrace, asArray, False)
self._Json += ","
self._Json += self.color.toJson('Color', False, False, False)
self._Json += '}}'
if asArray == True:
self._Json += "]"
if closeJson == True:
self._Json += "}"
return self._Json
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 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 __init__(self, orderid):
DataClass.__init__(self)
self.orderid = orderid
def __init__(self, priority):
DataClass.__init__(self)
self.priority = priority
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 __init__(self, id, description, status):
DataClass.__init__(self)
self.id = id
self.description = description
self.status = status
def search(self):
params = str(self.orderid)
self.rows = DataClass.selectSproc(self,
"Order_Item_Search_By_Order_Id",
"All", params)
def __init__(self, startdatetime, enddatetime, status):
DataClass.__init__(self)
self.startdatetime = startdatetime
self.enddatetime = enddatetime
self.status = status
def delete(self):
DataClass.executeSproc(self, "Order_Item_Status_Delete", str(self.id))
def __init__(self, status):
DataClass.__init__(self)
self.status = status
def search(self):
params = "'" + self.priority + "'"
self.rows = DataClass.selectSproc(self,"Customer_Search", "All", params)
