Beispiel #1
0
        /// <summary>
        /// Add the specified model.
        /// </summary>
        /// <param name="model">Model.</param>
        public bool Add(OrderInfo model)
        {
            model.CreateDate = DateTime.Now;
            CommandStruct command = new CommandStruct("OrderInfo", CommandMode.Insert);
            command.AddParameter("OrderNO", SqlDbType.VarChar, model.OrderNO);
            command.AddParameter("MerchandiseName", SqlDbType.VarChar, model.MerchandiseName);
            command.AddParameter("PayType", SqlDbType.VarChar, model.PayType);
            command.AddParameter("Amount", SqlDbType.Decimal, model.Amount);
            command.AddParameter("Currency", SqlDbType.VarChar, model.Currency);
            command.AddParameter("Expand", SqlDbType.VarChar, model.Expand);
            command.AddParameter("SerialNumber", SqlDbType.VarChar, model.SerialNumber);
            command.AddParameter("PassportID", SqlDbType.VarChar, model.PassportID);
            command.AddParameter("ServerID", SqlDbType.Int, model.ServerID);
            command.AddParameter("GameID", SqlDbType.Int, model.GameID);
            command.AddParameter("gameName", SqlDbType.VarChar, model.GameName);
            command.AddParameter("ServerName", SqlDbType.VarChar, model.ServerName);
            command.AddParameter("PayStatus", SqlDbType.Int, model.PayStatus);
            command.AddParameter("Signature", SqlDbType.VarChar, model.Signature);
            command.AddParameter("Remarks", SqlDbType.Text, model.Remarks);
            command.AddParameter("GameCoins", SqlDbType.Int, model.GameCoins);
            command.AddParameter("SendState", SqlDbType.Int, model.SendState);
            command.AddParameter("RetailID", SqlDbType.VarChar, model.RetailID);//添加渠道商ID 孙德尧 2012/4/1 9:24
            command.AddParameter("DeviceID", SqlDbType.VarChar, model.DeviceID == null ? string.Empty : model.DeviceID);
            if (model.SendDate > DateTime.MinValue)
            {
                command.AddParameter("SendDate", SqlDbType.DateTime, model.SendDate);
            }
            command.AddParameter("CreateDate", SqlDbType.DateTime, model.CreateDate);
            command.Parser();

            int rows = SqlHelper.ExecuteNonQuery(ConfigManger.connectionString, CommandType.Text, command.Sql, command.SqlParameters);
            if (rows > 0)
                return true;
            return false;
        }
 /// <summary>
 /// 生成Sql语句
 /// </summary>
 /// <param name="identityId">消息队列负载标识ID</param>
 /// <param name="command">命令对象</param>
 /// <returns></returns>
 public abstract SqlStatement GenerateSql(int identityId, CommandStruct command);
 /// <summary>
 /// 执行返回影响行数的Sql语句(增,删,改)
 /// </summary>
 /// <param name="command"></param>
 /// <returns></returns>
 public int ExecuteQuery(CommandStruct command)
 {
     command.Parser();
     return(ExecuteQuery(command.CommandType, command.Sql, command.Parameters));
 }
 /// <summary>
 /// 执行只返回第一行第一列值的sql语句
 /// </summary>
 /// <param name="command"></param>
 /// <returns></returns>
 public object ExecuteScalar(CommandStruct command)
 {
     command.Parser();
     return(ExecuteScalar(command.CommandType, command.Sql, command.Parameters));
 }
 /// <summary>
 /// 执行Sql语句
 /// </summary>
 /// <param name="command"></param>
 /// <returns></returns>
 public IDataReader ExecuteReader(CommandStruct command)
 {
     command.Parser();
     return(ExecuteReader(command.CommandType, command.Sql, command.Parameters));
 }
Beispiel #6
0
        /// <summary>
        /// 
        /// </summary>
        /// <param name="info"></param>
        public bool PostFeedBack(FeedbackInfo info)
        {
            CommandStruct command = new CommandStruct("GMFeedBack", CommandMode.Insert);
            command.AddParameter("UId", SqlDbType.Int, info.Uid);
            command.AddParameter("GameID", SqlDbType.Int, info.GameID);
            command.AddParameter("ServerID", SqlDbType.Int, info.ServerID);
            command.AddParameter("GMType", SqlDbType.Int, info.Type);
            command.AddParameter("content", SqlDbType.VarChar, info.Content);
            command.AddParameter("Pid", SqlDbType.VarChar, info.Pid);
            command.AddParameter("NickName", SqlDbType.VarChar, info.NickName);
            command.AddParameter("SubmittedTime", SqlDbType.DateTime, info.CreateDate);
            command.Parser();

            return SqlHelper.ExecuteNonQuery(ConfigManger.connectionString, CommandType.Text, command.Sql, command.SqlParameters) > 0;
        }
Beispiel #7
0
        /// <summary>
        /// 
        /// </summary>
        /// <param name="feedbackId"></param>
        /// <param name="replyContent"></param>
        /// <param name="replyId">回复者</param>
        /// <returns></returns>
        public bool ReplyToFeedBack(int feedbackId, string replyContent, int replyId)
        {
            CommandStruct command = new CommandStruct("GMFeedBack", CommandMode.Modify);
            command.AddParameter("RContent", SqlDbType.VarChar, replyContent);
            command.AddParameter("ReplyID", SqlDbType.VarChar, replyId);
            command.AddParameter("ReplyTime", SqlDbType.DateTime, DateTime.Now);
            command.Filter = new CommandFilter();
            command.Filter.Condition = "GMId=@GMId";
            command.Filter.AddParam("@GMId", SqlDbType.Int, 0, feedbackId);
            command.Parser();

            return SqlHelper.ExecuteNonQuery(ConfigManger.connectionString, CommandType.Text, command.Sql, command.SqlParameters) > 0;
        }
