设备点检标准(查询、新增、编辑、删除、查看)接口开发

yl

2022-08-17 3e783ac35c550b1d823f11dacb029885a6c760fe

 VueWebApi/DLL/DAL/QualityManagementDAL.cs

@@ -29,7 +29,7 @@
            {
                if (defectcode != "" && defectcode != null)
                {
                    search += "and A.code=@defectcode ";
                    search += "and A.code like '%'+@defectcode+'%' ";
                    dynamicParams.Add("@defectcode", defectcode);
                }
                if (defectname != "" && defectname != null)
@@ -211,7 +211,7 @@
            {
                if (stanedcode != "" && stanedcode != null)
                {
                    search += "and A.code=@stanedcode ";
                    search += "and A.code like '%'+@stanedcode+'%' ";
                    dynamicParams.Add("@stanedcode", stanedcode);
                }
                if (stanedname != "" && stanedname != null)
@@ -400,21 +400,21 @@
                    {
                        mes.code = "200";
                        mes.count = 0;
                        mes.Message = "新增操作成功!";
                        mes.Message = "操作成功!";
                        mes.data = null;
                    }
                    else
                    {
                        mes.code = "300";
                        mes.count = 0;
                        mes.Message = "新增操作失败!";
                        mes.Message = "操作失败!";
                        mes.data = null;
                    }
                }
                if (opertype == "Update") 
                {
                    //删除工序检验标准子表
                    sql = @"delete from TStepCheckStandard where code=@stepstaned_code";
                    sql = @"delete from TStepCheckStandardSub where stepstaned_code=@stepstaned_code";
                    list.Add(new { str = sql, parm = new { stepstaned_code = json.code} });
                    //修改工序检验标准主表
                    sql = @"update  TStepCheckStandard set name=@stepstaned_name,descr=@stepstaned_desc where code=@stepstaned_code";
@@ -433,14 +433,14 @@
                    {
                        mes.code = "200";
                        mes.count = 0;
                        mes.Message = "新增操作成功!";
                        mes.Message = "操作成功!";
                        mes.data = null;
                    }
                    else
                    {
                        mes.code = "300";
                        mes.count = 0;
                        mes.Message = "新增操作失败!";
                        mes.Message = "操作失败!";
                        mes.data = null;
                    }
                }
@@ -467,7 +467,7 @@
            {
                if (itemcode != "" && itemcode != null)
                {
                    search += "and A.code=@itemcode ";
                    search += "and A.code like '%'+@itemcode+'%' ";
                    dynamicParams.Add("@itemcode", itemcode);
                }
                if (itemname != "" && itemname != null)
@@ -636,8 +636,6 @@
            return mes;
        }
        #endregion



    }
}