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