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); }