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); }