public void UpdateAllStuData() { Posts p = hc.GetAllStu(); DsPostVerid dpv = hc.GetSerStuVer(); List<DSstu> dslist = DataSwitch.JsonToList<DSstu>(p.Jsons); dop.InsandDelStuData(dslist); dop.UpdataVer(dpv,0); }
public void UpdataDiffStuData() { DsPostVerid ldpv = dop.GetLocalDPV("0"); DsPostVerid sdpv = hc.GetSerStuVer(); List<Posts> plist = hc.StuDiff(sdpv, ldpv); List<DSstu> dslist = new List<DSstu>(); foreach (var p in plist) { List<DSstu> dl = DataSwitch.JsonToList<DSstu>(p.Jsons); dslist.AddRange(dl); } dop.InsandDelStuData(dslist); dop.UpdataVer(sdpv,0); }
public void UpdataHisData() { DsPostVerid ldpv = dop.GetLocalDPV("1"); DsPostVerid sdpv = hc.GetSerHisVer(); List<Posts> plist = hc.HisData(sdpv, ldpv); List<DsHistory> dshlist = new List<DsHistory>(); foreach (var p in plist) { List<DsHistory> dl = DataSwitch.JsonToList<DsHistory>(p.Jsons); if (dl == null) continue; dshlist.AddRange(dl); } dop.InsertHisData(dshlist); dop.UpdataVer(sdpv, 1); }
public string DeleteAuth(string userauthjson, string userid) { List <UserAuth> authlist = DataSwitch.JsonToList <UserAuth>(userauthjson); var user = dbSet.GetList(u => u.UserID == userid.ToInt()); foreach (var dbauth in user) { foreach (var auth in authlist) { if (auth.AuthID == dbauth.AuthID) { dbSet.Delete(dbauth); } } } return(DataSwitch.HttpPostMsg(General.strSucess)); }
public string InsertTable(string authlistjson, string userid) { List <UserAuth> auths = dbSet.GetList(u => u.UserID == userid.ToInt()); List <Authority> authlist = DataSwitch.JsonToList <Authority>(authlistjson); List <UserAuth> userAuths = new List <UserAuth>(); List <Authority> addauth = new List <Authority>(); foreach (var auth in authlist) { bool check = true; foreach (var au in auths) { if (auth.id == au.AuthID) { check = false; } } if (check) { UserAuth userAuth = new UserAuth { AuthID = auth.id, UserID = userid.ToInt() }; userAuths.Add(userAuth); addauth.Add(auth); } } if (userAuths.Count == 0) { return(DataSwitch.HttpPostList(addauth)); } bool insert = dbSet.InsertRange(userAuths.ToArray()); if (insert) { return(DataSwitch.HttpPostList(addauth)); } return(DataSwitch.HttpPostMsg(General.strFail)); }
public List <T> GetEntities <T>(string json) { List <T> list = DataSwitch.JsonToList <T>(json); return(list); }