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