public bool Edit(Bill_Main main, IList <T_BillingApplication> kpsqLists) { using (SqlConnection conn = new SqlConnection(DataHelper.constr)) { conn.Open(); SqlTransaction tran = conn.BeginTransaction(); try { MainDal maindal = new MainDal(); maindal.DeleteMain(main.BillCode, tran); Delete(main.BillCode, tran); maindal.InsertMain(main, tran); foreach (var i in kpsqLists) { Add(i, tran); } tran.Commit(); return(true); } catch { tran.Rollback(); throw; } } }
public void InsertYbbx(Bill_Main main, IList <Bill_Ybbxmxb> mxList) { using (SqlConnection conn = new SqlConnection(DataHelper.constr)) { conn.Open(); SqlTransaction tran = conn.BeginTransaction(); try { MainDal mainDal = new MainDal(); mainDal.DeleteMain(main.BillCode, tran); DeleteYbbx(main.BillCode, tran); mainDal.InsertMain(main, tran); foreach (Bill_Ybbxmxb ybbxmx in mxList) { InsertYbbxmxb(ybbxmx, tran); if (ybbxmx.KmList != null) { foreach (Bill_Ybbxmxb_Fykm km in ybbxmx.KmList) { InsertYbbxKm(km, tran); if (km.DeptList != null) { foreach (Bill_Ybbxmxb_Fykm_Dept dept in km.DeptList) { InsertYbbxDept(dept, tran); } } if (km.XmList != null) { foreach (Bill_Ybbxmxb_Hsxm xm in km.XmList) { InsertYbbxXm(xm, tran); } } } } if (ybbxmx.FysqList != null) { foreach (Bill_Ybbx_Fysq fysq in ybbxmx.FysqList) { InsertYbbxFysq(fysq, tran); } } } tran.Commit(); } catch (Exception e) { tran.Rollback(); throw e; } } }
public void InsertYsmx(IList <Bill_Ysmxb> list, Bill_Main main) { using (SqlConnection conn = new SqlConnection(DataHelper.constr)) { conn.Open(); SqlTransaction tran = conn.BeginTransaction(); try { DeleteYsmx(main.BillCode); InsertYsmx(list, tran); MainDal md = new MainDal(); md.DeleteMain(main.BillCode); md.InsertMain(main, tran); tran.Commit(); } catch { tran.Rollback(); throw; } } }
public void InsertXmzfdDal(Bill_xmzfd xmzfd, Bill_Main main) { using (SqlConnection conn = new SqlConnection(DataHelper.constr)) { conn.Open(); SqlTransaction tran = conn.BeginTransaction(); try { MainDal mainDal = new MainDal(); if (GetXmzfdByCode(xmzfd.Billcode) != null) { DeleteXmzfd(xmzfd.Billcode, tran); } mainDal.InsertMain(main, tran); InsertXmzfdDal(xmzfd, tran); tran.Commit(); } catch { tran.Rollback(); throw; } } }
public void insertYbbxForGkfj(Bill_Main main, IList <Bill_Ybbxmxb> ybbxList) { using (SqlConnection conn = new SqlConnection(DataHelper.constr)) { conn.Open(); SqlTransaction tran = conn.BeginTransaction(); try { MainDal mainDal = new MainDal(); DeleteYbbxsByName(main.BillName, tran); mainDal.DeleteMainByName(main.BillName, tran); foreach (Bill_Ybbxmxb ybbxmx in ybbxList) { foreach (Bill_Ybbxmxb_Fykm km in ybbxmx.KmList) { //主表 main.GkDept = km.Bxbm; main.BillCode = Guid.NewGuid().ToString();; main.BillJe = km.Je; mainDal.InsertMain(main, tran); //明细表 ybbxmx.BillCode = main.BillCode; InsertYbbxmxb(ybbxmx, tran); //科目明细表 km.BillCode = main.BillCode; InsertYbbxKm(km, tran); if (km.DeptList != null) { foreach (Bill_Ybbxmxb_Fykm_Dept dept in km.DeptList) { InsertYbbxDept(dept, tran); } } if (km.XmList != null) { foreach (Bill_Ybbxmxb_Hsxm xm in km.XmList) { InsertYbbxXm(xm, tran); } } } if (ybbxmx.FysqList != null) { foreach (Bill_Ybbx_Fysq fysq in ybbxmx.FysqList) { InsertYbbxFysq(fysq, tran); } } } tran.Commit(); } catch (Exception e) { tran.Rollback(); throw e; } } }