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