public int Update(SiteMultiInfo model) { StringBuilder sb = new StringBuilder(500); sb.Append(@"update SiteMulti set Coded = @Coded,Named = @Named,SiteLogo = @SiteLogo,SiteTitle = @SiteTitle,CultureName = @CultureName,LastUpdatedDate = @LastUpdatedDate where Id = @Id " ); SqlParameter[] parms = { new SqlParameter("@Id", SqlDbType.UniqueIdentifier), new SqlParameter("@Coded", SqlDbType.Char, 6), new SqlParameter("@Named", SqlDbType.NVarChar, 30), new SqlParameter("@SiteLogo", SqlDbType.VarChar, 256), new SqlParameter("@SiteTitle", SqlDbType.NVarChar, 50), new SqlParameter("@CultureName", SqlDbType.VarChar, 20), new SqlParameter("@LastUpdatedDate", SqlDbType.DateTime) }; parms[0].Value = model.Id; parms[1].Value = model.Coded; parms[2].Value = model.Named; parms[3].Value = model.SiteLogo; parms[4].Value = model.SiteTitle; parms[5].Value = model.CultureName; parms[6].Value = model.LastUpdatedDate; return(SqlHelper.ExecuteNonQuery(SqlHelper.AspnetDbConnString, CommandType.Text, sb.ToString(), parms)); }
public int Insert(SiteMultiInfo model) { model.Id = Guid.NewGuid(); _db.SiteMultis.Insert(model); return(1); }
public IList <SiteMultiInfo> GetList() { StringBuilder sb = new StringBuilder(300); sb.Append(@"select Id,Coded,Named,SiteLogo,SiteTitle,CultureName,LastUpdatedDate from SiteMulti order by LastUpdatedDate desc " ); IList <SiteMultiInfo> list = new List <SiteMultiInfo>(); using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.AspnetDbConnString, CommandType.Text, sb.ToString())) { if (reader != null && reader.HasRows) { while (reader.Read()) { SiteMultiInfo model = new SiteMultiInfo(); model.Id = reader.GetGuid(0); model.Coded = reader.GetString(1); model.Named = reader.GetString(2); model.SiteLogo = reader.GetString(3); model.SiteTitle = reader.GetString(4); model.CultureName = reader.GetString(5); model.LastUpdatedDate = reader.GetDateTime(6); list.Add(model); } } } return(list); }
public int Insert(SiteMultiInfo model) { StringBuilder sb = new StringBuilder(300); sb.Append(@"insert into SiteMulti (Coded,Named,SiteLogo,SiteTitle,CultureName,LastUpdatedDate) values (@Coded,@Named,@SiteLogo,@SiteTitle,@CultureName,@LastUpdatedDate) " ); SqlParameter[] parms = { new SqlParameter("@Coded", SqlDbType.Char, 6), new SqlParameter("@Named", SqlDbType.NVarChar, 30), new SqlParameter("@SiteLogo", SqlDbType.VarChar, 256), new SqlParameter("@SiteTitle", SqlDbType.NVarChar, 50), new SqlParameter("@CultureName", SqlDbType.VarChar, 20), new SqlParameter("@LastUpdatedDate", SqlDbType.DateTime) }; parms[0].Value = model.Coded; parms[1].Value = model.Named; parms[2].Value = model.SiteLogo; parms[3].Value = model.SiteTitle; parms[4].Value = model.CultureName; parms[5].Value = model.LastUpdatedDate; return(SqlHelper.ExecuteNonQuery(SqlHelper.AspnetDbConnString, CommandType.Text, sb.ToString(), parms)); }
public SiteMultiInfo GetModel(Guid id) { SiteMultiInfo model = null; StringBuilder sb = new StringBuilder(300); sb.Append(@"select top 1 Id,Coded,Named,SiteLogo,SiteTitle,CultureName,LastUpdatedDate from SiteMulti where Id = @Id " ); SqlParameter[] parms = { new SqlParameter("@Id", SqlDbType.UniqueIdentifier) }; parms[0].Value = id; using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.AspnetDbConnString, CommandType.Text, sb.ToString(), parms)) { if (reader != null) { if (reader.Read()) { model = new SiteMultiInfo(); model.Id = reader.GetGuid(0); model.Coded = reader.GetString(1); model.Named = reader.GetString(2); model.SiteLogo = reader.GetString(3); model.SiteTitle = reader.GetString(4); model.CultureName = reader.GetString(5); model.LastUpdatedDate = reader.GetDateTime(6); } } } return(model); }
public IList <SiteMultiInfo> GetListByJoin(int pageIndex, int pageSize, out int totalRecords, string sqlWhere, params SqlParameter[] cmdParms) { StringBuilder sb = new StringBuilder(500); sb.Append(@"select count(*) from SiteMulti sm left join SitePicture p on (p.FileDirectory+p.FileName) = sm.SiteLogo "); if (!string.IsNullOrEmpty(sqlWhere)) { sb.AppendFormat(" where 1=1 {0} ", sqlWhere); } totalRecords = (int)SqlHelper.ExecuteScalar(SqlHelper.AspnetDbConnString, CommandType.Text, sb.ToString(), cmdParms); if (totalRecords == 0) { return(new List <SiteMultiInfo>()); } sb.Clear(); int startIndex = (pageIndex - 1) * pageSize + 1; int endIndex = pageIndex * pageSize; sb.Append(@"select * from(select row_number() over(order by sm.LastUpdatedDate desc) as RowNumber, sm.Id,sm.Coded,sm.Named,sm.SiteLogo,sm.SiteTitle,sm.LastUpdatedDate ,p.Id SiteLogoId from SiteMulti sm left join SitePicture p on (p.FileDirectory+p.FileName) = sm.SiteLogo "); if (!string.IsNullOrEmpty(sqlWhere)) { sb.AppendFormat(" where 1=1 {0} ", sqlWhere); } sb.AppendFormat(@")as objTable where RowNumber between {0} and {1} ", startIndex, endIndex); var list = new List <SiteMultiInfo>(); using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.AspnetDbConnString, CommandType.Text, sb.ToString(), cmdParms)) { if (reader != null && reader.HasRows) { while (reader.Read()) { var model = new SiteMultiInfo(); model.Id = reader.GetGuid(1); model.Coded = reader.GetString(2); model.Named = reader.GetString(3); model.SiteLogo = reader.GetString(4); model.SiteTitle = reader.GetString(5); model.LastUpdatedDate = reader.GetDateTime(6); model.SiteLogoId = reader.IsDBNull(7) ? Guid.Empty : reader.GetGuid(7); list.Add(model); } } } return(list); }
public ResResultModel SaveSiteMulti(SiteMultiModel model) { try { if (!HttpContext.Current.User.IsInRole("Administrators")) { throw new ArgumentException(MC.Role_InvalidError); } Guid id = Guid.Empty; if (model.Id != null) { Guid.TryParse(model.Id.ToString(), out id); } var modelInfo = new SiteMultiInfo(id, model.Coded, model.Named, model.SiteLogo, model.SiteTitle, model.CultureName, DateTime.Now); var bll = new SiteMulti(); int effect = 0; if (id.Equals(Guid.Empty)) { var code = bll.GetCode(); modelInfo.Coded = code; effect = bll.Insert(modelInfo); } else { var oldInfo = bll.GetModel(id); modelInfo.Coded = oldInfo.Coded; effect = bll.Update(modelInfo); } if (effect > 0) { return(ResResult.Response(true, MC.M_Save_Ok, "")); } else { return(ResResult.Response(false, MC.M_Save_Error, "")); } } catch (Exception ex) { return(ResResult.Response(false, ex.Message, "")); } }
public IList <SiteMultiInfo> GetList(int pageIndex, int pageSize, string sqlWhere, params SqlParameter[] cmdParms) { StringBuilder sb = new StringBuilder(500); 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,Coded,Named,SiteLogo,SiteTitle,CultureName,LastUpdatedDate from SiteMulti " ); if (!string.IsNullOrEmpty(sqlWhere)) { sb.AppendFormat(" where 1=1 {0} ", sqlWhere); } sb.AppendFormat(@")as objTable where RowNumber between {0} and {1} ", startIndex, endIndex); IList <SiteMultiInfo> list = new List <SiteMultiInfo>(); using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.AspnetDbConnString, CommandType.Text, sb.ToString(), cmdParms)) { if (reader != null && reader.HasRows) { while (reader.Read()) { SiteMultiInfo model = new SiteMultiInfo(); model.Id = reader.GetGuid(1); model.Coded = reader.GetString(2); model.Named = reader.GetString(3); model.SiteLogo = reader.GetString(4); model.SiteTitle = reader.GetString(5); model.CultureName = reader.GetString(6); model.LastUpdatedDate = reader.GetDateTime(7); list.Add(model); } } } return(list); }
public IList <SiteMultiInfo> GetList(string sqlWhere, params SqlParameter[] cmdParms) { StringBuilder sb = new StringBuilder(500); sb.Append(@"select Id,Coded,Named,SiteLogo,SiteTitle,CultureName,LastUpdatedDate from SiteMulti "); if (!string.IsNullOrEmpty(sqlWhere)) { sb.AppendFormat(" where 1=1 {0} ", sqlWhere); } sb.Append("order by LastUpdatedDate desc "); IList <SiteMultiInfo> list = new List <SiteMultiInfo>(); using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.AspnetDbConnString, CommandType.Text, sb.ToString(), cmdParms)) { if (reader != null && reader.HasRows) { while (reader.Read()) { SiteMultiInfo model = new SiteMultiInfo(); model.Id = reader.GetGuid(0); model.Coded = reader.GetString(1); model.Named = reader.GetString(2); model.SiteLogo = reader.GetString(3); model.SiteTitle = reader.GetString(4); model.CultureName = reader.GetString(5); model.LastUpdatedDate = reader.GetDateTime(6); list.Add(model); } } } return(list); }
public int Update(SiteMultiInfo model) { return(dal.Update(model)); }
public int InsertByOutput(SiteMultiInfo model) { return(dal.InsertByOutput(model)); }
public int Update(SiteMultiInfo model) { _db.SiteMultis.Update(model); return(1); }
public int InsertByOutput(SiteMultiInfo model) { _db.SiteMultis.Insert(model); return(1); }