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