智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
zrg
2025-03-17 6ca4391a35cb940a5a27fd45811cce2d07f04b78 
 WebAPI/Controllers/CJGL/Sc_WorkBeginDotCheckBillController.cs


@@ -20,11 +20,13 @@


        public DBUtility.ClsPub.Enum_BillStatus BillStatus;//单据状态（新增，修改，浏览，更新单价，变更）


        private json objJsonResult = new json();


        public DataSet ds = new DataSet();


        public DataSet ds1 = new DataSet();


        SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();


        public DAL.ClsSc_WorkBeginDotCheckBillMain OBill = new DAL.ClsSc_WorkBeginDotCheckBillMain();   //启动点检单


        public DAL.ClsSc_WorkBeginDotCheckBillMain BillOld = new DAL.ClsSc_WorkBeginDotCheckBillMain();//启动点检单


        public DAL.ClsGy_WorkBeginDotCheckListBillMain OBill1 = new DAL.ClsGy_WorkBeginDotCheckListBillMain();  //设备启动点检清单


        public DAL.ClsGy_WorkBeginDotCheckListBillMain BillOld1 = new DAL.ClsGy_WorkBeginDotCheckListBillMain(); //设备启动点检清单








        #region 启动点检列表 查询       


@@ -1154,11 +1156,51 @@


                    objJsonResult.data = null;


                    return objJsonResult;


                }




                oCN.BeginTran();


                //判断存在性


                if (BillOld1.ShowBill(Int64.Parse(HInterID), ref DBUtility.ClsPub.sExeReturnInfo))


                {                  


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


                    string sql1 = "exec h_p_Gy_WorkBeginDotCheckListBill_BeforeDelCtrl  " + BillOld1.omodel.HInterID + ",'" + BillOld1.omodel.HBillNo + "','" + user + "'";


                    ds = oCN.RunProcReturn(sql1, "h_p_Gy_WorkBeginDotCheckListBill_BeforeDelCtrl");


                    if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


                        objJsonResult.Message = "删除失败!原因:删除前判断失败，请与网络管理人员联系";


                        objJsonResult.data = null;


                        return objJsonResult;


                    }




                oCN.RunProc("delete from Gy_WorkBeginDotCheckListBillMain where HInterID = " + HInterID);


                oCN.RunProc("delete from Gy_WorkBeginDotCheckListBillSub where HInterID = " + HInterID);


                    if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0")


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


                        objJsonResult.Message = "删除失败!原因:" + ds.Tables[0].Rows[0]["HRemark"].ToString(); ;


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


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




                    //删除单据（包含删除后控制、写入日志）


                    if (!BillOld1.DeleteBill(BillOld1.omodel.HInterID, BillOld1.omodel.HBillNo, "h_p_Gy_WorkBeginDotCheckListBill_AfterDelCtrl", user, ref ClsPub.sExeReturnInfo))


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = "删除失败!原因:" + ClsPub.sExeReturnInfo;


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


                    else


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


                        objJsonResult.Message = "删除成功！";


                        objJsonResult.data = null;


                        return objJsonResult;


                    }




                }




                oCN.Commit();




@@ -1213,7 +1255,7 @@


                if (Type == 1)


                {


                    //判断单据是否已经审核


                    DataSet ds;


                   


                    string sql = "select * from " + BillOld.MvarItemKey + " where HinterID = " + HInterID;


                    ds = oCN.RunProcReturn(sql, BillOld.MvarItemKey);


                    if (ds == null || ds.Tables[0].Rows.Count == 0)


@@ -1250,8 +1292,32 @@


                            objJsonResult.data = null;


                            return objJsonResult;


                        }


                        //审核前控制=========================================      


                        string sql1 = "exec h_p_Gy_WorkBeginDotCheckListBill_BeforeCheckCtrl " + HInterID + ",'" + ds.Tables[0].Rows[0]["HBillNo"].ToString() + "','" + user + "'";


                        ds1 = oCN.RunProcReturn(sql1, "h_p_Gy_WorkBeginDotCheckListBill_BeforeCheckCtrl");


                        if (ds1 == null || ds1.Tables.Count == 0 || ds1.Tables[0].Rows.Count == 0)


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 1;


                            objJsonResult.Message = "审核失败!原因:审核前判断失败，请与网络管理人员联系";


                            objJsonResult.data = null;


                            oCN.RollBack();


                            return objJsonResult;


                        }




                        if (ds1.Tables[0].Rows[0]["HBack"].ToString() != "0")


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 1;


                            objJsonResult.Message = "审核失败!原因:" + ds1.Tables[0].Rows[0]["HRemark"].ToString(); ;


                            objJsonResult.data = null;


                            oCN.RollBack();


                            return objJsonResult;


                        }


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


                       


                        //审核单据


                        if (!BillOld.CheckBill(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo))


                        if (!BillOld.CheckBill(Int64.Parse(HInterID), ds.Tables[0].Rows[0]["HBillNo"].ToString(), "h_p_Gy_WorkBeginDotCheckListBill_AfterCheckCtrl",user, ref ClsPub.sExeReturnInfo))


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 1;


