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