using Core.Mes.Client.Comm.Control; using Core.Mes.Client.Comm.Format; using Core.Mes.Client.Comm.Server; using Core.Mes.Client.Comm.Tool; using Core.StlMes.Client.Judge.Commons; using Core.StlMes.Client.Judge.Models; using Core.StlMes.Client.Judge.ViewModels; using CoreFS.CA06; using Infragistics.Win; using Infragistics.Win.UltraWinEditors; using Infragistics.Win.UltraWinGrid; using System; using System.Collections; using System.Collections.Generic; using System.Data; using System.Diagnostics; using System.Drawing; using System.Drawing.Printing; //using Spire.Pdf; using System.IO; using System.Linq; using System.Net; using System.Windows.Forms; //using Core.StlMes.Client.ZGMil.Signature; namespace Core.StlMes.Client.Judge.Forms { public partial class QcmJyThreadReport : FrmBase { private String OrderNo; public QcmJyThreadReport() { InitializeComponent(); this.IsLoadUserView = true; } private void QcmJyQueryFrm_Load(object sender, EventArgs e) { InitDate(); EntityHelper.ShowGridCaption(ultraGridOrder.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGridThread1.DisplayLayout.Bands[0]); DoQuery(); initResult(); } private void initResult() { //初始化加载设备仪器 DataTable dt1 = ServerHelper.GetData("com.steering.pss.judge.DAL.QcmJyEquipment.FindEquipmentInResult", new object[] { "螺纹量规" }, ob); threadReport1.ultraComboEditor1.DataSource = dt1; threadReport1.ultraComboEditor1.DisplayMember = "RESULT"; threadReport1.ultraComboEditor1.ValueMember = "RESULT"; DataTable dt2 = ServerHelper.GetData("com.steering.pss.judge.DAL.QcmJyEquipment.FindEquipmentInResult", new object[] { "游标卡尺" }, ob); threadReport1.ultraComboEditor2.DataSource = dt2; threadReport1.ultraComboEditor2.DisplayMember = "RESULT"; threadReport1.ultraComboEditor2.ValueMember = "RESULT"; DataTable dt3 = ServerHelper.GetData("com.steering.pss.judge.DAL.QcmJyEquipment.FindEquipmentInResult", new object[] { "深度卡尺" }, ob); threadReport1.ultraComboEditor3.DataSource = dt3; threadReport1.ultraComboEditor3.DisplayMember = "RESULT"; threadReport1.ultraComboEditor3.ValueMember = "RESULT"; DataTable dt4 = ServerHelper.GetData("com.steering.pss.judge.DAL.QcmJyEquipment.FindEquipmentInResult", new object[] { "测厚仪" }, ob); threadReport1.ultraComboEditor4.DataSource = dt4; threadReport1.ultraComboEditor4.DisplayMember = "RESULT"; threadReport1.ultraComboEditor4.ValueMember = "RESULT"; DataTable dt5 = ServerHelper.GetData("com.steering.pss.judge.DAL.QcmJyEquipment.FindEquipmentInResult", new object[] { "锥度量规" }, ob); threadReport1.ultraComboEditor5.DataSource = dt5; threadReport1.ultraComboEditor5.DisplayMember = "RESULT"; threadReport1.ultraComboEditor5.ValueMember = "RESULT"; DataTable dt6 = ServerHelper.GetData("com.steering.pss.judge.DAL.QcmJyEquipment.FindEquipmentInResult", new object[] { "齿高量规" }, ob); threadReport1.ultraComboEditor6.DataSource = dt6; threadReport1.ultraComboEditor6.DisplayMember = "RESULT"; threadReport1.ultraComboEditor6.ValueMember = "RESULT"; DataTable dt7 = ServerHelper.GetData("com.steering.pss.judge.DAL.QcmJyEquipment.FindEquipmentInResult", new object[] { "齿顶高量规" }, ob); threadReport1.ultraComboEditor7.DataSource = dt7; threadReport1.ultraComboEditor7.DisplayMember = "RESULT"; threadReport1.ultraComboEditor7.ValueMember = "RESULT"; DataTable dt8 = ServerHelper.GetData("com.steering.pss.judge.DAL.QcmJyEquipment.FindEquipmentInResult", new object[] { "顶径量规" }, ob); threadReport1.ultraComboEditor8.DataSource = dt8; threadReport1.ultraComboEditor8.DisplayMember = "RESULT"; threadReport1.ultraComboEditor8.ValueMember = "RESULT"; DataTable dt9 = ServerHelper.GetData("com.steering.pss.judge.DAL.QcmJyEquipment.FindEquipmentInResult", new object[] { "螺距量规" }, ob); threadReport1.ultraComboEditor9.DataSource = dt9; threadReport1.ultraComboEditor9.DisplayMember = "RESULT"; threadReport1.ultraComboEditor9.ValueMember = "RESULT"; } private void ChcCheckedChanged(object sender, EventArgs e) { if (ChcOrderNo.Checked) { TxtOrderNo.Enabled = true; } else { TxtOrderNo.Enabled = false; } if (ChcTime.Checked) { TimeBegin.Enabled = true; TimeEnd.Enabled = true; } else { TimeEnd.Enabled = false; TimeBegin.Enabled = false; } if (ChcStatus.Checked) { ComStatus.Enabled = true; } else { ComStatus.Enabled = false; } } /// /// 初始时间 /// private void InitDate() { DateTime now = DateTime.Now; DateTime dt1 = new DateTime(now.Year, now.Month, 1);//当月第一天 DateTime dt2 = dt1.AddMonths(1).AddDays(-1);//当月最后一天 TimeBegin.Value = DateTime.Parse(dt1.ToString("yyyy-MM-dd") + " 00:00:00"); TimeEnd.Value = DateTime.Parse(dt2.ToString("yyyy-MM-dd") + " 23:59:59"); } public override void ToolBar_Click(object sender, string ToolbarKey) { switch (ToolbarKey) { case "Query": DoQuery(); initResult(); break; case "Update": DoUpdate(); break; case "Delete": Delete(); break; case "doAdd": DoAdd(); break; case "Close": this.Close(); break; } } private ArrayList ingname = new ArrayList(); //新增下表记录 private void DoAdd() { threadReport1.ultraGrid1.UpdateData(); UltraGridRow ugr = threadReport1.ultraGrid1.ActiveRow; ArrayList parmList = new ArrayList(); QcmJyThreadReportEntity thread = (QcmJyThreadReportEntity)ugr.ListObject; string threadTity = JSONFormat.Format(thread); parmList.Add(threadTity); ArrayList param = new ArrayList(); param.Add(OrderNo); List listSource = EntityHelper.GetData( "com.steering.pss.judge.DAL.QcmJyThreadReport.FindThreadReport", new object[] { param }, this.ob); if (listSource.Count== 0) { int count = ServerHelper.SetData("com.steering.pss.judge.DAL.QcmJyThreadReport.AddThreadReport", new object[] { parmList }, ob); if (count > 0) { MessageUtil.ShowTips("新增螺纹检验信息成功！"); DoQuery(); } else { MessageUtil.ShowTips("新增失败!"); return; } }else{ MessageUtil.ShowTips("新增失败，该合同号已有螺纹检验信息，不可重复添加,请尝试一下修改哦！"); return; } } public string spathName = ""; private List ing = new List(); private List list = new List(); /// /// 修改下表记录 /// private void DoUpdate() { threadReport1.ultraGrid1.UpdateData(); UltraGridRow ugr = threadReport1.ultraGrid1.ActiveRow; ArrayList parmList = new ArrayList(); QcmJyThreadReportEntity thread = (QcmJyThreadReportEntity)ugr.ListObject; string threadTity = JSONFormat.Format(thread); parmList.Add(threadTity); int count = ServerHelper.SetData("com.steering.pss.judge.DAL.QcmJyThreadReport.UpdateThreadReport", new object[] { parmList }, ob); if (count > 0) { MessageUtil.ShowTips("修改成功！"); DoQuery(); } else { MessageUtil.ShowTips("修改失败！"); return; } } /// /// 删除下表记录 /// private void Delete() { ultraGridThread1.UpdateData(); ArrayList pram1 = new ArrayList(); //获取已选择的列 //IQueryable uGrid = ultraGridThread1.Rows.AsQueryable().Where(" CHK = 'True'"); //if (uGrid.Count() == 0) //{ // MessageUtil.ShowTips("请选择要删除的数据！"); // return; //} if (MessageUtil.ShowYesNoAndQuestion("是否确认删除该条螺纹检验报告信息？") == System.Windows.Forms.DialogResult.No) { return; } //foreach (UltraGridRow ugr in uGrid) //{ ArrayList pram = new ArrayList(); pram.Add(OrderNo); pram1.Add(pram);//由于合同号与螺纹信息 属于一对一关系 合同号为一开始选择的合同号/ //} int countinsert = ServerHelper.SetData("com.steering.pss.judge.DAL.QcmJyThreadReport.deleteThreadReport", new Object[] { pram1 }, this.ob); if (countinsert > 0) { MessageUtil.ShowTips("删除成功！"); } else { MessageUtil.ShowTips("删除失败！,请联系编程人员"); return; } DoQuery(); } /// /// 查询上表信息 /// private void DoQuery() { ArrayList param = new ArrayList(); string orderNo = ""; if (ChcOrderNo.Checked) { orderNo = TxtOrderNo.Text.Trim(); } string strBegin = "1900-01-01 00:00:00"; string strEnd = "9900-01-01 00:00:00"; if (ChcTime.Checked) { if (TimeBegin.Value == null || TimeEnd.Value == null) { MessageUtil.ShowWarning("请选择正确的时间"); return; } strBegin = TimeBegin.Value.ToString(); strEnd = TimeEnd.Value.ToString(); } param.Add(orderNo); param.Add(strBegin); param.Add(strEnd); if (ultraTabControl2.SelectedTab.Index == 0) { List listSource = EntityHelper.GetData( "com.steering.pss.judge.DAL.QcmJyQueryFrm.getOrderInfo", new object[] { param }, this.ob);//查找合同信息 ydmZcOutlistEntityBindingSource1.DataSource = listSource; } } /// /// 根据出库表去查询螺纹表信息 多个记录 /// /// private void QueryThreadReportInfobyQcmJyQueryFrm(string orderNo) { ultraGridThread1.UpdateData(); ArrayList param = new ArrayList(); param.Add(orderNo); List listSource = EntityHelper.GetData( "com.steering.pss.judge.DAL.QcmJyThreadReport.FindThreadReport", new object[] { param }, this.ob); List listSource2 = EntityHelper.GetData( "com.steering.pss.judge.DAL.QcmJyThreadReport.FindThreadReport", new object[] { param }, this.ob); //将信息赋值到下表 QcmJyThreadReportEntityBindingSource1.DataSource = listSource; //将信息赋值到中表 threadReport1.qcmJyThreadReportEntityBindingSource.DataSource = listSource2; QcmJyThreadReportEntity thread = new QcmJyThreadReportEntity(); if (listSource.Count < 1) {//如果数据库中没有螺纹信息记录 则创建合同号 根据上表所选中的合同号 thread.OrderNo = OrderNo; threadReport1.qcmJyThreadReportEntityBindingSource.DataSource = new List() { thread }; } } DataTable dtzbs = new DataTable(); //单击上表 行的事件 根据合同号查找螺纹信息 private void ultraGridOrder_AfterRowActivate_1(object sender, EventArgs e) { UltraGridRow ugr = ultraGridOrder.ActiveRow; if (ugr == null) { return; } OrderNo = ugr.Cells["OrderNo"].Text.ToString(); QueryThreadReportInfobyQcmJyQueryFrm(OrderNo); } private void ultraGridThread1_AfterRowActivate(object sender, EventArgs e) { UltraGridRow ug = ultraGridThread1.ActiveRow; if (ug == null) { return; } //将下表信息选中的信息赋值给中表 编辑 // threadReport1.qcmJyThreadReportEntityBindingSource.DataSource = new List() { ultraGridThread1.ActiveRow.ListObject as QcmJyThreadReportEntity }; } private void ultraGridThread1_MouseDown(object sender, MouseEventArgs e) { //UltraGridRow ug = ultraGridThread1.ActiveRow; //if (ug == null) //{ // return; //} ////将下表信息选中的信息赋值给中表 编辑 //threadReport1.qcmJyThreadReportEntityBindingSource.DataSource = new List() { ultraGridThread1.ActiveRow.ListObject as QcmJyThreadReportEntity }; } /// /// 按回车键触发查询按钮 /// /// /// private void ContPublic_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { DoQuery(); } } private int splitterDistance = 0; private void ultraExpandableGroupBox1_ExpandedStateChanged(object sender, EventArgs e) { if (ultraExpandableGroupBox1.Expanded == false) { this.splitContainer2.SplitterDistance = splitContainer2.Size.Height - 26; } else { this.splitContainer2.SplitterDistance = splitterDistance == 0 ? splitContainer2.Size.Height / 2 : splitterDistance; } } private void threadReport2_Load_1(object sender, EventArgs e) { GridHelper.SetAllColumnsActive(ultraGridThread1); } private void ultraGridThread1_AfterSelectChange(object sender, AfterSelectChangeEventArgs e) { //foreach (UltraGridRow uRow in ultraGridThread1.Selected.Rows) //{ // if (uRow.GetType() != typeof(Infragistics.Win.UltraWinGrid.UltraGridGroupByRow)) // { // uRow.Cells["CHC"].Value = true; // } //} } } }