@@ -1263,8 +1329,7 @@


                }


                else


                {


                    //判断单据是否已经反审核


                    DataSet ds;


                    //判断单据是否已经反审核                    


                    string sql = "select * from " + BillOld.MvarItemKey + " where HinterID = " + HInterID;


                    ds = oCN.RunProcReturn(sql, BillOld.MvarItemKey);


                    if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)


@@ -1293,8 +1358,29 @@


                            objJsonResult.data = null;


                            return objJsonResult;


                        }


                        //反审核单据


                        if (!BillOld.AbandonCheck(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo))


                        //反审核前控制=========================================        


                        string sql1 = "exec h_p_Gy_WorkBeginDotCheckListBill_BeforeUnCheckCtrl " + HInterID + ",'" + ds.Tables[0].Rows[0]["HBillNo"].ToString() + "','" + user + "'";


                        ds1 = oCN.RunProcReturn(sql1, "h_p_Gy_WorkBeginDotCheckListBill_BeforeUnCheckCtrl");


                        if (ds1 == null || ds1.Tables.Count == 0 || ds1.Tables[0].Rows.Count == 0)


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 1;


                            objJsonResult.Message = "反审核失败!原因:反审核前判断失败，请与网络管理人员联系";


                            objJsonResult.data = null;


                            return objJsonResult;




                        }


                        if (ds1.Tables[0].Rows[0]["HBack"].ToString() != "0")


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 1;


                            objJsonResult.Message = "反审核失败!原因:" + ds1.Tables[0].Rows[0]["HRemark"].ToString(); ;


                            objJsonResult.data = null;


                            return objJsonResult;


                        }


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


                            //反审核单据


                        if (!BillOld.AbandonCheck(Int64.Parse(HInterID), ds.Tables[0].Rows[0]["HBillNo"].ToString(), "h_p_Gy_WorkBeginDotCheckListBill_AfterUnCheckCtrl",user, ref ClsPub.sExeReturnInfo))


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 1;


