public int Add(tbl_inspect_master inItem) { PSQL SQL = new PSQL(); string query = string.Empty; SQL.Open(); query = "INSERT INTO tbl_inspect_master(inspect_cd, inspect_name, part_number, inspect_tool, inspect_spec, tol_plus, tol_minus) "; query += "VALUES ('" + inItem.inspect_cd + "','" + inItem.inspect_name + "','" + inItem.part_number + "','" + inItem.inspect_tool + "','"; query += inItem.inspect_spec + "','" + inItem.tol_plus + "','" + inItem.tol_minus + "') "; int result = SQL.Command(query).ExecuteNonQuery(); SQL.Close(); return(result); }
public int Search(tbl_inspect_master inItem) { PSQL SQL = new PSQL(); string query = string.Empty; query = "SELECT inspect_id, inspect_cd, inspect_name, part_number, inspect_tool, inspect_spec, tol_plus, tol_minus FROM tbl_inspect_master WHERE 1=1 "; if (inItem.inspect_id > 0) { query += "AND inspect_id='" + inItem.inspect_id + "' "; } if (!string.IsNullOrEmpty(inItem.inspect_cd)) { query += "AND inspect_cd='" + inItem.inspect_cd + "' "; } if (!string.IsNullOrEmpty(inItem.part_number)) { query += "AND part_number='" + inItem.part_number + "' "; } if (!string.IsNullOrEmpty(inItem.inspect_tool)) { query += "AND inspect_tool='" + inItem.inspect_tool + "' "; } query += "ORDER BY part_number, inspect_id"; SQL.Open(); IDataReader reader = SQL.Command(query).ExecuteReader(); while (reader.Read()) { tbl_inspect_master outItem = new tbl_inspect_master { inspect_id = (int)reader["inspect_id"], inspect_cd = reader["inspect_cd"].ToString(), inspect_name = reader["inspect_name"].ToString(), part_number = reader["part_number"].ToString(), inspect_tool = reader["inspect_tool"].ToString(), inspect_spec = (double)reader["inspect_spec"], tol_plus = (double)reader["tol_plus"], tol_minus = (double)reader["tol_minus"], }; listMaster.Add(outItem); } SQL.Close(); return(listMaster.Count); }