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