客诉追溯流程报表

zgq

2021-05-10 e7cfc2b5dd153c336b944f0593207c5c7f091c11

客诉追溯流程报表

 WebAPI/Controllers/ReportController.cs

New file
@@ -0,0 +1,78 @@
using Newtonsoft.Json.Linq;
using Pub_Class;
using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Web.Http;
using WebAPI.Models;

namespace WebAPI.Controllers
{
    //报表Controller
    public class ReportController : ApiController
    {
        public ClsPub.Enum_BillStatus BillStatus;

        private json objJsonResult = new json();
        SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
        DataSet ds;



        /// <summary>
        /// 返回客诉追溯流程报表
        /// </summary>
        /// <param name="sWhere">拼接的SQL</param>
        /// <returns>object</returns>
        [Route("Report/RetrospectionCustomerReport")]
        [HttpGet]
        public object RetrospectionCustomerReport(string sWhere)
        {
            DataSet ds;
            try
            {
                if (sWhere == null || sWhere.Equals(""))
                {
                    ds = oCN.RunProcReturn("select top 5000 * from h_v_RetrospectionCustomerReport order by 组托单日期 desc", "h_v_RetrospectionCustomerReport");
                }
                else
                {
                    string sql1 = "select * from h_v_RetrospectionCustomerReport where 1 = 1 ";
                    string sql = sql1 + sWhere;
                    string sql2 = " order by 组托单日期 desc";
                    sql += sql2;
                    ds = oCN.RunProcReturn(sql, "h_v_RetrospectionCustomerReport");
                }
                if (ds == null || ds.Tables[0].Rows.Count == 0)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "无数据！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                else
                {
                    objJsonResult.code = "1";
                    objJsonResult.count = 1;
                    objJsonResult.Message = "Sucess！";
                    objJsonResult.data = ds.Tables[0];
                    return objJsonResult;
                }

            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "Exception！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }

        //
    }
}

