YG-OPP-WCS-Client/WCS_Client/From/From_Task/FormTaskDis_dtl.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.Utility;

namespace WCS_Client.From
{
    public partial class FormTaskDis_dtl : CCSkinMain
    {
        DataTable _dt;
        string _task_id = string.Empty;
        public FormTaskDis_dtl(string task_id)
        {
            InitializeComponent();
            _task_id = task_id;
            BindingDataDtl(task_id);
        }
        private void BindingDataDtl(string task_Id)
        {
            string _SQLText = @"SELECT id,parentid,taskno,posidcur,posidnext,description,notes,to_char(executedate,'yyyy-MM-dd hh24:mi:ss') executedate FROM WCS_TASK_DIS_DTL where parentid='" + task_Id + "'";
            string _Orderby = " executedate asc";
            PageData pd = BaseWorkflow.QueryPageData(_SQLText, _Orderby, new List<string>(), 1, 10000);
            if (pd == null)
            {
                if (_dt != null) _dt.Clear();
            }
            else
            {
                dgvTaskdtl.DataSource = pd.Dt;
            }
        }
    }
}