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 DeleteXmzfd(string billCode, SqlTransaction tran) { MainDal mainDal = new MainDal(); mainDal.DeleteMain(billCode, tran); string sql = @"delete bill_xmzfd where billCode=@billCode"; SqlParameter[] sps = { new SqlParameter("@billCode", billCode) }; DataHelper.ExcuteNonQuery(sql, tran, sps, false); }
public void DeleteCgzjfk(string billCode) { using (SqlConnection conn = new SqlConnection(DataHelper.constr)) { conn.Open(); SqlTransaction tran = conn.BeginTransaction(); try { DeleteCgzjfk(billCode, tran); MainDal mdal = new MainDal(); mdal.DeleteMain(billCode, tran); tran.Commit(); } catch (Exception e) { tran.Rollback(); throw e; } } }
/// <summary> /// 删除一条数据 /// </summary> public int Delete(string Code) { using (SqlConnection conn = new SqlConnection(DataHelper.constr)) { conn.Open(); SqlTransaction tran = conn.BeginTransaction(); try { MainDal maindal = new MainDal(); maindal.DeleteMain(Code, tran); int row = Delete(Code, tran); tran.Commit(); return(row); } catch { tran.Rollback(); throw; } } }
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; } } }