public IList <ServiceVoteInfo> GetList(int pageIndex, int pageSize, out int totalRecords, string sqlWhere, params SqlParameter[] cmdParms) { StringBuilder sb = new StringBuilder(250); sb.Append(@"select count(*) from Service_Vote "); 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 <ServiceVoteInfo>()); } 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,ServiceItemId,Named,HeadPictureId,Descr,ContentText,Sort,EnableStartTime,EnableEndTime,IsDisable,LastUpdatedDate from Service_Vote " ); if (!string.IsNullOrEmpty(sqlWhere)) { sb.AppendFormat(" where 1=1 {0} ", sqlWhere); } sb.AppendFormat(@")as objTable where RowNumber between {0} and {1} ", startIndex, endIndex); IList <ServiceVoteInfo> list = new List <ServiceVoteInfo>(); using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderConnString, CommandType.Text, sb.ToString(), cmdParms)) { if (reader != null && reader.HasRows) { while (reader.Read()) { ServiceVoteInfo model = new ServiceVoteInfo(); model.Id = reader.GetGuid(1); model.ServiceItemId = reader.GetGuid(2); model.Named = reader.GetString(3); model.HeadPictureId = reader.GetGuid(4); model.Descr = reader.GetString(5); model.ContentText = reader.GetString(6); model.Sort = reader.GetInt32(7); model.EnableStartTime = reader.GetDateTime(8); model.EnableEndTime = reader.GetDateTime(9); model.IsDisable = reader.GetBoolean(10); model.LastUpdatedDate = reader.GetDateTime(11); list.Add(model); } } } return(list); }
public ServiceVoteInfo GetModelByJoin(object Id) { ServiceVoteInfo model = null; string cmdText = @"select top 1 sv.Id,sv.ServiceItemId,sv.Named,sv.HeadPictureId,sv.Descr,sv.ContentText,sv.Sort,sv.EnableStartTime,sv.EnableEndTime,sv.IsDisable,sv.LastUpdatedDate, si.Named as ServiceItemName,psv.FileExtension,psv.FileDirectory,psv.RandomFolder from Service_Vote sv left join Picture_ServiceVote psv on psv.Id = sv.HeadPictureId left join Service_Item si on si.Id = sv.ServiceItemId where sv.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 ServiceVoteInfo(); model.Id = reader.GetGuid(0); model.ServiceItemId = reader.GetGuid(1); model.Named = reader.GetString(2); model.HeadPictureId = reader.GetGuid(3); model.Descr = reader.GetString(4); model.ContentText = reader.GetString(5); model.Sort = reader.GetInt32(6); model.EnableStartTime = reader.GetDateTime(7); model.EnableEndTime = reader.GetDateTime(8); model.IsDisable = reader.GetBoolean(9); model.LastUpdatedDate = reader.GetDateTime(10); model.ServiceItemName = reader.IsDBNull(11) ? "" : reader.GetString(11); model.FileExtension = reader.IsDBNull(12) ? "" : reader.GetString(12); model.FileDirectory = reader.IsDBNull(13) ? "" : reader.GetString(13); model.RandomFolder = reader.IsDBNull(14) ? "" : reader.GetString(14); } } } return(model); }
public int Update(ServiceVoteInfo model) { if (IsExist(model.Named, model.ServiceItemId, model.Id)) { return(110); } StringBuilder sb = new StringBuilder(250); sb.Append(@"update Service_Vote set ServiceItemId = @ServiceItemId,Named = @Named,HeadPictureId = @HeadPictureId,Descr = @Descr,ContentText = @ContentText,Sort = @Sort,EnableStartTime = @EnableStartTime,EnableEndTime = @EnableEndTime,IsDisable = @IsDisable,LastUpdatedDate = @LastUpdatedDate where Id = @Id " ); SqlParameter[] parms = { new SqlParameter("@Id", SqlDbType.UniqueIdentifier), new SqlParameter("@ServiceItemId", SqlDbType.UniqueIdentifier), new SqlParameter("@Named", SqlDbType.NVarChar, 30), new SqlParameter("@HeadPictureId", SqlDbType.UniqueIdentifier), new SqlParameter("@Descr", SqlDbType.NVarChar, 300), new SqlParameter("@ContentText", SqlDbType.NVarChar, 4000), new SqlParameter("@Sort", SqlDbType.Int), new SqlParameter("@EnableStartTime", SqlDbType.DateTime), new SqlParameter("@EnableEndTime", SqlDbType.DateTime), new SqlParameter("@IsDisable", SqlDbType.Bit), new SqlParameter("@LastUpdatedDate", SqlDbType.DateTime) }; parms[0].Value = model.Id; parms[1].Value = model.ServiceItemId; parms[2].Value = model.Named; parms[3].Value = model.HeadPictureId; parms[4].Value = model.Descr; parms[5].Value = model.ContentText; parms[6].Value = model.Sort; parms[7].Value = model.EnableStartTime; parms[8].Value = model.EnableEndTime; parms[9].Value = model.IsDisable; parms[10].Value = model.LastUpdatedDate; return(SqlHelper.ExecuteNonQuery(SqlHelper.SqlProviderConnString, CommandType.Text, sb.ToString(), parms)); }
public IList <ServiceVoteInfo> GetList(string sqlWhere, params SqlParameter[] cmdParms) { StringBuilder sb = new StringBuilder(250); sb.Append(@"select Id,ServiceItemId,Named,HeadPictureId,Descr,ContentText,Sort,EnableStartTime,EnableEndTime,IsDisable,LastUpdatedDate from Service_Vote "); if (!string.IsNullOrEmpty(sqlWhere)) { sb.AppendFormat(" where 1=1 {0} ", sqlWhere); } IList <ServiceVoteInfo> list = new List <ServiceVoteInfo>(); using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderConnString, CommandType.Text, sb.ToString(), cmdParms)) { if (reader != null && reader.HasRows) { while (reader.Read()) { ServiceVoteInfo model = new ServiceVoteInfo(); model.Id = reader.GetGuid(0); model.ServiceItemId = reader.GetGuid(1); model.Named = reader.GetString(2); model.HeadPictureId = reader.GetGuid(3); model.Descr = reader.GetString(4); model.ContentText = reader.GetString(5); model.Sort = reader.GetInt32(6); model.EnableStartTime = reader.GetDateTime(7); model.EnableEndTime = reader.GetDateTime(8); model.IsDisable = reader.GetBoolean(9); model.LastUpdatedDate = reader.GetDateTime(10); list.Add(model); } } } return(list); }
public ServiceVoteInfo GetModel(object Id) { ServiceVoteInfo model = null; StringBuilder sb = new StringBuilder(300); sb.Append(@"select top 1 Id,ServiceItemId,Named,HeadPictureId,Descr,ContentText,Sort,EnableStartTime,EnableEndTime,IsDisable,LastUpdatedDate from Service_Vote 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, sb.ToString(), parm)) { if (reader != null) { while (reader.Read()) { model = new ServiceVoteInfo(); model.Id = reader.GetGuid(0); model.ServiceItemId = reader.GetGuid(1); model.Named = reader.GetString(2); model.HeadPictureId = reader.GetGuid(3); model.Descr = reader.GetString(4); model.ContentText = reader.GetString(5); model.Sort = reader.GetInt32(6); model.EnableStartTime = reader.GetDateTime(7); model.EnableEndTime = reader.GetDateTime(8); model.IsDisable = reader.GetBoolean(9); model.LastUpdatedDate = reader.GetDateTime(10); } } } return(model); }
public IList <ServiceVoteInfo> GetListByJoin(int pageIndex, int pageSize, out int totalRecords, string sqlWhere, params SqlParameter[] cmdParms) { StringBuilder sb = new StringBuilder(500); sb.Append(@"select count(*) from Service_Vote sv left join Picture_ServiceVote psv on psv.Id = sv.HeadPictureId left join Service_Item si on si.Id = sv.ServiceItemId "); 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 <ServiceVoteInfo>()); } sb.Clear(); int startIndex = (pageIndex - 1) * pageSize + 1; int endIndex = pageIndex * pageSize; sb.Append(@"select * from(select row_number() over(order by sv.LastUpdatedDate desc,sv.Sort) as RowNumber, sv.Id,sv.ServiceItemId,sv.Named,sv.HeadPictureId,sv.Descr,sv.Sort,sv.LastUpdatedDate, si.Named as ServiceItemName,psv.FileExtension,psv.FileDirectory,psv.RandomFolder from Service_Vote sv left join Picture_ServiceVote psv on psv.Id = sv.HeadPictureId left join Service_Item si on si.Id = sv.ServiceItemId "); if (!string.IsNullOrEmpty(sqlWhere)) { sb.AppendFormat(" where 1=1 {0} ", sqlWhere); } sb.AppendFormat(@")as objTable where RowNumber between {0} and {1} ", startIndex, endIndex); IList <ServiceVoteInfo> list = new List <ServiceVoteInfo>(); using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderConnString, CommandType.Text, sb.ToString(), cmdParms)) { if (reader != null && reader.HasRows) { while (reader.Read()) { ServiceVoteInfo model = new ServiceVoteInfo(); model.Id = reader.GetGuid(1); model.ServiceItemId = reader.GetGuid(2); model.Named = reader.GetString(3); model.HeadPictureId = reader.GetGuid(4); model.Descr = reader.GetString(5); model.Sort = reader.GetInt32(6); model.LastUpdatedDate = reader.GetDateTime(7); model.ServiceItemName = reader.IsDBNull(8) ? "" : reader.GetString(8); model.FileExtension = reader.IsDBNull(9) ? "" : reader.GetString(9); model.FileDirectory = reader.IsDBNull(10) ? "" : reader.GetString(10); model.RandomFolder = reader.IsDBNull(11) ? "" : reader.GetString(11); list.Add(model); } } } return(list); }
private void SaveServiceVote(HttpContext context) { context.Response.ContentType = "text/plain"; try { string svId = context.Request.Form["hServiceVoteId"].Trim(); string sServiceItemId = context.Request.Form["ServiceItemId"].Trim(); string sNamed = context.Request.Form["txtNamed_ServiceVote"].Trim(); string sHeadPictureId = context.Request.Form["hHeadPictureId_ServiceVote"].Trim(); string sSort = context.Request.Form["Sort"].Trim(); if (string.IsNullOrWhiteSpace(sNamed)) { context.Response.Write("{\"success\": false,\"message\": \"" + MessageContent.Submit_Params_InvalidError + "\"}"); return; } Guid serviceItemId = Guid.Empty; Guid.TryParse(sServiceItemId, out serviceItemId); Guid headPictureId = Guid.Empty; Guid.TryParse(sHeadPictureId, out headPictureId); int sort = 0; if (!string.IsNullOrWhiteSpace(sSort)) { int.TryParse(sSort, out sort); } string sDescr = context.Request.Form["txtaDescr_ServiceVote"].Trim(); string content = context.Request.Form["content"].Trim(); content = HttpUtility.HtmlDecode(content); Guid gId = Guid.Empty; if (!string.IsNullOrWhiteSpace(svId)) { Guid.TryParse(svId, out gId); } ServiceVoteInfo model = new ServiceVoteInfo(); model.Id = gId; model.LastUpdatedDate = DateTime.Now; model.ServiceItemId = serviceItemId; model.Named = sNamed; model.HeadPictureId = headPictureId; model.Descr = sDescr; model.ContentText = content; model.Sort = sort; ServiceVote bll = new ServiceVote(); ServiceItem siBll = new ServiceItem(); var siModel = siBll.GetModel(serviceItemId); if (siModel == null) { context.Response.Write("{\"success\": false,\"message\": \"服务分类【" + serviceItemId + "】" + MessageContent.Submit_Data_NotExists + "\"}"); return; } int effect = -1; using (TransactionScope scope = new TransactionScope()) { if (!gId.Equals(Guid.Empty)) { effect = bll.Update(model); if ((!siModel.HasVote) && effect > 0) { siModel.HasVote = true; siBll.Update(siModel); } } else { effect = bll.Insert(model); if ((!siModel.HasVote) && effect > 0) { siModel.HasVote = true; siBll.Update(siModel); } } scope.Complete(); } if (effect < 1) { context.Response.Write("{\"success\": false,\"message\": \"操作失败,请正确输入\"}"); return; } context.Response.Write("{\"success\": true,\"message\": \"操作成功\"}"); } catch (Exception ex) { context.Response.Write("{\"success\": false,\"message\": \"异常:" + ex.Message + "\"}"); } }
/// <summary> /// 修改数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Update(ServiceVoteInfo model) { return(dal.Update(model)); }
/// <summary> /// 添加数据到数据库 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Insert(ServiceVoteInfo model) { return(dal.Insert(model)); }