private void GetStockInfo(QueryOpportunity Opp)
{
//PL/SQL Special Copy
string strSql = "";
strSql += Convert.ToString("select 'false' checked,").Trim() + " ";
strSql += Convert.ToString(" t.fs_gp_stoveno,").Trim() + " ";
strSql += Convert.ToString(" t.fs_gp_steeltype,").Trim() + " ";
strSql += Convert.ToString(" t.fs_gp_spe,").Trim() + " ";
strSql += Convert.ToString(" round(t.fn_gp_len, 3) fn_gp_len,").Trim() + " ";
strSql += Convert.ToString(" t.fn_billet_count,").Trim() + " ";
strSql += Convert.ToString(" round(t.fn_billet_weight, 3) fn_billet_weight,").Trim() + " ";
strSql += Convert.ToString(" round(t.fn_billet_count * round(0.21 * t.fn_gp_len, 3), 3) fn_billet_weight_ll,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gp_c,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gp_si,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gp_mn,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gp_s,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gp_p,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gp_ni,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gp_cr,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gp_cu,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gp_v,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gp_mo,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gp_ceq,").Trim() + " ";
strSql += Convert.ToString(" t.fs_gp_memo,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gp_as,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gp_ti,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gp_sb,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gp_als,").Trim() + " ";
strSql += Convert.ToString(" t.fs_gp_judger,").Trim() + " ";
strSql += Convert.ToString(" to_char(t.fd_gp_judgedate, 'yyyy-MM-dd hh24:mi:ss') fd_gp_judgedate,").Trim() + " ";
strSql += Convert.ToString(" t.fs_cardno,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gpys_number,").Trim() + " ";
strSql += Convert.ToString(" nvl(t.fs_unqualified, '0') fs_unqualified,").Trim() + " ";
strSql += Convert.ToString(" round(t.fn_gpys_weight, 3) fn_gpys_weight,").Trim() + " ";
strSql += Convert.ToString(" round(nvl(t.fn_gpys_number, 0) * round(0.21 * t.fn_gp_len, 3), 3) fn_gpys_weight_ll,").Trim() + " ";
strSql += Convert.ToString(" decode(t.fs_checked, '1', '√', '') fs_checked").Trim() + " ";
strSql += Convert.ToString(" from it_fp_techcard t").Trim() + " ";
strSql += Convert.ToString(" where nvl(t.fs_batched, '0') = '0'").Trim() + " ";
strSql += Convert.ToString(" and t.fs_zc_batchno is null").Trim() + " ";
strSql += Convert.ToString(" and t.fs_gp_flow = '" + this._STOCK + "'").Trim() + " ";
strSql += Convert.ToString(" and nvl(t.fs_isvalid, '0') = '0'").Trim() + " ";
strSql += Convert.ToString(" and t.fs_checked = '1'").Trim() + " ";
strSql += Convert.ToString(" and nvl(t.fn_gpys_number, 0) > 0").Trim() + " ";
if (Opp == QueryOpportunity.UI)
{
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 t.fd_gp_judgedate between to_date('" + strDateTimeFrom + "', 'yyyy-MM-dd HH24:mi') and to_date('" + strDateTimeTo + "', 'yyyy-MM-dd HH24:mi')").Trim() + " ";
}
if (!string.IsNullOrEmpty(tbQueryButtressNo.Text.Trim()))
{
strSql += Convert.ToString(" and t.fs_djh like '%" + tbQueryButtressNo.Text.Trim() + "%'").Trim() + " ";
}
if (!string.IsNullOrEmpty(tbQueryStoveNo.Text.Trim()))
{
strSql += Convert.ToString(" and t.fs_gp_stoveno like '%" + tbQueryStoveNo.Text.Trim() + "%'").Trim() + " ";
}
}
strSql += Convert.ToString(" order by t.fs_gp_stoveno").Trim();
string err = "";
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)
{
DataTable table = ds.Tables[0];
CommonMethod.CopyDataToDatatable(ref table, ref dataTable1, true);
}
else
{
if (!string.IsNullOrEmpty(err))
{
MessageBox.Show("查询出错！\n" + err, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
dataTable1.Rows.Clear();
}
this.MarkupRows();
CommonMethod.RefreshAndAutoSize(ultraGrid2);
this.BatchCalc();
}
private void GetStockInfo(QueryOpportunity Opp)
{
//PL/SQL Special Copy
string strSql = "";
strSql += Convert.ToString("select 'false' checked,").Trim() + " ";
strSql += Convert.ToString(" t.fs_gp_stoveno,").Trim() + " ";
strSql += Convert.ToString(" t.fs_gp_steeltype,").Trim() + " ";
strSql += Convert.ToString(" t.fs_gp_spe,").Trim() + " ";
strSql += Convert.ToString(" round(t.fn_gp_len, 3) fn_gp_len,").Trim() + " ";
strSql += Convert.ToString(" t.fn_billet_count,").Trim() + " ";
strSql += Convert.ToString(" round(t.fn_billet_weight, 3) fn_billet_weight,").Trim() + " ";
strSql += Convert.ToString(" round(t.fn_billet_count * round(0.21 * t.fn_gp_len, 3), 3) fn_billet_weight_ll,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gp_c,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gp_si,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gp_mn,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gp_s,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gp_p,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gp_ni,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gp_cr,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gp_cu,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gp_v,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gp_mo,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gp_ceq,").Trim() + " ";
strSql += Convert.ToString(" t.fs_gp_memo,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gp_as,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gp_ti,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gp_sb,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gp_als,").Trim() + " ";
strSql += Convert.ToString(" t.fs_gp_judger,").Trim() + " ";
strSql += Convert.ToString(" to_char(t.fd_gp_judgedate, 'yyyy-MM-dd hh24:mi:ss') fd_gp_judgedate,").Trim() + " ";
strSql += Convert.ToString(" t.fs_cardno,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gpys_number,").Trim() + " ";
strSql += Convert.ToString(" nvl(t.fs_unqualified, '0') fs_unqualified,").Trim() + " ";
strSql += Convert.ToString(" round(t.fn_gpys_weight, 3) fn_gpys_weight,").Trim() + " ";
strSql += Convert.ToString(" round(nvl(t.fn_gpys_number, 0) * round(0.21 * t.fn_gp_len, 3), 3) fn_gpys_weight_ll,").Trim() + " ";
strSql += Convert.ToString(" decode(t.fs_checked, '1', '��', '') fs_checked").Trim() + " ";
strSql += Convert.ToString(" from it_fp_techcard t").Trim() + " ";
strSql += Convert.ToString(" where nvl(t.fs_batched, '0') = '0'").Trim() + " ";
strSql += Convert.ToString(" and t.fs_zc_batchno is null").Trim() + " ";
strSql += Convert.ToString(" and t.fs_gp_flow = '" + this._STOCK + "'").Trim() + " ";
strSql += Convert.ToString(" and nvl(t.fs_isvalid, '0') = '0'").Trim() + " ";
strSql += Convert.ToString(" and t.fs_checked = '1'").Trim() + " ";
strSql += Convert.ToString(" and nvl(t.fn_gpys_number, 0) > 0").Trim() + " ";
if (Opp == QueryOpportunity.UI)
{
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 t.fd_gp_judgedate between to_date('" + strDateTimeFrom + "', 'yyyy-MM-dd HH24:mi') and to_date('" + strDateTimeTo + "', 'yyyy-MM-dd HH24:mi')").Trim() + " ";
}
if (!string.IsNullOrEmpty(tbQueryButtressNo.Text.Trim()))
{
strSql += Convert.ToString(" and t.fs_djh like '%" + tbQueryButtressNo.Text.Trim() + "%'").Trim() + " ";
}
if (!string.IsNullOrEmpty(tbQueryStoveNo.Text.Trim()))
{
strSql += Convert.ToString(" and t.fs_gp_stoveno like '%" + tbQueryStoveNo.Text.Trim() + "%'").Trim() + " ";
}
}
strSql += Convert.ToString(" order by t.fs_gp_stoveno").Trim();
string err = "";
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)
{
DataTable table = ds.Tables[0];
CommonMethod.CopyDataToDatatable(ref table, ref dataTable1, true);
}
else
{
if (!string.IsNullOrEmpty(err))
{
MessageBox.Show("��ѯ�����\n" + err, "��ʾ", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
dataTable1.Rows.Clear();
}
this.MarkupRows();
CommonMethod.RefreshAndAutoSize(ultraGrid2);
this.BatchCalc();
}
private void GetBatchInfo(QueryOpportunity Opp)
{
//PL/SQL SPECIAL COPY
string strSql = "";
strSql += Convert.ToString("select distinct t.fs_zc_batchno,").Trim() + " ";
strSql += Convert.ToString(" max(t.fn_zz_spec) over(partition by t.fs_zc_batchno) fn_zz_spec,").Trim() + " ";
strSql += Convert.ToString(" max(t.fn_length) over(partition by t.fs_zc_batchno) fn_length,").Trim() + " ";
strSql += Convert.ToString(" max(t.fs_gp_steeltype) over(partition by t.fs_zc_batchno) fs_gp_steeltype,").Trim() + " ";
strSql += Convert.ToString(" max(t.fs_zc_orderno) over(partition by t.fs_zc_batchno) fs_zc_orderno,").Trim() + " ";
strSql += Convert.ToString(" max(t.fs_gp_spe) over(partition by t.fs_zc_batchno) fs_gp_spe,").Trim() + " ";
strSql += Convert.ToString(" max(t.fn_gp_len) over(partition by t.fs_zc_batchno) fn_gp_len,").Trim() + " ";
strSql += Convert.ToString(" sum(nvl(t.fn_billet_count, 0)) over(partition by t.fs_zc_batchno) fn_billet_count,").Trim() + " ";
strSql += Convert.ToString(" sum(nvl(t.fn_billet_weight, 0)) over(partition by t.fs_zc_batchno) fn_billet_weight,").Trim() + " ";
strSql += Convert.ToString(" sum(nvl(t.fn_billet_weight_ll, 0)) over(partition by t.fs_zc_batchno) fn_billet_weight_ll,").Trim() + " ";
strSql += Convert.ToString(" max(t.fs_batch_optor) over(partition by t.fs_zc_batchno) fs_batch_optor,").Trim() + " ";
strSql += Convert.ToString(" max(t.fs_batch_optdate) over(partition by t.fs_zc_batchno) fs_batch_optdate").Trim() + " ";
strSql += Convert.ToString(" from (select t.fs_zc_batchno,").Trim() + " ";
strSql += Convert.ToString(" t.fn_zz_spec,").Trim() + " ";
strSql += Convert.ToString(" round(t.fn_length, 3) fn_length,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gpys_number fn_billet_count,").Trim() + " ";
strSql += Convert.ToString(" t.fs_gp_steeltype,").Trim() + " ";
strSql += Convert.ToString(" t.fs_zc_orderno,").Trim() + " ";
strSql += Convert.ToString(" t.fs_gp_spe,").Trim() + " ";
strSql += Convert.ToString(" round(t.fn_gp_len, 3) fn_gp_len,").Trim() + " ";
strSql += Convert.ToString(" t.fs_batch_optor,").Trim() + " ";
strSql += Convert.ToString(" to_char(t.fs_batch_optdate, 'yyyy-MM-dd HH24:mi:ss') fs_batch_optdate,").Trim() + " ";
strSql += Convert.ToString(" round(t.fn_gpys_weight, 3) fn_billet_weight,").Trim() + " ";
strSql += Convert.ToString(" round(nvl(fn_gpys_number, 0) * round(0.21 * nvl(t.fn_gp_len, 0), 3), 3) fn_billet_weight_ll").Trim() + " ";
strSql += Convert.ToString(" from it_fp_techcard t").Trim() + " ";
strSql += Convert.ToString(" where t.fs_batched = '1'").Trim() + " ";
strSql += Convert.ToString(" and t.fs_zc_batchno is not null").Trim() + " ";
strSql += Convert.ToString(" and t.fs_gp_flow = '" + this._STOCK + "'").Trim() + " ";
strSql += Convert.ToString(" and nvl(t.fs_isvalid, '0') = '0'").Trim() + " ";
if (Opp == QueryOpportunity.UI)
{
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 t.fs_batch_optdate 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 t.fs_zc_batchno like '%" + tbQueryBatchNo.Text.Trim() + "%'").Trim() + " ";
}
if (!string.IsNullOrEmpty(tbQueryStoveNo.Text.Trim()))
{
strSql += Convert.ToString(" and exists (select 1 from (select x.fs_zc_batchno from it_fp_techcard x where x.fs_batched = '1' and x.fs_gp_stoveno like '%" + tbQueryStoveNo.Text.Trim() + "%') x where x.fs_zc_batchno = t.fs_zc_batchno)").Trim() + " ";
}
}
else
{
strSql += Convert.ToString(" and t.fs_batch_optdate > (sysdate - 1)").Trim() + " ";
}
strSql += Convert.ToString(" ) t order by FS_ZC_BATCHNO desc").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;
}
dataTable3.Rows.Clear();
dataTable2.Rows.Clear();
return;
}
strSql = "";
strSql += Convert.ToString("select t.fs_gp_stoveno,").Trim() + " ";
strSql += Convert.ToString(" t.fs_gp_steeltype,").Trim() + " ";
strSql += Convert.ToString(" t.fs_gp_spe,").Trim() + " ";
strSql += Convert.ToString(" round(t.fn_gp_len, 3) fn_gp_len,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gpys_number fn_billet_count,").Trim() + " ";
strSql += Convert.ToString(" round(t.fn_gpys_weight, 3) fn_billet_weight,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gp_c,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gp_si,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gp_mn,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gp_s,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gp_p,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gp_ni,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gp_cr,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gp_cu,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gp_v,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gp_mo,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gp_ceq,").Trim() + " ";
strSql += Convert.ToString(" t.fs_gp_memo,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gp_as,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gp_ti,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gp_sb,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gp_als,").Trim() + " ";
strSql += Convert.ToString(" t.fs_gp_judger,").Trim() + " ";
strSql += Convert.ToString(" to_char(t.fd_gp_judgedate, 'yyyy-mm-dd hh24:mi:ss') fd_gp_judgedate,").Trim() + " ";
strSql += Convert.ToString(" t.fs_zc_batchno,").Trim() + " ";
strSql += Convert.ToString(" t.fs_cardno").Trim() + " ";
strSql += Convert.ToString(" from it_fp_techcard t").Trim() + " ";
strSql += Convert.ToString(" where t.fs_batched = '1'").Trim() + " ";
strSql += Convert.ToString(" and t.fs_zc_batchno is not null").Trim() + " ";
strSql += Convert.ToString(" and t.fs_gp_flow = '" + this._STOCK + "'").Trim() + " ";
strSql += Convert.ToString(" and nvl(t.fs_isvalid, '0') = '0'").Trim() + " ";
if (Opp == QueryOpportunity.UI)
{
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 t.fs_batch_optdate 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 t.fs_zc_batchno like '%" + tbQueryBatchNo.Text.Trim() + "%'").Trim() + " ";
}
if (!string.IsNullOrEmpty(tbQueryStoveNo.Text.Trim()))
{
strSql += Convert.ToString(" and exists (select 1 from (select x.fs_zc_batchno from it_fp_techcard x where x.fs_batched = '1' and x.fs_gp_stoveno like '%" + tbQueryStoveNo.Text.Trim() + "%') x where x.fs_zc_batchno = t.fs_zc_batchno)").Trim() + " ";
}
}
else
{
strSql += Convert.ToString(" and t.fs_batch_optdate > (sysdate - 1)").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 (dataTable3.Constraints.Count > 0)
{
foreach (Constraint cnst in dataTable3.Constraints)
{
alistCnst1.Add(cnst);
}
dataTable3.Constraints.Clear();
}
CommonMethod.CopyDataToDatatable(ref tbDetail, ref dataTable3, true);
CommonMethod.CopyDataToDatatable(ref tbMain, ref dataTable2, true);
for (int i = 0; i < alistCnst1.Count; i++)
{
dataTable3.Constraints.Add((Constraint)alistCnst1[i]);
}
}
else
{
if (!string.IsNullOrEmpty(err))
{
MessageBox.Show("查询出错！\n" + err, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
CommonMethod.RefreshAndAutoSize(ultraGrid1);
if (ultraGrid1.Rows.Count > 0)
{
ultraGrid1.ActiveRow = ultraGrid1.Rows[0];
}
}
private void GetBatchInfo(QueryOpportunity Opp)
{
//PL/SQL SPECIAL COPY
string strSql = "";
strSql += Convert.ToString("select distinct t.fs_zc_batchno,").Trim() + " ";
strSql += Convert.ToString(" max(t.fn_zz_spec) over(partition by t.fs_zc_batchno) fn_zz_spec,").Trim() + " ";
strSql += Convert.ToString(" max(t.fn_length) over(partition by t.fs_zc_batchno) fn_length,").Trim() + " ";
strSql += Convert.ToString(" max(t.fs_gp_steeltype) over(partition by t.fs_zc_batchno) fs_gp_steeltype,").Trim() + " ";
strSql += Convert.ToString(" max(t.fs_zc_orderno) over(partition by t.fs_zc_batchno) fs_zc_orderno,").Trim() + " ";
strSql += Convert.ToString(" max(t.fs_gp_spe) over(partition by t.fs_zc_batchno) fs_gp_spe,").Trim() + " ";
strSql += Convert.ToString(" max(t.fn_gp_len) over(partition by t.fs_zc_batchno) fn_gp_len,").Trim() + " ";
strSql += Convert.ToString(" sum(nvl(t.fn_billet_count, 0)) over(partition by t.fs_zc_batchno) fn_billet_count,").Trim() + " ";
strSql += Convert.ToString(" sum(nvl(t.fn_billet_weight, 0)) over(partition by t.fs_zc_batchno) fn_billet_weight,").Trim() + " ";
strSql += Convert.ToString(" sum(nvl(t.fn_billet_weight_ll, 0)) over(partition by t.fs_zc_batchno) fn_billet_weight_ll,").Trim() + " ";
strSql += Convert.ToString(" max(t.fs_batch_optor) over(partition by t.fs_zc_batchno) fs_batch_optor,").Trim() + " ";
strSql += Convert.ToString(" max(t.fs_batch_optdate) over(partition by t.fs_zc_batchno) fs_batch_optdate").Trim() + " ";
strSql += Convert.ToString(" from (select t.fs_zc_batchno,").Trim() + " ";
strSql += Convert.ToString(" t.fn_zz_spec,").Trim() + " ";
strSql += Convert.ToString(" round(t.fn_length, 3) fn_length,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gpys_number fn_billet_count,").Trim() + " ";
strSql += Convert.ToString(" t.fs_gp_steeltype,").Trim() + " ";
strSql += Convert.ToString(" t.fs_zc_orderno,").Trim() + " ";
strSql += Convert.ToString(" t.fs_gp_spe,").Trim() + " ";
strSql += Convert.ToString(" round(t.fn_gp_len, 3) fn_gp_len,").Trim() + " ";
strSql += Convert.ToString(" t.fs_batch_optor,").Trim() + " ";
strSql += Convert.ToString(" to_char(t.fs_batch_optdate, 'yyyy-MM-dd HH24:mi:ss') fs_batch_optdate,").Trim() + " ";
strSql += Convert.ToString(" round(t.fn_gpys_weight, 3) fn_billet_weight,").Trim() + " ";
strSql += Convert.ToString(" round(nvl(fn_gpys_number, 0) * round(0.21 * nvl(t.fn_gp_len, 0), 3), 3) fn_billet_weight_ll").Trim() + " ";
strSql += Convert.ToString(" from it_fp_techcard t").Trim() + " ";
strSql += Convert.ToString(" where t.fs_batched = '1'").Trim() + " ";
strSql += Convert.ToString(" and t.fs_zc_batchno is not null").Trim() + " ";
strSql += Convert.ToString(" and t.fs_gp_flow = '" + this._STOCK + "'").Trim() + " ";
strSql += Convert.ToString(" and nvl(t.fs_isvalid, '0') = '0'").Trim() + " ";
if (Opp == QueryOpportunity.UI)
{
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 t.fs_batch_optdate 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 t.fs_zc_batchno like '%" + tbQueryBatchNo.Text.Trim() + "%'").Trim() + " ";
}
if (!string.IsNullOrEmpty(tbQueryStoveNo.Text.Trim()))
{
strSql += Convert.ToString(" and exists (select 1 from (select x.fs_zc_batchno from it_fp_techcard x where x.fs_batched = '1' and x.fs_gp_stoveno like '%" + tbQueryStoveNo.Text.Trim() + "%') x where x.fs_zc_batchno = t.fs_zc_batchno)").Trim() + " ";
}
}
else
{
strSql += Convert.ToString(" and t.fs_batch_optdate > (sysdate - 1)").Trim() + " ";
}
strSql += Convert.ToString(" ) t order by FS_ZC_BATCHNO desc").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;
}
dataTable3.Rows.Clear();
dataTable2.Rows.Clear();
return;
}
strSql = "";
strSql += Convert.ToString("select t.fs_gp_stoveno,").Trim() + " ";
strSql += Convert.ToString(" t.fs_gp_steeltype,").Trim() + " ";
strSql += Convert.ToString(" t.fs_gp_spe,").Trim() + " ";
strSql += Convert.ToString(" round(t.fn_gp_len, 3) fn_gp_len,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gpys_number fn_billet_count,").Trim() + " ";
strSql += Convert.ToString(" round(t.fn_gpys_weight, 3) fn_billet_weight,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gp_c,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gp_si,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gp_mn,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gp_s,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gp_p,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gp_ni,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gp_cr,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gp_cu,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gp_v,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gp_mo,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gp_ceq,").Trim() + " ";
strSql += Convert.ToString(" t.fs_gp_memo,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gp_as,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gp_ti,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gp_sb,").Trim() + " ";
strSql += Convert.ToString(" t.fn_gp_als,").Trim() + " ";
strSql += Convert.ToString(" t.fs_gp_judger,").Trim() + " ";
strSql += Convert.ToString(" to_char(t.fd_gp_judgedate, 'yyyy-mm-dd hh24:mi:ss') fd_gp_judgedate,").Trim() + " ";
strSql += Convert.ToString(" t.fs_zc_batchno,").Trim() + " ";
strSql += Convert.ToString(" t.fs_cardno").Trim() + " ";
strSql += Convert.ToString(" from it_fp_techcard t").Trim() + " ";
strSql += Convert.ToString(" where t.fs_batched = '1'").Trim() + " ";
strSql += Convert.ToString(" and t.fs_zc_batchno is not null").Trim() + " ";
strSql += Convert.ToString(" and t.fs_gp_flow = '" + this._STOCK + "'").Trim() + " ";
strSql += Convert.ToString(" and nvl(t.fs_isvalid, '0') = '0'").Trim() + " ";
if (Opp == QueryOpportunity.UI)
{
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 t.fs_batch_optdate 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 t.fs_zc_batchno like '%" + tbQueryBatchNo.Text.Trim() + "%'").Trim() + " ";
}
if (!string.IsNullOrEmpty(tbQueryStoveNo.Text.Trim()))
{
strSql += Convert.ToString(" and exists (select 1 from (select x.fs_zc_batchno from it_fp_techcard x where x.fs_batched = '1' and x.fs_gp_stoveno like '%" + tbQueryStoveNo.Text.Trim() + "%') x where x.fs_zc_batchno = t.fs_zc_batchno)").Trim() + " ";
}
}
else
{
strSql += Convert.ToString(" and t.fs_batch_optdate > (sysdate - 1)").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 (dataTable3.Constraints.Count > 0)
{
foreach (Constraint cnst in dataTable3.Constraints)
{
alistCnst1.Add(cnst);
}
dataTable3.Constraints.Clear();
}
CommonMethod.CopyDataToDatatable(ref tbDetail, ref dataTable3, true);
CommonMethod.CopyDataToDatatable(ref tbMain, ref dataTable2, true);
for (int i = 0; i < alistCnst1.Count; i++)
{
dataTable3.Constraints.Add((Constraint)alistCnst1[i]);
}
}
else
{
if (!string.IsNullOrEmpty(err))
{
MessageBox.Show("��ѯ�����\n" + err, "��ʾ", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
CommonMethod.RefreshAndAutoSize(ultraGrid1);
if (ultraGrid1.Rows.Count > 0)
{
ultraGrid1.ActiveRow = ultraGrid1.Rows[0];
}
}
