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("");
}
