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