public MainForm() { InitializeComponent(); btSearchPlan.Click += btSearchPlan_Click; btCreateByGate.Click += btCreateByGate_Click; butTransportPlan.Click += butTransportPlan_Click; this.btDelete.Click += btDelete_Click; btReturn.Click += btReturn_Click; butAddGatePlan.Click += butAddGatePlan_Click; WorkSpace.Show(_QueryReceivePlan); // SearchVoucherReceive(); step = Step.QueryPlanStep; // _QueryReceivePlan.MaterialSource = GetMaterialList; DataTable dtSample = report.GetQCReport("QC22_SamplesByCategory", new[] { "TypeID", "Lang" }, new object[] { "3", MyLanguage.Language }).Tables[0];; _QueryReceivePlan.SetSamples = dtSample; _GatePlanFrm.SetSamples = dtSample; //QC02_QueryMaterialList //GetMaterialList = report.GetQCReport("Q_Materials", new string[] { "SampleName", "Query" }, // new object[] { _GatePlanFrm.SelectSampleName, "S" }).Tables[0]; // _GatePlanFrm.MaterialSource = GetMaterialList; #region language try { CultureLanuage.ApplyResourcesFrom(this, "QC22", this.Name); } catch (Exception ex) { Console.WriteLine(ex); } #endregion }
private void Init_Load() { #region Language try { CultureLanuage.ApplyResourcesFrom(this, "QC21", "QC21"); CultureLanuage.ApplyResourcesFrom(_QC21Dialog, "QC21", "QC21Dialog"); CultureLanuage.ApplyResourcesFrom(_AddPlan, "QC21", "AddPlan"); ChangeGridViewLanguage("gridView1"); } catch (Exception ex) { Console.WriteLine(ex); MessageBox.Show("Translate error:" + ex.Message); } #endregion _AddPlan.AddPlan_cmbSample_SelectedIndexChanged += AddPlan_cmbSample_SelectedIndexChanged; // _AddPlan.MaterialSource = GetMaterials(_AddPlan.SampleName); _QC21View.eventSampleMaterial += new EventHandler(qC21View_eventSampleMaterial); _QC21View.eventMaterialGetPlan += new EventHandler(qC21View_eventMaterialGetPlan); //成品 工序 _QC21View.InitForm(); _AddPlan.dtListTypeName = report.GetQCReport("QCW1_QueryTypeName", new[] { "Lang" }, new object[] { MyLanguage.Language }).Tables[0]; _QC21View.dtListTypeName = report.GetQCReport("QCW1_QueryTypeName", new[] { "Lang" }, new object[] { MyLanguage.Language }).Tables[0]; WorkSpace.Show(_QC21View); }
public void Query() { MainMsg = ""; _QA23View.tablePlanADD = report.GetQCReport("QA23_QueryAddPlan", new string[] { "SampleName", "Material" }, new object[] { _QA23View.Sample, _QA23View.Materials }).Tables[0]; }
void MainForm_Load(object sender, EventArgs e) { btSearchSure.Click += new EventHandler(btSearchSure_Click); btVouSubmit.Click += new EventHandler(btVouSubmit_Click); btVouRelease.Click += new EventHandler(btVouRelease_Click); cmbTypeName.SelectionChangeCommitted += cmbTypeName_SelectionChangeCommitted; cmbSampleName.EditValueChanged += cmbSampleName_EditValueChanged; gridView1.Click += new EventHandler(gridView1_Click); dtListTypeName = report.GetQCReport("QCW1_QueryTypeName", new[] { "Lang" }, new object[] { MyLanguage.Language }).Tables[0]; }
/// <summary> /// 加载属性 /// </summary> /// <param name="voucherId"></param> public void FillProfile() { DataTable tableVoucher = report.GetQCReport("QE31_QueryDocByVoucherId", new string[] { "voucherId" }, new object[] { VoucherID }).Tables[0]; if (tableVoucher.Rows.Count > 0) { DataRow row = tableVoucher.Rows[0]; var DtPropertys = _DOCBiz.GetvProperties(VoucherID); gridControl2.DataSource = DtPropertys; foreach (DataRow dr in DtPropertys.Rows) { if (dr["MaxValue"].ToString().Length > 0 && dr["MinValue"].ToString().Length > 0 && dr["Prec"].ToString().Length > 0) { dr["MaxValue"] = decimal.Round(decimal.Parse(dr["MaxValue"].ToString()), Convert.ToInt32(dr["Prec"].ToString())); dr["MinValue"] = decimal.Round(decimal.Parse(dr["MinValue"].ToString()), Convert.ToInt32(dr["Prec"].ToString())); } } DtPropertys.AcceptChanges(); foreach (DevExpress.XtraGrid.Columns.GridColumn coulun in gridView2.Columns) { if (coulun.FieldName != "RealResult") { coulun.AppearanceCell.BackColor = Color.LightGray; coulun.OptionsColumn.AllowEdit = false; } } } else { gridControl2.DataSource = new DataTable(); } gridView2.BestFitColumns(); }
private void cmbTypeName_SelectionChangeCommitted(object sender, EventArgs e) { Console.WriteLine("select type"); QCReporting report = new QCReporting(); SetSamples = report.GetQCReport("Q_SamplesByCategory", new[] { "TypeID" }, new object[] { Catelag }).Tables[0]; }
public void LogsSource(PlanTimeJob plan) { gridControl1.DataSource = report.GetQCReport("QP01_QueryGetScheduleLog", new string[] { "ID", "ScheduleUID" }, new object[] { plan.JobID, plan.ScheduleUID }).Tables[0]; gridView1.Columns["Stamp"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.DateTime; gridView1.Columns["Stamp"].DisplayFormat.FormatString = "dd-MM-yyyy HH:mm:ss"; gridView1.BestFitColumns(); }
public void Query() { DataTable dt = report.GetQCReport("AT01_QueryGetAll", new string[] { "LabID", "TypeID", "SampleName", "Lang" }, new object[] { _AT01View.LabID, _AT01View.TypeID, _AT01View.Sample, MIS.Utility.MyLanguage.Language }).Tables[0]; _AT01View.tableMList = dt; }
public void Query() { DataTable dt = report.GetQCReport("MT01_Q_GetMaterial", new string[] { "SampleName", "LOT_NO" }, new object[] { _MT01View.Sample, _MT01View.LOT_NO }).Tables[0]; _MT01View.tableMList = dt; }
private void cmbSampleName_EditValueChanged(object sender, EventArgs e) { //QC02_QueryMaterialList DataTable dt = report.GetQCReport("QC02_QueryMaterialList", new string[] { "SampleName" }, new object[] { SelectSampleName }).Tables[0]; MaterialSource = dt; }
public MainForm() { InitializeComponent(); #region language CultureLanuage.ApplyResourcesFrom(this, "QC07", this.Name); #endregion butReceive.Click += butReceive_Click; this.Load += new System.EventHandler(this.Main_Load); btQuery.Click += btQuery_Click; this.butReturn.Click += butReturn_Click; _SerchPlanView.eventcmbTypeName_SelectedIndexChanged += _SerchPlanView_eventcmbTypeName_SelectedIndexChanged; DataTable DtTypeName = rep.GetQCReport("QCW1_QueryTypeName", new string[] { "Lang" }, new object[] { MyLanguage.Language }).Tables[0]; _SerchPlanView.TypeNameLoad = DtTypeName; dWorkSpace.Show(_SerchPlanView); }
void Init() { btSearchPlan.Click += btSearchPlan_Click; btRecFileUpload.Click += btRecFileUpload_Click; btnDeleteFile.Click += BtnDeleteFile_Click; this.Load += QE31_Load; btEditMaterial.Click += btEditMaterial_Click; btnUploadResult.Click += BtnUploadResult_Click; _QE31Edit.eventShowMessage += (o, s) => { WriteTips(5, (string)o); }; _QE31View.DOCTypeSource = report.GetQCReport("QE31_GetDOCType", new string[] { "Lan" }, new object[] { MIS.Utility.MyLanguage.Language }).Tables[0]; deckWorkspace1.Show(_QE31View); }
void Init_Load() { _SPC1View.LabNameLoad = report.GetQCReport("QCW1_QueryLabName", new string[] { "Lang" }, new object[] { _Language }).Tables[0]; _SPC1View.TypeNameLoad = report.GetQCReport("QCW1_QueryTypeName", new string[] { "Lang" }, new object[] { _Language }).Tables[0]; Workspace.Show(_SPC1View); }
private void cmbTypeName_SelectedIndexChanged(object sender, EventArgs e) { dtListSampleName = report.GetQCReport("GD01_N_GetSampleName", new[] { "LabID", "TypeID", "Language" }, new object[] { LabID, TypeID, MyLanguage.Language }).Tables[0]; }
/// <summary> /// 单据查询 /// </summary> private void SearchConfirm() { PlansTable = rep.GetQCReport("QC06_Query_Plans", new string[] { "deWadat", "deTo", "Catalog", "VoucherID", "Lot_No", "SampleName", "lang" }, new object[] { B, E, Catelag, txtVoucherID.Text.Trim(), this.txtVoucherID.Text.Trim(), this.cmbMaterial.Text.Trim(), this.SampleNameCode, MyLanguage.Language }).Tables[0]; }
public void QueryPlanJob() { PlanTimeJobData = report.GetQCReport("QP01_QueryGetPlanJob", new string[] { "Enable", "Language" }, new object[] { StartEnable, MyLanguage.Language }).Tables[0]; }
public void QueryDraftPlan(string draftid, string voucherid, DateTime DateB, DateTime DateE, string State) { tableDraftList = reports.GetQCReport("QA23_QueryDraftPlan", new string[] { "DraftID", "VoucherID", "DateB", "DateE", "State" }, new object[] { draftid, voucherid, DateB, DateE, State }).Tables[0]; }