From a29e09d88136434ebf5eba16645845bec487c532 Mon Sep 17 00:00:00 2001 From: duhe <226547893@qq.com> Date: 星期四, 04 一月 2024 11:02:50 +0800 Subject: [PATCH] 用户关联客户维护:新增、编辑、删除、列设置、按钮设置 --- WebAPI/DLL/ClsOA_ErrMsgBackBill.cs | 51 ++++++++++++++++++++++++++++++++++++++++++++++++++- 1 files changed, 50 insertions(+), 1 deletions(-) diff --git a/WebAPI/DLL/ClsOA_ErrMsgBackBill.cs b/WebAPI/DLL/ClsOA_ErrMsgBackBill.cs index 6802e1b..defb729 100644 --- a/WebAPI/DLL/ClsOA_ErrMsgBackBill.cs +++ b/WebAPI/DLL/ClsOA_ErrMsgBackBill.cs @@ -10,6 +10,7 @@ public Models.ClsOA_ErrMsgBackBillMain omodel = new Models.ClsOA_ErrMsgBackBillMain(); public List<Models.ClsOA_ErrMsgBackBillSub> DetailColl = new List<Models.ClsOA_ErrMsgBackBillSub>(); public List<Models.ClsOA_ErrMsgBackBillSub2> DetailColl2 = new List<Models.ClsOA_ErrMsgBackBillSub2>(); + public Models.ClsOA_ErrMsgBackBillSub DetailReply = new Models.ClsOA_ErrMsgBackBillSub(); public ClsOA_ErrMsgBackBill() { @@ -64,7 +65,9 @@ ",HDescription='" + omodel.HDescription + "'" + ",HHasten=" + omodel.HHasten.ToString() + ",HQty=" + omodel.HQty.ToString() + - + ",HRecDeptID=" + omodel.HRecDeptID.ToString() + + ",HMaterNumber='" + omodel.HMaterNumber + "'" + + " where HInterID=" + lngBillKey.ToString()); //鍒犻櫎鍏宠仈 DeleteRelation(ref sReturn, lngBillKey); @@ -193,6 +196,52 @@ } } + public bool ReplyBill(ref string sReturn) + { + try + { + + //鑻AINDI閲嶅鍒欓噸鏂拌幏鍙� + oCn.BeginTran(); + + + DataSet Ds = oCn.RunProcReturn("select count(HInterID) as num from OA_ErrMsgBackBillSub where HInterID = " + DetailReply.HInterID + " group by HInterID ", "OA_ErrMsgBackBillSub"); + + Int64 num = 0; + + if (Ds.Tables[0].Rows.Count == 0) + { + num = 1; + } + else + { + num = Convert.ToInt64(Ds.Tables[0].Rows[0]["num"]) + 1; + } + + //涓昏〃 + oCn.RunProc("Insert Into OA_ErrMsgBackBillSub " + + "(HInterID,HEntryID,HRemark,HSendStatus,HSendMan" + + ",HDescriptionSub,HDate" + + ",HCloseMan,HEntryCloseDate,HCloseType,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" + + ") " + + " values(" + DetailReply.HInterID + "," + num + ",'" + DetailReply.HRemark + "'," + 1 + ",'" + DetailReply.HSendMan + "'" + + ",'" + DetailReply.HDescriptionSub + "','" + DetailReply.HDate + "','" + DetailReply.HCloseMan + "','" + "" + "'" + + "," + 0 + "," + DetailReply.HSourceInterID + "," + DetailReply.HSourceEntryID + ",'" + DetailReply.HSourceBillNo + "'" + + ",'" + DetailReply.HSourceBillType + "'," + DetailReply.HRelationQty + "," + DetailReply.HRelationMoney + + ") "); + + sReturn = omodel.HInterID.ToString(); + oCn.Commit(); + return true; + } + catch (Exception e) + { + sReturn = e.Message; + oCn.RollBack(); + throw (e); + } + } + //鍒犻櫎鍗曟嵁 public virtual bool DeleteBill(Int64 lngBillKey,string HEntryID, ref string sReturn) { -- Gitblit v1.9.1