using System;
using System.Collections.Generic;
using System.Web.Http;
using System.Web.Http.Description;
using ESCG = GSYWApi.GeneralMethod;
using ESCM = GSYWApi.Model;
namespace GSYWApi.Controllers
{
///
/// 报表数据相关接口
///
public class AnalysisController : BaseController
{
#region 获取日结数据列表
///
/// 获取日结数据列表
///
/// 查询条件对象
///
[Route("Analysis/GetEndaccountList")]
[AcceptVerbs("POST")]
[ResponseType(typeof(Models.JsonMsg>))]
public IHttpActionResult GetEndaccountList(Models.SearchModel searchModel)
{
string Parameter = "入参信息:查询方式【" + searchModel.QueryType + "】,查询页码【" + searchModel.PageIndex + "】," +
"每页显示数量【" + searchModel.PageSize + "】,排序条件【" + searchModel.SortStr + "】";
try
{
int TotalCount = 0;
//获取日结数据列表
List ENDACCOUNTList = ESCG.ENDACCOUNTHelper.GetENDACCOUNTList(
transaction, ref TotalCount, searchModel);
//转化json形式
Models.JsonList jsonList = Models.JsonList.Success(
ENDACCOUNTList, TotalCount, searchModel.PageIndex, searchModel.PageSize);
return Ok(Models.JsonMsg>.Success(jsonList, 100, "查询成功"));
}
catch (Exception ex)
{
//事务回滚
transaction.Rollback();
Helper.LogUtil.WriteLog(null, "查询失败!失败原因:" + ex.Message + "\r\n" + Parameter,
DateTime.Now.ToString("yyyyMMdd") + "_GetEndaccountList");
return Ok(Helper.Common.ReturnJson(999, "查询失败" + ex.Message));
}
}
#endregion
#region 获取日结数据明细
///
/// 获取日结数据明细
///
/// 日结数据内码
///
[Route("Analysis/GetEndaccountDetail")]
[AcceptVerbs("GET")]
[ResponseType(typeof(Models.JsonMsg))]
public IHttpActionResult GetEndaccountDetail(int EndaccountId)
{
string Parameter = "入参信息:日结数据内码【" + EndaccountId + "】";
try
{
//获取日结数据明细
ESCM.ENDACCOUNTModel endaccountModel = ESCG.ENDACCOUNTHelper.GetENDACCOUNTDetail(transaction, EndaccountId);
return Ok(Models.JsonMsg.Success(endaccountModel, 100, "查询成功"));
}
catch (Exception ex)
{
//事务回滚
transaction.Rollback();
Helper.LogUtil.WriteLog(null, "查询失败!失败原因:" + ex.Message + "\r\n" + Parameter,
DateTime.Now.ToString("yyyyMMdd") + "_GetEndaccountDetail");
return Ok(Helper.Common.ReturnJson(999, "查询失败" + ex.Message));
}
}
#endregion
#region 同步日结数据
///
/// 同步日结数据
///
///
///
[Route("Analysis/SynchroEndaccount")]
[AcceptVerbs("POST")]
[ResponseType(typeof(Models.JsonMsg))]
public IHttpActionResult SynchroEndaccount(ESCM.ENDACCOUNTModel endaccountModel)
{
try
{
//新增日结数据
bool SynchroFlag = ESCG.ENDACCOUNTHelper.SynchroENDACCOUNT(transaction, endaccountModel);
if (SynchroFlag)
{
return Ok(Helper.Common.ReturnJson(100, "同步成功"));
}
else
{
return Ok(Helper.Common.ReturnJson(200, "更新失败,数据不存在!"));
}
}
catch (Exception ex)
{
//事务回滚
transaction.Rollback();
Helper.LogUtil.WriteLog(null, "同步失败!失败原因:" + ex.Message,
DateTime.Now.ToString("yyyyMMdd") + "_SynchroEndaccount");
return Ok(Helper.Common.ReturnJson(999, "同步失败" + ex.Message));
}
}
#endregion
#region 删除日结数据
///
/// 删除日结数据
///
/// 日结数据内码
///
[Route("Analysis/DeleteEndaccount")]
[AcceptVerbs("GET", "POST")]
[ResponseType(typeof(Models.JsonMsg))]
public IHttpActionResult DeleteEndaccount(int EndaccountId)
{
string Parameter = "入参信息:日结数据内码【" + EndaccountId + "】";
try
{
//删除日结数据
bool DeleteFlag = ESCG.ENDACCOUNTHelper.DeleteENDACCOUNT(transaction, EndaccountId);
if (DeleteFlag)
{
return Ok(Helper.Common.ReturnJson(100, "删除成功"));
}
else
{
return Ok(Helper.Common.ReturnJson(200, "删除失败,数据不存在!"));
}
}
catch (Exception ex)
{
//事务回滚
transaction.Rollback();
Helper.LogUtil.WriteLog(null, "删除失败!失败原因:" + ex.Message + "\r\n" + Parameter,
DateTime.Now.ToString("yyyyMMdd") + "_DeleteEndaccount");
return Ok(Helper.Common.ReturnJson(999, "删除失败" + ex.Message));
}
}
#endregion
#region 获取收银员报表列表
///
/// 获取收银员报表列表
///
/// 查询条件对象
///
[Route("Analysis/GetPersonsellList")]
[AcceptVerbs("POST")]
[ResponseType(typeof(Models.JsonMsg>))]
public IHttpActionResult GetPersonsellList(Models.SearchModel searchModel)
{
string Parameter = "入参信息:查询方式【" + searchModel.QueryType + "】,查询页码【" + searchModel.PageIndex + "】," +
"每页显示数量【" + searchModel.PageSize + "】,排序条件【" + searchModel.SortStr + "】";
try
{
int TotalCount = 0;
//获取收银员报表列表
List PERSONSELLList = ESCG.PERSONSELLHelper.GetPERSONSELLList(
transaction, ref TotalCount, searchModel);
//转化json形式
Models.JsonList jsonList = Models.JsonList.Success(
PERSONSELLList, TotalCount, searchModel.PageIndex, searchModel.PageSize);
return Ok(Models.JsonMsg>.Success(jsonList, 100, "查询成功"));
}
catch (Exception ex)
{
//事务回滚
transaction.Rollback();
Helper.LogUtil.WriteLog(null, "查询失败!失败原因:" + ex.Message + "\r\n" + Parameter,
DateTime.Now.ToString("yyyyMMdd") + "_GetPersonsellList");
return Ok(Helper.Common.ReturnJson(999, "查询失败" + ex.Message));
}
}
#endregion
#region 获取收银员报表明细
///
/// 获取收银员报表明细
///
/// 收银员报表内码
///
[Route("Analysis/GetPersonsellDetail")]
[AcceptVerbs("GET")]
[ResponseType(typeof(Models.JsonMsg))]
public IHttpActionResult GetPersonsellDetail(int PersonsellId)
{
string Parameter = "入参信息:收银员报表内码【" + PersonsellId + "】";
try
{
//获取收银员报表明细
ESCM.PERSONSELLModel personsellModel = ESCG.PERSONSELLHelper.GetPERSONSELLDetail(transaction, PersonsellId);
return Ok(Models.JsonMsg.Success(personsellModel, 100, "查询成功"));
}
catch (Exception ex)
{
//事务回滚
transaction.Rollback();
Helper.LogUtil.WriteLog(null, "查询失败!失败原因:" + ex.Message + "\r\n" + Parameter,
DateTime.Now.ToString("yyyyMMdd") + "_GetPersonsellDetail");
return Ok(Helper.Common.ReturnJson(999, "查询失败" + ex.Message));
}
}
#endregion
#region 同步收银员报表
///
/// 同步收银员报表
///
///
///
[Route("Analysis/SynchroPersonsell")]
[AcceptVerbs("POST")]
[ResponseType(typeof(Models.JsonMsg))]
public IHttpActionResult SynchroPersonsell(ESCM.PERSONSELLModel personsellModel)
{
try
{
//新增收银员报表
bool SynchroFlag = ESCG.PERSONSELLHelper.SynchroPERSONSELL(transaction, personsellModel);
if (SynchroFlag)
{
return Ok(Helper.Common.ReturnJson(100, "同步成功"));
}
else
{
return Ok(Helper.Common.ReturnJson(200, "更新失败,数据不存在!"));
}
}
catch (Exception ex)
{
//事务回滚
transaction.Rollback();
Helper.LogUtil.WriteLog(null, "同步失败!失败原因:" + ex.Message,
DateTime.Now.ToString("yyyyMMdd") + "_SynchroPersonsell");
return Ok(Helper.Common.ReturnJson(999, "同步失败" + ex.Message));
}
}
#endregion
#region 删除收银员报表
///
/// 删除收银员报表
///
/// 收银员报表内码
///
[Route("Analysis/DeletePersonsell")]
[AcceptVerbs("GET", "POST")]
[ResponseType(typeof(Models.JsonMsg))]
public IHttpActionResult DeletePersonsell(int PersonsellId)
{
string Parameter = "入参信息:收银员报表内码【" + PersonsellId + "】";
try
{
//删除
bool DeleteFlag = ESCG.PERSONSELLHelper.DeletePERSONSELL(transaction, PersonsellId);
if (DeleteFlag)
{
return Ok(Helper.Common.ReturnJson(100, "删除成功"));
}
else
{
return Ok(Helper.Common.ReturnJson(200, "删除失败,数据不存在!"));
}
}
catch (Exception ex)
{
//事务回滚
transaction.Rollback();
Helper.LogUtil.WriteLog(null, "删除失败!失败原因:" + ex.Message + "\r\n" + Parameter,
DateTime.Now.ToString("yyyyMMdd") + "_DeletePersonsell");
return Ok(Helper.Common.ReturnJson(999, "删除失败" + ex.Message));
}
}
#endregion
#region 获取单品数据列表
///
/// 获取单品数据列表
///
/// 查询条件对象
///
[Route("Analysis/GetCommoditySaleList")]
[AcceptVerbs("POST")]
[ResponseType(typeof(Models.JsonMsg>))]
public IHttpActionResult GetCommoditySaleList(Models.SearchModel searchModel)
{
string Parameter = "入参信息:查询方式【" + searchModel.QueryType + "】,查询页码【" + searchModel.PageIndex + "】," +
"每页显示数量【" + searchModel.PageSize + "】,排序条件【" + searchModel.SortStr + "】";
try
{
int TotalCount = 0;
//获取单品数据列表
List COMMODITYSALEList = ESCG.COMMODITYSALEHelper.GetCOMMODITYSALEList(
transaction, ref TotalCount, searchModel);
//转化json形式
Models.JsonList jsonList = Models.JsonList.Success(
COMMODITYSALEList, TotalCount, searchModel.PageIndex, searchModel.PageSize);
return Ok(Models.JsonMsg>.Success(jsonList, 100, "查询成功"));
}
catch (Exception ex)
{
//事务回滚
transaction.Rollback();
Helper.LogUtil.WriteLog(null, "查询失败!失败原因:" + ex.Message + "\r\n" + Parameter,
DateTime.Now.ToString("yyyyMMdd") + "_GetCommoditySaleList");
return Ok(Helper.Common.ReturnJson(999, "查询失败" + ex.Message));
}
}
#endregion
}
}