protected void DGList_DeleteCommand(object source, DataGridCommandEventArgs e)
{
int nowRow = int.Parse(e.Item.Cells[0].Text);
try
{
string sql = "delete from t_plat where id=" + nowRow.ToString();
AccessDb.ExecuteNonQuery(sql);
if (e.Item.Cells[6] != null && e.Item.Cells[6].Text.Length > 0)
{
string filePath = Page.Server.MapPath(@"~\" + e.Item.Cells[6].Text);
if (File.Exists(filePath))
{
File.Delete(filePath);
}
}
JS.Alert("删除成功");
}
catch (Exception ex)
{
JS.Alert("删除失败:" + ex);
}
showgrid(source, e);
}
protected void DGList_DeleteCommand(object source, DataGridCommandEventArgs e)
{
int nowRow = int.Parse(e.Item.Cells[0].Text);
string sql = "delete from t_programs where id=" + nowRow.ToString();
AccessDb.ExecuteNonQuery(sql);
JS.Alert("删除成功");
showgrid(source, e);
}
private void DGList_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
try
{
AccessDb.ExecuteNonQuery("delete from t_user where id=" + int.Parse(e.Item.Cells[0].Text));
JS.Alert("删除成功");
}
catch (Exception ex)
{
JS.Alert("删除失败:" + ex);
}
showgrid(source, e);
}
protected void DGList_DeleteCommand(object source, DataGridCommandEventArgs e)
{
int nowRow = int.Parse(e.Item.Cells[0].Text);
string sql = "delete from t_frind where id=" + nowRow.ToString();
AccessDb.ExecuteNonQuery(sql);
try
{
JS.Alert("删除成功");
}
catch (Exception ex)
{
JS.Alert("删除失败:" + ex);
}
showgrid(source, e);
}
protected void but_save_Click(object sender, EventArgs e)
{
string sql = "insert into t_frind(ptitle,purl,ptype) values('{0}','{1}','{2}')";
string title = this.txt_title.Text;
string type = this.DropDownList1.SelectedValue;
string url = this.txt_url.Text;
sql = string.Format(sql, title, url, type);
AccessDb.ExecuteNonQuery(sql);
JS.Alert("添加成功");
this.txt_title.Text = "";
this.txt_url.Text = "";
showgrid(null, null);
}
protected void but_save_Click(object sender, EventArgs e)
{
int sort = 0;
try
{
sort = int.Parse(this.txt_sort.Text);
}
catch
{
JS.Alert("请输入整数！");
return;
}
if (this.txt_title.Text.Length >= 255)
{
JS.Alert("栏目名称过长，请重新输入！");
return;
}
if (ViewState["pk"] != null)
{
//edit
string sql = "update t_programs set ptitle='{0}' ,purl='{1}',pstate={2}, picurl='{3}',psort={4} where id=" + ViewState["pk"].ToString();
sql = string.Format(sql, this.txt_title.Text, this.txt_url.Text, this.drp_isUse.SelectedValue == "是" ? "True" : "False", "", sort.ToString());
AccessDb.ExecuteNonQuery(sql);
JS.Alert("修改成功");
ViewState["pk"] = null;
//this.txt_title.Enabled = true;
}
else
{
//tianjia
string sql = "insert into t_programs(ptitle,purl,pstate,picurl,psort) values('{0}','{1}',{2},'{3}',{4})";
sql = string.Format(sql, this.txt_title.Text, this.txt_url.Text, this.drp_isUse.SelectedValue == "是" ? "True" : "False", "", sort);
AccessDb.ExecuteNonQuery(sql);
JS.Alert("添加成功");
}
this.txt_title.Text = "";
this.txt_url.Text = "";
txt_sort.Text = "";
this.drp_isUse.SelectedIndex = 0;
showgrid(null, null);
}
private void but_save_Click(object sender, System.EventArgs e)
{
//add
if (ViewState["pk"] != null)
{//edit
txt_user.Enabled = true;
try
{
string pass = this.txt_pass.Text;
AccessDb.ExecuteNonQuery("update t_user set pass='******' where id=" + ViewState["pk"].ToString());
JS.Alert("修改成功");
ViewState["pk"] = null;
}
catch (Exception ex)
{
JS.Alert("修改失败:" + ex);
}
}
else
{
if (AccessDb.Execute("select * from t_user where Uname='" + this.txt_user.Text.Trim().Replace("'", "''") + "'").Tables[0].Rows.Count != 0)
{
JS.Alert("存在同名用户");
return;
}
try
{
string pass = this.txt_pass.Text;
string uname = this.txt_user.Text;
string sql = "insert into t_user (uname,pass) values('{0}','{1}')";
sql = string.Format(sql, uname, pass);
AccessDb.ExecuteNonQuery(sql);
JS.Alert("添加成功");
ViewState["pk"] = null;
}
catch (Exception ex)
{
JS.Alert("添加失败:" + ex);
}
}
showgrid(null, null);
this.txt_user.Text = "";
this.txt_pass.Text = "";
}
protected void Button1_Click(object sender, EventArgs e)
{
string sql = "update t_3th set purl='" + this.txt_url.Text.Trim() + "' where id=";
switch (UID)
{
case "interface":
sql += "1";
break;
case "use":
sql += "2";
break;
case "source":
sql += "3";
break;
}
AccessDb.ExecuteNonQuery(sql);
JS.Alert("成功.");
}
