private string GetDeleteSql(PageBaseInfo obj) { string sql = "delete from {0} where page_id = '{1}'"; sql = string.Format(sql, _pageTableName, obj.page_id); return(sql); }
/// <summary> /// 页面实体解析成页面类 /// </summary> /// <param name="pageObj"></param> /// <returns></returns> public xinlongyuForm DecodePage(PageInfoDetail pageObj, bool isNavigationWindow) { //页面基本信息 PageBaseInfo dtObj = pageObj.data; if (object.Equals(dtObj.control_list, null)) { return(null); } try { List <ControlDetailForPage> listControlObject = ControlCaster.CastArrayToControl(dtObj.control_list); //判断一下解析出来的控件数组是不是为空 if (object.Equals(listControlObject, null) || listControlObject.Count < 1) { return(null); } var page = this.DecodeListControlObj(listControlObject, isNavigationWindow); if (!object.Equals(page, null)) { page.Title = pageObj.data.page_name; //设置标题 } return(page); } catch (Exception ex) { Logging.Error(ex.Message); return(null); } }
/// <summary> /// 获取更新的语句 /// </summary> /// <param name="obj"></param> /// <returns></returns> private string GetUpdateSql(PageBaseInfo obj) { string updateSql = "update {0} set {1} where page_id = '{2}'"; string values = string.Empty; StringBuilder sb = new StringBuilder(500); foreach (var prop in obj.GetType().GetFields()) { if (sb.Length < 1) { sb.Append(prop.Name + "=" + prop.GetValue(obj)); } else { sb.Append("," + prop.Name + "=" + prop.GetValue(obj)); } } updateSql = string.Format(updateSql, _pageTableName, sb.ToString(), obj.page_id); return(updateSql); }
/// <summary> /// 获取页面基本信息 /// </summary> /// <param name="pageid"></param> /// <returns></returns> private PageBaseInfo GetPageBaseInfo(int pageid) { string sql = @"select page_id, page_name, page_width, page_height, last_time from hs_new_pages where page_id = '{0}'"; sql = string.Format(sql, pageid); SQLiteDataReader reader = this.ExcuteReader(sql); while (reader.Read()) { PageBaseInfo obj = new PageBaseInfo(); obj.page_id = int.Parse(reader[0].ToString()); obj.page_name = reader[1].ToString(); obj.page_width = int.Parse(reader[2].ToString()); obj.page_height = int.Parse(reader[3].ToString()); obj.last_time = int.Parse(reader[4].ToString()); return(obj); } reader.Close(); this._connection.Close(); return(null); }