private decimal find_id_lcd_by_ma_lcd(string ma_lcd, string muc_lcd)
{
try
{
decimal id_ma_lcd = (from DataRow dr in m_dt_ma_lcd.Rows
where (string)dr["MA_TU_DIEN"] == ma_lcd
select (decimal)dr["ID"]).FirstOrDefault();
decimal id_muc_lcd = (from DataRow dr in m_dt_muc_lcd.Rows
where (string)dr["MA_TU_DIEN"] == muc_lcd
select (decimal)dr["ID"]).FirstOrDefault();
US_DM_LUONG_CHE_DO v_us = new US_DM_LUONG_CHE_DO();
DS_DM_LUONG_CHE_DO v_ds = new DS_DM_LUONG_CHE_DO();
v_us.FillDataset(v_ds);
decimal id_lcd = (from DataRow dr in v_ds.Tables[0].Rows
where (decimal)dr["ID_MA_LCD"] == id_ma_lcd & (decimal)dr["ID_MUC_LCD"] == id_muc_lcd
select (decimal)dr["ID"]).FirstOrDefault();
return id_lcd;
}
catch (Exception v_e)
{
throw v_e;
}
}