public static void UpdateFromServer()
{
string filePath;
//Ops Op = bulidOp();
//// 数组 【】 对象{} 值“”
string json1 = "{type:'image',url:'http://i1.hoopchina.com.cn/blogfile/201501/08/BbsImg142070525332424_550*550.jpg'}";
string json2 = "{type:'video',url:'http://i2.hoopchina.com.cn/blogfile/201411/27/BbsImg141707487288557_1271*988.jpg'}";
//string json2 = "{type:'video',url:'http://v.youku.com/v_show/id_XODczMTA2OTc2.html'}";
string json3 = "{type:'image',url:'http://i1.hoopchina.com.cn/blogfile/201304/09/136548593327743.jpg'}";
string jsonString = "[" + json1 + "," + json2 + "," + json3 + "]";
StringBuilder sb = new StringBuilder();
JArray array1 = (JArray)JsonConvert.DeserializeObject(jsonString);
for (int i = 0; i < 3; ++i)
{
WebClient mywebclient = new WebClient();
JObject jo = (JObject)array1[i];
string url = jo["url"].ToString();
string newfilename = DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString()
+ DateTime.Now.Day.ToString() + DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Second.ToString() + i + ".jpg";
//下载很快，如果不在文件名加入i的话，会在一秒内下载完，使用时间当做文件名，最后就只剩一个文件。
//string filePath = @"D:\VSPROJECT\WindowsFormsApplication3\" + newfilename;
if (jo["type"].ToString().Equals("image"))
{
filePath = @Environment.CurrentDirectory + "/Image/" + newfilename;
}
else if (jo["type"].ToString().Equals("video"))
{
filePath = @Environment.CurrentDirectory + "/Video/" + newfilename;
}
else
{
filePath = @"D:\";
}
try
{
mywebclient.DownloadFile(url, filePath);
SQLiteParameter[] Params1 = new SQLiteParameter[] {
new SQLiteParameter("@type", jo["type"]),
new SQLiteParameter("@url", jo["url"]),
new SQLiteParameter("@filename", newfilename),
new SQLiteParameter("@filepath", filePath),
new SQLiteParameter("@state", 1)
};
if (File.Exists(filePath))
{
Op.ChangeCommand(cmdInsertTableupdateText, Params1);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
}
int j = updateSq.checkLastUpdate();
}
public static int getCloums()
{
string cmd = "SELECT type FROM tableConf";
Ops Op = new Ops(dbPath);
SQLiteDataReader sdr = Op.noChangeCommand(cmd);
int i = 0;
while (sdr.Read())
{
i++;
}
if (i == 0)
{
string cmdInsertC1 = "INSERT INTO tableConf(type,val) VALUES ('url','null')";
string cmdInsertC2 = "INSERT INTO tableConf(type,val) VALUES ('com','null')";
Op.ChangeCommand(cmdInsertC1, null);
Op.ChangeCommand(cmdInsertC2, null);
int a = i;
return(i);
}
else
{
return(i);
}
}
public static void initUsingTable()
{
Ops Op = new Ops(dbPath);
//string cmdCreateUsingtableText = getCreateText("fileUsing");
Op.ChangeCommand(cmdCreateUsingtableText, null);
}
public static void setCOM(string value)
{
string str1 = "UPDATE tableConf SET val=";
string str2 = "WHERE type = 'com'";
string cmdUpdateConfTable = str1 + "'" + value + "'" + str2;
Ops Op = new Ops(dbPath);
Op.ChangeCommand(cmdUpdateConfTable, null);
}
public static void initUsingTable()
{
Ops Op = bulidOp();
SQLiteConnection conn = Ops.buildConn();
//Op.PrepareCommand(cmdCreteText, null);
Ops.ChangeCommand(cmdCreteUsingtableText, conn);
conn.Close();
}
public static void initUsingTable()
{
Ops Op = bulidOp();
string cmdCreteText = "CREATE TABLE IF NOT EXISTS fileUsing(type varchar(30),url varchar(1000),filename varcharo(30),filepath varchar(1000),state integer)";
SQLiteConnection conn = Ops.buildConn();
//Op.PrepareCommand(cmdCreteText, null);
Ops.ChangeCommand(cmdCreteText, conn);
conn.Close();
}
public static int checkLastUpdate()
{
string filePath = null;
SQLiteConnection conn = Ops.buildConn();
string cmdQueryText = "SELECT * FROM fileUpdate WHERE state<1";
SQLiteDataReader sdr = Ops.noChangeCommand(cmdQueryText, conn);
Ops.ChangeCommand(cmdQueryText, conn);
int i = 0;
int j = 0;
while (sdr.Read())
{
i++;
string filenamestr = sdr.GetString(2);
SQLiteCommand cmdChangeTable;
if (sdr.GetString(0).Equals("image"))
{
filePath = @Environment.CurrentDirectory + "/Image/" + filenamestr;
}
else if (sdr.GetString(0).Equals("video"))
{
filePath = @Environment.CurrentDirectory + "/Video/" + filenamestr;
}
else
{
filePath = @"D:\";
}
//写程序时要严格注意语法规则，可以节省不少时间
string cmdUpdateText = "UPDATE fileUpdate SET state=1 WHERE filename =" + "'" + filenamestr + "'";
if (File.Exists(filePath))
{
Ops.ChangeCommand(cmdUpdateText, conn);
Console.WriteLine(j);
}
Console.WriteLine(sdr.GetString(1) + " " + sdr.GetString(2));
}
if (i == 0)
{
Console.WriteLine(i);
string cmdDropText = "DROP TABLE fileUsing";
Ops.ChangeCommand(cmdDropText, conn);
initSqlite.initUsingTable();
string cmdCopyText = "INSERT INTO fileUsing SELECT * FROM fileUpdate";
Ops.ChangeCommand(cmdCopyText, conn);
}
conn.Close();
return(i);
}
public static void UpdateFromServer()
{
string filePath;
//Ops Op = bulidOp();
//// 数组 【】 对象{} 值“”
string json1 = "{type:'image',url:'http://i1.hoopchina.com.cn/blogfile/201501/08/BbsImg142070525332424_550*550.jpg'}";
//string json2 = "{type:'video',url:'http://i2.hoopchina.com.cn/blogfile/201411/27/BbsImg141707487288557_1271*988.jpg'}";
string json2 = "{type:'image',url:'http://p0.qhimg.com/dmsmty/70_70_100/t0152c6ddbb22a37797.png'}";
string json3 = "{type:'image',url:'http://i1.hoopchina.com.cn/blogfile/201304/09/136548593327743.jpg'}";
string jsonString = "[" + json1 + "," + json2 + "," + json3 + "]";
// string jsonString = myfile.readname();
StringBuilder sb = new StringBuilder();
JArray array1 = (JArray)JsonConvert.DeserializeObject(jsonString);
int le = array1.ToArray().Length;
for (int i = 0; i < le; ++i)
{
WebClient mywebclient = new WebClient();
JObject jo = (JObject)array1[i];
//string frontUrl = "http://10.108.158.5:8080/cpServerPro";
//string backUrl = jo["url"].ToString();
//string url = frontUrl + backUrl;
//string newfilename = backUrl;
//Boolean b = backUrl.Equals("");
//if (b) { continue; }
string url = jo["url"].ToString();
Boolean isHave = urlSearch(url);
if (isHave)
{
continue;
}
//if (backUrl.Equals("")) { continue; }
string newfilename = DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString()
+ DateTime.Now.Day.ToString() + DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Second.ToString() + i + ".jpg";
//下载很快，如果不在文件名加入i的话，会在一秒内下载完，使用时间当做文件名，最后就只剩一个文件。
//string filePath = @"D:\VSPROJECT\WindowsFormsApplication3\" + newfilename;
if (jo["type"].ToString().Equals("image"))
{
filePath = @Environment.CurrentDirectory + "/Image/" + newfilename;
}
else if (jo["type"].ToString().Equals("video"))
{
filePath = @Environment.CurrentDirectory + "/Video/" + newfilename;
}
else
{
filePath = @"D:\";
}
try
{
mywebclient.DownloadFile(url, filePath);
SQLiteParameter[] Params1 = new SQLiteParameter[] {
new SQLiteParameter("@type", jo["type"]),
new SQLiteParameter("@url", jo["url"]),
new SQLiteParameter("@filename", newfilename),
new SQLiteParameter("@filepath", filePath),
new SQLiteParameter("@state", 1)
};
if (File.Exists(filePath))
{
Op.ChangeCommand(cmdInsertTableupdateText, Params1);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
}
int j = updateSq.checkLastUpdate();
}
public static void initUsingTable()
{
Ops Op = new Ops(dbPath);
Op.ChangeCommand(cmdCreteUsingtableText, null);
}
public static void createConfTable()
{
Ops Op = new Ops(dbPath);
Op.ChangeCommand(cmdCreateConfTable, null);
}
