예제 #1
0
        /// <summary>
        /// 添加订单
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public int CreateStrikeOrder(Tz888.Model.StrikeOrder model)
        {
            SqlParameter[] parameters =
            {
                new SqlParameter("@flag",         SqlDbType.VarChar,  50),

                new SqlParameter("@PayTypeCode",  SqlDbType.Char,     10),
                new SqlParameter("@LoginName",    SqlDbType.Char,     16),
                new SqlParameter("@StrikeName",   SqlDbType.VarChar,  50),

                new SqlParameter("@Email",        SqlDbType.VarChar,  50),
                new SqlParameter("@Tel",          SqlDbType.VarChar,  30),
                new SqlParameter("@MobileNo",     SqlDbType.VarChar,  23),
                new SqlParameter("@RealName",     SqlDbType.Char,      8),

                new SqlParameter("@TotalCount",   SqlDbType.Float,     8),
                new SqlParameter("@OtherInfo",    SqlDbType.VarChar, 100),
                new SqlParameter("@remark",       SqlDbType.VarChar, 100),
                new SqlParameter("@OperationMan", SqlDbType.VarChar, 100),
                new SqlParameter("@OrderNo",      SqlDbType.BigInt),
            };

            parameters[0].Value = "Order_Insert";
            parameters[1].Value = model.PayTypeCode;

            parameters[2].Value = model.LoginName;
            parameters[3].Value = model.StrikeLoginName;

            parameters[4].Value = model.Email;
            parameters[5].Value = model.Tel;
            parameters[6].Value = model.MobileNo;
            parameters[7].Value = model.RealName;

            parameters[8].Value = model.TotalCount;
            parameters[9].Value = model.OtherInfo;

            parameters[10].Value = model.remark;
            parameters[11].Value = model.OperationMan;

            parameters[12].Direction = ParameterDirection.Output;


            int orderno = DbHelperSQL.RunProcReturn("StrikeOrder", parameters);

            return(orderno);
        }
예제 #2
0
 /// <summary>
 /// 生成在线充值订单
 /// </summary>
 /// <param name="model"></param>
 /// <returns></returns>
 public int CreateStrikeOrder(Tz888.Model.StrikeOrder model)
 {
     return(dal.CreateStrikeOrder(model));
 }