智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
yangle
8 天以前 bdd7d792753f71cfe31a33d0b0cf703e0b502385 
 WebAPI/Controllers/SBGL/Sb_EquipRepairSendWorkBillController.cs


@@ -39,14 +39,14 @@


                    objJsonResult.data = null;


                    return objJsonResult;


                }


                string sql = "select * from  h_v_Sb_EquipRepairSendWorkBillList where 1=1 ";


                string sql = "select * from  h_v_Sb_EquipRepairSendWorkBill_Edit where 1=1 ";


                if (sWhere == "" || sWhere == null)


                {


                    ds = oCN.RunProcReturn(sql+ " order by hmainid desc ", "h_v_Sb_EquipRepairSendWorkBillList");


                    ds = oCN.RunProcReturn(sql+ " order by hmainid desc ", "h_v_Sb_EquipRepairSendWorkBill_Edit");


                }


                else


                {


                    ds = oCN.RunProcReturn(sql + sWhere+ " order by hmainid desc ", "h_v_Sb_EquipRepairSendWorkBillList");


                    ds = oCN.RunProcReturn(sql + sWhere+ " order by hmainid desc ", "h_v_Sb_EquipRepairSendWorkBill_Edit");


                }




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


@@ -181,6 +181,26 @@


                omodel = Newtonsoft.Json.JsonConvert.DeserializeObject<ClsSb_EquipRepairSendWorkBillMain>(msg2);


                string BillType = "3909";




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


                DataSet ds = oCN.RunProcReturn("Exec h_p_Sb_EquipRepairSendWorkBill_BeforeSaveCtrl " + omodel.HInterID + ",'" + omodel.HBillNo + "','',1", "h_p_Sb_EquipRepairSendWorkBill_BeforeSaveCtrl");


                if (ds == null)


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


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


                    objJsonResult.data = null;


                    return objJsonResult;


                }


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


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


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


                    objJsonResult.data = null;


                    return objJsonResult;


                }


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






                if (OperationType == 1)//新增


                {


@@ -274,6 +294,26 @@


                i++;


            }




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


            DataSet ds = oCN.RunProcReturn("Exec h_p_Sb_EquipRepairSendWorkBill_AfterSaveCtrl " + omodel.HInterID + ",'" + omodel.HBillNo + "','',1", "h_p_Sb_EquipRepairSendWorkBill_AfterSaveCtrl");


            if (ds == null)


            {


                objJsonResult.code = "0";


                objJsonResult.count = 0;


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


                objJsonResult.data = null;


                return objJsonResult;


            }


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


            {


                objJsonResult.code = "0";


                objJsonResult.count = 0;


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


                objJsonResult.data = null;


                return objJsonResult;


            }


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




            objJsonResult.code = "1";


            objJsonResult.count = 1;


            objJsonResult.Message = null;


@@ -308,7 +348,32 @@


                    objJsonResult.data = null;


                    return objJsonResult;


                }


                if (oBill.DeleteBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo))




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


                string sql1 = "exec h_p_Sb_EquipRepairSendWorkBill_BeforeDelCtrl " + oBill.omodel.HInterID + ",'" + oBill.omodel.HBillNo + "','" + User + "'";


                ds = oCN.RunProcReturn(sql1, "h_p_Sb_EquipRepairSendWorkBill_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;


                }




                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;


                }


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




                bool IsDete = oBill.DeleteBill(Convert.ToInt32(HInterID), oBill.omodel.HBillNo, "h_p_Sb_EquipRepairSendWorkBill_AfterDelCtrl", User, ref DBUtility.ClsPub.sExeReturnInfo);




                if (IsDete)


                {


                    objJsonResult.code = "1";


                    objJsonResult.count = 1;


@@ -323,7 +388,7 @@


                    objJsonResult.Message = "删除失败";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


                }              


            }


            catch (Exception e)


            {


@@ -596,8 +661,33 @@


                            objJsonResult.data = null;


                            return objJsonResult;


                        }


                        //审核单据


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






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


                        string sql1 = "exec h_p_Sb_EquipRepairSendWorkBill_BeforeCheckCtrl " + HInterID + ",'" + BillOld.omodel.HBillNo + "','" + user + "'";


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


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


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 1;


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


                            objJsonResult.data = null;


                            oCN.RollBack();


                            return objJsonResult;


                        }




                        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;


                            oCN.RollBack();


                            return objJsonResult;


                        }


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




                        if (!BillOld.CheckBill(int.Parse(HInterID), BillOld.omodel.HBillNo, "h_p_Sb_EquipRepairSendWorkBill_AfterCheckCtrl", user, ref ClsPub.sExeReturnInfo))


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 1;


