private void LoadData() { dgvList.Rows.Clear(); List<DB_Talk.Model.m_PDS> lst = new List<DB_Talk.Model.m_PDS>(); //lst = new DB_Talk.BLL.m_PDS().GetModelList("i_Flag=0"); lst = new DB_Talk.BLL.m_PDS().GetModelList(string.Format("i_Flag=0 and BoxID='{0}' ", Global.Params.BoxID)); int i = 0; foreach (DB_Talk.Model.m_PDS item in lst) { i++; dgvList.Rows[dgvList.Rows.Add(item.ID, item.PdsID, item.vc_IP )].Tag = item; } kryptonHeaderGroup1.ValuesSecondary.Heading = " 共" + dgvList.Rows.Count.ToString() + "条记录"; }
private void UpdateDB() { //同步数据库数据 List<DB_Talk.Model.m_PDS> lst = new List<DB_Talk.Model.m_PDS>(); Tools.MBoxOperate.GetPDS(out lst); //new DB_Talk.BLL.m_StaticRoute().Delete(string.Format(" BoxID='{0}'", Global.Params.BoxID)); DB_Talk.BLL.m_PDS bll = new DB_Talk.BLL.m_PDS(); foreach (DB_Talk.Model.m_PDS m in lst) { if (!bll.Exists(string.Format("i_Flag=0 and BoxID='{0}' and PdsID='{1}'", Global.Params.BoxID, m.PdsID))) bll.Add(m); } }