工序单保存后判断是否自动新增。

仲国强

2021-09-17 9a22968dfc75024a852bb0b64dd6a6cb461be80a

 WebAPI/Controllers/Sc_MouldOtherInBillController.cs

@@ -13,7 +13,7 @@
    public class Sc_MouldOtherInBillController : ApiController
    {
        private json objJsonResult = new json();
        public DataSet ds = new DataSet();
        DataSet ds;
        public WebServer webserver = new WebServer();
        SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();

@@ -21,35 +21,23 @@
        /// 根据包装单 返回此包装单内的相关信息
        /// </summary>
        /// <returns></returns>
        /// 

        /// <summary>
        /// 模具其他入库单列表
        /// </summary>
        /// <returns></returns>
           #region 模具其他入库单列表

        [Route("Sc_MouldOtherInBill/GetMouldOtherInBillList")]
        [HttpGet]
        public object GetMouldOtherInBillList(string sWhere)
        public object GetMouldProdOutBill(string sWhere)
        {
            try
            {

                ds = Sc_MouldOtherInBillList_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;
                }
                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = "返回记录成功！";
                objJsonResult.data = ds.Tables[0];
                return objJsonResult;
            }
            catch (Exception ex)
            {
@@ -60,6 +48,107 @@
                return objJsonResult;
            }
        }

        public static DataSet Sc_GetMouldProdOutBill(string sWhere)
        {
            if (sWhere == null || sWhere.Equals(""))
            {
                return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldOtherInBillList ", "h_v_Sc_MouldOtherInBillList");
            }
            else
            {
                string sql1 = "select * from h_v_Sc_MouldOtherInBillList where 1 = 1 ";
                string sql = sql1 + sWhere;
                return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldOtherInBillList");
            }

        }
        #endregion
        ///// <summary>
        ///// 返回模具其他入库单列表
        /////参数：string sql。
        /////返回值：object。
        ///// </summary>
        //[Route("Sc_MouldOtherInBill/GetMouldOtherInBillList")]
        //[HttpGet]
        //public object list(string sWhere)
        //{
        //    try
        //    {
        //        if (sWhere == null || sWhere.Equals(""))
        //        {
        //            ds = oCN.RunProcReturn("select * from Sc_MouldStockBillMain " + sWhere, "Sc_MouldStockBillMain");
        //        }
        //        else
        //        {
        //            string sql1 = "select * from Sc_MouldStockBillMain where 1 = 1 ";
        //            string sql = sql1 + sWhere;
        //            ds = oCN.RunProcReturn(sql, "Sc_MouldStockBillMain");
        //        }
        //        if (ds == null || ds.Tables[0].Rows.Count == 0)
        //        {
        //            objJsonResult.code = "0";
        //            objJsonResult.count = 0;
        //            objJsonResult.Message = "false！";
        //            objJsonResult.data = null;
        //            return objJsonResult;
        //        }
        //        else
        //        {
        //            objJsonResult.code = "1";
        //            objJsonResult.count = 1;
        //            objJsonResult.Message = "Sucess！";
        //            objJsonResult.data = ds.Tables[0];
        //            return objJsonResult;
        //        }
        //    }
        //    catch (Exception e)
        //    {
        //        objJsonResult.code = "0";
        //        objJsonResult.count = 0;
        //        objJsonResult.Message = "Exception！" + e.ToString();
        //        objJsonResult.data = null;
        //        return objJsonResult;
        //    }
        //}
        ///// <summary>
        ///// 模具其他入库单列表
        ///// </summary>
        ///// <returns></returns>
        //[Route("Sc_MouldOtherInBill/GetMouldOtherInBillList")]
        //[HttpGet]
        //public object GetMouldOtherInBillList(string sWhere)
        //{
        //    try
        //    {

        //        ds = Sc_MouldOtherInBillList_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语句

@@ -181,8 +270,8 @@
                    //
                    if (oMould.DeleteBill(HItemID, ref DBUtility.ClsPub.sExeReturnInfo))
                    {
                        //写入日志
                        ClsPub.Add_Log("", "删除项目，代码：" + oMould.omodel.HNumber + ",名称：" + oMould.omodel.HName, ClsPub.CurUserName);
                        ////写入日志
                        //ClsPub.Add_Log("", "删除项目，代码：" + oMould.omodel.hn + ",名称：" + oMould.omodel.HName, ClsPub.CurUserName);
                        //更新上级为 末级
                        objJsonResult.code = "1";
                        objJsonResult.count = 1;