@@ -639,12 +729,34 @@


                            objJsonResult.data = null;


                            return objJsonResult;


                        }


                        //反审核单据


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




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


                        string sql1 = "exec h_p_Sb_EquipRepairSendWorkBill_BeforeUnCheckCtrl " + HInterID + ",'" + BillOld.omodel.HBillNo + "','" + user + "'";


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


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


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 1;


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


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


                            objJsonResult.data = null;


                            return objJsonResult;




                        }


                        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 (!BillOld.AbandonCheck(int.Parse(HInterID), BillOld.omodel.HBillNo, "h_p_Sb_EquipRepairSendWorkBill_AfterUnCheckCtrl", user, ref ClsPub.sExeReturnInfo))


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 1;


                            objJsonResult.Message = "审核失败!原因:" + ClsPub.sExeReturnInfo;


                            objJsonResult.data = null;


                            return objJsonResult;


                        }


@@ -743,12 +855,44 @@


                            objJsonResult.data = null;


                            return objJsonResult;


                        }


                        //关闭单据


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




                        string sql2 = "";


                        //关闭前控制===============================================Begin===================================================================


                        sql2 = "exec h_p_Sb_EquipRepairSendWorkBill_BeforeCloseCtrl " + HInterID + ",'" + BillOld.omodel.HBillNo + "','" + user + "'";


                        ds = oCN.RunProcReturn(sql2, "h_p_Sb_EquipRepairSendWorkBill_BeforeCloseCtrl");


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


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 0;


                            objJsonResult.Message = "关闭失败!原因:关闭前前判断失败，无返回信息，请与网络管理人员联系";


                            objJsonResult.data = null;


                            return objJsonResult;




                        }


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


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 0;


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


                            objJsonResult.data = null;


                            return objJsonResult;


                        }


                        //关闭前控制===============================================End===================================================================




                        //关闭提交


                        if (BillOld.CloseBill(Convert.ToInt32(HInterID), BillOld.omodel.HBillNo, "h_p_Sb_EquipRepairSendWorkBill_AfterCloseCtrl", user, ref DBUtility.ClsPub.sExeReturnInfo) == true)


                        {


                            objJsonResult.code = "1";


                            objJsonResult.count = 1;


                            objJsonResult.Message = "关闭失败!原因:" + ClsPub.sExeReturnInfo;


                            objJsonResult.Message = "关闭成功";


                            objJsonResult.data = null;


                            return objJsonResult;


                        }


                        else


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 0;


                            objJsonResult.Message = "关闭失败!原因:" + DBUtility.ClsPub.sExeReturnInfo;


                            objJsonResult.data = null;


                            return objJsonResult;


                        }


@@ -786,15 +930,47 @@


                            objJsonResult.data = null;


                            return objJsonResult;


                        }


                        //反关闭单据


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




                        string sql2 = "";


                        //反关闭前控制===============================================Begin===================================================================


                        sql2 = "exec h_p_Sb_EquipRepairSendWorkBill_BeforeUnCloseCtrl " + HInterID + ",'" + BillOld.omodel.HBillNo + "','" + user + "'";


                        ds = oCN.RunProcReturn(sql2, "h_p_Sb_EquipRepairSendWorkBill_BeforeUnCloseCtrl");


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


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 1;


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


                            objJsonResult.count = 0;


                            objJsonResult.Message = "反关闭失败!原因:反关闭前前判断失败，无返回信息，请与网络管理人员联系";


                            objJsonResult.data = null;


                            return objJsonResult;




                        }


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


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 0;


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


                            objJsonResult.data = null;


                            return objJsonResult;


                        }


                        //反关闭前控制===============================================End===================================================================




                        //反关闭提交


                        if (BillOld.CancelClose(Convert.ToInt32(HInterID), BillOld.omodel.HBillNo, "h_p_Sb_EquipRepairSendWorkBill_AfterUnCloseCtrl", user, ref DBUtility.ClsPub.sExeReturnInfo) == true)


                        {


                            objJsonResult.code = "1";


                            objJsonResult.count = 1;


                            objJsonResult.Message = "反关闭成功";


                            objJsonResult.data = null;


                            return objJsonResult;


                        }


                        else


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 0;


                            objJsonResult.Message = "反关闭失败!原因:" + DBUtility.ClsPub.sExeReturnInfo;


                            objJsonResult.data = null;


                            return objJsonResult;


                        }                       


                    }


                }