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);
}
