private void ultraToolbarsManager1_ToolClick(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs e) { if (e.Tool.Key == "查询") { QueryBCWeightMainData(); } if (e.Tool.Key == "修改") { UpdateSteelWeightMain(); } if (e.Tool.Key == "补录") { DoHandSaveMainForGP(); } if (e.Tool.Key == "删除") { DeleteSteelWeightMain(); } //if (e.Tool.Key == "修改从表") //{ // UpdateSteelWeightDetail(); //} if (e.Tool.Key == "补录从表") { //DoHandSaveForGP(); } if (e.Tool.Key == "删除从表") { //DeleteSteelWeightDetail(); } if (e.Tool.Key == "Export") { CommonMethod.ExportDataWithSaveDialog2(ref this.ultraGrid1, this.Text); } if (e.Tool.Key == "修改炉号") { UpdateStoveno(); } }
public ucBilletFlowCard() { InitializeComponent(); try { this.ultraGrid1.ClickCellButton += new Infragistics.Win.UltraWinGrid.CellEventHandler(this.ultraGrid1_ClickCellButton); ultraGrid1.DisplayLayout.Bands[0].Columns["FD_ZC_ENTERDATETIME"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.EditButton; ultraGrid1.DisplayLayout.Bands[0].Columns["FD_ZC_ENTERDATETIME"].ButtonDisplayStyle = Infragistics.Win.UltraWinGrid.ButtonDisplayStyle.OnMouseEnter; ultraGrid1.DisplayLayout.Bands[0].Columns["FD_ZZ_DATE"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.EditButton; ultraGrid1.DisplayLayout.Bands[0].Columns["FD_ZZ_DATE"].ButtonDisplayStyle = Infragistics.Win.UltraWinGrid.ButtonDisplayStyle.OnMouseEnter; } catch { } try { ultraGrid1.DisplayLayout.Bands[0].Columns["FN_LENGTH"].ValueList = CommonMethod.GetValuelistLength(); CommonMethod.InitUserControl(ref ultraDataSource1, ref ultraGrid1); CommonMethod.SetUltraGridCellReadOnly(ref ultraGrid1, true); } catch { } }
public void SetPost_Rolling(ProduceLine ProLine) { try { ArrayList alistEditable = new ArrayList(); alistEditable.Add("FN_ZZ_SPEC"); if (ProLine != ProduceLine.GX) { alistEditable.Add("FN_LENGTH"); } alistEditable.Add("FD_ZZ_DATE"); alistEditable.Add("FN_ZZ_NUM"); alistEditable.Add("FN_ZZ_WASTNUM"); alistEditable.Add("FS_ZZ_MEMO"); CommonMethod.SetUltraGridCellEditable(ref ultraGrid1, alistEditable); ultraGrid1.ActiveCell = ultraGrid1.Rows[0].Cells["FN_ZZ_SPEC"]; ultraGrid1.PerformAction(UltraGridAction.EnterEditMode); } catch { } }
private void QueryBCWeightMainData() { try { if (dtBeginTime.Value > dtEndTime.Value) { MessageBox.Show("查询开始时间不能大于结束时间"); return; } string strStartTime = dtBeginTime.Value.ToString("yyyy-MM-dd 00:00:00"); string strEndTime = dtEndTime.Value.ToString("yyyy-MM-dd 23:59:59"); string strSql = @"select FS_STOVENO,FS_PRODUCTNO,FS_ITEMNO,FS_PLANT,FS_MRP,FS_RECEIVEPLANT,FS_STORE ,FS_MATERIAL,FS_MATERIALNAME,FS_STEELTYPE,FS_SPEC,FS_WEIGHTTYPE,FN_LENGTH,FS_POINT ,FN_WEIGHT ,FN_THEORYWEIGHT, FS_AUDITOR,to_char(FD_AUDITTIME, 'yyyy-MM-dd HH24:mi:ss') FD_AUDITTIME, FS_UPLOADFLAG,to_char(FD_TOCENTERTIME, 'yyyy-MM-dd HH24:mi:ss') FD_TOCENTERTIME, FS_ACCOUNTDATE,to_char(FD_TESTIFYDATE, 'yyyy-MM-dd HH24:mi:ss') FD_TESTIFYDATE, decode(t.fs_shift,'0','常白班','1','早班','2','中班','3','晚班',t.fs_shift)FS_SHIFT,FS_PERSON,FS_ISMATCH,FS_SAPSTORE,FS_HEADER, to_char(FD_WEIGHTTIME, 'yyyy-MM-dd HH24:mi:ss') FD_WEIGHTTIME from DT_BOARDWEIGHTMAIN t where FD_WEIGHTTIME between to_date('{0}', 'yyyy-MM-dd HH24:mi:ss') and to_date('{1}', 'yyyy-MM-dd HH24:mi:ss')"; strSql = string.Format(strSql, strStartTime, strEndTime); if (this.tbx_BatchNo.Text.Trim() != string.Empty) { strSql += " and FS_STOVENO like '%" + this.tbx_BatchNo.Text.Trim().Replace("'", "''") + "%'"; } if (this.cbReceiver.SelectedValue.ToString() != string.Empty) { strSql += " and FS_STORE='" + cbReceiver.SelectedValue.ToString() + "'"; } strSql += " order by FD_WEIGHTTIME asc"; CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "ygjzjl.basedatamanage.OtherBaseInfo"; ccp.MethodName = "ExcuteQuery"; ccp.ServerParams = new object[] { strSql }; ccp.SourceDataTable = this.dataSet1.Tables[0]; this.dataSet1.Tables[1].Clear(); this.dataSet1.Tables[0].Clear(); this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); CommonMethod.RefreshAndAutoSize(ultraGrid1); // string strSqlTemp = @"select t.fs_weightno,t.fs_stoveno,t.fn_billetindex // ,round(t.fn_netweight,3) fn_netweight,t.fs_person,to_char(t.fd_weighttime,'yyyy-MM-dd HH24:mi:ss') fd_weighttime // ,decode(t.fs_shift,'0','常白班','1','早班','2','中班','3','晚班',t.fs_shift) fs_shift // ,decode(t.fs_term,'0','常白班','1','甲班','2','乙班','3','丙班','4','丁班',t.fs_term) fs_term // ,t.fs_weightpoint,decode(t.fs_thweitsingle,'0','是','1','否','是') fs_thweitsingle"; // strSqlTemp += " from DT_STEELWEIGHTDETAILROLL t where t.fs_stoveno in (select FS_STOVENO from dt_steelweightmain where FD_STARTTIME between to_date('" + strStartTime + "','yyyy-MM-dd HH24:mi:ss') and to_date('" + strEndTime + "','yyyy-MM-dd HH24:mi:ss')"; // if (this.tbx_BatchNo.Text.Trim() != string.Empty) // { // strSqlTemp += " and FS_STOVENO = '" + this.tbx_BatchNo.Text.Trim().Replace("'", "''") + "'"; // } // strSqlTemp += ") order by t.FN_BILLETINDEX,length(t.FN_BILLETINDEX)"; // ccp.ServerParams = new object[] { strSqlTemp }; // ccp.SourceDataTable = this.dataSet1.Tables[1]; // this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); this.txtStoveNo.ReadOnly = false; } catch (Exception exp) { MessageBox.Show(exp.Message); } }
public void ResetData() { CommonMethod.InitUserControl(ref ultraDataSource1, ref ultraGrid1); }
public bool DataValidation_Rolling(ProduceLine ProLine, out Hashtable htblValue) { htblValue = new Hashtable(); try { if (ultraGrid1.Rows.Count == 0) { return(false); } ultraGrid1.UpdateData(); string strValue = Convert.ToString(ultraGrid1.Rows[0].Cells["FN_ZZ_SPEC"].Value).Trim(); if (string.IsNullOrEmpty(strValue)) { MessageBox.Show("请输入轧制规格!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); CommonMethod.SetUltraGridActiveCell(ref ultraGrid1, 0, "FN_ZZ_SPEC", true); return(false); } int iCount = 0; decimal dCount = 0.0M; bool bOK = false; if (ProLine != ProduceLine.GX) { strValue = Convert.ToString(ultraGrid1.Rows[0].Cells["FN_LENGTH"].Value).Trim(); if (string.IsNullOrEmpty(strValue)) { MessageBox.Show("请输入定尺长度!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); CommonMethod.SetUltraGridActiveCell(ref ultraGrid1, 0, "FN_LENGTH", true); return(false); } bOK = int.TryParse(strValue, out iCount); if (!bOK) { MessageBox.Show("定尺长度必须是整数!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); CommonMethod.SetUltraGridActiveCell(ref ultraGrid1, 0, "FN_LENGTH", true); return(false); } if (iCount < 0) { MessageBox.Show("定尺长度必须大于零!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); CommonMethod.SetUltraGridActiveCell(ref ultraGrid1, 0, "FN_LENGTH", true); return(false); } } strValue = Convert.ToString(ultraGrid1.Rows[0].Cells["FN_ZZ_NUM"].Value).Trim(); if (string.IsNullOrEmpty(strValue)) { MessageBox.Show("请输入成材条数!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); CommonMethod.SetUltraGridActiveCell(ref ultraGrid1, 0, "FN_ZZ_NUM", true); return(false); } bOK = decimal.TryParse(strValue, out dCount); if (!bOK) { MessageBox.Show("成材条数必须是数值!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); CommonMethod.SetUltraGridActiveCell(ref ultraGrid1, 0, "FN_ZZ_NUM", true); return(false); } if (dCount < 0) { MessageBox.Show("成材条数必须大于零!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); CommonMethod.SetUltraGridActiveCell(ref ultraGrid1, 0, "FN_ZZ_NUM", true); return(false); } strValue = Convert.ToString(ultraGrid1.Rows[0].Cells["FN_ZZ_WASTNUM"].Value).Trim(); if (!string.IsNullOrEmpty(strValue)) { bOK = decimal.TryParse(strValue, out dCount); if (!bOK) { MessageBox.Show("轧废条数必须是数值!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); CommonMethod.SetUltraGridActiveCell(ref ultraGrid1, 0, "FN_ZZ_WASTNUM", true); return(false); } if (dCount < 0) { MessageBox.Show("轧废条数必须大于零!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); CommonMethod.SetUltraGridActiveCell(ref ultraGrid1, 0, "FN_ZZ_WASTNUM", true); return(false); } } strValue = Convert.ToString(ultraGrid1.Rows[0].Cells["FN_ZZ_SPEC"].Text).Trim(); htblValue.Add("V2", strValue); //轧制规格 strValue = Convert.ToString(ultraGrid1.Rows[0].Cells["FN_LENGTH"].Text).Trim(); htblValue.Add("V3", strValue); //定尺长度 strValue = Convert.ToString(ultraGrid1.Rows[0].Cells["FD_ZZ_DATE"].Text).Trim(); htblValue.Add("V4", strValue); //轧制时间 strValue = Convert.ToString(ultraGrid1.Rows[0].Cells["FN_ZZ_NUM"].Text).Trim(); htblValue.Add("V5", strValue); //成材支数 strValue = Convert.ToString(ultraGrid1.Rows[0].Cells["FN_ZZ_WASTNUM"].Text).Trim(); htblValue.Add("V6", strValue); //轧废支数 strValue = Convert.ToString(ultraGrid1.Rows[0].Cells["FS_ZZ_MEMO"].Text).Trim(); htblValue.Add("V8", strValue); //轧废支数 return(true); } catch { } return(false); }
private void cbx_Filter_CheckedChanged(object sender, EventArgs e) { CommonMethod.SetUltraGridRowFilter(ref ultraGrid1, cbx_Filter.Checked); }
private void GetWeightInfo() { //PL/SQL SPECIAL COPY string strWhere = ""; if (cbxDateTime.Checked) { string strDateTimeFrom = dateTimePicker1.Value.ToString("yyyy-MM-dd HH:mm"); string strDateTimeTo = dateTimePicker2.Value.ToString("yyyy-MM-dd HH:mm"); strWhere += Convert.ToString(" and t.fd_starttime between to_date('" + strDateTimeFrom + "', 'yyyy-MM-dd HH24:mi') and to_date('" + strDateTimeTo + "', 'yyyy-MM-dd HH24:mi')").Trim() + " "; } if (!string.IsNullOrEmpty(tbQueryBatchNo.Text.Trim())) { strWhere += Convert.ToString(" and t.fs_stoveno like '%" + tbQueryBatchNo.Text.Trim() + "%'").Trim() + " "; } string strSql = ""; strSql += Convert.ToString("select *").Trim() + " "; strSql += Convert.ToString(" from (select case").Trim() + " "; strSql += Convert.ToString(" when grouping(fs_stoveno) = 0 and grouping(fs_steeltype) = 0 and").Trim() + " "; strSql += Convert.ToString(" grouping(fs_spec) = 0 and grouping(fn_length) = 0 and").Trim() + " "; strSql += Convert.ToString(" grouping(fs_store) = 0 and grouping(fs_transtype) = 0 then").Trim() + " "; strSql += Convert.ToString(" 0").Trim() + " "; strSql += Convert.ToString(" when grouping(fs_stoveno) = 1 and grouping(fs_steeltype) = 0 and").Trim() + " "; strSql += Convert.ToString(" grouping(fs_spec) = 1 and grouping(fn_length) = 1 and").Trim() + " "; strSql += Convert.ToString(" grouping(fs_store) = 1 and grouping(fs_transtype) = 1 then").Trim() + " "; strSql += Convert.ToString(" 1").Trim() + " "; strSql += Convert.ToString(" when grouping(fs_stoveno) = 1 and grouping(fs_steeltype) = 1 and").Trim() + " "; strSql += Convert.ToString(" grouping(fs_spec) = 0 and grouping(fn_length) = 1 and").Trim() + " "; strSql += Convert.ToString(" grouping(fs_store) = 1 and grouping(fs_transtype) = 1 then").Trim() + " "; strSql += Convert.ToString(" 2").Trim() + " "; strSql += Convert.ToString(" when grouping(fs_stoveno) = 1 and grouping(fs_steeltype) = 1 and").Trim() + " "; strSql += Convert.ToString(" grouping(fs_spec) = 1 and grouping(fn_length) = 0 and").Trim() + " "; strSql += Convert.ToString(" grouping(fs_store) = 1 and grouping(fs_transtype) = 1 then").Trim() + " "; strSql += Convert.ToString(" 3").Trim() + " "; strSql += Convert.ToString(" when grouping(fs_stoveno) = 1 and grouping(fs_steeltype) = 1 and").Trim() + " "; strSql += Convert.ToString(" grouping(fs_spec) = 1 and grouping(fn_length) = 1 and").Trim() + " "; strSql += Convert.ToString(" grouping(fs_store) = 0 and grouping(fs_transtype) = 1 then").Trim() + " "; strSql += Convert.ToString(" 4").Trim() + " "; strSql += Convert.ToString(" when grouping(fs_stoveno) = 1 and grouping(fs_steeltype) = 1 and").Trim() + " "; strSql += Convert.ToString(" grouping(fs_spec) = 1 and grouping(fn_length) = 1 and").Trim() + " "; strSql += Convert.ToString(" grouping(fs_store) = 1 and grouping(fs_transtype) = 0 then").Trim() + " "; strSql += Convert.ToString(" 5").Trim() + " "; strSql += Convert.ToString(" when grouping(fs_stoveno) = 1 and grouping(fs_steeltype) = 1 and").Trim() + " "; strSql += Convert.ToString(" grouping(fs_spec) = 1 and grouping(fn_length) = 1 and").Trim() + " "; strSql += Convert.ToString(" grouping(fs_store) = 1 and grouping(fs_transtype) = 1 then").Trim() + " "; strSql += Convert.ToString(" 6").Trim() + " "; strSql += Convert.ToString(" else").Trim() + " "; strSql += Convert.ToString(" 7").Trim() + " "; strSql += Convert.ToString(" end XH,").Trim() + " "; strSql += Convert.ToString(" case").Trim() + " "; strSql += Convert.ToString(" when grouping(fs_stoveno) = 1 and grouping(fs_steeltype) = 0 and").Trim() + " "; strSql += Convert.ToString(" grouping(fs_spec) = 1 and grouping(fn_length) = 1 and").Trim() + " "; strSql += Convert.ToString(" grouping(fs_store) = 1 and grouping(fs_transtype) = 1 then").Trim() + " "; strSql += Convert.ToString(" '牌号【' || fs_steeltype || '】小计:'").Trim() + " "; strSql += Convert.ToString(" when grouping(fs_stoveno) = 1 and grouping(fs_steeltype) = 1 and").Trim() + " "; strSql += Convert.ToString(" grouping(fs_spec) = 0 and grouping(fn_length) = 1 and").Trim() + " "; strSql += Convert.ToString(" grouping(fs_store) = 1 and grouping(fs_transtype) = 1 then").Trim() + " "; strSql += Convert.ToString(" '规格【' || fs_spec || '】小计:'").Trim() + " "; strSql += Convert.ToString(" when grouping(fs_stoveno) = 1 and grouping(fs_steeltype) = 1 and").Trim() + " "; strSql += Convert.ToString(" grouping(fs_spec) = 1 and grouping(fn_length) = 0 and").Trim() + " "; strSql += Convert.ToString(" grouping(fs_store) = 1 and grouping(fs_transtype) = 1 then").Trim() + " "; strSql += Convert.ToString(" '长度【' || fn_length || '】小计:'").Trim() + " "; strSql += Convert.ToString(" when grouping(fs_stoveno) = 1 and grouping(fs_steeltype) = 1 and").Trim() + " "; strSql += Convert.ToString(" grouping(fs_spec) = 1 and grouping(fn_length) = 1 and").Trim() + " "; strSql += Convert.ToString(" grouping(fs_store) = 0 and grouping(fs_transtype) = 1 then").Trim() + " "; strSql += Convert.ToString(" '去向【' || fs_store || '】小计:'").Trim() + " "; strSql += Convert.ToString(" when grouping(fs_stoveno) = 1 and grouping(fs_steeltype) = 1 and").Trim() + " "; strSql += Convert.ToString(" grouping(fs_spec) = 1 and grouping(fn_length) = 1 and").Trim() + " "; strSql += Convert.ToString(" grouping(fs_store) = 1 and grouping(fs_transtype) = 0 then").Trim() + " "; strSql += Convert.ToString(" '输送方式【' || fs_transtype || '】小计:'").Trim() + " "; strSql += Convert.ToString(" when grouping(fs_stoveno) = 1 and grouping(fs_steeltype) = 1 and").Trim() + " "; strSql += Convert.ToString(" grouping(fs_spec) = 1 and grouping(fn_length) = 1 and").Trim() + " "; strSql += Convert.ToString(" grouping(fs_store) = 1 and grouping(fs_transtype) = 1 then").Trim() + " "; strSql += Convert.ToString(" '总计:'").Trim() + " "; strSql += Convert.ToString(" when grouping(fs_steeltype) = 0 and grouping(fs_spec) = 0 and").Trim() + " "; strSql += Convert.ToString(" grouping(fn_length) = 0 and grouping(fs_store) = 0 and").Trim() + " "; strSql += Convert.ToString(" grouping(fs_transtype) = 0 then").Trim() + " "; strSql += Convert.ToString(" max(fs_stoveno)").Trim() + " "; strSql += Convert.ToString(" end fs_stoveno,").Trim() + " "; strSql += Convert.ToString(" case").Trim() + " "; strSql += Convert.ToString(" when grouping(fs_stoveno) = 0 and grouping(fs_steeltype) = 0 and").Trim() + " "; strSql += Convert.ToString(" grouping(fs_spec) = 0 and grouping(fn_length) = 0 and").Trim() + " "; strSql += Convert.ToString(" grouping(fs_store) = 0 and grouping(fs_transtype) = 0 then").Trim() + " "; strSql += Convert.ToString(" fs_steeltype").Trim() + " "; strSql += Convert.ToString(" end fs_steeltype,").Trim() + " "; strSql += Convert.ToString(" case").Trim() + " "; strSql += Convert.ToString(" when grouping(fs_stoveno) = 0 and grouping(fs_steeltype) = 0 and").Trim() + " "; strSql += Convert.ToString(" grouping(fs_spec) = 0 and grouping(fn_length) = 0 and").Trim() + " "; strSql += Convert.ToString(" grouping(fs_store) = 0 and grouping(fs_transtype) = 0 then").Trim() + " "; strSql += Convert.ToString(" fs_spec").Trim() + " "; strSql += Convert.ToString(" end fs_spec,").Trim() + " "; strSql += Convert.ToString(" case").Trim() + " "; strSql += Convert.ToString(" when grouping(fs_stoveno) = 0 and grouping(fs_steeltype) = 0 and").Trim() + " "; strSql += Convert.ToString(" grouping(fs_spec) = 0 and grouping(fn_length) = 0 and").Trim() + " "; strSql += Convert.ToString(" grouping(fs_store) = 0 and grouping(fs_transtype) = 0 then").Trim() + " "; strSql += Convert.ToString(" fn_length").Trim() + " "; strSql += Convert.ToString(" end fn_length,").Trim() + " "; strSql += Convert.ToString(" sum(nvl(fn_count, 0)) fn_count,").Trim() + " "; strSql += Convert.ToString(" sum(nvl(fn_billetcount, 0)) fn_billetcount,").Trim() + " "; strSql += Convert.ToString(" round(sum(nvl(fn_totalweight, 0)), 3) fn_totalweight,").Trim() + " "; strSql += Convert.ToString(" round(sum(nvl(fn_totalweight_ll, 0)), 3) fn_totalweight_ll,").Trim() + " "; strSql += Convert.ToString(" case").Trim() + " "; strSql += Convert.ToString(" when grouping(fs_stoveno) = 0 and grouping(fs_steeltype) = 0 and").Trim() + " "; strSql += Convert.ToString(" grouping(fs_spec) = 0 and grouping(fn_length) = 0 and").Trim() + " "; strSql += Convert.ToString(" grouping(fs_store) = 0 and grouping(fs_transtype) = 0 then").Trim() + " "; strSql += Convert.ToString(" max(fd_starttime)").Trim() + " "; strSql += Convert.ToString(" end fd_starttime,").Trim() + " "; strSql += Convert.ToString(" case").Trim() + " "; strSql += Convert.ToString(" when grouping(fs_stoveno) = 0 and grouping(fs_steeltype) = 0 and").Trim() + " "; strSql += Convert.ToString(" grouping(fs_spec) = 0 and grouping(fn_length) = 0 and").Trim() + " "; strSql += Convert.ToString(" grouping(fs_store) = 0 and grouping(fs_transtype) = 0 then").Trim() + " "; strSql += Convert.ToString(" max(fd_endtime)").Trim() + " "; strSql += Convert.ToString(" end fd_endtime,").Trim() + " "; strSql += Convert.ToString(" case").Trim() + " "; strSql += Convert.ToString(" when grouping(fs_stoveno) = 0 and grouping(fs_steeltype) = 0 and").Trim() + " "; strSql += Convert.ToString(" grouping(fs_spec) = 0 and grouping(fn_length) = 0 and").Trim() + " "; strSql += Convert.ToString(" grouping(fs_store) = 0 and grouping(fs_transtype) = 0 then").Trim() + " "; strSql += Convert.ToString(" fs_store").Trim() + " "; strSql += Convert.ToString(" end fs_store,").Trim() + " "; strSql += Convert.ToString(" case").Trim() + " "; strSql += Convert.ToString(" when grouping(fs_stoveno) = 0 and grouping(fs_steeltype) = 0 and").Trim() + " "; strSql += Convert.ToString(" grouping(fs_spec) = 0 and grouping(fn_length) = 0 and").Trim() + " "; strSql += Convert.ToString(" grouping(fs_store) = 0 and grouping(fs_transtype) = 0 then").Trim() + " "; strSql += Convert.ToString(" fs_transtype").Trim() + " "; strSql += Convert.ToString(" end fs_transtype,").Trim() + " "; strSql += Convert.ToString(" case").Trim() + " "; strSql += Convert.ToString(" when grouping(fs_stoveno) = 0 and grouping(fs_steeltype) = 0 and").Trim() + " "; strSql += Convert.ToString(" grouping(fs_spec) = 0 and grouping(fn_length) = 0 and").Trim() + " "; strSql += Convert.ToString(" grouping(fs_store) = 0 and grouping(fs_transtype) = 0 then").Trim() + " "; strSql += Convert.ToString(" max(fs_completeflag)").Trim() + " "; strSql += Convert.ToString(" end fs_completeflag,").Trim() + " "; strSql += Convert.ToString(" case").Trim() + " "; strSql += Convert.ToString(" when grouping(fs_stoveno) = 0 and grouping(fs_steeltype) = 0 and").Trim() + " "; strSql += Convert.ToString(" grouping(fs_spec) = 0 and grouping(fn_length) = 0 and").Trim() + " "; strSql += Convert.ToString(" grouping(fs_store) = 0 and grouping(fs_transtype) = 0 then").Trim() + " "; strSql += Convert.ToString(" max(chemout)").Trim() + " "; strSql += Convert.ToString(" end chemout,").Trim() + " "; strSql += Convert.ToString(" case").Trim() + " "; strSql += Convert.ToString(" when grouping(fs_stoveno) = 0 and grouping(fs_steeltype) = 0 and").Trim() + " "; strSql += Convert.ToString(" grouping(fs_spec) = 0 and grouping(fn_length) = 0 and").Trim() + " "; strSql += Convert.ToString(" grouping(fs_store) = 0 and grouping(fs_transtype) = 0 then").Trim() + " "; strSql += Convert.ToString(" max(fs_unqualified)").Trim() + " "; strSql += Convert.ToString(" end fs_unqualified").Trim() + " "; strSql += Convert.ToString(" from (select t.fs_stoveno,").Trim() + " "; strSql += Convert.ToString(" t.fs_steeltype,").Trim() + " "; strSql += Convert.ToString(" t.fs_spec,").Trim() + " "; strSql += Convert.ToString(" t.fn_length,").Trim() + " "; strSql += Convert.ToString(" 1 fn_count,").Trim() + " "; strSql += Convert.ToString(" t2.fn_billetcount,").Trim() + " "; strSql += Convert.ToString(" t2.fn_totalweight,").Trim() + " "; strSql += Convert.ToString(" round(round(decode(substr(t.fs_stoveno, 4, 1),").Trim() + " "; strSql += Convert.ToString(" '1',").Trim() + " "; strSql += Convert.ToString(" 0.174,").Trim() + " "; strSql += Convert.ToString(" '2',").Trim() + " "; strSql += Convert.ToString(" 0.174,").Trim() + " "; strSql += Convert.ToString(" '3',").Trim() + " "; strSql += Convert.ToString(" 0.176,").Trim() + " "; strSql += Convert.ToString(" 0.174) * t.fn_length, 3) * t2.fn_billetcount, 3)").Trim() + " "; strSql += Convert.ToString(" fn_totalweight_ll,").Trim() + " "; strSql += Convert.ToString(" to_char(t.fd_starttime, 'yyyy-MM-dd hh24:mi:ss') fd_starttime,").Trim() + " "; strSql += Convert.ToString(" to_char(t.fd_endtime, 'yyyy-MM-dd hh24:mi:ss') fd_endtime,").Trim() + " "; strSql += Convert.ToString(" decode(nvl(t.fs_store, t1.fs_gp_flow),").Trim() + " "; strSql += Convert.ToString(" 'SH000100',").Trim() + " "; strSql += Convert.ToString(" '高线',").Trim() + " "; strSql += Convert.ToString(" 'SH000098',").Trim() + " "; strSql += Convert.ToString(" '棒材') fs_store,").Trim() + " "; strSql += Convert.ToString(" decode(nvl(t.fs_transtype, t1.fs_transtype),").Trim() + " "; strSql += Convert.ToString(" '1',").Trim() + " "; strSql += Convert.ToString(" '1#辊道',").Trim() + " "; strSql += Convert.ToString(" '2',").Trim() + " "; strSql += Convert.ToString(" '2#辊道',").Trim() + " "; strSql += Convert.ToString(" '3',").Trim() + " "; strSql += Convert.ToString(" '汽车') fs_transtype,").Trim() + " "; strSql += Convert.ToString(" decode(t.fs_completeflag, '1', '√', '') fs_completeflag,").Trim() + " "; strSql += Convert.ToString(" case").Trim() + " "; strSql += Convert.ToString(" when nvl(t1.fn_gp_c, 0) = 0 then").Trim() + " "; strSql += Convert.ToString(" '无'").Trim() + " "; strSql += Convert.ToString(" end chemout,").Trim() + " "; strSql += Convert.ToString(" decode(nvl(t1.fs_unqualified,'0'),'1','不合格','合格') fs_unqualified").Trim() + " "; strSql += Convert.ToString(" from dt_steelweightmain t,").Trim() + " "; strSql += Convert.ToString(" it_fp_techcard t1,").Trim() + " "; strSql += Convert.ToString(" (select t1.fs_stoveno,").Trim() + " "; strSql += Convert.ToString(" count(1) fn_billetcount,").Trim() + " "; strSql += Convert.ToString(" sum(nvl(t1.fn_netweight, 0)) fn_totalweight").Trim() + " "; strSql += Convert.ToString(" from dt_steelweightdetailroll t1").Trim() + " "; strSql += Convert.ToString(" where exists").Trim() + " "; strSql += Convert.ToString(" (select 1").Trim() + " "; strSql += Convert.ToString(" from dt_steelweightmain t").Trim() + " "; strSql += Convert.ToString(" where t.fs_stoveno = t1.fs_stoveno " + strWhere + ")").Trim() + " "; strSql += Convert.ToString(" group by t1.fs_stoveno) t2").Trim() + " "; strSql += Convert.ToString(" where t.fs_stoveno = t1.fs_gp_stoveno(+)").Trim() + " "; strSql += Convert.ToString(" and t.fs_stoveno = t2.fs_stoveno(+) " + strWhere + ")").Trim() + " "; strSql += Convert.ToString(" group by cube(fs_stoveno,").Trim() + " "; strSql += Convert.ToString(" fs_steeltype,").Trim() + " "; strSql += Convert.ToString(" fs_spec,").Trim() + " "; strSql += Convert.ToString(" fn_length,").Trim() + " "; strSql += Convert.ToString(" fs_store,").Trim() + " "; strSql += Convert.ToString(" fs_transtype))").Trim() + " "; strSql += Convert.ToString(" where xh <> 7").Trim() + " "; strSql += Convert.ToString(" order by xh, fs_stoveno").Trim(); string err = ""; DataTable tbMain = null, tbDetail = null; DataSet ds = SelectReturnDS("ygjzjl.bar.DBHelp", "getSqlInfo", new object[] { strSql }, out err); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { tbMain = ds.Tables[0]; } else { if (!string.IsNullOrEmpty(err)) { MessageBox.Show("查询出错!\n" + err, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } dataTable2.Rows.Clear(); dataTable1.Rows.Clear(); return; } strSql = ""; strSql += Convert.ToString("select t.fs_weightno,").Trim() + " "; strSql += Convert.ToString(" t.fn_billetindex,").Trim() + " "; strSql += Convert.ToString(" t.fn_netweight,").Trim() + " "; strSql += Convert.ToString(" round(nvl(decode(substr(t.fs_stoveno, 4, 1),").Trim() + " "; strSql += Convert.ToString(" '1',").Trim() + " "; strSql += Convert.ToString(" 0.174,").Trim() + " "; strSql += Convert.ToString(" '2',").Trim() + " "; strSql += Convert.ToString(" 0.174,").Trim() + " "; strSql += Convert.ToString(" '3',").Trim() + " "; strSql += Convert.ToString(" 0.176,").Trim() + " "; strSql += Convert.ToString(" 0.174),").Trim() + " "; strSql += Convert.ToString(" 0.174) * t1.fn_length,").Trim() + " "; strSql += Convert.ToString(" 3) fn_netweight_ll,").Trim() + " "; strSql += Convert.ToString(" t2.fs_pointname fs_weightpoint,").Trim() + " "; strSql += Convert.ToString(" t.fs_person,t.FS_HISWEIGHT,").Trim() + " "; strSql += Convert.ToString(" to_char(t.fd_weighttime, 'yyyy-MM-dd HH24:mi:ss') fd_weighttime,").Trim() + " "; strSql += Convert.ToString(" decode(t.fs_thweitsingle, '1', '理重', '实重') fs_thweitsingle,").Trim() + " "; strSql += Convert.ToString(" t.fs_stoveno").Trim() + " "; strSql += Convert.ToString(" from dt_steelweightdetailroll t, dt_steelweightmain t1, bt_point t2").Trim() + " "; strSql += Convert.ToString(" where t.fs_stoveno = t1.fs_stoveno(+)").Trim() + " "; strSql += Convert.ToString(" and t.fs_weightpoint = t2.fs_pointcode(+)").Trim() + " "; strSql += Convert.ToString(" and exists").Trim() + " "; strSql += Convert.ToString(" (select 1").Trim() + " "; strSql += Convert.ToString(" from dt_steelweightmain t1").Trim() + " "; strSql += Convert.ToString(" where t1.fs_stoveno = t.fs_stoveno").Trim() + " "; if (cbxDateTime.Checked) { string strDateTimeFrom = dateTimePicker1.Value.ToString("yyyy-MM-dd HH:mm"); string strDateTimeTo = dateTimePicker2.Value.ToString("yyyy-MM-dd HH:mm"); strSql += Convert.ToString(" and t1.fd_starttime between to_date('" + strDateTimeFrom + "', 'yyyy-MM-dd HH24:mi') and to_date('" + strDateTimeTo + "', 'yyyy-MM-dd HH24:mi')").Trim() + " "; } if (!string.IsNullOrEmpty(tbQueryBatchNo.Text.Trim())) { strSql += Convert.ToString(" and t1.fs_stoveno like '%" + tbQueryBatchNo.Text.Trim() + "%'").Trim() + " "; } strSql += Convert.ToString(" ) order by t.fs_stoveno, t.fn_billetindex").Trim(); err = ""; ds = SelectReturnDS("ygjzjl.bar.DBHelp", "getSqlInfo", new object[] { strSql }, out err); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { tbDetail = ds.Tables[0]; ArrayList alistCnst1 = new ArrayList(); if (dataTable2.Constraints.Count > 0) { foreach (Constraint cnst in dataTable2.Constraints) { alistCnst1.Add(cnst); } dataTable2.Constraints.Clear(); } CommonMethod.CopyDataToDatatable(ref tbDetail, ref dataTable2, true); CommonMethod.CopyDataToDatatable(ref tbMain, ref dataTable1, true); for (int i = 0; i < alistCnst1.Count; i++) { dataTable2.Constraints.Add((Constraint)alistCnst1[i]); } } else { if (!string.IsNullOrEmpty(err)) { MessageBox.Show("查询出错!\n" + err, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } } this.MarkupRows(); Constant.RefreshAndAutoSize(ultraGrid1); if (ultraGrid1.Rows.Count > 0) { ultraGrid1.ActiveRow = ultraGrid1.Rows[0]; } }