protected void SetPageData(int TempID)
{
if (TempID <= 0)
{
return;
}
Sys_Template model = bllTemplate.GetModel(TempID);
if (model != null)
{
txt_TemplateName.Value = model.TemplateName;
txt_Author.Value = model.Author;
txt_TemplateDirectory.Value = model.TemplateDirectory;
txt_TemplateImg.Value = model.TemplateImg;
hide_CreateDateTime.Value = model.CreateDateTime.ToString();
if (model.IsEnable == 1)
{
rad_yes.Checked = true;
}
else
{
rad_no.Checked = true;
}
}
}
/// <summary>
/// 更新一条数据
/// </summary>
/// <param name="model">实体对象</param>
/// <returns>返回影响行数</returns>
public int Update(Sys_Template model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("UPDATE " + tablePrefix + "Sys_Template SET ");
strSql.Append("TemplateName=@TemplateName,");
strSql.Append("TemplateDirectory=@TemplateDirectory,");
strSql.Append("IsEnable=@IsEnable,");
strSql.Append("CreateDateTime=@CreateDateTime,");
strSql.Append("TemplateImg=@TemplateImg,");
strSql.Append("Author=@Author");
strSql.Append(" WHERE TemplateID=@TemplateID");
SqlParameter[] cmdParms =
{
AddInParameter("@TemplateName", SqlDbType.NVarChar, 50, model.TemplateName),
AddInParameter("@TemplateDirectory", SqlDbType.VarChar, 255, model.TemplateDirectory),
AddInParameter("@IsEnable", SqlDbType.TinyInt, 1, model.IsEnable),
AddInParameter("@CreateDateTime", SqlDbType.DateTime, 8, model.CreateDateTime),
AddInParameter("@TemplateImg", SqlDbType.VarChar, 255, model.TemplateImg),
AddInParameter("@Author", SqlDbType.NVarChar, 50, model.Author),
AddInParameter("@TemplateID", SqlDbType.Int, 4, model.TemplateID)
};
return(dbHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), cmdParms));
}
/// <summary>
/// 由一行数据得到一个实体
/// </summary>
/// <param name="dr">SqlDataReader对象</param>
/// <returns>实体对象</returns>
private Sys_Template GetModel(SqlDataReader dr)
{
Sys_Template model = new Sys_Template();
model.TemplateID = dbHelper.GetInt(dr["TemplateID"]);
model.TemplateName = dbHelper.GetString(dr["TemplateName"]);
model.TemplateDirectory = dbHelper.GetString(dr["TemplateDirectory"]);
model.IsEnable = dbHelper.GetByte(dr["IsEnable"]);
model.CreateDateTime = dbHelper.GetDateTime(dr["CreateDateTime"]);
model.TemplateImg = dbHelper.GetString(dr["TemplateImg"]);
model.Author = dbHelper.GetString(dr["Author"]);
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
/// <param name="TemplateID">编号ID</param>
/// <returns>返回影响行数</returns>
public int Add(Sys_Template model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("INSERT INTO " + tablePrefix + "Sys_Template(");
strSql.Append("TemplateName,TemplateDirectory,IsEnable,CreateDateTime,TemplateImg,Author)");
strSql.Append(" VALUES (");
strSql.Append("@TemplateName,@TemplateDirectory,@IsEnable,@CreateDateTime,@TemplateImg,@Author)");
SqlParameter[] cmdParms =
{
AddInParameter("@TemplateName", SqlDbType.NVarChar, 50, model.TemplateName),
AddInParameter("@TemplateDirectory", SqlDbType.VarChar, 255, model.TemplateDirectory),
AddInParameter("@IsEnable", SqlDbType.TinyInt, 1, model.IsEnable),
AddInParameter("@CreateDateTime", SqlDbType.DateTime, 8, model.CreateDateTime),
AddInParameter("@TemplateImg", SqlDbType.VarChar, 255, model.TemplateImg),
AddInParameter("@Author", SqlDbType.NVarChar, 50, model.Author)
};
return(dbHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), cmdParms));
}
protected Sys_Template GetTemplateModel()
{
Sys_Template model = new Sys_Template();
model.TemplateID = TempID;
model.TemplateName = txt_TemplateName.Value.Trim();
model.Author = txt_Author.Value.Trim();
model.TemplateDirectory = txt_TemplateDirectory.Value.Trim();
model.TemplateImg = txt_TemplateImg.Value.Trim();
if (string.IsNullOrEmpty(hide_CreateDateTime.Value))
{
hide_CreateDateTime.Value = DateTime.Now.ToString();
}
model.CreateDateTime = Convert.ToDateTime(hide_CreateDateTime.Value);
model.IsEnable = 0;
if (rad_yes.Checked)
{
model.IsEnable = 1;
bllTemplate.UpdateEnable(TempID, 1);//保证只有一个模板启用
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
/// <param name="model">实体对象</param>
/// <returns>返回影响行数</returns>
public int Update(Sys_Template model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
/// <param name="model">实体对象</param>
/// <returns>返回影响行数</returns>
public int Add(Sys_Template model)
{
return(dal.Add(model));
}
