public static Solution findSolutionBySolutionID(int solutionID) { SqlConnection conn = null; SqlCommand cmd = null; try { conn = new SqlConnection(conStr); conn.Open(); cmd = conn.CreateCommand(); cmd.CommandText = "select * from solution where solution_ID=@solutionID"; cmd.Parameters.AddWithValue("@solutionID", solutionID); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Solution sl = new Solution(); sl.solutionID = reader.GetInt32(reader.GetOrdinal("solution_ID")); sl.solution = reader.GetString(reader.GetOrdinal("solution")); sl.runSolution = reader.GetString(reader.GetOrdinal("run_solution")); String criImgs = reader.GetString(reader.GetOrdinal("cri_img")); string[] simgs = criImgs.Split(','); foreach (string img in simgs) { sl.criImgs.Add(img); } return sl; } return null; } finally { conn.Close(); } }
public static int deleteSolution(Solution solution) { SqlConnection conn = null; SqlCommand cmd = null; try { conn = new SqlConnection(conStr); conn.Open(); cmd = conn.CreateCommand(); cmd.CommandText = "delete from solution where solution_ID=@solutionID"; cmd.Parameters.AddWithValue("@solutionID", solution.solutionID); return cmd.ExecuteNonQuery(); } finally { conn.Close(); } }
public static int addSolution(Solution solution) { SqlConnection conn = null; SqlCommand cmd = null; try { conn = new SqlConnection(conStr); conn.Open(); cmd = conn.CreateCommand(); if (findSolutionBySolutionID(solution.solutionID) != null) return -1; cmd.CommandText = "insert into solution (solution,run_solution,cri_img) values(@solution,@runSolution,@criImg)"; // cmd.Parameters.AddWithValue("@solutionID", solution.solutionID); cmd.Parameters.AddWithValue("@solution", solution.solution); cmd.Parameters.AddWithValue("@runSolution", solution.runSolution); String imgs = null; int i = 0; foreach (string im in solution.criImgs) { if (i > 0) { imgs = imgs + ","; } i++; imgs = imgs + im; } cmd.Parameters.AddWithValue("@criImg", imgs); return cmd.ExecuteNonQuery(); } finally { conn.Close(); } }
public static int updateSolution(Solution solution) { SqlConnection conn = null; SqlCommand cmd = null; try { conn = new SqlConnection(conStr); conn.Open(); cmd = conn.CreateCommand(); cmd.CommandText = "update solution set solution=@solution,run_solution=@runSolution,cri_img=@criImg where solution_ID=@solutionID"; cmd.Parameters.AddWithValue("@solutionID", solution.solutionID); cmd.Parameters.AddWithValue("@solution", solution.solution); cmd.Parameters.AddWithValue("@runSolution", solution.runSolution); String imgs = null; int i = 0; foreach (string im in solution.criImgs) { if (i > 0) { imgs = imgs + ","; } i++; imgs = imgs + im; } cmd.Parameters.AddWithValue("@criImg", imgs); return cmd.ExecuteNonQuery(); } finally { conn.Close(); } }
public static int updateMessage(Message m) { Operator op = findAllByRecordID(m.recordID); m.solutionID = op.solution.solutionID; m.faultID = op.fault.faultID; Record r = new Record(); r.recordID = m.recordID; r.carID = m.carID; r.time = m.time; r.worker = m.worker; r.faultID = m.faultID; r.solutionID = m.solutionID; updateRecord(r); Fault f = new Fault(); f.faultID = m.faultID; f.fault = m.fault; f.faultKey = m.faultKey; f.faultImgs = op.fault.faultImgs; updateFault(f); Solution s = new Solution(); s.solutionID = m.solutionID; s.solution = m.solution; s.runSolution = m.runSolution; s.criImgs = op.solution.criImgs; int i = 0; i = updateSolution(s); if (i != 0) { return 0; } else { return 1; } }
public static List<Solution> getAllSolution() { SqlConnection conn = null; SqlCommand cmd = null; try { conn = new SqlConnection(conStr); conn.Open(); cmd = conn.CreateCommand(); cmd.CommandText = "select * from solution"; SqlDataReader reader = cmd.ExecuteReader(); List<Solution> solutionList = new List<Solution>(); while (reader.Read()) { Solution s = new Solution(); s.solutionID = reader.GetInt32(reader.GetOrdinal("solution_ID")); s.solution = reader.GetString(reader.GetOrdinal("solution")); s.runSolution = reader.GetString(reader.GetOrdinal("run_solution")); string solutionImgs = reader.GetString(reader.GetOrdinal("cri_img")); string[] simgs = solutionImgs.Split(','); foreach (string img in simgs) { s.criImgs.Add(img); } solutionList.Add(s); } return solutionList; } finally { conn.Close(); } }