• 大小: 4.05MB
    文件类型: .zip
    金币: 1
    下载: 0 次
    发布日期: 2023-10-28
  • 语言: C#
  • 标签: C#  sql2008  数据库  

资源简介

使用C# + sql server 2008 实现,包含完整代码以及数据库,还有使用说明文档

资源截图

代码片段和文件信息

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace PWMS
{
    public partial class F_Login : Form
    {
        DataClass.MyMeans MyClass = new PWMS.DataClass.MyMeans();
        
        public F_Login()
        {
            InitializeComponent();
        }

        private void butClose_Click(object sender EventArgs e)
        {
            if ((int)(this.Tag) == 1)
            {
                DataClass.MyMeans.Login_n = 3;
                Application.Exit();
            }
            else
                if ((int)(this.Tag) == 2)
                    this.Close();
        }

        private void butLogin_Click(object sender EventArgs e)
        {
            if (textName.Text != ““ & textPass.Text != ““)
            {
                SqlDataReader temDR = MyClass.getcom(“select * from tb_Login where Name=‘“ + textName.Text.Trim() + “‘ and Pass=‘“ + textPass.Text.Trim() + “‘“);
                bool ifcom = temDR.Read();
                if (ifcom)
                {
                    DataClass.MyMeans.Login_Name = textName.Text.Trim();
                    DataClass.MyMeans.Login_ID = temDR.GetString(0);
                    DataClass.MyMeans.My_con.Close();
                    DataClass.MyMeans.My_con.Dispose();
                    DataClass.MyMeans.Login_n = (int)(this.Tag);
                    this.Close();
                }
                else
                {
                    MessageBox.Show(“用户名或密码错误!“ “提示“ MessageBoxButtons.OK MessageBoxIcon.Information);
                    textName.Text = ““;
                    textPass.Text = ““;
                }
                MyClass.con_close();
            }
            else
                MessageBox.Show(“请将登录信息添写完整!“ “提示“ MessageBoxButtons.OK MessageBoxIcon.Information);
        }

        private void F_Login_Load(object sender EventArgs e)
        {
            try
            {
                MyClass.con_open();  //连接数据库
                MyClass.con_close();
                textName.Text = ““;
                textPass.Text = ““;

            }
            catch
            {
                MessageBox.Show(“数据库连接失败。“ “提示“ MessageBoxButtons.OK MessageBoxIcon.Information);
                Application.Exit();
            }
        }

        private void textName_KeyPress(object sender KeyPressEventArgs e)
        {
            if (e.KeyChar == ‘\r‘)
                textPass.Focus();
        }

        private void textPass_KeyPress(object sender KeyPressEventArgs e)
        {
            if (e.KeyChar == ‘\r‘)
                butLogin.Focus();
        }

        private void F_Login_Activated(object sender EventArgs e)
        {
            textName.Focus();
        }

    }
}

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----
     目录           0  2015-04-27 19:06  07\
     目录           0  2015-04-27 19:16  07\PWMS\
     目录           0  2015-04-27 19:06  07\PWMS\PWMS\
     目录           0  2015-04-27 19:06  07\PWMS\PWMS\Database\
     文件     5242880  2013-01-07 13:57  07\PWMS\PWMS\Database\db_PWMS.mdf
     文件     1835008  2013-01-07 13:57  07\PWMS\PWMS\Database\db_PWMS_log.ldf
     目录           0  2015-04-27 19:06  07\PWMS\PWMS\DataClass\
     文件        4319  2010-08-11 09:32  07\PWMS\PWMS\DataClass\MyMeans.cs
     文件        6856  2007-12-06 10:24  07\PWMS\PWMS\F_Login.Designer.cs
     文件        2986  2007-12-15 14:40  07\PWMS\PWMS\F_Login.cs
     文件      341697  2007-12-06 10:24  07\PWMS\PWMS\F_Login.resx
     文件       38155  2007-12-15 13:27  07\PWMS\PWMS\F_Main.Designer.cs
     文件        7044  2007-12-15 13:27  07\PWMS\PWMS\F_Main.cs
     文件     1001411  2007-12-15 13:27  07\PWMS\PWMS\F_Main.resx
     目录           0  2015-04-27 19:06  07\PWMS\PWMS\Image\
     文件        2906  2007-12-05 09:05  07\PWMS\PWMS\Image\01.png
     文件        3071  2007-12-05 09:10  07\PWMS\PWMS\Image\02.PNG
     文件        3242  2007-12-05 09:11  07\PWMS\PWMS\Image\03.PNG
     文件        2897  2007-12-05 09:11  07\PWMS\PWMS\Image\04.PNG
     文件        3096  2007-12-05 09:11  07\PWMS\PWMS\Image\05.PNG
     文件        3526  2007-12-05 09:12  07\PWMS\PWMS\Image\06.PNG
     文件        2933  2007-12-05 09:13  07\PWMS\PWMS\Image\07.PNG
     文件        3636  2007-12-05 09:14  07\PWMS\PWMS\Image\08.PNG
     文件        3033  2007-12-05 09:14  07\PWMS\PWMS\Image\09.PNG
     文件       29776  2007-12-11 22:05  07\PWMS\PWMS\Image\PEOPLE.jpg
     文件      659936  2007-12-04 17:04  07\PWMS\PWMS\Image\主界面.bmp
     文件        6480  2007-12-04 17:15  07\PWMS\PWMS\Image\人事档案浏览.bmp
     文件        6480  2007-12-04 17:07  07\PWMS\PWMS\Image\人事资料查询.BMP
     文件        3312  2007-12-04 16:59  07\PWMS\PWMS\Image\修改.BMP
     文件        3312  2007-12-04 17:00  07\PWMS\PWMS\Image\关闭.BMP
     文件        3312  2007-12-04 17:00  07\PWMS\PWMS\Image\删除.BMP
............此处省略108个文件信息

评论

共有 条评论