public Bill_xmzfd GetXmzfdByCode(string billCode)
{
string sql = "select * from bill_xmzfd where billCode=@billCode";
SqlParameter[] sps = { new SqlParameter("@billCode", billCode) };
SqlDataReader dr = DataHelper.GetDataReader(sql, sps);
Bill_xmzfd xmzfd = new Bill_xmzfd();
if (dr.Read())
{
xmzfd.Billcode = Convert.ToString(dr["billcode"]);
xmzfd.Sj = Convert.ToDateTime(dr["sj"]);
xmzfd.ZfDept = Convert.ToString(dr["zfDept"]);
xmzfd.Zfxm = Convert.ToString(dr["zfxm"]);
xmzfd.Zynr = Convert.ToString(dr["zynr"]);
xmzfd.Sm = Convert.ToString(dr["sm"]);
xmzfd.Cbr = Convert.ToString(dr["cbr"]);
xmzfd.Ms = Convert.ToString(dr["ms"]);
xmzfd.Zfje = Convert.ToDecimal(dr["zfje"]);
return(xmzfd);
}
else
{
return(null);
}
}
public void InsertXmzfdDal(Bill_xmzfd xmzfd, SqlTransaction tran)
{
string sql = @"insert into bill_xmzfd(billcode,sj,zfDept,zfxm,zynr,sm,cbr,ms,zfje) values (@billcode,@sj,@zfDept,@zfxm,@zynr,@sm,@cbr,@ms,@zfje)";
SqlParameter[] parameters =
{
new SqlParameter("@billcode", SqlNull(xmzfd.Billcode)),
new SqlParameter("@sj", SqlNull(xmzfd.Sj)),
new SqlParameter("@zfDept", SqlNull(xmzfd.ZfDept)),
new SqlParameter("@zfxm", SqlNull(xmzfd.Zfxm)),
new SqlParameter("@zynr", SqlNull(xmzfd.Zynr)),
new SqlParameter("@sm", SqlNull(xmzfd.Sm)),
new SqlParameter("@cbr", SqlNull(xmzfd.Cbr)),
new SqlParameter("@ms", SqlNull(xmzfd.Ms)),
new SqlParameter("@zfje", SqlNull(xmzfd.Zfje))
};
DataHelper.ExcuteNonQuery(sql, tran, parameters, false);
}
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 InsertXmzfdDal(Bill_xmzfd xmzfd, Bill_Main main)
{
xmzfdal.InsertXmzfdDal(xmzfd, main);
}
