public int insert(ProvinceSumData psd)
{
int line = 0;
string sql = "insert into ProvinceSumData values (@province,@confirmed,@suspect,@death)";
List <MySqlParameter> plst = new List <MySqlParameter>();
plst.Add(new MySqlParameter("@province", psd.province));
plst.Add(new MySqlParameter("@confirmed", psd.confirmed));
plst.Add(new MySqlParameter("@suspect", psd.suspect));
plst.Add(new MySqlParameter("@death", psd.death));
line = MySQLHelper.ExecuteSql(sql, plst.ToArray());
return(line);
}
public List <ProvinceSumData> selectALL()
{
List <ProvinceSumData> psdlst = new List <ProvinceSumData>();
string sql = "select province,confirmed,suspect,death from ProvinceSumData";
MySqlDataReader reader = MySQLHelper.ExecuteReader(sql);
while (reader.Read())
{
ProvinceSumData psd = new ProvinceSumData(reader.GetString("province"), reader.GetInt32("confirmed"), reader.GetInt32("suspect"), reader.GetInt32("death"));
psdlst.Add(psd);
}
reader.Close();
return(psdlst);
}
public bool update(ProvinceSumData psd)
{
ProvinceSumData existPsd = psddao.selectByProvince(psd.province);
if (existPsd == null)
{
return(false);
}
int line = psddao.update(psd);
if (line == 1)
{
return(true);
}
return(false);
}
public int update(ProvinceSumData psd)
{
int line = 0;
string sql = "update ProvinceSumData set confirmed=@confirmed,suspect=@suspect,death=@death where province=@province";
List <MySqlParameter> plst = new List <MySqlParameter>();
plst.Add(new MySqlParameter("@province", psd.province));
plst.Add(new MySqlParameter("@confirmed", psd.confirmed));
plst.Add(new MySqlParameter("@suspect", psd.suspect));
plst.Add(new MySqlParameter("@death", psd.death));
line = MySQLHelper.ExecuteSql(sql, plst.ToArray());
return(line);
}
public ProvinceSumData selectByProvince(string province)
{
ProvinceSumData psd = null;
string sql = "select province,confirmed,suspect,death from ProvinceSumData where province=@province";
List <MySqlParameter> plst = new List <MySqlParameter>();
plst.Add(new MySqlParameter("@province", province));
MySqlDataReader reader = MySQLHelper.ExecuteReader(sql, plst.ToArray());
if (reader.Read())
{
psd = new ProvinceSumData(reader.GetString("province"), reader.GetInt32("confirmed"), reader.GetInt32("suspect"), reader.GetInt32("death"));
}
reader.Close();
return(psd);
}
public bool ProcessPlagueData(string jstr)
{
bool res = false;
JObject jnlst = JObject.Parse(jstr);
List <string> existDate = new List <string>();
ProvinceSumData psd = new ProvinceSumData("", 0, 0, 0);
IProvinceDailyDataBLL pddbll = new ProvinceDailyDataBLL();
IProvinceSumDataBLL psdbll = new ProvinceSumDataBLL();
foreach (JObject pdinfo in jnlst["results"])//province daily info
{
//province
string province = (string)pdinfo["provinceName"];
//date
System.DateTime startTime = TimeZone.CurrentTimeZone.ToLocalTime(new System.DateTime(1970, 1, 1));
double time = (double)pdinfo["updateTime"];
DateTime dt = startTime.AddMilliseconds(time);
string date = dt.ToString("yyyy-MM-dd");
if (existDate.Contains(date))
{
continue;
}
existDate.Add(date);
int confirmed = 0, suspect = 0, death = 0;
JObject judge = JObject.Parse("{\"error\": null}");
if (pdinfo.Property("confirmedCount") != null && pdinfo.Property("confirmedCount").ToString() != "" && !pdinfo["confirmedCount"].Equals(judge["error"]))
{
confirmed = (int)pdinfo["confirmedCount"];
}
if (pdinfo.Property("suspectedCount") != null && pdinfo.Property("suspectedCount").ToString() != "" && !pdinfo["suspectedCount"].Equals(judge["error"]))
{
suspect = (int)pdinfo["suspectedCount"];
}
if (pdinfo.Property("deadCount") != null && pdinfo.Property("deadCount").ToString() != "" && !pdinfo["deadCount"].Equals(judge["error"]))
{
death = (int)pdinfo["deadCount"];
}
//Console.WriteLine(province+" "+date+" "+confirmed+" "+suspect+" "+death);
//Console.ReadLine();
//构建ProvinceDailyData类
ProvinceDailyData pdd = new ProvinceDailyData(province, date, confirmed, suspect, death);
//插入数据库
if (pddbll.insert(pdd) == false)
{
res = pddbll.update(pdd);
if (res == false)
{
return(res);
}
}
//更新psd的值
psd.province = province;
psd.confirmed = Math.Max(psd.confirmed, pdd.confirmed);
psd.suspect = Math.Max(psd.suspect, pdd.suspect);
psd.death = Math.Max(psd.death, pdd.death);
}
Console.WriteLine("psd " + psd.province + " " + psd.confirmed + " " + psd.suspect + " " + psd.death);
Console.ReadLine();
if (psdbll.insert(psd) == false)
{
res = psdbll.update(psd);
if (res == false)
{
return(res);
}
}
return(res);
}
