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