YG-OPP-WCS-Client/WCS_Client/From/From_Task/Form_TaskDis.cs

using CCWin;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using WCS_Client.UC;
using WCS_Client.Utility;

namespace WCS_Client.From
{
    public partial class Form_TaskDis : CCSkinMain
    {
        DataTable _dt;
        DataRow _currentDr;
        public Form_TaskDis()
        {
            InitializeComponent();
            Bind();
        }
        private static Form_TaskDis childFromInstanc;
        public static Form_TaskDis ChildFromInstanc
        {
            get
            {
                if (childFromInstanc == null || childFromInstanc.IsDisposed)
                {
                    childFromInstanc = new Form_TaskDis();
                }
                return childFromInstanc;
            }
        }
        //加载任务类型下拉列表
        private void SelectTaskType()
        {
            try
            {
                DataTable dt = BaseWorkflow.QueryTaskType();
                if (dt == null || dt.Rows.Count == 0)
                {
                    cboTasktype.Items.Clear();
                }
                else
                {
                    cboTasktype.DisplayMember = "MEP_MAPPINGCHNAME";
                    cboTasktype.ValueMember = "MEP_MAPPINGNO";
                    cboTasktype.DataSource = dt;
                    cboTasktype.SelectedIndex = 0;
                }
            }
            catch (Exception ex)
            {

            }
        }

        //绑定数据
        private void Bind()
        {
            PageData pd = QueryPageDataMethods(pagerControl1.CurrentPage, pagerControl1.PageSize);
            if (pd == null)
            {
                if (_dt != null)
                    _dt.Clear();
            }
            else
            {
                pagerControl1.Record = pd.RowsCount;
                dgvTask.DataSource = pd.Dt;
                _dt = pd.Dt;
            }
        }

        //获取数据集
        private PageData QueryPageDataMethods(int PageIndex, int PageSize)
        {
            string _SQLText = @"SELECT task_id,task_no,task_systype,task_posidfrom,task_posidcur,task_posidnext,task_posidto,task_posidmove,task_priority,
    task_whid,task_adduserno,task_adddatetime,task_edituserno,task_editdatetime,task_notes,task_srmno,task_boxbarcode,TASK_DELETEDATE,
    m.MEP_MAPPINGCHNAME task_comtypech, me.MEP_MAPPINGCHNAME task_wkstatusch
FROM wcs_task_dis t
left join WCS_MAPPINGENTRY m on t.task_comtype = m.MEP_MAPPINGNO and m.MEP_MAPPINGTYPE = 'COMTYPE'
left join WCS_MAPPINGENTRY me on t.task_wkstatus = me.MEP_MAPPINGNO and me.MEP_MAPPINGTYPE = 'WkStatus' where 1=1 ";
            List<string> wherelist = new List<string>();
            if (nudTaskNo.Value > 0 && string.IsNullOrWhiteSpace(nudTaskNo.Text) == false)
                wherelist.Add(string.Format("task_no={0}", nudTaskNo.Value));
            if (string.IsNullOrWhiteSpace(cboTasktype.Text) == false)
                wherelist.Add(string.Format("m.MEP_MAPPINGCHNAME like '%{0}%'", cboTasktype.Text));
            if (string.IsNullOrWhiteSpace(txtStartAdrress.Text.Trim()) == false)
                wherelist.Add(string.Format("task_posidfrom like '%{0}%'", txtStartAdrress.Text.Trim()));
            if (string.IsNullOrWhiteSpace(txtBarCode.Text.Trim()) == false)
                wherelist.Add(string.Format("task_boxbarcode like '%{0}%'",txtBarCode.Text.Trim()));
            if(string.IsNullOrWhiteSpace(skinDateTimePicker1.text)==false)
            {
                DateTime startdate = Convert.ToDateTime(skinDateTimePicker1.text);
                string starttime = startdate.ToString("yyyy-MM-dd");
                wherelist.Add(string.Format("to_char(task_adddatetime,'yyyy-mm-dd')>='{0}'", starttime));
            }
            if (string.IsNullOrWhiteSpace(skinDateTimePicker2.text) == false)
            {
                DateTime enddate = Convert.ToDateTime(skinDateTimePicker2.text);
                string endtime = enddate.ToString("yyyy-MM-dd");
                wherelist.Add(string.Format("to_char(task_adddatetime,'yyyy-mm-dd')<='{0}'", endtime));
            }

            string _Orderby = " task_no desc";
            PageData pd = BaseWorkflow.QueryPageData(_SQLText, _Orderby, wherelist, PageIndex, PageSize);
            return pd;
        }

        private void btn_QueryTask_Click(object sender, EventArgs e)
        {
            Bind();
        }

        private void btnQueryTaskDtl_Click(object sender, EventArgs e)
        {
            SelectedRow();
            FormTaskDis_dtl taskdis_dtl = new FormTaskDis_dtl(_currentDr["TASK_ID"].ToString());
            taskdis_dtl.ShowDialog();
        }
        protected virtual bool SelectedRow()
        {
            _currentDr = GetDgvRow("TASK_ID");
            if (_currentDr == null)
            {
                MessageUtil.ShowWarning("请选中行！！！");
                return false;
            }
            return true;
        }
        public DataRow GetDgvRow(string cellName)
        {
            try
            {
                if (dgvTask.CurrentCell == null) return null;
                if (dgvTask.CurrentCell.RowIndex >= 0)
                {
                    string no = Convert.ToString(dgvTask.Rows[dgvTask.CurrentCell.RowIndex].Cells[cellName].Value);
                    return _dt.Select(cellName + "='" + no + "'")[0];
                }
                return null;
            }
            catch (Exception ex)
            {
                return null;
            }

        }

        private void Form_TaskDis_Load(object sender, EventArgs e)
        {
            SelectTaskType();
            cboTasktype.SelectedIndex = -1;
        }

        private void btnResert_Click(object sender, EventArgs e)
        {
            nudTaskNo.Value = 0;
            cboTasktype.SelectedIndex = -1;
            txtStartAdrress.Text = string.Empty;
            txtBarCode.Text = string.Empty;
            skinDateTimePicker1.Text = string.Empty;
            skinDateTimePicker2.text = string.Empty;
            Bind();
        }

        private void pagerControl1_BindSource(object sender, EventArgs e)
        {
            Bind();
        }
    }
}