/// <summary>
/// Check table
/// </summary>
/// <param name="tblName">table name</param>
/// <returns>true: if table is exist</returns>
public bool CheckTblExist(string tblName)
{
try
{
PSQL SQL = new PSQL();
string query = string.Empty;
query = "SELECT 1 FROM " + tblName;
SQL.Open();
SQL.Command(query).ExecuteScalar();
SQL.Close();
return(true);
}
catch
{
return(false);
}
}
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);
}
public int Search(tbl_inspect_data inItem)
{
listData.Clear();
PSQL SQL = new PSQL();
string query = string.Empty;
string[] box = inItem.part_box_cd.Split('#');
string month = box[2].Remove(6, 2);
string tablename = "tbl_inspect_data" + month;
if (!CheckTblExist(tablename))
{
return(0);
}
query = "SELECT part_box_cd, item_no, inspect_id, inspect_data, judge, inspect_date, incharge FROM " + tablename + " WHERE 1=1 ";
query += "AND part_box_cd ='" + inItem.part_box_cd + "' AND inspect_id ='" + inItem.inspect_id;
query += "' ORDER BY inspect_id, item_no";
SQL.Open();
IDataReader reader = SQL.Command(query).ExecuteReader();
while (reader.Read())
{
tbl_inspect_data outItem = new tbl_inspect_data
{
part_box_cd = reader["part_box_cd"].ToString(),
item_no = (int)reader["item_no"],
inspect_id = (int)reader["inspect_id"],
inspect_data = (double)reader["inspect_data"],
judge = reader["judge"].ToString(),
inspect_date = (DateTime)reader["inspect_date"],
incharge = reader["incharge"].ToString(),
};
listData.Add(outItem);
}
SQL.Close();
return(listData.Count);
}
/// <summary>
/// Saearch item in table part box
/// </summary>
/// <param name="inItem">input info</param>
/// <param name="checkDate">true: if check date</param>
/// <returns>number of item</returns>
public int Search(tbl_part_box inItem, bool checkDate)
{
listBox.Clear();
PSQL SQL = new PSQL();
string query = string.Empty;
query = "SELECT part_box_id, part_box_cd, part_number, part_name, model_cd, invoice, part_box_qty, part_box_lot, part_box_date, ";
query += "vender_cd, purpose_cmt, incharge FROM tbl_part_box WHERE 1=1 ";
if (!string.IsNullOrEmpty(inItem.part_box_cd))
{
query += "AND part_box_cd ='" + inItem.part_box_cd + "' ";
}
if (!string.IsNullOrEmpty(inItem.part_number))
{
query += "AND part_number ='" + inItem.part_number + "' ";
}
if (!string.IsNullOrEmpty(inItem.part_name))
{
query += "AND part_name ='" + inItem.part_name + "' ";
}
if (!string.IsNullOrEmpty(inItem.model_cd))
{
query += "AND model_cd ='" + inItem.model_cd + "' ";
}
if (!string.IsNullOrEmpty(inItem.invoice))
{
query += "AND invoice ='" + inItem.invoice + "' ";
}
if (!string.IsNullOrEmpty(inItem.vender_cd))
{
query += "AND vender_cd ='" + inItem.vender_cd + "' ";
}
if (!string.IsNullOrEmpty(inItem.purpose_cmt))
{
query += "AND purpose_cmt ='" + inItem.purpose_cmt + "' ";
}
if (checkDate)
{
query += "AND part_box_date ='" + inItem.part_box_date + "' ";
}
query += "ORDER BY part_box_cd, part_box_date";
SQL.Open();
IDataReader reader = SQL.Command(query).ExecuteReader();
while (reader.Read())
{
tbl_part_box outItem = new tbl_part_box()
{
part_box_id = (int)reader["part_box_id"],
part_box_cd = reader["part_box_cd"].ToString(),
part_number = reader["part_number"].ToString(),
part_name = reader["part_name"].ToString(),
model_cd = reader["model_cd"].ToString(),
invoice = reader["invoice"].ToString(),
part_box_qty = (double)reader["part_box_qty"],
part_box_lot = reader["part_box_lot"].ToString(),
part_box_date = (DateTime)reader["part_box_date"],
vender_cd = reader["vender_cd"].ToString(),
purpose_cmt = reader["purpose_cmt"].ToString(),
incharge = reader["incharge"].ToString()
};
listBox.Add(outItem);
}
SQL.Close();
return(listBox.Count);
}
