器具档案保存报错修复

YL

2021-10-09 51e0d69d916695c04ccc88b44d16047a3efcd1a9

 WebAPI/Controllers/MJGL/Sc_MouldMoveStockStepOutBillController.cs

@@ -1,4 +1,5 @@
using Newtonsoft.Json.Linq;
using Pub_Class;
using System;
using System.Collections.Generic;
using System.Data;
@@ -6,14 +7,79 @@
using WebAPI.Models;
namespace WebAPI.Controllers
{
    /**
     * 找货单单
     */
    public class Sc_MouldMoveStockStepOutBillController : ApiController
    {
        public DBUtility.ClsPub.Enum_BillStatus BillStatus;//单据状态（新增，修改，浏览，更新单价，变更）

        private json objJsonResult = new json();
        public DataSet ds = new DataSet();
        public WebServer webserver = new WebServer();

        public DAL.ClsSc_MouldScrapInBill BillNew0 = new DAL.ClsSc_MouldScrapInBill();   //模具报废入库对应单据类
        public DAL.ClsSc_MouldScrapInBill BillOld0 = new DAL.ClsSc_MouldScrapInBill();   //模具报废入库对应单据类


        /// <summary>
        /// 根据包装单 返回此包装单内的相关信息
        /// </summary>
        /// <returns></returns>

        /// <summary>
        /// 检具维修工单列表
        /// </summary>
        /// <returns></returns>
        [Route("Sc_CheckToolsRepair/GetCheckToolsRepairWorkBillList")]
        [HttpGet]
        public object GetCheckToolsRepairWorkBillList(string sWhere)
        {
            try
            {

                ds = Sc_CheckToolsRepairWorkBillList_s(sWhere);
                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 ex)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "没有返回任何记录！" + ex.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }

        #region sql语句


        public static DataSet Sc_CheckToolsRepairWorkBillList_s(string sWhere)
        {
            return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_CheckToolsRepairWorkBillList ", "h_v_Sc_CheckToolsRepairWorkBillList");
        }



        #region 器具分布式调出单据列表

        #region 器具分布式调出单

        #region 器具分布式调出单列表

        [Route("Sc_MouldMoveStockStepOutBill/GetMouldMoveStockStepOutBill")]
        [HttpGet]
@@ -56,287 +122,290 @@

        #endregion

     
        #region sql语句


        public static DataSet Sc_MouldOtherOutBillList_s(string sWhere)
        #region[器具分布式调出单编辑时获取表头数据]
        [Route("Sc_MouldMoveStockStepOutBill/Sc_MouldMoveStockStepOutBillListCheckDetai")]
        [HttpGet]
        public ApiResult<DataSet> Sc_MouldMoveStockStepOutBillListCheckDetai(string HID)
        {
            return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldOtherOutBillList ", "h_v_Sc_MouldOtherOutBillList");
            if (string.IsNullOrEmpty(HID))
                return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };
            SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();

            var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Sc_MouldMoveStockStepOutBill  where hmainid= " + HID + " ", "h_v_Sc_MouldMoveStockStepOutBill");
            if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
                return new ApiResult<DataSet> { code = -1, msg = "不存在退库单号" };

