public int UpdateById(C_ACTION_CODE NewActionCode, OleExec DB)
{
Row_C_ACTION_CODE NewActionCodeRow = (Row_C_ACTION_CODE)NewRow();
NewActionCodeRow.ID = NewActionCode.ID;
NewActionCodeRow.ACTION_CODE = NewActionCode.ACTION_CODE;
NewActionCodeRow.ENGLISH_DESCRIPTION = NewActionCode.ENGLISH_DESCRIPTION;
NewActionCodeRow.CHINESE_DESCRIPTION = NewActionCode.CHINESE_DESCRIPTION;
NewActionCodeRow.EDIT_EMP = NewActionCode.EDIT_EMP;
NewActionCodeRow.EDIT_TIME = NewActionCode.EDIT_TIME;
int result = DB.ExecuteNonQuery(NewActionCodeRow.GetUpdateString(DBType, NewActionCode.ID), CommandType.Text);
return(result);
}
public C_ACTION_CODE GetByid(string id, OleExec DB)
{
string strSql = $@"select * from c_action_code where id=:id";
OleDbParameter[] paramet = new OleDbParameter[] { new OleDbParameter(":id", id) };
DataTable res = DB.ExecuteDataTable(strSql, CommandType.Text, paramet);
if (res.Rows.Count > 0)
{
Row_C_ACTION_CODE ret = (Row_C_ACTION_CODE)NewRow();
ret.loadData(res.Rows[0]);
return(ret.GetDataObject());
}
else
{
return(null);
}
}
public List <C_ACTION_CODE> GetByFuzzySearch(string ParametValue, OleExec DB)
{
string strSql = $@"select * from c_action_code where upper(action_code) like'%{ParametValue}%' or upper(english_description) like'%{ParametValue}%' or upper(chinese_description) like'%{ParametValue}%'";
List <C_ACTION_CODE> result = new List <C_ACTION_CODE>();
DataTable res = DB.ExecuteDataTable(strSql, CommandType.Text);
if (res.Rows.Count > 0)
{
for (int i = 0; i < res.Rows.Count; i++)
{
Row_C_ACTION_CODE ret = (Row_C_ACTION_CODE)NewRow();
ret.loadData(res.Rows[i]);
result.Add(ret.GetDataObject());
}
return(result);
}
else
{
return(null);
}
}
public List <C_ACTION_CODE> GetAllActionCode(OleExec DB)
{
string strSql = $@"select * from c_action_code ";
List <C_ACTION_CODE> result = new List <C_ACTION_CODE>();
DataTable res = DB.ExecuteDataTable(strSql, CommandType.Text);
if (res.Rows.Count > 0)
{
for (int i = 0; i < res.Rows.Count; i++)
{
Row_C_ACTION_CODE ret = (Row_C_ACTION_CODE)NewRow();
ret.loadData(res.Rows[i]);
result.Add(ret.GetDataObject());
}
return(result);
}
else
{
return(null);
}
}
