Example #1
0
        /// <summary>
        /// 设置礼品卡订单状态,返回1成功,其它失败
        /// </summary>
        /// <param name="dingDanId">订单编号</param>
        /// <param name="operatorId">操作员编号</param>
        /// <param name="status">订单状态</param>
        /// <returns></returns>
        public int SheZhiLiPinKaDingDanStatus(string dingDanId, string operatorId, EyouSoft.Model.EnumType.YlStructure.LiPinKaDingDanStatus status)
        {
            DbCommand cmd = _db.GetStoredProcCommand("proc_YL_LiPinKaDingDan_SheZhiDingDanStatus");

            _db.AddInParameter(cmd, "@DingDanId", DbType.AnsiStringFixedLength, dingDanId);
            _db.AddInParameter(cmd, "@OperatorId", DbType.AnsiStringFixedLength, operatorId);
            _db.AddInParameter(cmd, "@DingDanStatus", DbType.Byte, status);
            _db.AddInParameter(cmd, "@IssueTime", DbType.DateTime, DateTime.Now);
            _db.AddOutParameter(cmd, "@RetCode", DbType.Int32, 4);

            int sqlExceptionCode = 0;

            try
            {
                DbHelper.RunProcedure(cmd, _db);
            }
            catch (System.Data.SqlClient.SqlException e)
            {
                sqlExceptionCode = 0 - e.Number;
            }

            if (sqlExceptionCode < 0)
            {
                return(sqlExceptionCode);
            }
            else
            {
                return(Convert.ToInt32(_db.GetParameterValue(cmd, "RetCode")));
            }
        }
Example #2
0
        /// <summary>
        /// 设置礼品卡订单状态,返回1成功,其它失败
        /// </summary>
        /// <param name="dingDanId">订单编号</param>
        /// <param name="operatorId">操作员编号</param>
        /// <param name="status">订单状态</param>
        /// <returns></returns>
        public int SheZhiLiPinKaDingDanStatus(string dingDanId, string operatorId, EyouSoft.Model.EnumType.YlStructure.LiPinKaDingDanStatus status)
        {
            if (string.IsNullOrEmpty(dingDanId) || string.IsNullOrEmpty(operatorId))
            {
                return(0);
            }

            int dalRetCode = dal.SheZhiLiPinKaDingDanStatus(dingDanId, operatorId, status);

            return(dalRetCode);
        }