项目费用分类 的基础资料编辑及列表 管径、管径材质 的 基础资料 项目费用 里 增加 项目费用分类和 金额HStdMoney 的字段 异常反馈验...

zrg

2025-03-28 fa61fd1b6e892f055656c3232e8cf643d3658002

 WebAPI/Controllers/»ù´¡×ÊÁÏ/»ù´¡×ÊÁÏ/Xt_CheckFlowBillController.cs

@@ -115,7 +115,17 @@
                    }
                }
                ds = oCN.RunProcReturn("select  *  from h_v_Xt_CheckFlowList where Hmainid= " + main.HInterID, "h_v_Xt_CheckFlowList");

                //保存前控制判断
                string sql = "select * from Xt_CheckFlowMain where  HBillTypeID = '" + main.HBillTypeID.ToString() + "' and HDeptID = " + main.HDeptID.ToString() + " and HStandard = 1 and HInterID <> "+ main.HInterID.ToString();
                DataSet ds2 = oCN.RunProcReturn(sql, "Xt_CheckFlowMain");
                if (ds2.Tables[0].Rows.Count > 0 && main.HStandard)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "添加失败,只能有一个默认流程单";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                //保存
                //保存完毕后处理
                oCN.BeginTran();
@@ -126,34 +136,21 @@
                         ",HRemark,HStandard,HName" + ") " +
                         " values('" + main.HBillTypeID.ToString() + "'," + main.HInterID.ToString() + "," + main.HDeptID.ToString() +
                         ",'" + main.HRemark + "'," + Convert.ToString(main.HStandard ? 1 : 0) + ",'" + main.HName.ToString() + "') ");

                    int i = 0;
                    foreach (Xt_CheckFlowSub oSub in lsmain)
                    {
                        i++;
                        bool bResult = false;

                        oCN.RunProc("Insert into Xt_CheckFlowSub " +
                                " (HInterID,HEntryID,HCheckMan" +
                                ",HFlowNo,HJumpFlag,HMakerSelf,HCheckItemID" +
                                " )values("
                                + main.HInterID.ToString() + "," + i + ",'" + oSub.HCheckMan + "'" +
                                "," + oSub.HFlowNo + "," + Convert.ToString(oSub.HJumpFlag ? 1 : 0) + "," + Convert.ToString(oSub.HMakerSelf ? 1 : 0) + "," + oSub.HCheckItemID + ") ");

                        bResult = true;


                        if (!bResult)
                        {
                            objJsonResult.code = "0";
                            objJsonResult.count = 0;
                            objJsonResult.Message = "保存失败！" + DBUtility.ClsPub.sExeReturnInfo;
                            objJsonResult.data = 1;
                            return objJsonResult;
                        }

                    }
                }
                else
                {
                    //更新主表
                    oCN.RunProc("UpDate Xt_CheckFlowMain set  " +
                    "HRemark='" + main.HRemark + "'" +
                    ",HName='" + main.HName + "'" +
                    ",HDeptID=" + main.HDeptID.ToString() +
                    ",HBillTypeID='" + main.HBillTypeID + "'" +
                    ",HStandard='" + Convert.ToString(main.HStandard ? 1 : 0) + "'" +
                    " where HInterID=" + main.HInterID.ToString());
                    //删除子表
                    oCN.RunProc("delete from Xt_CheckFlowSub where HInterID=" + main.HInterID.ToString());
                }
                AddBillSub(lsmain, main.HInterID);

                oCN.Commit();

@@ -174,6 +171,27 @@
            }
        }

        public json AddBillSub(List<Xt_CheckFlowSub> DetailColl, long HInterID)
        {
            int i = 1;
            foreach (Xt_CheckFlowSub oSub in DetailColl)
            {

                oCN.RunProc("Insert into Xt_CheckFlowSub " +
                             " (HInterID,HEntryID,HCheckMan" +
                             ",HFlowNo,HJumpFlag,HMakerSelf,HCheckItemID" +
                             " )values("
                             + HInterID + "," + i + ",'" + oSub.HCheckMan + "'" +
                             "," + oSub.HFlowNo + "," + Convert.ToString(oSub.HJumpFlag ? 1 : 0) + "," + Convert.ToString(oSub.HMakerSelf ? 1 : 0) + "," + oSub.HCheckItemID + ") ");
                i++;
            }
            objJsonResult.code = "1";
            objJsonResult.count = 1;
            objJsonResult.Message = null;
            objJsonResult.data = null;
            return objJsonResult;
        }

        #endregion

        #region  å®¡æ ¸æµç¨‹å• åˆ é™¤