/// <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);
}
/// <summary>
/// 获取资源属性（是否可打印，存盘）
/// </summary>
/// <param name="ResourceFolder_Id"></param>
/// <returns></returns>
public BookAttrModel GetBookAttrValue(string ResourceFolder_Id)
{
BookAttrModel model = new BookAttrModel();
model.IsPrint = false;
model.IsSave = false;
try
{
List <Model_BookAttrbute> listModel = new BLL_BookAttrbute().GetModelListByCache(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 OperateResourceAuth(string AttrEnum, string ReId, string AttrValue)
{
string temp = "0";
try
{
Model_VSysUserRole loginUser = (Model_VSysUserRole)HttpContext.Current.Session["LoginUser"];
BLL_BookAttrbute bll = new BLL_BookAttrbute();
Model_BookAttrbute model = new Model_BookAttrbute();
List <Model_BookAttrbute> list = bll.GetModelList("ResourceFolder_Id='" + ReId + "' and AttrEnum='" + AttrEnum + "' ");
bool result = false;
if (list.Count != 0)
{
model = list[0];
model.AttrValue = AttrValue;
model.CreateTime = DateTime.Now;
result = bll.Update(model);
}
else
{
model.BookAttrId = Guid.NewGuid().ToString();
model.ResourceFolder_Id = ReId;
model.AttrEnum = AttrEnum;
model.AttrValue = AttrValue;
model.CreateUser = loginUser.SysUser_ID;
model.CreateTime = DateTime.Now;
result = bll.Add(model);
}
if (result)
{
temp = "1";
}
}
catch (Exception)
{
}
return(temp);
}
public static string GetCloudBooks(string DocName, string strResource_Type, string strResource_Class, string strGradeTerm, string strSubject, string strResource_Version, int PageIndex, int PageSize)
{
try
{
DocName = DocName.Filter();
PageIndex = Convert.ToInt32(PageIndex.ToString().Filter());
Model_VSysUserRole loginUser = (Model_VSysUserRole)HttpContext.Current.Session["LoginUser"];
#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 ResourceFolder_Name like '%" + DocName.Filter() + "%' ";
}
if (strResource_Class != "-1")
{
strWhere += " and Resource_Class = '" + strResource_Class.Filter() + "' ";
}
if (strResource_Type != "-1")
{
strWhere += " and Resource_Type = '" + strResource_Type.Filter() + "' ";
}
if (strGradeTerm != "-1")
{
strWhere += " and GradeTerm = '" + strGradeTerm.Filter() + "' ";
}
if (strSubject != "-1")
{
strWhere += " and Subject = '" + strSubject.Filter() + "' ";
}
if (strResource_Version != "-1")
{
strWhere += " and Resource_Version = '" + strResource_Version.Filter() + "' ";
}
//if (tp == "0") strWhere += " and ResourceFolder_Id='" + ResourceFolder_Id.Filter() + "' ";
strWhere += " AND A.ResourceFolder_Level=5 and bk.BookShelvesState='1' and bka.AuditState='1'";//管理员维护的书籍目录
strSqlCount = @"select count(*) from ResourceFolder A left JOIN Bookshelves bk on bk.ResourceFolder_Id=A.ResourceFolder_Id inner join BookAudit bka on bka.ResourceFolder_Id=A.ResourceFolder_Id where 1=1 " + strWhere + " ";
strSql = @"select * from (select ROW_NUMBER() over(ORDER BY A.CreateTime DESC) row,A.*
,bka.AuditState
,t1.D_Name as GradeTermName,t2.D_Name as SubjectName,t3.D_Name as Resource_VersionName,t4.D_Name as Resource_TypeName
from ResourceFolder A
left JOIN Bookshelves bk on bk.ResourceFolder_Id=A.ResourceFolder_Id
inner join BookAudit bka on bka.ResourceFolder_Id=A.ResourceFolder_Id
left join Common_Dict t1 on t1.Common_Dict_Id=A.GradeTerm
left join Common_Dict t2 on t2.Common_Dict_Id=A.Subject
left join Common_Dict t3 on t3.Common_Dict_Id=A.Resource_Version
left join Common_Dict t4 on t4.Common_Dict_Id=A.Resource_Type
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;
DataTable dtAttr = new BLL_BookAttrbute().GetList("").Tables[0];
for (int i = 0; i < dtRes.Rows.Count; i++)
{
inum++;
string docName = dtRes.Rows[i]["ResourceFolder_Name"].ToString().ReplaceForFilter();
docName = pfunction.GetDocFileName(docName);
listReturn.Add(new
{
inum = (i + 1),
docId = dtRes.Rows[i]["ResourceFolder_Id"].ToString(),
GradeTerm = dtRes.Rows[i]["GradeTermName"].ToString(),
Subject = dtRes.Rows[i]["SubjectName"].ToString(),
Resource_Version = dtRes.Rows[i]["Resource_VersionName"].ToString(),
Resource_Type = dtRes.Rows[i]["Resource_TypeName"].ToString(),
docName = docName,
docTime = pfunction.ConvertToLongDateTime(dtRes.Rows[i]["CreateTime"].ToString()),
IsPrint = GetBookAttr(dtAttr, BookAttrEnum.Print.ToString(), dtRes.Rows[i]["ResourceFolder_Id"].ToString()),
IsSave = GetBookAttr(dtAttr, BookAttrEnum.Save.ToString(), dtRes.Rows[i]["ResourceFolder_Id"].ToString()),
IsCopy = GetBookAttr(dtAttr, BookAttrEnum.Copy.ToString(), dtRes.Rows[i]["ResourceFolder_Id"].ToString())
});
}
#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()
}));
}
}
