新手求注释,要详细,本人菜鸟
RT 各位高手速度哈 急~~~~~~
- C# code
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 jinxiaocun{ public partial class frmWindows_login : Form { int nCount = 0; public static string strLogin = ""; public static string strPwd = ""; public static int nXuanzhong = 0; string strSQL; public static int nsystem; public static int ncustormer; public static int nsupplie; public static int nstockmanage; public static int nsellmanage; public static int nreservemanage; public frmWindows_login() { InitializeComponent(); } private void frmWindows_login_Load(object sender, EventArgs e) { } private void btnDenglu_Click(object sender, EventArgs e) { strLogin = txtLogin.Text;//获取用户名的文本信息 strPwd = txtPwd.Text; //用户名和密码不能为空 if (strLogin == "" || strPwd == "") //||表示或者 { MessageBox.Show("用户名和密码不能为空"); return;//程序不再往后执行 } if (strLogin.IndexOf("'") >= 0) { MessageBox.Show("密码中不能含有'"); return; } if (rdbgly.Checked == true) { string strCountsql = "select count(*) from logintable where login='" + strLogin + "'"; int nCountresult = Convert.ToInt32(ConglyClass.returnStringSql(strCountsql)); if (nCountresult != 1){MessageBox.Show("你不是管理员/员工,无法登录!"); return;} nXuanzhong=1; } else if (rdbkehu.Checked == true) { string strCountsql = "select count(*) from custormer where Clogin='" + strLogin + "'"; int nCountresult = Convert.ToInt32(ConglyClass.returnStringSql(strCountsql)); if (nCountresult != 1){MessageBox.Show("你不是客户,无法登录!"); return;} nXuanzhong=2; } else { MessageBox.Show("请选择身份,再登录!"); return;} if(nXuanzhong==1){ strSQL = "select password from logintable where login='" + strLogin + "'"; }else{ strSQL = "select CPassword from custormer where CLogin='" + strLogin + "'"; } string strPwd2 = ConglyClass.returnStringSql(strSQL); if (strPwd == strPwd2)//判断密码是对的 { this.Hide(); if (nXuanzhong == 1) { string strsqlcount = "select COUNT(*) from limits_authority where [login]='" + strLogin + "'"; if (Convert.ToInt32(ConglyClass.returnStringSql(strsqlcount)) == 1) { string strsql = "SELECT system,custormer,supplie,stockmanage,sellmanage,reservemanage FROM limits_authority where [login]='"+strLogin+"'"; SqlDataReader sdrread = ConglyClass.getSqlDataReader(strsql); sdrread.Read(); nsystem = Convert.ToInt32(sdrread["system"]); ncustormer = Convert.ToInt32(sdrread["custormer"]); nsupplie=Convert.ToInt32(sdrread["supplie"]); nstockmanage=Convert.ToInt32(sdrread["stockmanage"]); nsellmanage=Convert.ToInt32(sdrread["sellmanage"]); nreservemanage=Convert.ToInt32(sdrread["reservemanage"]); } else { nsystem = 0; ncustormer = 0; nsupplie = 0; nstockmanage = 0; nsellmanage = 0; nreservemanage = 0; } frmSystem_interface frm = new frmSystem_interface(); frm.ShowDialog(); } if (frmChange_Password.nUpdate == 2) { this.Show(); txtPwd.Text = ""; frmChange_Password.nUpdate = 1; } else { this.Close(); } } else { //增加第一个功能:错误超过三次,则系统关闭,提示使用变量nCount nCount++;//值自动加1 MessageBox.Show("密码输入错误!", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Warning); if (nCount >= 3) this.Close(); } } private void btnRegister_Click(object sender, EventArgs e) { frmWindows_register frm2 = new frmWindows_register(); frm2.ShowDialog(); if (frmWindows_register.nRegister_status == 1) { txtLogin.Text = frmWindows_register.strLogin; txtPwd.Text = "";} } private void rdbkehu_CheckedChanged(object sender, EventArgs e) { } private void rdbgly_CheckedChanged(object sender, EventArgs e) { } }}//员工基本信息维护和客户资料管理
[解决办法]
友情接分 上面都注释得很多了
[解决办法]
貌似没有什么好解释的
[解决办法]
- C# code
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 jinxiaocun{ public partial class frmWindows_login : Form { int nCount = 0; public static string strLogin = "";//存储用户登录名 public static string strPwd = ""; //存储用户密码 public static int nXuanzhong = 0;//选中标记 string strSQL; public static int nsystem; public static int ncustormer; public static int nsupplie; public static int nstockmanage; public static int nsellmanage; public static int nreservemanage; public frmWindows_login() { InitializeComponent(); } private void frmWindows_login_Load(object sender, EventArgs e) { } private void btnDenglu_Click(object sender, EventArgs e)//登录按钮 { strLogin = txtLogin.Text;//获取用户名的文本信息 strPwd = txtPwd.Text; //用户名和密码不能为空 if (strLogin == "" || strPwd == "") //||表示或者 { MessageBox.Show("用户名和密码不能为空"); return;//程序不再往后执行 } if (strLogin.IndexOf("'") >= 0)//strLogin用户名中是否存在逗号,存在直接return { MessageBox.Show("密码中不能含有'"); return; } //选中Checkbox,管理员登陆的。估计是指定管理员用户类型的 if (rdbgly.Checked == true) { string strCountsql = "select count(*) from logintable where login='" + strLogin + "'";//定义sql语句,数据库中查找存在用户名和密码的数据条数 int nCountresult = Convert.ToInt32(ConglyClass.returnStringSql(strCountsql));//返回数据库查找结果,条数赋给nCountresult if (nCountresult != 1){MessageBox.Show("你不是管理员/员工,无法登录!"); return;} nXuanzhong=1;//管理员登陆标记设置为1 } else if (rdbkehu.Checked == true)//选择客户登陆,指定客户类型的 { string strCountsql = "select count(*) from custormer where Clogin='" + strLogin + "'"; int nCountresult = Convert.ToInt32(ConglyClass.returnStringSql(strCountsql)); if (nCountresult != 1){MessageBox.Show("你不是客户,无法登录!"); return;} nXuanzhong=2;//客户登陆标记设置为2 } else { MessageBox.Show("请选择身份,再登录!"); return;} if(nXuanzhong==1){ strSQL = "select password from logintable where login='" + strLogin + "'";//查询密码 }else{ strSQL = "select CPassword from custormer where CLogin='" + strLogin + "'"; } string strPwd2 = ConglyClass.returnStringSql(strSQL); if (strPwd == strPwd2)//判断密码是对的 { this.Hide();//隐藏窗体,估计是登陆窗体吧 if (nXuanzhong == 1) { string strsqlcount = "select COUNT(*) from limits_authority where [login]='" + strLogin + "'"; if (Convert.ToInt32(ConglyClass.returnStringSql(strsqlcount)) == 1)//如果从数据库找到一条数据 { string strsql = "SELECT system,custormer,supplie,stockmanage,sellmanage,reservemanage FROM limits_authority where [login]='"+strLogin+"'"; SqlDataReader sdrread = ConglyClass.getSqlDataReader(strsql); sdrread.Read();//读取数据,分别付给下面变量 nsystem = Convert.ToInt32(sdrread["system"]); ncustormer = Convert.ToInt32(sdrread["custormer"]); nsupplie=Convert.ToInt32(sdrread["supplie"]); nstockmanage=Convert.ToInt32(sdrread["stockmanage"]); nsellmanage=Convert.ToInt32(sdrread["sellmanage"]); nreservemanage=Convert.ToInt32(sdrread["reservemanage"]); } else {//没找到设置默认值,都设置为0 nsystem = 0; ncustormer = 0; nsupplie = 0; nstockmanage = 0; nsellmanage = 0; nreservemanage = 0; } frmSystem_interface frm = new frmSystem_interface();//显示frmSystem_interface窗体 frm.ShowDialog(); } if (frmChange_Password.nUpdate == 2) { this.Show(); txtPwd.Text = ""; frmChange_Password.nUpdate = 1; } else { this.Close(); } } else { //增加第一个功能:错误超过三次,则系统关闭,提示使用变量nCount nCount++;//值自动加1 MessageBox.Show("密码输入错误!", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Warning); if (nCount >= 3) this.Close(); } } //注册按钮事件 private void btnRegister_Click(object sender, EventArgs e) { frmWindows_register frm2 = new frmWindows_register(); frm2.ShowDialog(); if (frmWindows_register.nRegister_status == 1) { txtLogin.Text = frmWindows_register.strLogin; txtPwd.Text = "";} } private void rdbkehu_CheckedChanged(object sender, EventArgs e) { } private void rdbgly_CheckedChanged(object sender, EventArgs e) { } }}//员工基本信息维护和客户资料管理
[解决办法]
- C# code
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 jinxiaocun{ public partial class frmWindows_login : Form { int nCount = 0; public static string strLogin = ""; public static string strPwd = ""; public static int nXuanzhong = 0; string strSQL; public static int nsystem; public static int ncustormer; public static int nsupplie; public static int nstockmanage; public static int nsellmanage; public static int nreservemanage; //------------这上面全是变量的声明 public frmWindows_login() { InitializeComponent(); } private void frmWindows_login_Load(object sender, EventArgs e) { } private void btnDenglu_Click(object sender, EventArgs e) { strLogin = txtLogin.Text;//获取用户名的文本信息 strPwd = txtPwd.Text; //密码框的信息 //用户名和密码不能为空 if (strLogin == "" || strPwd == "") //||表示或者 { MessageBox.Show("用户名和密码不能为空"); return;//程序不再往后执行 } if (strLogin.IndexOf("'") >= 0) { MessageBox.Show("密码中不能含有'"); return; } if (rdbgly.Checked == true) { string strCountsql = "select count(*) from logintable where login='" + strLogin + "'"; int nCountresult = Convert.ToInt32(ConglyClass.returnStringSql(strCountsql)); if (nCountresult != 1){MessageBox.Show("你不是管理员/员工,无法登录!"); return;} nXuanzhong=1; //如查XX选中,通过用声明到数据库里查一下,如果有,nXuanzhong变量赋1,否则return } else if (rdbkehu.Checked == true) { string strCountsql = "select count(*) from custormer where Clogin='" + strLogin + "'"; int nCountresult = Convert.ToInt32(ConglyClass.returnStringSql(strCountsql)); if (nCountresult != 1){MessageBox.Show("你不是客户,无法登录!"); return;} nXuanzhong=2; //这是和上面一个意思 } else { MessageBox.Show("请选择身份,再登录!"); return;} if(nXuanzhong==1){ strSQL = "select password from logintable where login='" + strLogin + "'"; }else{ strSQL = "select CPassword from custormer where CLogin='" + strLogin + "'"; } string strPwd2 = ConglyClass.returnStringSql(strSQL); //上面是通过用户名查密码 if (strPwd == strPwd2)//判断密码是对的 { this.Hide(); if (nXuanzhong == 1) { string strsqlcount = "select COUNT(*) from limits_authority where [login]='" + strLogin + "'"; if (Convert.ToInt32(ConglyClass.returnStringSql(strsqlcount)) == 1) { string strsql = "SELECT system,custormer,supplie,stockmanage,sellmanage,reservemanage FROM limits_authority where [login]='"+strLogin+"'"; SqlDataReader sdrread = ConglyClass.getSqlDataReader(strsql); sdrread.Read(); nsystem = Convert.ToInt32(sdrread["system"]); ncustormer = Convert.ToInt32(sdrread["custormer"]); nsupplie=Convert.ToInt32(sdrread["supplie"]); nstockmanage=Convert.ToInt32(sdrread["stockmanage"]); nsellmanage=Convert.ToInt32(sdrread["sellmanage"]); nreservemanage=Convert.ToInt32(sdrread["reservemanage"]); // } else { nsystem = 0; ncustormer = 0; nsupplie = 0; nstockmanage = 0; nsellmanage = 0; nreservemanage = 0; } frmSystem_interface frm = new frmSystem_interface(); frm.ShowDialog(); } if (frmChange_Password.nUpdate == 2) { this.Show(); txtPwd.Text = ""; frmChange_Password.nUpdate = 1; } else { this.Close(); } } else { //增加第一个功能:错误超过三次,则系统关闭,提示使用变量nCount nCount++;//值自动加1 MessageBox.Show("密码输入错误!", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Warning); if (nCount >= 3) this.Close(); } } private void btnRegister_Click(object sender, EventArgs e) { frmWindows_register frm2 = new frmWindows_register(); frm2.ShowDialog(); if (frmWindows_register.nRegister_status == 1) { txtLogin.Text = frmWindows_register.strLogin; txtPwd.Text = "";} } private void rdbkehu_CheckedChanged(object sender, EventArgs e) { } private void rdbgly_CheckedChanged(object sender, EventArgs e) { } }}//员工基本信息维护和客户资料管理
[解决办法]
if (strPwd == strPwd2)//判断密码是对的
{
this.Hide();//隐藏窗体,估计是登陆窗体吧
if (nXuanzhong == 1) {
string strsqlcount = "select COUNT(*) from limits_authority where [login]='" + strLogin + "'";
if (Convert.ToInt32(ConglyClass.returnStringSql(strsqlcount)) == 1)//如果从数据库找到一条数据
{
string strsql = "SELECT system,custormer,supplie,stockmanage,sellmanage,reservemanage FROM limits_authority where [login]='"+strLogin+"'";
SqlDataReader sdrread = ConglyClass.getSqlDataReader(strsql);
sdrread.Read();//读取数据,分别付给下面变量
nsystem = Convert.ToInt32(sdrread["system"]);
ncustormer = Convert.ToInt32(sdrread["custormer"]);
nsupplie=Convert.ToInt32(sdrread["supplie"]);
nstockmanage=Convert.ToInt32(sdrread["stockmanage"]);
nsellmanage=Convert.ToInt32(sdrread["sellmanage"]);
nreservemanage=Convert.ToInt32(sdrread["reservemanage"]);
}
else {//没找到设置默认值,都设置为0
nsystem = 0;
ncustormer = 0;
nsupplie = 0;
nstockmanage = 0;
nsellmanage = 0;
nreservemanage = 0;
}
frmSystem_interface frm = new frmSystem_interface();//显示frmSystem_interface窗体
frm.ShowDialog();
}
不知道frmSystem_interface是不是