IMEX.mes.wcf/DK.Service/PDAModuleLogic/PDAModuleLogicSemi.cs

/*******************************************************************************
 * Copyright(c) 2019 DongkeSoft All rights reserved. / Confidential
 * 类的信息：
 *      1.程序名称：PDAModuleLogicSemi.cs
 *      2.功能描述：PDA相关处理(半检专用)。
 * 编辑履历：
 *      作者            日期                版本            修改内容
 *      徐伟          2019/12/02            1.00            新建
 *******************************************************************************/

using System;
using System.Collections.Generic;
using System.Data;
using System.Drawing;
using System.Drawing.Imaging;
using System.IO;
using System.Text;

using Dongke.IBOSS.PRD.Basics.BaseResources;
using Dongke.IBOSS.PRD.Basics.DataAccess;
using Dongke.IBOSS.PRD.Basics.Library;
using Dongke.IBOSS.PRD.Service.DataModels;
using Dongke.IBOSS.PRD.WCF.DataModels;
using Dongke.IBOSS.PRD.WCF.DataModels.HRModule;
using Dongke.IBOSS.PRD.WCF.DataModels.PCModule;
using Dongke.IBOSS.PRD.WCF.DataModels.PMModule;
using Oracle.ManagedDataAccess.Client;
using Newtonsoft.Json.Linq;

namespace Dongke.IBOSS.PRD.Service.PDAModuleLogic
{
    /// <summary>
    /// 半检专用接口
    /// </summary>
    public partial class PDAModuleLogic
    {
        /// <summary>
        /// 获取半检等级 xuwei add 2019-12-5
        /// </summary>
        /// <param name="procedureId"></param>
        /// <param name="sUser"></param>
        /// <returns></returns>
        public static ServiceResultEntity GetGoodsGradeDataSemi(int procedureId , SUserInfo sUser)
        {
            ServiceResultEntity sre = new ServiceResultEntity();
            sre.Data = new DataSet();
            sre.Status = Constant.ServiceResultStatus.Success;
            IDBTransaction conn = ClsDbFactory.CreateDBTransaction(DataBaseType.ORACLE, DataManager.ConnectionString);
            string sqlStr = "";
            try
            {
                conn.Connect();
                //读取工序定义的半检产品等级
                if (sre.Status == Constant.ServiceResultStatus.Success)
                {
                    //获取全部分级
                    if (procedureId == 0)
                    {
                        sqlStr = $@"
                        SELECT
                             t.GOODSLEVELTYPEID,
                             l.GOODSLEVELID,
                             l.GOODSLEVELNAME 
                        FROM
                             TP_MST_GOODSLEVEL l
                             LEFT JOIN TP_SYS_GOODSLEVELTYPE t ON l.GOODSLEVELTYPEID = t.GOODSLEVELTYPEID 
                        WHERE
                             t.ISSEMIFINISHEDEX = '1' 
                             AND t.GOODSLEVELTYPEID NOT IN ( 13, 14 ) 
                        ORDER BY
                             l.SFEDISPLAYNO
                        ";
                    }
                    //获取工序定义的分级
                    if (procedureId > 0)
                    {
                        sqlStr = $@"
                            SELECT
                                 t.GOODSLEVELTYPEID,
                                 l.GOODSLEVELID,
                                 l.GOODSLEVELNAME 
                            FROM
                                 TP_PC_PROCEDUREGOODSLEVEL p
                                 LEFT JOIN TP_SYS_GOODSLEVELTYPE t ON p.GOODSLEVELTYPEID = t.GOODSLEVELTYPEID 
                                 LEFT JOIN TP_MST_GOODSLEVEL l ON l.GOODSLEVELTYPEID = t.GOODSLEVELTYPEID
                            WHERE
                                 p.PROCEDUREID = {procedureId}
                            ORDER BY
                                 l.SFEDISPLAYNO
                            ";
                    }
                    DataTable groutingLine = conn.GetSqlResultToDt(sqlStr);
                    groutingLine.TableName = "GoodsLevel";
                    sre.Data.Tables.Add(groutingLine);
                    if (groutingLine.Rows.Count == 0)
                    {
                        sre.Status = Constant.ServiceResultStatus.NoSearchResults;
                        sre.Message = "没有查询结果！";
                    }
                    else
                    {
                        sre.Status = Constant.ServiceResultStatus.Success;
                        sre.Message = "操作成功！";
                    }
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                conn.Disconnect();
            }
            //返回数据
            return sre;
        }
    }
}