/// <summary>
/// 使用非芮卡家园APP扫码后打开该页下载APP
/// </summary>
///<param name="typestr">1</param>
/// <param name="codestr">二维码字符串</param>
/// <returns></returns>
public ActionResult App(string typestr, string codestr)
{
string showMsg = ""; //提示信息
int typeId = 0; //类型；1学一学课件注册
bool typeIsInt = int.TryParse(typestr, out typeId);
//-----------------------
if (typeId == 1)
{
#region 判断并开通学一学电子书
using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities())//数据库操作
{
Sys_BookStudy_QRCode mySys_BookStudy_QRCode = new Sys_BookStudy_QRCode();
mySys_BookStudy_QRCode = myOperating.Sys_BookStudy_QRCode.FirstOrDefault(p => p.QRCode == codestr);
if (mySys_BookStudy_QRCode != null)
{
long myBookId = mySys_BookStudy_QRCode.BookStudyID;
if (mySys_BookStudy_QRCode.Used)
{//注册码已经使用过
showMsg = "该二维码已经使用过，不能再次使用，请核对准确。";
}
else
{
#region 要开通那本图书
Child_Book_Study myChild_Book_Study = new Child_Book_Study();
myChild_Book_Study = myOperating.Child_Book_Study.FirstOrDefault(p => p.BookID == myBookId);
if (myChild_Book_Study != null)
{
showMsg = "要开通：《" + myChild_Book_Study.BookName + "》点读";
if (!String.IsNullOrWhiteSpace(myChild_Book_Study.BookImage))
{
ViewBag.CoverImage = StaticVarClass.BookStudyResourceUrl + myChild_Book_Study.BookImage;
}
}
else
{
showMsg = "该电子书不存在，请核实您的二维码。";
}
#endregion
}
}
else
{
showMsg = "该编码不存在，请核实您的二维码。";
}
}
#endregion
}
else
{
showMsg = "二维码错误。";
}
ViewBag.Message = showMsg;
//========================
return(View());
}
public ActionResult ItemList(int currentpage = 1, int ClassId = 0, long del = 0)
{
#region 翻页定义
ViewBag.CurrentPage = 0; //当前页
ViewBag.PPage = 0; //上一页
ViewBag.NPage = 0; //下一页
ViewBag.PageCount = 0; //总页数
ViewBag.RecordCount = 0; //记录总数
ViewBag.IsFirstPage = ""; //第一条记录，禁用首页和上一页
ViewBag.IsEndPage = ""; //最后条记录，禁用首页和下一页
#endregion
//
ViewBag.Headline = "图书管理";//栏目主题
//
ViewBag.DataList = null;
ViewBag.RecordItem = null;
ViewBag.Operate = "add"; //add添加；edit编辑取出数据；editsave编辑保存
//
StatusData myStatusData = new StatusData(); //返回状态
//
using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities()) //数据库操作
{
#region 除
if (del > 0)
{
Child_Book_Study myDelRecord = myOperating.Child_Book_Study.FirstOrDefault(p => p.BookID == del);
if (myDelRecord != null)
{
myOperating.Child_Book_Study.Remove(myDelRecord);
myOperating.SaveChanges();
}
}
#endregion
//
#region 翻页属性
int recordCount = 0;
int pageCount = 0;
string orderbyfiled = "OrderBy";
//
//当前页
int sqlCurrentpage = currentpage;
if (sqlCurrentpage < 1)
{
sqlCurrentpage = 1;
}
//页大小
int sqlPagesize = 10;
#endregion
//
#region 取出内容
IQueryable <Child_Book_Study> myIQueryable = null;
if (ClassId > 0)
{
myIQueryable = myOperating.Child_Book_Study.Where(p => p.BookClassID == ClassId);
}
else
{
myIQueryable = myOperating.Child_Book_Study;
}
//
if (myIQueryable != null)
{
List <Child_Book_Study> BookTable = QueryableExtensions.OrderBy(myIQueryable, orderbyfiled, out recordCount, out pageCount, ref sqlCurrentpage, sqlPagesize, true).ToList();
//
ViewBag.DataList = BookTable;
#region 页数取值
ViewBag.CurrentPage = sqlCurrentpage;
ViewBag.PageCount = pageCount;
ViewBag.RecordCount = recordCount;
if (sqlCurrentpage > 1)
{
ViewBag.PPage = sqlCurrentpage - 1;
}
else
{
ViewBag.IsFirstPage = "disabled";
ViewBag.PPage = 1;
}
if (sqlCurrentpage < pageCount)
{
ViewBag.NPage = sqlCurrentpage + 1;
}
else
{
ViewBag.NPage = sqlCurrentpage;
ViewBag.IsEndPage = "disabled";
}
#endregion
}
#endregion
//
ViewBag.ClassId = ClassId;//当前类别
//
List <Child_Book_Study_Class> ClassTable = myOperating.Child_Book_Study_Class.Where(p => p.Status == 200).OrderByDescending(p => p.OrderBy).ToList();
ViewBag.DataListClass = ClassTable;
}
return(View());
}
//
#region 内容添加-编辑
public ActionResult ItemAdd(BookStudyModel model, string ReturnUrl, Nullable <long> myid = 0, Nullable <int> ClassId = 0)
{
#region 获取来路路径
if (System.Web.HttpContext.Current.Request.UrlReferrer != null)
{
ViewBag.ReturnUrl = System.Web.HttpContext.Current.Request.UrlReferrer.PathAndQuery;
}
#endregion
ViewBag.Headline = "图书添加"; //栏目主题
ViewBag.ButtonValue = "添加"; //按钮名称
//
using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities()) //数据库操作
{
if ((myid > 0) && (model.Operate == null))
{
long mySelfId = 0;
long.TryParse(myid.ToString(), out mySelfId);
ViewBag.Headline = "图书编辑";
ViewBag.ButtonValue = "修改";
model.Operate = "edit";
//
#region 取出数据
Child_Book_Study editRecord = myOperating.Child_Book_Study.FirstOrDefault(p => p.BookID == mySelfId);
if (editRecord != null)
{
ClassId = editRecord.BookClassID;
model.BookID = editRecord.BookID;
model.BookClassID = editRecord.BookClassID;
model.BookName = editRecord.BookName;
model.BookOnlineUrl = editRecord.BookOnlineUrl;
model.BookDownLoadZip = editRecord.BookDownLoadZip;
model.BookZipName = editRecord.BookZipName;
model.OrderBy = editRecord.OrderBy;
}
#endregion
}
else if (model.Operate == "add")
{
#region 保存添加
if (ModelState.IsValid)
{
Child_Book_Study addRecord = new Child_Book_Study();
addRecord.BookClassID = model.BookClassID;
addRecord.BookName = model.BookName;
addRecord.BookOnlineUrl = model.BookOnlineUrl;
addRecord.BookDownLoadZip = model.BookDownLoadZip;
addRecord.BookZipName = model.BookZipName;
addRecord.OrderBy = model.OrderBy;
addRecord.AddDate = DateTime.Now;
addRecord.PraiceCount = 0;
addRecord.ReadCount = 0;
addRecord.BookStatus = 200;
//
myOperating.Child_Book_Study.Add(addRecord);
myOperating.SaveChanges();
//
return(RedirectToLocal(ReturnUrl));
}
else
{
ModelState.AddModelError("", "输入错误");
}
#endregion
}
else if (model.Operate == "edit")
{
//
#region 保存编辑
if (ModelState.IsValid)
{
Child_Book_Study editSaveRecord = myOperating.Child_Book_Study.FirstOrDefault(p => p.BookID == model.BookID);
if (editSaveRecord != null)
{
editSaveRecord.BookClassID = model.BookClassID;
editSaveRecord.BookName = model.BookName;
editSaveRecord.BookOnlineUrl = model.BookOnlineUrl;
editSaveRecord.BookDownLoadZip = model.BookDownLoadZip;
editSaveRecord.BookZipName = model.BookZipName;
editSaveRecord.OrderBy = model.OrderBy;
//
myOperating.SaveChanges();
//
return(RedirectToLocal(ReturnUrl));
}
}
else
{
ModelState.AddModelError("", "输入错误");
}
#endregion
}
else
{ //初次加载-添加
model.BookClassID = ClassId; //类别编号
model.Operate = "add";
#region 默认值
try
{
if (ClassId != 0)
{
model.OrderBy = myOperating.Child_Book_Study.Where(p => p.BookClassID == ClassId).Max(p => p.OrderBy) + 1;
}
else
{
model.OrderBy = myOperating.Child_Book_Study.Max(p => p.OrderBy) + 1;
}
}
catch
{
model.OrderBy = 0;
}
if (model.OrderBy == null)
{
model.OrderBy = 1;
}
#endregion
}
#region 类别
List <Child_Book_Study_Class> ClassTable = myOperating.Child_Book_Study_Class.Where(p => p.Status == 200).OrderByDescending(p => p.OrderBy).ToList();
ViewBag.DataListClass = ClassTable;
#endregion
}
//
return(View(model));
}
public ActionResult ItemList(int currentpage = 1, string del = "", long bookid = 0, int searchBatchNum = 0)
{
ViewBag.BookID = 0;//要生成那本书的二维码
//
#region 翻页定义
ViewBag.CurrentPage = 0; //当前页
ViewBag.PPage = 0; //上一页
ViewBag.NPage = 0; //下一页
ViewBag.PageCount = 0; //总页数
ViewBag.RecordCount = 0; //记录总数
ViewBag.IsFirstPage = ""; //第一条记录，禁用首页和上一页
ViewBag.IsEndPage = ""; //最后条记录，禁用首页和下一页
#endregion
//
ViewBag.Headline = "二维码管理";//栏目主题
//
ViewBag.DataList = null;
ViewBag.RecordItem = null;
//
StatusData myStatusData = new StatusData(); //返回状态
//
using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities()) //数据库操作
{
#region 除
if (!String.IsNullOrWhiteSpace(del))
{
Sys_BookStudy_QRCode myDelRecord = myOperating.Sys_BookStudy_QRCode.FirstOrDefault(p => p.QRCode == del);
if (myDelRecord != null)
{
myOperating.Sys_BookStudy_QRCode.Remove(myDelRecord);
myOperating.SaveChanges();
}
}
#endregion
//
#region 翻页属性
int recordCount = 0;
int pageCount = 0;
string orderbyfiled = "AddDate";
//
//当前页
int sqlCurrentpage = currentpage;
if (sqlCurrentpage < 1)
{
sqlCurrentpage = 1;
}
//页大小
int sqlPagesize = 10;
#endregion
//
#region 取出内容
IQueryable <Sys_BookStudy_QRCode> myIQueryable = null;
if (bookid > 0)
{
if (searchBatchNum > 0)
{
ViewBag.BatchNum = searchBatchNum;
myIQueryable = myOperating.Sys_BookStudy_QRCode.Where(p => p.BookStudyID == bookid && p.BatchNum == searchBatchNum);
}
else
{
myIQueryable = myOperating.Sys_BookStudy_QRCode.Where(p => p.BookStudyID == bookid);
}
}
else
{
if (searchBatchNum > 0)
{
ViewBag.BatchNum = searchBatchNum;
myIQueryable = myOperating.Sys_BookStudy_QRCode.Where(p => p.BatchNum == searchBatchNum);
}
else
{
myIQueryable = myOperating.Sys_BookStudy_QRCode;
}
}
//
if (myIQueryable != null)
{
List <Sys_BookStudy_QRCode> BookTable = QueryableExtensions.OrderBy(myIQueryable, orderbyfiled, out recordCount, out pageCount, ref sqlCurrentpage, sqlPagesize, true).ToList();
//
ViewBag.DataList = BookTable;
#region 页数取值
ViewBag.CurrentPage = sqlCurrentpage;
ViewBag.PageCount = pageCount;
ViewBag.RecordCount = recordCount;
if (sqlCurrentpage > 1)
{
ViewBag.PPage = sqlCurrentpage - 1;
}
else
{
ViewBag.IsFirstPage = "disabled";
ViewBag.PPage = 1;
}
if (sqlCurrentpage < pageCount)
{
ViewBag.NPage = sqlCurrentpage + 1;
}
else
{
ViewBag.NPage = sqlCurrentpage;
ViewBag.IsEndPage = "disabled";
}
#endregion
}
#endregion
//
if (bookid > 0)
{
#region 要开通那本图书
Child_Book_Study myChild_Book_Study = new Child_Book_Study();
myChild_Book_Study = myOperating.Child_Book_Study.FirstOrDefault(p => p.BookID == bookid);
if (myChild_Book_Study != null)
{
ViewBag.BookName = myChild_Book_Study.BookName;
ViewBag.BookID = myChild_Book_Study.BookID;
}
#endregion
}
}
return(View());
}
//
#region 根据批次和书号导出excel
public void ExportExcel(int batchNum, long bookid)
{
//
int rowNum = 0;
string saveFileName = batchNum.ToString() + "_" + bookid.ToString();
string xlsSheetName = "";
///
using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities())//数据库操作
{
#region 要开通那本图书
Child_Book_Study myChild_Book_Study = new Child_Book_Study();
myChild_Book_Study = myOperating.Child_Book_Study.FirstOrDefault(p => p.BookID == bookid);
if (myChild_Book_Study != null)
{
xlsSheetName = myChild_Book_Study.BookName;
saveFileName = myChild_Book_Study.BookName;
}
#endregion
//
if (!String.IsNullOrWhiteSpace(saveFileName))
{
NPOI.HSSF.UserModel.HSSFWorkbook book = new NPOI.HSSF.UserModel.HSSFWorkbook();
NPOI.SS.UserModel.ISheet sheet = book.CreateSheet(xlsSheetName);
// 添加数据
IQueryable <Sys_BookStudy_QRCode> myDataTable = myOperating.Sys_BookStudy_QRCode.Where(p => p.BatchNum == batchNum && p.BookStudyID == bookid);
NPOI.SS.UserModel.IRow row = null;
foreach (Sys_BookStudy_QRCode item in myDataTable)
{
row = sheet.CreateRow(rowNum);
NPOI.SS.UserModel.ICell cell = row.CreateCell(0);
cell.SetCellType(NPOI.SS.UserModel.CellType.String);
cell.SetCellValue(StaticVarClass.QRCodeUrl + "1/" + item.QRCode);
sheet.SetColumnWidth(0, 20000);
rowNum++;
}
#region 导出文件
if (rowNum > 0)
{
// 写入
System.IO.MemoryStream ms = new System.IO.MemoryStream();
book.Write(ms);
book = null;
//
int updateCount = myOperating.Sys_BookStudy_QRCode.Where(p => p.BatchNum == batchNum && p.BookStudyID == bookid && p.PrintStatus == false).Update(q => new Sys_BookStudy_QRCode()
{
PrintStatus = true
});
if (updateCount > 0)
{
EFCachClear.ClearTable("Sys_BookStudy_QRCode");
}
//
Response.ClearHeaders();
Response.Clear();
Response.Expires = 0;
Response.Buffer = true;
Response.AddHeader("Accept-Language", "zh-tw");
//
saveFileName = saveFileName + "_" + batchNum.ToString() + "_" + rowNum + ".xls";
//
Response.AddHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(saveFileName, System.Text.Encoding.UTF8));
Response.ContentType = "application/octet-stream;charset=gbk";
Response.BinaryWrite(ms.ToArray());
ms.Close();
ms.Dispose();
Response.End();
}
else
{
Response.AddHeader("Accept-Language", "zh-tw");
Response.Write("没有任何数据导出，请选择图书和批次。");
Response.End();
}
#endregion
}
}
}
public JsonResult BookRegList()
{
string mobilePhone = ""; //
//
StatusData myStatusData = new StatusData(); //返回状态
//
#region 检查授权
AuthCodeInstance myAuthCodeInstance = new AuthCodeInstance();
AuthCodeClass myAuthCodeClass = new AuthCodeClass();
bool checkAuthCodeBool = myAuthCodeClass.checkAuthCode(out myAuthCodeInstance);
if (checkAuthCodeBool)
{
mobilePhone = myAuthCodeInstance.mobilePhone;
}
#endregion
if (!String.IsNullOrWhiteSpace(mobilePhone))
{
using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities())//数据库操作
{
List <StudyBookItem> StudyBookList = new List <StudyBookItem>();
//
List <User_RegBook_List> myRegBookList = myOperating.User_RegBook_List.Where(p => p.MobilePhone == mobilePhone).ToList();
if (myRegBookList != null)
{
//
#region 取出所有类别
List <Child_Book_Study_Class> myChild_Book_Study_Class = new List <Child_Book_Study_Class>();
myChild_Book_Study_Class = myOperating.Child_Book_Study_Class.ToList();
#endregion
//
int bookCount = myRegBookList.Count();
myStatusData.dataRecordCount = bookCount;
for (int i = 0; i < bookCount; i++)
{
long myLong = myRegBookList[i].BookStudyID;
Child_Book_Study myChildBookStudy = myOperating.Child_Book_Study.FirstOrDefault(p => p.BookID == myLong && p.BookStatus == 200);
if (myChildBookStudy != null)
{
StudyBookItem myStudyBookItem = new StudyBookItem();
myStudyBookItem.BookID = myLong;
myStudyBookItem.BookName = myChildBookStudy.BookName;
myStudyBookItem.BookOnlineUrl = StaticVarClass.BookStudyResourceUrl + myChildBookStudy.BookOnlineUrl;
myStudyBookItem.BookDownLoadZip = StaticVarClass.BookStudyResourceUrl + myChildBookStudy.BookDownLoadZip;
myStudyBookItem.BookZipName = myChildBookStudy.BookZipName;
myStudyBookItem.IsReg = true;
//
#region 取出该类别图片的大小
Nullable <int> myClassId = myChildBookStudy.BookClassID;
Child_Book_Study_Class Child_Book_Study_ClassItem = new Child_Book_Study_Class();
Child_Book_Study_ClassItem = myChild_Book_Study_Class.FirstOrDefault(p => p.BookClassID == myClassId);
if (Child_Book_Study_ClassItem != null)
{
myStudyBookItem.ImgWidth = Child_Book_Study_ClassItem.ImgWidth;
myStudyBookItem.ImgHeight = Child_Book_Study_ClassItem.ImgHeight;
}
#endregion
//
StudyBookList.Add(myStudyBookItem);
}
}
myStatusData.dataTable = StudyBookList;
}
}
}
myStatusData.operateStatus = 200;
return(Json(myStatusData));
}
