public void drop_cla_bind()
{
obj = new db_help();
string connectingstring = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["connStr"].ConnectionString;
SqlConnection scon = new SqlConnection(connectingstring);
scon.Open();
string sql = "select * from txk order by txID";
SqlDataAdapter sda = new SqlDataAdapter(sql, scon);
DataSet ds = new DataSet();
sda.Fill(ds);
drop_cla.DataSource = ds;
drop_cla.DataTextField = "stlx";
drop_cla.DataValueField = "txID";
drop_cla.DataBind();
sda.Dispose();
scon.Close();
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;
}
}
}
protected void Rep_list_ItemCommand(object source, RepeaterCommandEventArgs e)
{
function_all.adminLoginChack(0, "Default.aspx");
obj = new db_help();
if (e.CommandName == "dele")
{
sql = "delete from stk where(stID=" + e.CommandArgument + ")";
obj.ExecNonSql(sql);
function_all.TiaoZhuan("删除成功", "shoudonng.aspx?p=" + p + "&c=" + c, 0);
}
if (e.CommandName == "tianjia")
{
//可以用if语句来实现分类查询
sql = "select stnr from stk where(stID=" + e.CommandArgument + ")";
rds = obj.ExecReaderSql(sql);
if (rds.Read())
{
if (!Convert.IsDBNull(rds["stnr"]))
{
// Text_nr.Text = "First Line\r\nSecond Line\r\nThird Line";
Text_nr.Text = rds["stnr"].ToString();
//Server.HtmlEncode(br);
}
}
Text_nr.Text = rds["stnr"].ToString();
}
}
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);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
protected void butt_log_Click(object sender, EventArgs e)
{
string sql = "";
db_help obj = new db_help();
SqlDataReader rds = default(SqlDataReader);
string gadm = "";
string gpwd = "";
gadm = System.Convert.ToString(text_adm.Text);
gpwd = System.Convert.ToString(text_pwd.Text);
//判断用户输出是否为空或者过长
if (gadm.Length <= 0 || gpwd.Length <= 0)
{
function_all.TiaoZhuan("用户名/密码不能为空", "Default.aspx", 0);
Response.End();
}
int bdid = 0;
string dbpwd = "";
sql = "Select * from T_user where U_name ='" + gadm + "' and U_password ='******'";
rds = obj.ExecReaderSql(sql);
if (rds.Read())
{
Session["aid"] = rds.GetValue(rds.GetOrdinal("U_name")); //获取该用户名
Session["aid"] = rds.GetValue(rds.GetOrdinal("U_password")); //获取该用户密码
Page.Response.Redirect("welcome.aspx");
rds.Close();
rds.Close();
}
else
{
function_all.TiaoZhuan("账号/密码错误", "Default.aspx", 0);//提示
Response.End();
}
//文本框中输入的账号和密码与session存储的数据比对
if (gpwd == dbpwd)
{
Session["aid"] = bdid;
HttpCookieCollection myCookieCollection = new HttpCookieCollection();
//HttpCookie类专门由C#用于读取和写入Cookie的类。
HttpCookie cstgl = new HttpCookie("cstgl");
cstgl.Value = DateTime.Now.ToString();
myCookieCollection.Add(cstgl);
Response.AppendCookie(cstgl);
}
else
{
function_all.TiaoZhuan("账号/密码错误", "Default.aspx", 0);
Response.End();
}
}
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();
}
private void InputExcel(string pPath)
{
string conn = "Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source =" + pPath + ";Extended Properties='Excel 8.0;HDR=False;IMEX=1'";
OleDbConnection oleCon = new OleDbConnection(conn);
oleCon.Open();
string Sql = "select * from [Sheet1$]";
OleDbDataAdapter mycommand = new OleDbDataAdapter(Sql, oleCon);
DataSet ds = new DataSet();
mycommand.Fill(ds, "[Sheet1$]");
oleCon.Close();
int count = ds.Tables["[Sheet1$]"].Rows.Count;
for (int i = 0; i < count; i++)
{
string stlx, stnr, stda, stnd, zj, stfz, txbz;
stlx = ds.Tables["[Sheet1$]"].Rows[i]["stlx"].ToString().Trim();
stnr = ds.Tables["[Sheet1$]"].Rows[i]["stnr"].ToString().Trim();
stda = ds.Tables["[Sheet1$]"].Rows[i]["stda"].ToString().Trim();
stnd = ds.Tables["[Sheet1$]"].Rows[i]["stnd"].ToString().Trim();
zj = ds.Tables["[Sheet1$]"].Rows[i]["zj"].ToString().Trim();
stfz = ds.Tables["[Sheet1$]"].Rows[i]["stfz"].ToString().Trim();
txbz = ds.Tables["[Sheet1$]"].Rows[i]["txbz"].ToString().Trim();
string excelsql = "insert into stk(stlx, stnr, stda,stnd,zj,stfz,txbz) values ('" + stlx + "','" + stnr + "','" + stda + "','" + stnd + "','" + zj + "','" + stfz + "','" + txbz + "')";
try
{
//导入到SQL Server中
db_help dm = new db_help();
dm.ExecReaderSql(excelsql);
// Response.Write("<script language='javascript'>Alert('数据导入成功!');window.location='stgl_edit.aspx'</script>");
function_all.TiaoZhuan("数据导入成功", "stgl_edit.aspx", 0);
}
catch (Exception)
{
//Response.Write("<script language='javascript'>Alert('数据导入失败!');window.location='stgl_edit.aspx'</script>");
function_all.TiaoZhuan("数据导入失败", "stgl_sdit.aspx", 0);
}
}
}
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();
}
}
protected void butt_ok_Click(object sender, EventArgs e)
{
int a = System.Convert.ToInt32(Txt_1.Text);
obj = new db_help();
if (System.Convert.ToUInt32(c) == 1)
{
sql = "select top " + a + " [X_nr] from xzt where X_zj= " + Txt_3.Text + " and X_nd= '" + Txt_2.Text.ToString() + "'";
rds = obj.ExecReaderSql(sql);
if (rds.Read())
{
if (!Convert.IsDBNull(rds["X_nr"]))
{
Text_nr.Text = rds["X_nr"].ToString();
}
}
}
if (System.Convert.ToUInt32(c) == 2)
{
sql = "select top " + a + " p_nr from pdt where p_zj=" + Txt_3.Text + "and p_nd='" + Txt_2.Text.ToString() + "'";
rds = obj.ExecReaderSql(sql);
if (rds.Read())
{
if (!Convert.IsDBNull(rds["p_nr"]))
{
Text_nr.Text = rds["p_nr"].ToString();
}
}
}
if (System.Convert.ToUInt32(c) == 3)
{
sql = "select top " + a + " d_nr from dcx where d_zj=" + Txt_3.Text + "and d_nd='" + Txt_2.Text.ToString() + "'";
rds = obj.ExecReaderSql(sql);
if (rds.Read())
{
if (!Convert.IsDBNull(rds["d_nr"]))
{
Text_nr.Text = rds["d_nr"].ToString();
}
}
}
if (System.Convert.ToUInt32(c) == 4)
{
sql = "select top " + a + " j_nr from jdt where j_zj=" + Txt_3.Text + "and j_nd='" + Txt_2.Text.ToString() + "'";
rds = obj.ExecReaderSql(sql);
if (rds.Read())
{
if (!Convert.IsDBNull(rds["j_nr"]))
{
Text_nr.Text = rds["j_nr"].ToString();
}
}
}
if (System.Convert.ToUInt32(c) == 5)
{
sql = "select top " + a + " b_nr from bct where b_zj=" + Txt_3.Text + "and b_nd='" + Txt_2.Text.ToString() + "'";
rds = obj.ExecReaderSql(sql);
if (rds.Read())
{
if (!Convert.IsDBNull(rds["b_nr"]))
{
Text_nr.Text = rds["b_nr"].ToString();
}
}
}
}
