/// <summary> /// 更新文件列表 /// </summary> /// <param name="retmsg"></param> /// <param name="filedata"></param> /// <returns></returns> public static int DoUpdateFileList(string account, out string retmsg, out CommonData.FileData filedata) { int res = -1; try { WRFileUpdate.UpdateFileWebService ws = new WRFileUpdate.UpdateFileWebService(); RecvRes retres = TransRes(ws.GetUpdateFileList(account)); retmsg = retres.Description; filedata = null; if (retres.IsOK) { if (!string.IsNullOrEmpty(retres.ExtData)) { string jsondata = retres.ExtData; filedata = JsonDeal.JsonData2FileData(jsondata); res = 0; } else { throw new Exception("accpect extData is null"); } } } catch (Exception ex) { filedata = null; retmsg = ex.Message; throw; } return(res); }
public static string FileData2JsonData(CommonData.FileData filedata) { string jsondata = ""; jsondata = JsonConvert.SerializeObject(filedata); return(jsondata); }
public void InitFileList() { fileListLocal = new CommonData.FileData(); fileListAccept = new CommonData.FileData(); fileListAdd = new CommonData.FileData(); fileListUpdate = new CommonData.FileData(); fileListDelete = new CommonData.FileData(); }
/// <summary> /// 将本地文件信息写进数据库 /// </summary> /// <param name="fileData"></param> public void SetFileDataToDB(CommonData.FileData fileData) { DeleteFileDataList(); for (int i = 0; i < fileData.DataList.Count; i++) { string strSql = string.Format(@"Insert into LocalFileList ([FilePath],[FileMD5],[FileURL]) VALUES ('{0}','{1}','{2}')", EncryptString(fileData.DataList[i].FilePath, Skey), EncryptString(fileData.DataList[i].FileMD5, Skey), EncryptString(fileData.DataList[i].FileURL, Skey)); ExecuteCommand(strSql); } }
public static CommonData.FileData JsonData2FileData(string jsondata) { CommonData.FileData filedata = new CommonData.FileData(); //filedata = JsonConvert.DeserializeObject<CommonData.FileData>(jsondata); List <CommonData.Data> datalist = JsonConvert.DeserializeObject <List <CommonData.Data> >(jsondata); filedata.DataList = datalist; return(filedata); }
/// <summary> /// 根据路径在list中找到CommonData数据 /// </summary> /// <param name="infileList"></param> /// <param name="path"></param> /// <returns></returns> private CommonData.Data FindDataByPath(CommonData.FileData infileList, string path) { if (infileList.DataList.Count == 0) { return(null); } foreach (CommonData.Data d in infileList.DataList) { if (string.Compare(path, d.FilePath) == 0) { return(d); } } return(null); }
/// <summary> /// 读取数据库中本地文件信息 /// </summary> /// <returns></returns> public CommonData.FileData GetFileDataFromDB() { CommonData.FileData filedata = new CommonData.FileData(); string strSql = string.Format(@"SELECT FilePath,FileMD5,FileURL FROM LocalFileList"); DataTable table = GetDataTable(strSql); if (table == null || table.Rows.Count == 0) { return(null); } for (int i = 0; i < table.Rows.Count; i++) { DataRow dr = table.Rows[i]; CommonData.Data data = new CommonData.Data(); data.FilePath = DecryptString(GetString(dr["FilePath"]), Skey); data.FileMD5 = DecryptString(GetString(dr["FileMD5"]), Skey); data.FileURL = DecryptString(GetString(dr["FileURL"]), Skey); filedata.DataList.Add(data); } return(filedata); }