protected void LoadInfo() { int id = WS.RequestInt("id"); TemplateVar tl = TemplateVarView.GetModelByID(id.ToS()); txt_VarName.Text = tl.VarName; txt_Content.Text = tl.Content; }
protected void LoadInfo() { using (DataEntities ent = new DataEntities()) { int id = WS.RequestInt("id"); if (id < 0) { return; } txt_VarName.Enabled = false; TemplateVar tl = (from l in ent.TemplateVar where l.ID == id select l).FirstOrDefault(); txt_VarName.Text = tl.VarName; txt_Content.Text = tl.Content; } }
/// <summary> /// DataTable转换为list /// </summary> /// <param name="dt"></param> /// <returns></returns> protected static List <TemplateVar> DataTableToList(DataTable dt) { List <TemplateVar> Ms = new List <TemplateVar>(); for (int i = 0; i < dt.Rows.Count; i++) { TemplateVar M = new TemplateVar(); M.ID = dt.Rows[i]["ID"].ToInt32(); M.GroupID = dt.Rows[i]["GroupID"].ToInt32(); M.VarName = dt.Rows[i]["VarName"].ToString(); M.Content = dt.Rows[i]["Content"].ToString(); M.IsPublic = dt.Rows[i]["IsPublic"].ToBoolean(); Ms.Add(M); } return(Ms); }
protected void btn_Save_Click(object sender, EventArgs e) { int id = WS.RequestInt("id"); TemplateVar tl = TemplateVarView.GetModelByID(id.ToS()); tl.VarName = txt_VarName.Text; tl.Content = txt_Content.Text.Replace("'", "''"); if (tl.ID > 0) { TemplateVarView.Update(tl); } else { tl.GroupID = 1; TemplateVarView.Insert(tl); } Js.AlertAndGoback("保存成功!"); }
/// <summary> /// 将修改过的实体修改到数据库 /// </summary> /// <param name="M">赋值后的实体</param> /// <returns></returns> public static int Update(TemplateVar M) { IDbHelper Sql = GetHelper(); StringBuilder sb = new StringBuilder(); sb.Append("update [TemplateVar] set "); sb.Append("[GroupID]=" + M.GroupID.ToS()); sb.Append(","); sb.Append("[VarName]=N'" + M.VarName + "'"); sb.Append(","); sb.Append("[Content]=N'" + M.Content + "'"); sb.Append(","); sb.Append("[IsPublic]=" + M.IsPublic.ToS()); sb.Append(" where ID='" + M.ID + "'"); sb.Append(""); if (DataBase.CmsDbType == DataBase.DbType.SqlServer) { sb.Append(";select @@ROWCOUNT"); } if (DataBase.CmsDbType == DataBase.DbType.SQLite) { sb.Append(";select 0"); } if (DataBase.CmsDbType == DataBase.DbType.MySql) { sb.Append(";SELECT ROW_COUNT()"); } if (DataBase.CmsDbType == DataBase.DbType.Access) { sb.Append(";select 0"); } if (DataBase.CmsDbType == DataBase.DbType.Oracle) { sb.Append(";select SQL%ROWCOUNT"); } return(Sql.ExecuteScalar(CommandType.Text, sb.ToString()).ToInt32()); }
/// <summary> /// 将数据插入表 /// </summary> /// <param name="M">赋值后的实体</param> /// <returns></returns> public static void Insert(TemplateVar M) { IDbHelper Sql = GetHelper(); StringBuilder sb = new StringBuilder(); sb.Append("insert into [TemplateVar]([GroupID],[VarName],[Content],[IsPublic]) values("); sb.Append(M.GroupID.ToS()); sb.Append(","); sb.Append("N'" + M.VarName + "'"); sb.Append(","); sb.Append("N'" + M.Content + "'"); sb.Append(","); sb.Append(M.IsPublic.ToS()); sb.Append(")"); if (DataBase.CmsDbType == DataBase.DbType.SqlServer) { sb.Append(";select @@Identity"); } if (DataBase.CmsDbType == DataBase.DbType.SQLite) { sb.Append(";select last_insert_rowid()"); } if (DataBase.CmsDbType == DataBase.DbType.MySql) { sb.Append(";select LAST_INSERT_ID()"); } if (DataBase.CmsDbType == DataBase.DbType.Access) { sb.Append(";select max(ID) from TemplateVar"); } if (DataBase.CmsDbType == DataBase.DbType.Oracle) { sb.Append(";select LAST_INSERT_ID()"); } M.ID = Sql.ExecuteScalar(CommandType.Text, sb.ToString()).ToInt32(); }
/// <summary> /// 根据条件语句取得第一个实体 /// </summary> /// <param name="m_where">条件语句,不包含“where”</param> /// <returns></returns> public static TemplateVar Find(string m_where) { IDbHelper Sql = GetHelper(); TemplateVar M = new TemplateVar(); DbDataReader Rs = Sql.ExecuteReader(CommandType.Text, "select [ID],[GroupID],[VarName],[Content],[IsPublic] from [TemplateVar] where " + m_where, true); if (!Rs.Read()) { M.ID = 0; } else { M.ID = Rs["ID"].ToInt32(); M.GroupID = Rs["GroupID"].ToInt32(); M.VarName = Rs["VarName"].ToString(); M.Content = Rs["Content"].ToString(); M.IsPublic = Rs["IsPublic"].ToBoolean(); } Rs.Close(); Rs = null; return(M); }
protected void btn_Save_Click(object sender, EventArgs e) { DataEntities ent = new DataEntities(); int id = WS.RequestInt("id"); TemplateVar tl = new TemplateVar(); try { tl = (from l in ent.TemplateVar where l.ID == id select l).First(); } catch { } tl.VarName = txt_VarName.Text; tl.Content = txt_Content.Text.Replace("'", "''"); if (tl.ID == null || tl.ID <= 0) { ent.AddToTemplateVar(tl); } ent.SaveChanges(); var pages = (from l in ent.TemplatePage where l.CreateWith == 5 select l).ToList(); TemplateHelper th = new TemplateHelper(); foreach (var p in pages) { try { string html = th.GetStatisPage(p.id); Voodoo.IO.File.Write(Server.MapPath(p.FileName), html); } catch { } } ent.Dispose(); Js.AlertAndChangUrl("保存成功!", "VarTemplateList.aspx"); }
public static TemplateVar CreateTemplateVar(int id) { TemplateVar templateVar = new TemplateVar(); templateVar.ID = id; return templateVar; }
public void AddToTemplateVar(TemplateVar templateVar) { base.AddObject("TemplateVar", templateVar); }