public static List <SnapFileVM> RetrieveFileByID(string id, string username)
{
var sql = "select DocID,FileAddr,Owner,ShareTo,ReviewTimes,UpdateTime from SnapFileVM where DocID=@DocID";
var ret = new List <SnapFileVM>();
var dict = new Dictionary <string, string>();
dict.Add("@DocID", id);
var dbret = DBUtility.ExeLocalSqlWithRes(sql, dict);
foreach (var line in dbret)
{
var tempvm = new SnapFileVM();
tempvm.DocID = Convert.ToString(line[0]);
tempvm.FileAddr = Convert.ToString(line[1]);
tempvm.Owner = Convert.ToString(line[2]);
tempvm.ShareTo = Convert.ToString(line[3]);
tempvm.ReviewTimes = Convert.ToInt32(line[4]);
if (string.Compare(tempvm.ShareTo, username, true) == 0)
{
ret.Add(tempvm);
UpdateReviewTimes(tempvm.DocID, tempvm.ShareTo, (tempvm.ReviewTimes + 1));
return(ret);
}
if (string.Compare(tempvm.Owner, username, true) == 0)
{
ret.Add(tempvm);
return(ret);
}
}
return(ret);
}
public static List <SnapFileVM> RetrieveFileListByOwner(string owner)
{
var sql = "select distinct DocID,FileAddr,UpdateTime,APVal2 from SnapFileVM where Owner=@Owner and APVal1 <> 'DELETE' order by UpdateTime desc";
var ret = new List <SnapFileVM>();
var dict = new Dictionary <string, string>();
dict.Add("@Owner", owner);
var dbret = DBUtility.ExeLocalSqlWithRes(sql, dict);
foreach (var line in dbret)
{
var tempvm = new SnapFileVM();
tempvm.DocID = Convert.ToString(line[0]);
tempvm.FileAddr = Convert.ToString(line[1]);
tempvm.UpdateTime = Convert.ToDateTime(line[2]).ToString("yyyy-MM-dd");
tempvm.Tag = Convert.ToString(line[3]);
ret.Add(tempvm);
}
return(ret);
}
public static List <SnapFileVM> RetrieveFileListByShareTo(string shareto)
{
var sql = "select DocID,FileAddr,Owner,ShareTo,UpdateTime,ReviewTimes,APVal2 from SnapFileVM where ShareTo=@ShareTo order by ReviewTimes desc, UpdateTime desc";
var ret = new List <SnapFileVM>();
var dict = new Dictionary <string, string>();
dict.Add("@ShareTo", shareto);
var dbret = DBUtility.ExeLocalSqlWithRes(sql, dict);
foreach (var line in dbret)
{
var tempvm = new SnapFileVM();
tempvm.DocID = Convert.ToString(line[0]);
tempvm.FileAddr = Convert.ToString(line[1]);
tempvm.Owner = Convert.ToString(line[2]);
tempvm.UpdateTime = Convert.ToDateTime(line[4]).ToString("yyyy-MM-dd");
tempvm.Tag = Convert.ToString(line[6]);
ret.Add(tempvm);
}
return(ret);
}
