public void AddFykm(Bill_Ybbxmxb_Fykm model, SqlTransaction tran)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into bill_ybbxmxb_fykm(");
strSql.Append("billCode,fykm,je,mxGuid,status,se");
strSql.Append(") values (");
strSql.Append("@billCode,@fykm,@je,@mxGuid,@status,@se");
strSql.Append(") ");
SqlParameter[] parameters =
{
new SqlParameter("@billCode", SqlDbType.VarChar, 50),
new SqlParameter("@fykm", SqlDbType.VarChar, 50),
new SqlParameter("@je", SqlDbType.Float, 8),
new SqlParameter("@mxGuid", SqlDbType.VarChar, 50),
new SqlParameter("@status", SqlDbType.VarChar, 2),
new SqlParameter("@se", SqlDbType.Decimal, 9)
};
parameters[0].Value = SqlNull(model.BillCode);
parameters[1].Value = SqlNull(model.Fykm);
parameters[2].Value = SqlNull(model.Je);
parameters[3].Value = SqlNull(model.MxGuid);
parameters[4].Value = SqlNull(model.Status);
parameters[5].Value = SqlNull(model.Se);
DataHelper.ExcuteNonQuery(strSql.ToString(), tran, parameters, false);
}
public bool Ph_Add(Bill_Main main, Bill_Ybbxmxb ybbx, Bill_Ybbxmxb_Fykm fykm, IList <Bill_Ybbxmxb_Fykm_Dept> hsbmList, IList <Bill_Ybbxmxb_Hsxm> hsxmList)
{
using (SqlConnection conn = new SqlConnection(DataHelper.constr))
{
conn.Open();
SqlTransaction tran = conn.BeginTransaction();
try
{
DeleteMain(main.BillCode, tran);
InsertMain(main, tran);
AddYbbxmx(ybbx, tran);
AddFykm(fykm, tran);
AddHsbm(hsbmList, tran);
AddHsXm(hsxmList, tran);
DeletePh_mainByBillCode(main.BillCode, tran);
tran.Commit();
return(true);
}
catch
{
tran.Rollback();
throw;
}
}
}
public void InsertYbbxKm(Bill_Ybbxmxb_Fykm fykm, SqlTransaction tran)
{
string sql = @"insert into bill_ybbxmxb_fykm( billCode, fykm, je, mxGuid, status, se,ms)values
( @billCode, @fykm, @je, @mxGuid, @status, @se,@ms)";
SqlParameter[] sps =
{
new SqlParameter("@billCode", fykm.BillCode),
new SqlParameter("@fykm", fykm.Fykm),
new SqlParameter("@je", SqlNull(fykm.Je)),
new SqlParameter("@mxGuid", fykm.MxGuid),
new SqlParameter("@status", fykm.Status),
new SqlParameter("@se", SqlNull(fykm.Se)),
new SqlParameter("@ms", SqlNull(fykm.ms))
};
DataHelper.ExcuteNonQuery(sql, tran, sps, false);
}
public IList <Bill_Ybbxmxb_Fykm> GetFykm(string billCode)
{
string sql = "select * from Bill_Ybbxmxb_Fykm where billcode=@billCode";
SqlParameter[] sps = { new SqlParameter("@billCode", billCode) };
DataTable dt = DataHelper.GetDataTable(sql, sps, false);
IList <Bill_Ybbxmxb_Fykm> list = new List <Bill_Ybbxmxb_Fykm>();
foreach (DataRow dr in dt.Rows)
{
Bill_Ybbxmxb_Fykm fykm = new Bill_Ybbxmxb_Fykm();
fykm.BillCode = Convert.ToString(dr["BillCode"]);
fykm.Fykm = Convert.ToString(dr["Fykm"]);
fykm.Je = Convert.ToDecimal(dr["Je"]);
fykm.MxGuid = Convert.ToString(dr["MxGuid"]);
fykm.Se = Convert.ToDecimal(SetDBNull(dr["Se"]));
fykm.Status = Convert.ToString(dr["Status"]);
fykm.DeptList = GetDept(fykm.MxGuid);
fykm.XmList = GetXm(fykm.MxGuid);
list.Add(fykm);
}
return(list);
}
