/// <summary> /// 新增行 /// </summary> /// <param name="model"></param> /// <returns></returns> public int InsertItem(ReachGoodsBillItem model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into OA_ReachGoodsBillItem("); strSql.Append("ReachGoodsBillItemID,ReachGoodsBillID,MaterialsID,ReachQty,BuyQty,Remark,ReachCost)"); strSql.Append(" values ("); strSql.Append("@ReachGoodsBillItemID,@ReachGoodsBillID,@MaterialsID,@ReachQty,@BuyQty,@Remark,@ReachCost)"); SqlParameter[] parameters = { new SqlParameter("@ReachGoodsBillItemID", SqlDbType.VarChar, 36), new SqlParameter("@ReachGoodsBillID", SqlDbType.VarChar, 36), new SqlParameter("@MaterialsID", SqlDbType.VarChar, 36), new SqlParameter("@ReachQty", SqlDbType.Int, 4), new SqlParameter("@BuyQty", SqlDbType.Int, 4), new SqlParameter("@Remark", SqlDbType.NVarChar, 300), new SqlParameter("@ReachCost", SqlDbType.Decimal, 9) }; parameters[0].Value = model.ReachGoodsBillItemID; parameters[1].Value = model.ReachGoodsBillID; parameters[2].Value = model.MaterialsID; parameters[3].Value = model.ReachQty; parameters[4].Value = model.BuyQty; parameters[5].Value = model.Remark; parameters[6].Value = model.ReachCost; return(DBAccess.ExecuteNonQuery(DB.Type, DB.ConnectionString, CommandType.Text, strSql.ToString(), parameters)); }
/// <summary> /// 新增行 /// </summary> /// <param name="model"></param> /// <returns></returns> public int InsertItem(ReachGoodsBillItem model) { return(iReachGoodsBillItemDAL.InsertItem(model)); }