private void simpleButton1_Click(object sender, EventArgs e) { switch (this.simpleButton1.Text) { case "开始查询": //旧的异步查询方法已经废弃,现用同步查询 /* * this.simpleButton1.Visible = false; * string _rfname = ""; * //this.queryWaitingPanel1.Visible = true; * // this.queryWaitingPanel1.SetWait("查询任务已发!"); * this.CurrentTaskID = GetQueryTaskID(ref _rfname); * if (CurrentTaskID != "") * { * this.panel_BGDMSG.Visible = true; * Msg_HGBGD.Text = string.Format("请到查询任务列表中查看结果!\r\n{0}", _rfname); * this.bgWorker_BGD.RunWorkerAsync(); * } * * * */ StartQueryOtherLib(); break; case "查看详细": frmSinoSZ_QueryResult _qr = new frmSinoSZ_QueryResult(this.QueryTaskID_BGD); _application.AddForm(Guid.NewGuid().ToString(), _qr); break; } }
/// <summary> /// 显示查询结果 /// </summary> private bool ShowResult() { if (this.CurrentTask != null) { frmSinoSZ_QueryResult _qr = new frmSinoSZ_QueryResult(this.CurrentTask); _application.AddForm(Guid.NewGuid().ToString(), _qr); return(true); } else { return(false); } }
/// <summary> /// 查询数据 /// </summary> virtual protected void QueryData(IApplication _application) { if (_application == null) { return; } string _errorMsg = ""; if (!this.sinoSZUC_MD_Model_FieldList1.CheckItems(ref _errorMsg)) { XtraMessageBox.Show(string.Format("选择查询结果不正确:{0}", _errorMsg), "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (!this.sinoSZUC_ConditionPanel1.CheckInput(ref _errorMsg)) { XtraMessageBox.Show(string.Format("查询条件不正确:{0}", _errorMsg), "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } MC_QueryRequsetFactory _rf = new MC_QueryRequsetFactory(); _rf.QueryModelName = this.QueryModelName; this.sinoSZUC_ConditionPanel1.InsertConditions2QueryRequest(_rf); this.sinoSZUC_MD_Model_FieldList1.InsertResultFields2QueryRequest(_rf); MDQuery_Request _queryRequest = _rf.GetQueryRequest(); if (_queryRequest.MainResultTable.Columns == null || _queryRequest.MainResultTable.Columns.Count < 1) { XtraMessageBox.Show("主表必须至少选择一个结果字段!", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } frmSinoSZ_QueryResult _qr = new frmSinoSZ_QueryResult(_queryModel, _queryRequest); AddExtMenu(_qr); _application.AddForm(Guid.NewGuid().ToString(), _qr); //XtraMessageBox.Show(string.Format("查询请求包占用存{0}Byte", CalcMemory.CalcInstanceMemory(_rf.GetQueryRequest()))); }
virtual protected void AddExtMenu(frmSinoSZ_QueryResult _qr) { }
private string StartQueryOtherLib() { string _ret = ""; string Task_Name = ""; string _taskid = ""; MDQuery_Request _request; if (ResultData == null) { return(""); } if (ResultData.Rows.Count < 1) { return(""); } var _find = from _c in this.QueryModel.MainTable.Columns where _c.ColumnName == "FORM_ID" select _c; if (_find == null || _find.Count() < 1) { return(""); } MDModel_Table_Column tc_FORM_ID = this.QueryModel.MainTable.GetColumnByName("FORM_ID"); MDModel_Table_Column tc_FORM_TYPE = this.QueryModel.MainTable.GetColumnByName("FORM_TYPE"); MDModel_Table_Column tc_I_E_PORT = this.QueryModel.MainTable.GetColumnByName("I_E_PORT"); MDModel_Table_Column tc_I_E_FLAG = this.QueryModel.MainTable.GetColumnByName("I_E_FLAG"); MDModel_Table_Column tc_I_E_DATETIME = this.QueryModel.MainTable.GetColumnByName("I_E_DATETIME"); MDModel_Table_Column tc_VE_CUSTOMS_NO = this.QueryModel.MainTable.GetColumnByName("VE_CUSTOMS_NO"); DataRow _dr = ResultData.Rows[0]; string _formType = _dr[tc_FORM_TYPE.ColumnAlias].ToString().Trim(); string _formID = _dr[tc_FORM_ID.ColumnAlias].ToString().Trim(); string _portCode = _dr[tc_I_E_PORT.ColumnAlias].ToString().Trim(); string _customs_no = _dr[tc_VE_CUSTOMS_NO.ColumnAlias].ToString().Trim(); _portCode = _portCode.Substring(0, 2); string _IEFlag = _dr[tc_I_E_FLAG.ColumnAlias].ToString().Trim(); string _IEFlagNum = (_IEFlag == "I") ? "1" : "0"; DateTime I_E_Date = (DateTime)_dr[tc_I_E_DATETIME.ColumnAlias]; DateTime Min_SB_Date = I_E_Date.AddMonths(-1); switch (_formType) { case "1": //清单 XtraMessageBox.Show("本记录为清单,无法查询详细内容", "系统提示"); return(""); case "2": //报关单 string _FormIDPre = _formID.Substring(0, 2); //生成一个单号 _ret = string.Format("{0}{1}{2}", I_E_Date.Year, _IEFlagNum, _formID); _request = CreateBGDQueryRequest2(I_E_Date, _IEFlagNum, _formID); string _qvName = "HG_GDFS.海关报关单"; MDModel_QueryModel _qv = MetaDataCache.GetQueryModelDefine(_qvName); frmSinoSZ_QueryResult _qr = new frmSinoSZ_QueryResult(_qv, _request, false); _application.AddForm(Guid.NewGuid().ToString(), _qr); return(_taskid); case "4": //转关单 string _prestr = _formID.Substring(0, 4); if (_prestr == "1000" || _prestr == "5000") { _request = CreateZGDQueryRequest("@" + _formID, Min_SB_Date, I_E_Date); Task_Name = string.Format("查询编号为{0}的转关单[{1}]", _ret, DateTime.Now.ToString("yyyyMMdd")); using (MetaDataQueryServiceClient _msc = new MetaDataQueryServiceClient()) { _taskid = _msc.AddNewQueryTask(Task_Name, _request); } return(_taskid); } break; } return(""); }