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