private void btnLogin_Click(object sender, EventArgs e)
{
string name = textName.Text;
string pwd = textPwd.Text;
int type;
ManagerInfoBll bll = new ManagerInfoBll();
LoginState login = bll.Login(name, pwd, out type);
switch (login)
{
case LoginState.Ok:
FormMain main = new FormMain();
main.Tag = type;
//将登录窗体隐藏
this.Hide();
main.Show();
break;
case LoginState.NameError:
MessageBox.Show("名字错误");
break;
case LoginState.PwdError:
MessageBox.Show("密码错误");
break;
}
}
private void btnLogin_Click(object sender, EventArgs e)
{
//获取用户输入的信息
string name = txtName.Text;
string pwd = txtPwd.Text;
//调用代码
int type;
ManagerInfoBll miBll = new ManagerInfoBll();
LoginState loginState = miBll.Login(name, pwd, out type);
switch (loginState)
{
case LoginState.Ok:
FormMain main = new FormMain();
main.Tag = type; //将员工级别传递过去
main.Show();
//将登录窗体隐藏
this.Hide();
break;
case LoginState.NameError:
MessageBox.Show("用户名错误");
break;
case LoginState.PwdError:
MessageBox.Show("密码错误");
break;
}
}
private void btnLoad_Click(object sender, EventArgs e)
{
try
{
ManagerInfo mi = new ManagerInfo();
mi.MName = txtUser.Text;
mi.MPwd = txtPwd.Text;
ManagerInfoBll miBll = new ManagerInfoBll();
if (miBll.Load(mi))
{
string overdatestr = ConfigurationManager.ConnectionStrings["date"].ConnectionString;
DateTime overdate = Convert.ToDateTime(overdatestr);
if (DateTime.Now.Date < overdate.Date)
{
Mainform mainform = new Mainform();
mainform.Tag = mi.MType;
mainform.Show();
this.Visible = false;
}
else
{
MessageBox.Show("系统文件缺失，请联系开发人员QQ：1517680389");
}
}
else
{
MessageBox.Show("用户名或密码错误");
}
}
catch
{
MessageBox.Show("数据库连接错误，请联系小雨QQ：1517680389");
}
}
private void BtnLogin_Click(object sender, EventArgs e)
{
string name = textUsername.Text;
string pwd = textPassword.Text;
int type;
ManagerInfoBll miBll = new ManagerInfoBll();
LoginState loginState = miBll.Login(name, pwd, out type);
switch (loginState)
{
case LoginState.Ok:
FormMain main = new FormMain();
main.Tag = type;
main.Show();
main.Focus();
this.Hide();
break;
case LoginState.NameError:
MessageBox.Show("User name error");
break;
case LoginState.PwdError:
MessageBox.Show("Password error");
break;
}
}
private void btnLogin_Click(object sender, EventArgs e)
{
string name = txtName.Text;
string pwd = txtPwd.Text;
ManagerInfoBll miBll = new ManagerInfoBll();
int type;
LoginState state = miBll.Login(name, pwd, out type);
switch (state)
{
case LoginState.Ok:
MainFrm mainFrm = new MainFrm();
mainFrm.Tag = type;
mainFrm.Show();
this.Visible = false;
break;
case LoginState.NameError:
MessageBox.Show("用户名错误");
break;
case LoginState.PwdError:
MessageBox.Show("密码错误");
break;
default:
break;
}
}
//显示数据
private void LoadList()
{
ManagerInfoBll bll = new ManagerInfoBll();
//禁用列的自动生成
dgvList.AutoGenerateColumns = false;
dgvList.DataSource = bll.GetList();
}
private void btnExcelExport_Click(object sender, EventArgs e)
{
ManagerInfoBll miBll = new ManagerInfoBll();
var list = miBll.GetList();
dataGridView1.DataSource = list;
//创建Excel工作薄
XSSFWorkbook workbook = new XSSFWorkbook();
//创建单元格样式
ICellStyle cellTitleStyle = workbook.CreateCellStyle();
//设置单元格居中显示
cellTitleStyle.Alignment = NPOI.SS.UserModel.HorizontalAlignment.Center;
//创建字体
IFont font = workbook.CreateFont();
//设置字体加粗显示
font.IsBold = true;
cellTitleStyle.SetFont(font);
//创建Excel工作表
ISheet sheet = workbook.CreateSheet("管理员");
//创建Excel行
IRow row = sheet.CreateRow(0);
//创建Excel单元格
NPOI.SS.UserModel.ICell cell = row.CreateCell(0);
//设置单元格值
cell.SetCellValue("管理员管理");
//设置单元格合并
sheet.AddMergedRegion(new NPOI.SS.Util.CellRangeAddress(0, 0, 0, 3));
cell.CellStyle = cellTitleStyle;
for (int i = 0; i < list.Count; i++)
{
IRow rowDate = sheet.CreateRow(i + 1);
Type t = list[i].GetType();
int count = 0;
foreach (PropertyInfo pi in t.GetProperties())
{
object value = pi.GetValue(list[i]);
string name = pi.Name;
NPOI.SS.UserModel.ICell cellDate = rowDate.CreateCell(count);
if (i == 0)
{
cellDate.SetCellValue(name);
}
else
{
cellDate.SetCellValue(value.ToString());
}
sheet.AutoSizeColumn(count);
count++;
}
}
using (FileStream fs = new FileStream(@"C:\Users\Saber\Desktop\Demo.xlsx", FileMode.OpenOrCreate))
{
workbook.Write(fs);
}
}
/// <summary>
/// 登录验证
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button_登录_Click(object sender, EventArgs e)
{
if (pwdnum < 2)
{
if (textBox_用户名.Text != "" && textBox_密码.Text != "")
{
#region 查询并验证
ManagerInfoBll MIBll = new ManagerInfoBll();
int type;
int num = MIBll.GetRowInfo(textBox_用户名.Text, textBox_密码.Text, out type);
switch (num)
{
case 0:
MessageBox.Show("账号不正确,请确认账号后再重新输入");
break;
case 1:
//这里设置登录窗口隐藏,打开新的窗体
主界面 fm = new 主界面();
fm.Tag = type;
fm.Show();
this.Hide();
break;
case 2:
MessageBox.Show("密码错误");
label_密码错误提示.Text = string.Format("密码错误,还剩余{0}次", (2 - pwdnum));
pwdnum = pwdnum + 1;
break;
}
;
#endregion
}
else
{
MessageBox.Show("用户名和密码不能为空");
}
}
else
{
MessageBox.Show("错误次数太多,程序关闭");
Application.Exit();
}
}
private void btnSave_Click(object sender, EventArgs e)
{
ManagerInfo manager = new ManagerInfo()
{
//MId=Convert.ToInt32(txtId.Text),
MName = txtName.Text,
MPwd = txtPwd.Text,
MType = rb1.Checked ? 1 : 0
};
ManagerInfoBll bll = new ManagerInfoBll();
if (btnSave.Text == "添加")
{
if (bll.Insert(manager))
{
LoadList();
//MessageBox.Show("添加成功");
}
else
{
MessageBox.Show("添加失败");
}
}
else
{
manager.MId = Convert.ToInt32(txtId.Text);
if (bll.Update(manager))
{
LoadList();
//MessageBox.Show("添加成功");
}
else
{
MessageBox.Show("修改失败");
}
}
txtId.Text = "添加时无编号";
txtName.Text = "";
txtPwd.Text = "";
rb2.Checked = true;
btnSave.Text = "添加";
}
private void button1_Click(object sender, EventArgs e)
{
ManagerInfo mi = new ManagerInfo();
mi.MName = textBox1.Text;
mi.MPwd = textBox2.Text;
ManagerInfoBll miBll = new ManagerInfoBll();
if (miBll.Login(mi))
{
MainForm mainForm = new MainForm();
mainForm.Tag = mi.MType;
mainForm.Show();
this.Visible = false;
}
else
{
MessageBox.Show("用户名或密码错误！！！");
}
}
private void btnLogin_Click(object sender, EventArgs e)
{
var mi = new ManagerInfo();
mi.MName = txtName.Text;
mi.MPwd = txtPwd.Text;
var miBll = new ManagerInfoBll();
if (miBll.Login(mi))
{
var mainForm = new MainForm();
mainForm.Tag = mi.MType.ToString();
mainForm.Show();
Visible = false;
}
else
{
MessageBox.Show("用户名或者密码错误");
}
}
private void btnRemove_Click(object sender, EventArgs e)
{
var rows = dgvList.SelectedRows;
if (rows.Count > 0)
{
DialogResult result = MessageBox.Show("确定要删除吗？", "提示", MessageBoxButtons.OKCancel);
if (result == DialogResult.Cancel)
{
return;
}
string id = rows[0].Cells[0].Value.ToString();
ManagerInfoBll bll = new ManagerInfoBll();
if (bll.Delete(id))
{
LoadList();
}
}
else
{
MessageBox.Show("请选择一行数据");
}
}
private void button1_Click(object sender, EventArgs e)
{
ManagerInfoBll bll = new ManagerInfoBll();
int type;
ManagerStute stute = bll.Login(textBox1.Text, textBox2.Text, out type);
switch (stute)
{
case ManagerStute.OK:
FormMain main = new FormMain();
main.Tag = type;
main.Show();
this.Hide();
break;
case ManagerStute.NAMEERROR:
MessageBox.Show("用户名错误");
break;
case ManagerStute.PWDERROR:
MessageBox.Show("密码错误");
break;
}
}
private void button1_Click(object sender, EventArgs e)
{
//查询数据，显示到表格上
ManagerInfoBll miBll = new ManagerInfoBll();
var list = miBll.GetList();
dataGridView1.DataSource = list;
//进行excel生成创建操作
//1、创建workbook,不指定参数，表示创建一个新的工作本
HSSFWorkbook workbook = new HSSFWorkbook();
//2、创建sheet
HSSFSheet sheet = workbook.CreateSheet("管理员");
//3、创建row
HSSFRow row = sheet.CreateRow(0);
//4、创建cell
HSSFCell cell0 = row.CreateCell(0);
cell0.SetCellValue("管理员列表");
//5、设置合并单元格
sheet.AddMergedRegion(new NPOI.HSSF.Util.Region(0, 0, 0, 3));
//6、设置单元格居中
HSSFCellStyle styleTitle = workbook.CreateCellStyle();
styleTitle.Alignment = 2;//居中
cell0.CellStyle = styleTitle;
//6.1设置字体
HSSFFont fontTitle = workbook.CreateFont();
fontTitle.FontHeightInPoints = 14;
styleTitle.SetFont(fontTitle);
//7、创建标题行
//7.1创建行
HSSFRow rowTitle = sheet.CreateRow(1);
//7.2创建单元格
HSSFCell cellTitle0 = rowTitle.CreateCell(0);
cellTitle0.SetCellValue("编号");
cellTitle0.CellStyle = styleTitle;
HSSFCell cellTitle1 = rowTitle.CreateCell(1);
cellTitle1.SetCellValue("姓名");
cellTitle1.CellStyle = styleTitle;
HSSFCell cellTitle2 = rowTitle.CreateCell(2);
cellTitle2.SetCellValue("密码");
cellTitle2.CellStyle = styleTitle;
HSSFCell cellTitle3 = rowTitle.CreateCell(3);
cellTitle3.SetCellValue("类型");
cellTitle3.CellStyle = styleTitle;
//8、遍历集合，创建正文数据
//8.1遍历集合
int rowIndex = 2;
foreach (var mi in list)
{
//8.2创建行
HSSFRow rowData = sheet.CreateRow(rowIndex++);
//8.3创建数据单元格
HSSFCell cellData0 = rowData.CreateCell(0);
cellData0.SetCellValue(mi.MId);
HSSFCell cellData1 = rowData.CreateCell(1);
cellData1.SetCellValue(mi.MName);
HSSFCell cellData2 = rowData.CreateCell(2);
cellData2.SetCellValue(mi.MPwd);
HSSFCell cellData3 = rowData.CreateCell(3);
cellData3.SetCellValue(mi.MType == 1?"经理":"店员");
}
//保存工作本
FileStream stream = new FileStream(@"C:\Users\q1\Desktop\t1.xls", FileMode.Create);
workbook.Write(stream);
stream.Close();
stream.Dispose();
}
private void button1_Click(object sender, EventArgs e)
{
//导出：将数据库中的数据，存储到一个Excel中
//1、查询数据
ManagerInfoBll miBll = new ManagerInfoBll();
var list = miBll.GetList();
//2、生成Excel
//2.1 生成workbook
//2.2 生成sheet
//2.3 遍历集合，生成行
//2.4 根据对象生成单元格
//创建工作本
HSSFWorkbook workbook = new HSSFWorkbook();
//创建工作表
HSSFSheet sheet = (HSSFSheet)workbook.CreateSheet("管理员");
//创建标题行
HSSFRow row = (HSSFRow)sheet.CreateRow(0);
//样式操作
ICellStyle style = workbook.CreateCellStyle();
style.Alignment = NPOI.SS.UserModel.HorizontalAlignment.CENTER;
//设置字体
var font = workbook.CreateFont();
font.FontHeightInPoints = 16;
font.Boldweight = 1;
style.SetFont(font);
//创建单元格
HSSFCell cellId = (HSSFCell)row.CreateCell(0);
cellId.CellStyle = style;
cellId.SetCellValue("编号");
HSSFCell cellName = (HSSFCell)row.CreateCell(1);
cellName.SetCellValue("用户名");
cellName.CellStyle = style;
HSSFCell cellPwd = (HSSFCell)row.CreateCell(2);
cellPwd.SetCellValue("密码");
cellPwd.CellStyle = style;
HSSFCell cellType = (HSSFCell)row.CreateCell(3);
cellType.SetCellValue("类型");
cellType.CellStyle = style;
//遍历集合，生成行
int index = 1;
foreach (var item in list)
{
var row1 = sheet.CreateRow(index++);
var cell0 = row1.CreateCell(0);
cell0.SetCellValue(item.MId);
var cell1 = row1.CreateCell(1);
cell1.SetCellValue(item.MName);
var cell2 = row1.CreateCell(2);
cell2.SetCellValue(item.MPwd);
var cell3 = row1.CreateCell(3);
cell3.SetCellValue(item.MType == 0 ? "店员" : "经理");
}
FileStream file = new FileStream(@"D:\database\a.xls", FileMode.Create, FileAccess.Write);
workbook.Write(file);
file.Dispose();
MessageBox.Show("OK");
}
