protected void btnSave_Click(object sender, EventArgs e) { if (themesname.Text.Trim() != null && themesname.Text.Trim() != "") { SysThemes model = new SysThemes(); SysThemesDAL dal = new SysThemesDAL(); if (themesvalue.Text.Trim() != null && themesvalue.Text.Trim() != "") { model.Value = themesvalue.Text; } model.Name = themesname.Text; model.ID = Guid.NewGuid().ToString("N").ToUpper(); model.IsState = isstateyes.Checked ? 1 : 0; if (dal.AddSysTemes(model)) { MessageBox.Show(this, "操作成功!"); } else { MessageBox.Show(this, "操作失败!"); } } else { MessageBox.Show(this, "名称不能为空!"); return; } }
/// <summary> /// 添加主题 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool AddSysTemes(SysThemes model) { string sql = @"INSERT INTO [SYS_Account_Ext] ([ID] ,[Name] ,[Value] ,[IsState]) VALUES (@ID ,@Name ,@Value ,@IsState)"; System.Data.SqlClient.SqlParameter[] paras = new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@ID", model.ID), new System.Data.SqlClient.SqlParameter("@Name", model.Name), new System.Data.SqlClient.SqlParameter("@Value", model.Value), new System.Data.SqlClient.SqlParameter("@IsState", model.IsState) }; int rowsAffected = DbHelperSQL.ExecuteSql(sql.ToString(), paras); if (rowsAffected > 0) { return(true); } else { return(false); } }
protected void Page_Load(object sender, EventArgs e) { if (null != Common.Common.NoHtml(Request.QueryString["action"])) { strAction = Common.Common.NoHtml(Request.QueryString["action"]); } if (null != Common.Common.NoHtml(Request.QueryString["id"])) { strID = Common.Common.NoHtml(Request.QueryString["id"]); } SysThemesDAL dal = new SysThemesDAL(); int statein = 0; try { statein = Convert.ToInt32(dal.GetThemesvaluesById("IsState", strID)); } catch (Exception) { statein = 0; } switch (statein) { case 0: statein = 1; break; default: statein = 0; break; } SysThemes model = new SysThemes(); model.ID = strID; model.IsState = statein; switch (strAction) { case "del": if (dal.UpdateSysThemes(model)) { strMessage = "操作成功!"; } else { strMessage = "操作失败!"; } break; default: break; } Response.Write(strMessage); Response.End(); }
public void ShowActivityInfo(string strID) { SysThemesDAL dal = new SysThemesDAL(); DataSet ds = dal.GetSysThemesds(strID); SysThemes model = DataConvert.DataRowToModel <SysThemes>(ds.Tables[0].Rows[0]); themesname.Text = model.Name; themesvalue.Text = model.Value; if (model.IsState == 0) { isstateyes.Checked = true; } else { isstateno.Checked = true; } }
/// <summary> /// 更新主题信息 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool UpdateSysThemes(SysThemes model) { string safesql = " update SYS_Themes set "; if (model.Name != null && model.Name != "") { safesql += " name='" + model.Name + "',"; } if (model.Value != null && model.Value != "") { safesql += " Value='" + model.Value + "',"; } safesql += " isstate=" + model.IsState + " where id='" + model.ID + "'"; int rowsAffected = DbHelperSQL.ExecuteSql(safesql.ToString()); if (rowsAffected > 0) { return(true); } else { return(false); } }