1
沈泽
2021-10-12 4ce845ec79f717ac4669ce3e39eaa0cb7323b1ad
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,16 +7,81 @@
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 器具分布式调出单据列表
        [Route("Sc_MouldMoveStockStepOutBill/GetMouldMoveStockStepOutBillList")]
        #region 器具分布式调出单
        #region 器具分布式调出单列表
        [Route("Sc_MouldMoveStockStepOutBill/GetMouldMoveStockStepOutBill")]
        [HttpGet]
        public object GetMouldMoveStockStepOutBill(string sWhere)
        {
@@ -56,16 +122,7 @@
        #endregion
        #region sql语句
        public static DataSet Sc_MouldOtherOutBillList_s(string sWhere)
        {
            return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldOtherOutBillList ", "h_v_Sc_MouldOtherOutBillList");
        }
        #endregion
        #region[模具领用单编辑时获取表头数据]
        #region[器具分布式调出单编辑时获取表头数据]
        [Route("Sc_MouldMoveStockStepOutBill/Sc_MouldMoveStockStepOutBillListCheckDetai")]
        [HttpGet]
        public ApiResult<DataSet> Sc_MouldMoveStockStepOutBillListCheckDetai(string HID)
@@ -82,8 +139,8 @@
        }
        #endregion
        #region[模具领用单编辑时获取表体数据]
        [Route("Sc_MouldMoveStockStepOutBill/Sc_MouldMoveStockStepOutBillListCheckDetai")]
        #region[器具分布式调出单编辑时获取表体数据]
        [Route("Sc_MouldMoveStockStepOutBill/Sc_MouldMoveStockStepOutBillListProjectDetai")]
        [HttpGet]
        public object Sc_MouldMoveStockStepOutBillListProjectDetai(string sqlWhere)
        {
@@ -130,277 +187,225 @@
            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();
        #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