//判断登录
tb_EmpInfo EmpClass = new tb_EmpInfo();//对象
tb_EmpInfoMenthod tbMenthod = new tb_EmpInfoMenthod();
public static int intFalg = 0;//控件方法状态
int G_Int_status; //保存工具栏按钮操作状态
public int getPan()
{
int intFalg1 = 0;
if (intFalg != 3)
{
if (txtEmpName.Text == "")
{
MessageBox.Show("员工姓名不能为空!", "提示");
txtEmpName.Focus();
return intFalg1;
}
if (txtEmpLoginName.Text == "")
{
MessageBox.Show("登录名称不能为空!", "提示");
return intFalg1;
}
if (intFalg != 2)
{
if (txtEmpLoginPwd.Text == "")
{
MessageBox.Show("登录密码不能为空!", "提示");
return intFalg1;
}
}
if (intFalg == 2)
{
EmpClass.intEmpId = this.dataGridView1[0, this.dataGridView1.CurrentCell.RowIndex].Value.ToString();
}
else
{
EmpClass.intEmpId = tbMenthod.tb_EmpInfoID();
}
}
else
{
if (txtEmpName.Text == "")
{
MessageBox.Show("请在下面选择要删除的记录", "提示");
return intFalg1;
}
else
{
EmpClass.intEmpId = this.dataGridView1[0, this.dataGridView1.CurrentCell.RowIndex].Value.ToString();
EmpClass.intEmpId = this.dataGridView1[0, this.dataGridView1.CurrentCell.RowIndex].Value.ToString();
}
}
EmpClass.strEmpName = txtEmpName.Text;
EmpClass.strEmpLoginName = txtEmpLoginName.Text;
EmpClass.strEmpLoginPwd = txtEmpLoginPwd.Text;
EmpClass.intEmpSex = comboBox2.Text;
EmpClass.daEmpBirthday = daEmpBirthday.Value;
EmpClass.strEmpDept = cmbEmpDept.Text;
EmpClass.strEmpPost = cmbEmpPost.Text;
EmpClass.strEmpPhone = txtEmpPhone.Text;
EmpClass.strEmpPhoneM = txtEmpPhoneM.Text;
EmpClass.strEmpAddress = txtEmpAddress.Text;
if(intFalg!=3)
{
EmpClass.intEmpFalg = 0;
}else
{
EmpClass.intEmpFalg = 1;
}
intFalg1 = 1;
return intFalg1;}
private void ControlStatus()
{
this.toolSave.Enabled = !this.toolSave.Enabled;
this.toolAdd.Enabled = !this.toolAdd.Enabled;
this.toolCancel.Enabled = !this.toolCancel.Enabled;
this.toolAmend.Enabled = !this.toolAmend.Enabled;
this.toolDelete.Enabled = !this.toolDelete.Enabled;
}
/// <summary>
/// 将控件恢复到原始状态
/// </summary>
private void ClearControls()
{
txtEmpAddress.Text = "";
txtEmpLoginName.Text = "";
txtEmpLoginPwd.Text = "";
txtEmpName.Text = "";
txtEmpPhone.Text = "";
txtEmpPhoneM.Text = "";
cmbEmpDept.SelectedIndex = 0;
cmbEmpPost.SelectedIndex = 0;
comboBox2.SelectedIndex = 0;
this.daEmpBirthday.Value = DateTime.Now;
}
private void frmEmpInfo_Load(object sender, EventArgs e)
{
tbMenthod.tb_EmpInfoFind(" ",5,dataGridView1);
}
private void toolAdd_Click(object sender, EventArgs e)
{
ClearControls();//清空控件内容
ControlStatus();//控件控年状态
intFalg = 1;//添加标
}
private void toolAmend_Click(object sender, EventArgs e)
{
ControlStatus();
intFalg = 2;//修改标记
}
private void toolrefesh_Click(object sender, EventArgs e)
{
ClearControls();//刷新
ControlStatus();
}
private void toolExit_Click(object sender, EventArgs e)
{
this.Close();
}
private void toolDelete_Click(object sender, EventArgs e)
{
ControlStatus();//控件控年状态
intFalg = 3;//删除标记
}
private void txtOK_Click(object sender, EventArgs e)
{
string P_Str_selectcondition = this.cbxCondition.Text;
//Items[this.cbxCondition.SelectedIndex].ToString();
if (P_Str_selectcondition == null)
{
MessageBox.Show("请选择查询条件!");
return;
}
if (this.txtKeyWord.Text == "")
{
MessageBox.Show("输入查询条件!");
return;
}
switch (P_Str_selectcondition)
{
case "员工姓名":
tbMenthod.tb_EmpInfoFind(txtKeyWord.Text,1,dataGridView1);
break;
case "员工性别":
tbMenthod.tb_EmpInfoFind(txtKeyWord.Text, 2, dataGridView1);
break;
case "所属部门":
tbMenthod.tb_EmpInfoFind(txtKeyWord.Text, 3, dataGridView1);
break;
case "员工职位":
tbMenthod.tb_EmpInfoFind(txtKeyWord.Text, 4, dataGridView1);
break;
default:
break;
}
}
private void toolSave_Click(object sender, EventArgs e)
{
if (getPan() == 1)
{
if (intFalg == 1)
{
if (tbMenthod.tb_EmpInfoFind(txtEmpLoginName.Text,"",1) == 1)
{
MessageBox.Show("登录名称已被占用!!");
txtEmpLoginName.Text = "";
txtEmpLoginName.Focus();
return;
}
if (tbMenthod.tb_EmpInfoAdd(EmpClass) == 1)
{
MessageBox.Show("添加成功");
intFalg = 0;
tbMenthod.tb_EmpInfoFind("", 5, dataGridView1);
ClearControls();
ControlStatus();
}
else
{
MessageBox.Show("添加成失败");
intFalg = 0;
//tbMenthod.tb_EmpInfoFind("2",dataGridView1);
ClearControls();
ControlStatus();
}
}
if (intFalg == 2)
{
if (tbMenthod.tb_EmpInfoUpdate(EmpClass)==1)
{
MessageBox.Show("修改成功");
intFalg = 0;
tbMenthod.tb_EmpInfoFind("", 5, dataGridView1);
ClearControls();
ControlStatus();
}
else
{
MessageBox.Show("修改成失败");
intFalg = 0;
//tbMenthod.tb_EmpInfoFind("2",dataGridView1);
ClearControls();
ControlStatus();
}
}
if (intFalg == 3)
{
if (tbMenthod.tb_EmpInfoDelete(EmpClass) == 1)
{
MessageBox.Show("删除成功");
intFalg = 0;
tbMenthod.tb_EmpInfoFind("", 5, dataGridView1);
ClearControls();
ControlStatus();
}
else
{
MessageBox.Show("删除失败");
intFalg = 0;
ClearControls();
ControlStatus();
}
}
}//end}
private void FillControls()
{
try
{
SqlDataReader sqldr = tbMenthod.tb_EmpInfoFind(this.dataGridView1[0, this.dataGridView1.CurrentCell.RowIndex].Value.ToString(),1);
sqldr.Read();
if (sqldr.HasRows)
{
txtEmpLoginName.Text = sqldr[2].ToString();
txtEmpName.Text = sqldr[1].ToString();
comboBox2.Text =sqldr[4].ToString();
daEmpBirthday.Value = Convert.ToDateTime(sqldr[5].ToString());
cmbEmpDept.Text =sqldr[6].ToString();
cmbEmpPost.Text = sqldr[7].ToString();
txtEmpPhone.Text = sqldr[8].ToString();
txtEmpPhoneM.Text = sqldr[9].ToString();
txtEmpAddress.Text = sqldr[10].ToString();
}
}
catch(Exception ee)
{
MessageBox.Show(ee.ToString());
}
}
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (intFalg == 2 || intFalg == 3)
{
FillControls();
}
}
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using xitong.sql;
using xitong.ClassInfo;
using System.Data.SqlClient;
using System.Windows.Forms;
namespace xitong.sql
{
class tb_EmpInfoMenthod
{
SqlConnection conn = null;
SqlCommand cmd = null;
SqlDataReader qlddr = null;
#region 添加
public int tb_EmpInfoAdd(tb_EmpInfo Empinfo)
{
int intFalg = 0;
try
{
string str_Add = "insert into tb_EmpInfo values( ";
str_Add+=" '"+Empinfo.intEmpId+"','"+Empinfo.strEmpName+"','"+Empinfo.strEmpLoginName+"',";
str_Add+=" '"+Empinfo.strEmpLoginPwd+"','"+Empinfo.intEmpSex+"','"+Empinfo.daEmpBirthday+"',";
str_Add+=" '"+Empinfo.strEmpDept+"','"+Empinfo.strEmpPost+"','"+Empinfo.strEmpPhone+"',";
str_Add+=" '"+Empinfo.strEmpPhoneM+"','"+Empinfo.strEmpAddress+"',";
str_Add+=""+Empinfo.intEmpFalg+")";
getsqlconnom getConnection = new getsqlconnom();
conn = getConnection.GetCon();
cmd = new SqlCommand(str_Add,conn);
intFalg = cmd.ExecuteNonQuery();
conn.Dispose();
return intFalg;
}
catch (Exception ee)
{
MessageBox.Show(ee.ToString());
return intFalg;
}
}
#endregion
#region 修改
public int tb_EmpInfoUpdate(tb_EmpInfo Empinfo)
{
int intFalg = 0;
try
{
string str_Update= "update tb_EmpInfo set ";
str_Update += "EmpName='" + Empinfo.strEmpName + "',EmpLoginName='" + Empinfo.strEmpLoginName + "',";
str_Update += "EmpLoginPwd='" + Empinfo.strEmpLoginPwd + "',EmpSex='" + Empinfo.intEmpSex + "',EmpBirthday='" + Empinfo.daEmpBirthday + "',";
str_Update += "EmpDept= '" + Empinfo.strEmpDept + "',EmpPost='" + Empinfo.strEmpPost + "',EmpPhone='" + Empinfo.strEmpPhone + "',";
str_Update += " EmpPhoneM='" + Empinfo.strEmpPhoneM + "',EmpAddress='" + Empinfo.strEmpAddress + "',";
str_Update += "EmpFalg=" + Empinfo.intEmpFalg + " where EmpId='" + Empinfo.intEmpId + "'";
getsqlconnom getConnection = new getsqlconnom();
conn = getConnection.GetCon();
cmd = new SqlCommand(str_Update, conn);
intFalg = cmd.ExecuteNonQuery();
conn.Dispose();
return intFalg;
}
catch (Exception ee)
{
MessageBox.Show(ee.ToString());
return intFalg;
}
}
#endregion
#region 删除
public int tb_EmpInfoDelete(tb_EmpInfo Empinfo)
{
int intFalg = 0;
try
{
string str_Update = "update tb_EmpInfo set ";
str_Update += "EmpFalg='" + Empinfo.intEmpFalg + "' where EmpId='" + Empinfo.intEmpId + "'";
getsqlconnom getConnection = new getsqlconnom();
conn = getConnection.GetCon();
cmd = new SqlCommand(str_Update, conn);
intFalg = cmd.ExecuteNonQuery();
conn.Dispose();
return intFalg;
}
catch (Exception ee)
{
return intFalg;
}
}
#endregion
#region 查询
public void tb_EmpInfoFind(string strObject,int intFalg,Object DataObject)
{
int intCount=0;
string strSecar=null;
try
{
switch(intFalg)//判断条件
{
case 1://"员工姓名":
strSecar = "select * from tb_EmpInfo where EmpName like '%" + strObject + "%' and EmpFalg=0";
break;
case 2://员工性别
strSecar = "select * from tb_EmpInfo where EmpSex = '" + strObject + "' and EmpFalg=0";
break;
case 3://所属部门"
strSecar = "select * from tb_EmpInfo where EmpDept like '%" + strObject + "%' and EmpFalg=0";
break;
case 4://"员工职位":
strSecar = "select * from tb_EmpInfo where EmpPost like '%" + strObject + "%' and EmpFalg=0";
break;
case 5:
strSecar = "select * from tb_EmpInfo where EmpFalg=0";
break;
case 6:
strSecar = "select * from tb_EmpInfo where EmpPhone like'"+strObject+"%' and EmpFalg=0";
break;
// case 0:
// break;
}
getsqlconnom getConnection = new getsqlconnom();
conn = getConnection.GetCon();
cmd = new SqlCommand(strSecar,conn);
int ii = 0;
qlddr = cmd.ExecuteReader();
while(qlddr.Read())
{
ii++;
}
qlddr.Close();
System.Windows.Forms.DataGridView dv = (DataGridView)DataObject;
if (ii!= 0)
{
int i = 0;
dv.RowCount = ii;
qlddr = cmd.ExecuteReader();
while (qlddr.Read())
{
dv[0, i].Value = qlddr[0].ToString();
dv[1, i].Value = qlddr[1].ToString();
dv[2, i].Value = qlddr[4].ToString();
dv[3, i].Value = qlddr[6].ToString();
dv[4, i].Value = qlddr[7].ToString();
dv[5, i].Value = qlddr[9].ToString();
i++;
}
qlddr.Close();
}
else
{
for (int i = 0; i < dv.RowCount; i++)
{
dv[0, i].Value = "";
dv[1, i].Value = "";
dv[2, i].Value = "";
dv[3, i].Value = "";
dv[4, i].Value = "";
dv[5, i].Value = "";
}
}
}
catch (Exception ee)
{
}
}
#endregion
#region 查询
public SqlDataReader tb_EmpInfoFind(string strObject,int intFalg)
{
int intCount = 0;
string strSecar = null;
try
{
switch (intFalg)
{
case 1:
strSecar = "select * from tb_EmpInfo where EmpId= '" + strObject + "' and EmpFalg=0";
break;
case 2:
strSecar = "select * from tb_EmpInfo where EmpFalg=0";
break;
}
strSecar = "select * from tb_EmpInfo where EmpId= '" + strObject + "' and EmpFalg=0";
getsqlconnom getConnection = new getsqlconnom();
conn = getConnection.GetCon();
cmd = new SqlCommand(strSecar, conn);
qlddr = cmd.ExecuteReader();
return qlddr;
}
catch (Exception ee)
{
return qlddr;
}
}
#endregion
#region 查询
public int tb_EmpInfoFind(string strObject, string pwwd,int intFalg)
{
int intCount = 0;
string strSecar = null;
try
{
switch(intFalg)
{
case 1:
strSecar = "select * from tb_EmpInfo where EmpLoginName= '" + strObject + "' and EmpFalg=0";
break;
case 2:
strSecar = "select * from tb_EmpInfo where EmpLoginName= '" + strObject + "' and EmpFalg=0 and EmpLoginPwd='" + pwwd + "'";
break;
}
getsqlconnom getConnection = new getsqlconnom();
conn = getConnection.GetCon();
cmd = new SqlCommand(strSecar, conn);
qlddr = cmd.ExecuteReader();
qlddr.Read();
if (qlddr.HasRows)
{
intCount = 1;
}
return intCount;
}
catch (Exception ee)
{
MessageBox.Show(ee.Message.ToString());
return intCount=2;
}
}
#endregion
#region //生成客户编号 例如:KH-20071118114255
public string tb_EmpInfoID()
{
int intYear = DateTime.Now.Day;
int intMonth = DateTime.Now.Month;
int intDate = DateTime.Now.Year;
int intHour = DateTime.Now.Hour;
int intSecond = DateTime.Now.Second;
int intMinute = DateTime.Now.Minute;
string strTime = null;
strTime = intYear.ToString();
if (intMonth < 10)
{
strTime += "0" + intMonth.ToString();
}
else
{
strTime += intMonth.ToString();
}
if (intDate < 10)
{
strTime += "0" + intDate.ToString();
}
else
{
strTime += intDate.ToString();
}
if (intHour < 10)
{
strTime += "0" + intHour.ToString();
}
else
{
strTime += intHour.ToString();
}
if (intMinute < 10)
{
strTime += "0" + intMinute.ToString();
}
else
{
strTime += intMinute.ToString();
}
if (intSecond < 10)
{
strTime += "0" + intSecond.ToString();
}
else
{
strTime += intSecond.ToString();
}
return ("YG-" + strTime);
}// end if
#endregion
public DataGridView dataGridView1 { get; set; }}
}