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