/// <summary> /// 产品价格新增,返回1成功,其它失败 /// </summary> /// <param name="info">实体</param> /// <returns></returns> public int ChanPinJiaGe_C(EyouSoft.Model.MChanPinJiaGeInfo info) { var cmd = _db.GetStoredProcCommand("proc_ChanPinJiaGe_C"); _db.AddInParameter(cmd, "@JiaGeId", DbType.AnsiStringFixedLength, info.JiaGeId); _db.AddInParameter(cmd, "@ChanPinId", DbType.AnsiStringFixedLength, info.ChanPinId); _db.AddInParameter(cmd, "@JiaGe2", DbType.Currency, info.JiaGe2); _db.AddInParameter(cmd, "@ShuoMing", DbType.String, info.ShuoMing); _db.AddInParameter(cmd, "@CaoZuoRenId", DbType.AnsiStringFixedLength, info.CaoZuoRenId); _db.AddInParameter(cmd, "@IssueTime", DbType.DateTime, info.IssueTime); _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); } return(Convert.ToInt32(_db.GetParameterValue(cmd, "@RetCode"))); }
/// <summary> /// 获取产品价格信息集合 /// </summary> /// <param name="chanPinId">产品编号</param> /// <returns></returns> public IList <EyouSoft.Model.MChanPinJiaGeInfo> GetChanPinJiaGes(string chanPinId) { IList <EyouSoft.Model.MChanPinJiaGeInfo> items = new List <EyouSoft.Model.MChanPinJiaGeInfo>(); var cmd = _db.GetSqlStringCommand("SELECT A.*,B.Name AS CaoZuoRenName FROM tbl_ChanPinJiaGe AS A INNER JOIN tbl_YongHu AS B ON A.CaoZuoRenId=B.YongHuId WHERE A.ChanPinId=@ChanPinId ORDER BY A.IssueTime DESC"); _db.AddInParameter(cmd, "ChanPinId", DbType.AnsiStringFixedLength, chanPinId); using (var rdr = DbHelper.ExecuteReader(cmd, _db)) { while (rdr.Read()) { var item = new EyouSoft.Model.MChanPinJiaGeInfo(); item.CaoZuoRenId = rdr["CaoZuoRenId"].ToString(); item.ChanPinId = rdr["ChanPinId"].ToString(); item.IssueTime = rdr.GetDateTime(rdr.GetOrdinal("IssueTime")); item.JiaGe1 = rdr.GetDecimal(rdr.GetOrdinal("JiaGe1")); item.JiaGe2 = rdr.GetDecimal(rdr.GetOrdinal("JiaGe2")); item.JiaGeId = rdr["JiaGeId"].ToString(); item.ShuoMing = rdr["ShuoMing"].ToString(); item.CaoZuoRenName = rdr["CaoZuoRenName"].ToString(); items.Add(item); } } return(items); }
/// <summary> /// 产品价格新增,返回1成功,其它失败 /// </summary> /// <param name="info">实体</param> /// <returns></returns> public int ChanPinJiaGe_C(EyouSoft.Model.MChanPinJiaGeInfo info) { if (info == null || string.IsNullOrEmpty(info.CaoZuoRenId) || string.IsNullOrEmpty(info.ChanPinId)) { return(0); } info.JiaGeId = Guid.NewGuid().ToString(); info.IssueTime = DateTime.Now; int dalRetCode = dal.ChanPinJiaGe_C(info); if (dalRetCode == 1) { var logInfo = new EyouSoft.Model.MCaoZuoLogInfo(); logInfo.BiaoTi = "维护产品价格"; logInfo.NeiRong = "维护产品价格,价格编号:" + info.JiaGeId + "。"; logInfo.GuanLianId = info.JiaGeId; BCaoZuoLog.Log_C(logInfo); } return(dalRetCode); }