/// <summary>
/// 根据ID查询任务
/// </summary>
/// <param name="pWorkItemID"></param>
/// <returns></returns>
public static workTaskDataInfo GetWorkTaskByWorkItemID(string pWorkItemID)
{
try
{
using (SqlConnection conn = new SqlConnection(getTmpAppConnectionString()))
{
string sql = "select * from WorkTasks where WorkItemID='" + pWorkItemID + "' ";
SqlDataAdapter sd = new SqlDataAdapter(sql, conn);
DataTable dt = new DataTable();
sd.Fill(dt);
if (dt.Rows.Count > 0)
{
DataRow row = dt.Rows[0];
workTaskDataInfo info = new workTaskDataInfo();
info.taskStatus = Convert.ToInt32(row["TaskStatus"]);
info.programID = row["ProgramID"].ToString();
return(info);
}
else
{
return(null);
}
}
}
catch (Exception ex)
{
throw ex;
}
}
// POST api/worktask
public resultInfo AddWorkTask([FromBody] workTaskDataInfo value)
{
resultInfo _ResultInfo = new resultInfo();
_ResultInfo.message = "任务添加失败";
try
{
if (DBManager.IsExistWorkTask(value.workItemID))
{
_ResultInfo.code = 1;
_ResultInfo.message = "此任务已存在";
}
else
{
if (DBManager.InsertIntoWorkTask(value))
{
_ResultInfo.code = 0;
_ResultInfo.message = "任务添加成功，任务ID：" + value.workItemID;
}
else
{
_ResultInfo.code = -1;
_ResultInfo.message = "任务添加失败";
}
}
}
catch (Exception ex)
{
_ResultInfo.code = -1;
_ResultInfo.message = "添加失败：" + ex.Message;
ClassFunction.WriteLocalLog(ex.Message);
}
return(_ResultInfo);
}
/// <summary>
/// 添加任务
/// </summary>
/// <param name="pWorkTaskDataInfo"></param>
/// <returns></returns>
public static bool InsertIntoWorkTask(workTaskDataInfo pWorkTaskDataInfo)
{
using (SqlConnection conn = new SqlConnection(getTmpAppConnectionString()))
{
using (SqlCommand cmd = new SqlCommand())
{
try
{
conn.Open();
cmd.Connection = conn;
cmd.Transaction = conn.BeginTransaction();
cmd.CommandText = "insert into WorkTasks (WorkItemID, ProgramID, WorkCreateDate , AssetName, ColumnName,PlayDate,Tags,Description,Content,ChannelPath,ModifiedDate,ModifiedBy,CreationDate,CreatedBy,MaterialDrefs,TaskStatus,IsBroadcast,BroadcastCode) " +
"values (@WorkItemID, @ProgramID, @WorkCreateDate, @AssetName, @ColumnName,@PlayDate,@Tags,@Description,@Content,@ChannelPath,@ModifiedDate,@ModifiedBy,@CreationDate,@CreatedBy,@MaterialDrefs,@TaskStatus,@IsBroadcast,@BroadcastCode)";
cmd.Parameters.AddWithValue("@WorkItemID", pWorkTaskDataInfo.workItemID);
cmd.Parameters.AddWithValue("@ProgramID", Guid.Empty.ToString());
cmd.Parameters.AddWithValue("@WorkCreateDate", DateTime.Now);
cmd.Parameters.AddWithValue("@AssetName", pWorkTaskDataInfo.assetName);
cmd.Parameters.AddWithValue("@ColumnName", pWorkTaskDataInfo.columnName);
cmd.Parameters.AddWithValue("@PlayDate", pWorkTaskDataInfo.playDate);
cmd.Parameters.AddWithValue("@Tags", pWorkTaskDataInfo.tags);
cmd.Parameters.AddWithValue("@Description", pWorkTaskDataInfo.description);
cmd.Parameters.AddWithValue("@Content", pWorkTaskDataInfo.content);
cmd.Parameters.AddWithValue("@ChannelPath", pWorkTaskDataInfo.channelPath);
cmd.Parameters.AddWithValue("@ModifiedDate", pWorkTaskDataInfo.modifiedDate);
cmd.Parameters.AddWithValue("@ModifiedBy", pWorkTaskDataInfo.modifiedBy);
cmd.Parameters.AddWithValue("@CreationDate", pWorkTaskDataInfo.creationDate);
cmd.Parameters.AddWithValue("@CreatedBy", pWorkTaskDataInfo.createdBy);
string strMaterialDrefs = "";
if (pWorkTaskDataInfo.materialDrefs != null && pWorkTaskDataInfo.materialDrefs.Count > 0)
{
foreach (string item in pWorkTaskDataInfo.materialDrefs)
{
strMaterialDrefs += item + ",";
}
strMaterialDrefs = strMaterialDrefs.Substring(0, strMaterialDrefs.Length - 1);
}
cmd.Parameters.AddWithValue("@MaterialDrefs", strMaterialDrefs);
cmd.Parameters.AddWithValue("@TaskStatus", 0);
cmd.Parameters.AddWithValue("@IsBroadcast", pWorkTaskDataInfo.isBroadcast);
cmd.Parameters.AddWithValue("@BroadcastCode", pWorkTaskDataInfo.broadcastCode);
cmd.ExecuteNonQuery();
cmd.Transaction.Commit();
return(true);
}
catch (Exception ex)
{
if (cmd.Transaction != null)
{
cmd.Transaction.Rollback();
}
throw ex;
}
}
}
}
public taskProgress QueryWorkTask(string id)
{
//整个生产任务的状态，查询错误-100，未找到-1，未开始0、进行中1、已终止2、已完成3
taskProgress _TaskProgress = new taskProgress();
try
{
workTaskDataInfo _WorkTaskDataInfo = DBManager.GetWorkTaskByWorkItemID(id);
if (_WorkTaskDataInfo != null)
{
switch (_WorkTaskDataInfo.taskStatus)
{
case 0:
_TaskProgress.name = "未开始";
_TaskProgress.status = 0;
break;
case 1:
_TaskProgress.name = "未发送";
_TaskProgress.status = 1;
break;
case 2:
_TaskProgress.name = "发送完成";
_TaskProgress.status = 2;
break;
case 3:
_TaskProgress.name = "制作中";
_TaskProgress.status = 3;
break;
default:
_TaskProgress.name = "未开始";
_TaskProgress.status = 0;
break;
}
}
else
{
_TaskProgress.name = "未找到制作任务";
_TaskProgress.status = -1;
}
}
catch (Exception ex)
{
_TaskProgress.name = "查询失败:" + ex.Message;
_TaskProgress.status = -100;
ClassFunction.WriteLocalLog(ex.Message);
}
return(_TaskProgress);
}
