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