public void DeleteYbbxsByName(string billName)
{
using (SqlConnection conn = new SqlConnection(DataHelper.constr))
{
conn.Open();
SqlTransaction tran = conn.BeginTransaction();
try
{
DeleteYbbxsByName(billName, tran);
MainDal mdal = new MainDal();
mdal.DeleteMainByName(billName, tran);
tran.Commit();
}
catch (Exception e)
{
tran.Rollback();
throw e;
}
}
}
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;
}
}
}