/// <summary> /// 在同类中排序 /// </summary> /// <param name="id">lb.id</param> /// <param name="isUp">1=升序,0=降序</param> /// <returns>排序后的dataTable</returns> public static void lbOrderUP(string id, bool isUp) { SQLHelper_ db = new SQLHelper_(); db.sql = "SELECT id,lbid,parentid,orderid FROM " + com.tablePrefix + "lb WHERE id=" + id; DataTable dt = db.Get_DataTable(); string parentid = dt.Rows[0]["parentid"].ToString(); string curOrder = dt.Rows[0]["orderid"].ToString(); if (isUp) { db.sql = "SELECT TOP 1 id,lbid,parentid,orderid FROM " + com.tablePrefix + "lb WHERE parentid=" + parentid + " AND orderid<" + curOrder + " ORDER BY orderid DESC"; } else { db.sql = "SELECT TOP 1 id,lbid,parentid,orderid FROM " + com.tablePrefix + "lb WHERE parentid=" + parentid + " AND orderid>" + curOrder + " ORDER BY orderid"; } DataTable dt1 = db.Get_DataTable(); if (dt1.Rows.Count > 0) { string newOrder = dt1.Rows[0]["orderid"].ToString(); string otherId = dt1.Rows[0]["id"].ToString(); db.sql = "UPDATE " + com.tablePrefix + "lb SET orderid=" + newOrder + " WHERE id=" + id; db.ExecSql(); db.sql = "UPDATE " + com.tablePrefix + "lb SET orderid=" + curOrder + " WHERE id=" + otherId; db.ExecSql(); } }
public static void del(string id) { SQLHelper_ db = new SQLHelper_(); db.sql = "UPDATE dxlb SET isDeleted=1 WHERE id=" + id; db.ExecSql(); }
/// <summary> /// 添加栏目 /// </summary> /// <param name="lbname">栏目名称</param> /// <param name="parentid">父栏目ID</param> /// <returns>int,1=成功,0=已存在</returns> public static string AddLb(string lbname, string parentid) { string maxlbid = MaxLbid(); string sql = "INSERT INTO " + com.tablePrefix + "lb (lbid,lbname,parentid,OrderId) VALUES(" + maxlbid + ",'" + lbname + "'," + parentid + "," + maxlbid + ")"; SQLHelper_ db = new SQLHelper_(); db.sql = sql; return db.ExecSql(); }
/// <summary> /// 添加栏目 /// </summary> /// <param name="lbname">栏目名称</param> /// <param name="parentid">父栏目ID</param> /// <returns>int,1=成功,0=已存在</returns> public static string AddLb(string lbname, string parentid) { string maxlbid = MaxLbid(); string sql = "INSERT INTO " + com.tablePrefix + "lb (lbid,lbname,parentid,OrderId) VALUES(" + maxlbid + ",'" + lbname + "'," + parentid + "," + maxlbid + ")"; SQLHelper_ db = new SQLHelper_(); db.sql = sql; return(db.ExecSql()); }
public static bool AdminDel(string id) { string sql = "DELETE Admin WHERE id=" + id; try { SQLHelper_ db = new SQLHelper_(); db.sql = sql; db.ExecSql(); return true; } catch { return false; } }
protected void Button1_Click(object sender, EventArgs e) { string pwd = txtPwd.Text; string newPwd = txtNewPwd.Text; string newPwd2 = txtNewPwd2.Text; if (pwd.Length == 0) { alert.Show(Page, "请填写原密码"); return; } if (newPwd.Length == 0) { alert.Show(Page, "请填写新密码"); return; } if (newPwd != newPwd2) { alert.Show(Page, "新密码与确认新密码不一致"); return; } string memberName = Session["AdminName"].ToString(); SQLHelper_ db = new SQLHelper_(); db.sql = "SELECT pwd FROM " + com.tablePrefix + "admin WHERE username='******'"; DataTable dt = db.Get_DataTable(); pwd = com.MD5(pwd, 1); newPwd = com.MD5(newPwd, 1); if (dt.Rows.Count > 0) { if (pwd != dt.Rows[0]["pwd"].ToString()) { alert.Show(Page, "原密码错误"); return; } else { db.sql = "UPDATE admin SET Pwd='" + newPwd + "' WHERE username='******'"; db.ExecSql(); alert.Show(Page,"修改成功"); } } else { Response.Redirect("Login.aspx"); } }
public static bool AdminDel(string id) { string sql = "DELETE Admin WHERE id=" + id; try { SQLHelper_ db = new SQLHelper_(); db.sql = sql; db.ExecSql(); return(true); } catch { return(false); } }
public static string adminEdit(string id, string pwd, string role) { string sql = ""; if (pwd.Length > 0) sql = "UPDATE Admin SET pwd='" + pwd + "',role='" + role + "' WHERE id=" + id; else sql = "UPDATE Admin SET role='" + role + "' WHERE id=" + id; try { SQLHelper_ db = new SQLHelper_(); db.sql = sql; db.ExecSql(); return "1"; } catch (Exception ex) { return ex.Message;// +"SQL:" + sql; } }
public static string adminEdit(string id, string pwd, string role) { string sql = ""; if (pwd.Length > 0) { sql = "UPDATE Admin SET pwd='" + pwd + "',role='" + role + "' WHERE id=" + id; } else { sql = "UPDATE Admin SET role='" + role + "' WHERE id=" + id; } try { SQLHelper_ db = new SQLHelper_(); db.sql = sql; db.ExecSql(); return("1"); } catch (Exception ex) { return(ex.Message);// +"SQL:" + sql; } }
public static void del(string id) { SQLHelper_ db = new SQLHelper_(); db.sql = "UPDATE dxlb SET isDeleted=1 WHERE id="+id; db.ExecSql(); }
/// <summary> /// 在同类中排序 /// </summary> /// <param name="id">lb.id</param> /// <param name="isUp">1=升序,0=降序</param> /// <returns>排序后的dataTable</returns> public static void lbOrderUP(string id,bool isUp) { SQLHelper_ db = new SQLHelper_(); db.sql = "SELECT id,lbid,parentid,orderid FROM "+com.tablePrefix+"lb WHERE id="+id; DataTable dt = db.Get_DataTable(); string parentid = dt.Rows[0]["parentid"].ToString(); string curOrder = dt.Rows[0]["orderid"].ToString(); if (isUp) { db.sql = "SELECT TOP 1 id,lbid,parentid,orderid FROM " + com.tablePrefix + "lb WHERE parentid=" + parentid + " AND orderid<" + curOrder + " ORDER BY orderid DESC"; } else { db.sql = "SELECT TOP 1 id,lbid,parentid,orderid FROM " + com.tablePrefix + "lb WHERE parentid=" + parentid + " AND orderid>" + curOrder + " ORDER BY orderid"; } DataTable dt1 = db.Get_DataTable(); if (dt1.Rows.Count > 0) { string newOrder = dt1.Rows[0]["orderid"].ToString(); string otherId = dt1.Rows[0]["id"].ToString(); db.sql = "UPDATE "+com.tablePrefix+"lb SET orderid=" + newOrder + " WHERE id=" + id; db.ExecSql(); db.sql = "UPDATE "+com.tablePrefix+"lb SET orderid=" + curOrder + " WHERE id=" + otherId; db.ExecSql(); } }