XinYu_LG2MES/ClientSolution/Core.LgMes.Client.LgResMgt/弹出窗体/frmSelBillet.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using CoreFS.CA06;

namespace Core.LgMes.Client.LgResMgt
{
    public partial class frmSelBillet : Form
    {
        private CoreClientParam par;
        private string strReturn = "ExecuteCommand_Return", strNonReturn = "ExecuteCommand_NonReturn";

        public System.Collections.ArrayList alstReturn = new System.Collections.ArrayList();

        public frmSelBillet()
        {
            InitializeComponent();
            this.proc_Init();
        }

        private void frmSelBillet_Load(object sender, EventArgs e)
        {
            this.proc_Query();
        }

        private void proc_Init()
        {
            try
            {
                ultraDateTimeEditor2.DateTime = ultraDateTimeEditor1.DateTime = DateTime.Today;

                DataTable tbCCm = new DataTable();
                tbCCm.Columns.Add(new DataColumn("ID", typeof(System.String)));
                tbCCm.Columns.Add(new DataColumn("CAPTION", typeof(System.String)));
                tbCCm.Rows.Add("0", "所有");
                tbCCm.Rows.Add("1", "1#铸机");
                tbCCm.Rows.Add("2", "2#铸机");
                tbCCm.Rows.Add("3", "3#铸机");
                tbCCm.Rows.Add("4", "4#铸机");

                ultraCombo1.DataSource = tbCCm.DefaultView;
                ultraCombo1.ValueMember = "ID";
                ultraCombo1.DisplayMember = "CAPTION";
                ultraCombo1.DisplayLayout.BorderStyle = Infragistics.Win.UIElementBorderStyle.None;
                ultraCombo1.DisplayLayout.Bands[0].ColHeadersVisible = false;
                ultraCombo1.DisplayLayout.Bands[0].Columns["ID"].Hidden = true;
                ultraCombo1.DisplayLayout.Bands[0].Columns["CAPTION"].Width = ultraCombo1.Width;
                ultraCombo1.Rows[0].Selected = true;

                par = new CoreClientParam();
                par.ServerName = "lgResMgt.Core.LgMes.Server.LgResMgt";
                par.MethodName = "classResCommonModule";
                //par.ClassName = "Core.LgMes.Server.LgResMgt.classResCommonModule";
            }
            catch { }
        }

        private void proc_Query()
        {
            try
            {
                string strFrom = ultraDateTimeEditor1.DateTime.ToString("yyyy-MM-dd");
                string strTo = ultraDateTimeEditor2.DateTime.ToString("yyyy-MM-dd");
                string strWhere = "where to_char(CUTTIME, 'yyyy-MM-dd') between '" + strFrom + "' and '" + strTo + "'";

                string str = "";

                if (ultraCombo1.SelectedRow.Index > 0)
                {
                    str = ultraCombo1.Value.ToString();
                    strWhere += " and CCMID = '" + str + "'";
                }

                str = ultraTextEditor1.Text.Trim();
                if (str.Length > 0)
                    strWhere += " and HEATNO = '" + str + "'";

                string strErr = "";
                string strSql = "select * from "
                + "("
                + "select BILLETNO, "
                + "HEATNO, MOULDNO, CCMID, "
                + "THICKNESS, WIDTH, LENGTH, WEIGHT, "
                + "to_char(CUTTIME, 'yyyy-MM-dd HH24:mi') CUTTIME "
                + "from JOB_INCISION " + strWhere + " "

                + "union all "

                + "select BILLETNO, "
                + "HEATNO, MOULDNO, CCMID, "
                + "THICKNESS, WIDTH, LENGTH, WEIGHT, "
                + "to_char(CUTTIME, 'yyyy-MM-dd HH24:mi') CUTTIME "
                + "from J#JOB_INCISION " + strWhere + " "
                + ")"

                + "order by CCMID, CUTTIME, BILLETNO ";

                par.MethodName = strReturn;
                par.ServerParams = new object[] { strSql };

                DataSet ds = null; //hengxing ClientCommon._RemotingHelp.ExecuteMethod(par, out strErr) as DataSet;

                if (strErr != "" || !(ds != null && ds.Tables.Count > 0))
                {
                    MessageBox.Show("数据查询失败！\r\n" + strErr, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                }

                this.ultraDataSource1.Rows.Clear();
                DataRow dr = null;
                for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                {
                    dr = ds.Tables[0].Rows[i];
                    this.ultraDataSource1.Rows.Add(new object[] { 
                                                                    dr["BILLETNO"].ToString(),
                                                                    dr["HEATNO"].ToString(),
                                                                    dr["MOULDNO"].ToString(),
                                                                    dr["CCMID"].ToString(),
                                                                    dr["THICKNESS"].ToString(),
                                                                    dr["WIDTH"].ToString(),
                                                                    dr["LENGTH"].ToString(),
                                                                    dr["WEIGHT"].ToString(),
                                                                    dr["CUTTIME"].ToString()
                                                                });
                }

                this.ultraGrid1.Refresh();
                if (this.ultraGrid1.Rows.Count > 0)
                    this.ultraGrid1.ActiveRow = this.ultraGrid1.Rows[0];
                Infragistics.Win.UltraWinGrid.UltraGridRow row = ultraGrid1.ActiveRow;
                if (row != null) row.Selected = true;
                btnOK.Enabled = (row != null);
            }
            catch { }
        }

        private void proc_OK()
        {
            try
            {
                Infragistics.Win.UltraWinGrid.UltraGridRow row = ultraGrid1.ActiveRow;
                if (row == null) return;

                alstReturn.Add(row.Cells["BILLETNO"].Value);
                alstReturn.Add(row.Cells["HEATNO"].Value);
                alstReturn.Add(row.Cells["THICKNESS"].Value);
                alstReturn.Add(row.Cells["WIDTH"].Value);

                this.DialogResult = DialogResult.OK;
            }
            catch
            {
                alstReturn = null;
                this.DialogResult = DialogResult.Cancel;
            }
            finally
            {
                this.Close();
            }
        }

        private void ultraTextEditor_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
        {
            try
            {
                Infragistics.Win.UltraWinEditors.UltraTextEditor ultraTextEditor = (Infragistics.Win.UltraWinEditors.UltraTextEditor)sender;
                if (ultraTextEditor == null) return;

                if (ultraTextEditor.Text.Trim().Length > 0)
                {
                    ultraTextEditor.Tag = ultraTextEditor.Text.Trim();
                    ultraTextEditor.Text = "";
                }
                else
                {
                    if (ultraTextEditor.Tag != null)
                    {
                        ultraTextEditor.Text = Convert.ToString(ultraTextEditor.Tag);
                    }
                }
            }
            catch { }
        }

        private void ultraGrid1_DoubleClickRow(object sender, Infragistics.Win.UltraWinGrid.DoubleClickRowEventArgs e)
        {
            proc_OK();
        }

        private void btnQuery_Click(object sender, EventArgs e)
        {
            this.proc_Query();
        }

        private void btnOK_Click(object sender, EventArgs e)
        {
            this.proc_OK();
        }

        private void btnCancel_Click(object sender, EventArgs e)
        {
            this.DialogResult = DialogResult.Cancel;
            this.Close();
        }
    }
}