public IList <ServiceUserPraiseInfo> GetList() { StringBuilder sb = new StringBuilder(250); sb.Append(@"select Id,UserId,ServiceItemId,LastUpdatedDate from Service_UserPraise order by LastUpdatedDate desc " ); IList <ServiceUserPraiseInfo> list = new List <ServiceUserPraiseInfo>(); using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderConnString, CommandType.Text, sb.ToString())) { if (reader != null && reader.HasRows) { while (reader.Read()) { ServiceUserPraiseInfo model = new ServiceUserPraiseInfo(); model.Id = reader.GetGuid(0); model.UserId = reader.GetGuid(1); model.ServiceItemId = reader.GetGuid(2); model.LastUpdatedDate = reader.GetDateTime(3); list.Add(model); } } } return(list); }
public IList <ServiceUserPraiseInfo> GetList(string sqlWhere, params SqlParameter[] cmdParms) { StringBuilder sb = new StringBuilder(250); sb.Append(@"select Id,UserId,ServiceItemId,LastUpdatedDate from Service_UserPraise "); if (!string.IsNullOrEmpty(sqlWhere)) { sb.AppendFormat(" where 1=1 {0} ", sqlWhere); } IList <ServiceUserPraiseInfo> list = new List <ServiceUserPraiseInfo>(); using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderConnString, CommandType.Text, sb.ToString(), cmdParms)) { if (reader != null && reader.HasRows) { while (reader.Read()) { ServiceUserPraiseInfo model = new ServiceUserPraiseInfo(); model.Id = reader.GetGuid(0); model.UserId = reader.GetGuid(1); model.ServiceItemId = reader.GetGuid(2); model.LastUpdatedDate = reader.GetDateTime(3); list.Add(model); } } } return(list); }
public ServiceUserPraiseInfo GetModel(object Id) { ServiceUserPraiseInfo model = null; string cmdText = @"select top 1 Id,UserId,ServiceItemId,LastUpdatedDate from Service_UserPraise where Id = @Id " ; SqlParameter parm = new SqlParameter("@Id", SqlDbType.UniqueIdentifier); parm.Value = Guid.Parse(Id.ToString()); using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText, parm)) { if (reader != null) { while (reader.Read()) { model = new ServiceUserPraiseInfo(); model.Id = reader.GetGuid(0); model.UserId = reader.GetGuid(1); model.ServiceItemId = reader.GetGuid(2); model.LastUpdatedDate = reader.GetDateTime(3); } } } return(model); }
public string SaveServiceUserPraise(string username, Guid serviceItemId) { try { if (serviceItemId.Equals(Guid.Empty)) { return(string.Format("<Rsp><IsOK>{0}</IsOK><RtMsg>{1}</RtMsg></Rsp>", false, "服务ID【" + serviceItemId + "】无效,请检查")); } MembershipUser user = Membership.GetUser(username); if (user == null) { return(string.Format("<Rsp><IsOK>{0}</IsOK><RtMsg>{1}</RtMsg></Rsp>", false, "用户【" + username + "】不存在或已被删除")); } object userId = user.ProviderUserKey; ServiceUserPraise bll = new ServiceUserPraise(); ServiceUserPraiseInfo model = new ServiceUserPraiseInfo(); model.UserId = Guid.Parse(userId.ToString()); model.ServiceItemId = serviceItemId; model.LastUpdatedDate = DateTime.Now; int effect = 0; using (TransactionScope scope = new TransactionScope()) { if (bll.IsExist(userId, serviceItemId)) { effect = 110; } else { effect = bll.Insert(model); } scope.Complete(); } if (effect == 110) { return(string.Format("<Rsp><IsOK>{0}</IsOK><RtMsg>{1}</RtMsg><HasPraise>{2}</HasPraise></Rsp>", false, "您已赞过,请不要重复操作!", true)); } if (effect > 0) { return(string.Format("<Rsp><IsOK>{0}</IsOK><RtMsg>{1}</RtMsg></Rsp>", true, "点赞成功")); } else { return(string.Format("<Rsp><IsOK>{0}</IsOK><RtMsg>{1}</RtMsg></Rsp>", false, "点赞失败,请正确操作,必要时请联系管理员")); } } catch (Exception ex) { new CustomException(string.Format("服务-接口:string SaveServiceUserPraise,异常:{0}", ex.Message), ex); return(string.Format("<Rsp><IsOK>{0}</IsOK><RtMsg>{1}</RtMsg></Rsp>", false, "系统异常,原因:" + ex.Message + "")); } }
public IList <ServiceUserPraiseInfo> GetList(int pageIndex, int pageSize, out int totalRecords, string sqlWhere, params SqlParameter[] cmdParms) { StringBuilder sb = new StringBuilder(250); sb.Append(@"select count(*) from Service_UserPraise "); if (!string.IsNullOrEmpty(sqlWhere)) { sb.AppendFormat(" where 1=1 {0} ", sqlWhere); } totalRecords = (int)SqlHelper.ExecuteScalar(SqlHelper.SqlProviderConnString, CommandType.Text, sb.ToString(), cmdParms); if (totalRecords == 0) { return(new List <ServiceUserPraiseInfo>()); } sb.Clear(); int startIndex = (pageIndex - 1) * pageSize + 1; int endIndex = pageIndex * pageSize; sb.Append(@"select * from(select row_number() over(order by LastUpdatedDate desc) as RowNumber, Id,UserId,ServiceItemId,LastUpdatedDate from Service_UserPraise " ); if (!string.IsNullOrEmpty(sqlWhere)) { sb.AppendFormat(" where 1=1 {0} ", sqlWhere); } sb.AppendFormat(@")as objTable where RowNumber between {0} and {1} ", startIndex, endIndex); IList <ServiceUserPraiseInfo> list = new List <ServiceUserPraiseInfo>(); using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderConnString, CommandType.Text, sb.ToString(), cmdParms)) { if (reader != null && reader.HasRows) { while (reader.Read()) { ServiceUserPraiseInfo model = new ServiceUserPraiseInfo(); model.Id = reader.GetGuid(1); model.UserId = reader.GetGuid(2); model.ServiceItemId = reader.GetGuid(3); model.LastUpdatedDate = reader.GetDateTime(4); list.Add(model); } } } return(list); }
public int Insert(ServiceUserPraiseInfo model) { StringBuilder sb = new StringBuilder(250); sb.Append(@"insert into Service_UserPraise (UserId,ServiceItemId,LastUpdatedDate) values (@UserId,@ServiceItemId,@LastUpdatedDate) " ); SqlParameter[] parms = { new SqlParameter("@UserId", SqlDbType.UniqueIdentifier), new SqlParameter("@ServiceItemId", SqlDbType.UniqueIdentifier), new SqlParameter("@LastUpdatedDate", SqlDbType.DateTime) }; parms[0].Value = model.UserId; parms[1].Value = model.ServiceItemId; parms[2].Value = model.LastUpdatedDate; return(SqlHelper.ExecuteNonQuery(SqlHelper.SqlProviderConnString, CommandType.Text, sb.ToString(), parms)); }
/// <summary> /// 修改数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Update(ServiceUserPraiseInfo model) { return(dal.Update(model)); }
/// <summary> /// 添加数据到数据库 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Insert(ServiceUserPraiseInfo model) { return(dal.Insert(model)); }