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)