智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
yusijie
2025-03-18 b38be3b76d6169692a7907b7f33cd488a5345279 
 WebAPI/Controllers/BaseSet/Gy_QCCheckClassController.cs


@@ -182,9 +182,55 @@


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


                    oCN.BeginTran();


                    //


                    //删除前控制=========================================


                    ds = oCN.RunProcReturn("Exec h_p_Gy_QCCheckClass_BeforeDelCtrl " + HItemID + ",'" + User + "'", "h_p_Gy_QCCheckClass_BeforeDelCtrl");




                    if (ds == null)


                    {


                        oCN.RollBack();


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = "删除前判断失败！";


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


                    if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) != "0")


                    {


                        oCN.RollBack();


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = "删除失败！" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


                    //=========================================================




                    if (oDept.DeleteByID(HItemID))


                    {


                        //删除后控制=========================================


                        DataSet ds2 = oCN.RunProcReturn("Exec h_p_Gy_QCCheckClass_AfterDelCtrl " + HItemID + ",'" + User + "'", "h_p_Gy_QCCheckClass_AfterDelCtrl");


                        if (ds2 == null)


                        {


                            oCN.RollBack();


                            objJsonResult.code = "0";


                            objJsonResult.count = 0;


                            objJsonResult.Message = "删除后判断失败！";


                            objJsonResult.data = null;


                            return objJsonResult;


                        }


                        if (DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBack"]) != "0")


                        {


                            oCN.RollBack();


                            objJsonResult.code = "0";


                            objJsonResult.count = 0;


                            objJsonResult.Message = "删除失败！" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);


                            objJsonResult.data = null;


                            return objJsonResult;


                        }


                        //=========================================================


                        oCN.Commit();


                        //写入日志


                        ClsPub.Add_Log("", "删除项目，代码：" + oDeptHlp.omodel.HNumber + ",名称：" + oDeptHlp.omodel.HName, ClsPub.CurUserName);


                        //更新上级为 末级


@@ -196,6 +242,7 @@


                    }


                    else


                    {


                        oCN.RollBack();


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = "删除失败";


@@ -268,8 +315,11 @@


                string HHelpCode = list[0].HHelpCode;


                string HRemark = list[0].HRemark;


                bool HStopflag = list[0].HStopflag;


                bool HUseFlag = list[0].HUseFlag;


                string HUseFlag = list[0].HUseFlag;


                long HQCCheckClassID = list[0].HQCCheckClassID;


                string HMakeEmp = list[0].HMakeEmp;


                long HUSEORGID = list[0].HUSEORGID;


                long HCREATEORGID = list[0].HCREATEORGID;




                if (!DBUtility.ClsPub.AllowNumber(HNumber))


                {


@@ -282,17 +332,66 @@




                //若MAINDI重复则重新获取


                oCN.BeginTran();




                //保存前控制=========================================


                DataSet ds = oCN.RunProcReturn("Exec h_p_Gy_QCCheckClass_BeforeSaveCtrl " + msg4 + ",'1'", "h_p_Gy_QCCheckClass_BeforeSaveCtrl");


                if (ds == null)


                {


                    oCN.RollBack();


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "保存前判断失败！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


                if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) != "0")


                {


                    oCN.RollBack();


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "保存失败！" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);


                    objJsonResult.data = null;


                    return objJsonResult;


                }


                //=========================================================




                //主表


                oCN.RunProc("Insert Into Gy_QCCheckClass " +


                "(HNumber,HName,HHelpCode,HShortNumber,HParentID" +


                ",HLevel,HEndFlag,HStopflag,HRemark,HUseFlag) " +


                ",HLevel,HEndFlag,HStopflag,HRemark" +


                 ",HMakeEmp,HMakeTime,HUSEORGID,HCREATEORGID,HUseFlag) " +


                " values('" + HNumber + "','" + HName + "','" + HHelpCode + "','" + HShortNumber + "','" + HItemID + "'" +


                ",'1',0,'" + Convert.ToString(HStopflag ? 1 : 0) + "','" + HRemark + "','未使用')");


                ",'1',0,'" + Convert.ToString(HStopflag ? 1 : 0) + "','" + HRemark + "'" +


                ",'" + HMakeEmp + "',getdate()," + HUSEORGID + "," + HCREATEORGID + ",'" + HUseFlag + "')");


                //修改上级为非末级代码


                if (list[0].HItemID.ToString() != "")


                {


                    oCN.RunProc("Update Gy_QCCheckClass set HEndflag=0 where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo);


                }




                //保存后控制=========================================


                DataSet ds2 = oCN.RunProcReturn("Exec h_p_Gy_QCCheckClass_AfterSaveCtrl " + msg4 + ",'1'", "h_p_Gy_QCCheckClass_AfterSaveCtrl");


                if (ds2 == null)


                {


                    oCN.RollBack();


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "保存后判断失败！";


                    objJsonResult.data = null;


                    return objJsonResult;




                }


                if (DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBack"]) != "0")


                {


                    oCN.RollBack();


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "" + DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBackRemark"]);


                    objJsonResult.data = null;


                    return objJsonResult;


                }


                //=========================================================




                oCN.Commit();


                objJsonResult.code = "1";


                objJsonResult.count = 1;


@@ -348,7 +447,7 @@




                //反序列化


                msg2 = "[" + msg2.ToString() + "]";


                List<MaintenanceAcceptItem> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<MaintenanceAcceptItem>>(msg2);


                List<CheckItem> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<CheckItem>>(msg2);




                long HItemID = int.Parse(msg3);


                string HNumber = list[0].HNumber;


@@ -357,8 +456,10 @@


                long HParentID = list[0].HParentID.ToString() == "" ? 0 : list[0].HParentID;


                string HHelpCode = list[0].HHelpCode;


                string HRemark = list[0].HRemark;


                string HStopflag = list[0].HStopflag;


                bool HStopflag = list[0].HStopflag;


                string HUseFlag = list[0].HUseFlag;


                string HModifyEmp = msg4;


                long HUSEORGID = list[0].HUSEORGID;




                if (!DBUtility.ClsPub.AllowNumber(HNumber))


                {


@@ -381,10 +482,36 @@




                //若MAINDI重复则重新获取


                oCN.BeginTran();




                //保存前控制=========================================


                DataSet ds = oCN.RunProcReturn("Exec h_p_Gy_QCCheckClass_BeforeSaveCtrl " + msg4 + ",'1'", "h_p_Gy_QCCheckClass_BeforeSaveCtrl");


                if (ds == null)


                {


                    oCN.RollBack();


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "保存前判断失败！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


                if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) != "0")


                {


                    oCN.RollBack();


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "保存失败！" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);


                    objJsonResult.data = null;


                    return objJsonResult;


                }


                //=========================================================




                //主表


                oCN.RunProc("Update Gy_QCCheckClass set " +


                    " HNumber='" + HNumber + "'" +


                    ",HName='" + HName + "'" +


                    ",HModifyEmp='" + HModifyEmp + "'" +


                    ",HModifyTime=getdate()" +


                     ",HUSEORGID='" + HUSEORGID + "'" +


                    ",HShortNumber='" + HShortNumber + "'" +


                    ",HHelpCode='" + HHelpCode + "'" +


                    ",HParentID=" + HParentID +


@@ -395,6 +522,30 @@


                //将上级 为非末级


                oCN.RunProc("Update Gy_QCCheckClass set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo);


                //




                //保存后控制=========================================


                DataSet ds2 = oCN.RunProcReturn("Exec h_p_Gy_QCCheckClass_AfterSaveCtrl " + msg4 + ",'1'", "h_p_Gy_QCCheckClass_AfterSaveCtrl");


                if (ds2 == null)


                {


                    oCN.RollBack();


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "保存后判断失败！";


                    objJsonResult.data = null;


                    return objJsonResult;




                }


                if (DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBack"]) != "0")


                {


                    oCN.RollBack();


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "" + DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBackRemark"]);


                    objJsonResult.data = null;


                    return objJsonResult;


                }


                //=========================================================




                oCN.Commit();


                objJsonResult.code = "1";


                objJsonResult.count = 1;