using DBUtility;
using Newtonsoft.Json;
using Newtonsoft.Json.Linq;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Net;
using System.Net.Http;
using System.Web.Http;
using WebAPI.Models;
using System.Web;
using WebAPI.Controllers.SCGL.日计划管理;
using System.IO;
using SyntacticSugar.constant;
namespace WebAPI.Controllers
{
    public class Gy_WorkTypeController : ApiController
    {
        public DBUtility.ClsPub.Enum_BillStatus BillStatus;
        const string ModCaption = "工种";
        public const string ModRightName = "Gy_WorkType";
        public const string ModRightNameAdd = ModRightName + "_Add";        //新增
        public const string ModRightNameEdit = ModRightName + "_Edit";      //编辑
        public const string ModRightNameCheck = ModRightName + "_Check";    //审核
        public const string ModRightNameClose = ModRightName + "_Stop";     //禁用
        public const string ModRightNameDelete = ModRightName + "_Delete";  //删除
        public DataSet ds = new DataSet();
        private json objJsonResult = new json();
        SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
        DAL.ClsGy_WorkType_Ctl oBill = new DAL.ClsGy_WorkType_Ctl();
        DAL.ClsGy_WorkType_View oBillHlp = new DAL.ClsGy_WorkType_View();


        #region 工种列表
        /// <summary>
        /// 获取工种列表信息
        /// </summary>
        /// <returns></returns>
        [Route("Gy_WorkTypeController/GetGy_WorkTypeList_Json")]
        [HttpGet]
        public object GetGy_WorkTypeList_Json(string sWhere, string HMaker, string OperationType)
        {
            try
            {
                //判断权限  1为直接列表模块打开  2为从其他模块跳转打开列表
                if (OperationType == "1")
                {
                    //判断权限
                    if (!DBUtility.ClsPub.Security_Log(ModRightName, 1, false, HMaker))
                    {
                        objJsonResult.code = "0";
                        objJsonResult.count = 0;
                        objJsonResult.Message = "您没有该模块权限,请与管理员联系！";
                        objJsonResult.data = null;
                        return objJsonResult;
                    }
                }

                //返回列表信息
                ds = oCn.RunProcReturn("select * from h_v_Gy_WorkTypeList where " + sWhere + " order by " + ModCaption + "代码" , "h_v_Gy_WorkTypeList");
                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

        #region 工种删除
        /// <summary>
        /// 删除工种
        /// </summary>
        /// <returns></returns>
        [Route("Gy_WorkTypeController/GetGy_WorkType_Delete_Json")]
        [HttpGet]
        public object GetGy_WorkType_Delete_Json(Int64 HItemID, string HMaker)
        {
            try
            {
                //判断权限
                if (!DBUtility.ClsPub.Security_Log(ModRightNameDelete, 1, false, HMaker))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "您没有该模块删除功能权限,请与管理员联系！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                //判断存在性
                if (oBillHlp.GetInfoByID(HItemID))
                {
                    //判断是否存在子项
                    if (oBill.HavChildCodes(HItemID))
                    {
                        objJsonResult.code = "0";
                        objJsonResult.count = 0;
                        objJsonResult.Message = "此工种存在子项目,不能删除！";
                        objJsonResult.data = null;
                        return objJsonResult;
                    }
                    //删除数据
                    if (oBill.DeleteByID(HItemID))
                    {
                        //写入日志
                        DBUtility.ClsPub.Add_Log("", "删除工种，代码：" + oBillHlp.omodel.HNumber + ",名称：" + oBillHlp.omodel.HName, HMaker);
                        objJsonResult.code = "1";
                        objJsonResult.count = 1;
                        objJsonResult.Message = "删除工种成功！";
                        objJsonResult.data = null;
                        return objJsonResult;
                    }
                    else
                    {
                        objJsonResult.code = "0";
                        objJsonResult.count = 0;
                        objJsonResult.Message = "删除工种失败！";
                        objJsonResult.data = null;
                        return objJsonResult;
                    }
                }
                else
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "未查询到该工种，请刷新数据后重新选择！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "删除工种失败！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #endregion

        #region 工种审核、反审核
        /// <summary>
        /// 审核、反审核工种
        /// </summary>
        /// <param name="HItemID">内码</param>
        /// <param name="IsAudit">审核(0),反审核(1)</param>
        /// <param name="HMaker">操作人</param>
        /// <returns></returns>
        [Route("Gy_WorkTypeController/GetGy_WorkType_Check_Json")]
        [HttpGet]
        public object GetGy_WorkType_Check_Json(Int64 HItemID, int IsAudit, string HMaker)
        {
            string sErrMsg = "";
            try
            {
                //判断权限
                if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, false, HMaker))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "您没有该模块审核/反审核功能权限,请与管理员联系！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                if (IsAudit == 0)   //审核判断
                {
                    if (oBill.CheckByHItemID(HItemID, HMaker, ref sErrMsg))
                    {
                        objJsonResult.code = "1";
                        objJsonResult.count = 1;
                        objJsonResult.Message = "审核工种成功！";
                        objJsonResult.data = null;
                        return objJsonResult;
                    }
                    else
                    {
                        objJsonResult.code = "0";
                        objJsonResult.count = 0;
                        objJsonResult.Message = "审核工种失败！" + sErrMsg;
                        objJsonResult.data = null;
                        return objJsonResult;
                    }
                }
                else if (IsAudit == 1)  //反审核判断
                {
                    if (oBill.AbandonCheckByHItemID(HItemID, HMaker, ref sErrMsg))
                    {
                        objJsonResult.code = "1";
                        objJsonResult.count = 1;
                        objJsonResult.Message = "反审核工种成功！";
                        objJsonResult.data = null;
                        return objJsonResult;
                    }
                    else
                    {
                        objJsonResult.code = "0";
                        objJsonResult.count = 0;
                        objJsonResult.Message = "反审核工种失败！" + sErrMsg;
                        objJsonResult.data = null;
                        return objJsonResult;
                    }
                }
                else
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "审核/反审核功能判断错误！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "审核或反审核工种失败！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #endregion

        #region 工种禁用、反禁用
        /// <summary>
        /// 禁用、反禁用工种
        /// </summary>
        /// <param name="HItemID">内码</param>
        /// <param name="IsStop">禁用(0),反禁用(1)</param>
        /// <param name="HMaker">操作人</param>
        /// <returns></returns>
        [Route("Gy_WorkTypeController/GetGy_WorkType_Stop_Json")]
        [HttpGet]
        public object GetGy_WorkType_Stop_Json(Int64 HItemID, int IsStop, string HMaker)
        {
            string sErrMsg = "";
            try
            {
                //判断权限
                if (!DBUtility.ClsPub.Security_Log(ModRightNameClose, 1, false, HMaker))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "您没有该模块禁用/反禁用功能权限,请与管理员联系！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                if (IsStop == 0)   //禁用判断
                {
                    if (oBill.StopByHItemID(HItemID, HMaker, ref sErrMsg))
                    {
                        objJsonResult.code = "1";
                        objJsonResult.count = 1;
                        objJsonResult.Message = "禁用工种成功！";
                        objJsonResult.data = null;
                        return objJsonResult;
                    }
                    else
                    {
                        objJsonResult.code = "0";
                        objJsonResult.count = 0;
                        objJsonResult.Message = "禁用工种失败！" + sErrMsg;
                        objJsonResult.data = null;
                        return objJsonResult;
                    }
                }
                else if (IsStop == 1)  //反禁用判断
                {
                    if (oBill.AbandonStopByHItemID(HItemID, HMaker, ref sErrMsg))
                    {
                        objJsonResult.code = "1";
                        objJsonResult.count = 1;
                        objJsonResult.Message = "反禁用工种成功！";
                        objJsonResult.data = null;
                        return objJsonResult;
                    }
                    else
                    {
                        objJsonResult.code = "0";
                        objJsonResult.count = 0;
                        objJsonResult.Message = "反禁用工种失败！" + sErrMsg;
                        objJsonResult.data = null;
                        return objJsonResult;
                    }
                }
                else
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "禁用/反禁用功能判断错误！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "禁用或反禁用工种失败！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #endregion

        #region 工种保存
        /// <summary>
        /// 工种保存
        /// </summary>
        [Route("Gy_WorkTypeController/GetGy_WorkType_Save_Json")]
        [HttpPost]
        public object GetGy_WorkType_Save_Json([FromBody] JObject oMain)
        {
            try
            {
                var _value = oMain["oMain"].ToString();
                string msg1 = _value.ToString();
                string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
                string msg2 = sArray[0].ToString();
                string HMaker = sArray[1].ToString();
                string OperationType = sArray[2].ToString();    //操作类型（1新增、2编辑）

                //判断权限
                if (OperationType == "1")
                {
                    //判断新增权限
                    if (!DBUtility.ClsPub.Security_Log(ModRightNameAdd, 1, false, HMaker))
                    {
                        objJsonResult.code = "0";
                        objJsonResult.count = 0;
                        objJsonResult.Message = "您没有该模块新增权限,请与管理员联系！";
                        objJsonResult.data = null;
                        return objJsonResult;
                    }
                }
                else
                {
                    //判断编辑权限
                    if (!DBUtility.ClsPub.Security_Log(ModRightNameEdit, 1, false, HMaker))
                    {
                        objJsonResult.code = "0";
                        objJsonResult.count = 0;
                        objJsonResult.Message = "您没有该模块编辑权限,请与管理员联系！";
                        objJsonResult.data = null;
                        return objJsonResult;
                    }
                }

                //反序列化
                msg2 = msg2.Replace("\\", "");
                msg2 = msg2.Replace("\n", "");
                msg2 = "[" + msg2.ToString() + "]";
                List<Model.ClsGy_WorkType_Model> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsGy_WorkType_Model>>(msg2);
                oBill.oModel.HItemID = list[0].HItemID;
                oBill.oModel.HNumber = list[0].HNumber;
                oBill.oModel.HName = list[0].HName;
                oBill.oModel.HShortNumber = DBUtility.ClsPub.GetShortNumber(list[0].HNumber);
                oBill.oModel.HLevel = DBUtility.ClsPub.GetLevel(list[0].HNumber);
                oBill.oModel.HEndFlag = true;
                oBill.oModel.HStopflag = list[0].HStopflag;
                oBill.oModel.HUseFlag = list[0].HUseFlag;
                oBill.oModel.HRemark = list[0].HRemark;
                oBill.oModel.HMakeEmp = HMaker;
                oBill.oModel.HModifyEmp = HMaker;
                oBill.oModel.HCheckEmp = list[0].HCheckEmp;
                oBill.oModel.HUSEORGID = list[0].HUSEORGID;
                oBill.oModel.HCREATEORGID = list[0].HUSEORGID;
                //
                oBill.oModel.HPayMoney = list[0].HPayMoney;
                oBill.oModel.HDayMoney = list[0].HDayMoney;
                oBill.oModel.HForEmp = list[0].HForEmp;

                //检查父级是否存在
                string sParent = DBUtility.ClsPub.GetParentCode(list[0].HNumber);
                if (sParent.Trim() == "")
                {
                    oBill.oModel.HParentID = 0;
                }
                else
                {
                    ds = oCn.RunProcReturn("select * from " + ModRightName + " where HStopflag=0 and HNumber='" + sParent + "' and HItemID<>" + oBill.oModel.HItemID, ModRightName);
                    if (ds.Tables[0].Rows.Count > 0)
                    {
                        oBill.oModel.HParentID = long.Parse(ds.Tables[0].Rows[0]["HItemID"].ToString());
                    }
                    else
                    {
                        objJsonResult.code = "0";
                        objJsonResult.count = 0;
                        objJsonResult.Message = "保存失败！上级代码不存在或被禁用！";
                        objJsonResult.data = null;
                        return objJsonResult;
                    }
                }
                //保存原代码

                DataSet dsOldNumber = oCn.RunProcReturn("select * from " + ModRightName + " where HItemID='" + oBill.oModel.HItemID + "'", ModRightName);
                if (dsOldNumber.Tables[0].Rows.Count > 0)
                {
                    oBill.HOldNumber = DBUtility.ClsPub.isStrNull(dsOldNumber.Tables[0].Rows[0]["HNumber"]);
                    //是否新代码是自己子项目的　子项目
                    if (sParent.Length >= oBill.HOldNumber.Length)
                    {
                        if (sParent.Substring(0, oBill.HOldNumber.ToString().Length) == oBill.HOldNumber.Trim())
                        {
                            objJsonResult.code = "0";
                            objJsonResult.count = 0;
                            objJsonResult.Message = "新代码不能是自己的下级的子项目！";
                            objJsonResult.data = null;
                            return objJsonResult;
                        }
                    }
                }
                else
                {
                    oBill.HOldNumber = "";
                }

                //保存前判断
                //审核代码是否合理
                if (!DBUtility.ClsPub.AllowNumber(oBill.oModel.HNumber))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "代码中不能出现连续‘.’并且首位末位不能为‘.’！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                //是否重复代码
                if (oBill.HavSameNumber(oBill.oModel.HItemID, oBill.oModel.HNumber))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "代码重复！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                //保存
                if (OperationType == "1")
                {
                    //新增
                    if (oBill.AddNew())
                    {
                        objJsonResult.code = "1";
                        objJsonResult.count = 1;
                        objJsonResult.Message = "新增成功！";
                        objJsonResult.data = null;
                        return objJsonResult;
                    }
                    else
                    {
                        objJsonResult.code = "0";
                        objJsonResult.count = 0;
                        objJsonResult.Message = "新增失败！";
                        objJsonResult.data = null;
                        return objJsonResult;
                    }
                }
                else
                {
                    if(oBill.oModel.HCheckEmp!="")
                    {
                        objJsonResult.code = "0";
                        objJsonResult.count = 0;
                        objJsonResult.Message = "单据已审核，不允许修改！";
                        objJsonResult.data = null;
                        return objJsonResult;
                    }
                    //修改
                    if (oBill.ModifyByID(oBill.oModel.HItemID))
                    {
                        objJsonResult.code = "1";
                        objJsonResult.count = 1;
                        objJsonResult.Message = "修改成功！";
                        objJsonResult.data = null;
                        return objJsonResult;
                    }
                    else
                    {
                        objJsonResult.code = "0";
                        objJsonResult.count = 0;
                        objJsonResult.Message = "修改失败！";
                        objJsonResult.data = null;
                        return objJsonResult;
                    }
                }
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "保存失败！" + e.Message;
                objJsonResult.data = null;
                return objJsonResult;
            }
        }

        #endregion

        #region 显示工种信息
        /// <summary>
        /// 根据基础资料ID 查找记录
        /// </summary>
        [Route("Gy_WorkTypeController/GetGy_WorkType_Json")]
        [HttpGet]
        public object GetGy_WorkType_Json(Int64 HItemID)
        {
            try
            {
                ds = oCn.RunProcReturn("select * from h_v_Gy_WorkTypeListDetail where HItemID=" + HItemID, "h_v_Gy_WorkTypeListDetail");
                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 = "成功！";
                    objJsonResult.data = ds.Tables[0];
                    return objJsonResult;
                }
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "返回工种信息失败！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }

        #endregion

        #region 工种 文件导入保存
        #region 工种 文件上传
        [Route("Gy_WorkTypeController/Gy_WorkTypeController_Excel")]
        [HttpPost]
        public object Gy_WorkTypeController_Excel()
        {
            try
            {
                //获取文件名称
                var file = HttpContext.Current.Request.Files[0];
                //获取文件物理路径
                string ExcelPath = HttpContext.Current.Server.MapPath("~/" + file.FileName);
                //保存文件
                file.SaveAs(ExcelPath);

                NpoiHelper np = new NpoiHelper();
                DataSet ExcelDs = np.ReadExcel(ExcelPath, 1, 1, "0");

                //删除文件
                File.Delete(ExcelPath);

                //创建临时表
                DataTable tb2 = new DataTable("dt2");

                //添加列名
                for (int i = 0; i < ExcelDs.Tables[0].Columns.Count; i++)
                {
                    tb2.Columns.Add(ExcelDs.Tables[0].Rows[0][i].ToString());
                }

                //模板缺少列 但需要从数据库中查询出来显示在页面的字段
                tb2.Columns.Add("HOrgID", typeof(Int32));//组织ID

                //添加数据
                for (int i = 1; i < ExcelDs.Tables[0].Rows.Count; i++)
                {
                    DataRow row = tb2.NewRow();
                    for (int j = 0; j < ExcelDs.Tables[0].Columns.Count; j++)
                    {
                        row[j] = ExcelDs.Tables[0].Rows[i][j].ToString();
                    }
                    tb2.Rows.Add(row);
                }


                var error = "";

                //查询没有的列
                if (!tb2.Columns.Contains("组织代码"))
                    error += "没有找到【组织代码】的标题,";

                if (!tb2.Columns.Contains("组织名称"))
                    error += "没有找到【组织名称】的标题,";

                if (!tb2.Columns.Contains("工种名称"))
                    error += "没有找到【工种名称】的标题,";

                if (!tb2.Columns.Contains("工种代码"))
                    error += "没有找到【工种代码】的标题,";

                if (!tb2.Columns.Contains("日工资"))
                    error += "没有找到【日工资】的标题,";

                if (!tb2.Columns.Contains("小时工资"))
                    error += "没有找到【小时工资】的标题,";

                if (!tb2.Columns.Contains("考虑人数"))
                    error += "没有找到【考虑人数】的标题,";

                if (!tb2.Columns.Contains("备注"))
                    error += "没有找到【备注】的标题,";

                if (!tb2.Columns.Contains("助记码"))
                    error += "没有找到【助记码】的标题,";

                if (error.Length > 0)
                {
                    objJsonResult.code = CodeConstant.FAIL;
                    objJsonResult.count = CountConstant.FAIL;
                    objJsonResult.Message = $"Excel模板存在错误,{error}\r\n";
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                for (int i = 0; i <= tb2.Rows.Count - 1; i++)
                {
                    string HProcessName = "";
                    string HProcessNum = "";
                    string HORGNumber = "";
                    string HORGName = "";


                    HProcessName = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["工种名称"].ToString());
                    HProcessNum = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["工种代码"].ToString());
                    HORGNumber = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["组织代码"].ToString());
                    HORGName = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["组织名称"].ToString());

                    //检查物料
                    int index = i + 1;

                    if (HORGNumber != "")
                    {

                        //查询组织
                        ds = oCn.RunProcReturn("select * from Xt_ORGANIZATIONS where  HNumber='" + HORGNumber + "' and Hname='" + HORGName + "'", "Xt_ORGANIZATIONS");

                        if (ds.Tables[0].Rows.Count == 0)
                        {
                            objJsonResult.code = CodeConstant.FAIL;
                            objJsonResult.count = CountConstant.FAIL;
                            objJsonResult.Message = "第" + index + "行,组织不存在！";
                            objJsonResult.data = null;
                            return objJsonResult;
                        }
                        else
                        {
                            tb2.Rows[i]["HOrgID"] = ds.Tables[0].Rows[0]["HItemID"].ToString();
                        }
                        string HORGid = ds.Tables[0].Rows[0]["HItemID"].ToString();

                        //工种名称
                        if (HProcessName == "")
                        {
                            objJsonResult.code = CodeConstant.FAIL;
                            objJsonResult.count = CountConstant.FAIL;
                            objJsonResult.Message = "第" + index + "行,工种名称不能为空！";
                            objJsonResult.data = null;
                            return objJsonResult;
                        }

                        //工种代码
                        if (HProcessNum == "")
                        {
                            objJsonResult.code = CodeConstant.FAIL;
                            objJsonResult.count = CountConstant.FAIL;
                            objJsonResult.Message = "第" + index + "行,工种代码不能为空！";
                            objJsonResult.data = null;
                            return objJsonResult;
                        }
                    }
                    else
                    {
                        objJsonResult.code = CodeConstant.FAIL;
                        objJsonResult.count = CountConstant.FAIL;
                        objJsonResult.Message = "第" + index + "行,组织代码为空";
                        objJsonResult.data = null;
                        return objJsonResult;
                    }
                }

                objJsonResult.code = CodeConstant.SUCCEED;
                objJsonResult.count = CountConstant.SUCCEED;
                objJsonResult.Message = error;
                objJsonResult.data = tb2;
                return objJsonResult;
            }
            catch (Exception e)
            {
                objJsonResult.code = CodeConstant.FAIL;
                objJsonResult.count = CountConstant.FAIL;
                objJsonResult.Message = "Exception！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #endregion

        #region 工种项目 导入(保存)
        [Route("Gy_WorkTypeController/Gy_WorkTypeController_btnSave")]
        [HttpPost]
        public object Gy_WorkTypeController_btnSave([FromBody] JObject sMainSub)
        {
            var _value = sMainSub["sMainSub"].ToString();
            string msg1 = _value.ToString();
            string[] sArray = msg1.Split(new string[] { "&和" }, StringSplitOptions.RemoveEmptyEntries);
            string msg2 = sArray[0].ToString();
            string user = sArray[1].ToString();
            try
            {
                if (!DBUtility.ClsPub.Security_Log("Gy_ErrType_Edit", 1, false, user))
                {
                    objJsonResult.code = CodeConstant.FAIL;
                    objJsonResult.count = CountConstant.FAIL;
                    objJsonResult.Message = "无保存权限！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                List<object> Excel = Newtonsoft.Json.JsonConvert.DeserializeObject<List<object>>(msg2);
                List<Dictionary<string, string>> list = new List<Dictionary<string, string>>();

                foreach (JObject item in Excel)
                {
                    Dictionary<string, string> dic = new Dictionary<string, string>();
                    foreach (var itm in item.Properties())
                    {
                        dic.Add(itm.Name, itm.Value.ToString());
                    }
                    list.Add(dic);
                }

                oCn.BeginTran();
                int i = 1;
                foreach (Dictionary<string, string> item in list)
                {
                    string HOrgID = item["HOrgID"].ToString();//组织ID
                    string HName = item["工种名称"].ToString();
                    string HNumber = item["工种代码"].ToString();
                    string HRemark = item["备注"].ToString();
                    string HHelpCode = item["助记码"].ToString();
                    string HPayMoney = item["小时工资"].ToString();
                    string HDayMoney = item["日工资"].ToString();
                    string HForEmp = item["考虑人数"].ToString();
                    string sShortNumber;
                    sShortNumber = DBUtility.ClsPub.GetShortNumber(HNumber);//短代码
                    if (sShortNumber.Trim() == "")
                    {
                        objJsonResult.code = CodeConstant.FAIL;
                        objJsonResult.count = CountConstant.FAIL;
                        objJsonResult.Message = "保存失败！短代码为空！";
                        objJsonResult.data = 1;
                        return objJsonResult;
                    }
                    int HEndFlag = 1;//末级标志
                    int HLevel = DBUtility.ClsPub.GetLevel(HNumber); //等级


                    if (!DBUtility.ClsPub.AllowNumber(HNumber.Trim()))
                    {
                        objJsonResult.code = CodeConstant.FAIL;
                        objJsonResult.count = CountConstant.FAIL;
                        objJsonResult.Message = "保存失败！代码中不能出现连续‘.’并且首位末位不能为‘.’！";
                        objJsonResult.data = 1;
                        return objJsonResult;
                    }

                    ds = oCn.RunProcReturn("select * from Gy_WorkType where HNumber='" + HNumber + "'", "Gy_WorkTypeController");

                    if (ds.Tables[0].Rows.Count == 0)
                    {
                        oCn.RunProc("Insert into " + "Gy_WorkType" +
                        " (HNumber,HName,HHelpCode,HShortNumber,HParentID" +
                        ",HLevel,HEndFlag,HStopflag,HRemark" +
                        ",HMakeEmp,HMakeTime,HUSEORGID,HCREATEORGID" +
                        ",HPayMoney,HDayMoney,HForEmp) " +
                        " Values('" + HNumber + "','" + HName + "','" + HHelpCode + "','" + sShortNumber + "'," + 0 +
                        "," + HLevel + "," + HEndFlag + "," + 0 + ",'" + HRemark + "'" +
                        ",'" + user + "',getdate()" + "," + HOrgID + "," + HOrgID +
                        "," + HPayMoney + "," + HDayMoney + ",'" + HForEmp + "'" +
                        ")");
                    }
                    else
                    {
                        oCn.RunProc("Update " + "Gy_WorkType " + " set " +
                        "HName='" + HName + "'" +
                        ",HShortNumber='" + sShortNumber + "'" +
                        ",HRemark= '" + HRemark + "'" +
                        ",HModifyEmp= '" + user + "'" +
                        ",HModifyTime=getdate()" +
                        ",HUSEORGID=" + HOrgID +
                        ",HPayMoney=" + HPayMoney +
                        ",HDayMoney=" + HDayMoney +
                        ",HForEmp='" + HForEmp + "'" +
                        " where HNumber='" + HNumber + "'");
                    }

                    i++;
                }

                oCn.Commit();

                objJsonResult.code = CodeConstant.SUCCEED;
                objJsonResult.count = CountConstant.SUCCEED;
                objJsonResult.Message = "导入成功!";
                objJsonResult.data = null;
                return objJsonResult;
            }
            catch (Exception e)
            {
                LogService.Write(e);
                objJsonResult.code = CodeConstant.FAIL;
                objJsonResult.count = CountConstant.FAIL;
                objJsonResult.Message = "Exception！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #endregion
        #endregion

    }
}