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