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