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