public static Rc.Model.Resources.Model_F_User IsPageFlag(Page page) { Rc.Model.Resources.Model_F_User user = null; if (page.Session["FLoginUser"] != null) { user = (Rc.Model.Resources.Model_F_User)page.Session["FLoginUser"]; page.Session["FLoginUser"] = user; return(user); } ErrorDispose(page, 1, true); page.Response.End(); return(user); }
public static string RenewCustom(string Two_NewWayChecklist_Id) { try { string Two_WayChecklistToTeacher_Id = string.Empty; string Two_WayChecklist_Id = string.Empty; Rc.Model.Resources.Model_F_User loginUser = (Rc.Model.Resources.Model_F_User)HttpContext.Current.Session["FLoginUser"]; string sql = @"select * from [Two_WayChecklistToTeacher] where Two_NewWayChecklist_Id='" + Two_NewWayChecklist_Id.Filter() + "' and Teacher_Id='" + loginUser.UserId + "'"; DataTable dt = Rc.Common.DBUtility.DbHelperSQL.Query(sql).Tables[0]; if (dt.Rows.Count > 0) { Two_WayChecklistToTeacher_Id = dt.Rows[0]["Two_WayChecklistToTeacher_Id"].ToString(); Two_WayChecklist_Id = dt.Rows[0]["Two_WayChecklist_Id"].ToString(); #region 除老师自定义双向细目表数据 string DSql = string.Format(@"update Two_WayChecklistToTeacher set status='0' where Two_WayChecklistToTeacher_Id='{0}'; delete from Two_WayChecklistDetailToAttr where Two_WayChecklist_Id='{1}'; delete from Two_WayChecklistDetailToTestQuestions where Two_WayChecklist_Id='{1}'; delete from Two_WayChecklistDetail where Two_WayChecklist_Id='{1}'; delete from Two_WayChecklist where Two_WayChecklist_Id='{1}';" , Two_WayChecklistToTeacher_Id , Two_NewWayChecklist_Id); #endregion if (Rc.Common.DBUtility.DbHelperSQL.ExecuteSql(DSql) > 0) { return(Two_WayChecklist_Id); } else { return(""); } } else { return(""); } } catch (Exception ex) { return(""); } }
public static string GetResourceFolderListPage(int PageIndex, int PageSize) { try { StringBuilder strHtml = new StringBuilder(); Rc.Model.Resources.Model_F_User loginUser = Rc.Common.StrUtility.clsUtility.IsFPageFlag() as Rc.Model.Resources.Model_F_User; DataTable dtRes = new DataTable(); List <object> listReturn = new List <object>(); string strSql = string.Empty; string strSqlCount = string.Empty; strSqlCount = @"SELECT count(1) from ResourceFolder t left join Bookshelves t1 on t.ResourceFolder_ID=t1.ResourceFolder_ID where t.Resource_Type='" + Resource_TypeConst.testPaper类型文件 + "' and t.ResourceFolder_ID in(SELECT book_id from UserBuyResources where userid='" + loginUser.UserId + "') "; strSql = @"select * from (select ROW_NUMBER() over(ORDER BY t.CreateTime DESC) row,t1.BookImg_Url,t.*,t1.bookShelvesstate,t1.BookPrice,t1.Book_Name from ResourceFolder t left join Bookshelves t1 on t.ResourceFolder_ID=t1.ResourceFolder_ID where t.Resource_Type='" + Resource_TypeConst.testPaper类型文件 + "' and t.ResourceFolder_ID in(SELECT book_id from UserBuyResources where userid='" + loginUser.UserId + "') " + " ) z 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++) { inum++; listReturn.Add(new { inum = (i + 1), BookImg_Url = dtRes.Rows[i]["BookImg_Url"].ToString(), Book_Name = dtRes.Rows[i]["Book_Name"].ToString(), BookPrice = dtRes.Rows[i]["BookPrice"].ToString(), ResourceFolder_ID = dtRes.Rows[i]["ResourceFolder_ID"].ToString(), }); } 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 GetResourceFolderListPage(string ParticularYear, string GradeTerm, string Subject, string Resource_Version, string Province, string City, string Name, int PageIndex, int PageSize) { try { StringBuilder strHtml = new StringBuilder(); Rc.Model.Resources.Model_F_User loginUser = Rc.Common.StrUtility.clsUtility.IsFPageFlag() as Rc.Model.Resources.Model_F_User; DataTable dtRes = new DataTable(); List <object> listReturn = new List <object>(); string strSql = string.Empty; string strSqlCount = string.Empty; string strWhere = string.Empty; if (ParticularYear != "") { strWhere += " and ParticularYear = '" + ParticularYear.Filter() + "' "; //年份 } if (GradeTerm != "") { strWhere += " and GradeTerm = '" + GradeTerm.Filter() + "' "; //年级学期 } if (Subject != "") { strWhere += " and Subject = '" + Subject.Filter() + "' "; //学科 } if (Resource_Version != "") { strWhere += " and Resource_Version = '" + Resource_Version.Filter() + "' "; //教材版本 } if (Name != "") { strWhere += " and ResourceFolder_Name like '%" + Name.Filter() + "%' "; //名称 } string strWhereCount = strWhere; if (Province != "-1" && City != "-1")//选择省市 { strWhereCount = string.Format(" and t.ResourceFolder_Id in(select ResourceFolder_Id from BookArea where City_ID='{0}') ", City); strWhere += string.Format(" and ResourceFolder_Id in(select ResourceFolder_Id from BookArea where City_ID='{0}') ", City); } else if (Province != "-1" && City == "-1")//只选择省 { strWhereCount = string.Format(" and t.ResourceFolder_Id in(select ResourceFolder_Id from BookArea where Province_ID='{0}') ", Province); strWhere += string.Format(" and ResourceFolder_Id in(select ResourceFolder_Id from BookArea where Province_ID='{0}') ", Province); } strSqlCount = @"select count(1) from(SELECT DISTINCT t1.BookImg_Url ,t.*,t1.bookShelvesstate from ResourceFolder t left join Bookshelves t1 on t.ResourceFolder_ID=t1.ResourceFolder_ID left join UserBuyResources t2 on t.ResourceFolder_ID=t2.book_id where t.Resource_Type='" + Resource_TypeConst.testPaper类型文件 + "' and t1.BookShelvesState=1 " + strWhereCount + " ) a "; strSql = @"select * from (select ROW_NUMBER() over(ORDER BY CreateTime DESC) row,* from ( SELECT DISTINCT t1.BookImg_Url ,t.*,t1.bookShelvesstate,t1.BookPrice,t2.userid,t1.Book_Name from ResourceFolder t left join Bookshelves t1 on t.ResourceFolder_ID=t1.ResourceFolder_ID left join UserBuyResources t2 on t.ResourceFolder_ID=t2.book_id and t2.userid='" + loginUser.UserId + "' where t.Resource_Type='" + Resource_TypeConst.testPaper类型文件 + "' and t1.BookShelvesState=1 ) a where 1=1 " + strWhere + " ) z 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++) { #region 处理图片显示宽高 int imgHeight = 0; int imgWidth = 0; string imgFilePath = HttpContext.Current.Server.MapPath(dtRes.Rows[i]["BookImg_Url"].ToString()); if (System.IO.File.Exists(imgFilePath)) { System.Drawing.Image img = System.Drawing.Image.FromFile(imgFilePath); imgHeight = img.Height; imgWidth = img.Width; if (imgHeight / 218.0 > imgWidth / 160.0) { imgWidth = 0; if (imgHeight > 218) { imgHeight = 218; } } else { imgHeight = 0; if (imgWidth > 160) { imgWidth = 160; } } img.Dispose(); } #endregion inum++; listReturn.Add(new { inum = (i + 1), Book_Name = dtRes.Rows[i]["Book_Name"].ToString(), BookImg_Url = dtRes.Rows[i]["BookImg_Url"].ToString(), BookPrice = dtRes.Rows[i]["BookPrice"].ToString(), ResourceFolder_ID = dtRes.Rows[i]["ResourceFolder_ID"].ToString(), isGouMai = (dtRes.Rows[i]["userid"].ToString() != "" ? "1" : "0"), imgHeight = imgHeight, imgWidth = imgWidth }); } 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() })); } }