/// <summary> /// 新增采购单行 /// </summary> /// <param name="item"></param> /// <returns></returns> public int Add(BuyApplyBillItem item) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into BuyApplyOrderItem("); strSql.Append("BuyApplyOrderItemID,BuyApplyOrderID,MaterialID,BuyQty,BuyCost,BuyUnitID,Remark)"); strSql.Append(" values ("); strSql.Append("@BuyApplyOrderItemID,@BuyApplyOrderID,@MaterialID,@BuyQty,@BuyCost,@BuyUnitID,@Remark)"); SqlParameter[] parameters = { new SqlParameter("@BuyApplyOrderItemID", SqlDbType.VarChar, 36), new SqlParameter("@BuyApplyOrderID", SqlDbType.VarChar, 36), new SqlParameter("@MaterialID", SqlDbType.VarChar, 36), new SqlParameter("@BuyQty", SqlDbType.Decimal, 13), new SqlParameter("@BuyCost", SqlDbType.Decimal, 13), new SqlParameter("@BuyUnitID", SqlDbType.VarChar, 36), new SqlParameter("@Remark", SqlDbType.VarChar, 1024) }; parameters[0].Value = item.BuyApplyOrderItemID; parameters[1].Value = item.BuyApplyOrderID; parameters[2].Value = item.MaterialID; parameters[3].Value = item.BuyQty; parameters[4].Value = item.BuyCost; parameters[5].Value = item.BuyUnitID; parameters[6].Value = item.Remark; return(DBAccess.ExecuteNonQuery(DB.Type, DB.ConnectionString, CommandType.Text, strSql.ToString(), parameters)); }
/// <summary> /// 新增采购单行 /// </summary> /// <param name="item"></param> /// <returns></returns> public int Add(BuyApplyBillItem item) { return(iBuyBillItemDAL.Add(item)); }