예제 #1
0
        static void DownSTask()
        {
            string sql = string.Format(@"SELECT ts.*,c.ItemName FROM dbo.T_Task_Son ts
                                    LEFT JOIN dbo.T_Type_Config c ON ts.STaskType = c.ItemNo
                                    WHERE State IN(1, 2, 3) ORDER BY AgvNo, SerialNo");


            DataSet ds = DbHelperSQL.Query(sql);

            foreach (DataRow dr in ds.Tables[0].Rows)
            {
                GetObject.GetSTask(dr);
            }
        }