Merge branch 'master' of http://101.37.171.70:10101/r/MES-WEB-API

jinghz@oceic.com

2023-08-24 c5cfa2df88c6d2e5b31e87e1d5a8fe49d585f0bb

 WebAPI/Controllers/ÈËʹÜÀí/ÀëÖ°ÉêÇë/HR_EmpDimissionBillController.cs

@@ -11,7 +11,7 @@
using System.Windows.Forms;
using WebAPI.Models;

namespace WebAPI.Controllers.项目管理.工作任务
namespace WebAPI.Controllers.人事管理.离职申请
{
    public class HR_EmpDimissionBillController : ApiController
    {
@@ -19,7 +19,7 @@
        private json objJsonResult = new json();
        public DataSet ds = new DataSet();
        public SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
        public DAL.ClsSc_ICMOBill BillOld = new DAL.ClsSc_ICMOBill();
        public DAL.ClsHR_EmpDimissionBill BillOld = new DAL.ClsHR_EmpDimissionBill();
        string user_LongShan = "";
        string HName_LongShan = "";

@@ -788,5 +788,57 @@
            }
        }
        #endregion

        #region ç¦»èŒç”³è¯·å•åˆ—表 æ ¹æ®èŒå‘˜å†…码获取部门与岗位
        /// <summary>
        /// è¿”回项目阶段列表
        ///参数：string sql。
        ///返回值：object。
        /// </summary>
        [Route("HR_EmpDimissionBill/getInfoByHEmpID")]
        [HttpGet]
        public object getInfoByHEmpID(Int64 HEmpID)
        {
            try
            {
                string sql = @"select 
                            b.HItemID HDeptID, b.HNumber HDeptNumber, b.HName HDeptName
                            , c.HItemID HPostID, c.HNumber HPostNumber, c.HName HPostName
                            , d.HItemID HWorkTypeID, d.HNumber HWorkTypeNumber, d.HName HWorkTypeName, d.HPayMoney 
                            , e.HItemID HGroupID, e.HNumber HGroupNumber, e.HName HGroupName
                            from Gy_Employee AS a 
                            LEFT OUTER JOIN Gy_Department AS b on a.HDeptID = b.HItemID
                            LEFT OUTER JOIN Gy_Post AS c on a.HPostID = c.HItemID
                            LEFT OUTER JOIN Gy_WorkType AS d on a.HWorkTypeID = d.HItemID
                            LEFT OUTER JOIN Gy_Group AS e on a.HGroupID = e.HItemID
                            where a.HItemID = " + HEmpID;

                ds = oCN.RunProcReturn(sql, "Gy_EmployeeInfo");

                if(ds==null || ds.Tables[0].Rows.Count == 0)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "未找到该职员记录";
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                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;
            }
        }
        #endregion
    }
}