/// <summary>
/// 获取资源属性（是否可打印，存盘）
/// </summary>
/// <param name="ResourceFolder_Id"></param>
/// <returns></returns>
public static Rc.Interface.BookAttrModel GetBookAttrValue(string ResourceFolder_Id)
{
Rc.Interface.BookAttrModel model = new Rc.Interface.BookAttrModel();
model.IsPrint = false;
model.IsSave = false;
try
{
List <Model_BookAttrbute> listModel = new BLL_BookAttrbute().GetModelList("ResourceFolder_Id='" + ResourceFolder_Id + "'");
foreach (var item in listModel)
{
if (item.AttrEnum == BookAttrEnum.Print.ToString() && item.AttrValue == "1")
{
model.IsPrint = true;
}
else if (item.AttrEnum == BookAttrEnum.Save.ToString() && item.AttrValue == "1")
{
model.IsSave = true;
}
}
}
catch (Exception)
{
}
return(model);
}
public static string GetCloudResource(string ResourceFolder_Id, string DocName, string ShowFolderIn, string strResource_Class, int PageSize, int PageIndex)
{
Rc.Model.Resources.Model_F_User FloginUser = Rc.Common.StrUtility.clsUtility.IsFPageFlag() as Rc.Model.Resources.Model_F_User;
try
{
DocName = DocName.Filter();
PageIndex = Convert.ToInt32(PageIndex.ToString().Filter());
#region 资源信息
DataTable dtRes = new DataTable();
List <object> listReturn = new List <object>();
string strSql = string.Empty;
string strSqlCount = string.Empty;
string strWhere = string.Empty;
if (!string.IsNullOrEmpty(DocName))
{
strWhere = " and File_Name like '%" + DocName.Filter() + "%' ";
}
//strWhere += string.Format(" and LessonPlan_Type='{0}' and Resource_Class = '{1}'", strLessonPlan_Type.Filter(), strResource_Class.Filter());
strWhere += string.Format(" and Resource_Class = '{0}'", strResource_Class.Filter());
if (Resource_ClassConst.云资源 == strResource_Class)
{
strWhere += string.Format(" AND Book_ID IN(SELECT Book_ID FROM UserBuyResources WHERE A.Book_ID=UserBuyResources.Book_id AND UserBuyResources.UserId='{0}' )"
, FloginUser.UserId);
}
if (ShowFolderIn != "1")
{
strWhere += " and ResourceFolder_Id='" + ResourceFolder_Id.Filter() + "' ";
}
else
{
strWhere += " and 1<>1 ";
}
//strWhere += string.Format(" and Resource_Class='{0}' and Resource_Type='{1}'", strResource_Class, strResource_Type);
strSqlCount = @"select count(*) from ResourceToResourceFolder A
INNER JOIN Resource B ON A.Resource_Id=B.Resource_Id where 1=1 " + strWhere + " ";
strSql = @"select * from (select ROW_NUMBER() over(ORDER BY A.ResourceToResourceFolder_Order,A.Resource_Name) row,A.*,B.Resource_ContentLength from ResourceToResourceFolder A
INNER JOIN Resource B ON A.Resource_Id=B.Resource_Id where 1=1 "
+ strWhere + " ) t where row between " + ((PageIndex - 1) * PageSize + 1) + " and " + (PageIndex * PageSize) + " ";
dtRes = Rc.Common.DBUtility.DbHelperSQL.Query(strSql).Tables[0];
int rCount = Convert.ToInt32(Rc.Common.DBUtility.DbHelperSQL.GetSingle(strSqlCount).ToString());
int inum = 0;
string operateStr = string.Empty;
for (int i = 0; i < dtRes.Rows.Count; i++)
{
Rc.Interface.BookAttrModel bkAttrModel = GetBookAttrValue(dtRes.Rows[i]["Book_ID"].ToString());
inum++;
string docName = dtRes.Rows[i]["File_Name"].ToString().ReplaceForFilter();
//docName = pfunction.GetDocFileName(docName);
string resUrl = "Upload/Resource/" + dtRes.Rows[i]["Resource_Url"].ToString().Replace("\\", "/");
if (!string.IsNullOrEmpty(resUrl) && resUrl.IndexOf(".") > 0)
{
resUrl = resUrl.Substring(0, resUrl.LastIndexOf(".")) + ".htm";
}
if (dtRes.Rows[i]["Resource_Class"].ToString() == Resource_ClassConst.自有资源)
{
}
listReturn.Add(new
{
inum = (i + 1),
docId = dtRes.Rows[i]["ResourceToResourceFolder_Id"].ToString(),
docName = docName,
docType = dtRes.Rows[i]["File_Suffix"].ToString(),
// docTypeAll = dtRes.Rows[i]["File_Suffix"].ToString(),
docSize = pfunction.ConvertDocSizeUnit(dtRes.Rows[i]["Resource_ContentLength"].ToString()),
docUrl = pfunction.GetResourceHost("TeachingPlanViewWebSiteUrl") + resUrl,
docTime = pfunction.ConvertToLongDateTime(dtRes.Rows[i]["CreateTime"].ToString()),
IsDownload = bkAttrModel.IsSave,
Resource_Class = dtRes.Rows[i]["Resource_Class"].ToString() == Resource_ClassConst.自有资源 ? true : false,
IsShare = dtRes.Rows[i]["Resource_shared"].ToString()
//Opearate = operateStr
});
}
#endregion
if (inum > 0)
{
return(JsonConvert.SerializeObject(new
{
err = "null",
PageIndex = PageIndex,
PageSize = PageSize,
TotalCount = rCount,
list = listReturn
}));
}
else
{
return(JsonConvert.SerializeObject(new
{
err = "暂无数据"
}));
}
}
catch (Exception)
{
return(JsonConvert.SerializeObject(new
{
err = "error"//ex.Message.ToString()
}));
}
}