| | |
|---|
| | | var task = db.Queryable<WCSTask>().Where(a => a.S_CODE.Trim() == no).First(); |
|---|
| | | return task; |
|---|
| | | } |
|---|
| | | internal static WCSTask GetTaskName(string no) |
|---|
| | | { |
|---|
| | | var db = new SqlHelper<WCSTask>().GetInstance(); |
|---|
| | | var task = db.Queryable<WCSTask>().Where(a => a.S_WORKSHOP_NO.Trim() == no).First(); |
|---|
| | | return task; |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | internal static List<WCSTask> GetTaskBycntrcode(string no) |
|---|
| | | { |
|---|
| | | var db = new SqlHelper<WCSTask>().GetInstance(); |
|---|
| | |
|---|
| | | var endLoc = LocationHelper.GetLocation(to); |
|---|
| | | WCSTask TN_Task = new WCSTask() |
|---|
| | | { |
|---|
| | | S_CODE = GenerateTaskNo(), |
|---|
| | | //S_CODE = GenerateTaskNo(), |
|---|
| | | S_CODE = orderName, |
|---|
| | | S_START_AREA = fromLoc.S_AREA_CODE, |
|---|
| | | S_END_AREA = endLoc.S_AREA_CODE, |
|---|
| | | S_START_LOC = from, |
|---|
| | |
|---|
| | | N_B_STATE = 0, |
|---|
| | | S_B_STATE = WCSTask.GetStateStr(0), |
|---|
| | | S_CNTR_CODE = cntrInfo, |
|---|
| | | //存小米任务号 |
|---|
| | | S_WORKSHOP_NO = orderName |
|---|
| | | ////存小米任务号 |
|---|
| | | //S_WORKSHOP_NO = orderName |
|---|
| | | //N_START_LAYER = startLayer, |
|---|
| | | //N_END_LAYER = endLayer, |
|---|
| | | //N_CNTR_COUNT = cntrCount |
|---|
