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 Bill_Ybbxmxb GetYbbx(string billCode)
{
string sql = "select * from Bill_Ybbxmxb where billcode=@billCode";
SqlParameter[] sps = { new SqlParameter("@billCode", billCode) };
Bill_Ybbxmxb main = new Bill_Ybbxmxb();
using (SqlDataReader dr = DataHelper.GetDataReader(sql, sps))
{
if (dr.Read())
{
main.BillCode = Convert.ToString(dr["BillCode"]);
main.Bxmxlx = Convert.ToString(dr["Bxmxlx"]);
main.Bxr = Convert.ToString(dr["Bxr"]);
main.Bxsm = Convert.ToString(dr["Bxsm"]);
main.Bxzy = Convert.ToString(dr["Bxzy"]);
main.Bxrphone = dr["bxrphone"].ToString();
main.Bxrzh = dr["bxrzh"].ToString();
main.Gfr = Convert.ToString(SetDBNull(dr["Gfr"]));
if (dr["Gfsj"] == DBNull.Value)
{
main.Gfsj = null;
}
else
{
main.Gfsj = Convert.ToDateTime(dr["Gfsj"]);
}
main.Sfdk = Convert.ToString(dr["Sfdk"]);
main.Sfgf = Convert.ToString(dr["Sfgf"]);
main.Ybje = Convert.ToDecimal(dr["Ybje"]);
main.Ytje = Convert.ToDecimal(dr["Ytje"]);
main.Bxdjs = Convert.ToInt32(SetDBNull(dr["Bxdjs"]));
main.Bxr2 = Convert.ToString(dr["Bxr2"]);
main.Ykfs = Convert.ToString(dr["ykfs"]); //用款方式
main.Sqlx = Convert.ToString(dr["sqlx"]); //申请类型
main.note0 = Convert.ToString(dr["note0"]); //退费单的录入信息
main.note1 = Convert.ToString(dr["note1"]); //退费单报销费用信息
main.note2 = Convert.ToString(dr["note2"]);
main.note3 = Convert.ToString(dr["note3"]);
main.note4 = Convert.ToString(dr["note4"]);
main.note5 = Convert.ToString(dr["note5"]);
}
else
{
return(null);
}
}
main.KmList = GetFykm(main.BillCode);
main.FysqList = GetFysq(main.BillCode);
return(main);
}
public void AddYbbxmx(Bill_Ybbxmxb model, SqlTransaction tran)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into bill_ybbxmxb(");
strSql.Append("billCode,bxr,bxzy,bxsm,ytje,ybje,sfgf,bxmxlx");
strSql.Append(") values (");
strSql.Append("@billCode,@bxr,@bxzy,@bxsm,@ytje,@ybje,@sfgf,@bxmxlx");
strSql.Append(") ");
SqlParameter[] parameters =
{
new SqlParameter("@billCode", SqlDbType.VarChar, 50),
new SqlParameter("@bxr", SqlDbType.VarChar, 50),
new SqlParameter("@bxzy", SqlDbType.VarChar, 2000),
new SqlParameter("@bxsm", SqlDbType.VarChar, 2000),
new SqlParameter("@ytje", SqlDbType.Float, 8),
new SqlParameter("@ybje", SqlDbType.Float, 8),
new SqlParameter("@sfgf", SqlDbType.VarChar, 1),
new SqlParameter("@bxmxlx", SqlDbType.VarChar, 50)
};
parameters[0].Value = SqlNull(model.BillCode);
parameters[1].Value = SqlNull(model.Bxr);
parameters[2].Value = SqlNull(model.Bxzy);
parameters[3].Value = SqlNull(model.Bxsm);
parameters[4].Value = SqlNull(model.Ytje);
parameters[5].Value = SqlNull(model.Ybje);
parameters[6].Value = SqlNull(model.Sfgf);
parameters[7].Value = SqlNull(model.Bxmxlx);
DataHelper.ExcuteNonQuery(strSql.ToString(), tran, parameters, false);
}
public void InsertYbbxmxb(Bill_Ybbxmxb ybbxmx, SqlTransaction tran)
{
string sql = @" insert into bill_ybbxmxb ( billCode, bxr,bxrzh,bxrphone,bxzy, bxsm, sfdk, ytje, ybje, sfgf, bxmxlx, gfr, gfsj,bxdjs,guazhang,pzcode,pzdate,bxr2,fujian,sqlx,ykfs,note0,note1,note2,note3,note4,note5) values
(@billCode, @bxr,@bxrzh,@bxrphone, @bxzy, @bxsm, @sfdk, @ytje, @ybje, @sfgf, @bxmxlx, @gfr, @gfsj,@bxdjs,@guazhang,@pzcode,@pzdate,@bxr2,@fujian,@sqlx,@ykfs,@note0,@note1,@note2,@note3,@note4,@note5)";
SqlParameter[] sps =
{
new SqlParameter("@billCode", SqlNull(ybbxmx.BillCode)),
new SqlParameter("@bxr", SqlNull(ybbxmx.Bxr)),
new SqlParameter("@bxrzh", SqlNull(ybbxmx.Bxrzh)),
new SqlParameter("@bxrphone", SqlNull(ybbxmx.Bxrphone)),
new SqlParameter("@bxzy", SqlNull(ybbxmx.Bxzy)),
new SqlParameter("@bxsm", SqlNull(ybbxmx.Bxsm)),
new SqlParameter("@sfdk", SqlNull(ybbxmx.Sfdk)),
new SqlParameter("@ytje", SqlNull(ybbxmx.Ytje)),
new SqlParameter("@ybje", SqlNull(ybbxmx.Ybje)),
new SqlParameter("@sfgf", SqlNull(ybbxmx.Sfgf)),
new SqlParameter("@bxmxlx", SqlNull(ybbxmx.Bxmxlx)),
new SqlParameter("@gfr", SqlNull(ybbxmx.Gfr)),
new SqlParameter("@gfsj", SqlNull(ybbxmx.Gfsj)),
new SqlParameter("@guazhang", SqlNull(ybbxmx.Guazhang)),
new SqlParameter("@pzcode", SqlNull(ybbxmx.Pzcode)),
new SqlParameter("@pzdate", SqlNull(ybbxmx.Pzdate)),
new SqlParameter("@bxdjs", SqlNull(ybbxmx.Bxdjs)),
new SqlParameter("@bxr2", SqlNull(ybbxmx.Bxr2)),
new SqlParameter("@fujian", SqlNull(ybbxmx.fujian)),
new SqlParameter("@sqlx", SqlNull(ybbxmx.Sqlx)),
new SqlParameter("@ykfs", SqlNull(ybbxmx.Ykfs)),
new SqlParameter("@note0", SqlNull(ybbxmx.note0)),
new SqlParameter("@note1", SqlNull(ybbxmx.note1)),
new SqlParameter("@note2", SqlNull(ybbxmx.note2)),
new SqlParameter("@note3", SqlNull(ybbxmx.note3)),
new SqlParameter("@note4", SqlNull(ybbxmx.note4)),
new SqlParameter("@note5", SqlNull(ybbxmx.note5))
};
DataHelper.ExcuteNonQuery(sql, tran, sps, false);
}
