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