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];
}
}
