/// <summary>
/// 会员留言新增、修改、删除，返回1成功，其它失败
/// </summary>
/// <param name="FS">C:新增 U:修改 D:删除 H:回复</param>
/// <param name="info">实体</param>
/// <returns></returns>
public int HuiYuanLiuYan_CUD(string FS, Eyousoft_yhq.Model.MHuiYuanLiuYanInfo info)
{
var cmd = _db.GetStoredProcCommand("proc_HuiYuan_LiuYan_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, "@LiuYanNeiRong", DbType.String, info.LiuYanNeiRong);
_db.AddInParameter(cmd, "@LiuYanTime", DbType.DateTime, info.LiuYanTime);
_db.AddInParameter(cmd, "@HuiFuNeiRong", DbType.String, info.HuiFuNeiRong);
_db.AddInParameter(cmd, "@HuiFuTime", DbType.DateTime, info.HuiFuTime);
_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.MHuiYuanLiuYanInfo> GetLiuYans(string huiYuanId)
{
IList <Eyousoft_yhq.Model.MHuiYuanLiuYanInfo> items = new List <Eyousoft_yhq.Model.MHuiYuanLiuYanInfo>();
var cmd = _db.GetSqlStringCommand("SELECT * FROM view_HuiYuan_LiuYan 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.MHuiYuanLiuYanInfo();
item.HuiFuNeiRong = rdr["HuiFuNeiRong"].ToString();
item.HuiFuTime = rdr.GetDateTime(rdr.GetOrdinal("HuiFuTime"));
item.HuiYuanId1 = rdr["HuiYuanId1"].ToString();
item.HuiYuanId2 = rdr["HuiYuanId2"].ToString();
item.IdentityId = rdr.GetInt32(rdr.GetOrdinal("IdentityId"));
item.LiuYanNeiRong = rdr["LiuYanNeiRong"].ToString();
item.LiuYanTime = rdr.GetDateTime(rdr.GetOrdinal("LiuYanTime"));
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>
/// <param name="liuYanneiRong">留言内容</param>
/// <returns></returns>
public int HuiYuanLiuYan(string huiYuanId1, string huiYuanId2, string liuYanneiRong)
{
if (string.IsNullOrEmpty(huiYuanId1) || string.IsNullOrEmpty(huiYuanId2) || string.IsNullOrEmpty(liuYanneiRong))
{
return(0);
}
var info = new Eyousoft_yhq.Model.MHuiYuanLiuYanInfo();
info.HuiFuNeiRong = string.Empty;
info.HuiFuTime = DateTime.Now;
info.HuiYuanId1 = huiYuanId1;
info.HuiYuanId2 = huiYuanId2;
info.IdentityId = 0;
info.LiuYanNeiRong = liuYanneiRong;
info.LiuYanTime = DateTime.Now;
return(dal.HuiYuanLiuYan_CUD("C", info));
}
/// <summary>
/// 会员留言-删除，返回1成功，其它失败
/// </summary>
/// <param name="identityId">留言编号</param>
/// <param name="huiYuanId1">留言会员编号</param>
/// <param name="huiYuanId2">对方会员编号</param>
/// <returns></returns>
public int HuiYuanLiuYan_ShanChu(int identityId, string huiYuanId1, string huiYuanId2)
{
if (identityId < 1 || string.IsNullOrEmpty(huiYuanId1) || string.IsNullOrEmpty(huiYuanId2))
{
return(0);
}
var info = new Eyousoft_yhq.Model.MHuiYuanLiuYanInfo();
info.HuiFuNeiRong = string.Empty;
info.HuiFuTime = DateTime.Now;
info.HuiYuanId1 = huiYuanId1;
info.HuiYuanId2 = huiYuanId2;
info.IdentityId = identityId;
info.LiuYanNeiRong = string.Empty;
info.LiuYanTime = DateTime.Now;
return(dal.HuiYuanLiuYan_CUD("D", info));
}
/// <summary>
/// 获取会员被留言信息集合
/// </summary>
/// <param name="huiYuanId">会员编号</param>
/// <returns></returns>
public IList<Eyousoft_yhq.Model.MHuiYuanLiuYanInfo> GetLiuYans(string huiYuanId)
{
IList<Eyousoft_yhq.Model.MHuiYuanLiuYanInfo> items = new List<Eyousoft_yhq.Model.MHuiYuanLiuYanInfo>();
var cmd = _db.GetSqlStringCommand("SELECT * FROM view_HuiYuan_LiuYan 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.MHuiYuanLiuYanInfo();
item.HuiFuNeiRong = rdr["HuiFuNeiRong"].ToString();
item.HuiFuTime = rdr.GetDateTime(rdr.GetOrdinal("HuiFuTime"));
item.HuiYuanId1 = rdr["HuiYuanId1"].ToString();
item.HuiYuanId2 = rdr["HuiYuanId2"].ToString();
item.IdentityId = rdr.GetInt32(rdr.GetOrdinal("IdentityId"));
item.LiuYanNeiRong = rdr["LiuYanNeiRong"].ToString();
item.LiuYanTime = rdr.GetDateTime(rdr.GetOrdinal("LiuYanTime"));
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="identityId">留言编号</param>
/// <param name="huiYuanId1">留言会员编号</param>
/// <param name="huiYuanId2">对方会员编号</param>
/// <returns></returns>
public int HuiYuanLiuYan_ShanChu(int identityId, string huiYuanId1, string huiYuanId2)
{
if (identityId < 1 || string.IsNullOrEmpty(huiYuanId1) || string.IsNullOrEmpty(huiYuanId2)) return 0;
var info = new Eyousoft_yhq.Model.MHuiYuanLiuYanInfo();
info.HuiFuNeiRong = string.Empty;
info.HuiFuTime = DateTime.Now;
info.HuiYuanId1 = huiYuanId1;
info.HuiYuanId2 = huiYuanId2;
info.IdentityId = identityId;
info.LiuYanNeiRong = string.Empty;
info.LiuYanTime = DateTime.Now;
return dal.HuiYuanLiuYan_CUD("D", info);
}
/// <summary>
/// 会员留言-留言，返回1成功，其它失败
/// </summary>
/// <param name="huiYuanId1">留言会员编号</param>
/// <param name="huiYuanId2">对方会员编号</param>
/// <param name="liuYanneiRong">留言内容</param>
/// <returns></returns>
public int HuiYuanLiuYan(string huiYuanId1, string huiYuanId2, string liuYanneiRong)
{
if (string.IsNullOrEmpty(huiYuanId1) || string.IsNullOrEmpty(huiYuanId2) || string.IsNullOrEmpty(liuYanneiRong)) return 0;
var info = new Eyousoft_yhq.Model.MHuiYuanLiuYanInfo();
info.HuiFuNeiRong = string.Empty;
info.HuiFuTime = DateTime.Now;
info.HuiYuanId1 = huiYuanId1;
info.HuiYuanId2 = huiYuanId2;
info.IdentityId = 0;
info.LiuYanNeiRong = liuYanneiRong;
info.LiuYanTime = DateTime.Now;
return dal.HuiYuanLiuYan_CUD("C",info);
}
