/// <summary> /// append to order table /// </summary> /// <returns>new record id of order 0 if failed</returns> protected Int32 append_order() { Int32 _newid = 0; DateTime? _dtnull = null; publishipadvanceOrderTableCustomcontroller _o = new publishipadvanceOrderTableCustomcontroller(); int _len = this.dxmemaddress.Text.Length > 200 ? 200 : this.dxmemaddress.Text.Length; string _addr = wwi_func.no_sql(this.dxmemaddress.Text.ToString().Substring(0, _len)); string _dest = this.dxcbocountry.Text != null? this.dxcbocountry.Text.ToString(): ""; DateTime? _cargo = this.dxdtcargoready.Text != ""? wwi_func.vdatetime(this.dxdtcargoready.Text): _dtnull; _newid = _o.PartialInsert(this.dxlblorderno2.Text, this.dxtxtpayee.Text, _addr, _dest, wwi_func.vint(this.dxlblprinter1.Text), wwi_func.vint(this.dxlblprinter2.Text), _cargo , this.dxtxtfao.Text); this.dxhforder.Set("orderid", _newid.ToString()); return _newid; }
//****************************** end carton grid /// <summary> /// set tallies for titles and cartons for current order and update order table /// </summary> /// <param name="orderid"></param> protected void set_tally(int orderId, int valueModifier, string appliesTo) { if (orderId > 0) { try { //Query q = new Query(DAL.Logistics.Tables.PublishipAdvanceOrderTable) {QueryType = QueryType.Update}; //q.WHERE("OrderId", SubSonic.Comparison.Equals, orderId); //q.AddUpdateSetting(PublishipAdvanceOrderTable.Columns.Titles, 1); //update order table //PublishipAdvanceOrderTableCollection _o = new PublishipAdvanceOrderTableCollection().Where("OrderID", SubSonic.Comparison.Equals, orderId).Load(); publishipadvanceOrderTableCustomcontroller _o = new publishipadvanceOrderTableCustomcontroller(); switch (appliesTo) { case "titles": { _o.UpdateTitleCount(orderId, valueModifier); break; } case "cartons": { _o.UpdateCartonCount(orderId, valueModifier); break; } } } catch (Exception ex) { Response.Write(ex.Message.ToString()); } } }