 WebAPI/Controllers/Sc_GroupOrderBillController.cs

@@ -113,6 +113,8 @@
                long HInterID = list[0].HInterID;//递入type得到的单据ID
                string HBillNo = list[0].HBillNo;//递入type得到的单据No
                string HMaker = list[0].HMaker;//制单人
                string HBatchNo = list[0].HBatchNo;//入库批次
                string HBarCode_Cus = list[0].HBarCode_Cus;//客户标签（黑标号）
                //生成唯一条码
                ds = oCN.RunProcReturn("exec h_p_WMS_GetMaxNo '" + nowDate + "'", "h_p_WMS_GetMaxNo");    //获取最大流水号
                oCN.RunProc("exec h_p_WMS_SetMaxNo '" + nowDate + "'");
@@ -125,17 +127,19 @@
                    "(" +
                        "HYear, HBillType, HInterID, HBillNo, HMaker" +
                        ", HMakeDate, HPeriod, HDate, HRemark, HICMOInterID" +
                        ", HICMOBillNo, HBarCode_Pack, HMaterID, HUnitID" +
                        ", HICMOBillNo, HBarCode_Pack, HMaterID, HUnitID,HBatchNo,HBarCode_Cus" +
                    ")" +
                    "values" +
                    "(" +
                        "'"+ year + "', '" + HBillType + "'," + HInterID + ", '" + HBillNo + "', '" + HMaker + "'" +
                        ",GETDATE(),0,GETDATE(),' ',0" +
                        ",' ','"+ HBarCode_Pack + "',0,0" +
                    ")"
                        ",' ','"+ HBarCode_Pack + "',0,0,'" + HBatchNo +"','" + HBarCode_Cus +
                    "')"
                );
                //插入子表
                oCN.RunProc("exec h_p_SaveGroupOrder " + HInterID + "");
                //根据子表汇总生成Sc_PackUnionBillSub_Sum表记录
                oCN.RunProc("exec h_p_Sc_PackUnionBill_SumSubBill " + HInterID + ",'','',''");
                oCN.Commit();
                objJsonResult.code = "1";
                objJsonResult.count = 1;
@@ -289,6 +293,103 @@
            }
        }

        /// <summary>
        /// 根据唯一条码删除缓存表中扫码记录
        /// </summary>
        /// <param name="BarCode">唯一条码</param>
        /// <returns>object</returns>
        [Route("GroupOrderBill/DelCacheListByBarCode")]
        [HttpGet]
        public object DelCacheListByBarCode(string BarCode)
        {
            try
            {
                SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
                oCn.RunProc("Delete from KF_PonderationBillMain_Temp where HBarCode = " + BarCode + " and HBillType = '2601'");
                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = "删除成功！";
                objJsonResult.data = null;
                return objJsonResult;
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "删除失败！";
                objJsonResult.data = e.ToString();
                return objJsonResult;
            }
        }

        /// <summary>
        /// 根据组托单主ID和子ID删除列表中行记录
        /// </summary>
        /// <param name="HInterID">组托单主ID</param>
        /// <param name="HEntryID">组托单子ID</param>
        /// <returns>object</returns>
        [Route("GroupOrderBill/DelListRow")]
        [HttpGet]
        public object DelListRow(long HInterID,long HEntryID)
        {
            try
            {
                SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
                oCN.BeginTran();
                oCn.RunProc("Delete from Sc_PackUnionBillSub where HInterID = " + HInterID + " and HEntryID = " + HEntryID);
                //重新刷新更新 汇总子表 的记录和条码档案
                oCn.RunProc("Delete from Sc_PackUnionBillSub_Sum where HInterID = " + HInterID);
                oCn.RunProc("Delete from Gy_BarCodeBill where HInterID = " + HInterID + " and HSourceBillType = '3772'");
                //根据子表汇总生成Sc_PackUnionBillSub_Sum表记录
                oCN.RunProc("exec h_p_Sc_PackUnionBill_SumSubBill " + HInterID + ",'','',''");
                oCN.Commit();
                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = "删除成功！";
                objJsonResult.data = null;
                return objJsonResult;
            }
            catch (Exception e)
            {
                oCN.RollBack();
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "删除失败！";
                objJsonResult.data = e.ToString();
                return objJsonResult;
            }
        }

        /// <summary>
        /// 根据组托单主ID和子ID修改列表中行记录的黑标号
        /// </summary>
        /// <param name="HInterID">组托单主ID</param>
        /// <param name="HBarCode_Cus">黑标号</param>
        /// <returns>object</returns>
        [Route("GroupOrderBill/editListRowHBarCode_Cus")]
        [HttpGet]
        public object editListRowHBarCode_Cus(long HInterID,string HBarCode_Cus)
        {
            try
            {
                SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
                oCn.RunProc("update Sc_PackUnionBillMain set HBarCode_Cus = " + HBarCode_Cus + " where HInterID = " + HInterID);
                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = "修改成功！";
                objJsonResult.data = null;
                return objJsonResult;
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "修改失败！";
                objJsonResult.data = e.ToString();
                return objJsonResult;
            }
        }

        //
    }
}

 WebAPI/Models/GroupOrderBill.cs

@@ -10,6 +10,8 @@
        public long HInterID { get; set; }
        public string HBillNo { get; set; }
        public string HMaker { get; set; }
        public string HBatchNo { get; set; }//入库批次
        public string HBarCode_Cus { get; set; }//客户标签（黑标号）
        //public int HYear { get; set; }
        //public double HPeriod { get; set; }
        //public DateTime HStationInTime { get; set; }

 WebAPI/WebAPI.csproj

@@ -314,6 +314,7 @@
    <Compile Include="Controllers\EntrustOutBackController.cs" />
    <Compile Include="Controllers\EntrustOutController.cs" />
    <Compile Include="Controllers\Kf_EntrustInBillController.cs" />
    <Compile Include="Controllers\ReportController.cs" />
    <Compile Include="Controllers\Sc_GroupOrderBillController.cs" />
    <Compile Include="Controllers\MateOutController.cs" />
    <Compile Include="Controllers\MoveStockBillController.cs" />