public void GetOperatingData(DoWorkEventArgs e) { using (var Client = new SRPiPeline.PipelineServiceClient()) { int iPageSize = (int)page.PageSize; int iCurrPage = (int)page.CurrentPage; Tuple <StringBuilder, List <object> > dtFilter = Tuple.Create <StringBuilder, List <object> >(new StringBuilder(), new List <object>()); dtFilter.Item1.Append("1 = 1"); if (string.IsNullOrEmpty(te_CheckStartTime.Text) == false && string.IsNullOrEmpty(te_CheckEndTime.Text) == false) { var mindate = Convert.ToDateTime(te_CheckStartTime.Text).Date; var maxdate = Convert.ToDateTime(te_CheckEndTime.Text).Date.AddHours(23.99); FilterProcess.MergeFilterCondition("OperatingTime", mindate, ref dtFilter, objValues1: maxdate, dataType: FilterProcess.DataType.DateTime); //FilterProcess.MergeFilterCondition("OperatingTime", Convert.ToDateTime(te_CheckEndTime.Text).Date.AddHours(23.99), ref dtFilter, "<="); } var ret = Client.GetOperatingRecord(context.SessionID, Tuple.Create <string, object[]>(dtFilter.Item1.ToString(), dtFilter.Item2.ToArray()), iCurrPage, iPageSize); if (ret.IsSuccess) { page.CurrentPage = iCurrPage; page.RowCount = ret.TotalNum; e.Result = ret.Data; } else { backgroundWorker.ReportProgress(101, ret.Message); } } }
public void LoadPersonData(DoWorkEventArgs e) { using (var Client = new SRPersonInfo.PersonServiceClient()) { Tuple <StringBuilder, List <object> > dtFilter = Tuple.Create <StringBuilder, List <object> >(new StringBuilder(), new List <object>()); dtFilter.Item1.Append("1 = 1"); FilterProcess.MergeFilterCondition("DepCode", te_DepCode.Text, ref dtFilter); if (string.IsNullOrEmpty(te_PersonCode.Text) == false) { FilterProcess.MergeFilterCondition("PersonCode", te_PersonCode.Text, ref dtFilter); } if (string.IsNullOrEmpty(te_PersonName.Text) == false) { FilterProcess.MergeFilterCondition("PersonName", te_PersonName.Text, ref dtFilter, "like"); } if (string.IsNullOrEmpty(te_PersonType.Text) == false) { FilterProcess.MergeFilterCondition("PersonType", te_PersonType.Text, ref dtFilter); } int iPageSize = (int)Page.PageSize; int iCurrPage = (int)Page.CurrentPage; var ret = Client.GetPersonList(context.SessionID, Tuple.Create <string, object[]>(dtFilter.Item1.ToString(), dtFilter.Item2.ToArray()), iPageSize, iCurrPage); if (ret.IsSuccess) { Page.CurrentPage = iCurrPage; Page.RowCount = ret.TotalNum; e.Result = ret.Data; } } }
private void bgWait_DoWork(object sender, DoWorkEventArgs e) { bgWait.ReportProgress(0); try { switch (e.Argument.ToString()) { case "LoadArrangedVouchCodeList": if (string.IsNullOrEmpty(te_Date.Text) == false) { using (AVClient = new SRArrangedVouch.ArrangedVServiceClient()) { var mindate = Convert.ToDateTime(te_Date.Text).Date; var maxdate = Convert.ToDateTime(te_Date.Text).Date.AddHours(23.99); int iPageSize = (int)Page.PageSize; int iCurrPage = (int)Page.CurrentPage; Tuple <StringBuilder, List <object> > dtFilter = Tuple.Create <StringBuilder, List <object> >(new StringBuilder(), new List <object>()); dtFilter.Item1.Append("1=1"); FilterProcess.MergeFilterCondition("CreateTime", mindate, ref dtFilter, objValues1: maxdate, dataType: FilterProcess.DataType.DateTime); //FilterProcess.MergeFilterCondition("CreateTime", maxdate, ref dtFilter, "<=", dataType: FilterProcess.DataType.DateTime); FilterProcess.MergeFilterCondition("UserStatus", "1", ref dtFilter, "!=", dataType: FilterProcess.DataType.Int); var ret = AVClient.GetArrangedVouchList(context.SessionID, Tuple.Create <string, object[]>(dtFilter.Item1.ToString(), dtFilter.Item2.ToArray()), iPageSize, iCurrPage); if (ret.IsSuccess) { Page.PageSize = iPageSize; Page.CurrentPage = iCurrPage; e.Result = ret.Data; } else { ClsMsg.ShowInfoMsg(ret.Message); } } } else { ClsMsg.ShowWarningEmptyMsg(lb_Date.Text); } break; default: break; } } catch (FaultException <SRZhuanGu.CustomFaultMessage> fex) { bgWait.ReportProgress(102, fex.Message); Utils.Logger.Error(fex.ToString()); } catch (Exception ex) { bgWait.ReportProgress(102, ex.Message); Utils.Logger.Error(ex.ToString()); } bgWait.ReportProgress(100); }
/// <summary> /// 异步事务工作事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void BGW2_DoWork(object sender, DoWorkEventArgs e) { BGW2.ReportProgress(0); try { switch (e.Argument.ToString()) { case "SearchData": int CurrPage = (int)page.CurrentPage; int PageSize = (int)page.PageSize; Tuple <string, object[]> tWhere = null; //if (SeeKTextEdit.Text.IsNullOrEmpty() == false) //{ // //string strWhere = "1=1 and (DevCode.Contains(@0) or DevCCode.Contains(@0) or DevName.Contains(@0)) "; // //tWhere = Tuple.Create<string, object[]>(strWhere, new object[] { SeeKTextEdit.Text }); //} Tuple <StringBuilder, List <object> > dtFilter = Tuple.Create <StringBuilder, List <object> >(new StringBuilder(), new List <object>()); dtFilter.Item1.Append("1 = 1"); FilterProcess.MergeFilterCondition("DevCCode", DevCCodeTextEdit.Text, ref dtFilter); FilterProcess.MergeFilterCondition("DevCode", DevCodeTextEdit.Text, ref dtFilter, "like"); FilterProcess.MergeFilterCondition("DevName", DevNameTextEdit.Text, ref dtFilter, "like"); using (SRDevice.DeviceServiceClient client = new SRDevice.DeviceServiceClient()) { //var ret = client.GetDevicePagedList(context.SessionID, tWhere, PageSize, CurrPage); var ret = client.GetDevicePagedList(context.SessionID, Tuple.Create <string, object[]>(dtFilter.Item1.ToString(), dtFilter.Item2.ToArray()), PageSize, CurrPage); if (ret.IsSuccess) { page.CurrentPage = CurrPage; page.RowCount = ret.TotalNum; e.Result = ret.Data; } else { BGW2.ReportProgress(101, ret.Message); } } break; default: break; } } catch (Exception ex) { BGW2.ReportProgress(101, ex.Message); } BGW2.ReportProgress(100); }
private void BgWait1_DoWork(object sender, DoWorkEventArgs e) { BgWait1.ReportProgress(0); try { switch (e.Argument.ToString()) { case "SearchData": Tuple <StringBuilder, List <object> > dtFilter = Tuple.Create <StringBuilder, List <object> >(new StringBuilder(), new List <object>()); dtFilter.Item1.Append("1=1"); FilterProcess.MergeFilterCondition("ArrangedVouchCode", textEdit1.EditValue, ref dtFilter); FilterProcess.MergeFilterCondition("MaterialVouchCode", textEdit2.EditValue, ref dtFilter); FilterProcess.MergeFilterCondition("FormulaCode", textEdit3.EditValue, ref dtFilter); FilterProcess.MergeFilterCondition("FormulaName", textEdit4.EditValue, ref dtFilter); FilterProcess.MergeFilterCondition("UserStatus", Convert.ToInt32(UseStatusLookUpEdit.EditValue), ref dtFilter, dataType: FilterProcess.DataType.Int); FilterProcess.MergeFilterCondition("VouchDate", dStartDate.EditValue, ref dtFilter, objValues1: dEndDate.EditValue, dataType: FilterProcess.DataType.DateTime); //按日期区间查询 int iCurrPage = (int)page.CurrentPage; int iPageSize = (int)page.PageSize; //using (var client = new SRArrangedVouch.ArrangedVServiceClient()) //{ var ret = WCFHelper.InvokeService <SRArrangedVouch.IArrangedVServiceChannel, SRArrangedVouch.CommonResultOfArrayOfArrangedVouchdYMi5huk>(context, wcf => wcf.GetArrangedVouchList(context.SessionID, Tuple.Create <string, object[]>(dtFilter.Item1.ToString(), dtFilter.Item2.ToArray()), iPageSize, iCurrPage)); //var ret = client.GetArrangedVouchList(context.SessionID, Tuple.Create<string, object[]>(dtFilter.Item1.ToString(), dtFilter.Item2.ToArray()), iPageSize, iCurrPage); if (ret.IsSuccess) { page.CurrentPage = iCurrPage; page.RowCount = ret.TotalNum; e.Result = ret.Data; } else { BgWait1.ReportProgress(101, ret.Message); } // } break; default: break; } } catch (Exception ex) { BgWait1.ReportProgress(102, ex.Message); } BgWait1.ReportProgress(100); }
private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e) { backgroundWorker1.ReportProgress(0); try { switch (e.Argument.ToString()) { case "SearchData": Tuple <StringBuilder, List <object> > dtFilter = Tuple.Create <StringBuilder, List <object> >(new StringBuilder(), new List <object>()); dtFilter.Item1.Append("1=1"); if (TE_DeveCode.Text != "") { FilterProcess.MergeFilterCondition("DeveCode", TE_DeveCode.Text, ref dtFilter, dataType: FilterProcess.DataType.Int); } FilterProcess.MergeFilterCondition("PDevCode", TE_PDevCode.Text, ref dtFilter); FilterProcess.MergeFilterCondition("DevpCode", TE_DevpCode.Text, ref dtFilter); FilterProcess.MergeFilterCondition("DeviCode", TE_DeviCode.Text, ref dtFilter); int iCurrPage = (int)page.CurrentPage; int iPageSize = (int)page.PageSize; using (var client = new DeviceCollectServiceClient()) { var ret = client.GetCollectDataPagedList(context.SessionID, Tuple.Create <string, object[]>(dtFilter.Item1.ToString(), dtFilter.Item2.ToArray()), iPageSize, iCurrPage); if (ret.IsSuccess) { page.CurrentPage = iCurrPage; page.RowCount = ret.TotalNum; e.Result = ret.Data; } else { backgroundWorker1.ReportProgress(101, ret.Message); } } break; default: break; } } catch (System.ServiceModel.FaultException <LY.MES.WFCL.SRDataColl.CustomFaultMessage> fex) { backgroundWorker1.ReportProgress(102, fex.Message); Utils.Logger.Error(fex.ToString()); } catch (Exception ex) { backgroundWorker1.ReportProgress(102, ex.Message); Utils.Logger.Error(ex.ToString()); } backgroundWorker1.ReportProgress(100); }
/// <summary> /// 线程控件响应事件,只需响应搜索事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void BgWait1_DoWork(object sender, DoWorkEventArgs e) { BgWait1.ReportProgress(0); try { switch (e.Argument.ToString()) { case "SearchData": Tuple <StringBuilder, List <object> > dtFilter = Tuple.Create <StringBuilder, List <object> >(new StringBuilder(), new List <object>()); dtFilter.Item1.Append("1=1"); FilterProcess.MergeFilterCondition("DevCode", textEdit1.EditValue, ref dtFilter); FilterProcess.MergeFilterCondition("DevpCode", textEdit2.EditValue, ref dtFilter, strCompare: "like"); FilterProcess.MergeFilterCondition("DeviCode", textEdit3.EditValue, ref dtFilter); int iCurrPage = (int)page.CurrentPage; int iPageSize = (int)page.PageSize; using (var client = new SRExcute.DevExecuteServiceClient()) { var ret = client.GetDevExecutePagedList(context.SessionID, Tuple.Create <string, object[]>(dtFilter.Item1.ToString(), dtFilter.Item2.ToArray()), iPageSize, iCurrPage); if (ret.IsSuccess) { page.CurrentPage = iCurrPage; page.RowCount = ret.TotalNum; e.Result = ret.Data; } else { BgWait1.ReportProgress(101, ret.Message); } } break; default: break; } } catch (Exception ex) { BgWait1.ReportProgress(102, ex.Message); } BgWait1.ReportProgress(100); }
private void GetPipelineOpereate(string PipelineCode) { try { using (var client = new SRPiPeline.PipelineServiceClient()) { var ret = client.GetDaviceInformation(context.SessionID, "06", PipelineCode); if (ret.IsSuccess) { Model = new SRPiPeline.MainPipelineInfo(); Model.Operator = context.UserName; Model.Creator = context.UserName; //mainPipelineInfoBindingSource.DataSource = Model; Model.DeveCode = ret.Data.DevCode; Model.DeveName = ret.Data.DevName; mainPipelineInfoBindingSource.DataSource = Model; int iCurrPage = 0; int iPageSize = 0; Tuple <StringBuilder, List <object> > dtFilter = Tuple.Create <StringBuilder, List <object> >(new StringBuilder(), new List <object>()); dtFilter.Item1.Append("1 = 1"); FilterProcess.MergeFilterCondition("DeveCode", ret.Data.DevCode, ref dtFilter); var mp_ret = client.GetOperatingRecord(context.SessionID, Tuple.Create <string, object[]>(dtFilter.Item1.ToString(), dtFilter.Item2.ToArray()), iCurrPage, iPageSize); if (mp_ret.IsSuccess && mp_ret.Data.Count() > 0) { // PipelineStatusTextEdit.Properties.ReadOnly = true; Model.PipelineStatus = mp_ret.Data.First(t => t.OperatingTime < DateTime.Now).PipelineStatus; //if (PipelineStatusTextEdit.Text == "管道打开") //{ // Model.PromptDes = "管道关闭"; //} //else if (PipelineStatusTextEdit.Text == "管道关闭") //{ // Model.PromptDes = "管道打开"; //} mainPipelineInfoBindingSource.DataSource = Model; } } else { ClsMsg.ShowInfoMsg(ret.Message); } } } catch (Exception ex) { Utils.Logger.Error(ex.ToString()); ClsMsg.ShowErrMsg(ex.Message); } }
/// <summary> /// 异步事务工作事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void bgwWait_DoWork(object sender, DoWorkEventArgs e) { bgwWait.ReportProgress(0); try { switch (e.Argument.ToString()) { case "SearchData": Tuple <StringBuilder, List <object> > dtFilter = Tuple.Create <StringBuilder, List <object> >(new StringBuilder(), new List <object>()); dtFilter.Item1.Append("1=1"); FilterProcess.MergeFilterCondition("DevCode", txtDevCode.EditValue, ref dtFilter); FilterProcess.MergeFilterCondition("DevName", txtDevName.EditValue, ref dtFilter, strCompare: "like"); FilterProcess.MergeFilterCondition("DevCCode", txtDevCCode.EditValue, ref dtFilter); int iCurrPage = (int)page.CurrentPage; int iPageSize = (int)page.PageSize; using (var client = new SRDevice.DeviceServiceClient()) { var ret = client.GetVDeviceInfoPagedList(context.SessionID, Tuple.Create <string, object[]>(dtFilter.Item1.ToString(), dtFilter.Item2.ToArray()), iPageSize, iCurrPage); if (ret.IsSuccess) { page.CurrentPage = iCurrPage; page.RowCount = ret.TotalNum; e.Result = ret.Data; } else { bgwWait.ReportProgress(101, ret.Message); } } break; default: break; } } catch (System.ServiceModel.FaultException <SRDevice.CustomFaultMessage> fex) { bgwWait.ReportProgress(102, fex.Message); Utils.Logger.Error(fex.ToString()); } catch (Exception ex) { bgwWait.ReportProgress(102, ex.Message); Utils.Logger.Error(ex.ToString()); } bgwWait.ReportProgress(100); }
private void BgWait1_DoWork(object sender, DoWorkEventArgs e) { BgWait1.ReportProgress(PubConstant.WaitMessageStatus.START); try { switch (e.Argument.ToString()) { case "SearchData": Tuple <StringBuilder, List <object> > dtFilter = Tuple.Create <StringBuilder, List <object> >(new StringBuilder(), new List <object>()); dtFilter.Item1.Append("1=1"); FilterProcess.MergeFilterCondition("FLVCode", textEdit1.EditValue, ref dtFilter, strCompare: "like"); FilterProcess.MergeFilterCondition("CreateDate", dateEdit1.EditValue, ref dtFilter, dataType: FilterProcess.DataType.Date, strCompare: ">="); int iCurrPage = (int)page.CurrentPage; int iPageSize = (int)page.PageSize; using (var client = new SRFindLeak.QCDFindLeakServiceClient()) { var ret = client.GetQCDrumsFindLeakList(context.SessionID, Tuple.Create <string, object[]>(dtFilter.Item1.ToString(), dtFilter.Item2.ToArray()), iPageSize, iCurrPage); if (ret.IsSuccess) { page.CurrentPage = iCurrPage; page.RowCount = ret.TotalNum; e.Result = ret.Data; } else { BgWait1.ReportProgress(101, ret.Message); } } break; default: break; } } catch (Exception ex) { BgWait1.ReportProgress(PubConstant.WaitMessageStatus.ERROR, ex.Message); } BgWait1.ReportProgress(100); }
private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e) { backgroundWorker1.ReportProgress(0); try { switch (e.Argument.ToString()) { case "SearchData": int CurrPage = (int)page.CurrentPage; int PageSize = (int)page.PageSize; //Tuple<string, object[]> tWhere = null; //if (ChecktextEdit.Text.IsNullOrEmpty() == false) //{a // string strWhere = "1=1 and ( 明细ID.Contains(@0) ) "; // tWhere = Tuple.Create<string, object[]>(strWhere, new object[] { ChecktextEdit.Text });ref int iTotalNum //} var dtWhere = FilterProcess.CreateFilterTable(); FilterProcess.MergeFilterCondition("明细ID", ChecktextEdit.Text, ref dtWhere, strCompare: "like"); using (SRQZData.QZDataServiceClient client = new SRQZData.QZDataServiceClient()) { int TotalNum = 0; var ret = client.GetOrderSchData(context.SessionID, dtWhere, PageSize, CurrPage, ref TotalNum); page.CurrentPage = CurrPage; page.RowCount = TotalNum; e.Result = ret; } break; default: break; } } catch (Exception ex) { backgroundWorker1.ReportProgress(102, ex.Message); } backgroundWorker1.ReportProgress(100); }