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