@@ -1479,6 +1565,7 @@


        {


            try


            {


 


                //判断是否有作废权限


                if (!DBUtility.ClsPub.Security_Log("Gy_WorkBeginDotCheckListBillMain_Drop", 1, false, user))


                {


@@ -1499,16 +1586,16 @@


                }




                ClsPub.CurUserName = user;


                BillOld.MvarItemKey = "Gy_WorkBeginDotCheckListBillMain";


                BillOld1.MvarItemKey = "Gy_WorkBeginDotCheckListBillMain";


                oCN.BeginTran();//开始事务




                //Type 1 作废  2  反作废


                if (Type == 1)


                {


                    //判断单据是否已经作废


                    DataSet ds;


                    string sql = "select * from " + BillOld.MvarItemKey + " where HinterID = " + HInterID;


                    ds = oCN.RunProcReturn(sql, BillOld.MvarItemKey);


                    


                    string sql = "select * from " + BillOld1.MvarItemKey + " where HinterID = " + HInterID;


                    ds = oCN.RunProcReturn(sql, BillOld1.MvarItemKey);


                    if (ds == null || ds.Tables[0].Rows.Count == 0)


                    {


                        objJsonResult.code = "0";


@@ -1535,23 +1622,45 @@


                            objJsonResult.data = null;


                            return objJsonResult;


                        }


                        //作废单据


                        if (!BillOld.Cancelltion(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo))


                        //作废前控制=========================================      


                        string sql1 = "exec h_p_Gy_WorkBeginDotCheckListBill_BeforeDropCtrl " + HInterID + ",'" + ds.Tables[0].Rows[0]["HBillNo"].ToString() + "','" + user + "'";


                        ds1 = oCN.RunProcReturn(sql1, "h_p_Gy_WorkBeginDotCheckListBill_BeforeDropCtrl");


                        if (ds1 == null || ds1.Tables.Count == 0 || ds1.Tables[0].Rows.Count == 0)


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 1;


                            objJsonResult.Message = "审核失败!原因:审核前判断失败，请与网络管理人员联系";


                            objJsonResult.data = null;


                            oCN.RollBack();


                            return objJsonResult;


                        }




                        if (ds1.Tables[0].Rows[0]["HBack"].ToString() != "0")


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 1;


                            objJsonResult.Message = "审核失败!原因:" + ds.Tables[0].Rows[0]["HRemark"].ToString(); ;


                            objJsonResult.data = null;


                            oCN.RollBack();


                            return objJsonResult;


                        }


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


                        //作废单据


                        if (!BillOld1.Cancelltion(Int64.Parse(HInterID), ds.Tables[0].Rows[0]["HBillNo"].ToString(), "h_p_Gy_WorkBeginDotCheckListBill_AfterDropCtrl", user, ref ClsPub.sExeReturnInfo))


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 0;


                            objJsonResult.Message = "作废失败!原因:" + ClsPub.sExeReturnInfo;


                            objJsonResult.data = null;


                            return objJsonResult;


                        }


                        }                       


                    }


                }


                else


                {


                    //判断单据是否已经反作废


                    DataSet ds;


                    string sql = "select * from " + BillOld.MvarItemKey + " where HinterID = " + HInterID;


                    ds = oCN.RunProcReturn(sql, BillOld.MvarItemKey);


                    string sql = "select * from " + BillOld1.MvarItemKey + " where HinterID = " + HInterID;


                    ds = oCN.RunProcReturn(sql, BillOld1.MvarItemKey);


                    if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)


                    {


                        if (ds.Tables[0].Rows[0]["HChecker"] != null && ds.Tables[0].Rows[0]["HChecker"].ToString() != "")


@@ -1570,15 +1679,38 @@


                            objJsonResult.data = null;


                            return objJsonResult;


                        }


                        //反作废单据


                        if (!BillOld.AbandonCancelltion(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo))


                        //反作废前控制=========================================      


                        string sql1 = "exec h_p_Gy_WorkBeginDotCheckListBill_BeforeUnDropCtrl " + HInterID + ",'" + ds.Tables[0].Rows[0]["HBillNo"].ToString() + "','" + user + "'";


                        ds1 = oCN.RunProcReturn(sql1, "h_p_Gy_WorkBeginDotCheckListBill_BeforeUnDropCtrl");


                        if (ds1 == null || ds1.Tables.Count == 0 || ds1.Tables[0].Rows.Count == 0)


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 1;


                            objJsonResult.Message = "作废失败!原因:反作废前判断失败，请与网络管理人员联系";


                            objJsonResult.data = null;


                            oCN.RollBack();


                            return objJsonResult;


                        }




                        if (ds1.Tables[0].Rows[0]["HBack"].ToString() != "0")


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 1;


                            objJsonResult.Message = "作废失败!原因:" + ds1.Tables[0].Rows[0]["HRemark"].ToString(); ;


                            objJsonResult.data = null;


                            oCN.RollBack();


                            return objJsonResult;


                        }


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


                        //反作废单据


                        if (!BillOld1.AbandonCancelltion(Int64.Parse(HInterID), ds.Tables[0].Rows[0]["HBillNo"].ToString(), "h_p_Gy_WorkBeginDotCheckListBill_AfterDropCtrl", user, ref ClsPub.sExeReturnInfo))


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 0;


                            objJsonResult.Message = "反作废失败!原因:" + ClsPub.sExeReturnInfo;


                            objJsonResult.data = null;


                            return objJsonResult;


                        }


                        }                      


                    }


                }