using Core.Mes.Client.Comm.Control; using Core.StlMes.Client.Judge.Commons; using CoreFS.CA06; using CoreFS.SA06; using Infragistics.Win.UltraWinGrid; using System; using System.Data; using System.Drawing; using System.Windows.Forms; namespace Core.StlMes.Client.Judge.Controls { public partial class QcmGpPassApplyCtrl : UserControl { private Dal _d; private OpeBase ob; private string[] _validDataPurviewIds; public QcmGpPassApplyCtrl(Control container, OpeBase ob, string[] validDataPurviewIds) { InitializeComponent(); _d = new Dal(ob); this.ob = ob; _validDataPurviewIds = validDataPurviewIds; container.Controls.Add(this); this.Dock = DockStyle.Fill; this.BringToFront(); } public void Query(string stoveNo, string judgeStoveNo, string timeB, string timeE, string validflag) { DataTable dt = _d.GetTableByXmlId("QcmGpPassApplyDAL.query", stoveNo, judgeStoveNo, timeB, timeE, validflag); GridHelper.CopyDataToDatatable(dt, dataTable1, true); GridHelper.RefreshAndAutoSize(ultraGrid1); } public void AuditeQuery(string stoveNo, string judgeStoveNo, string timeB, string timeE, string customInfo, string auditState, string validflag,string supplyUnit) { DataTable dt; dt = _d.GetTableByXmlId("QcmGpPassApplyDAL.auditeQuery", stoveNo, judgeStoveNo, timeB, timeE, auditState, customInfo, validflag, CoreUserInfo.UserInfo.GetUserName(), _validDataPurviewIds, supplyUnit); GridHelper.CopyDataToDatatable(dt, dataTable1, true); GridHelper.RefreshAndAutoSize(ultraGrid1); // if (customInfo == "Quality1") // { // //string[] zgProPlanId = GetZgPlanId(); // //string designKey = QueryDesignKey(zgProPlanId[0], zgProPlanId[1]); // } // else if (customInfo == "Quality2") // { // dt = _d.GetTableByXmlId("QcmGpPassApplyDAL.auditeQuery2", stoveNo, judgeStoveNo, timeB, timeE, auditState, "0", "1"); // GridHelper.CopyDataToDatatable(dt, dataTable1, true); // }else if (customInfo == "Urgent1") //{ // string[] zgProPlanId = GetZgPlanId(); // string designKey = QueryDesignKey(zgProPlanId[0], zgProPlanId[1]); // dt = _d.GetTableByXmlId("QcmGpPassApplyDAL.auditeQuery", stoveNo, judgeStoveNo, timeB, timeE, auditState, // CoreUserInfo.UserInfo.GetUserName(), _validDataPurviewIds.Length, _validDataPurviewIds, "1", "1"); // GridHelper.CopyDataToDatatable(dt, dataTable1, true); // } // else if (customInfo == "Urgent2") // { // dt = _d.GetTableByXmlId("QcmGpPassApplyDAL.auditeQuery2", stoveNo, judgeStoveNo, timeB, timeE, auditState, "1", "1"); // GridHelper.CopyDataToDatatable(dt, dataTable1, true); // } } private string[] GetZgPlanId() { var row = ultraGrid1.ActiveRow; if (row == null) return new string[] { "", "" }; DataRow drGpApply = _d.GetRowByXmlId("QcmGpJugdeApplyDAL.QueryByPk", row.GetValue("jugdeApplyCode"), row.GetValue("jugdeApplySqe"), row.GetValue("multipleNum"), row.GetValue("JudgeStoveNo")); if (drGpApply == null) return new string[] { "", "" }; string zgProPlanId = ""; string zgGxPlanNo = ""; if (drGpApply["proPlanIdNext"].ToString() != "" && drGpApply["proPlanIdNext"].ToString().StartsWith("ZG")) { zgProPlanId = drGpApply["proPlanIdNext"].ToString(); zgGxPlanNo = drGpApply["gxPlanNoNext"].ToString(); } else { string zzProPlanId = ""; if (drGpApply["proPlanIdNext"].ToString() != "") { zzProPlanId = drGpApply["proPlanIdNext"].ToString(); } else { zzProPlanId = drGpApply["proPlanId"].ToString(); } DataRow drOrderZgS = _d.GetRowByXmlId("JdgPlnOrderZgS.queryByGpreqId", zzProPlanId); if (drOrderZgS == null) return new string[] { "", "" }; zgProPlanId = drOrderZgS["proPlanId"].ToString(); zgGxPlanNo = drOrderZgS["gxPlanNo"].ToString(); } return new string[] { zgProPlanId, zgGxPlanNo }; } private string QueryDesignKey(string zgProPlanId, string zgGxPlanNo) { DataRow drDesignKey = _d.GetRowByXmlId("QcmGpJugdeApplyDAL.queryCraftDesignKey", zgProPlanId, zgGxPlanNo); if (drDesignKey == null) { return ""; } else { return drDesignKey["desginKey"].ToString(); } } private void ultraGrid1_CellChange(object sender, Infragistics.Win.UltraWinGrid.CellEventArgs e) { e.Cell.Row.Update(); } private void ultraGrid1_InitializeRow(object sender, Infragistics.Win.UltraWinGrid.InitializeRowEventArgs e) { Color yellow = Color.FromArgb(238, 238, 0); Color red = Color.FromArgb(255, 106, 106); Color green = Color.FromArgb(60, 179, 113); if (e.Row.GetValue("validflag") == "0") { e.Row.RowSelectorAppearance.BackColor = Color.Red; } if (e.Row.GetValue("auditResult") == "审核通过" && e.Row.GetValue("auditResult2") == "审核通过") { e.Row.RowSelectorAppearance.BackColor = green; } else if (e.Row.GetValue("auditResult") == "审核通过" && e.Row.GetValue("auditResult2") == "") { e.Row.RowSelectorAppearance.BackColor = yellow; } else if (e.Row.GetValue("auditResult") == "审核不通过" || e.Row.GetValue("auditResult2") == "审核不通过") { e.Row.RowSelectorAppearance.BackColor = red; } } FormFileDown askDown; private void ultraTextEditor1_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e) { string filePath = ultraGrid1.ActiveRow.GetValue("craftPath"); askDown = new FormFileDown(ob, filePath); askDown.DeleteButton.Visible = false; askDown.Show(); } private void ultraGrid1_MouseUp(object sender, MouseEventArgs e) { foreach (UltraGridRow row in ultraGrid1.Rows) { if (row.Selected) { row.Cells["CHK"].Value = true; } } ultraGrid1.UpdateData(); } } }