public void setTaskInfo(Model.TaskInfo taskInfo)
{
try
{
OracleParameter[] parms = new OracleParameter[] {
new OracleParameter(":TASKSTATE", taskInfo.TaskState),
new OracleParameter(":dbid", taskInfo.DbId),
};
string SQL = " UPDATE TASKINFO "
+ " SET "
+ " TASKSTATE = :TASKSTATE "
+ " where "
+ " dbid=:dbid ";
string strCnn = OracleHelper.ConnectionStringOrderDistributedTransaction;
using (OracleConnection cnn = new OracleConnection(strCnn))
{
OracleHelper.ExecuteNonQuery(cnn, CommandType.Text, SQL, parms);
}
}
catch (Exception e)
{
throw e;
}
}
private List <Model.TaskInfo> getTaskInfoModelList(DataTable dt)
{
List <Model.TaskInfo> taskInfoList = new List <Model.TaskInfo> ();
for (int i = 0; i < dt.Rows.Count; i++)
{
Model.TaskInfo taskInfo = new Model.TaskInfo();
if (dt.Rows[i]["DBID"] != null)
{
taskInfo.DbId = long.Parse(dt.Rows[i]["DBID"].ToString());
}
if (dt.Rows[i]["DEPLOYTIME"] != null)
{
taskInfo.DeployTime = (DateTime)dt.Rows[i]["DEPLOYTIME"];
}
if (dt.Rows[i]["DESCIRPTION"] != null)
{
taskInfo.Description = dt.Rows[i]["DESCIRPTION"].ToString();
}
if (dt.Rows[i]["FINISHTIME"] != null && dt.Rows[i]["FINISHTIME"].Equals(""))
{
taskInfo.FinishTime = (DateTime)dt.Rows[i]["FINISHTIME"];
}
if (dt.Rows[i]["STREET"] != null)
{
taskInfo.Street = dt.Rows[i]["STREET"].ToString();
}
if (dt.Rows[i]["TASKSTATE"] != null)
{
taskInfo.TaskState = dt.Rows[i]["TASKSTATE"].ToString();
}
if (dt.Rows[i]["USERNAME"] != null)
{
taskInfo.UserName = dt.Rows[i]["USERNAME"].ToString();
}
if (dt.Rows[i]["PATROLER_ID"] != null)
{
taskInfo.Patroler_id = long.Parse(dt.Rows[i]["PATROLER_ID"].ToString());
}
taskInfoList.Add(taskInfo);
}
return(taskInfoList);
}
public void UpdateTask(Model.TaskInfo task)
{
string cmdText = @"update [Task] set [hostName]=@hostName,
[logTime]=@logTime,[ACT]=@act,[Comment]=@Comment
where sno=@sno";
SqlParameter[] parameters = new SqlParameter[] {
new SqlParameter("@sno", task.SNo),
new SqlParameter("@hostName", task.HostName),
new SqlParameter("@logTime", task.LogTime),
new SqlParameter("@act", (int)task.Act),
new SqlParameter("@comment", task.Comments)
};
SqlHelper.ExecuteNonQuery(cmdText, parameters);
}
public int AddTask(Model.TaskInfo task)
{
string cmdText = @"insert into [Task] (flowId,uid,createTime,Role)
values (@flowId,@uid,@createTime,@role); select @@identity";
SqlParameter[] parameters = new SqlParameter[] {
new SqlParameter("@flowId", task.FlowId),
new SqlParameter("@uid", task.UID),
new SqlParameter("@createTime", task.CreateTime),
new SqlParameter("@role", task.Role)
};
object obj = SqlHelper.ExecuteScalar(cmdText, parameters);
return(obj == null ? -1 : Convert.ToInt32(obj));
}
public void setTaskInfo(Model.TaskInfo taskInfo)
{
try
{
if (null == taskInfo)
{
return;
}
IDAL.ITaskInfo dal = DALFactory.TaskInfo.Create();
dal.setTaskInfo(taskInfo);
}
catch (Exception e)
{
throw e;
}
}
public static Client.TaskInfo Convert(Model.TaskInfo modelTaskInfo)
{
if (modelTaskInfo == null)
{
throw new ArgumentNullException(nameof(modelTaskInfo));
}
var clientPriority = TaskPriorityConverter.Convert(modelTaskInfo.Priority);
var clientTaskInfo = new Client.TaskInfo
{
Id = modelTaskInfo.Id.ToString(),
UserId = modelTaskInfo.UserId.ToString(),
Title = modelTaskInfo.Title,
CreatedAt = modelTaskInfo.CreatedAt,
LastUpdatedAt = modelTaskInfo.LastUpdatedAt,
Priority = clientPriority,
Done = modelTaskInfo.Done,
DeadLine = modelTaskInfo.DeadLine
};
return(clientTaskInfo);
}
public TaskInfo GetTask(int taskId)
{
string cmdText = @"select * from task where sno=@sno";
SqlParameter parameter = new SqlParameter("@sno", taskId);
Model.TaskInfo ts = null;
using (SqlDataReader reader = SqlHelper.ExecuteReader(cmdText, parameter))
{
if (reader.Read())
{
ts = new Model.TaskInfo();
ts.SNo = (int)reader["sno"];
if (reader["act"] != DBNull.Value && reader["act"] != null)
{
ts.Act = (Model.ActionType)reader["act"];
}
if (reader["uid"] != DBNull.Value && reader["uid"] != null)
{
ts.UID = reader["uid"].ToString();
}
}
}
return(ts);
}
private Model.TaskInfo GetTaskInfoByOracleDataReader(OracleDataReader rdr)
{
string[] colsName;
int[] colsOrdinal;
const int colsCount = 8;
Model.TaskInfo task;
colsName = new string[colsCount] {
"DBID", "DEPLOYTIME", "DESCIRPTION",
"FINISHTIME", "STREET", "TASKSTATE",
"USERNAME", "PATROLER_ID"
};
colsOrdinal = new int[colsCount];
if (GetColumnsOrdinal(rdr, colsName, colsOrdinal) < 0)
{
throw (new Exception("Error"));
}
task = new Model.TaskInfo();
for (int i = 0; i < colsCount; i++)
{
if (colsOrdinal[i] < 0 || rdr.IsDBNull(colsOrdinal[i]))
{
continue;
}
switch (i)
{
case 0:
task.DbId = rdr.GetInt32(colsOrdinal[i]);
break;
case 1:
task.DeployTime = rdr.GetDateTime(colsOrdinal[i]);
break;
case 2:
task.Description = rdr.GetString(colsOrdinal[i]);
break;
case 3:
task.FinishTime = rdr.GetDateTime(colsOrdinal[i]);
break;
case 4:
task.Street = rdr.GetString(colsOrdinal[i]);
break;
case 5:
task.TaskState = rdr.GetString(colsOrdinal[i]);
break;
case 6:
task.UserName = rdr.GetString(colsOrdinal[i]);
break;
case 7:
if (rdr.GetInt32(colsOrdinal[i]) != null)
{
task.Patroler_id = rdr.GetInt32(colsOrdinal[i]);
}
break;
}
}
return(task);
}
