private void course_Load(object sender, EventArgs e) { sql = new SqLiteHelper("data source=" + Application.StartupPath + "\\mydb.db"); //--------------------------------------------------------------------------- SQLiteDataReader read = sql.ExecuteQuery("select cname from course"); //bool bRead = false; while (read.Read()) { cbName.Items.Add(read.GetString(read.GetOrdinal("cname"))); //bRead = true; } //if (bRead) cbName.SelectedIndex = 0; //---------------------------------------------------------------------------- if (TITLE == "编辑") { txtNO.Enabled = false; SQLiteDataReader reader = sql.ExecuteQuery("select * from course where cno='" + GUID + "'"); while (reader.Read()) { txtNO.Text = reader.GetString(reader.GetOrdinal("cno")); txtName.Text = reader.GetString(reader.GetOrdinal("cname")); cbName.Text = reader.GetString(reader.GetOrdinal("cpno")); txtCredit.Text = reader.GetString(reader.GetOrdinal("ccredit")); } } }
private void teacher_Load(object sender, EventArgs e) { sql = new SqLiteHelper("data source=" + Application.StartupPath + "\\mydb.db"); cbSex.Items.Add("男"); cbSex.Items.Add("女"); cbSex.SelectedIndex = 0; for (int i = 60; i >= 24; i--) { cbAge.Items.Add(i.ToString()); } cbAge.SelectedIndex = 0; cbEb.Items.Add("博士"); cbEb.Items.Add("硕士"); cbEb.Items.Add("学士"); cbEb.SelectedIndex = 0; cbPt.Items.Add("教授"); cbPt.Items.Add("副教授"); cbPt.Items.Add("讲师"); cbPt.Items.Add("助教"); cbPt.SelectedIndex = 0; //--------------------------------------------------------------------------- SQLiteDataReader read = sql.ExecuteQuery("select cname from course"); //bool bRead = false; while (read.Read()) { string strCno = read.GetString(read.GetOrdinal("cname")); cbCno1.Items.Add(strCno); cbCno2.Items.Add(strCno); cbCno3.Items.Add(strCno); //bRead = true; } //if (bRead) cbName.SelectedIndex = 0; //---------------------------------------------------------------------------- if (TITLE == "编辑") { txtNO.Enabled = false; SQLiteDataReader reader = sql.ExecuteQuery("select * from teacher where tno='" + GUID + "'"); while (reader.Read()) { txtNO.Text = reader.GetString(reader.GetOrdinal("tno")); txtName.Text = reader.GetString(reader.GetOrdinal("tname")); cbSex.Text = reader.GetString(reader.GetOrdinal("tsex")); cbAge.Text = reader.GetString(reader.GetOrdinal("tage")); cbEb.Text = reader.GetString(reader.GetOrdinal("teb")); cbPt.Text = reader.GetString(reader.GetOrdinal("tpt")); cbCno1.Text = reader.GetString(reader.GetOrdinal("cno1")); cbCno2.Text = reader.GetString(reader.GetOrdinal("cno2")); cbCno3.Text = reader.GetString(reader.GetOrdinal("cno3")); } } }
private void runClosedCommand() { int a = 0; DataTable dt3 = sql.ExecuteQuery("select count(1) from userTB where userpower=3"); int i = Convert.ToInt32(dt3.Rows[0][0].ToString()); if (i > 0) { //已经创建了普通用户,临时用户可以销毁 int rownum = sql.ExecuteNonQuery("delete from userTB where username='******' and passwd='123456'"); Console.WriteLine(rownum); } }
private void sct_Load(object sender, EventArgs e) { if (GUID == "") { GUID = System.Guid.NewGuid().ToString("N"); } txtGUID.Text = GUID; //-------------------------------------------------------------------------- sql = new SqLiteHelper("data source=" + Application.StartupPath + "\\mydb.db"); //-------------------------------------------------------------------------- SQLiteDataReader read; read = sql.ExecuteQuery("select sno,sname from student"); while (read.Read()) { cbsno.Items.Add(read.GetString(read.GetOrdinal("sno")) + "," + read.GetString(read.GetOrdinal("sname"))); } read = sql.ExecuteQuery("select cno,cname from course"); while (read.Read()) { cbcno.Items.Add(read.GetString(read.GetOrdinal("cno")) + "," + read.GetString(read.GetOrdinal("cname"))); } read = sql.ExecuteQuery("select tno,tname from teacher"); while (read.Read()) { cbtno.Items.Add(read.GetString(read.GetOrdinal("tno")) + "," + read.GetString(read.GetOrdinal("tname"))); } //------------------------------------------------------------------------------------------------- if (TITLE == "编辑") { SQLiteDataReader reader = sql.ExecuteQuery("select * from sct where GUID='" + GUID + "'"); while (reader.Read()) { cbsno.Text = reader.GetString(reader.GetOrdinal("sno")); cbcno.Text = reader.GetString(reader.GetOrdinal("cno")); cbtno.Text = reader.GetString(reader.GetOrdinal("tno")); txtgrade.Text = reader.GetString(reader.GetOrdinal("grade")); } } }
private void student_Load(object sender, EventArgs e) { sql = new SqLiteHelper("data source=" + Application.StartupPath + "\\mydb.db"); //SqLiteHelper inssql = new SqLiteHelper("data source=" + Application.StartupPath + "\\mydb.db"); cbSex.Items.Add("男"); cbSex.Items.Add("女"); cbSex.SelectedIndex = 0; for (int i = 24; i >= 14; i--) { cbAge.Items.Add(i.ToString()); } cbAge.SelectedIndex = 0; //--------------------------------------------------------------------------- SQLiteDataReader read = sql.ExecuteQuery("select dname from department"); bool bRead = false; while (read.Read()) { cbDept.Items.Add(read.GetString(read.GetOrdinal("dname"))); bRead = true; } if (bRead) { cbDept.SelectedIndex = 0; } //---------------------------------------------------------------------------- if (TITLE == "编辑") { txtNO.Enabled = false; SQLiteDataReader reader = sql.ExecuteQuery("select * from student where sno='" + GUID + "'"); while (reader.Read()) { txtNO.Text = reader.GetString(reader.GetOrdinal("sno")); txtName.Text = reader.GetString(reader.GetOrdinal("sname")); cbSex.Text = reader.GetString(reader.GetOrdinal("ssex")); cbAge.Text = reader.GetString(reader.GetOrdinal("sage")); cbDept.Text = reader.GetString(reader.GetOrdinal("sdept")); } } }
private void Init() { //ConsoleManager.Show();//打开信息打印窗口 LoginCommand = new DelegateCommand <Login>(runLoginCommand); LoginKeyDownCommand = new DelegateCommand <Login>(runLoginKeyDownCommand); sql = SqLiteHelper.getInstance; sql.ConnectionString = "data source=mydb.db"; sql.CreateTable("userTB", new string[] { "id", "username", "passwd", "userpower", "itemlist", "times" }, new string[] { "integer primary key AUTOINCREMENT", "varchar2(100) not null", "varchar2(100) not null", "int not null", "varchar2(100) not null", "int not null" }); //创建名为table1的数据表 DataTable dt = sql.ExecuteQuery("select count(*) from userTB"); int count = Convert.ToInt32(dt.Rows[0][0].ToString()); if (count == 0) { //是新表,需要创建管理员账户 sql.InsertValues("userTB", new string[] { null, "admin", "123456", "2", "1,1,1,1", "0" }); } }
private void btnSct_Click(object sender, EventArgs e) { string strsql = "select * from sct"; string[] value = { "sno", "cno", "tno", "grade" }; string[] content = { "学号", "课程号", "教工号", "成绩" }; for (int i = 0; i < content.Length; i++) { if (cbSct.Text == content[i]) { strsql += " where "; strsql += value[i]; strsql += " like '%"; strsql += txtSct.Text; strsql += "%'"; break; } } //MessageBox.Show(strsql); //------------------------------------------------------------------------------------ listView5.BeginUpdate(); listView5.Items.Clear(); //读取整张表 SQLiteDataReader reader = sql.ExecuteQuery(strsql); while (reader.Read()) { int no = listView5.Items.Count; listView5.Items.Add(Convert.ToString(no + 1)); listView5.Items[no].SubItems.Add(reader.GetString(reader.GetOrdinal("GUID"))); listView5.Items[no].SubItems.Add(reader.GetString(reader.GetOrdinal("sno"))); listView5.Items[no].SubItems.Add(reader.GetString(reader.GetOrdinal("cno"))); listView5.Items[no].SubItems.Add(reader.GetString(reader.GetOrdinal("tno"))); listView5.Items[no].SubItems.Add(reader.GetString(reader.GetOrdinal("grade"))); } //------------------------------------------------------------------------------- listView5.EndUpdate(); }
private void runLoginCommand(Login window) { if (Passwd == null || Username == null) { return; } if (isGen2) { if (Passwd == "guest" && Username == "guest") { //客户权限 //五个权限分别对应实时信息、配置页面(读取配置和更改配置其中一个可见即为可见)、读取配置、更改配置、追溯码 Gen2MainWindow m = new Gen2MainWindow(new string[] { "Visible", "Hidden", "Hidden", "Hidden", "Hidden" }); m.Show(); window.Hide(); } else if (Passwd == "production" && Username == "production") { //产线 Gen2MainWindow m = new Gen2MainWindow(new string[] { "Visible", "Visible", "Visible", "Hidden", "Visible" }); m.Show(); window.Hide(); } else if (Passwd == "ruineng" && Username == "ruineng") { //锐能 Gen2MainWindow m = new Gen2MainWindow(new string[] { "Visible", "Visible", "Visible", "Visible", "Hidden" }); m.Show(); window.Hide(); } else if (Passwd == "aftermarket" && Username == "aftermarket") { Gen2MainWindow m = new Gen2MainWindow(new string[] { "Visible", "Visible", "Visible", "Visible", "Visible" }); m.Show(); window.Hide(); } else if (Passwd == "abc@123" && Username == "Gotion") { Gen2MainWindow m = new Gen2MainWindow(new string[] { "Visible", "Visible", "Visible", "Visible", "Visible" }); m.Show(); window.Hide(); } else { Application.Current.Dispatcher.Invoke((Action) delegate { ModernDialog.ShowMessage("用户名或密码错误", "提示", MessageBoxButton.OK); }); return; } } else if (isGen3) { if (Passwd == "master" && Username == "master") { //超级用户 ////DataTable dt=sql.ExecuteQuery("select times from userTB where username='******'"); //登录次数 // int count = Convert.ToInt32(dt.Rows[0][0].ToString()); // String pwd = PasswordBuilder.calPwdByTimes('master',count); window.Hide(); if (isGen3) { MainWindow m = new MainWindow(new string[] { "Visible", "Visible", "Visible", "Visible", "Visible" }, 0); m.Show(); } //else if (isGen2) { // Gen2MainWindow m = new Gen2MainWindow(); // m.Show(); //} //AddUser m = new AddUser(0); //m.Show(); } else { DataTable result = sql.ExecuteQuery("select * from userTB where username=@username and passwd=@passwd", new Dictionary <string, string>() { { "@username", Username }, { "@passwd", Passwd } }); bool ifHasRows = (result.Rows.Count != 0); User u = new User(); if (ifHasRows) { u.Username = result.Rows[0]["username"].ToString(); u.Passwd = result.Rows[0]["passwd"].ToString(); u.Itemlist = result.Rows[0]["itemlist"].ToString(); u.Times = Convert.ToInt32(result.Rows[0]["times"].ToString()); u.Userpower = Convert.ToInt32(result.Rows[0]["userpower"].ToString()); } if (ifHasRows) { //登陆成功 if (u.Username == "admin") { //临时用户登陆 sql.ExecuteNonQuery("update userTB set times=(select times from userTB where username='******')+1 where username='******'"); //弹出建立用户界面 //window.Hide(); AddUser m = new AddUser(2); m.Show(); } else { //普通用户或管理员登陆 sql.ExecuteNonQuery("update userTB set times=(select times from userTB where username=@username)+1 where username=@username;", new Dictionary <string, string> { { "@username", Username } }); if (u.Userpower == 1) { //管理员登陆 string[] sArray = u.Itemlist.ToString().Split(','); for (int i = 0; i < sArray.Length; i++) { sArray[i] = sArray[i] == "0" ? "Hidden" : "Visible"; } window.Hide(); MainWindow m = new MainWindow(sArray, 1); m.Show(); } else if (u.Userpower == 3) { //普通用户登陆 string[] sArray = u.Itemlist.ToString().Split(','); for (int i = 0; i < sArray.Length; i++) { sArray[i] = sArray[i] == "0" ? "Collapsed" : "Visible"; } window.Hide(); MainWindow m = new MainWindow(sArray, 3); m.Show(); } } } else { //登陆失败 Application.Current.Dispatcher.Invoke((Action) delegate { ModernDialog.ShowMessage("用户名或密码错误", "提示", MessageBoxButton.OK); }); return; } } } else if (IsUDS) { if (Passwd == "master" && Username == "master") { window.Hide(); UDSTestMainWindow m = new UDSTestMainWindow(); m.Show(); } } else if (IsTooling) { if (Passwd == "abc@123" && Username == "GotionTooling") { window.Hide(); ToolingMainWindow m = new ToolingMainWindow(); m.Show(); } } }