工资计算模块

duhe

2023-07-28 4f23c4da3c004c530fda95bf21294b786918f12b

 WebAPI/Controllers/CJGL/Mes_OrderProcFlowAllReportController.cs

@@ -18,6 +18,7 @@
        private json objJsonResult = new json();
        SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
        DataSet ds;
        Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter();

        #region 车间工序全程跟踪报表 查询
        [Route("Mes_OrderProcFlowAllReport/OrderProcFlowAllReportList")]
@@ -172,10 +173,37 @@
        #region 计件工资报表 查询
        [Route("Mes_OrderProcFlowAllReport/EmployeePiecePayReport")]
        [HttpGet]
        public object EmployeePiecePayReport(string sWhere)
        public object EmployeePiecePayReport(string sWhere, string user)
        {
            try
            {
                //获取系统参数
                string Ret = "";
                if (oSystemParameter.ShowBill(ref Ret))
                {
                    //判断客户为龙山汽配
                    if (oSystemParameter.omodel.WMS_CampanyName == "龙山汽配")
                    {
                        //获取需要拼接的字符串
                        string sql_splice = DBUtility.ClsPub.SpliceSQL(user, "计件工资报表");

                        if (sql_splice != "")
                        {
                            sWhere += sql_splice;
                        }
                        else
                        {
                            string czymc = "";
                            ds = oCN.RunProcReturn("select * from gy_czygl where Czymc='" + user + "'", "gy_czygl");
                            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                            {
                                czymc += Convert.ToString(ds.Tables[0].Rows[i]["czymc"]) + ",";
                            }
                            sWhere += ",''";
                        }
                    }
                }

                //反序列化传递的值

                ds = oCN.RunProcReturn("exec h_p_Sc_EmployeePiecePayReport " + sWhere + "", "h_p_Sc_EmployeePiecePayReport");
@@ -210,10 +238,37 @@
        #region 计件工资汇总报表 查询
        [Route("Mes_OrderProcFlowAllReport/EmployeePiecePaySumReport")]
        [HttpGet]
        public object EmployeePiecePaySumReport(string sWhere)
        public object EmployeePiecePaySumReport(string sWhere, string user)
        {
            try
            {
                //获取系统参数
                string Ret = "";
                if (oSystemParameter.ShowBill(ref Ret))
                {
                    //判断客户为龙山汽配
                    if (oSystemParameter.omodel.WMS_CampanyName == "龙山汽配")
                    {
                        //获取需要拼接的字符串
                        string sql_splice = DBUtility.ClsPub.SpliceSQL(user, "计件工资汇总报表");

                        if (sql_splice != "")
                        {
                            sWhere += sql_splice;
                        }
                        else
                        {
                            string czymc = "";
                            ds = oCN.RunProcReturn("select * from gy_czygl where Czymc='" + user + "'", "gy_czygl");
                            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                            {
                                czymc += Convert.ToString(ds.Tables[0].Rows[i]["czymc"]) + ",";
                            }
                            sWhere += ",''";
                        }
                    }
                }

                //反序列化传递的值

                ds = oCN.RunProcReturn("exec h_p_Sc_EmployeePiecePaySumReport " + sWhere + "", "h_p_Sc_EmployeePiecePaySumReport");
@@ -248,10 +303,37 @@
        #region 工资汇报日报表 查询
        [Route("Mes_OrderProcFlowAllReport/EmployeePieceWorkReport")]
        [HttpGet]
        public object EmployeePieceWorkReport(string sWhere)
        public object EmployeePieceWorkReport(string sWhere, string user)
        {
            try
            {
                //获取系统参数
                string Ret = "";
                if (oSystemParameter.ShowBill(ref Ret))
                {
                    //判断客户为龙山汽配
                    if (oSystemParameter.omodel.WMS_CampanyName == "龙山汽配")
                    {
                        //获取需要拼接的字符串
                        string sql_splice = DBUtility.ClsPub.SpliceSQL(user, "工序汇报日报表");

                        if (sql_splice != "")
                        {
                            sWhere += sql_splice;
                        }
                        else
                        {
                            string czymc = "";
                            ds = oCN.RunProcReturn("select * from gy_czygl where Czymc='" + user + "'", "gy_czygl");
                            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                            {
                                czymc += Convert.ToString(ds.Tables[0].Rows[i]["czymc"]) + ",";
                            }
                            sWhere += ",''";
                        }
                    }
                }

                //反序列化传递的值

                ds = oCN.RunProcReturn("exec h_p_Sc_EmployeePieceWorkReport " + sWhere + "", "h_p_Sc_EmployeePieceWorkReport");
@@ -286,10 +368,37 @@
        #region 生产车间工序报表 查询
        [Route("Mes_OrderProcFlowAllReport/WorkShopProcessWIPReport")]
        [HttpGet]
        public object WorkShopProcessWIPReport(string sWhere)
        public object WorkShopProcessWIPReport(string sWhere,string user)
        {
            try
            {
                //获取系统参数
                string Ret = "";
                if (oSystemParameter.ShowBill(ref Ret))
                {
                    //判断客户为龙山汽配
                    if (oSystemParameter.omodel.WMS_CampanyName == "龙山汽配")
                    {
                        //获取需要拼接的字符串
                        string sql_splice = DBUtility.ClsPub.SpliceSQL(user, "生产车间工序报表");

                        if(sql_splice != "")
                        {
                            sWhere += sql_splice;
                        }
                        else
                        {
                            string czymc = "";
                            ds = oCN.RunProcReturn("select * from gy_czygl where Czymc='" + user + "'", "gy_czygl");
                            for(int i = 0; i < ds.Tables[0].Rows.Count; i++)
                            {
                                czymc += Convert.ToString(ds.Tables[0].Rows[i]["czymc"])+",";
                            }
                            sWhere += ",''";
                        }                        
                    }
                }

                //反序列化传递的值

                ds = oCN.RunProcReturn("exec h_p_Sc_WorkShopProcessWIPReport " + sWhere + "", "h_p_Sc_WorkShopProcessWIPReport");
@@ -324,10 +433,37 @@
        #region 工序在制品报表 查询
        [Route("Mes_OrderProcFlowAllReport/WorkShopProcessWIPSumReport")]
        [HttpGet]
        public object WorkShopProcessWIPSumReport(string sWhere)
        public object WorkShopProcessWIPSumReport(string sWhere, string user)
        {
            try
            {
                //获取系统参数
                string Ret = "";
                if (oSystemParameter.ShowBill(ref Ret))
                {
                    //判断客户为龙山汽配
                    if (oSystemParameter.omodel.WMS_CampanyName == "龙山汽配")
                    {
                        //获取需要拼接的字符串
                        string sql_splice = DBUtility.ClsPub.SpliceSQL(user, "工序在制品报表");

                        if (sql_splice != "")
                        {
                            sWhere += sql_splice;
                        }
                        else
                        {
                            string czymc = "";
                            ds = oCN.RunProcReturn("select * from gy_czygl where Czymc='" + user + "'", "gy_czygl");
                            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                            {
                                czymc += Convert.ToString(ds.Tables[0].Rows[i]["czymc"]) + ",";
                            }
                            sWhere += ",''";
                        }
                    }
                }

                //反序列化传递的值

                ds = oCN.RunProcReturn("exec h_p_Sc_WorkShopProcessWIPSumReport " + sWhere + "", "h_p_Sc_WorkShopProcessWIPSumReport");