Esempio n. 1
0
        void uc_FlowModuleClick(object sender, EventArgs e)
        {
            UC_FlowModule     uc  = (UC_FlowModule)sender;
            FrmWorkPoint_Show frm = new FrmWorkPoint_Show();

            frm.TaskID    = uc.TaskId;
            frm.PointSort = uc.PointSort;
            frm.ShowDialog();
        }
Esempio n. 2
0
        //private DataTable _DataSource;

        //public DataTable DataSource
        //{
        //    get { return _DataSource; }
        //    set { _DataSource = value; }
        //}
        public void DataBind()
        {
            FP_Flow.Controls.Clear();

            if (ValidateUtil.IsGuid(_TaskId))
            {
                string    sqlstr      = @"SELECT distinct PointSort,PointName,TaskID,
(SELECT TOP 1 AcceptUser FROM Meter_WorkResolve WHERE TaskID=@TaskID AND PointSort=MWR.PointSort) AS AcceptUser,
(SELECT TOP 1 CONVERT(VARCHAR(10),AcceptDate,120) FROM Meter_WorkResolve WHERE TaskID=@TaskID AND PointSort=MWR.PointSort) AS AcceptDate
FROM Meter_WorkResolve MWR where TaskID=@TaskID order by PointSort";
                DataTable _DataSource = new SqlServerHelper().GetDateTableBySql(sqlstr, new SqlParameter[] { new SqlParameter("@TaskID", _TaskId) });

                if (DataTableHelper.IsExistRows(_DataSource))
                {
                    object obj = new SqlServerHelper().GetFirsRowsValue("select PointSort from Meter_WorkTask where TaskID=@TaskID", new SqlParameter[] { new SqlParameter("@TaskID", _TaskId) });
                    int    num = int.Parse(obj.ToString());

                    foreach (DataRow dr in _DataSource.Rows)
                    {
                        UC_FlowModule uc = new UC_FlowModule();
                        uc.SLabelText        = dr["AcceptUser"].ToString();
                        uc.SLabelDescription = dr["AcceptDate"].ToString();
                        uc.SLablePoint       = dr["PointName"].ToString();
                        int pointid = int.Parse(dr["PointSort"].ToString());
                        uc.TaskId    = _TaskId;
                        uc.PointSort = pointid;
                        if (pointid < num)
                        {
                            uc.SBackColor = Color.Green;
                        }
                        else
                        {
                            uc.SBackColor = Color.Gray;
                        }
                        uc.FlowModuleClick += new EventHandler(uc_FlowModuleClick);
                        FP_Flow.Controls.Add(uc);
                    }
                }
            }
        }