protected void butt_ok_Click(object sender, EventArgs e)
{
string sql = "";
obj = new db_help();
sql = "insert into stk (stlx,stnr,stda,stnd,zj,stfz,txbz) values('" + Text_tx.Text.ToString() + "','" + Text_nr.Text.ToString() + "','" + Text_da.Text.ToString() + "','" + Text_nd.Text.ToString() + "','" + Text_zj.Text.ToString() + "', '" + System.Convert.ToInt32(Text_fz.Text) + "' ,'" + Text_bz.Text.ToString() + "')";
obj.ExecNonSql(sql);
obj.Close();
function_all.TiaoZhuan("更新成功", "stgl_edit.aspx", 0);
}
protected void Rep_list_ItemCommand(object source, RepeaterCommandEventArgs e)
{
function_all.adminLoginChack(0, "Default.aspx");
if (e.CommandName == "dele")
{
obj = new db_help();
sql = "delete from stk where(stID=" + e.CommandArgument + ")";
obj.ExecNonSql(sql);
obj.Close();
function_all.TiaoZhuan("删除成功", "stgl.aspx?p=" + p + "&c=" + c, 0);
}
}
public void rep_list_bind()
{
obj = new db_help();
sql = "select stID,stlx,stnr,stsj from stk where(txbz='" + c + "') order by stID DESC";
pds = obj.MPagedDataSource(sql, p, 10);
obj.Close();
Rep_list.DataSource = pds;
Rep_list.DataBind();
pega.pageNow = p;
pega.pageTotle = pds.PageCount;
pega.otherQuery = "&c=" + c;
}
//用户密码注册
protected void butt_ok_Click1(object sender, System.EventArgs e)
{
string sql = "";
string adm = System.Convert.ToString(text_adm.Text);
string npw = System.Convert.ToString(text_npw.Text);
obj = new db_help();
//sql = "insert into T_user (U_name,U_password) values ( '"+ adm+ "','" + npw + "'）";
sql = "Insert into T_user(U_name, U_password) values('" + adm + "','" + npw + "')";
obj.ExecNonSql(sql);
obj.Close();
function_all.TiaoZhuan("注册成功，请登录！", "Default.aspx", 0);
}
//用户名匹配
public void controls_bind()
{
obj = new db_help();
sql = "SELECT UserName FROM admin ";
rds = obj.ExecReaderSql(sql);
if (rds.Read())
{
if (Convert.IsDBNull(rds["UserName"]) == null)
{
text_adm.Text = System.Convert.ToString(rds["UserName"]);
}
}
rds.Close();
obj.Close();
}
public void drop_cla_bind()
{
obj = new db_help();
sql = "select * From txk order by txID";
pds = obj.MPagedDataSource(sql, 0, 0);
obj.Close();
drop_cla.DataSource = pds;
drop_cla.DataTextField = "stlx";
drop_cla.DataValueField = "txbz";
drop_cla.DataBind();
for (int n = 0; n < drop_cla.Items.Count; n++)
{
if (System.Convert.ToString(drop_cla.Items[n].Value) == c)
{
drop_cla.Items[0].Selected = false;
drop_cla.Items[n].Selected = true;
break;
}
}
c = drop_cla.SelectedValue;
}
//用户密码匹配与密码修改
protected void butt_ok_Click1(object sender, System.EventArgs e)
{
function_all.adminLoginChack(0, "Default.aspx");
string ers = null;
string adm = System.Convert.ToString(text_adm.Text.Trim());
string opw = System.Convert.ToString(text_opw.Text);
string npw = System.Convert.ToString(text_npw.Text);
string spw = System.Convert.ToString(text_spw.Text);
Regex umReg = new Regex("^[A-Za-z0-9]{1,50}$");
if (!umReg.IsMatch(adm))
{
ers = "管理员账号不能为空，最大支持50个字符，可以是0-9、a-z、A-Z的组合";
}
if (string.IsNullOrEmpty(ers))
{
if (opw.Length <= 0 || npw.Length <= 0 || spw.Length <= 0)
{
ers = "密码不能为空";
}
else
{
if (npw != spw)
{
ers = "两次输入的新密码不一样";
}
}
}
if (string.IsNullOrEmpty(ers))
{
string dbpwd = "";
obj = new db_help();
sql = "SELECT PassWord FROM admin";
rds = obj.ExecReaderSql(sql);
if (rds.Read())
{
if (!Convert.IsDBNull(rds["PassWord"]))
{
dbpwd = System.Convert.ToString(rds["PassWord"]);
}
}
rds.Close();
obj.Close();
if (opw != dbpwd)
{
ers = "原密码不正确";
}
}
if (string.IsNullOrEmpty(ers))
{
obj = new db_help();
sql = "UPDATE admin SET UserName = '******', PassWord = '******' ";
obj.ExecNonSql(sql);
obj.Close();
function_all.TiaoZhuan("密码修改成功，下次登录生效！", "welcome.aspx", 0);
Response.End();
}
else
{
function_all.TiaoZhuan(ers, "password.aspx", 0);
Response.End();
}
}