/// <summary>
/// Search list log
/// </summary>
/// <param name="inItem">input info</param>
/// <param name="fromDate"></param>
/// <param name="toDate"></param>
/// <param name="checkDate">check date for search or no</param>
public void Search(pts_stock_log inItem, DateTime fromDate, DateTime toDate, bool checkDate)
{
//SQL library
PSQL SQL = new PSQL();
string query = string.Empty;
//Open SQL connection
SQL.Open();
//SQL query string
query = "SELECT log_id, log_date, log_action, log_user_cd, stock_id, stock_field, before_value, after_value ";
query += "FROM pts_stock_log WHERE 1=1 ";
if (checkDate)
{
query += "AND log_date >= '" + fromDate.ToString("yyyy-MM--dd HH:mm:ss") + "' ";
query += "AND log_date <= '" + toDate.ToString("yyyy-MM--dd HH:mm:ss") + "' ";
}
if (!string.IsNullOrEmpty(inItem.log_action))
{
query += "AND log_action ='" + inItem.log_action + "' ";
}
if (!string.IsNullOrEmpty(inItem.log_user_cd))
{
query += "AND log_user_cd ='" + inItem.log_user_cd + "' ";
}
if (!string.IsNullOrEmpty(inItem.stock_field))
{
query += "AND stock_field ='" + inItem.stock_field + "' ";
}
query += "ORDER BY log_id";
//Execute reader for read database
IDataReader reader = SQL.Command(query).ExecuteReader();
while (reader.Read())
{
pts_stock_log outItem = new pts_stock_log
{
log_id = (int)reader["log_id"],
log_date = (DateTime)reader["log_date"],
log_action = reader["log_action"].ToString(),
log_user_cd = reader["log_user_cd"].ToString(),
stock_id = reader["stock_id"].ToString(),
stock_field = reader["stock_field"].ToString(),
before_value = reader["before_value"].ToString(),
after_value = reader["after_value"].ToString(),
};
listStockLog.Add(outItem);
}
query = string.Empty;
SQL.Close();
}
/// <summary>
/// Add new log
/// </summary>
/// <param name="inItem">add new log_action, usercode, stockid, stockfield, before_value, after_value</param>
/// <returns></returns>
public int AddLog(pts_stock_log inItem)
{
//SQL library
PSQL SQL = new PSQL();
string query = string.Empty;
//Open SQL connection
SQL.Open();
//SQL query string
query = "INSERT INTO pts_stock_log(log_action, log_user_cd, stock_id, stock_field, before_value, after_value) ";
query += "VALUES('" + inItem.log_action + "','" + inItem.log_user_cd + "','" + inItem.stock_id + "','" + inItem.stock_field;
query += "','" + inItem.before_value + "','" + inItem.after_value + "')";
//Execute non query for read database
int result = SQL.Command(query).ExecuteNonQuery();
query = string.Empty;
SQL.Close();
return(result);
}