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