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;
}
}
}