/// <summary> /// 会员点赞新增、修改、删除,返回1成功,其它失败 /// </summary> /// <param name="FS">C:新增 U:修改 D:删除</param> /// <param name="info">实体</param> /// <returns></returns> public int HuiYuanDianZan_CUD(string FS, Eyousoft_yhq.Model.MHuiYuanDianZanInfo info) { var cmd = _db.GetStoredProcCommand("proc_HuiYuan_DianZan_CUD"); _db.AddInParameter(cmd, "@IdentityId", DbType.Int32, info.IdentityId); _db.AddInParameter(cmd, "@HuiYuanId1", DbType.AnsiStringFixedLength, info.HuiYuanId1); _db.AddInParameter(cmd, "@HuiYuanId2", DbType.AnsiStringFixedLength, info.HuiYuanId2); _db.AddInParameter(cmd, "@IssueTime", DbType.DateTime, info.IssueTime); _db.AddInParameter(cmd, "@FS", DbType.AnsiStringFixedLength, FS); _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="huiYuanId">会员编号</param> /// <returns></returns> public IList <Eyousoft_yhq.Model.MHuiYuanDianZanInfo> GetDianZans(string huiYuanId) { IList <Eyousoft_yhq.Model.MHuiYuanDianZanInfo> items = new List <Eyousoft_yhq.Model.MHuiYuanDianZanInfo>(); var cmd = _db.GetSqlStringCommand("SELECT * FROM view_HuiYuan_DianZan WHERE HuiYuanId2=@HuiYuanId ORDER BY IdentityId DESC"); _db.AddInParameter(cmd, "HuiYuanId", DbType.AnsiStringFixedLength, huiYuanId); using (var rdr = DbHelper.ExecuteReader(cmd, _db)) { while (rdr.Read()) { var item = new Eyousoft_yhq.Model.MHuiYuanDianZanInfo(); item.HuiYuanId1 = rdr["HuiYuanId1"].ToString(); item.HuiYuanId2 = rdr["HuiYuanId2"].ToString(); item.IdentityId = rdr.GetInt32(rdr.GetOrdinal("IdentityId")); item.IssueTime = rdr.GetDateTime(rdr.GetOrdinal("IssueTime")); item.HuiYuanName1 = rdr["HuiYuanXingMing1"].ToString(); item.HuiYuanName2 = rdr["HuiYuanXingMing2"].ToString(); item.HuiYuanTuXiangFilepath1 = rdr["HuiYuanTuXiangFilepath1"].ToString(); item.HuiYuanTuXiangFilepath2 = rdr["HuiYuanTuXiangFilepath2"].ToString(); item.MingPianId1 = rdr["MingPianId1"].ToString(); item.MingPianId2 = rdr["MingPianId2"].ToString(); items.Add(item); } } return(items); }
/// <summary> /// 获取会员被点赞信息集合(被动) /// </summary> /// <param name="huiYuanId">会员编号</param> /// <returns></returns> public IList<Eyousoft_yhq.Model.MHuiYuanDianZanInfo> GetDianZans(string huiYuanId) { IList<Eyousoft_yhq.Model.MHuiYuanDianZanInfo> items = new List<Eyousoft_yhq.Model.MHuiYuanDianZanInfo>(); var cmd = _db.GetSqlStringCommand("SELECT * FROM view_HuiYuan_DianZan WHERE HuiYuanId2=@HuiYuanId ORDER BY IdentityId DESC"); _db.AddInParameter(cmd, "HuiYuanId", DbType.AnsiStringFixedLength, huiYuanId); using (var rdr = DbHelper.ExecuteReader(cmd, _db)) { while (rdr.Read()) { var item =new Eyousoft_yhq.Model.MHuiYuanDianZanInfo(); item.HuiYuanId1 = rdr["HuiYuanId1"].ToString(); item.HuiYuanId2 = rdr["HuiYuanId2"].ToString(); item.IdentityId = rdr.GetInt32(rdr.GetOrdinal("IdentityId")); item.IssueTime = rdr.GetDateTime(rdr.GetOrdinal("IssueTime")); item.HuiYuanName1 = rdr["HuiYuanXingMing1"].ToString(); item.HuiYuanName2 = rdr["HuiYuanXingMing2"].ToString(); item.HuiYuanTuXiangFilepath1 = rdr["HuiYuanTuXiangFilepath1"].ToString(); item.HuiYuanTuXiangFilepath2 = rdr["HuiYuanTuXiangFilepath2"].ToString(); item.MingPianId1 = rdr["MingPianId1"].ToString(); item.MingPianId2 = rdr["MingPianId2"].ToString(); items.Add(item); } } return items; }
/// <summary> /// 会员点赞-点赞,返回1成功,其它失败 /// </summary> /// <param name="huiYuanId1">点赞会员编号</param> /// <param name="huiYuanId2">对方会员编号</param> /// <returns></returns> public int HuiYuanDianZan(string huiYuanId1, string huiYuanId2) { if (string.IsNullOrEmpty(huiYuanId1) || string.IsNullOrEmpty(huiYuanId2)) { return(0); } var info = new Eyousoft_yhq.Model.MHuiYuanDianZanInfo(); info.HuiYuanId1 = huiYuanId1; info.HuiYuanId2 = huiYuanId2; info.IdentityId = 0; info.IssueTime = DateTime.Now; return(dal.HuiYuanDianZan_CUD("C", info)); }
/// <summary> /// 会员点赞-点赞,返回1成功,其它失败 /// </summary> /// <param name="huiYuanId1">点赞会员编号</param> /// <param name="huiYuanId2">对方会员编号</param> /// <returns></returns> public int HuiYuanDianZan(string huiYuanId1, string huiYuanId2) { if (string.IsNullOrEmpty(huiYuanId1) || string.IsNullOrEmpty(huiYuanId2)) return 0; var info = new Eyousoft_yhq.Model.MHuiYuanDianZanInfo(); info.HuiYuanId1 = huiYuanId1; info.HuiYuanId2 = huiYuanId2; info.IdentityId = 0; info.IssueTime = DateTime.Now; return dal.HuiYuanDianZan_CUD("C", info); }