/// <summary>
///获取taskrecord数据集
/// </summary>
private List <TaskRecord> selectTaskRecordList(string whereCause)
{
string sql = selectFromTaskrecordStr + (string.IsNullOrEmpty(whereCause) ? " 1=1 " : whereCause) + orderByTaskrecordStr;
List <TaskRecord> taskRecordList = DBDao.getDao().SelectTaskRecordBySql(sql);
return(taskRecordList);
}
/// <summary>
/// 车子查询后，不能重新查询，整个运行周期只维护一个Forklift列表
/// </summary>
/// <returns></returns>
public static List <ForkLiftWrapper> getForkLiftWrapperList()
{
if (forkLiftWrapperList == null)
{
forkLiftWrapperList = DBDao.getDao().getForkLiftWrapperList();
}
return(forkLiftWrapperList);
}
public static List <User> getUserList()
{
if (userList == null)
{
userList = DBDao.getDao().SelectUserList();
}
return(userList);
}
public static DBDao getDao()
{
if (dao == null)
{
dao = new DBDao();
}
return(dao);
}
private void InsertTaskexeSysInfo(string msg, string type)
{
string sql = "insert into taskexe_s2c_sop (`uuid`,taskid,opflag,msg) " + "values(uuid(),'" + type
+ "','" + "New" + "','" + msg + "')";
try {
lock (DBDao.getDao().getLockDB()) {
DBDao.getDao().execNonQuery(sql);
}
} catch (Exception ex) {
Console.WriteLine(ex.ToString());
}
}
public TaskexeBean selectTaskexeByUuid(string uuid)
{
List <TaskexeBean> tbList = DBDao.getDao().SelectTaskexeBySql(selectTaskexeByUuidSql + "'" + uuid + "'");
if (tbList == null || tbList.Count <= 0)
{
return(null);
}
else
{
return(tbList[0]);
};
}
public bool checkTaskexeIsOver()
{
List <TaskexeBean> tbList = DBDao.getDao().SelectTaskexeBySql(checkTaskexeIsOverSql);
if (tbList == null || tbList.Count <= 0)
{
return(true);
}
else
{
return(false);
}
}
public List <SingleTask> getDownPickSingleTask()
{
List <SingleTask> sList = DBDao.getDao().SelectSingleTaskList();
List <SingleTask> downList = new List <SingleTask>();
foreach (SingleTask st in sList)
{
if (st.taskType == TASKTYPE_T.TASK_TYPE_DOWN_PICK)
{
downList.Add(st);
}
}
return(downList);
}
public static List <SingleTask> getSingleTaskList() //获取供选择任务列表
{
lock (LockController.getLockController().getLockData()) {
if (singleTaskList == null)
{
upPickSingleTaskList = new List <SingleTask>();
downPickSingleTaskList = new List <SingleTask>();
singleTaskList = DBDao.getDao().SelectSingleTaskList();
foreach (SingleTask st in singleTaskList)
{
if (st.taskType == TASKTYPE_T.TASK_TYPE_UP_PICK)
{
upPickSingleTaskList.Add(st); //总共只有两个楼上取货任务
}
else if (st.taskType == TASKTYPE_T.TASK_TYPE_DOWN_PICK)
{
downPickSingleTaskList.Add(st);
}
}
}
}
return(singleTaskList);
}
public void sendTaskexeBean(TaskexeBean taskexeBean)
{
string sql = " update taskexe_s2c_task set opflag = 'Send' where `uuid` = '" + taskexeBean.getUuid() + "'";
DBDao.getDao().DeleteWithSql(sql);
}
public List <TaskexeBean> getTaskexeStartOrPauseList()
{
return(DBDao.getDao().SelectTaskexeBySql(selectTaskexeStartOrPauseSql));
}
public List <TaskexeBean> getTaskexeTaskList()
{
return(DBDao.getDao().SelectTaskexeBySql(selectTaskexeTaskSql));
}
public void deleteAllTaskRecord()
{
string sql = "truncate table taskrecord";
DBDao.getDao().DeleteWithSql(sql);
}