FormTaskDis_dtl.cs 1.2 KB

12345678910111213141516171819202122232425262728293031323334353637383940
  1. using CCWin;
  2. using System;
  3. using System.Collections.Generic;
  4. using System.ComponentModel;
  5. using System.Data;
  6. using System.Drawing;
  7. using System.Linq;
  8. using System.Text;
  9. using System.Threading.Tasks;
  10. using System.Windows.Forms;
  11. using WCS_Client.Utility;
  12. namespace WCS_Client.From
  13. {
  14. public partial class FormTaskDis_dtl : CCSkinMain
  15. {
  16. DataTable _dt;
  17. string _task_id = string.Empty;
  18. public FormTaskDis_dtl(string task_id)
  19. {
  20. InitializeComponent();
  21. _task_id = task_id;
  22. BindingDataDtl(task_id);
  23. }
  24. private void BindingDataDtl(string task_Id)
  25. {
  26. 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 + "'";
  27. string _Orderby = " executedate asc";
  28. PageData pd = BaseWorkflow.QueryPageData(_SQLText, _Orderby, new List<string>(), 1, 10000);
  29. if (pd == null)
  30. {
  31. if (_dt != null) _dt.Clear();
  32. }
  33. else
  34. {
  35. dgvTaskdtl.DataSource = pd.Dt;
  36. }
  37. }
  38. }
  39. }