Beispiel #8
0
        internal bool PaySuccess(string orderNo, OrderInfo orderInfo)
        {
            CommandStruct command = new CommandStruct("OrderInfo", CommandMode.Modify);
            orderInfo.PayStatus = 2;
            command.AddParameter("PayStatus", SqlDbType.Int, orderInfo.PayStatus);
            if (!string.IsNullOrEmpty(orderInfo.PayType))
            {
                command.AddParameter("PayType", SqlDbType.VarChar, orderInfo.PayType);
            }
            if (orderInfo.Amount > 0 && orderInfo.GameCoins > 0)
            {
                command.AddParameter("Amount", SqlDbType.Decimal, orderInfo.Amount);
                command.AddParameter("GameCoins", SqlDbType.Int, orderInfo.GameCoins);
            }
            command.Filter = new CommandFilter();
            command.Filter.Condition = "OrderNO=@OrderNO";
            command.Filter.AddParam("@OrderNO", SqlDbType.VarChar, 0, orderNo);
            command.Parser();

            int rows = SqlHelper.ExecuteNonQuery(ConfigManger.connectionString, CommandType.Text, command.Sql, command.SqlParameters);
            return rows > 0;
        }
Beispiel #9
0
        /// <summary>
        /// Updatestr the specified OrderNo.
        /// </summary>
        /// <param name="OrderNo">Order no.</param>
        public bool Updatestr(string OrderNo)
        {
            CommandStruct command = new CommandStruct("OrderInfo", CommandMode.Modify);
            command.AddParameter("SendState", 2);
            command.AddParameter("SendDate", SqlDbType.DateTime, DateTime.Now);
            command.Filter = new CommandFilter();
            command.Filter.Condition = "OrderNO=@OrderNO";
            command.Filter.AddParam("@OrderNO", SqlDbType.VarChar, 0, OrderNo);
            command.Parser();

            int rows = SqlHelper.ExecuteNonQuery(ConfigManger.connectionString, CommandType.Text, command.Sql, command.SqlParameters);
            {
                if (rows > 0)
                {
                    return true;
                }
                else
                {
                    return false;
                }
            }
        }
Beispiel #10
0
 /// <summary>
 /// Updates the by91.
 /// </summary>
 /// <returns><c>true</c>, if by91 was updated, <c>false</c> otherwise.</returns>
 /// <param name="model">Model.</param>
 /// <param name="callback">If set to <c>true</c> callback.</param>
 public bool UpdateBy91(OrderInfo model, bool callback)
 {
     CommandStruct command = new CommandStruct("OrderInfo", CommandMode.Modify);
     if (callback)
     {
         command.AddParameter("MerchandiseName", SqlDbType.VarChar, model.MerchandiseName);
         command.AddParameter("PayType", SqlDbType.VarChar, model.PayType);
         command.AddParameter("Amount", SqlDbType.Decimal, model.Amount);
         command.AddParameter("SendState", SqlDbType.Int, model.SendState);
         command.AddParameter("PayStatus", SqlDbType.Int, model.PayStatus);
         command.AddParameter("GameCoins", SqlDbType.Int, model.GameCoins);
         command.AddParameter("Signature", SqlDbType.VarChar, model.Signature);
     }
     else
     {
         command.AddParameter("ServerID", SqlDbType.Int, model.ServerID);
         command.AddParameter("PassportID", SqlDbType.VarChar, model.PassportID);
         command.AddParameter("GameID", SqlDbType.Int, model.GameID);
         command.AddParameter("RetailID", SqlDbType.VarChar, model.RetailID);//20
         //修改了服务器名称为空写库的BUG panx 2012-11-26
         if (!string.IsNullOrEmpty(model.ServerName))
         {
             command.AddParameter("ServerName", SqlDbType.VarChar, model.ServerName);
         }
         //修改了游戏名称为空写库的BUG panx 2012-11-26
         if (!string.IsNullOrEmpty(model.GameName))
         {
             command.AddParameter("gameName", SqlDbType.VarChar, model.GameName);
         }
     }
     command.Filter = new CommandFilter();
     command.Filter.Condition = "OrderNO=@OrderNO";
     command.Filter.AddParam("@OrderNO", SqlDbType.VarChar, 0, model.OrderNO);
     command.Parser();
     int rows = SqlHelper.ExecuteNonQuery(ConfigManger.connectionString, CommandType.Text, command.Sql, command.SqlParameters);
     return rows > 0;
 }
Beispiel #11
0
        /// <summary>
        /// 修改状态
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool Update(OrderInfo model)
        {
            CommandStruct command = new CommandStruct("OrderInfo", CommandMode.Modify);
            command.AddParameter("SerialNumber", SqlDbType.VarChar, model.SerialNumber);
            command.AddParameter("PayStatus", SqlDbType.Int, model.PayStatus);
            command.AddParameter("@Signature", SqlDbType.VarChar, 0, model.Signature);
            command.Filter = new CommandFilter();
            command.Filter.Condition = "OrderNO=@OrderNO";
            command.Filter.AddParam("@OrderNO", SqlDbType.VarChar, 0, model.OrderNO);
            command.Parser();

            int rows = SqlHelper.ExecuteNonQuery(ConfigManger.connectionString, CommandType.Text, command.Sql, command.SqlParameters);
            return rows > 0;
        }