public Row_C_USER_PRIVILEGE getC_PrivilegebyIDemp(string id, string emp, OleExec DB)
{
string strSql = $@" SELECT * FROM C_USER_PRIVILEGE a,c_user b where a.PRIVILEGE_ID='{id}' and EMP_NO='{emp}' and A.USER_ID=B.ID ";
DataSet res = DB.ExecSelect(strSql);
if (res.Tables[0].Rows.Count > 0)
{
Row_C_USER_PRIVILEGE ret = (Row_C_USER_PRIVILEGE)NewRow();
ret.loadData(res.Tables[0].Rows[0]);
return(ret);
}
else
{
return(null);
}
}
public Row_C_USER_PRIVILEGE getC_PrivilegebyID(string id, OleExec DB)
{
string strSql = $@" SELECT * FROM C_USER_PRIVILEGE where PRIVILEGE_ID='{id}' ";
DataSet res = DB.ExecSelect(strSql);
if (res.Tables[0].Rows.Count > 0)
{
Row_C_USER_PRIVILEGE ret = (Row_C_USER_PRIVILEGE)NewRow();
ret.loadData(res.Tables[0].Rows[0]);
return(ret);
}
else
{
return(null);
}
}
