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

仲国强

2021-09-17 9a22968dfc75024a852bb0b64dd6a6cb461be80a

 WebAPI/Controllers/Sc_MouldOtherInBillController.cs

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

        /// <summary>
        /// 返回模具其他入库单列表
        ///参数：string sql。
        ///返回值：object。
        /// </summary>
           #region 模具其他入库单列表

        [Route("Sc_MouldOtherInBill/GetMouldOtherInBillList")]
        [HttpGet]
        public object list(string sWhere)
        public object GetMouldProdOutBill(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;
                }

                ds = Sc_MouldOtherInBillList_s(sWhere);
                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = "返回记录成功！";
                objJsonResult.data = ds.Tables[0];
                return objJsonResult;
            }
            catch (Exception e)
            catch (Exception ex)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "Exception！" + e.ToString();
                objJsonResult.Message = "没有返回任何记录！" + ex.ToString();
                objJsonResult.data = null;
                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>