public Entities.Lay_ID_Top_1 sp_Tim_ID(Entities.Lay_ID_Top_1 giatri) { Entities.Lay_ID_Top_1 trave = null; try { lay = new Constants.SelectID(); Sql = new Constants.Sql(); top = new Entities.Lay_ID_Top_1(); string sql = Sql.sp_Lay_ID; conn = new Connection(); cn = conn.openConnection(); cmd = new SqlCommand(sql, cn); cmd.Parameters.Add("table", SqlDbType.NVarChar, 50).Value = giatri.ColumnNameID; dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (dr.Read()) { top.ColumnNameID = dr[0].ToString(); } trave = new Entities.Lay_ID_Top_1(); trave.ColumnNameID = dr[Sql.ColumnNameID].ToString(); } catch (Exception ex) { string s = ex.Message.ToString(); } finally { cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); } return top; }
public Entities.Lay_ID_Top_1 sp_Tim_ID() { try { lay = new Constants.SelectID(); Sql = new Constants.Sql(); top = new Entities.Lay_ID_Top_1(); string sql = Sql.sp_Tim_ID_HoaDonNhap; conn = new Connection(); cn = conn.openConnection(); cmd = new SqlCommand(sql, cn); dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (dr.Read()) { top.ColumnNameID = dr[0].ToString(); } } catch (Exception ex) { string s = ex.Message.ToString(); } finally { cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); } return top; }