示例#1
0
        /// <summary>
        /// 检查比对任务目的
        /// </summary>
        /// <param name="id"></param>
        /// <param name="wcs_no"></param>
        /// <param name="loc"></param>
        /// <returns></returns>
        public void CheckTask(String wcs_no, String loc)
        {
            try
            {
                // 获取对应清单
                String    sql = String.Format(@"select TASK_TYPE,FRT,TASK_UID_1,LOC_TO_1,TASK_UID_2,LOC_TO_2 from wcs_command_v where STEP <>'4' and WCS_NO = '{0}'", wcs_no);
                DataTable dt  = mySQL.SelectAll(sql);
                if (tools.IsNoData(dt))
                {
                    return;
                }
                String tasktype = dt.Rows[0]["TASK_TYPE"].ToString();
                String frt      = dt.Rows[0]["FRT"].ToString();
                String taskid1  = dt.Rows[0]["TASK_UID_1"].ToString();
                String loc1     = dt.Rows[0]["LOC_TO_1"].ToString();
                String taskid2  = dt.Rows[0]["TASK_UID_2"].ToString();
                String loc2     = dt.Rows[0]["LOC_TO_2"].ToString();
                // 判断目的位置是否一致
                // 更新Task状态(Command于数据库TRIGGER 'update_command_T' 触发更新)
                switch (tasktype)
                {
                case TaskType.入库:
                    if (loc == task.GetABCStockLoc(loc1))
                    {
                        task.UpdateTask(taskid1, TaskSite.完成);
                    }
                    if (loc == task.GetABCStockLoc(loc2))
                    {
                        task.UpdateTask(taskid2, TaskSite.完成);
                    }
                    break;

                case TaskType.出库:
                    if (loc == frt)
                    {
                        task.UpdateTask(taskid1, TaskSite.完成);
                        task.UpdateTask(taskid2, TaskSite.完成);
                    }
                    break;

                default:
                    break;
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }