public string UploadDiffStudentdata() { string json = hc.GetSerStuJsonByPostid("1"); Posts p = DataSwitch.JsonToObject <Posts>(json); DsPostVerid dpv = DataSwitch.JsonToObject <DsPostVerid>(p.Jsons); DataTable dt = (DataTable)gdb.GetStudentData(dpv.dbid, "byid"); if (dt.Rows.Count == 0) { return("未有更新项"); } string postjson = DataSwitch.DataToJson(dt); string dbmaxid = gdb.GetStudentData("", "ver").ToString(); Posts p1 = new Posts { ID = dpv.serid + 1, Jsons = postjson }; dpv.serid = dpv.serid + 1; dpv.dbid = dbmaxid; Posts p2 = CreatPost(1, dpv); hc.PostStudentData(p1); return(hc.PostStudentData(p2)); }
public string UploadHisData() { string hisverjson = hc.GetSerHisMaxIDJson("1"); Posts p = DataSwitch.JsonToObject <Posts>(hisverjson); DsPostVerid dpv = DataSwitch.JsonToObject <DsPostVerid>(p.Jsons); return(GetanduploadHisData(dpv)); }
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); }
internal DsPostVerid GetLocalDPV(string soh) { string sql = string.Format("SELECT * FROM DSdataver WHERE datatype = '{0}'", soh); DataTable dt = initsql.SQLiteGetTable(sql); DsPostVerid dv = new DsPostVerid { serid = int.Parse(dt.Rows[0]["serstuid"].ToString()), dbid = dt.Rows[0]["serhisid"].ToString() }; return(dv); }
public string GetanduploadHisData(DsPostVerid dpv) { DataTable dt = (DataTable)gdb.GetStudentData(dpv.dbid, "his"); if (dt.Rows.Count > 0) { string dbmaxid = dt.Rows[dt.Rows.Count - 1]["ID"].ToString(); Posts p = CreatPost(dpv.serid + 1, dt); return(hc.PostHisData(p)); } return("记录上传不成功"); }
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 GetVerData(string sid) { string str = ""; string serjsonstr = hc.GetSerStuJsonByPostid(sid); Posts p = DataSwitch.JsonToObject <Posts>(serjsonstr); DsPostVerid dps = DataSwitch.JsonToObject <DsPostVerid>(p.Jsons); int count = 1; //foreach (DataRow item in dps.DSAllstudentDT.Rows) //{ // str+=count+"--"+ item["dsname"].ToString()+"\r\n"; // count++; //} return(serjsonstr); }
public string UploadAllstudentdata() { DataTable dt = (DataTable)gdb.GetStudentData("", "alldata"); string json = DataSwitch.DataToJson(dt); Posts p1 = new Posts { ID = 2, Jsons = json }; string Smaxid = hc.GetSerStuMaxID(); string dbmaxid = gdb.GetStudentData("", "ver").ToString(); DsPostVerid dpv = new DsPostVerid { serid = StrToInt(Smaxid), dbid = dbmaxid }; Posts p2 = CreatPost(1, dpv); hc.PostStudentData(p1); return(hc.PostStudentData(p2)); }
public string UploadHisVer() { Posts sp = DataSwitch.JsonToObject <Posts>(hc.GetSerHisMaxIDJson("1")); DsPostVerid dpv = DataSwitch.JsonToObject <DsPostVerid>(sp.Jsons); dpv.serid = dpv.serid + 1; DataTable maxdbiddt = (DataTable)gdb.GetStudentData("", "hisid"); string maxdbid = ""; if (maxdbiddt.Rows.Count > 0) { maxdbid = maxdbiddt.Rows[0]["ID"].ToString(); dpv.dbid = maxdbid; Posts p = CreatPost(1, dpv); return(hc.PostHisData(p)); } return(""); }
public void UpdataVer(DsPostVerid dpv, int datatype) { string sql = string.Format("UPDATE DSdataver SET serstuid = '{0}', serhisid = '{1}' WHERE datatype = '{2}'", dpv.serid, dpv.dbid, datatype); initsql.SQLiteNonQuery(sql); }