?? frmlogin.cs
字號:
using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
using System.Data.SqlClient;
namespace OneToMany
{
/// <summary>
/// frmLogin 的摘要說明。
/// </summary>
public class frmLogin : System.Windows.Forms.Form
{
private System.Windows.Forms.ImageList imageList1;
private System.Windows.Forms.Button btnCancel;
private System.Windows.Forms.Button btnOK;
private System.Windows.Forms.PictureBox pictureBox2;
private System.Windows.Forms.Label label2;
private System.Windows.Forms.PictureBox pictureBox1;
private System.Windows.Forms.Label label1;
private System.Windows.Forms.TextBox txtPwd;
private System.Windows.Forms.TextBox txtUser;
private System.Windows.Forms.PictureBox pictureBox3;
private System.ComponentModel.IContainer components;
public frmLogin()
{
//
// Windows 窗體設計器支持所必需的
//
InitializeComponent();
//
// TODO: 在 InitializeComponent 調用后添加任何構造函數代碼
//
}
/// <summary>
/// 清理所有正在使用的資源。
/// </summary>
protected override void Dispose( bool disposing )
{
if( disposing )
{
if(components != null)
{
components.Dispose();
}
}
base.Dispose( disposing );
}
#region Windows 窗體設計器生成的代碼
/// <summary>
/// 設計器支持所需的方法 - 不要使用代碼編輯器修改
/// 此方法的內容。
/// </summary>
private void InitializeComponent()
{
this.components = new System.ComponentModel.Container();
System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(frmLogin));
this.imageList1 = new System.Windows.Forms.ImageList(this.components);
this.btnCancel = new System.Windows.Forms.Button();
this.btnOK = new System.Windows.Forms.Button();
this.pictureBox2 = new System.Windows.Forms.PictureBox();
this.txtPwd = new System.Windows.Forms.TextBox();
this.label2 = new System.Windows.Forms.Label();
this.pictureBox1 = new System.Windows.Forms.PictureBox();
this.label1 = new System.Windows.Forms.Label();
this.txtUser = new System.Windows.Forms.TextBox();
this.pictureBox3 = new System.Windows.Forms.PictureBox();
this.SuspendLayout();
//
// imageList1
//
this.imageList1.ImageSize = new System.Drawing.Size(32, 32);
this.imageList1.TransparentColor = System.Drawing.Color.Transparent;
//
// btnCancel
//
this.btnCancel.DialogResult = System.Windows.Forms.DialogResult.Cancel;
this.btnCancel.Image = ((System.Drawing.Image)(resources.GetObject("btnCancel.Image")));
this.btnCancel.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
this.btnCancel.Location = new System.Drawing.Point(216, 176);
this.btnCancel.Name = "btnCancel";
this.btnCancel.Size = new System.Drawing.Size(80, 32);
this.btnCancel.TabIndex = 4;
this.btnCancel.Text = "取消(&C)";
this.btnCancel.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
//
// btnOK
//
this.btnOK.DialogResult = System.Windows.Forms.DialogResult.OK;
this.btnOK.Image = ((System.Drawing.Image)(resources.GetObject("btnOK.Image")));
this.btnOK.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
this.btnOK.Location = new System.Drawing.Point(120, 176);
this.btnOK.Name = "btnOK";
this.btnOK.Size = new System.Drawing.Size(80, 32);
this.btnOK.TabIndex = 3;
this.btnOK.Text = "確定(&O)";
this.btnOK.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
this.btnOK.Click += new System.EventHandler(this.btnOK_Click);
//
// pictureBox2
//
this.pictureBox2.BackColor = System.Drawing.Color.Transparent;
this.pictureBox2.BackgroundImage = ((System.Drawing.Image)(resources.GetObject("pictureBox2.BackgroundImage")));
this.pictureBox2.Location = new System.Drawing.Point(40, 128);
this.pictureBox2.Name = "pictureBox2";
this.pictureBox2.Size = new System.Drawing.Size(32, 32);
this.pictureBox2.TabIndex = 10;
this.pictureBox2.TabStop = false;
//
// txtPwd
//
this.txtPwd.Location = new System.Drawing.Point(88, 136);
this.txtPwd.Name = "txtPwd";
this.txtPwd.PasswordChar = '*';
this.txtPwd.Size = new System.Drawing.Size(208, 21);
this.txtPwd.TabIndex = 2;
this.txtPwd.Text = "";
//
// label2
//
this.label2.Location = new System.Drawing.Point(88, 112);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(80, 23);
this.label2.TabIndex = 8;
this.label2.Text = "操作員密碼：";
this.label2.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
//
// pictureBox1
//
this.pictureBox1.BackColor = System.Drawing.Color.Transparent;
this.pictureBox1.BackgroundImage = ((System.Drawing.Image)(resources.GetObject("pictureBox1.BackgroundImage")));
this.pictureBox1.Location = new System.Drawing.Point(40, 64);
this.pictureBox1.Name = "pictureBox1";
this.pictureBox1.Size = new System.Drawing.Size(32, 32);
this.pictureBox1.TabIndex = 13;
this.pictureBox1.TabStop = false;
//
// label1
//
this.label1.Location = new System.Drawing.Point(88, 56);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(80, 23);
this.label1.TabIndex = 14;
this.label1.Text = "操作員姓名：";
this.label1.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
//
// txtUser
//
this.txtUser.Location = new System.Drawing.Point(88, 80);
this.txtUser.Name = "txtUser";
this.txtUser.Size = new System.Drawing.Size(208, 21);
this.txtUser.TabIndex = 1;
this.txtUser.Text = "";
//
// pictureBox3
//
this.pictureBox3.Image = ((System.Drawing.Image)(resources.GetObject("pictureBox3.Image")));
this.pictureBox3.Location = new System.Drawing.Point(0, 8);
this.pictureBox3.Name = "pictureBox3";
this.pictureBox3.Size = new System.Drawing.Size(352, 40);
this.pictureBox3.SizeMode = System.Windows.Forms.PictureBoxSizeMode.StretchImage;
this.pictureBox3.TabIndex = 15;
this.pictureBox3.TabStop = false;
//
// frmLogin
//
this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this.ClientSize = new System.Drawing.Size(352, 221);
this.Controls.Add(this.pictureBox3);
this.Controls.Add(this.txtUser);
this.Controls.Add(this.txtPwd);
this.Controls.Add(this.label1);
this.Controls.Add(this.pictureBox1);
this.Controls.Add(this.btnCancel);
this.Controls.Add(this.btnOK);
this.Controls.Add(this.pictureBox2);
this.Controls.Add(this.label2);
this.Name = "frmLogin";
this.Text = "用戶登錄";
this.Load += new System.EventHandler(this.frmLogin_Load);
this.ResumeLayout(false);
}
#endregion
private void frmLogin_Load(object sender, System.EventArgs e)
{
}
private void btnOK_Click(object sender, System.EventArgs e)
{
}
// public static string UserName()
// {
// UserName u= this.txtName.Text;
// }
public bool login()
{
if(this.txtUser.Text=="")
{
MessageBox.Show("請您輸入用戶名！","提示",MessageBoxButtons.OK,MessageBoxIcon.Warning);
return false;
}
else if(this.txtUser.Text==""&&this.txtPwd.Text=="")
{
MessageBox.Show("請您輸入用戶名！","提示",MessageBoxButtons.OK,MessageBoxIcon.Warning);
return false;
}
else if(this.txtPwd.Text=="")
{
MessageBox.Show("請您輸入密碼！","提示",MessageBoxButtons.OK,MessageBoxIcon.Warning);
this.txtPwd.Focus();
return false;
}
else
{
string userPwd=this.txtPwd.Text;
SqlParameter para=new SqlParameter("@userName",SqlDbType.VarChar,50);
para.Value=this.txtUser.Text;
SqlConnection conn=new SqlConnection("server=.;database=DBApp;Trusted_Connection=true;");
conn.Open();
SqlCommand cmd = new SqlCommand("select count(*) from 用戶清單 where 姓名=@userName", conn);
cmd.Parameters.Add(para);
int count = Convert.ToInt32(cmd.ExecuteScalar());
if(count==0)
{
MessageBox.Show("該用戶不存在！","登錄失敗",MessageBoxButtons.OK,MessageBoxIcon.Warning);
this.txtPwd.Text="";
this.txtUser.Text="";
this.txtUser.Focus();
conn.Close();
return false;
}
else
{
cmd.CommandText="select 密碼 from 用戶清單 where 姓名=@userName";
string pwd=Convert.ToString(cmd.ExecuteScalar()).Trim();
if(pwd!=userPwd)
{
conn.Close();
MessageBox.Show("密碼錯誤！","登錄失敗",MessageBoxButtons.OK,MessageBoxIcon.Warning);
this.txtPwd.Text="";
this.txtPwd.Focus();
return false;
}
else
{
conn.Close();
return true;
}
}
}
}
// public bool login()
// {
// SqlConnection conn=new SqlConnection("server=.;database=DBApp;Trusted_Connection=true;");
//
// SqlCommand cmd=new SqlCommand("select count(*) from 用戶清單 where 姓名=@Name and 密碼=@Password",conn);
// // try
// // {
// SqlParameter para;
//
// para = new SqlParameter("@Name",SqlDbType.VarChar,50);
// para.Value = this.txtName.Text;
// cmd.Parameters.Add(para);
//
// para = new SqlParameter("@Password",SqlDbType.VarChar,50);
// para.Value = this.txtPassword.Text;
// cmd.Parameters.Add(para);
//
// conn.Open();
// int input = Convert.ToInt32(cmd.ExecuteScalar());
//
// cmd.Parameters.Clear();
//
// if(input== 0)
// {
// MessageBox.Show("ssss");
// conn.Close();
// return false;
//
//
// }
// else
// {
// MessageBox.Show("服務器拒絕登錄!!!","錯誤提示");
// conn.Close();
// return true;
//
// }
// // }
// // catch
// // {
// // MessageBox.Show("請檢查你的輸入是否正確!!!","錯誤提示");
// //
// // }
// }
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -