/// <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));
}
