internal List <LXJHGLInstance> GetTasksByStatus(LXJHGLStatus status, string userName)
{
List <LXJHGLInstance> result = new List <LXJHGLInstance>();
this.dbParam.Open();
OracleCommand queryCmd = new OracleCommand();
queryCmd.Connection = (OracleConnection)this.dbParam.Connection;
queryCmd.CommandText = @"SELECT ID,
NAME,
VERSION,
RELEASER,
RELEASETIME,
TYPE,
CREATOR,
PLANEDTIME,
TASKCREATIME,
STATUS,
BZ,
PROCESS,
DIFFICULTY,
COMPLETETIME
FROM dq_route_taskmng
WHERE STATUS=:status and CREATOR like '%' || :userName || '%' ";
queryCmd.Parameters.Add(":status", OracleDbType.Int32);
queryCmd.Parameters[":status"].Value = status;
queryCmd.Parameters.Add(":userName", OracleDbType.NVarchar2);
queryCmd.Parameters[":userName"].Value = userName;
var reader = queryCmd.ExecuteReader();
while (reader.Read())
{
LXJHGLInstance task = new LXJHGLInstance();
task.Id = reader.GetOracleString(0).IsNull ? string.Empty : reader.GetOracleString(0).Value;
task.Name = reader.GetOracleString(1).IsNull ? string.Empty : reader.GetOracleString(1).Value;
task.Version = reader.GetOracleDecimal(2).IsNull ? 0 : reader.GetOracleDecimal(2).ToInt32();
task.Releaser = reader.GetOracleString(3).IsNull ? string.Empty : reader.GetOracleString(3).Value;
task.Releasetime = reader.GetOracleDate(4).IsNull ? DateTime.MinValue : reader.GetOracleDate(4).Value;
task.Type = reader.GetOracleString(5).IsNull ? string.Empty : reader.GetOracleString(5).Value;
task.Creator = reader.GetOracleString(6).IsNull ? string.Empty : reader.GetOracleString(6).Value;
task.Planedtime = reader.GetOracleDate(7).IsNull ? DateTime.MinValue : reader.GetOracleDate(7).Value;
task.Taskcreatime = reader.GetOracleDate(8).IsNull ? DateTime.MinValue : reader.GetOracleDate(8).Value;
task.Status = reader.GetOracleDecimal(9).IsNull ? (LXJHGLStatus)1 : (LXJHGLStatus)reader.GetOracleDecimal(9).ToInt32();
task.Bz = reader.GetOracleString(10).IsNull ? string.Empty : reader.GetOracleString(10).Value;
task.Process = reader.GetOracleString(11).IsNull ? string.Empty : reader.GetOracleString(11).Value;
task.Difficulty = reader.GetOracleDecimal(12).IsNull ? 0 : reader.GetOracleDecimal(12).ToInt32();
task.Completetime = reader.GetOracleDate(13).IsNull ? DateTime.MinValue : reader.GetOracleDate(13).Value;
result.Add(task);
}
this.dbParam.Close();
return(result);
}
internal List<LXJHGLInstance> GetTasksByStatus(LXJHGLStatus status, string userName)
{
List<LXJHGLInstance> result = new List<LXJHGLInstance>();
this.dbParam.Open();
OracleCommand queryCmd = new OracleCommand();
queryCmd.Connection = (OracleConnection)this.dbParam.Connection;
queryCmd.CommandText = @"SELECT ID,
NAME,
VERSION,
RELEASER,
RELEASETIME,
TYPE,
CREATOR,
PLANEDTIME,
TASKCREATIME,
STATUS,
BZ,
PROCESS,
DIFFICULTY,
COMPLETETIME
FROM dq_route_taskmng
WHERE STATUS=:status and CREATOR like '%' || :userName || '%' ";
queryCmd.Parameters.Add(":status", OracleDbType.Int32);
queryCmd.Parameters[":status"].Value = status;
queryCmd.Parameters.Add(":userName", OracleDbType.NVarchar2);
queryCmd.Parameters[":userName"].Value = userName;
var reader = queryCmd.ExecuteReader();
while (reader.Read())
{
LXJHGLInstance task = new LXJHGLInstance();
task.Id = reader.GetOracleString(0).IsNull ? string.Empty : reader.GetOracleString(0).Value;
task.Name = reader.GetOracleString(1).IsNull ? string.Empty : reader.GetOracleString(1).Value;
task.Version = reader.GetOracleDecimal(2).IsNull ? 0 : reader.GetOracleDecimal(2).ToInt32();
task.Releaser = reader.GetOracleString(3).IsNull ? string.Empty : reader.GetOracleString(3).Value;
task.Releasetime = reader.GetOracleDate(4).IsNull ? DateTime.MinValue : reader.GetOracleDate(4).Value;
task.Type = reader.GetOracleString(5).IsNull ? string.Empty : reader.GetOracleString(5).Value;
task.Creator = reader.GetOracleString(6).IsNull ? string.Empty : reader.GetOracleString(6).Value;
task.Planedtime = reader.GetOracleDate(7).IsNull ? DateTime.MinValue : reader.GetOracleDate(7).Value;
task.Taskcreatime = reader.GetOracleDate(8).IsNull ? DateTime.MinValue : reader.GetOracleDate(8).Value;
task.Status = reader.GetOracleDecimal(9).IsNull ? (LXJHGLStatus)1 : (LXJHGLStatus)reader.GetOracleDecimal(9).ToInt32();
task.Bz = reader.GetOracleString(10).IsNull ? string.Empty : reader.GetOracleString(10).Value;
task.Process = reader.GetOracleString(11).IsNull ? string.Empty : reader.GetOracleString(11).Value;
task.Difficulty = reader.GetOracleDecimal(12).IsNull ? 0 : reader.GetOracleDecimal(12).ToInt32();
task.Completetime = reader.GetOracleDate(13).IsNull ? DateTime.MinValue : reader.GetOracleDate(13).Value;
result.Add(task);
}
this.dbParam.Close();
return result;
}
public List<LXJHGLInstance> GetTasksByStatus(LXJHGLStatus status, string userName)
{
return new PRLXJHGLS().GetTasksByStatus(status,userName);
}
public List <LXJHGLInstance> GetTasksByStatus(LXJHGLStatus status, string userName)
{
return(new PRLXJHGLS().GetTasksByStatus(status, userName));
}
internal List <LXJHGLInstance> GetTasksByStatus(LXJHGLStatus status, string userName)
{
return(new DALXJHGLS(base.dbParam).GetTasksByStatus(status, userName));
}
internal List<LXJHGLInstance> GetTasksByStatus(LXJHGLStatus status, string userName)
{
return new DALXJHGLS(base.dbParam).GetTasksByStatus(status, userName);
}
