示例#1
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(Model.order_gift model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into " + databaseprefix + "order_gift(");
            strSql.Append("order_id,gift_id,company)");
            strSql.Append(" values (");
            strSql.Append("@order_id,@gift_id,@company)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters =
            {
                new SqlParameter("@order_id", SqlDbType.Int, 4),
                new SqlParameter("@gift_id",  SqlDbType.Int, 4),
                new SqlParameter("@company",  SqlDbType.Int, 4)
            };
            parameters[0].Value = model.order_id;
            parameters[1].Value = model.gift_id;
            parameters[2].Value = model.company;
            object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);

            if (obj == null)
            {
                return(0);
            }
            else
            {
                return(Convert.ToInt32(obj));
            }
        }
示例#2
0
 /// <summary>
 /// 增加一条数据
 /// </summary>
 public int Add(Model.order_gift model)
 {
     return(dal.Add(model));
 }