Project_Net4/040_高速驿网/002_报表数据分析/ReportDataAnalysis/WebApi/COMMODITYSALEController.cs

using System;
using System.Collections.Generic;
using System.Web.Http;
using System.Web.Http.Description;
using ESCG = GSYWApi.GeneralMethod;
using ESCM = GSYWApi.Model;
using HZQR.Common;

namespace GSYWApi.Controllers
{
    /// <summary>
    /// 相关接口
    /// </summary>
    public class COMMODITYSALEController : BaseController
    {
        #region 获取列表
        /// <summary>
        /// 获取列表
        /// </summary>
        /// <param name="searchModel">查询条件对象</param>
        /// <returns></returns>
        [Route("Analysis/GetCOMMODITYSALEList")]
        [AcceptVerbs("POST")]
        [ResponseType(typeof(Models.JsonMsg<Models.JsonList<ESCM.COMMODITYSALEModel>>))]
        public IHttpActionResult GetCOMMODITYSALEList(ESCM.SearchModel<ESCM.COMMODITYSALEModel> searchModel)
        {
            string Parameter = "入参信息：查询方式【" + searchModel.QueryType + "】，查询页码【" + searchModel.PageIndex + "】，" + 
                "每页显示数量【" + searchModel.PageSize + "】，排序条件【" + searchModel.SortStr + "】";
            try
            {
                int TotalCount = 0;
                //获取列表
                List<ESCM.COMMODITYSALEModel> COMMODITYSALEList = ESCG.COMMODITYSALEHelper.GetCOMMODITYSALEList(
                    transaction, ref TotalCount, searchModel);

                //转化json形式
                Models.JsonList<ESCM.COMMODITYSALEModel> jsonList = Models.JsonList<ESCM.COMMODITYSALEModel>.Success(
                    COMMODITYSALEList, TotalCount, searchModel.PageIndex, searchModel.PageSize);

                return Ok(Models.JsonMsg<Models.JsonList<ESCM.COMMODITYSALEModel>>.Success(jsonList, 100, "查询成功"));
            }
            catch (Exception ex)
            {
                //事务回滚
                transaction.Rollback();
                LogUtil.WriteLog(null, "查询失败！失败原因：" + ex.Message + "\r\n" + Parameter,
                    DateTime.Now.ToString("yyyyMMdd") + "_GetCOMMODITYSALEList");
                return Ok(Method.Common.ReturnJson(999, "查询失败" + ex.Message));
            }
        }
        #endregion

        #region 获取明细
        /// <summary>
        /// 获取明细
        /// </summary>
        /// <param name="COMMODITYSALEId">内码</param>
        /// <returns></returns>
        [Route("Analysis/GetCOMMODITYSALEDetail")]
        [AcceptVerbs("GET")]
        [ResponseType(typeof(Models.JsonMsg<ESCM.COMMODITYSALEModel>))]
        public IHttpActionResult GetCOMMODITYSALEDetail(int COMMODITYSALEId)
        {
            string Parameter = "入参信息：内码【" + COMMODITYSALEId + "】";
            try
            {
                //获取明细
                ESCM.COMMODITYSALEModel commoditysaleModel = ESCG.COMMODITYSALEHelper.GetCOMMODITYSALEDetail(transaction, COMMODITYSALEId);

                return Ok(Models.JsonMsg<ESCM.COMMODITYSALEModel>.Success(commoditysaleModel, 100, "查询成功"));
            }
            catch (Exception ex)
            {
                //事务回滚
                transaction.Rollback();
                LogUtil.WriteLog(null, "查询失败！失败原因：" + ex.Message + "\r\n" + Parameter,
                    DateTime.Now.ToString("yyyyMMdd") + "_GetCOMMODITYSALEDetail");
                return Ok(Method.Common.ReturnJson(999, "查询失败" + ex.Message));
            }
        }
        #endregion

        #region 同步
        /// <summary>
        /// 同步
        /// </summary>
        /// <param name="commoditysaleModel"></param>
        /// <returns></returns>
        [Route("Analysis/SynchroCOMMODITYSALE")]
        [AcceptVerbs("POST")]
        [ResponseType(typeof(Models.JsonMsg<string>))]
        public IHttpActionResult SynchroCOMMODITYSALE(ESCM.COMMODITYSALEModel commoditysaleModel)
        {
            try
            {
                //新增
                bool SynchroFlag = ESCG.COMMODITYSALEHelper.SynchroCOMMODITYSALE(transaction, commoditysaleModel);

                if (SynchroFlag)
                {
                    return Ok(Method.Common.ReturnJson(100, "同步成功"));
                }
                else
                {
                    return Ok(Method.Common.ReturnJson(200, "更新失败，数据不存在！"));
                }
            }
            catch (Exception ex)
            {
                //事务回滚
                transaction.Rollback();
                LogUtil.WriteLog(null, "同步失败！失败原因：" + ex.Message,
                    DateTime.Now.ToString("yyyyMMdd") + "_SynchroCOMMODITYSALE");
                return Ok(Method.Common.ReturnJson(999, "同步失败" + ex.Message));
            }
        }
        #endregion

        #region 删除
        /// <summary>
        /// 删除
        /// </summary>
        /// <param name="COMMODITYSALEId">内码</param>
        /// <returns></returns>
        [Route("Analysis/DeleteCOMMODITYSALE")]
        [AcceptVerbs("GET", "POST")]
        [ResponseType(typeof(Models.JsonMsg<string>))]
        public IHttpActionResult DeleteCOMMODITYSALE(int COMMODITYSALEId)
        {
            string Parameter = "入参信息：内码【" + COMMODITYSALEId + "】";
            try
            {
                //删除
                bool DeleteFlag = ESCG.COMMODITYSALEHelper.DeleteCOMMODITYSALE(transaction, COMMODITYSALEId);

                if (DeleteFlag)
                {
                    return Ok(Method.Common.ReturnJson(100, "删除成功"));
                }
                else
                {
                    return Ok(Method.Common.ReturnJson(200, "删除失败，数据不存在！"));
                }
            }
            catch (Exception ex)
            {
                //事务回滚
                transaction.Rollback();
                LogUtil.WriteLog(null, "删除失败！失败原因：" + ex.Message + "\r\n" + Parameter,
                    DateTime.Now.ToString("yyyyMMdd") + "_DeleteCOMMODITYSALE");
                return Ok(Method.Common.ReturnJson(999, "删除失败" + ex.Message));
            }
        }
        #endregion
    }
}