设备工艺参数趋势图,制程绩效趋势图(一次合格率)

zrg

2024-07-31 e1dd681c82cdde2b21c35eb091fc992202d6d339

 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");
@@ -359,6 +495,91 @@
        #endregion


        #region 产品工艺路线展开报表 查询
        [Route("Mes_OrderProcFlowAllReport/RoutingBillMulLevBOMReportList")]
        [HttpGet]
        public object RoutingBillMulLevBOMReportList(string sWhere)
        {
            try
            {
                //反序列化传递的值

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

                List<object> listCol = new List<object>();
                foreach (DataColumn col in ds.Tables[0].Columns)
                {
                    Type dataType = col.DataType;
                    string str = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}";
                    listCol.Add(JsonConvert.DeserializeObject(str));
                }

                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = "Sucess！";
                objJsonResult.data = ds.Tables[0];
                objJsonResult.list = listCol;
                return objJsonResult;
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "Exception！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #endregion


        #region 工序异常过站报表
        /// <summary>
        /// 工序异常过站报表
        /// </summary>
        /// <returns></returns>
        [Route("Mes_OrderProcFlowAllReportController/GetSc_ProcessErrStationReport_Json")]
        [HttpGet]
        public object GetSc_ProcessErrStationReport_Json(string sWhere,string user)
        {
            try
            {
                if (!DBUtility.ClsPub.Security_Log("Sc_ProcessErrStationReport", 1, false, user))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "无查看权限！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                ds = oCN.RunProcReturn("exec h_p_Sc_ProcessErrStationReport " + sWhere, "h_p_Sc_ProcessErrStationReport");
                List<object> columnNameList = new List<object>();
                //添加列名
                foreach (DataColumn col in ds.Tables[0].Columns)
                {
                    Type dataType = col.DataType;
                    string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}";
                    columnNameList.Add(JsonConvert.DeserializeObject(ColmString));  //获取到DataColumn列对象的列名
                }
                objJsonResult.code = "0";
                objJsonResult.count = 1;
                objJsonResult.Message = "成功！";
                objJsonResult.data = ds.Tables[0];
                objJsonResult.list = columnNameList;
                return objJsonResult;
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "查询工序异常过站报表信息失败！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #endregion


    }
}