public static Sys_User GetItem(string no)
{
if (Default == null)
{
return(null);
}
Sys_User result = (Sys_User)Default.FindRow("No", no);
if (result != null)
{
return(result);
}
string sql = "select su.*,sa.DEP,d.Name DepName from Sys_User su LEFT join salm sa on su.no=sa.SYS_USR left JOIN DEPT d on sa.DEP=d.DEP where su.No=@NO";
BooleanValue <DataRow> bv = DAO.Default.GetDataRow(sql, new SqlParameters {
DbParameters.CreateDbParameter("@NO", no, DbType.AnsiStringFixedLength, 50)
});
DataRow dr = bv.Value;
if (dr == null)
{
return(null);
}
result = Default.LoadDataRow(dr, true) as Sys_User;
return(result);
}
public static Sys_User GetItem(int id)
{
Sys_User result = (Sys_User)Default.FindRow("ID", id);
if (result != null)
{
return(result);
}
string sql = string.Format("select su.*,dp.name as DepName from Sys_User su left join dept dp on su.dep=dp.dep where su.ID={0}", id);
BooleanValue <DataRow> bv = DAO.Default.GetDataRow(sql);
DataRow dr = bv.Value;
if (dr == null)
{
return(null);
}
result = Default.LoadDataRow(dr, true) as Sys_User;
return(result);
}
