/// <summary>
/// 获取工作报告列表
/// </summary>
/// <param name="ntype"></param>
/// <param name="PageSize"></param>
/// <param name="PageIndex"></param>
/// <param name="totalCount"></param>
/// <returns></returns>
public List<Work_Note> GetDailyList(KSOAEnum.NoteType ntype, int PageSize, int PageIndex, out int totalCount)
{
string strtype = ntype.ToString();
var query = _db.Work_Note.Where(s => s.IsDelete == false && s.WType == strtype).Select(s => new Work_Note { ID = s.ID, WType = s.WType, WriterID = s.WriterID, WriterName = s.WriterName, WTitle = s.WTitle, WConetent = s.WConetent, WTaster = s.WTaster, IsRead = s.IsRead, AddTime = s.AddTime, IsDelete = s.IsDelete }).OrderBy(s => s.AddTime);
totalCount = query.Count();
var list = new List<Work_Note>();
if (PageIndex < 0 || PageSize < 0)
{
return null;
}
if (PageIndex == 1 && PageSize > totalCount)
{
list = query.ToList();
}
else if (PageIndex == 1 && PageSize > 0)
{
list = query.Take(PageSize).ToList();
}
else
{
list = query.Skip((PageIndex - 1) * PageSize).Take(PageSize).ToList();
}
return list;
}
/// <summary>
///获取作品分页列表
/// </summary>
/// <param name="ntype"></param>
/// <param name="PageSize"></param>
/// <param name="PageIndex"></param>
/// <param name="totalCount"></param>
/// <returns></returns>
public List<Bank_CommercialOpus> GetCommercialOpusList(KSOAEnum.OpusType ntype, int PageSize, int PageIndex, out int totalCount)
{
var query = _db.Bank_CommercialOpus.Join(_db.Bank_Opus, s => s.OpusID, Opus => Opus.ID, (s, Opus) => new { ID = s.ID, CompanyName = s.CompanyName, ChannelAddress = s.ChannelAddress, CpAddress = s.CpAddress, OpusID = s.OpusID, Oupsname = Opus.OpTitle, AddTime = s.AddTime, IsDelete = s.IsDelete }).Where(s => s.IsDelete == false).Select(s => new Bank_CommercialOpus { ID = s.ID, CompanyName = s.CompanyName, ChannelAddress = s.ChannelAddress, CpAddress = s.CpAddress, OpusID = s.OpusID, Oupsname = s.Oupsname, AddTime = s.AddTime, IsDelete = s.IsDelete }).OrderBy(s => s.AddTime);
totalCount = query.Count();
var list = new List<Bank_CommercialOpus>();
if (PageIndex < 0 || PageSize < 0)
{
return null;
}
if (PageIndex == 1 && PageSize > totalCount)
{
list = query.ToList();
}
else if (PageIndex == 1 && PageSize > 0)
{
list = query.Take(PageSize).ToList();
}
else
{
list = query.Skip((PageIndex - 1) * PageSize).Take(PageSize).ToList();
}
return list;
}
/// <summary>
/// 选取作品
/// </summary>
/// <param name="ntype"></param>
/// <param name="PageSize"></param>
/// <param name="PageIndex"></param>
/// <param name="totalCount"></param>
/// <returns></returns>
public List<Bank_CommercialOpus> GetCommercialOpusList(string keyword, KSOAEnum.OpusType ntype, int PageSize, int PageIndex, out int totalCount)
{
string strtype = ntype.ToString();
var query = _db.Bank_CommercialOpus.Where(s => s.IsDelete == false).Select(s => new Bank_CommercialOpus { ID = s.ID, CompanyName = s.CompanyName, ChannelAddress = s.ChannelAddress, CpAddress = s.CpAddress, OpusID = s.OpusID, AddTime = s.AddTime, IsDelete = s.IsDelete }).OrderBy(s => s.AddTime);
if (strtype != "A")
{
query = _db.Bank_CommercialOpus.Where(s => s.IsDelete == false).Select(s => new Bank_CommercialOpus { ID = s.ID, CompanyName = s.CompanyName, ChannelAddress = s.ChannelAddress, CpAddress = s.CpAddress, OpusID = s.OpusID, AddTime = s.AddTime, IsDelete = s.IsDelete }).OrderBy(s => s.AddTime);
}
totalCount = query.Count();
var list = new List<Bank_CommercialOpus>();
if (PageIndex < 0 || PageSize < 0)
{
return null;
}
if (PageIndex == 1 && PageSize > totalCount)
{
list = query.ToList();
}
else if (PageIndex == 1 && PageSize > 0)
{
list = query.Take(PageSize).ToList();
}
else
{
list = query.Skip((PageIndex - 1) * PageSize).Take(PageSize).ToList();
}
return list;
}
/// <summary>
///获取作品分页列表
/// </summary>
/// <param name="ntype"></param>
/// <param name="PageSize"></param>
/// <param name="PageIndex"></param>
/// <param name="totalCount"></param>
/// <returns></returns>
public List<Bank_Opus> GetOpusList(KSOAEnum.OpusType ntype, int PageSize, int PageIndex, out int totalCount)
{
string strtype = ntype.ToString();
var query = _db.Bank_Opus.Where(s => s.IsDelete == false).Select(s => new Bank_Opus { ID = s.ID, OpTitle = s.OpTitle, OpBeginTime = s.OpBeginTime, OpAuthor = s.OpAuthor, OpType = s.OpType, AddTime = s.AddTime, IsDelete = s.IsDelete }).OrderBy(s => s.AddTime);
if (strtype != "A")
{
query = _db.Bank_Opus.Where(s => s.IsDelete == false && s.OpType == strtype).Select(s => new Bank_Opus { ID = s.ID, OpTitle = s.OpTitle, OpBeginTime = s.OpBeginTime, OpAuthor = s.OpAuthor, OpType = s.OpType, AddTime = s.AddTime, IsDelete = s.IsDelete }).OrderBy(s => s.AddTime);
}
totalCount = query.Count();
var list = new List<Bank_Opus>();
if (PageIndex < 0 || PageSize < 0)
{
return null;
}
if (PageIndex == 1 && PageSize > totalCount)
{
list = query.ToList();
}
else if (PageIndex == 1 && PageSize > 0)
{
list = query.Take(PageSize).ToList();
}
else
{
list = query.Skip((PageIndex - 1) * PageSize).Take(PageSize).ToList();
}
return list;
}
/// <summary>
///获取原创组信息列表
/// </summary>
/// <param name="ntype"></param>
/// <param name="PageSize"></param>
/// <param name="PageIndex"></param>
/// <param name="totalCount"></param>
/// <returns></returns>
public List<Bank_OriginalGroup> GetOriginalGroupList(KSOAEnum.OpusType ntype, int PageSize, int PageIndex, out int totalCount)
{
var query = _db.Bank_OriginalGroup.Where(s => s.IsDelete == false).Select(s => new Bank_OriginalGroup { ID = s.ID, OpusCopyright = s.OpusCopyright, CreationInfo = s.CreationInfo, OpusName = s.OpusName, OpusAuthor = s.OpusAuthor, SalePrice = s.SalePrice, AccreditPlatform = s.AccreditPlatform, AccreditCompany = s.AccreditCompany, AccreditTime = s.AccreditTime, AccreditType = s.AccreditType, Awards = s.Awards, OpusMascot = s.OpusMascot, AddTime = s.AddTime, IsDelete = s.IsDelete }).OrderBy(s => s.AddTime);
totalCount = query.Count();
var list = new List<Bank_OriginalGroup>();
if (PageIndex < 0 || PageSize < 0)
{
return null;
}
if (PageIndex == 1 && PageSize > totalCount)
{
list = query.ToList();
}
else if (PageIndex == 1 && PageSize > 0)
{
list = query.Take(PageSize).ToList();
}
else
{
list = query.Skip((PageIndex - 1) * PageSize).Take(PageSize).ToList();
}
return list;
}
/// <summary>
/// 读取上传的Excel源文件,写入到数据库对应表
/// </summary>
/// <param name="excelName"></param>
public bool ReadExcelAndWriteToTable(string excelName, int CP, KSOAEnum.ImportExcelType type)
{
HSSFWorkbook hssfworkbook;
string path = "";
if ((int)type == (int)KSOAEnum.ImportExcelType.投诉源数据)
{
path = Server.MapPath("~/UploadFile/Complain/" + excelName);
}
if ((int)type == (int)KSOAEnum.ImportExcelType.包月源数据)
{
path = Server.MapPath("~/UploadFile/Month/" + excelName);
}
if ((int)type == (int)KSOAEnum.ImportExcelType.非包月付费源数据)
{
path = Server.MapPath("~/UploadFile/NBP/" + excelName);
}
using (FileStream file = new FileStream(path, FileMode.Open, FileAccess.Read))
{
hssfworkbook = new HSSFWorkbook(file);
}
bool result = ConvertEcelToTable(hssfworkbook, CP, type);
return result;
}
