public static void En_btn(Device_Management_System form)
{
form.Not_Returned_button.Enabled = true;
form.Returned_log_button.Enabled = true;
form.Borrow_button.Enabled = true;
form.Return_button.Enabled = true;
}
public static void Refresh(Device_Management_System form)
{
DBHelper db = new DBHelper();
//string SqlText = "select * from Borrow_Device_Input_List";
//string SqlText = "select * from Borrow_Device_Input_List union all select * from Borrow_Device_FlashStorage_List";
string SqlText = Refresh_SqlText;
DataSet data = db.DBselect(SqlText, null);
form.dataGridView1.DataSource = data.Tables[0];
}
private void Login_button_Click(object sender, EventArgs e)
{
Account_n = Account_textBox.Text;
if (Account_textBox.Text == "" || Password_textBox.Text == "")
{
MessageBox.Show("Account and password can not be empty!", "Prompt", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
DBHelper db = new DBHelper();
string SqlText = "select * from Admin where Account = @username and Password = @password";
SqlParameter Acount = new SqlParameter("@username", Account_textBox.Text.Trim());
SqlParameter Password = new SqlParameter("@password", Password_textBox.Text.Trim());
if (count < 3)
{
count++;
DataSet data = db.DBselect(SqlText, Acount, Password);
if (data.Tables[0].Rows.Count == 0)
{
SqlText = "select * from Users where Account = @username and Password = @password";
Acount = new SqlParameter("@username", Account_textBox.Text.Trim());
Password = new SqlParameter("@password", Password_textBox.Text.Trim());
data = db.DBselect(SqlText, Acount, Password);
if (data.Tables[0].Rows.Count == 0)
{
MessageBox.Show("The account does not exist or the password is incorrect.", "Prompt", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
Device_Management_System forms = new Device_Management_System();
forms.Show();
this.Hide();
}
//MessageBox.Show("The account does not exist or the password is incorrect.", "Prompt", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
Device_Management_System forms = new Device_Management_System();
forms.Show();
this.Hide();
}
}
else
{
Application.Exit();
}
}
public static void Set(Device_Management_System form) //参数获取窗体对象
{
form.dataGridView1.RowHeadersVisible = false; //
//form.dataGridView1.Columns[0].Visible = false; //隐藏列
//dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
//dataGridView1.AutoResizeRows(DataGridViewAutoSizeRowsMode.AllCells); //自动行高
form.dataGridView1.Columns[0].Width = 80; //指定列宽
form.dataGridView1.Columns[1].Width = 120;
form.dataGridView1.Columns[2].Width = 80;
form.dataGridView1.Columns[3].Width = 120;
form.dataGridView1.Columns[4].Width = 120;
form.dataGridView1.Columns[5].Width = 180;
//form.dataGridView1.Columns[6].Width = 200;
form.dataGridView1.DefaultCellStyle.WrapMode = DataGridViewTriState.True; //设置显示所有字段
form.dataGridView1.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.AllCellsExceptHeaders; //自动调节行高
//dataGridView1.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; //设置标题栏剧中，但由于
//dataGridView1.ColumnHeadersDefaultCellStyle.Font = new Font("Tahoma", 9, FontStyle.Bold); //设置标题文字
//dataGridView1.RowsDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; //所有字段剧中显示
//dataGridView1.Columns[2].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; //设置居中对齐
//dataGridView1.Columns[5].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft; //设置左对齐
//dataGridView1.Columns[7].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft; //设置右对齐
//设置字段的对齐方式
for (int i = 0; i <= 5; i++)
{
if (i == 5)
{
continue;
}
form.dataGridView1.Columns[i].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
}
//设置标题剧中
foreach (DataGridViewColumn col in form.dataGridView1.Columns)
{
col.SortMode = DataGridViewColumnSortMode.NotSortable;
}
form.dataGridView1.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
GC.Collect();
}