private bool CheckTonTai(string strDoiTuong) { bool kq = false; clsDM_ChuyenDoiMucHuong obj = new clsDM_ChuyenDoiMucHuong(); kq = obj.CheckTonTai(strDoiTuong); return kq; }
public static List<clsDM_ChuyenDoiMucHuong> GetListChuyenDoi() { List<clsDM_ChuyenDoiMucHuong> lst = new List<clsDM_ChuyenDoiMucHuong>(); SQLiteConnection m_dbConnection = new SQLiteConnection(ConfigurationManager.AppSettings["ConnectionString"]); m_dbConnection.Open(); DataTable dt = new DataTable(); string sql = "select * from DM_ChuyenDoi order by DoiTuong"; SQLiteCommand cmd = new SQLiteCommand(sql, m_dbConnection); SQLiteDataAdapter da = new SQLiteDataAdapter(cmd); da.Fill(dt); m_dbConnection.Close(); foreach (DataRow row in dt.Rows) { clsDM_ChuyenDoiMucHuong mh = new clsDM_ChuyenDoiMucHuong(); mh.ChuyenDoi_Id = int.Parse(row["ChuyenDoi_Id"].ToString()); mh.DoiTuong = row["DoiTuong"].ToString(); mh.MucHuongCu = int.Parse(row["MucHuongCu"].ToString()); mh.MucHuongMoi = int.Parse(row["MucHuongMoi"].ToString()); lst.Add(mh); } return lst; }
private void LoadGridView() { clsDM_ChuyenDoiMucHuong obj = new clsDM_ChuyenDoiMucHuong(); TableChuyenDoiMucHuong = obj.GetAll(); grdDM_ChuyenDoiMucHuong.DataSource = TableChuyenDoiMucHuong; }