/// <summary>
/// 产品添加、修改，返回1成功，其它失败
/// </summary>
/// <param name="info">实体</param>
/// <returns></returns>
public int ChanPin_CU(EyouSoft.Model.MChanPinInfo info)
{
var cmd = _db.GetStoredProcCommand("proc_ChanPin_CU");
_db.AddInParameter(cmd, "@ChanPinId", DbType.AnsiStringFixedLength, info.ChanPinId);
_db.AddInParameter(cmd, "@GysId", DbType.AnsiStringFixedLength, info.GysId);
_db.AddInParameter(cmd, "@Name", DbType.String, info.Name);
_db.AddInParameter(cmd, "@PinPai", DbType.String, info.PinPai);
_db.AddInParameter(cmd, "@GuiGe", DbType.String, info.GuiGe);
_db.AddInParameter(cmd, "@JiLiangDanWei", DbType.String, info.JiLiangDanWei);
_db.AddInParameter(cmd, "@JiaGe1", DbType.Currency, info.JiaGe1);
_db.AddInParameter(cmd, "@JieShao", DbType.String, info.JieShao);
_db.AddInParameter(cmd, "@CaoZuoRenId", DbType.AnsiStringFixedLength, info.CaoZuoRenId);
_db.AddInParameter(cmd, "@IssueTime", DbType.DateTime, info.IssueTime);
_db.AddInParameter(cmd, "@FuJianXml", DbType.String, CreateFuJianXml(info.FuJians));
_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>
/// 产品修改，返回1成功，其它失败
/// </summary>
/// <param name="info">实体</param>
/// <returns></returns>
public int ChanPin_U(EyouSoft.Model.MChanPinInfo info)
{
if (info == null ||
string.IsNullOrEmpty(info.CaoZuoRenId) ||
string.IsNullOrEmpty(info.GysId) ||
string.IsNullOrEmpty(info.Name) ||
string.IsNullOrEmpty(info.ChanPinId))
{
return(0);
}
info.IssueTime = DateTime.Now;
int dalRetCode = dal.ChanPin_CU(info);
if (dalRetCode == 1)
{
var logInfo = new EyouSoft.Model.MCaoZuoLogInfo();
logInfo.BiaoTi = "修改产品信息";
logInfo.NeiRong = "修改产品信息，产品编号：" + info.ChanPinId + "。";
logInfo.GuanLianId = info.ChanPinId;
BCaoZuoLog.Log_C(logInfo);
}
return(dalRetCode);
}
/// <summary>
/// 获取产品信息业务实体
/// </summary>
/// <param name="chanPinId">产品编号</param>
/// <returns></returns>
public EyouSoft.Model.MChanPinInfo GetInfo(string chanPinId)
{
EyouSoft.Model.MChanPinInfo info = null;
var cmd = _db.GetSqlStringCommand("SELECT A.*,B.Name AS CaoZuoRenName,(SELECT A1.Name FROM tbl_GongSi AS A1 WHERE A1.GongSiId=A.GysId) AS GysName FROM [tbl_ChanPin] AS A INNER JOIN tbl_YongHu AS B ON A.CaoZuoRenId=B.YongHuId WHERE A.ChanPinId=@ChanPinId");
_db.AddInParameter(cmd, "@ChanPinId", DbType.AnsiStringFixedLength, chanPinId);
using (var rdr = DbHelper.ExecuteReader(cmd, _db))
{
if (rdr.Read())
{
info = new EyouSoft.Model.MChanPinInfo();
info.BianMa = rdr["BianMa"].ToString();
info.CaoZuoRenId = rdr["CaoZuoRenId"].ToString();
info.ChanPinId = rdr["ChanPinId"].ToString();
info.FuJians = null;
info.GuiGe = rdr["GuiGe"].ToString();
info.GysId = rdr["GysId"].ToString();
info.IssueTime = rdr.GetDateTime(rdr.GetOrdinal("IssueTime"));
info.JiaGe1 = rdr.GetDecimal(rdr.GetOrdinal("JiaGe1"));
info.JiaGe2 = rdr.GetDecimal(rdr.GetOrdinal("JiaGe2"));
info.JieShao = rdr["JieShao"].ToString();
info.JiLiangDanWei = rdr["JiLiangDanWei"].ToString();
info.Name = rdr["Name"].ToString();
info.PinPai = rdr["PinPai"].ToString();
info.GysName = rdr["GysName"].ToString();
info.CaoZuoRenName = rdr["CaoZuoRenName"].ToString();
}
}
if (info != null)
{
info.FuJians = GetChanPinFuJians(chanPinId);
}
return(info);
}
/// <summary>
/// 获取产品信息集合
/// </summary>
/// <param name="pageSize">页记录数</param>
/// <param name="pageIndex">页序号</param>
/// <param name="recordCount">总记录数</param>
/// <param name="chaXun">查询</param>
/// <returns></returns>
public IList <EyouSoft.Model.MChanPinInfo> GetChanPins(int pageSize, int pageIndex, ref int recordCount, EyouSoft.Model.MChanPinChaXunInfo chaXun)
{
IList <EyouSoft.Model.MChanPinInfo> items = new List <EyouSoft.Model.MChanPinInfo>();
string fields = "*,(SELECT A1.Name FROM tbl_YongHu AS A1 WHERE A1.YongHuId=tbl_ChanPin.CaoZuoRenId) AS CaoZuoRenName,(SELECT A1.Name FROM tbl_GongSi AS A1 WHERE A1.GongSiId=tbl_ChanPin.GysId) AS GysName";
StringBuilder sql = new StringBuilder();
string tableName = "tbl_ChanPin";
string orderByString = " IssueTime DESC ";
string heJiString = "";
#region sql
sql.Append(" IsDelete='0' ");
if (chaXun != null)
{
if (!string.IsNullOrEmpty(chaXun.BianMa))
{
sql.AppendFormat(" AND BianMa LIKE '%{0}%' ", chaXun.BianMa);
}
if (chaXun.FaBuTime1.HasValue)
{
sql.AppendFormat(" AND IssueTime>'{0}' ", chaXun.FaBuTime1.Value.AddMinutes(-1));
}
if (chaXun.FaBuTime2.HasValue)
{
sql.AppendFormat(" AND IssueTime<'{0}' ", chaXun.FaBuTime1.Value.AddDays(1).AddMinutes(-1));
}
if (!string.IsNullOrEmpty(chaXun.GysId))
{
sql.AppendFormat(" AND GysId='{0}' ", chaXun.GysId);
}
if (!string.IsNullOrEmpty(chaXun.GysName))
{
sql.AppendFormat(" AND EXISTS(SELECT 1 FROM dbo.tbl_GongSi G WHERE G.GongSiId=tbl_ChanPin.GysId AND G.Name LIKE '%{0}%') ", chaXun.GysName);
}
if (!string.IsNullOrEmpty(chaXun.Name))
{
sql.AppendFormat(" AND Name LIKE '%{0}%' ", chaXun.Name);
}
if (!string.IsNullOrEmpty(chaXun.CgsId))
{
sql.AppendFormat(" AND EXISTS(SELECT 1 FROM tbl_GongSiGuanXi AS A1 WHERE A1.GongSiId2=tbl_ChanPin.GysId AND A1.GongSiId1='{0}') ", chaXun.CgsId);
}
if (!string.IsNullOrEmpty(chaXun.PinPai))
{
sql.AppendFormat(" AND PinPai LIKE '%{0}%' ", chaXun.PinPai);
}
if (!string.IsNullOrEmpty(chaXun.GuiGe))
{
sql.AppendFormat(" AND GuiGe LIKE '%{0}%' ", chaXun.GuiGe);
}
}
#endregion
using (IDataReader rdr = DbHelper.ExecuteReader1(_db, pageSize, pageIndex, ref recordCount, tableName, fields, sql.ToString(), orderByString, heJiString))
{
while (rdr.Read())
{
var info = new EyouSoft.Model.MChanPinInfo();
info.BianMa = rdr["BianMa"].ToString();
info.CaoZuoRenId = rdr["CaoZuoRenId"].ToString();
info.ChanPinId = rdr["ChanPinId"].ToString();
info.FuJians = null;
info.GuiGe = rdr["GuiGe"].ToString();
info.GysId = rdr["GysId"].ToString();
info.IssueTime = rdr.GetDateTime(rdr.GetOrdinal("IssueTime"));
info.JiaGe1 = rdr.GetDecimal(rdr.GetOrdinal("JiaGe1"));
info.JiaGe2 = rdr.GetDecimal(rdr.GetOrdinal("JiaGe2"));
info.JieShao = rdr["JieShao"].ToString();
info.JiLiangDanWei = rdr["JiLiangDanWei"].ToString();
info.Name = rdr["Name"].ToString();
info.PinPai = rdr["PinPai"].ToString();
info.CaoZuoRenName = rdr["CaoZuoRenName"].ToString();
info.GysName = rdr["GysName"].ToString();
items.Add(info);
}
}
return(items);
}
