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 + ")";
getSqlConnection getConnection = new getSqlConnection();
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);
}
}
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 + "'";
getSqlConnection getConnection = new getSqlConnection();
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);
}
}
public int tb_EmpInfoAdd(tb_EmpInfo Empinfo)
{
int intFalg = 0;
try
{
string str_Add = "insert into tb_EmpInfo values( ";
str_Add += " '" + Empinfo.strEmpId + "','" + Empinfo.strEmpName + "',";
str_Add += " '" + Empinfo.strEmpLoginPwd + "',";
str_Add += " '" + Empinfo.strEmpDept + "','" + Empinfo.strEmpPost + "'," + " '" + Empinfo.strEmpPhone + "'," + Empinfo.intEmpFalg + ",1,null," + Empinfo.intEmpGroupID;
str_Add += ", '" + Empinfo.strEmpKilnNO + "','" + Empinfo.strEmpWorshoId + "')";
string sql = "select Count(1) from tb_EmpInfo where EmpId='" + Empinfo.strEmpId + "'";
//SqlCommand cmd1 = new SqlCommand(sql, conn);
int count = dbl.ExecuteSelect(sql);
if (count > 0)
{
MessageUtil.ShowError("该员工已存在!");
return(0);
}
else
{
intFalg = dbl.ExeInfochange(str_Add);
return(intFalg);
}
}
catch (Exception ee)
{
MessageBox.Show(ee.ToString());
return(intFalg);
}
}
private void frmSelPorcelain_Load(object sender, EventArgs e)
{
curUser = frmLogin.curUser;
toolbar1.btnSaveClick += new Toolbar.BtnSaveClick(btnSaveClick);
toolbar1.btnNewClick += new Toolbar.BtnNewClick(btnNewClick);
toolbar1.btnDeleteClick += new Toolbar.BtnDeleteClick(btnDeleteClick);
toolbar1.btnEditClick += new Toolbar.BtnEditClick(btnEditClick);
toolbar1.btnCancelClick += new Toolbar.BtnCancelClick(btnCancleClick);
toolbar1.btnEditEnabled = false;
toolbar1.btndelete.Enabled = false;
vKeyBoard1.lblclick += new VKeyBoard.labClick(lblClick);
SetControlsReadOnly(true);
this.Resize += new EventHandler(frmSelPorcelain_Resize);
asc.Load(this);
//fasc.controllInitializeSize(this);
tb_BaseMgr.SetCombox("worknum", cbworknum);
tb_BaseMgr.SetCombox("KilnNO", cmbkilnno);
tb_BaseMgr.SetCombox("ProdLine", cmbSCX);
tb_BaseMgr.SetCombox("material", cmbMaterial);
//string sql = "select "
tb_EmpInfoMenthod.SetCombox(cmbOpr);
//tb_BaseMgr.SetCombox("Color", tbMaterial);
BindModel();
BindColor();
cmbMaterial.SelectedValue = "";
cmbcolor.SelectedValue = "";
cmbcolor.Text = "";
cbgoods.Text = "";
if (!IsGm)
{
cmbOpr.Enabled = false;
cmbOpr.Text = username;
}
else
{
cmbOpr.Text = "";
}
dtdate.Value = System.DateTime.Now;
dtdate2.Value = System.DateTime.Now;
btnDel.Visible = IsGm;
FreshSp();
UpdateBindings(context);
//tb_BaseMgr.SetCombox("KilnNO", cbkilnno);
InitializeGrid();
//InitializeRptGrid();
}
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 + "'";
getSqlConnection getConnection = new getSqlConnection();
conn = getConnection.GetCon();
cmd = new SqlCommand(str_Update, conn);
intFalg = cmd.ExecuteNonQuery();
conn.Dispose();
return(intFalg);
}
catch (Exception ee)
{
return(intFalg);
}
}
public int tb_EmpInfoUpdate(tb_EmpInfo Empinfo)
{
int intFalg = 0;
try
{
string str_Update = "update tb_EmpInfo set ";
str_Update += "EmpName='" + Empinfo.strEmpName + "',";
str_Update += "EmpLoginPwd='" + Empinfo.strEmpLoginPwd + "',";
str_Update += "EmpWorshoId='" + Empinfo.strEmpWorshoId + "',EmpKilnNO='" + Empinfo.strEmpKilnNO + "',";
str_Update += "EmpDept= '" + Empinfo.strEmpDept + "',EmpPost='" + Empinfo.strEmpPost + "',EmpPhone='" + Empinfo.strEmpPhone + "',empfalg=" + Empinfo.intEmpFalg + ",EmpGroupID=" + Empinfo.intEmpGroupID + "";
str_Update += " where EmpId='" + Empinfo.strEmpId + "'";
intFalg = dbl.ExeInfochange(str_Update);
//conn.Dispose();
return(intFalg);
}
catch (Exception ee)
{
MessageBox.Show(ee.ToString());
return(intFalg);
}
}
public int tb_EmpInfoDelete(tb_EmpInfo Empinfo)
{
int intFalg = 0;
return(intFalg);
}
public int tb_EmpInfoAdd(tb_EmpInfo Empinfo)
{
int intFalg = 0;
return(intFalg);
}
