1

沈泽

2021-09-22 ce0f27009ef4b09008381b9edf4871e94aaadd23

 WebAPI/Controllers/MJGL/Sc_MouldMoveStockStepOutBillController.cs

@@ -65,278 +65,342 @@
            return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldOtherOutBillList ", "h_v_Sc_MouldOtherOutBillList");
        }
        #endregion
        #region[模具领用单编辑时获取表头数据]
        [Route("Sc_MouldMoveStockStepOutBill/Sc_MouldMoveStockStepOutBillListCheckDetai")]
        [HttpGet]
        public ApiResult<DataSet> Sc_MouldMoveStockStepOutBillListCheckDetai(string HID)
        {
            if (string.IsNullOrEmpty(HID))
                return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };
            SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();

//        #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();
            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[模具领用单编辑时获取表体数据]
        [Route("Sc_MouldMoveStockStepOutBill/Sc_MouldMoveStockStepOutBillListCheckDetai")]
        [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_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();


//            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
        //            {
        //                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";

//                    //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.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.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_Sc_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;
        //                    //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 = "";//备注

//                    oBill.DetailColl.Add(oItemSub);
        //                    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_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;
        //            //}


//            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;
        //            }
        //            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;
        //                }

//                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
        //                {
        //                    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

//        #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
        //        #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





      


    }
}