/// <summary>
/// 获取资源属性（是否可打印，存盘）
/// </summary>
/// <param name="ResourceFolder_Id"></param>
/// <returns></returns>
public static Rc.Cloud.Web.AuthApi.index.BookAttrModel GetBookAttrValue(string ResourceFolder_Id)
{
Rc.Cloud.Web.AuthApi.index.BookAttrModel model = new Rc.Cloud.Web.AuthApi.index.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 IType, int PageIndex, int PageSize)
{
Rc.Model.Resources.Model_F_User FloginUser = Rc.Common.StrUtility.clsUtility.IsFPageFlag() as Rc.Model.Resources.Model_F_User;
try
{
ResourceFolder_Id = ResourceFolder_Id.Filter();
DocName = DocName.Filter();
IType = IType.Filter();
int pageSize = 10;
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 = " Resource_Type='" + Resource_TypeConst.class类型微课件 + "' ";
if (!string.IsNullOrEmpty(DocName))
{
strWhere = " and File_Name like '%" + DocName.Filter() + "%' ";
}
strWhere += string.Format(" and Resource_Class = '{0}'", Resource_ClassConst.云资源);
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 (IType == "1")
{
strWhere += " and Subject='" + ResourceFolder_Id + "' ";
}
else
{
strWhere += " and ResourceFolder_Id='" + ResourceFolder_Id + "' ";
}
strSqlCount = @"select count(*) from ResourceToResourceFolder A
INNER JOIN Resource B ON A.Resource_Id=B.Resource_Id where " + 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 "
+ 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;
for (int i = 0; i < dtRes.Rows.Count; i++)
{
Rc.Cloud.Web.AuthApi.index.BookAttrModel bkAttrModel = GetBookAttrValue(dtRes.Rows[i]["Book_ID"].ToString());
inum++;
string docName = dtRes.Rows[i]["File_Name"].ToString();
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";
}
listReturn.Add(new
{
inum = (i + 1),
docId = dtRes.Rows[i]["ResourceToResourceFolder_Id"].ToString(),
docName = docName,
docType = 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
});
}
#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()
}));
}
}
public static string GetCloudResource(string Resource_Type, int PageSize, int PageIndex)
{
Rc.Model.Resources.Model_F_User FloginUser = Rc.Common.StrUtility.clsUtility.IsFPageFlag() as Rc.Model.Resources.Model_F_User;
try
{
Resource_Type = Resource_Type.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 = " 1=1 ";
if (!string.IsNullOrEmpty(Resource_Type) && Resource_Type != "1")
{
strWhere += string.Format(" and rtr.Resource_Type = '{0}'", Resource_Type.Filter());
}
if (!string.IsNullOrEmpty(FloginUser.Subject) && FloginUser.Subject != "-1")
{
strWhere += " and rtr.Subject='" + FloginUser.Subject + "'";
}
strWhere += " and rs.ResourceToResourceFolder_Id in(select distinct (ResourceToResourceFolder_Id) from ResourceShare where ShareObjectId in (select distinct(SchoolId) from dbo.VW_UserOnClassGradeSchool where UserId='" + FloginUser.UserId + "' and SchoolId<>''))";
strSqlCount = @"select count(*) from(select rtr.ResourceFolder_Id,rtr.ResourceToResourceFolder_Id,rtr.Subject,rtr.Resource_Type,
rtr.Resource_Name,rtr.Resource_Url,rs.CreateTime,ISNULL(fu.TrueName,fu.UserName) TeacherName,r.Resource_ContentLength
,rtr.File_Suffix,rtr.Book_ID,rtr.File_Name from dbo.ResourceShare rs
left join ResourceToResourceFolder rtr on rtr.ResourceToResourceFolder_Id=rs.ResourceToResourceFolder_Id
left join ResourceFolder rf on rf.ResourceFolder_Id=rtr.ResourceFolder_Id
left join Resource r on r.Resource_Id=rtr.Resource_Id
left join F_User fu on fu.UserId=rs.CreateUserId where " + strWhere + " ) a ";
strSql = @"select * from (select ROW_NUMBER() over(ORDER BY A.Resource_Name) row,A.* from (select rtr.ResourceFolder_Id,rtr.ResourceToResourceFolder_Id,rtr.Subject,rtr.Resource_Type,
rtr.Resource_Name,rtr.Resource_Url,rs.CreateTime,ISNULL(fu.TrueName,fu.UserName) TeacherName,r.Resource_ContentLength
,rtr.File_Suffix,rtr.Book_ID,rtr.File_Name from dbo.ResourceShare rs
left join ResourceToResourceFolder rtr on rtr.ResourceToResourceFolder_Id=rs.ResourceToResourceFolder_Id
left join ResourceFolder rf on rf.ResourceFolder_Id=rtr.ResourceFolder_Id
left join Resource r on r.Resource_Id=rtr.Resource_Id
left join F_User fu on fu.UserId=rs.CreateUserId where "
+ strWhere + " ) A ) 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;
for (int i = 0; i < dtRes.Rows.Count; i++)
{
Rc.Cloud.Web.AuthApi.index.BookAttrModel bkAttrModel = GetBookAttrValue(dtRes.Rows[i]["Book_ID"].ToString());
inum++;
string docName = dtRes.Rows[i]["File_Name"].ToString();
//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";
}
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,
TeacherName = dtRes.Rows[i]["TeacherName"].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()
}));
}
}
