/// <summary>
/// 新增到货单
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int AddReachGoodsBill(ReachGoodsBill model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into OA_ReachGoodsBill(");
strSql.Append("ReachGoodsBillID,ReachGoodsBillCode,BuyOrderCode,ReachGoodsDate,CreateBillTime,CreateUserID,InforPerson,Remark,BuyOrderID)");
strSql.Append(" values (");
strSql.Append("@ReachGoodsBillID,@ReachGoodsBillCode,@BuyOrderCode,@ReachGoodsDate,@CreateBillTime,@CreateUserID,@InforPerson,@Remark,@BuyOrderID)");
SqlParameter[] parameters =
{
new SqlParameter("@ReachGoodsBillID", SqlDbType.VarChar, 36),
new SqlParameter("@ReachGoodsBillCode", SqlDbType.NVarChar, 50),
new SqlParameter("@BuyOrderCode", SqlDbType.NVarChar, 50),
new SqlParameter("@ReachGoodsDate", SqlDbType.Char, 8),
new SqlParameter("@CreateBillTime", SqlDbType.DateTime),
new SqlParameter("@CreateUserID", SqlDbType.VarChar, 36),
new SqlParameter("@InforPerson", SqlDbType.VarChar, 36),
new SqlParameter("@Remark", SqlDbType.NVarChar, 300),
new SqlParameter("@BuyOrderID", SqlDbType.VarChar, 36)
};
parameters[0].Value = model.ReachGoodsBillID;
parameters[1].Value = model.ReachGoodsBillCode;
parameters[2].Value = model.BuyOrderCode;
parameters[3].Value = model.ReachGoodsDate;
parameters[4].Value = model.CreateBillTime;
parameters[5].Value = model.CreateUserID;
parameters[6].Value = model.InforPerson;
parameters[7].Value = model.Remark;
parameters[8].Value = model.BuyOrderID;
IDbTransaction transaction = DBAccess.BeginDbTransaction(DB.Type, DB.ConnectionString);
try
{
DBAccess.ExecuteNonQuery(DB.Type, DB.ConnectionString, CommandType.Text, strSql.ToString(), parameters);
ReachGoodsBillItemDAL item = new ReachGoodsBillItemDAL();
item.Save(model.ReachGoodsBillID);
transaction.Commit();
}
catch
{
transaction.Rollback();
}
return(1);
}
/// <summary>
/// 新增到货单
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int AddReachGoodsBill(ReachGoodsBill model)
{
return(iReachGoodsBillDAL.AddReachGoodsBill(model));
}
