| | |
| | | |
| | | internal static bool AddActionRecord(string no, int state, string forkliftNo, string extData) { |
| | | var db = new SqlHelper<TaskAction>().GetInstance(); |
| | | var action = new TaskAction() |
| | | var result = true; |
| | | var info = db.Queryable<TaskAction>().Where(a => a.S_TASK_CODE == no && a.N_ACTION_CODE == state).First(); |
| | | if (info == null) |
| | | { |
| | | N_ACTION_CODE = state, |
| | | S_TASK_CODE = no, |
| | | S_EQ_CODE = forkliftNo, |
| | | S_EQ_TYPE = "agv", |
| | | S_DATA = extData |
| | | }; |
| | | return db.Insertable(action).ExecuteCommand() > 0; |
| | | var action = new TaskAction() |
| | | { |
| | | N_ACTION_CODE = state, |
| | | S_TASK_CODE = no, |
| | | S_EQ_CODE = forkliftNo, |
| | | S_EQ_TYPE = "agv", |
| | | S_DATA = extData |
| | | }; |
| | | result= db.Insertable(action).ExecuteCommand() > 0; |
| | | } |
| | | return result; |
| | | } |
| | | internal static bool CheckActionRecordExist(string no, int code) { |
| | | var db = new SqlHelper<TaskAction>().GetInstance(); |