public bool SelectInfoMap(InfoMapQuery query) { try { return _infoMapDao.SelectInfoMap(query); } catch (Exception ex) { throw new Exception("InfoMapMgr-->SelectInfoMap-->" + ex.Message, ex); } }
public InfoMapQuery GetOldModel(InfoMapQuery query) { try { return _infoMapDao.GetOldModel(query); } catch (Exception ex) { throw new Exception("InfoMapMgr-->GetOldModel-->" + ex.Message, ex); } }
public List<InfoMapQuery> GetInfoMapList(InfoMapQuery query, out int totalCount) { try { return _infoMapDao.GetInfoMapList(query, out totalCount); } catch (Exception ex) { throw new Exception("InfoMapMgr-->GetInfoMapList-->" + ex.Message, ex); } }
public int UpdateInfoMap(InfoMapQuery query) { try { return _infoMapDao.UpdateInfoMap(query); } catch (Exception ex) { throw new Exception("InfoMapMgr-->UpdateInfoMap-->" + ex.Message, ex); } }
public HttpResponseBase GetInfoMapList() { List<InfoMapQuery> store = new List<InfoMapQuery>(); string json = string.Empty; InfoMapQuery query = new InfoMapQuery(); try { query.Start = Convert.ToInt32(Request.Params["start"] ?? "0"); query.Limit = Convert.ToInt32(Request.Params["limit"] ?? "25"); if (!string.IsNullOrEmpty(Request.Params["siteName"])) { query.site_name = Request.Params["siteName"]; } if (!string.IsNullOrEmpty(Request.Params["searchType"])) { query.type = Convert.ToInt32(Request.Params["searchType"]); } _infoMapMgr = new InfoMapMgr(mySqlConnectionString); int totalCount = 0; store = _infoMapMgr.GetInfoMapList(query, out totalCount); IsoDateTimeConverter timeConverter = new IsoDateTimeConverter(); timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss"; json = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(store, Formatting.Indented, timeConverter) + "}"; } catch (Exception ex) { Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message); logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; log.Error(logMessage); json = "{success:false,totalCount:0,data:[]}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
/// <summary> /// 元素關係保存 /// </summary> /// <returns></returns> public HttpResponseBase SaveInfoMap() { string json = string.Empty; int isTranInt = 0; try { _infoMapMgr = new InfoMapMgr(mySqlConnectionString); InfoMapQuery emQuery = new InfoMapQuery(); if (!string.IsNullOrEmpty(Request.Params["map_id"]))//修改 { emQuery.map_id = Convert.ToInt32(Request.Params["map_id"]); InfoMapQuery oldQuery = _infoMapMgr.GetOldModel(emQuery); if (!string.IsNullOrEmpty(Request.Params["site_id"])) { emQuery.site_id = Convert.ToInt32(Request.Params["site_id"]); } if (!string.IsNullOrEmpty(Request.Params["page_id"])) { emQuery.page_id = Convert.ToInt32(Request.Params["page_id"]); } if (!string.IsNullOrEmpty(Request.Params["area_id"])) { emQuery.area_id = Convert.ToInt32(Request.Params["area_id"]); } if (!string.IsNullOrEmpty(Request.Params["type"])) { emQuery.type = Convert.ToInt32(Request.Params["type"]); } switch (emQuery.type) { case 1: if (int.TryParse(Request.Params["info_id1"], out isTranInt)) { emQuery.info_id = Convert.ToInt32(Request.Params["info_id1"]); } else { emQuery.info_id = oldQuery.info_id; } break; case 2: if (int.TryParse(Request.Params["info_id2"], out isTranInt)) { emQuery.info_id = Convert.ToInt32(Request.Params["info_id2"]); } else { emQuery.info_id = oldQuery.info_id; } break; case 3: if (int.TryParse(Request.Params["info_id3"], out isTranInt)) { emQuery.info_id = Convert.ToInt32(Request.Params["info_id3"]); } else { emQuery.info_id = oldQuery.info_id; } break; case 4: if (int.TryParse(Request.Params["info_id4"], out isTranInt)) { emQuery.info_id = Convert.ToInt32(Request.Params["info_id4"]); } else { emQuery.info_id = oldQuery.info_id; } break; } if (!string.IsNullOrEmpty(Request.Params["sort"])) { emQuery.sort = Convert.ToInt32(Request.Params["sort"]); } emQuery.update_date = DateTime.Now; emQuery.update_user_id = int.Parse((System.Web.HttpContext.Current.Session["caller"] as Caller).user_id.ToString()); if (_infoMapMgr.SelectInfoMap(emQuery)) { _infoMapMgr.UpdateInfoMap(emQuery); json = "{success:true}"; } else { json = "{success:false}"; } } else //新增 { if (!string.IsNullOrEmpty(Request.Params["site_id"])) { emQuery.site_id = Convert.ToInt32(Request.Params["site_id"]); } if (!string.IsNullOrEmpty(Request.Params["page_id"])) { emQuery.page_id = Convert.ToInt32(Request.Params["page_id"]); } if (!string.IsNullOrEmpty(Request.Params["area_id"])) { emQuery.area_id = Convert.ToInt32(Request.Params["area_id"]); } if (!string.IsNullOrEmpty(Request.Params["type"])) { emQuery.type = Convert.ToInt32(Request.Params["type"]); } switch (emQuery.type) { case 1: if (int.TryParse(Request.Params["info_id1"], out isTranInt)) { emQuery.info_id = Convert.ToInt32(Request.Params["info_id1"]); } break; case 2: if (int.TryParse(Request.Params["info_id2"], out isTranInt)) { emQuery.info_id = Convert.ToInt32(Request.Params["info_id2"]); } break; case 3: if (int.TryParse(Request.Params["info_id3"], out isTranInt)) { emQuery.info_id = Convert.ToInt32(Request.Params["info_id3"]); } break; case 4: if (int.TryParse(Request.Params["info_id4"], out isTranInt)) { emQuery.info_id = Convert.ToInt32(Request.Params["info_id4"]); } break; } if (!string.IsNullOrEmpty(Request.Params["sort"])) { emQuery.sort = Convert.ToInt32(Request.Params["sort"]); } emQuery.create_date = DateTime.Now; emQuery.update_date = emQuery.create_date; emQuery.create_user_id = int.Parse((System.Web.HttpContext.Current.Session["caller"] as Caller).user_id.ToString()); emQuery.update_user_id = emQuery.create_user_id; if (_infoMapMgr.SelectInfoMap(emQuery)) { _infoMapMgr.SaveInfoMap(emQuery); json = "{success:true}"; } else { json = "{success:false}"; } } } catch (Exception ex) { Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message); logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; log.Error(logMessage); json = "{success:false}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
/// <summary> /// 查詢元素關係列表 /// </summary> /// <param name="query">實體</param> /// <param name="totalCount">分頁</param> /// <returns>List<InfoMapQuery>集合</returns> public List<InfoMapQuery> GetInfoMapList(InfoMapQuery query, out int totalCount) { StringBuilder sql = new StringBuilder(); StringBuilder sb = new StringBuilder(); StringBuilder sbCondi = new StringBuilder(); StringBuilder sbCount = new StringBuilder(); List<InfoMapQuery> store = new List<InfoMapQuery>(); try { sb.Append(@" select im.map_id,im.site_id,s.site_name,im.page_id,sp.page_name,im.area_id,pa.area_name,im.info_id,im.type,im.sort,create_date,update_date,mu.user_username as update_user_name"); sbCondi.Append(" from info_map im "); sbCondi.Append(" left join site s on s.site_id=im.site_id "); sbCondi.Append(" left join site_page sp on sp.page_id=im.page_id "); sbCondi.Append(" left join page_area pa on im.area_id=pa.area_id "); sbCondi.Append(" left join manage_user mu on im.update_user_id=mu.user_id where 1=1 "); sbCount.Append(" select count(im.map_id) as totalCount "); if (!string.IsNullOrEmpty(query.site_name)) { sbCondi.AppendFormat(" and s.site_name like N'%{0}%' ", query.site_name); } if (query.type != 0) { sbCondi.AppendFormat(" and im.type='{0}' ", query.type); } sbCondi.Append(" order by map_id desc"); totalCount = 0; if (query.IsPage) { sbCount.Append(sbCondi.ToString()); DataTable dtcount = new DataTable(); dtcount = _access.getDataTable(sbCount.ToString()); if (dtcount != null && dtcount.Rows.Count > 0) { totalCount =Convert.ToInt32(dtcount.Rows[0]["totalCount"]); } } sbCondi.AppendFormat(" limit {0},{1}", query.Start, query.Limit); sb.Append(sbCondi.ToString()); store = _access.getDataTableForObj<InfoMapQuery>(sb.ToString()); foreach (var item in store) { sql.Clear(); switch (item.type)//類型 1:活動頁面 2:最新消息 3:訊息公告 4:電子報', { case 1: sql.AppendFormat("select tb.epaper_title as info_name from epaper_content tb where tb.epaper_id='{0}'", item.info_id); break; case 2: sql.AppendFormat("select tb.news_title as info_name from news_content tb where tb.news_id='{0}'", item.info_id); break; case 3: sql.AppendFormat("select tb.title as info_name from announce tb where tb.announce_id='{0}'", item.info_id); break; case 4: sql.AppendFormat("select tb.content_title as info_name from edm_content tb where tb.content_id='{0}'", item.info_id); break; } System.Data.DataTable _dt = _access.getDataTable(sql.ToString()); if (_dt != null && _dt.Rows.Count > 0) { item.info_name = _dt.Rows[0]["info_name"].ToString(); } } return store; } catch (Exception ex) { throw new Exception("InfoMapDao-->GetInfoMapList-->" + ex.Message + sb.ToString() + sbCount.ToString()+sql.ToString(), ex); } }
public InfoMapQuery GetOldModel(InfoMapQuery query) { StringBuilder sql = new StringBuilder(); try { sql.AppendFormat("select map_id, site_id,page_id,area_id,type,info_id,sort,create_date,create_user_id,update_date,update_user_id from info_map where map_id='{0}'", query.map_id); return _access.getSinggleObj<InfoMapQuery>(sql.ToString()); } catch (Exception ex) { throw new Exception("InfoMapDao-->GetOldModel-->" + ex.Message + sql.ToString(), ex); } }
/// <summary> /// 判斷是否重複添加 /// </summary> /// <param name="query"></param> /// <returns></returns> public bool SelectInfoMap(InfoMapQuery query) { string strSql = string.Empty; try { strSql = string.Format("select * from info_map where site_id='{0}' and page_id='{1}' and area_id='{2}' and type='{3}' and info_id='{4}'", query.site_id, query.page_id, query.area_id, query.type, query.info_id); InfoMapQuery model = _access.getSinggleObj<InfoMapQuery>(strSql); if (model == null) { return true;//代表沒有重複添加 } else if (model.map_id == query.map_id && query.map_id != 0) { return true; } else { return false;//代表有重複添加 } } catch (Exception ex) { throw new Exception("InfoMapDao-->SelectInfoMap-->" + ex.Message + strSql.ToString(), ex); } }
public int UpdateInfoMap(InfoMapQuery query) { StringBuilder sb = new StringBuilder(); try { sb.AppendFormat(@" update info_map set site_id='{0}',page_id='{1}',area_id='{2}',type='{3}',sort='{4}',info_id='{5}', ", query.site_id, query.page_id, query.area_id, query.type, query.sort, query.info_id); sb.AppendFormat(" update_date='{0}',update_user_id='{1}' where map_id='{2}'", query.update_date.ToString("yyyy-MM-dd HH:mm:ss"), query.update_user_id, query.map_id); return _access.execCommand(sb.ToString()); } catch (Exception ex) { throw new Exception("InfoMapDao-->UpdateInfoMap-->" + ex.Message + sb.ToString(), ex); } }
public int SaveInfoMap(InfoMapQuery query) { StringBuilder sb = new StringBuilder(); try { sb.AppendFormat(@" insert into info_map(site_id,page_id,area_id,type,info_id,sort,create_date,create_user_id,update_date,update_user_id)VALUES('{0}','{1}','{2}','{3}','{4}','{5}',", query.site_id, query.page_id, query.area_id, query.type, query.info_id, query.sort); sb.AppendFormat(" '{0}','{1}','{2}','{3}')", query.create_date.ToString("yyyy-MM-dd HH:mm:ss"), query.create_user_id, query.update_date.ToString("yyyy-MM-dd HH:mm:ss"), query.update_user_id); return _access.execCommand(sb.ToString()); } catch (Exception ex) { throw new Exception("InfoMapDao-->SaveInfoMap-->" + ex.Message + sb.ToString(), ex); } }