/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(TaskME model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Task(");
strSql.Append("taskID,taskCode,taskObj,taskExeStatus)");
strSql.Append(" values (");
strSql.Append("@taskID,@taskCode,@taskObj,@taskExeStatus)");
SqlParameter[] parameters = {
new SqlParameter("@taskID", SqlDbType.NVarChar,50),
new SqlParameter("@taskCode", SqlDbType.Int,4),
new SqlParameter("@taskObj", SqlDbType.Xml,-1),
new SqlParameter("@taskExeStatus", SqlDbType.Int,4)};
parameters[0].Value = model.taskID;
parameters[1].Value = model.taskCode;
parameters[2].Value = model.taskObj;
parameters[3].Value = model.taskExeStatus;
int rows =_dbAssist.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 添加任务
/// </summary>
/// <param name="m"></param>
/// <returns></returns>
public bool AddTask(TaskME m)
{
if (_taskDAL.Exists(m.taskID))
{
return false;
}
return _taskDAL.Add(m);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(TaskME model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Task set ");
strSql.Append("taskCode=@taskCode,");
strSql.Append("taskObj=@taskObj,");
strSql.Append("taskExeStatus=@taskExeStatus");
strSql.Append(" where taskID=@taskID ");
SqlParameter[] parameters = {
new SqlParameter("@taskCode", SqlDbType.Int,4),
new SqlParameter("@taskObj", SqlDbType.Xml,-1),
new SqlParameter("@taskExeStatus", SqlDbType.Int,4),
new SqlParameter("@taskID", SqlDbType.NVarChar,50)};
parameters[0].Value = model.taskCode;
parameters[1].Value = model.taskObj;
parameters[2].Value = model.taskExeStatus;
parameters[3].Value = model.taskID;
int rows = _dbAssist.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public TaskME GetModel(string taskID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 taskID,taskCode,taskObj,taskExeStatus from Task ");
strSql.Append(" where taskID=@taskID ");
SqlParameter[] parameters = {
new SqlParameter("@taskID", SqlDbType.NVarChar,50) };
parameters[0].Value = taskID;
TaskME model = new TaskME();
DataSet ds = _dbAssist.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["taskID"] != null && ds.Tables[0].Rows[0]["taskID"].ToString() != "")
{
model.taskID = ds.Tables[0].Rows[0]["taskID"].ToString();
}
if (ds.Tables[0].Rows[0]["taskCode"] != null && ds.Tables[0].Rows[0]["taskCode"].ToString() != "")
{
model.taskCode = int.Parse(ds.Tables[0].Rows[0]["taskCode"].ToString());
}
if (ds.Tables[0].Rows[0]["taskObj"] != null && ds.Tables[0].Rows[0]["taskObj"].ToString() != "")
{
model.taskObj=ds.Tables[0].Rows[0]["taskObj"].ToString();
}
if (ds.Tables[0].Rows[0]["taskExeStatus"] != null && ds.Tables[0].Rows[0]["taskExeStatus"].ToString() != "")
{
model.taskExeStatus = int.Parse(ds.Tables[0].Rows[0]["taskExeStatus"].ToString());
}
return model;
}
else
{
return null;
}
}
/// <summary>
/// 根据条件查找符合的第一条记录
/// </summary>
/// <param name="strWhere"></param>
/// <returns></returns>
public TaskME GetConditionedModel(string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 taskID,taskCode,taskObj,taskExeStatus ");
strSql.Append(" FROM Task ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
DataSet ds = _dbAssist.Query(strSql.ToString());
TaskME model = new TaskME();
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["taskID"] != null && ds.Tables[0].Rows[0]["taskID"].ToString() != "")
{
model.taskID = ds.Tables[0].Rows[0]["taskID"].ToString();
}
if (ds.Tables[0].Rows[0]["taskCode"] != null && ds.Tables[0].Rows[0]["taskCode"].ToString() != "")
{
model.taskCode = int.Parse(ds.Tables[0].Rows[0]["taskCode"].ToString());
}
if (ds.Tables[0].Rows[0]["taskObj"] != null && ds.Tables[0].Rows[0]["taskObj"].ToString() != "")
{
model.taskObj = ds.Tables[0].Rows[0]["taskObj"].ToString();
}
if (ds.Tables[0].Rows[0]["taskExeStatus"] != null && ds.Tables[0].Rows[0]["taskExeStatus"].ToString() != "")
{
model.taskExeStatus = int.Parse(ds.Tables[0].Rows[0]["taskExeStatus"].ToString());
}
return model;
}
else
{
return null;
}
}
private void button3_Click(object sender, EventArgs e)
{
TaskProductInhouse task = new TaskProductInhouse();
task.productID = "124314";
task.targetL = 1;
task.targetR = 2;
task.targetC = 40;
TaskME taskM = new TaskME();
taskM.taskCode = (int)TaskCode.TASK_PRODUCT_INHOUSE;
taskM.taskID = DateTime.Now.ToString();
taskM.taskObj = TaskSerializer.Serialize(task);
try
{
this.richTextBox1.AppendText(taskM.taskObj + "\r\n");
_taskBll.AddTask(taskM);
}
catch (System.Exception e1)
{
this.richTextBox1.AppendText(e1.Message);
}
}
private void button5_Click(object sender, EventArgs e)
{
StringBuilder strBuilder = new StringBuilder();
//TaskExeStatus s = TaskExeStatus.TASK_NEW;
//string TaskID = string.Empty;
//XMLConfigRW.ReadMachineCurrentTask(1,out s,out TaskID);
//strBuilder.AppendFormat("1号小车当前任务ID：{0}，任务状态:{1}\r\n", TaskID, ((int)s).ToString());
//this.richTextBox1.AppendText(strBuilder.ToString());
//strBuilder.Clear();
//XMLConfigRW.SaveMachineCurrentTask(1, TaskExeStatus.TASK_COMPLETED, System.DateTime.Now.ToString("yyyyMMddHHmm"));
//s = TaskExeStatus.TASK_RUN;
//TaskID = string.Empty;
//XMLConfigRW.ReadMachineCurrentTask(1, out s, out TaskID);
//strBuilder.AppendFormat("1号小车当前任务ID：{0}，任务状态:{1}\r\n", TaskID, ((int)s).ToString());
//this.richTextBox1.AppendText(strBuilder.ToString());
string taskSerialNo = _taskBll.GenerateNewTaskSerialNo();
BaseTaskInfo taskObj= new TaskProductInhouse();
taskObj.taskID = taskSerialNo;
TaskME newTask = new TaskME();
newTask.taskCode = (int)taskObj.taskCode;
newTask.taskID = taskSerialNo;
newTask.taskObj = TaskSerializer.Serialize(taskObj);
newTask.taskExeStatus = 0;
_taskBll.AddTask(newTask);
this.richTextBox1.AppendText("生成新的流水号:" + taskSerialNo+"\r\n");
}
/// <summary>
/// 获取未执行的任务列表
/// </summary>
/// <returns></returns>
public IList<TaskME> GetAllUnexedTaskList()
{
DataSet ds = _taskDAL.GetList(" taskExeStatus=0 ");
if (ds != null && ds.Tables.Count > 0)
{
IList<TaskME> taskList = new List<TaskME>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
TaskME model = new TaskME();
if (dr["taskID"] != null && dr["taskID"].ToString() != "")
{
model.taskID = dr["taskID"].ToString();
}
if( dr["taskCode"] != null && dr["taskCode"].ToString() != "")
{
model.taskCode = int.Parse(dr["taskCode"].ToString());
}
if (dr["taskObj"] != null && dr["taskObj"].ToString() != "")
{
model.taskObj = dr["taskObj"].ToString();
}
if (dr["taskExeStatus"] != null && dr["taskExeStatus"].ToString() != "")
{
model.taskExeStatus = int.Parse(dr["taskExeStatus"].ToString());
}
taskList.Add(model);
}
return taskList;
}
else
return null;
}
