using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using CoreFS.SA06; using Core.Mes.Client.Comm.Server; using Core.Mes.Client.Comm.Control; using Core.Mes.Client.Comm.Tool; //using Infragistics.Win.UltraWinGrid; using Infragistics.Win.Misc; using CoreFS.CA06; using System.Net; using System.Collections; namespace Core.StlMes.Client.BuyBillet { public partial class RptPVKFSetting : FrmBase { private DataTable dt_pl = new DataTable(); public RptPVKFSetting() { InitializeComponent(); qydate.Value = DateTime.Today; id.Text = ""; fj_id.Text = ""; fgz_id.Text = ""; qz_id.Text = ""; } private void RptPVKFSetting_Load(object sender, EventArgs e) { //mylocations(); clearedit("kf"); clearedit("fj"); clearedit("fgz"); clearedit("qz"); } private void mylocations() { uEGB_kf.Height = 198; uEGB_fj.Height = 198; uEGB_fgz.Height = 228; uEGB_qz.Height = 128; int w, h, ub_top, edge_b = 10; Point mypoint; w = uEGB_kf.Width; h = uEGB_kf.Height; w = Convert.ToInt32(w / 2); ub_top = h - edge_b - uB_savekf.Height; mypoint=new Point( Convert.ToInt32(w / 4) + Convert.ToInt32(uB_savekf.Width / 2),ub_top); uB_savekf.Location = mypoint; mypoint = new Point( Convert.ToInt32(w / 2) + Convert.ToInt32(uB_isvalid.Width / 2), ub_top); uB_isvalid.Location = mypoint; mypoint = new Point(Convert.ToInt32(w / 4 * 3) + Convert.ToInt32(uB_delete.Width / 2), ub_top); uB_delete.Location = mypoint; mypoint = new Point(w + Convert.ToInt32(w / 3) + Convert.ToInt32(uB_addkffj.Width / 2), ub_top); uB_addkffj.Location = mypoint; mypoint = new Point(w + Convert.ToInt32(w / 3 * 2) + Convert.ToInt32(uB_addkffgz.Width / 2), ub_top); uB_addkffgz.Location = mypoint; w = uEGB_fj.Width; h = uEGB_fj.Height; ub_top = h - edge_b - uB_savefj.Height; mypoint = new Point(Convert.ToInt32(w / 4) + Convert.ToInt32(uB_savefj.Width / 2), ub_top); uB_savefj.Location = mypoint; mypoint = new Point(Convert.ToInt32(w / 2) + Convert.ToInt32(uB_isvalidfj.Width / 2), ub_top); uB_isvalidfj.Location = mypoint; mypoint = new Point(Convert.ToInt32(w / 4 * 3) + Convert.ToInt32(uB_deletefj.Width / 2), ub_top); uB_deletefj.Location = mypoint; w = uEGB_fgz.Width; h = uEGB_fgz.Height; ub_top = h - edge_b - uB_savefgz.Height; mypoint = new Point(Convert.ToInt32(w / 4) + Convert.ToInt32(uB_savefgz.Width / 2), ub_top); uB_savefgz.Location = mypoint; mypoint = new Point(Convert.ToInt32(w / 2) + Convert.ToInt32(uB_isvalidfgz.Width / 2), ub_top); uB_isvalidfgz.Location = mypoint; mypoint = new Point(Convert.ToInt32(w / 4 * 3) + Convert.ToInt32(uB_deletefgz.Width / 2), ub_top); uB_deletefgz.Location = mypoint; w = uEGB_qz.Width; h = uEGB_qz.Height; ub_top = h - edge_b - uB_saveqz.Height; mypoint = new Point(Convert.ToInt32(w / 4) + Convert.ToInt32(uB_saveqz.Width / 2), ub_top); uB_saveqz.Location = mypoint; mypoint = new Point(Convert.ToInt32(w / 2) + Convert.ToInt32(uB_isvalidqz.Width / 2), ub_top); uB_isvalidqz.Location = mypoint; mypoint = new Point(Convert.ToInt32(w / 4 * 3) + Convert.ToInt32(uB_deleteqz.Width / 2), ub_top); uB_deleteqz.Location = mypoint; } public override void ToolBar_Click(object sender, string ToolbarKey) { base.ToolBar_Click(sender, ToolbarKey); switch (ToolbarKey) { case "Query": { getkfsetting(); getkfsettingfjx("", "qz"); } break; case "Export": Export(); break; case "Close": this.Close(); break; } } private void Export() { GridHelper.ulGridToExcel(ultraGridkf, "生产流速——扣分"); } private void getkfsetting() { WaitingForm2 wf = new WaitingForm2("正在加载数据,请稍候...."); try { string mytype = uCb_kftype.SelectedIndex==-1?"1":uCb_kftype.SelectedItem.DataValue.ToString(); DataTable dtqry = ServerHelper.GetData("com.steering.rpt.scls.SCLS.getSCLS_KF", new object[] { mytype }, this.ob); dt_pl = ServerHelper.GetData("com.steering.rpt.scls.SCLS.get_pline", new object[] { }, this.ob); wf.Close(); DataTable dt = (DataTable)ultraGridkf.DataSource; if (dt!=null && dt.Rows.Count > 0) dt.Rows.Clear(); ultraGridkf.DataSource = dtqry; setgridcolunmName(ultraGridkf,"kf"); if (dtqry.Rows.Count>0) ultraGridkf.Rows[0].Selected = true; } catch (Exception e) { MessageBox.Show(e.Message); } finally { wf.Close(); } } private void getkfsettingfjx(string id,string fjx) { try { string mytype = id; if (id == "") mytype = uCb_kftype.SelectedIndex == -1 ? "1" : uCb_kftype.SelectedItem.DataValue.ToString(); if (fjx == "fj") { DataTable dtqry = ServerHelper.GetData("com.steering.rpt.scls.SCLS.getSCLS_KFFJX1", new object[] { mytype }, this.ob); DataTable dt = (DataTable)ultraGridkffj.DataSource; if (dt != null && dt.Rows.Count > 0) dt.Rows.Clear(); ultraGridkffj.DataSource = dtqry; setgridcolunmName(ultraGridkffj, fjx); if (dtqry.Rows.Count > 0) ultraGridkffj.Rows[0].Selected = true; else { clearedit(fjx); txt_kftypefj.Text = txt_kftype.Text; lab_kftypefj_name.Text = lab_kftype_name.Text; } } else if (fjx == "fgz") { DataTable dtqry = ServerHelper.GetData("com.steering.rpt.scls.SCLS.getSCLS_KFFJX2", new object[] { mytype }, this.ob); DataTable dt = (DataTable)ultraGridkffgz.DataSource; if (dt != null && dt.Rows.Count > 0) dt.Rows.Clear(); ultraGridkffgz.DataSource = dtqry; setgridcolunmName(ultraGridkffgz, fjx); if (dtqry.Rows.Count > 0) ultraGridkffgz.Rows[0].Selected = true; else { clearedit(fjx); txt_kftypefgz.Text = txt_kftype.Text; lab_kftypefgz_name.Text = lab_kftype_name.Text; } } else if (fjx == "qz") { DataTable dtqry = ServerHelper.GetData("com.steering.rpt.scls.SCLS.getSCLS_KFQZ", new object[] {}, this.ob); DataTable dt = (DataTable)ultraGridkfqz.DataSource; if (dt != null && dt.Rows.Count > 0) dt.Rows.Clear(); ultraGridkfqz.DataSource = dtqry; setgridcolunmName(ultraGridkfqz, fjx); if (dtqry.Rows.Count > 0) ultraGridkfqz.Rows[0].Selected = true; else { clearedit(fjx); } } } catch (Exception e) { MessageBox.Show(e.Message); } } private void setkfsettingkf(int index) { Infragistics.Win.UltraWinGrid.UltraGridRow myrow = ultraGridkf.Rows[index]; id.Text = myrow.Cells["id"].Value.ToString(); txt_kftype.Text = myrow.Cells["kftype"].Value.ToString(); if (uCb_kftype.SelectedIndex > -1) lab_kftype_name.Text = uCb_kftype.Text; else { foreach (Infragistics.Win.ValueListItem mylist in uCb_kftype.Items) { if (mylist.DataValue.ToString() == txt_kftype.Text) { lab_kftype_name.Text = mylist.DisplayText; break; } } } qydate.Value = Convert.ToDateTime(myrow.Cells["startime"].Value.ToString()); kf.Value = Convert.ToInt32(myrow.Cells["kf"].Value); isvalid.Text = myrow.Cells["isvalid"].Value.ToString(); min_range.Value = Convert.ToInt32(myrow.Cells["min_range"].Value); if (myrow.Cells["max_range"].Text == "") max_range.Value = null; else max_range.Value = Convert.ToInt32(myrow.Cells["max_range"].Value); for (int i = 0; i < cLB_processcode.Items.Count; i++) { cLB_processcode.SetItemChecked(i, false); if (myrow.Cells["processcode"].Value.ToString().Contains(cLB_processcode.Items[i].ToString())) cLB_processcode.SetItemChecked(i, true); } lab_qztypename.Text = myrow.Cells["kftype_name"].Value.ToString(); } private void setkdtypename() { if (kf.Value != null && min_range.Value != null) { lab_qztypename.Text = lab_kftype_name.Text + "，"; if (max_range.Value == null) lab_qztypename.Text += "超" + min_range.Value.ToString() + "天扣" + kf.Value.ToString() + "分"; else lab_qztypename.Text += min_range.Value.ToString() + "-" + max_range.Value.ToString() + "天扣" + kf.Value.ToString() + "分"; } else if (min_range.Value != null) { lab_qztypename.Text = lab_kftype_name.Text + "，"; if (max_range.Value == null) lab_qztypename.Text += "超" + min_range.Value.ToString() + "天"; else lab_qztypename.Text += min_range.Value.ToString() + "-" + max_range.Value.ToString() + "天"; } else if (kf.Value != null) { lab_qztypename.Text = lab_kftype_name.Text + "，"; if (max_range.Value == null) lab_qztypename.Text += "扣" + kf.Value.ToString() + "分"; else lab_qztypename.Text += "-" + max_range.Value.ToString() + "天扣" + kf.Value.ToString() + "分"; } } private void setkfsettingfj(int index) { Infragistics.Win.UltraWinGrid.UltraGridRow myrow = ultraGridkffj.Rows[index]; fj_id.Text = myrow.Cells["id"].Value.ToString(); txt_kftypefj.Text = myrow.Cells["kftype"].Value.ToString(); if (uCb_kftype.SelectedIndex > -1) lab_kftypefj_name.Text = uCb_kftype.Text; else { foreach (Infragistics.Win.ValueListItem mylist in uCb_kftype.Items) { if (mylist.DataValue.ToString() == txt_kftype.Text) { lab_kftypefj_name.Text = mylist.DisplayText; break; } } } foreach (Infragistics.Win.ValueListItem mylist in uCb_fjtype.Items) { if (mylist.DataValue.ToString() == myrow.Cells["fjtype"].Value.ToString()) { uCb_fjtype.SelectedItem = mylist; break; } } qydatefj.Value = Convert.ToDateTime(myrow.Cells["startime"].Value.ToString()); fj_value.Value = Convert.ToInt32(myrow.Cells["fj_value"].Value); isvalidfj.Text = myrow.Cells["isvalid"].Value.ToString(); for (int i = 0; i < cLB_processcodefj.Items.Count; i++) { cLB_processcodefj.SetItemChecked(i, false); if (myrow.Cells["processcode"].Value.ToString().Contains(cLB_processcodefj.Items[i].ToString())) cLB_processcodefj.SetItemChecked(i, true); } lab_kdtypenamefj.Text = myrow.Cells["fjtype_name"].Value.ToString(); } private void txt_kftypefj_TextChanged(object sender, EventArgs e) { setkdfjtypename(); } private void uCb_fjtype_SelectionChanged(object sender, EventArgs e) { setkdfjtypename(); } private void fj_value_ValueChanged(object sender, EventArgs e) { setkdfjtypename(); } private void setkdfjtypename() { if (fj_value.Value != null && uCb_fjtype.SelectedIndex > -1) lab_kdtypenamefj.Text = uCb_fjtype.SelectedItem.DisplayText + "增加" + fj_value.Value.ToString() + "天"; else if (uCb_fjtype.SelectedIndex > -1) lab_kdtypenamefj.Text = uCb_fjtype.SelectedItem.DisplayText; else if (fj_value.Value != null) lab_kdtypenamefj.Text = "增加" + fj_value.Value.ToString() + "天"; else lab_kdtypenamefj.Text = ""; } private void setkfsettingfgz(int index) { Infragistics.Win.UltraWinGrid.UltraGridRow myrow = ultraGridkffgz.Rows[index]; fgz_id.Text = myrow.Cells["id"].Value.ToString(); txt_kftypefgz.Text = myrow.Cells["kftype"].Value.ToString(); if (uCb_kftype.SelectedIndex > -1) lab_kftypefj_name.Text = uCb_kftype.Text; else { foreach (Infragistics.Win.ValueListItem mylist in uCb_kftype.Items) { if (mylist.DataValue.ToString() == txt_kftypefgz.Text) { lab_kftypefgz_name.Text = mylist.DisplayText; break; } } } foreach (Infragistics.Win.ValueListItem mylist in uCb_processcode.Items) { if (mylist.DataValue.ToString() == myrow.Cells["processcode"].Value.ToString()) { uCb_processcode.SelectedItem = mylist; break; } } foreach (Infragistics.Win.ValueListItem mylist in uCb_pline.Items) { if (mylist.DataValue.ToString() == myrow.Cells["pline_code"].Value.ToString()) { uCb_pline.SelectedItem = mylist; break; } } qydatefgz.Value = Convert.ToDateTime(myrow.Cells["startime"].Value.ToString()); if (myrow.Cells["nowork_days"].Text == "") uCb_nowork_days.SelectedIndex = -1; else { foreach (Infragistics.Win.ValueListItem mylist in uCb_nowork_days.Items) { if (mylist.DataValue.ToString() == myrow.Cells["nowork_days"].Value.ToString()) { uCb_nowork_days.SelectedItem = mylist; break; } } } if (myrow.Cells["nowork_times"].Text == "") uCb_nowork_times.Value = null; else uCb_nowork_times.Value = Convert.ToInt32(myrow.Cells["nowork_times"].Value); isvalidfgz.Text = myrow.Cells["isvalid"].Value.ToString(); txt_noworktime_desc.Text = myrow.Cells["noworktime_desc"].Value.ToString(); } private void getpline() { DataView dv = dt_pl.DefaultView; dv.RowFilter = "process_code='" + uCb_processcode.SelectedItem.DataValue.ToString() + "'"; dv.Sort = "process_code,pline_name"; DataTable dt = dv.ToTable(true, "pline_code", "pline_name");//注：其中ToTable（）的第一个参数为是否DISTINCT uCb_pline.Items.Clear(); uCb_pline.DisplayMember = "PLINE_NAME"; uCb_pline.ValueMember = "PLINE_CODE"; uCb_pline.DataSource = dt; } private void setkfsettingqz(int index) { Infragistics.Win.UltraWinGrid.UltraGridRow myrow = ultraGridkfqz.Rows[index]; qz_id.Text = myrow.Cells["id"].Value.ToString(); uCb_kfqztype.Enabled = false; foreach (Infragistics.Win.ValueListItem mylist in uCb_kfqztype.Items) { if (mylist.DataValue.ToString() == myrow.Cells["qztype"].Value.ToString()) { uCb_kfqztype.SelectedItem = mylist; break; } } qydateqz.Value = Convert.ToDateTime(myrow.Cells["startime"].Value.ToString()); qz.Value = Convert.ToInt32(myrow.Cells["qz"].Value); isvalidqz.Text = myrow.Cells["isvalid"].Value.ToString(); lab_kfqztype_desc.Text = myrow.Cells["qztype_name"].Value.ToString(); } private void uCb_kfqztype_SelectionChanged(object sender, EventArgs e) { setqztypename(); } private void qz_ValueChanged(object sender, EventArgs e) { setqztypename(); } private void setqztypename() { if (uCb_kfqztype.SelectedIndex > -1 && qz.Value != null) lab_kfqztype_desc.Text = uCb_kfqztype.Text + "（" + qz.Value.ToString() + "分）"; else if (uCb_kfqztype.SelectedIndex > -1) lab_kfqztype_desc.Text = uCb_kfqztype.Text; else if (qz.Value != null) lab_kfqztype_desc.Text = "（" + qz.Value.ToString() + "分）"; else lab_kfqztype_desc.Text =""; } private void txt_kftypefgz_TextChanged(object sender, EventArgs e) { setfgztypename(); } private void uCb_pline_SelectionChanged(object sender, EventArgs e) { setfgztypename(); } private void uCb_nowork_days_SelectionChanged(object sender, EventArgs e) { setfgztypename(); } private void uCb_nowork_times_ValueChanged(object sender, EventArgs e) { setfgztypename(); } private void setfgztypename() { if (uCb_pline.SelectedIndex > -1 && uCb_nowork_days.SelectedIndex > -1 && uCb_nowork_times.Value != null) txt_noworktime_desc.Text = uCb_pline.Text + uCb_nowork_days.Text + uCb_nowork_times.Value.ToString() + "小时无班"; else if (uCb_pline.SelectedIndex > -1 && (uCb_nowork_days.SelectedIndex > -1 && uCb_nowork_times.Value == null)) txt_noworktime_desc.Text = uCb_pline.Text + uCb_nowork_days.Text+"无班"; else if (uCb_pline.SelectedIndex > -1 && (uCb_nowork_days.SelectedIndex == -1 && uCb_nowork_times.Value != null)) txt_noworktime_desc.Text = uCb_pline.Text + "每天" + uCb_nowork_times.Value.ToString()+ "小时无班"; else if (uCb_pline.SelectedIndex > -1) txt_noworktime_desc.Text = uCb_pline.Text; else if (uCb_pline.SelectedIndex == -1 && uCb_nowork_days.SelectedIndex > -1 && uCb_nowork_times.Value != null) txt_noworktime_desc.Text = uCb_nowork_days.Text + uCb_nowork_times.Value.ToString() + "小时无班"; else if (uCb_pline.SelectedIndex == -1 && (uCb_nowork_days.SelectedIndex > -1 && uCb_nowork_times.Value == null)) txt_noworktime_desc.Text = uCb_nowork_days.Text + "无班"; else if (uCb_pline.SelectedIndex == -1 && (uCb_nowork_days.SelectedIndex == -1 && uCb_nowork_times.Value != null)) txt_noworktime_desc.Text = "每天" + uCb_nowork_times.Value.ToString() + "小时无班"; else txt_noworktime_desc.Text = ""; } private void uCb_kftype_SelectionChanged(object sender, EventArgs e) { getkfsetting(); } private void setgridcolunmName(Infragistics.Win.UltraWinGrid.UltraGrid ultraGrid, String sign) { Dictionary gridcolunmnames = new Dictionary(); if (sign == "kf") { gridcolunmnames.Add("id".ToUpper(), "ID"); gridcolunmnames.Add("kftype".ToUpper(), "扣分类型"); gridcolunmnames.Add("processcode".ToUpper(), "大工序码"); gridcolunmnames.Add("kf".ToUpper(), "扣分"); gridcolunmnames.Add("min_range".ToUpper(), "最小值"); gridcolunmnames.Add("max_range".ToUpper(), "最大值"); gridcolunmnames.Add("kftype_name".ToUpper(), "扣分类型说明"); gridcolunmnames.Add("startime".ToUpper(), "启用日期"); gridcolunmnames.Add("endtime".ToUpper(), "结束日期"); gridcolunmnames.Add("isvalid".ToUpper(), "有效"); gridcolunmnames.Add("createtime".ToUpper(), "创建时间"); gridcolunmnames.Add("updatetime".ToUpper(), "修改时间"); } else if (sign == "fj") { gridcolunmnames.Add("id".ToUpper(), "ID"); gridcolunmnames.Add("kftype".ToUpper(), "扣分类型"); gridcolunmnames.Add("fjtype".ToUpper(), "附加类型"); gridcolunmnames.Add("fjtype_name".ToUpper(), "附加类型说明"); gridcolunmnames.Add("processcode".ToUpper(), "大工序码"); gridcolunmnames.Add("fj_value".ToUpper(), "增加天数"); gridcolunmnames.Add("isvalid".ToUpper(), "有效"); gridcolunmnames.Add("startime".ToUpper(), "启用日期"); gridcolunmnames.Add("createtime".ToUpper(), "创建时间"); gridcolunmnames.Add("updatetime".ToUpper(), "修改时间"); } else if (sign == "fgz") { gridcolunmnames.Add("id".ToUpper(), "ID"); gridcolunmnames.Add("kftype".ToUpper(), "扣分类型"); gridcolunmnames.Add("noworktime_desc".ToUpper(), "非工作日说明"); gridcolunmnames.Add("processcode".ToUpper(), "大工序码"); gridcolunmnames.Add("pline_code".ToUpper(), "产线码"); gridcolunmnames.Add("pline_name".ToUpper(), "产线"); gridcolunmnames.Add("nowork_times".ToUpper(), "非工作小时"); gridcolunmnames.Add("nowork_days".ToUpper(), "非工作星期"); gridcolunmnames.Add("isvalid".ToUpper(), "有效"); gridcolunmnames.Add("startime".ToUpper(), "启用日期"); gridcolunmnames.Add("createtime".ToUpper(), "创建时间"); gridcolunmnames.Add("updatetime".ToUpper(), "修改时间"); } else if (sign == "qz") { gridcolunmnames.Add("id".ToUpper(), "ID"); gridcolunmnames.Add("qztype".ToUpper(), "权重类型"); gridcolunmnames.Add("qztype_name".ToUpper(), "权重说明"); gridcolunmnames.Add("qz".ToUpper(), "权重"); gridcolunmnames.Add("isvalid".ToUpper(), "有效"); gridcolunmnames.Add("startime".ToUpper(), "启用日期"); gridcolunmnames.Add("createtime".ToUpper(), "创建时间"); gridcolunmnames.Add("updatetime".ToUpper(), "修改时间"); } ultraGrid.DataBind(); ultraGrid.DisplayLayout.Bands[0].Header.Appearance.TextHAlign = Infragistics.Win.HAlign.Center; ultraGrid.DisplayLayout.Bands[0].Header.Appearance.FontData.Name = "宋体"; ultraGrid.DisplayLayout.Bands[0].Header.Appearance.FontData.SizeInPoints = 18; ultraGrid.DisplayLayout.UseFixedHeaders = true; foreach (Infragistics.Win.UltraWinGrid.UltraGridBand band in ultraGrid.DisplayLayout.Bands) { foreach (Infragistics.Win.UltraWinGrid.UltraGridColumn column in band.Columns) { column.Header.Caption = gridcolunmnames[column.Key].ToString(); if (column.Key == "ID" || column.Key == "PLINE_CODE") { column.Hidden = true; } column.PerformAutoResize(Infragistics.Win.UltraWinGrid.PerformAutoSizeType.AllRowsInBand); } } ultraGrid.Refresh(); } private void ultraGridkf_AfterSelectChange(object sender, Infragistics.Win.UltraWinGrid.AfterSelectChangeEventArgs e) { Infragistics.Win.UltraWinGrid.UltraGrid mygrid = (Infragistics.Win.UltraWinGrid.UltraGrid) sender; string mykftype = ""; if (mygrid.Selected.Rows.Count > 0) { setkfsettingkf(mygrid.Selected.Rows[0].Index); mykftype = ultraGridkf.Rows[mygrid.Selected.Rows[0].Index].Cells["kftype"].Value.ToString(); getkfsettingfjx(mykftype, "fj"); getkfsettingfjx(mykftype, "fgz"); } else { } // getkfsettingfjx1(mygrid.Selected.Rows[0].Cells["id"].Value.ToString(), "1"); // getkfsettingfjx1(mygrid.Selected.Rows[0].Cells["id"].Value.ToString(), "2"); } private void kf_ValueChanged(object sender, EventArgs e) { setkdtypename(); } private void min_range_ValueChanged(object sender, EventArgs e) { setkdtypename(); } private void max_range_ValueChanged(object sender, EventArgs e) { setkdtypename(); } private void txt_kftype_TextChanged(object sender, EventArgs e) { setkdtypename(); } private void clearedit(string sign) { if (sign == "kf") { Infragistics.Win.UltraWinGrid.UltraGrid mygrid=ultraGridkf; if (mygrid.Selected.Rows.Count > 0) mygrid.Rows[mygrid.Selected.Rows[0].Index].Selected = false; id.Text = ""; txt_kftype.Text = ""; lab_kftype_name.Text = ""; qydate.Value = DateTime.Today; kf.Value = null; min_range.Value = null; max_range.Value = null; for (int i = 0; i < cLB_processcode.Items.Count; i++) { cLB_processcode.SetItemChecked(i, false); } isvalid.Text = "0"; lab_qztypename.Text = ""; } else if (sign == "fj") { Infragistics.Win.UltraWinGrid.UltraGrid mygrid = ultraGridkffj; if (mygrid.Selected.Rows.Count > 0) mygrid.Rows[mygrid.Selected.Rows[0].Index].Selected = false; fj_id.Text = ""; txt_kftypefj.Text = ""; lab_kftypefj_name.Text = ""; uCb_fjtype.SelectedIndex = -1; qydatefj.Value = DateTime.Today; fj_value.Value = null; isvalidfj.Text = "0"; for (int i = 0; i < cLB_processcodefj.Items.Count; i++) { cLB_processcodefj.SetItemChecked(i, false); } } else if (sign == "fgz") { Infragistics.Win.UltraWinGrid.UltraGrid mygrid = ultraGridkffgz; if (mygrid.Selected.Rows.Count > 0) mygrid.Rows[mygrid.Selected.Rows[0].Index].Selected = false; fgz_id.Text = ""; txt_kftypefgz.Text = ""; lab_kftypefgz_name.Text = ""; uCb_processcode.SelectedIndex = -1; uCb_pline.Items.Clear(); qydatefgz.Value = DateTime.Today; uCb_nowork_days.SelectedIndex = -1; uCb_nowork_times.Value = null; isvalidfgz.Text = "0"; txt_noworktime_desc.Text = ""; } else if (sign == "qz") { Infragistics.Win.UltraWinGrid.UltraGrid mygrid = ultraGridkfqz; if (mygrid.Selected.Rows.Count > 0) mygrid.Rows[mygrid.Selected.Rows[0].Index].Selected = false; uCb_kfqztype.Enabled = true; uCb_kfqztype.SelectedIndex = -1; qz_id.Text = ""; qz.Value = null; qydateqz.Value = DateTime.Today; isvalidqz.Text = "0"; lab_kfqztype_desc.Text = ""; } } private void uB_addkf_Click(object sender, EventArgs e) { if (uCb_kftype.SelectedIndex == -1) this.alert("请先选择流速扣分类型"); else { clearedit("kf"); txt_kftype.Text = uCb_kftype.Value.ToString(); lab_kftype_name.Text = uCb_kftype.Text; } } private void uB_addkfqz_Click(object sender, EventArgs e) { clearedit("qz"); } private void uB_addkffj_Click(object sender, EventArgs e) { if (id.Text == "") this.alert("请先选择流速扣分记录"); else { clearedit("fj"); txt_kftypefj.Text = txt_kftype.Text; lab_kftypefj_name.Text = lab_kftype_name.Text; } } private void uB_addkffgz_Click(object sender, EventArgs e) { if (id.Text == "") this.alert("请先选择流速扣分记录"); else { clearedit("fgz"); txt_kftypefgz.Text = txt_kftype.Text; lab_kftypefgz_name.Text = lab_kftype_name.Text; } } private void uCb_processcode_SelectionChanged(object sender, EventArgs e) { if (uCb_processcode.SelectedIndex > -1) getpline(); else uCb_pline.Clear(); } private void ultraGridkffj_AfterSelectChange(object sender, Infragistics.Win.UltraWinGrid.AfterSelectChangeEventArgs e) { Infragistics.Win.UltraWinGrid.UltraGrid mygrid = (Infragistics.Win.UltraWinGrid.UltraGrid)sender; if (mygrid.Selected.Rows.Count>0) setkfsettingfj(mygrid.Selected.Rows[0].Index); } private void ultraGridkfqz_AfterSelectChange(object sender, Infragistics.Win.UltraWinGrid.AfterSelectChangeEventArgs e) { Infragistics.Win.UltraWinGrid.UltraGrid mygrid = (Infragistics.Win.UltraWinGrid.UltraGrid)sender; if (mygrid.Selected.Rows.Count > 0) setkfsettingqz(mygrid.Selected.Rows[0].Index); } private void ultraGridkffgz_AfterSelectChange(object sender, Infragistics.Win.UltraWinGrid.AfterSelectChangeEventArgs e) { Infragistics.Win.UltraWinGrid.UltraGrid mygrid = (Infragistics.Win.UltraWinGrid.UltraGrid)sender; if (mygrid.Selected.Rows.Count > 0) setkfsettingfgz(mygrid.Selected.Rows[0].Index); } private void uCb_kftype_TextChanged(object sender, EventArgs e) { if (uCb_kftype.Text == "") { getkfsetting(); getkfsettingfjx("", "qz"); } else if (uCb_kftype.Text != "" && uCb_kftype.SelectedIndex == -1) uCb_kftype.Text = ""; } private void setuCbselectedindex(Infragistics.Win.UltraWinEditors.UltraComboEditor myuCb,String myvalue,string sign) { foreach (Infragistics.Win.ValueListItem mylist in myuCb.Items) { if (sign == "value" && mylist.DataValue.ToString() == myvalue) { myuCb.SelectedItem = mylist; break; } else if (sign == "text" && mylist.DisplayText.ToString() == myvalue) { myuCb.SelectedItem = mylist; break; } } } private void uCb_kfqztype_TextChanged(object sender, EventArgs e) { if (uCb_kfqztype.Text == "") setqztypename(); else if (uCb_kfqztype.Text != "" && uCb_kfqztype.SelectedIndex == -1) uCb_kfqztype.Text = ""; } private void uCb_fjtype_TextChanged(object sender, EventArgs e) { if (uCb_fjtype.Text == "") setkdfjtypename(); else if (uCb_fjtype.Text != "" && uCb_fjtype.SelectedIndex == -1) uCb_fjtype.Text = ""; } private void uCb_processcode_TextChanged(object sender, EventArgs e) { if (uCb_processcode.Text == "") setfgztypename(); else if (uCb_processcode.Text != "" && uCb_processcode.SelectedIndex == -1) uCb_processcode.Text = ""; } private void uCb_pline_TextChanged(object sender, EventArgs e) { if (uCb_pline.Text == "") setfgztypename(); else if (uCb_pline.Text != "" && uCb_pline.SelectedIndex == -1) uCb_pline.Text = ""; } private void uCb_nowork_days_TextChanged(object sender, EventArgs e) { if (uCb_nowork_days.Text == "") setfgztypename(); else if (uCb_nowork_days.Text != "" && uCb_nowork_days.SelectedIndex == -1) uCb_nowork_days.Text = ""; } private void setbutton(string sign) { if (sign == "kf") { if (id.Text == "") { uB_isvalid.Enabled = false; uB_delete.Enabled = false; } else { uB_isvalid.Enabled = true; if (isvalid.Text == "0") { uB_isvalid.Text = "启用"; uB_delete.Enabled = true; } else { uB_isvalid.Text = "停用"; uB_delete.Enabled = false; } } } else if (sign == "fj") { if (fj_id.Text == "") { uB_isvalidfj.Enabled = false; uB_deletefj.Enabled = false; } else { uB_isvalidfj.Enabled = true; if (isvalidfj.Text == "0") { uB_isvalidfj.Text = "启用"; uB_deletefj.Enabled = true; } else { uB_isvalidfj.Text = "停用"; uB_deletefj.Enabled = false; } } } else if (sign == "fgz") { if (fgz_id.Text == "") { uB_isvalidfgz.Enabled = false; uB_deletefgz.Enabled = false; } else { uB_isvalidfgz.Enabled = true; if (isvalidfgz.Text == "0") { uB_isvalidfgz.Text = "启用"; uB_deletefgz.Enabled = true; } else { uB_isvalidfgz.Text = "停用"; uB_deletefgz.Enabled = false; } } } else if (sign == "qz") { if (qz_id.Text == "") { uB_isvalidqz.Enabled = false; uB_deleteqz.Enabled = false; } else { uB_isvalidqz.Enabled = true; if (isvalidqz.Text == "0") { uB_isvalidqz.Text = "启用"; uB_deleteqz.Enabled = true; } else { uB_isvalidqz.Text = "停用"; uB_deleteqz.Enabled = false; } } } } private void isvalid_TextChanged(object sender, EventArgs e) { setbutton("kf"); } private void isvalidfj_TextChanged(object sender, EventArgs e) { setbutton("fj"); } private void isvalidfgz_TextChanged(object sender, EventArgs e) { setbutton("fgz"); } private void isvalidqz_TextChanged(object sender, EventArgs e) { setbutton("qz"); } private void id_TextChanged(object sender, EventArgs e) { setbutton("kf"); } private void qz_id_TextChanged(object sender, EventArgs e) { setbutton("qz"); } private void fj_id_TextChanged(object sender, EventArgs e) { setbutton("fj"); } private void fgz_id_TextChanged(object sender, EventArgs e) { setbutton("fgz"); } private bool getifConfirm(UltraButton mybutoon, string othermessage = "",string sign="") { bool Confirm = false; string mymessge = othermessage != "" ? othermessage + "\n" : ""; if (sign=="") mymessge += "确实要" + mybutoon.Text + "该记录吗？"; else mymessge = "确实要" + othermessage+sign + "吗？"; if (MessageBox.Show(mymessge, "提交", MessageBoxButtons.YesNo,MessageBoxIcon.Information) == DialogResult.Yes) Confirm = true; return Confirm; } private void uB_savekf_Click(object sender, EventArgs e) { if (txt_kftype.Text == "") { this.alert("流速扣分类型不能为空！"); } else if (kf.Value == null || kf.Value.ToString() == "") { this.alert("最小天数不能为空！"); //kf.Focus(); } else if (min_range.Value == null || min_range.Value.ToString() == "") { this.alert("最小天数不能为空！"); //min_range.Focus(); } else if (cLB_processcode.CheckedItems.Count == 0) { this.alert("适用大工序不能为空！"); //cLB_processcode.Focus(); } else if (getifConfirm((UltraButton)sender, "请确认扣分类型、扣分、范围等内容已填写正确。")) { savedata("kf"); } } private void uB_savefj_Click(object sender, EventArgs e) { if (txt_kftypefj.Text == "") { this.alert("流速扣分类型不能为空！"); } else if (uCb_fjtype.SelectedIndex < 0) { this.alert("附加类型不能为空！"); //uCb_fjtype.Focus(); } else if (fj_value.Value == null || fj_value.Value.ToString() == "") { this.alert("增加天数不能为空！"); //fj_value.Focus(); } else if (cLB_processcodefj.CheckedItems.Count == 0) { this.alert("适用大工序不能为空！"); //cLB_processcodefj.Focus(); } else if (getifConfirm((UltraButton)sender, "请确认扣分类型、增项类型、增加天数、大工序等内容已填写正确。")) { savedata("fj"); } } private void uB_savefgz_Click(object sender, EventArgs e) { if (txt_kftypefgz.Text == "") { this.alert("流速扣分类型不能为空！"); } else if (uCb_processcode.SelectedIndex < 0) { this.alert("大工序不能为空！"); //uCb_processcode.Focus(); } else if (uCb_pline.SelectedIndex < 0) { this.alert("产线不能为空！"); //uCb_pline.Focus(); } else if (uCb_nowork_days.SelectedIndex == -1 && (uCb_nowork_times.Value == null || uCb_nowork_times.Value.ToString() == "")) { this.alert("非工作星期和小时不能同时为空！"); //uCb_nowork_days.Focus(); } else if (txt_noworktime_desc.Text == "") { this.alert("说明不能为空！"); //txt_noworktime_desc.Focus(); } else if (getifConfirm((UltraButton)sender, "请确认扣分类型、产线、非工作星期、小时以及说明等内容已填写正确。")) { savedata("fgz"); } } private void uB_saveqz_Click(object sender, EventArgs e) { if (uCb_kfqztype.SelectedIndex < 0) { this.alert("流速扣分权重类型不能为空！"); //uCb_kfqztype.Focus(); } else if (qz.Value == null || qz.Value.ToString() == "") { this.alert("权重不能为空！"); //qz.Focus(); } else if (getifConfirm((UltraButton)sender, "请确认扣分权重类型、权重等内容已填写正确。")) { savedata("qz"); } } private void savedata(string sign) { try { bool isnew = false; object[] myobj = new object[] { }; Infragistics.Win.UltraWinGrid.UltraGrid myulgrid = new Infragistics.Win.UltraWinGrid.UltraGrid(); UltraButton myuB_save = new UltraButton(); string sql = ""; String myid = ""; if (sign == "kf") { myuB_save = uB_savekf; String kftype, processcode = "", mymin_range, mymax_range = "null", mykf, kftype_name, startime; myid = id.Text; kftype = txt_kftype.Text; startime = ((DateTime)this.qydate.Value).ToString("yyyy-MM-dd"); foreach (string cb in cLB_processcode.CheckedItems) { processcode += cb; } mymin_range = min_range.Value.ToString(); if (max_range.Value != null && max_range.Value.ToString()!="") mymax_range = max_range.Value.ToString(); mykf = kf.Value.ToString(); kftype_name = lab_qztypename.Text; if (myid == "") { sql = "com.steering.rpt.scls.SCLS.insert_SCLS_KF"; myid = kftype + startime.Replace("-", ""); isnew = true; } else sql = "com.steering.rpt.scls.SCLS.update_SCLS_KF"; myobj = new object[] { myid, kftype, processcode, mymin_range, mymax_range, mykf, kftype_name, startime }; } else if (sign == "fj") { myuB_save = uB_savefj; String kftype, fjtype,fjtype_name,processcode = "", myfj, startime; myid = fj_id.Text; kftype = txt_kftypefj.Text; fjtype = uCb_fjtype.Value.ToString(); startime = ((DateTime)this.qydatefj.Value).ToString("yyyy-MM-dd"); foreach (string cb in cLB_processcodefj.CheckedItems) { processcode += cb; } myfj = fj_value.Value.ToString(); fjtype_name = lab_kdtypenamefj.Text; if (myid == "") { sql = "com.steering.rpt.scls.SCLS.insert_SCLS_KFFJX1"; myid = kftype + startime.Replace("-", ""); isnew = true; } else sql = "com.steering.rpt.scls.SCLS.update_SCLS_KFFJX1"; myobj = new object[] { myid, kftype, fjtype, fjtype_name, processcode, myfj, startime }; } else if (sign == "fgz") { myuB_save = uB_savefgz; String kftype, mynoworktime_desc, processcode,mypline_code,mypline_name,mynowork_days,mynowork_times, startime; myid = fgz_id.Text; kftype = txt_kftypefgz.Text; processcode = uCb_processcode.Value.ToString(); mypline_code = uCb_pline.Value.ToString(); mypline_name = uCb_pline.Text; startime = ((DateTime)this.qydatefgz.Value).ToString("yyyy-MM-dd"); if (uCb_nowork_days.Value == null || uCb_nowork_days.Value.ToString() == "") mynowork_days = "null"; else mynowork_days = uCb_nowork_days.Value.ToString(); if (uCb_nowork_times.Value == null || uCb_nowork_times.Value.ToString() == "") mynowork_times = "null"; else mynowork_times = uCb_nowork_times.Value.ToString(); mynoworktime_desc = txt_noworktime_desc.Text; if (myid == "") { sql = "com.steering.rpt.scls.SCLS.insert_SCLS_KFFJX2"; myid = kftype + startime.Replace("-", ""); isnew = true; } else sql = "com.steering.rpt.scls.SCLS.update_SCLS_KFFJX2"; myobj = new object[] { myid, kftype, mynoworktime_desc, processcode,mypline_code,mypline_name,mynowork_days,mynowork_times, startime }; } else if (sign == "qz") { myuB_save = uB_saveqz; String myqztype, myqz,myqztype_name, startime; myid = qz_id.Text; myqztype = uCb_kfqztype.Value.ToString(); startime = ((DateTime)this.qydateqz.Value).ToString("yyyy-MM-dd"); myqz = qz.Value.ToString(); myqztype_name = lab_qztypename.Text; if (myid == "") { sql = "com.steering.rpt.scls.SCLS.insert_KFQZ"; myid = myqztype + startime.Replace("-", ""); isnew = true; } else sql = "com.steering.rpt.scls.SCLS.update_KFQZ"; myobj = new object[] { myid, myqztype, myqz,myqztype_name, startime }; } DataTable dt = ServerHelper.GetData(sql, myobj, this.ob); if (dt != null && dt.Rows.Count == 1) { MessageBox.Show("该记录" + myuB_save.Text + "提交成功！", "提示"); setgridselected(sign, dt, myid,isnew); } else MessageBox.Show("该记录" + myuB_save.Text + "提交失败！", "提示"); } catch (Exception e) { MessageBox.Show(e.Message); } } private void setgridselected(string sign, DataTable dt, string id, bool isnew) { Infragistics.Win.UltraWinGrid.UltraGrid myulgrid = new Infragistics.Win.UltraWinGrid.UltraGrid(); Infragistics.Win.UltraWinGrid.UltraGridRow myrow; if (sign == "kf") myulgrid = ultraGridkf; else if (sign == "fj") myulgrid = ultraGridkffj; else if (sign == "fgz") myulgrid = ultraGridkffgz; else if (sign == "qz") myulgrid = ultraGridkfqz; if (isnew) myrow = myulgrid.Rows.Band.AddNew(); else myrow = myulgrid.Selected.Rows[0]; foreach (Infragistics.Win.UltraWinGrid.UltraGridCell mycell in myrow.Cells) { mycell.Value = dt.Rows[0][mycell.Column.Key]; } } private void saveisvalid(string sign) { try { string sql = ""; Infragistics.Win.UltraWinGrid.UltraGrid myulgrid = new Infragistics.Win.UltraWinGrid.UltraGrid(); UltraButton myuB_isvalid = new UltraButton(); Label myl_isvalid = new Label(); String myid = "", kftype = "", newisvalid = "", oldisvalid = ""; object[] myobj=new object[]{}; if (sign == "kf") { myulgrid = ultraGridkf; myuB_isvalid = uB_isvalid; myl_isvalid = isvalid; myid = id.Text; kftype = txt_kftype.Text; oldisvalid = myl_isvalid.Text; if (oldisvalid == "0") newisvalid = "1"; else newisvalid = "0"; sql = "com.steering.rpt.scls.SCLS.isvalid_KF"; myobj = new object[] { myid, kftype, newisvalid, oldisvalid }; } else if (sign == "fj") { String fjtype ; myulgrid = ultraGridkffj; myuB_isvalid = uB_isvalidfj; myl_isvalid = isvalidfj; myid = fj_id.Text; kftype = txt_kftypefj.Text; fjtype = uCb_fjtype.Value.ToString(); oldisvalid = myl_isvalid.Text; if (oldisvalid == "0") newisvalid = "1"; else newisvalid = "0"; sql = "com.steering.rpt.scls.SCLS.isvalid_KFFJX1"; myobj = new object[] { myid, kftype,fjtype, newisvalid, oldisvalid }; } else if (sign == "fgz") { String mypline; myulgrid = ultraGridkffgz; myuB_isvalid = uB_isvalidfgz; myl_isvalid = isvalidfgz; myid = fgz_id.Text; kftype = txt_kftypefgz.Text; mypline = uCb_pline.Value.ToString(); ; oldisvalid = myl_isvalid.Text; if (oldisvalid == "0") newisvalid = "1"; else newisvalid = "0"; sql = "com.steering.rpt.scls.SCLS.isvalid_KFFJX2"; myobj = new object[] { myid, kftype, mypline, newisvalid, oldisvalid }; } else if (sign == "qz") { String mykfqztype; myulgrid = ultraGridkffgz; myuB_isvalid = uB_isvalidfgz; myl_isvalid = isvalidfgz; myid = fgz_id.Text; mykfqztype = uCb_kfqztype.Value.ToString(); ; oldisvalid = myl_isvalid.Text; if (oldisvalid == "0") newisvalid = "1"; else newisvalid = "0"; sql = "com.steering.rpt.scls.SCLS.isvalid_KFQZ"; myobj = new object[] { myid, mykfqztype, newisvalid, oldisvalid }; } DataTable dt = ServerHelper.GetData(sql,myobj , this.ob); if (dt != null && dt.Rows.Count == 1) { MessageBox.Show("该记录" + uB_isvalid.Text + "提交成功！", "提示"); myulgrid.Rows[myulgrid.Selected.Rows[0].Index].Cells["isvalid"].Value = newisvalid; myl_isvalid.Text = newisvalid; } else MessageBox.Show("该记录" + uB_isvalid.Text + "提交失败！", "提示"); } catch (Exception e) { MessageBox.Show(e.Message); } } private void uB_isvalid_Click(object sender, EventArgs e) { if (getifConfirm((UltraButton)sender)) { saveisvalid("kf"); } } private void uB_isvalidqz_Click(object sender, EventArgs e) { if (getifConfirm((UltraButton)sender)) { saveisvalid("qz"); } } private void uB_isvalidfj_Click(object sender, EventArgs e) { if (getifConfirm((UltraButton)sender)) { saveisvalid("fj"); } } private void uB_isvalidfgz_Click(object sender, EventArgs e) { if (getifConfirm((UltraButton)sender)) { saveisvalid("fgz"); } } private void delete(string sign) { try { string sql = ""; Infragistics.Win.UltraWinGrid.UltraGrid myulgrid = new Infragistics.Win.UltraWinGrid.UltraGrid(); String myid = ""; object[] myobj = new object[] { }; if (sign == "kf") { myulgrid = ultraGridkf; myid = id.Text; sql = "com.steering.rpt.scls.SCLS.delete_KF"; myobj = new object[] { myid }; } else if (sign == "fj") { myulgrid = ultraGridkffj; myid = fj_id.Text; sql = "com.steering.rpt.scls.SCLS.delete_KFFJX1"; myobj = new object[] { myid }; } else if (sign == "fgz") { myulgrid = ultraGridkffgz; myid = fgz_id.Text; sql = "com.steering.rpt.scls.SCLS.delete_KFFJX2"; myobj = new object[] { myid }; } else if (sign == "qz") { myulgrid = ultraGridkffgz; myid = fgz_id.Text; sql = "com.steering.rpt.scls.SCLS.isvalid_KFQZ"; myobj = new object[] { myid }; } DataTable dt = ServerHelper.GetData(sql, myobj, this.ob); if (dt != null && dt.Rows.Count == 0) { MessageBox.Show("删除该记录提交成功！", "提示"); myulgrid.Rows[myulgrid.Selected.Rows[0].Index].Delete(true); if (myulgrid.Rows.Count > 0) myulgrid.Rows[0].Selected = true; else clearedit(sign); } else MessageBox.Show("删除该记录提交成功提交失败！", "提示"); } catch (Exception e) { MessageBox.Show(e.Message); } } private void uB_delete_Click(object sender, EventArgs e) { if (isvalid.Text == "1") this.alert("不能删除有效数据，若要删除请先停用！"); else if (id.Text == "") this.alert("没有可删除的有效数据！"); else if (getifConfirm((UltraButton)sender)) { delete("kf"); } } private void uB_deleteqz_Click(object sender, EventArgs e) { if (isvalidqz.Text == "1") this.alert("不能删除有效数据，若要删除请先停用！"); else if (qz_id.Text == "") this.alert("没有可删除的有效数据！"); else if (getifConfirm((UltraButton)sender)) { delete("qz"); } } private void uB_deletefj_Click(object sender, EventArgs e) { if (isvalidfj.Text == "1") this.alert("不能删除有效数据，若要删除请先停用！"); else if (fj_id.Text == "") this.alert("没有可删除的有效数据！"); else if (getifConfirm((UltraButton)sender)) { delete("fj"); } } private void uB_deletefgz_Click(object sender, EventArgs e) { if (isvalidfgz.Text == "1") this.alert("不能删除有效数据，若要删除请先停用！"); else if (fgz_id.Text == "") this.alert("没有可删除的有效数据！"); else if (getifConfirm((UltraButton)sender)) { delete("fgz"); } } private void uB_ImportData_Click(object sender, EventArgs e) { if (uCb_kftype.SelectedIndex == -1) this.alert("请先选择流速扣分类型"); else { string sql = "", sign = ""; object[] myobj = new object[] { }; if (uCb_kftype.Value.ToString().Contains("ls_dc")) { sql = "com.steering.rpt.scls.SCLS.ImportDC"; sign = "待产"; } else if (uCb_kftype.Value.ToString().Contains("ls_qx")) { sql = "com.steering.rpt.scls.SCLS.ImportQX"; sign = "清线"; } else if (uCb_kftype.Value.ToString().Contains("ls_lxwt")) { sql = "com.steering.rpt.scls.SCLS.ImportLXWT"; sign = "离线待委托"; } else if (uCb_kftype.Value.ToString().Contains("ls_lxfx")) { sql = "com.steering.rpt.scls.SCLS.ImportLXFX"; sign = "离线待返线"; } else if (uCb_kftype.Value.ToString().Contains("ls_dpsp")) { sql = "com.steering.rpt.scls.SCLS.ImportDPDSP"; sign = "下线待送判"; } else if (uCb_kftype.Value.ToString().Contains("ls_dppd")) { sql = "com.steering.rpt.scls.SCLS.ImportDPDPD"; sign = "下线待判定"; } else if (uCb_kftype.Value.ToString().Contains("ls_fp")) { sql = "com.steering.rpt.scls.SCLS.ImportFP"; sign = "废品待处理"; } if (getifConfirm((UltraButton)sender, "重新导入今天",sign)) { WaitingForm2 wf = new WaitingForm2("请耐心等待，正在处理数据...."); try { DataTable dt = ServerHelper.GetData(sql, myobj, this.ob); wf.Close(); if (dt != null && dt.Rows.Count == 1) MessageBox.Show("重新导入今天" + sign + "数据成功！", "提示"); else MessageBox.Show("重新导入今天" + sign + "数据失败！", "提示"); } catch (Exception ex) { wf.Close(); MessageBox.Show(ex.Message); } finally { } } } } private void ultraGridkf_ClickCell(object sender, Infragistics.Win.UltraWinGrid.ClickCellEventArgs e) { ultraGridkf.Rows[e.Cell.Row.Index].Selected = true; } private void ultraGridkffj_ClickCell(object sender, Infragistics.Win.UltraWinGrid.ClickCellEventArgs e) { ultraGridkffj.Rows[e.Cell.Row.Index].Selected = true; } private void ultraGridkffgz_ClickCell(object sender, Infragistics.Win.UltraWinGrid.ClickCellEventArgs e) { ultraGridkffgz.Rows[e.Cell.Row.Index].Selected = true; } private void ultraGridkfqz_ClickCell(object sender, Infragistics.Win.UltraWinGrid.ClickCellEventArgs e) { ultraGridkfqz.Rows[e.Cell.Row.Index].Selected = true; } } }