public ActionResult DelAdditionalData(int id, int page)
{
try
{
using (DataWallContext db = new DataWallContext())
{
SysAdditionalData sysAdditionalData = new SysAdditionalData()
{
ID = id,
DelState = 1,
EditTime = DateTime.Now
};
db.Entry(sysAdditionalData).State = EntityState.Modified;
//不更新的字段
db.Entry(sysAdditionalData).Property(x => x.Type).IsModified = false;
db.Entry(sysAdditionalData).Property(x => x.PeopleNum).IsModified = false;
db.Entry(sysAdditionalData).Property(x => x.BookNum).IsModified = false;
db.Entry(sysAdditionalData).Property(x => x.StillPeopleNum).IsModified = false;
db.Entry(sysAdditionalData).Property(x => x.StillBookNum).IsModified = false;
db.Entry(sysAdditionalData).Property(x => x.DataDatetime).IsModified = false;
db.Entry(sysAdditionalData).Property(x => x.SysLibraryId).IsModified = false;
db.Entry(sysAdditionalData).Property(x => x.CrateTime).IsModified = false;
db.Entry(sysAdditionalData).Property(x => x.IsEnable).IsModified = false;
db.SaveChanges();
int npage = 0;
int Count = db.SysAdditionalDatas.Where(u => u.DelState == 0).Count();
double MaxPage = Convert.ToDouble(Convert.ToDouble(Count + 10) / Convert.ToDouble(10));
if (MaxPage > page)
{
npage = page;
}
else
{
if (Count <= 10)
{
npage = 1;
}
else
{
npage = page - 1;
}
}
Lg.AddLog("删除额外数据", "Other", 3, GetUserName());
return(Json(new { code = "200", page = npage, msg = "删除成功!" }));
}
}
catch (Exception ex)
{
LogHelper.ErrorLog("额外数据删除失败:" + ex.Message);
return(Json(new { code = "201", msg = "删除失败，请重试或联/系管理员!" }));
}
}
/// <summary>
/// 额外数据修改页
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult AdditionalDataEdit(int id)
{
using (DataWallContext db = new DataWallContext())
{
//当前用户可管理场馆
List <SysLibrary> libList = GetLibraryList();
ViewData["datalist"] = libList;
SysAdditionalData sysAdditionalData = db.SysAdditionalDatas.Find(id);
return(View(sysAdditionalData));
}
}
public ActionResult AdditionalDataEditEnable(int id, int enable)
{
try
{
using (DataWallContext db = new DataWallContext())
{
SysAdditionalData sysAdditionalData = new SysAdditionalData()
{
ID = id,
IsEnable = enable,
EditTime = DateTime.Now
};
db.Entry(sysAdditionalData).State = EntityState.Modified;
//不更新的字段
db.Entry(sysAdditionalData).Property(x => x.Type).IsModified = false;
db.Entry(sysAdditionalData).Property(x => x.PeopleNum).IsModified = false;
db.Entry(sysAdditionalData).Property(x => x.BookNum).IsModified = false;
db.Entry(sysAdditionalData).Property(x => x.StillPeopleNum).IsModified = false;
db.Entry(sysAdditionalData).Property(x => x.StillBookNum).IsModified = false;
db.Entry(sysAdditionalData).Property(x => x.DataDatetime).IsModified = false;
db.Entry(sysAdditionalData).Property(x => x.SysLibraryId).IsModified = false;
db.Entry(sysAdditionalData).Property(x => x.CrateTime).IsModified = false;
db.Entry(sysAdditionalData).Property(x => x.DelState).IsModified = false;
db.SaveChanges();
Lg.AddLog("修改额外数据状态", "Other", 2, GetUserName());
return(Json(new { code = "200", msg = "修改成功!" }));
}
}
catch (Exception ex)
{
LogHelper.ErrorLog("额外数据状态修改失败:" + ex.Message);
return(Json(new { code = "201", msg = "修改失败，请重试或联/系管理员!" }));
}
}
/// <summary>
/// 读取sheet 内的数据进入实体
/// </summary>
/// <param name="worksheet"></param>
/// <returns></returns>
public bool GetSheetValues(string filepath)
{
FileInfo file = new FileInfo(filepath);
if (file != null)
{
using (ExcelPackage package = new ExcelPackage(file))
{
ExcelWorksheet worksheet = package.Workbook.Worksheets[0];
//获取表格的列数和行数
int rowCount = worksheet.Dimension.Rows;
int ColCount = worksheet.Dimension.Columns;
var sysAdditionalDatas = new List <SysAdditionalData>();
for (int row = 1; row <= rowCount; row++)
{
SysAdditionalData sysAdditionalData = new SysAdditionalData();
sysAdditionalData.SysLibraryId = int.Parse(worksheet.Cells[row, 1].Value.ToString());
sysAdditionalDatas.Add(sysAdditionalData);
}
return(true);
}
}
return(false);
}
public ActionResult DelAdditionalDataAll(string idList, int page)
{
try
{
using (DataWallContext db = new DataWallContext())
{
//获取待删除id集合
string[] sArray = idList.Split(',');
int[] IdList = new int[sArray.Length];
for (int i = 0; i < sArray.Length; i++)
{
IdList[i] = Int32.Parse(sArray[i]);
}
for (int i = 0; i < IdList.Length; i++)
{
int id = IdList[i];
SysAdditionalData sysAdditionalData = new SysAdditionalData()
{
ID = id,
DelState = 1,
EditTime = DateTime.Now
};
db.Entry(sysAdditionalData).State = EntityState.Modified;
//不更新的字段
db.Entry(sysAdditionalData).Property(x => x.Type).IsModified = false;
db.Entry(sysAdditionalData).Property(x => x.PeopleNum).IsModified = false;
db.Entry(sysAdditionalData).Property(x => x.BookNum).IsModified = false;
db.Entry(sysAdditionalData).Property(x => x.StillPeopleNum).IsModified = false;
db.Entry(sysAdditionalData).Property(x => x.StillBookNum).IsModified = false;
db.Entry(sysAdditionalData).Property(x => x.DataDatetime).IsModified = false;
db.Entry(sysAdditionalData).Property(x => x.SysLibraryId).IsModified = false;
db.Entry(sysAdditionalData).Property(x => x.CrateTime).IsModified = false;
db.Entry(sysAdditionalData).Property(x => x.IsEnable).IsModified = false;
db.SaveChanges();
}
int npage = 0;
int Count = db.SysAdditionalDatas.Where(u => u.DelState == 0).AsNoTracking().Count();
double MaxPage = Convert.ToDouble(Convert.ToDouble(Count + 10) / Convert.ToDouble(10));
if (MaxPage > page)
{
npage = page;
}
else
{
if (Count <= 10)
{
npage = 1;
}
else
{
if ((Count % 10) <= page)
{
npage = page - 1;
}
}
}
Lg.AddLog("删除额外数据", "Other", 3, GetUserName());
return(Json(new { code = "200", page = npage, msg = "删除成功!" }));
}
}
catch (Exception ex)
{
LogHelper.ErrorLog("额外数据删除失败:" + ex.Message);
return(Json(new { code = "201", msg = "删除失败，请重试或联/系管理员!" }));
}
}
public ActionResult UploadExcel(int Type)
{
int location = 0;
try
{
var file = Request.Files[0];
var filecombin = file.FileName.Split('.');
if (file == null || String.IsNullOrEmpty(file.FileName) || file.ContentLength == 0 || filecombin.Length < 2)
{
return(Json(new
{
code = "201",
msg = "上传出错请检查文件名或文件内容"
}));
}
using (ExcelPackage package = new ExcelPackage(file.InputStream))
{
int count = package.Workbook.Worksheets.Count;
ExcelWorksheet worksheet = package.Workbook.Worksheets[1];
//获取表格的列数和行数
int rowCount = worksheet.Dimension.Rows;
int ColCount = worksheet.Dimension.Columns;
var sysAdditionalDatas = new List <SysAdditionalData>();
//插入数据
using (DataWallContext db = new DataWallContext())
{
for (int row = 2; row <= rowCount; row++)
{
location = row;
int PeopleNum = 0;
int BookNum = 0;
int StillPeopleNum = 0;
int StillBookNum = 0;
DateTime DataDatetime = DateTime.Now;
switch (Type)
{
case 0:
PeopleNum = int.Parse(worksheet.Cells[row, 3].Value.ToString());
DataDatetime = DateTime.Parse(worksheet.Cells[row, 4].Value.ToString());
break;
case 1:
PeopleNum = int.Parse(worksheet.Cells[row, 3].Value.ToString());
BookNum = int.Parse(worksheet.Cells[row, 4].Value.ToString());
StillPeopleNum = int.Parse(worksheet.Cells[row, 5].Value.ToString());
StillBookNum = int.Parse(worksheet.Cells[row, 6].Value.ToString());
DataDatetime = DateTime.Parse(worksheet.Cells[row, 7].Value.ToString());
break;
}
SysAdditionalData sysAdditionalData = new SysAdditionalData()
{
PeopleNum = PeopleNum,
BookNum = BookNum,
StillPeopleNum = StillPeopleNum,
StillBookNum = StillBookNum,
DataDatetime = DataDatetime,
SysLibraryId = int.Parse(worksheet.Cells[row, 2].Value.ToString()),
CrateTime = DateTime.Now,
EditTime = DateTime.Now,
DelState = 0,
Type = Type
};
sysAdditionalDatas.Add(sysAdditionalData);
//数据检查
if (!CheckLibraryId(worksheet.Cells[row, 2].Value.ToString(), worksheet.Cells[row, 1].Value.ToString()))
{
return(Json(new
{
code = "201",
msg = "场馆不存在或您没有场馆" + worksheet.Cells[row, 1].Value.ToString() + "(ID:" + worksheet.Cells[row, 2].Value.ToString() + ")" + "的数据导入权限"
}));
}
//推送客流更新
string ToLibraryName = db.SysLibrarys.Find(sysAdditionalData.SysLibraryId).LibraryName;
int type = 3;
var msg = "客流数据更新";
MyHub.Show(ToLibraryName, JsonConvert.SerializeObject(new
{
msg = msg,
action = "CustData",
type = type
}));
}
sysAdditionalDatas.ForEach(s => db.SysAdditionalDatas.Add(s));
db.SaveChanges();
}
Lg.AddLog("导入额外数据", "Other", 1, GetUserName());
return(Json(new
{
code = "200",
msg = "导入成功"
}));
}
}
catch (Exception ex)
{
LogHelper.ErrorLog("数据导入失败:" + ex.Message);
return(Json(new
{
code = "201",
msg = "导入失败,请检查内容格式,错误行号:" + location
}));
}
}
public ActionResult AdditionalDataEdit(FormCollection AdditionalData)
{
try
{
using (DataWallContext db = new DataWallContext())
{
//当前用户可管理场馆
List <SysLibrary> libList = GetLibraryList();
if (libList.Count == 0)
{
return(Json(new { code = "202", msg = "当前用户未分配可管理场馆，请联系系统管理员！" }));
}
ViewData["datalist"] = libList;
//额外数据
if (AdditionalData["Library"] != null)
{
int BookNum = 0;
int StillPeopleNum = 0;
int StillBookNum = 0;
int LibraryId = int.Parse(AdditionalData["Library"]);
string ToLibraryName = db.SysLibrarys.Find(LibraryId).LibraryName;
if (AdditionalData["Type"] == "0")
{
BookNum = 0;
StillPeopleNum = 0;
StillPeopleNum = 0;
int type = 3;
var msg = "客流数据更新";
MyHub.Show(ToLibraryName, JsonConvert.SerializeObject(new
{
msg = msg,
action = "Other",
type = type
}));
}
else
{
BookNum = int.Parse(AdditionalData["BookNum"]);
StillPeopleNum = int.Parse(AdditionalData["StillPeopleNum"]);
StillBookNum = int.Parse(AdditionalData["StillBookNum"]);
int type = 4;
var msg = "借还数据更新";
MyHub.Show(ToLibraryName, JsonConvert.SerializeObject(new
{
msg = msg,
action = "Other",
type = type
}));
}
SysAdditionalData sysAdditionalData = new SysAdditionalData()
{
ID = int.Parse(AdditionalData["ID"]),
PeopleNum = int.Parse(AdditionalData["PeopleNum"]),
BookNum = BookNum,
StillPeopleNum = StillPeopleNum,
StillBookNum = StillBookNum,
DataDatetime = DateTime.Parse(AdditionalData["DataDatetime"]),
SysLibraryId = int.Parse(AdditionalData["Library"]),
EditTime = DateTime.Now
};
db.Entry(sysAdditionalData).State = EntityState.Modified;
//不更新的字段
db.Entry(sysAdditionalData).Property(x => x.Type).IsModified = false;
db.Entry(sysAdditionalData).Property(x => x.CrateTime).IsModified = false;
db.Entry(sysAdditionalData).Property(x => x.IsEnable).IsModified = false;
db.Entry(sysAdditionalData).Property(x => x.DelState).IsModified = false;
db.SaveChanges();
Lg.AddLog("修改额外数据", "Other", 2, GetUserName());
return(Json(new { code = "200", msg = "修改成功!" }));
}
else
{
return(Json(new { code = "202", msg = "请选择内容所属场馆!" }));
}
}
}
catch (Exception ex)
{
LogHelper.ErrorLog("额外数据修改失败:" + ex.Message);
return(Json(new { code = "201", msg = "修改失败，请重试或联系管理员!" }));
}
}
