protected void bind_eta_grid(int voyageid) { string[] _cols = { "VoyageETASubTable.VoyageETASubID", "VoyageETASubTable.VoyageID", "VoyageETASubTable.DestinationPortID", "VoyageETASubTable.ETA", "PortTable.PortName" }; SubSonic.SqlQuery _qry = DAL.Logistics.DB.Select(_cols).From(DAL.Logistics.Tables.VoyageETASubTable). LeftOuterJoin(DAL.Logistics.PortTable.PortIDColumn, DAL.Logistics.VoyageETASubTable.DestinationPortIDColumn) .WhereExpression("VoyageID").IsEqualTo(voyageid); DataTable _dt = _qry.ExecuteDataSet().Tables[0]; this.dxgrdETA.DataSource = _dt; this.dxgrdETA.KeyFieldName = "VoyageETASubID"; this.dxgrdETA.DataBind(); }
public string get_company_group(int requestCompanyId) { string _cg = "0"; string[] _tcols = { "NameAndAddressBook.CompanyId", "NameAndAddressBook.Pricer_Group" }; SubSonic.SqlQuery _qry = DAL.Logistics.DB.Select(_tcols).From(DAL.Logistics.Tables.NameAndAddressBook).Where("CompanyID").IsEqualTo(requestCompanyId); DataSet _dt = _qry.ExecuteDataSet(); if (_dt.Tables.Count > 0 && _dt.Tables[0].Rows.Count > 0) { _cg = !string.IsNullOrEmpty(_dt.Tables[0].Rows[0]["Pricer_Group"].ToString()) ? _dt.Tables[0].Rows[0]["Pricer_Group"].ToString() : "0"; } return(_cg); }
protected void dxcboCountry_ItemsRequestedByFilterCondition(object source, ListEditItemsRequestedByFilterConditionEventArgs e) { DevExpress.Web.ASPxEditors.ASPxComboBox _combo = (DevExpress.Web.ASPxEditors.ASPxComboBox)source; string _filter = !string.IsNullOrEmpty(e.Filter) ? e.Filter : ""; //use datareaders - much faster than loading into collections string[] _cols = { "CountryID", "CountryName" }; string[] _order = { "CountryName" }; //SubSonic.SqlQuery _query = DAL.Logistics.DB.Select(_cols).From(DAL.Logistics.Tables.NameAndAddressBook).Paged(e.BeginIndex + 1, e.EndIndex + 1, "CompanyID").WhereExpression("CompanyName").Like(string.Format("%{0}%", e.Filter.ToString())); SubSonic.SqlQuery _query = DAL.Logistics.DB.Select(_cols).From(DAL.Logistics.Tables.CountryTable).Paged(e.BeginIndex + 1, e.EndIndex + 1, "CountryID").WhereExpression("CountryName").Like(string.Format("{0}%", _filter)); DataTable _dt = _query.ExecuteDataSet().Tables[0]; IDataReader _rd = _query.ExecuteReader(); _combo.ValueField = "CountryID"; _combo.ValueType = typeof(int); _combo.TextField = "CountryName"; _combo.DataBindItems(); }
//end bind country #endregion #region incremental filtering for large combobox datasets //14/07/14 dxcboVesselID_ItemRequestedByValue and dxcboVesselID_ItemsRequestedByFilterCondition DEPRECATED //can't use OnItemsRequestedByFilterCondition and OnItemRequestedByValue on this combo as server-side filtring makes the search case sensitive //incremental filtering for large datasets on combos /// <summary> /// incremental filtering and partial loading of name and address book for speed /// both ItemsRequestedByFilterCondition and ItemRequestedByValue must be set up for this to work /// company name is only available to publiship users /// </summary> /// <param name="source"></param> /// <param name="e"></param> protected void dxcboCountry_ItemRequestedByValue(object source, ListEditItemRequestedByValueEventArgs e) { DevExpress.Web.ASPxEditors.ASPxComboBox _combo = (DevExpress.Web.ASPxEditors.ASPxComboBox)source; Int32 _id = 0; if (e.Value != null) { _id = wwi_func.vint(e.Value.ToString()); } string[] _cols = { "CountryID", "CountryName" }; string[] _order = { "CountryName" }; SubSonic.SqlQuery _query = DAL.Logistics.DB.Select(_cols).From(DAL.Logistics.Tables.CountryTable).WhereExpression("CountryID").IsEqualTo(_id); IDataReader _rd = _query.ExecuteReader(); DataTable _dt = _query.ExecuteDataSet().Tables[0]; _combo.ValueField = "CountryID"; _combo.ValueType = typeof(int); _combo.TextField = "CountryName"; _combo.DataBindItems(); }
protected void formOrder_DataBound(object sender, EventArgs e) { try { OrderTable _row = (OrderTable)this.formOrder.DataItem; //icons //publiship order this.dximgJobPubliship.ClientVisible = _row != null? _row.PublishipOrder: false; this.dxlblJobPubliship.ClientVisible = _row != null ? _row.PublishipOrder : false; //job closed this.dximgJobClosed.ClientVisible = _row != null ? _row.JobClosed : false; this.dxlblJobClosed.ClientVisible = _row != null ? _row.JobClosed : false; //hot job this.dximgJobHot.ClientVisible = _row != null ? _row.HotJob : false; this.dxlblJobHot.ClientVisible = _row != null ? _row.HotJob : false; string _office = ""; int _officeid = 0; if (this.formOrder.CurrentMode == FormViewMode.Insert) { //order number and office in header this.dxlblOrderNo.Text = "[New Order]"; _officeid = Page.Session["user"] != null ? (int)((UserClass)Page.Session["user"]).OfficeId : 0; _office = wwi_func.lookup_xml_string("xml\\office_names.xml", "value", _officeid.ToString(), "name"); } else { this.dxlblOrderNo.Text = _row.OrderNumber.ToString(); _office = _row != null ? _row.OfficeIndicator : ""; _officeid = wwi_func.vint(wwi_func.lookup_xml_string("xml\\office_names.xml", "name", _office, "value")); } this.dxlbOrderDetails1.Text = "|" + _office; //just pass it as a param //this.dxhfOfficeID.Clear(); //this.dxhfOfficeID.Add("officeid", _officeid.ToString()); //16/10/13 view returned to this page and single summary query used to populate look-up values //view moved to seperate page (Order_View.aspx) so we can avoid all these calls to the database! if (this.formOrder.CurrentMode == FormViewMode.Edit || this.formOrder.CurrentMode == FormViewMode.Insert) { //have to bind the standard ddls here or they don't populate for new orders bind_company_combos(_officeid); bind_origin_combos(-1); bind_dest_combos(); sub_decks(); } else //readonly { string _test =""; SubSonic.SqlQuery _q = new SubSonic.SqlQuery(); _q = DB.Select().From("view_order_summary").Where("OrderNumber").IsEqualTo(_row.OrderNumber); DataTable _dt = _q.ExecuteDataSet().Tables[0]; //labels ASPxLabel _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblViewController"); if (_lbl != null) { _lbl.Text = _dt.Rows[0]["OrderController"].ToString(); } _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblViewContact"); if (_lbl != null) { _lbl.Text = _dt.Rows[0]["ContactName"].ToString(); } _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblViewOps"); if (_lbl != null) { _lbl.Text = _lbl.Text = _dt.Rows[0]["OpsController"].ToString(); } _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblContactEmail"); if (_lbl != null) { _lbl.Text = _dt.Rows[0]["EMail"].ToString(); } _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblViewCompany"); if (_lbl != null) { _lbl.Text = _dt.Rows[0]["CompanyName"].ToString(); } _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblViewPrinter"); if (_lbl != null) { _lbl.Text = _dt.Rows[0]["PrinterName"].ToString(); } _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblViewCountry"); if (_lbl != null) { _lbl.Text = _dt.Rows[0]["OriginCountry"].ToString(); } _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblViewOrigin"); if (_lbl != null) { _lbl.Text = _dt.Rows[0]["PlaceName"].ToString(); } _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblViewOriginPort"); if (_lbl != null) { _lbl.Text = _dt.Rows[0]["OriginPort"].ToString(); } _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblViewAgentAtOrigin"); if (_lbl != null) { _lbl.Text = _dt.Rows[0]["OriginAgent"].ToString(); _test = _dt.Rows[0]["OriginAgent"].ToString(); } _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblViewDestPort"); if (_lbl != null) { _lbl.Text = _dt.Rows[0]["DestinationPort"].ToString(); } _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblViewFinal"); if (_lbl != null) { _lbl.Text = _dt.Rows[0]["FinalDestination"].ToString(); } //260211 some older jobs have an origin controller but no origin agent in those cases don't display the origin controller if (!string.IsNullOrEmpty(_test)) { _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblViewOriginController"); if (_lbl != null) { _lbl.Text = _dt.Rows[0]["OriginPortController"].ToString(); } } //date formatting _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblDateCreated"); if (_lbl != null) { _lbl.Text = _lbl.Text != "" ? wwi_func.vdatetime(_lbl.Text).ToShortDateString() : ""; } _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblViewExWorks"); if (_lbl != null) { _lbl.Text = _lbl.Text != "" ? wwi_func.vdatetime(_lbl.Text).ToShortDateString() : ""; } _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblViewBookingReceived"); if (_lbl != null) { _lbl.Text = _lbl.Text != "" ? wwi_func.vdatetime(_lbl.Text).ToShortDateString() : ""; } _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblViewCargoReady"); if (_lbl != null) { _lbl.Text = _lbl.Text != "" ? wwi_func.vdatetime(_lbl.Text).ToShortDateString() : ""; } _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblViewDueWarehouse"); if (_lbl != null) { _lbl.Text = _lbl.Text != "" ? wwi_func.vdatetime(_lbl.Text).ToShortDateString() : ""; } _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblViewDocsApprovedDate"); if (_lbl != null) { _lbl.Text = _lbl.Text != "" ? wwi_func.vdatetime(_lbl.Text).ToShortDateString() : ""; } //addresses _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblCompanyAddress"); if (_lbl != null) { _lbl.Text = _dt.Rows[0]["Address1"].ToString() + Environment.NewLine + _dt.Rows[0]["Address2"].ToString() + Environment.NewLine + _dt.Rows[0]["Address3"].ToString() + Environment.NewLine + _dt.Rows[0]["CountryName"].ToString() + Environment.NewLine + _dt.Rows[0]["TelNo"].ToString(); } _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblPrinterAddress"); if (_lbl != null) { _lbl.Text = _dt.Rows[0]["PrinterAdd1"].ToString() + Environment.NewLine + _dt.Rows[0]["PrinterAdd2"].ToString() + Environment.NewLine + _dt.Rows[0]["PrinterAdd3"].ToString() + Environment.NewLine + _dt.Rows[0]["PrinterCountry"].ToString() + Environment.NewLine + _dt.Rows[0]["PrinterTel"].ToString(); } _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblOriginAgentAddress"); if (_lbl != null) { _lbl.Text = _dt.Rows[0]["OriginAgentAddress1"].ToString() + Environment.NewLine + _dt.Rows[0]["OriginAgentAddress2"].ToString() + Environment.NewLine + _dt.Rows[0]["OriginAgentAddress3"].ToString() + Environment.NewLine + _dt.Rows[0]["OriginAgentCountry"].ToString() + Environment.NewLine + _dt.Rows[0]["OriginAgentTel"].ToString(); } //deprecated look-up code //if (this.formOrder.CurrentMode == FormViewMode.ReadOnly) //{ // //text values for view template // ASPxLabel _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblViewController"); // if (_lbl != null) { _lbl.Text = wwi_func.lookup_value("Name", "EmployeesTable", "EmployeeID", _row.OrderControllerID); } // _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblViewContact"); // if (_lbl != null) { _lbl.Text = wwi_func.lookup_value("ContactName", "ContactTable", "ContactID", _row.ContactID); } // _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblViewOps"); // if (_lbl != null) { _lbl.Text = wwi_func.lookup_value("Name", "EmployeesTable", "EmployeeID", _row.OperationsControllerID); } // _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblViewCompany"); // if (_lbl != null) { _lbl.Text = wwi_func.lookup_value("CompanyName", "view_delivery_address", "CompanyID", _row.CompanyID); } // _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblViewPrinter"); // if (_lbl != null) { _lbl.Text = wwi_func.lookup_value("PrinterName", "PrinterView", "CompanyID", _row.PrinterID); } // _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblViewCountry"); // if (_lbl != null) { _lbl.Text = wwi_func.lookup_value("CountryName", "CountryTable", "CountryID", _row.CountryID); } // _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblViewOrigin"); // if (_lbl != null) { _lbl.Text = wwi_func.lookup_value("PlaceName", "PlacesTable", "PlaceID", _row.OriginPointID); } // _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblViewOriginPort"); // if (_lbl != null) { _lbl.Text = wwi_func.lookup_value("PortName", "PortTable", "PortID", _row.PortID); } // _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblViewAgentAtOrigin"); // if (_lbl != null) { _lbl.Text = wwi_func.lookup_value("OriginAgent", "OriginAgentView", "OriginAgentID", _row.AgentAtOriginID); } // _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblViewDestPort"); // if (_lbl != null) { _lbl.Text = wwi_func.lookup_value("PortName", "PortTable", "PortID", _row.DestinationPortID); } // _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblViewFinal"); // if (_lbl != null) { _lbl.Text = wwi_func.lookup_value("PlaceName", "PlacesTable", "PlaceID", _row.FinalDestinationID); } // _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblViewOriginController"); // if (_lbl != null) { _lbl.Text = wwi_func.lookup_value("Name", "EmployeesTable", "EmployeeID", _row.OriginPortControllerID); } // //address labels // _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblCompanyAddress"); // if (_lbl != null) { _lbl.Text = wwi_func.lookup_multi_values("Address1,Address2,Address3,CountryName,TelNo", "view_delivery_address", "CompanyID", _row.CompanyID); } // _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblContactEmail"); // if (_lbl != null) { _lbl.Text = wwi_func.lookup_value("EMail", "ContactTable", "ContactID", _row.ContactID); } // _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblPrinterAddress"); // if (_lbl != null) { _lbl.Text = wwi_func.lookup_multi_values("PrinterAdd1,PrinterAdd2,PrinterAdd3,PrinterCountry,PrinterTel", "PrinterView", "CompanyID", _row.PrinterID); } // _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblOriginAgentAddress"); // if (_lbl != null) { _lbl.Text = wwi_func.lookup_multi_values("OriginAgentAddress1,OriginAgentAddress2,OriginAgentAddress3,OriginAgentCountry", "OriginAgentView", "OriginAgentID", _row.AgentAtOriginID); } //} } } catch (Exception ex) { string _ex = ex.Message.ToString(); this.dxlblErr.Text = _ex; this.dxpnlErr.Visible = true; } }
//end selecting protected void fmvShipment_DataBound(object sender, EventArgs e) { try { OrderTable _row = (OrderTable)this.fmvShipment.DataItem; //publiship order this.dximgJobPubliship.ClientVisible = _row != null ? _row.PublishipOrder : false; this.dxlblJobPubliship.ClientVisible = _row != null ? _row.PublishipOrder : false; //job closed this.dximgJobClosed.ClientVisible = _row != null ? _row.JobClosed : false; this.dxlblJobClosed.ClientVisible = _row != null ? _row.JobClosed : false; //hot job this.dximgJobHot.ClientVisible = _row != null ? _row.HotJob : false; this.dxlblJobHot.ClientVisible = _row != null ? _row.HotJob : false; //order number and office in header this.dxlblOrderNo.Text = _row.OrderNumber.ToString(); string[] _cols = { "OrderNumber", "PublishipOrder", "OfficeIndicator", "DateOrderCreated", "JobClosed", "HotJob", "PortID", "DestinationPortID", "VesselID", "PackageTypeID", "FCLLCL" }; SubSonic.SqlQuery _q = new SubSonic.SqlQuery(); _q = DAL.Logistics.DB.Select(_cols).From(DAL.Logistics.Tables.OrderTable).WhereExpression("OrderNumber").IsEqualTo(_row.OrderNumber); DataTable _dt = _q.ExecuteDataSet().Tables[0]; if (_dt.Rows.Count > 0) { string _vessel = wwi_func.lookup_value("Joined", "VoyageTable", "VoyageID", wwi_func.vint(_dt.Rows[0]["VesselID"].ToString())); string _package = wwi_func.lookup_value("PackageType", "PackageTypeTable", "PackageTypeID", wwi_func.vint(_dt.Rows[0]["PackageTypeID"].ToString())); string _fcllcl = wwi_func.lookup_xml_string("//xml//ddl_items.xml", "ddls", "FCLLCL", "value", _dt.Rows[0]["FCLLCL"].ToString(), "name"); this.dxhfOrder.Remove("ptstart"); //origin port this.dxhfOrder.Remove("ptend"); //destination port this.dxhfOrder.Remove("vssl"); //vessel name this.dxhfOrder.Add("ptstart", _dt.Rows[0]["PortID"].ToString()); this.dxhfOrder.Add("ptend", _dt.Rows[0]["DestinationPortID"].ToString()); this.dxhfOrder.Add("vssl", _vessel); //containers list in all views bind_containers(); if (this.fmvShipment.CurrentMode != FormViewMode.ReadOnly) { //bind dlls here or won't populate on new record bind_fcl_lcl(); bind_package_type(); } else { //set values for dlls in ReadOnly mode ASPxLabel _lbl = (ASPxLabel)this.fmvShipment.FindControl("dxlblFieldVessel"); if (_lbl != null) { _lbl.Text = _vessel; } _lbl = (ASPxLabel)this.fmvShipment.FindControl("dxlblFieldPackageTypeID"); if (_lbl != null) { _lbl.Text = _package; } _lbl = (ASPxLabel)this.fmvShipment.FindControl("dxlblFieldFCLLCL"); if (_lbl != null) { _lbl.Text = _fcllcl; } //date formatting _lbl = (ASPxLabel)this.fmvShipment.FindControl("dxlblFieldETS"); if (_lbl != null) { _lbl.Text = _lbl.Text != "" ? wwi_func.vdatetime(_lbl.Text).ToShortDateString() : ""; } _lbl = (ASPxLabel)this.fmvShipment.FindControl("dxlblFieldETA"); if (_lbl != null) { _lbl.Text = _lbl.Text != "" ? wwi_func.vdatetime(_lbl.Text).ToShortDateString() : ""; } _lbl = (ASPxLabel)this.fmvShipment.FindControl("dxlblFieldJobClosureDate"); if (_lbl != null) { _lbl.Text = _lbl.Text != "" ? wwi_func.vdatetime(_lbl.Text).ToShortDateString() : ""; } }//endif }//endif } catch (Exception ex) { string _err = ex.Message.ToString(); this.dxlblErr.Text = _err; this.dxpnlErr.ClientVisible = true; } }
//end selecting protected void fmvShipment_DataBound(object sender, EventArgs e) { try { OrderTable _row = (OrderTable)this.fmvShipment.DataItem; //publiship order this.dximgJobPubliship.ClientVisible = _row != null ? _row.PublishipOrder : false; this.dxlblJobPubliship.ClientVisible = _row != null ? _row.PublishipOrder : false; //job closed this.dximgJobClosed.ClientVisible = _row != null ? _row.JobClosed : false; this.dxlblJobClosed.ClientVisible = _row != null ? _row.JobClosed : false; //hot job this.dximgJobHot.ClientVisible = _row != null ? _row.HotJob : false; this.dxlblJobHot.ClientVisible = _row != null ? _row.HotJob : false; //order number and office in header this.dxlblOrderNo.Text = _row.OrderNumber.ToString(); string[] _cols = { "OrderNumber", "PublishipOrder", "OfficeIndicator", "DateOrderCreated", "JobClosed", "HotJob", "PortID", "DestinationPortID", "VesselID", "PackageTypeID", "FCLLCL" }; SubSonic.SqlQuery _q = new SubSonic.SqlQuery(); _q = DAL.Logistics.DB.Select(_cols).From(DAL.Logistics.Tables.OrderTable).WhereExpression("OrderNumber").IsEqualTo(_row.OrderNumber); DataTable _dt = _q.ExecuteDataSet().Tables[0]; if (_dt.Rows.Count > 0) { string _vessel = wwi_func.lookup_value("Joined", "VoyageTable", "VoyageID", wwi_func.vint(_dt.Rows[0]["VesselID"].ToString())); string _package = wwi_func.lookup_value("PackageType", "PackageTypeTable", "PackageTypeID", wwi_func.vint(_dt.Rows[0]["PackageTypeID"].ToString())); string _fcllcl = wwi_func.lookup_xml_string("//xml//ddl_items.xml", "ddls", "FCLLCL", "value", _dt.Rows[0]["FCLLCL"].ToString(), "name"); this.dxhfOrder.Remove("ptstart"); //origin port this.dxhfOrder.Remove("ptend"); //destination port this.dxhfOrder.Remove("vssl"); //vessel name this.dxhfOrder.Add("ptstart", _dt.Rows[0]["PortID"].ToString()); this.dxhfOrder.Add("ptend", _dt.Rows[0]["DestinationPortID"].ToString()); this.dxhfOrder.Add("vssl", _vessel); //containers list in all views bind_containers(); if (this.fmvShipment.CurrentMode != FormViewMode.ReadOnly) { //bind dlls here or won't populate on new record bind_fcl_lcl(); bind_package_type(); } else { //set values for dlls in ReadOnly mode ASPxLabel _lbl = (ASPxLabel)this.fmvShipment.FindControl("dxlblFieldVessel"); if (_lbl != null) { _lbl.Text = _vessel; } _lbl = (ASPxLabel)this.fmvShipment.FindControl("dxlblFieldPackageTypeID"); if (_lbl != null) { _lbl.Text = _package; } _lbl = (ASPxLabel)this.fmvShipment.FindControl("dxlblFieldFCLLCL"); if (_lbl != null) { _lbl.Text = _fcllcl; } //date formatting _lbl = (ASPxLabel)this.fmvShipment.FindControl("dxlblFieldETS"); if (_lbl != null) { _lbl.Text = _lbl.Text != "" ? wwi_func.vdatetime(_lbl.Text).ToShortDateString() : ""; } _lbl = (ASPxLabel)this.fmvShipment.FindControl("dxlblFieldETA"); if (_lbl != null) { _lbl.Text = _lbl.Text != "" ? wwi_func.vdatetime(_lbl.Text).ToShortDateString() : ""; } _lbl = (ASPxLabel)this.fmvShipment.FindControl("dxlblFieldJobClosureDate"); if (_lbl != null) { _lbl.Text = _lbl.Text != "" ? wwi_func.vdatetime(_lbl.Text).ToShortDateString() : ""; } } //endif } //endif } catch (Exception ex) { string _err = ex.Message.ToString(); this.dxlblErr.Text = _err; this.dxpnlErr.ClientVisible = true; } }