            return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
        }
        #endregion

//        #region 模治具其他出库单 保存/编辑
//        /// <summary>
//        /// 保存模具维修单
//        /// </summary>
//        /// <param name="msg"></param>
//        /// <returns></returns>
//        [Route("Sc_MouldOtherOutBill/SaveMouldOtherOutBillList")]
//        [HttpPost]
//        public object SaveMouldOtherOutBillList([FromBody] JObject msg)
//        {
//            var _value = msg["msg"].ToString();
//            string msg1 = _value.ToString();
//            string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
//            string msg2 = sArray[0].ToString();
//            string msg3 = sArray[1].ToString();
        #region[器具分布式调出单编辑时获取表体数据]
        [Route("Sc_MouldMoveStockStepOutBill/Sc_MouldMoveStockStepOutBillListProjectDetai")]
        [HttpGet]
        public object Sc_MouldMoveStockStepOutBillListProjectDetai(string sqlWhere)
        {
            DataSet ds;
            try
            {
                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
                if (sqlWhere == null || sqlWhere.Equals(""))
                {
                    ds = oCN.RunProcReturn(string.Format(@"SELECT HMaterID,模具代码 HMaterCode,模具名称 HMaterName,规格型号 HMaterSpec,批次 HBatchNo,
                                                设计寿命 HDesignLife, 剩余寿命 HLeaveLife, 累积使用寿命 HUseLife, 应发数量 HQtyMust, 实发数量 HQty, 
                                                单价 HPrice, 金额 HMoney,HWHSonID HWHID, 发料仓库代码 HWHCode, 发料仓库 HWHName,HSPID, 
                                                仓位代码 HSPCode, 仓位 HSPName,表体备注 HRemark FROM h_v_Sc_MouldMoveStockStepOutBill"), "h_v_Sc_MouldMoveStockStepOutBill");

                    objJsonResult.code = "0";
                    objJsonResult.count = 1;
                    objJsonResult.Message = "获取信息成功！";
                    objJsonResult.data = ds.Tables[0];
                }
                else
                {

                    //string sql1 = "select HRepairCheckID,HRepairCheckContent,HManagerID,HRemark  from Sc_MouldRepairCheckBillSub where 1 = 1 ";
                    string sql1 = string.Format(@"SELECT HMaterID,模具代码 HMaterCode,模具名称 HMaterName,规格型号 HMaterSpec,批次 HBatchNo,
                                                设计寿命 HDesignLife, 剩余寿命 HLeaveLife, 累积使用寿命 HUseLife, 应发数量 HQtyMust, 实发数量 HQty, 
                                                单价 HPrice, 金额 HMoney,HWHSonID HWHID, 发料仓库代码 HWHCode, 发料仓库 HWHName,HSPID, 
                                                仓位代码 HSPCode, 仓位 HSPName,表体备注 HRemark FROM h_v_Sc_MouldMoveStockStepOutBill where 1 = 1 ");
                    string sql = sql1 + sqlWhere;
                    ds = oCN.RunProcReturn(sql, "h_v_Sc_MouldMoveStockStepOutBill");

                    objJsonResult.code = "0";
                    objJsonResult.count = 1;
                    objJsonResult.Message = "获取信息成功！";
                    objJsonResult.data = ds.Tables[0];
                }
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "没有返回任何记录！" + e.ToString();
                objJsonResult.data = null;
            }
            return objJsonResult;
        }
        #endregion

        #region 器具分布式调出单保存/编辑
        /// <summary>
        /// 保存模具领用单
        /// </summary>
        /// <param name="msg"></param>
        /// <returns></returns>
        [Route("Sc_MouldMoveStockStepOutBill/SaveGetMouldMoveStockStepOutBillList")]
        [HttpPost]
        public object SaveGetMouldMoveStockStepOutBillList([FromBody] JObject msg)
        {
            var _value = msg["msg"].ToString();
            string msg1 = _value.ToString();
            string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
            string msg2 = sArray[0].ToString();
            string msg3 = sArray[1].ToString();


//            string UserName = "";
//            ListModels oListModels = new ListModels();
//            try
//            {
//                DAL.ClsSc_MouldOtherOutBill oBill = new DAL.ClsSc_MouldOtherOutBill();
//                List<Model.ClsSc_MouldStockBillMain> lsmain = new List<Model.ClsSc_MouldStockBillMain>();
//                msg2 = msg2.Replace("\\", "");
//                msg2 = msg2.Replace("\n", "");  //\n
//                lsmain = oListModels.getObjectByJson_Sc_MouldStockBillMain(msg2);
//                foreach (Model.ClsSc_MouldStockBillMain oItem in lsmain)
//                {
//                    //oItem.HMaker = "";
//                    UserName = oItem.HMaker;  //制单人
//                    oItem.HBillType = "3828";
//                    oItem.HBillSubType = "3828";
            string UserName = "";
            ListModels oListModels = new ListModels();
            try
            {
                DLL.ClsSc_MouldMoveStockStepOutBill oBill = new DLL.ClsSc_MouldMoveStockStepOutBill();
                List<Model.ClsSc_MouldMoveStockStepOutBillMain> lsmain = new List<Model.ClsSc_MouldMoveStockStepOutBillMain>();
                msg2 = msg2.Replace("\\", "");
                msg2 = msg2.Replace("\n", "");  //\n
                lsmain = oListModels.getObjectByJson_Gy_MouldMoveStockStepOutBillMain(msg2);
                foreach (Model.ClsSc_MouldMoveStockStepOutBillMain oItem in lsmain)
                {
                    //oItem.HMaker = "";
                    UserName = oItem.HMaker;  //制单人
                    oItem.HBillType = "3841";
                    oItem.HBillSubType = "3841";
                    //oItem.HBillNo = "";    //单据号
                    //oItem.HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd"));//  --日期
                    //oItem.HInnerBillNo = "";  //  --内部单据号
                    oItem.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year);
                    oItem.HMakeDate = DBUtility.ClsPub.isStrNull(DateTime.Now.ToString("yyyy-MM-dd"));
                    //oItem.HEquipID = 0;    //设备ID(Gy_EquipMent)
                    //oItem.HPeriod = 0;
                    //oItem.HCheckBeginDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd"));  //  --维修日期
                    //oItem.HCheckResult = "";     //验收结论--(正常，异常)
                    //oItem.HEmpID = 0;           //验收人(Gy_Employee)
                    //oItem.HManagerID = 0;      //负责人(Gy_Employee)
                    //oItem.HDeptID = 0;        //验收部门(Gy_Department)
                    //oItem.HExplanation = "";  //摘要(故障描述)  
                    //oItem.HRemark = "";       //备注

//                    //oItem.HInterID =0;
//                    //oItem.HBillNo = "";
//                    oItem.HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd"));//  --日期
//                    oItem.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year);
//                    //oItem.HMakeDate = "";
//                    //oItem.HYear = "";
//                    //oItem.HPeriod = "";
//                    //oItem.HRemark = "";
//                    //oItem.HCycleUnit = "";
//                    //oItem.HCheckCycle = "";
//                    //oItem.HBeginDate = "";
//                    //oItem.HEndDate = "";
//                    //oItem.HInnerBillNo = "";
//                    //oItem.HExplanation = "";
                    //oItem.HMainSourceInterID = oItem.HInterID;

//                    //oItem.HInterID = DBUtility.ClsPub.CreateBillID_SRMProd("1103", ref DBUtility.ClsPub.sExeReturnInfo);
//                    if (DBUtility.ClsPub.isStrNull(oItem.HDate) == "")
//                    {
//                        objJsonResult.code = "0";
//                        objJsonResult.count = 0;
//                        objJsonResult.Message = "保存失败！没有单据日期，无法保存！";
//                        objJsonResult.data = 1;
//                        return objJsonResult;
//                    }
//                    oBill.omodel = oItem;
//                }
//                //表体数据
//                //按 },{来拆分数组 //去掉【和】
//                msg3 = msg3.Substring(1, msg3.Length - 2);
//                msg3 = msg3.Replace("\\", "");
//                msg3 = msg3.Replace("\n", "");  //\n
//                //msg2 = msg2.Replace("'", "’");
//                List<Model.ClsSc_MouldStockBillSub> ls = new List<Model.ClsSc_MouldStockBillSub>();
//                ls = oListModels.getObjectByJson_Sc_MouldStockBillSub(msg3);
//                int i = 0;
//                foreach (Model.ClsSc_MouldStockBillSub oItemSub in ls)
//                {
                    //oItem.HInterID = DBUtility.ClsPub.CreateBillID_SRMProd("1103", ref DBUtility.ClsPub.sExeReturnInfo);
                    if (DBUtility.ClsPub.isStrNull(oItem.HDate) == "")
                    {
                        objJsonResult.code = "0";
                        objJsonResult.count = 0;
                        objJsonResult.Message = "保存失败！没有单据日期，无法保存！";
                        objJsonResult.data = 1;
                        return objJsonResult;
                    }
                    oBill.omodel = oItem;
                }
                //表体数据
                //按 },{来拆分数组 //去掉【和】
                msg3 = msg3.Substring(1, msg3.Length - 2);
                msg3 = msg3.Replace("\\", "");
                msg3 = msg3.Replace("\n", "");  //\n
                //msg2 = msg2.Replace("'", "’");
                List<Model.ClsSc_MouldStockBillSub> ls = new List<Model.ClsSc_MouldStockBillSub>();
                ls = oListModels.getObjectByJson_Gy_MouldStockBillSub(msg3);
                int i = 0;
                foreach (Model.ClsSc_MouldStockBillSub oItemSub in ls)
                {

//                    i++;
//                    oItemSub.HEntryID = i;
//                    //oItemSub.HCloseMan = "";       //行关闭
//                    oItemSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now);
//                    oItemSub.HCloseType = false;   //关闭类型
//                    //oItemSub.HRemark = "";         //备注
//                    oItemSub.HSourceInterID = 0;     // 源单主内码
//                    oItemSub.HSourceEntryID = 0;   //源单子内码
//                    //oItemSub.HSourceBillNo = "";  //源单单号
//                    //oItemSub.HSourceBillType = ""; //源单类型
//                    oItemSub.HRelationQty = 0;     //关联数量
//                                                   //oItemSub.HRelationMoney = 0;   //关联金额
//                                                   //HMaterID = "";//配件代码
//                                                   //HUnitID = "";//单位代码
//                                                   //HQty = "";//实际用量
//                                                   //HQtyMust = "";//单位用量
//                                                   //HRemark = "";//备注
                    i++;
                    oItemSub.HEntryID = i;

//                    oBill.DetailColl.Add(oItemSub);
                    //oItemSub.HRepairCheckID = 0;   //验收项目ID
                    //oItemSub.HRepairCheckContent = ""; //验收内容
                    //oItemSub.HManagerID = 0;   //负责人ID
                    //oItemSub.HCloseMan = "";       //行关闭
                    oItemSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now);
                    oItemSub.HCloseType = false;   //关闭类型
                    //oItemSub.HRemark = "";         //备注
                    oItemSub.HSourceInterID = 0;     // 源单主内码
                    oItemSub.HSourceEntryID = 0;   //源单子内码
                    //oItemSub.HSourceBillNo = "";  //源单单号
                    //oItemSub.HSourceBillType = ""; //源单类型
                    //oItemSub.HRelationQty = 0;     //关联数量
                    //oItemSub.HRelationMoney = 0;   //关联金额 
                    //oItemSub.HRepairID = 0;       //维修项目
                    //oItemSub.HRepairExplanation ="";   //维修要求
                    //oItemSub.HMoney = 0;        //维修费用
                    oBill.DetailColl.Add(oItemSub);

//                }
//                //保存
//                //保存完毕后处理
//                bool bResult;
//                if (oBill.omodel.HInterID == 0)
//                {
//                    // bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
//                    bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
//                }
//                else
//                {
//                    bResult = oBill.ModifyBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo);
//                }
//                if (bResult)
//                {
//                    objJsonResult.code = "0";
//                    objJsonResult.count = 1;
//                    objJsonResult.Message = "保存成功！";
//                    //WebAPIController.Add_Log("送货单下推", UserName, "生成送货单");
//                    objJsonResult.data = 1;
//                    return objJsonResult;
//                }
//                else
//                {
//                    objJsonResult.code = "0";
//                    objJsonResult.count = 0;
//                    objJsonResult.Message = "保存失败！" + DBUtility.ClsPub.sExeReturnInfo;
//                    objJsonResult.data = 1;
//                    return objJsonResult;
//                }
//            }
//            catch (Exception e)
//            {
//                objJsonResult.code = "0";
//                objJsonResult.count = 0;
//                objJsonResult.Message = "保存失败！" + e.ToString();
//                objJsonResult.data = 1;
//                return objJsonResult;
//            }
//        }
//        #endregion
//        #region [模治具其他出库单删除功能]
//        /// <summary>
//        /// 模具维修单删除功能
//        /// </summary>
//        /// <returns></returns>
//        [Route("Sc_MouldOtherOutBill/DeltetMouldOtherOutBillList")]
//        [HttpGet]
//        public object DeltetMouldOtherOutBillList(string HInterID)
//        {
//            //编辑权限
//            //if (!DBUtility.ClsPub.Security_Log("Sb_MouldRepairWorkBill_Delete", 1, true, DBUtility.ClsPub.CurUserName))
//            //{
//            //    objJsonResult.code = "0";
//            //    objJsonResult.count = 0;
//            //    objJsonResult.Message = "无删除权限！";
//            //    objJsonResult.data = null;
//            //    return objJsonResult;
//            //}
                }
                //保存
                //保存完毕后处理
                bool bResult;
                if (oBill.omodel.HInterID == 0)
                {
                    // bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
                    bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
                }
                else
                {
                    bResult = oBill.ModifyBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo);
                }
                if (bResult)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 1;
                    objJsonResult.Message = "保存成功！";
                    //WebAPIController.Add_Log("送货单下推", UserName, "生成送货单");
                    objJsonResult.data = 1;
                    return objJsonResult;
                }
                else
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "保存失败！" + DBUtility.ClsPub.sExeReturnInfo;
                    objJsonResult.data = 1;
                    return objJsonResult;
                }
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "保存失败！" + e.ToString();
                objJsonResult.data = 1;
                return objJsonResult;
            }
        }
        #endregion

        #region [器具分布式调入单删除功能]
        /// <summary>
        /// 模具处理领用单删除功能
        /// </summary>
        /// <returns></returns>
        [Route("Sc_MouldMoveStockStepOutBill/DeltetMouldMoveStockStepOutBil")]
        [HttpGet]
        public object DeltetMouldMoveStockStepOutBil(string HInterID)
        {
            //编辑权限
            //if (!DBUtility.ClsPub.Security_Log("Sc_MouldProdBackBill_Delete", 1, true, DBUtility.ClsPub.CurUserName))
            //{
            //    objJsonResult.code = "0";
            //    objJsonResult.count = 0;
            //    objJsonResult.Message = "无删除权限！";
            //    objJsonResult.data = null;
            //    return objJsonResult;
            //}


//            Int64 lngBillKey = 0;
//            lngBillKey = DBUtility.ClsPub.isLong(HInterID);
//            if (lngBillKey == 0)
//            {
//                objJsonResult.code = "0";
//                objJsonResult.count = 0;
//                objJsonResult.Message = "单据ID为空！";
//                objJsonResult.data = null;
//                return objJsonResult;
//            }
//            DAL.ClsSc_MouldOtherOutBill oBill = new DAL.ClsSc_MouldOtherOutBill();
//            if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo))
//            {
//                if (oBill.omodel.HBillStatus > 1)
//                {
//                    objJsonResult.code = "0";
//                    objJsonResult.count = 0;
//                    objJsonResult.Message = "单据当前处于不能删除状态,不能删除！";
//                    objJsonResult.data = null;
//                    return objJsonResult;
//                }
//                if (oBill.omodel.HChecker != "")
//                {
//                    objJsonResult.code = "0";
//                    objJsonResult.count = 0;
//                    objJsonResult.Message = "单据已经审核,不能删除！";
//                    objJsonResult.data = null;
//                    return objJsonResult;
//                }
            Int64 lngBillKey = 0;
            lngBillKey = DBUtility.ClsPub.isLong(HInterID);
            if (lngBillKey == 0)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "单据ID为空！";
                objJsonResult.data = null;
                return objJsonResult;
            }
            DLL.ClsSc_MouldMoveStockStepOutBill oBill = new DLL.ClsSc_MouldMoveStockStepOutBill();
            if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo))
            {
                if (oBill.omodel.HBillStatus > 1)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "单据当前处于不能删除状态,不能删除！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                if (oBill.omodel.HChecker != "")
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "单据已经审核,不能删除！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }

//                bool IsDete = oBill.DeleteBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo);
//                if (IsDete)
//                {
//                    objJsonResult.code = "0";
//                    objJsonResult.count = 1;
//                    objJsonResult.Message = DBUtility.ClsPub.sExeReturnInfo;
//                    objJsonResult.data = null;
//                    return objJsonResult;
//                }
//                else
//                {
//                    objJsonResult.code = "0";
//                    objJsonResult.count = 0;
//                    objJsonResult.Message = DBUtility.ClsPub.sExeReturnInfo;
//                    objJsonResult.data = null;
//                    return objJsonResult;
//                }
//            }
//            else
//            {
//                objJsonResult.code = "0";
//                objJsonResult.count = 0;
//                objJsonResult.Message = "单据未找到";
//                objJsonResult.data = null;
//                return objJsonResult;
//            }
//        }
//        #endregion
                bool IsDete = oBill.DeleteBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo);
                if (IsDete)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 1;
                    objJsonResult.Message = DBUtility.ClsPub.sExeReturnInfo;
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                else
                {

//        #region[模治具其他出库单编辑时获取表头数据]
//        [Route("Sc_MouldOtherOutBill/Sc_MouldOtherOutBillListCheckDetai")]
//        [HttpGet]
//        public ApiResult<DataSet> Sc_MouldOtherOutBillListCheckDetai(string HID)
//        {
//            if (string.IsNullOrEmpty(HID))
//                return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };
//            SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
//            var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Sc_MouldOtherOutBillList  where hmainid= " + HID + " ", "h_v_Sc_MouldOtherOutBillList");
//            if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
//                return new ApiResult<DataSet> { code = -1, msg = "不存在设备保养记录表" };
//            return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
//        }
//        #endregion
//        #region[模治具其他出库单编辑时获取表题数据]
//        [Route("Sc_MouldOtherOutBill/Sc_MouldOtherOutBillListProjectDetai")]
//        [HttpGet]
//        public object Sc_MouldOtherOutBillListProjectDetai(string sqlWhere)
//        {
//            DataSet ds;
//            try
//            {
//                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
//                if (sqlWhere == null || sqlWhere.Equals(""))
//                {
//                    ds = oCN.RunProcReturn(@"select 模具代码 HMaterID,模具名称 HMaterName,规格型号 HMaterSpec ,批次 HBatchNo,设计寿命 HDesignLife,剩余寿命 HLeaveLife,累积使用寿命 HUseLife,实发数量 HQty,单价 HPrice,金额 HMoney,模具仓库代码 HWHID,发货仓库 HWHName,表体备注 HRemark
//from h_v_Sc_MouldOtherOutBillList", "h_v_Sc_MouldOtherOutBillList_Edit");
//                    objJsonResult.code = "0";
//                    objJsonResult.count = 1;
//                    objJsonResult.Message = "获取信息成功！";
//                    objJsonResult.data = ds.Tables[0];
//                }
//                else
//                {
//                    string sql1 = @"select 模具代码 HMaterID,模具名称 HMaterName,规格型号 HMaterSpec ,批次 HBatchNo,设计寿命 HDesignLife,剩余寿命 HLeaveLife,累积使用寿命 HUseLife,实发数量 HQty,单价 HPrice,金额 HMoney,模具仓库代码 HWHID,发货仓库 HWHName,表体备注 HRemark
//from h_v_Sc_MouldOtherOutBillList where 1 = 1 ";
//                    string sql = sql1 + sqlWhere;
//                    ds = oCN.RunProcReturn(sql, "h_v_Sc_MouldOtherOutBillList");
//                    objJsonResult.code = "0";
//                    objJsonResult.count = 1;
//                    objJsonResult.Message = "获取信息成功！";
//                    objJsonResult.data = ds.Tables[0];
//                }
//            }
//            catch (Exception e)
//            {
//                objJsonResult.code = "0";
//                objJsonResult.count = 0;
//                objJsonResult.Message = "没有返回任何计划！" + e.ToString();
//                objJsonResult.data = null;
//            }
//            return objJsonResult;
//        }
//        #endregion
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = DBUtility.ClsPub.sExeReturnInfo;
                    objJsonResult.data = null;
                    return objJsonResult;
                }
            }
            else
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "单据未找到";
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #endregion





      

    }
}
}
#endregion
#endregion