public bool AddEmployeeResume(CPersonnelResume Resume)
{
if (Resume == null)
{
return(false);
}
List <OleDbParameter> Param = new List <OleDbParameter>();
Param.Add(Db.MakeInParam("PersonnelID", System.Data.OleDb.OleDbType.BigInt, 8, Resume.PersonnelID));
Param.Add(Db.MakeInParam("Resume", System.Data.OleDb.OleDbType.VarChar, 2048, Resume.Resume));
Param.Add(Db.MakeInParam("Portrait", System.Data.OleDb.OleDbType.LongVarBinary, 0, Resume.Portrait));
Param.Add(Db.MakeInParam("Fere", System.Data.OleDb.OleDbType.VarChar, 50, Resume.Fere));
Param.Add(Db.MakeInParam("FerePhone", System.Data.OleDb.OleDbType.VarChar, 50, Resume.FerePhone));
Param.Add(Db.MakeInParam("Father", System.Data.OleDb.OleDbType.VarChar, 50, Resume.Father));
Param.Add(Db.MakeInParam("FatherPhone", System.Data.OleDb.OleDbType.VarChar, 50, Resume.FatherPhone));
Param.Add(Db.MakeInParam("Mater", System.Data.OleDb.OleDbType.VarChar, 50, Resume.Mater));
Param.Add(Db.MakeInParam("MaterPhone", System.Data.OleDb.OleDbType.VarChar, 50, Resume.MaterPhone));
Param.Add(Db.MakeInParam("Wedded", System.Data.OleDb.OleDbType.Integer, 4, Resume.Wedded));
if (Db.ExecSql(@"INSERT INTO tPersonnelResume(PersonnelID,Resume,Portrait,Fere,FerePhone,Father, FatherPhone,Mater,MaterPhone,Wedded) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", Param) > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool UpdateEmployeeResume(CPersonnelResume Resume)
{
if (Resume == null)
{
return(false);
}
int PortraitLen = 0;
if (Resume.Portrait != null)
{
PortraitLen = Resume.Portrait.Length;
}
List <OleDbParameter> Param = new List <OleDbParameter>();
Param.Add(Db.MakeInParam("PersonnelID", System.Data.OleDb.OleDbType.BigInt, 8, Resume.PersonnelID));
Param.Add(Db.MakeInParam("Resume", System.Data.OleDb.OleDbType.VarChar, 2048, Resume.Resume));
if (PortraitLen > 0)
{
Param.Add(Db.MakeInParam("Portrait", System.Data.OleDb.OleDbType.LongVarBinary, PortraitLen, Resume.Portrait));
}
Param.Add(Db.MakeInParam("Fere", System.Data.OleDb.OleDbType.VarChar, 50, Resume.Fere));
Param.Add(Db.MakeInParam("FerePhone", System.Data.OleDb.OleDbType.VarChar, 50, Resume.FerePhone));
Param.Add(Db.MakeInParam("Father", System.Data.OleDb.OleDbType.VarChar, 50, Resume.Father));
Param.Add(Db.MakeInParam("FatherPhone", System.Data.OleDb.OleDbType.VarChar, 50, Resume.FatherPhone));
Param.Add(Db.MakeInParam("Mater", System.Data.OleDb.OleDbType.VarChar, 50, Resume.Mater));
Param.Add(Db.MakeInParam("MaterPhone", System.Data.OleDb.OleDbType.VarChar, 50, Resume.MaterPhone));
Param.Add(Db.MakeInParam("Wedded", System.Data.OleDb.OleDbType.Integer, 4, Resume.Wedded));
string CommandText = "Update tPersonnelResume Set Resume=?,Fere=?,FerePhone=?,Father=?,FatherPhone=?,Mater=?,MaterPhone=?,Wedded=? where PersonnelID=?";
if (PortraitLen > 0)
{
CommandText = "Update tPersonnelResume Set Resume=?,Portrait=?,Fere=?,FerePhone=?,Father=?,FatherPhone=?,Mater=?,MaterPhone=?,Wedded=? where PersonnelID=?";
}
else
{
}
if (Db.ExecSql(CommandText, Param) > 0)
{
return(true);
}
else
{
return(false);
}
}
public CPersonnelResume GetEmployeeResume(long EmployeeID)
{
CPersonnelResume EmployeeResume = new CPersonnelResume();
List <OleDbParameter> Param = new List <OleDbParameter>();
Param.Add(Db.MakeInParam("PersonnelID", System.Data.OleDb.OleDbType.BigInt, 8, EmployeeID));
DataTable dt = Db.GetDataTable(@"Select * From tPersonnelResume where PersonnelID=?", Param);
if (dt != null && dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
EmployeeResume.PersonnelID = EmployeeID;
EmployeeResume.Father = dr["Father"].ToString();
EmployeeResume.FatherPhone = dr["FatherPhone"].ToString();
EmployeeResume.Fere = dr["Fere"].ToString();
EmployeeResume.FerePhone = dr["FerePhone"].ToString();
EmployeeResume.Mater = dr["Mater"].ToString();
EmployeeResume.MaterPhone = dr["MaterPhone"].ToString();
object obytes = dr["Portrait"];
if (obytes.ToString() != "")
{
EmployeeResume.Portrait = (byte[])obytes;
}
else
{
EmployeeResume.Portrait = null;
}
EmployeeResume.Resume = dr["Resume"].ToString();
EmployeeResume.Wedded = Convert.ToInt32(dr["Wedded"]);
return(EmployeeResume);
}
else
{
return(null);
}
}
public FormEmployeeInfo()
{
m_Personnel = new CPersonnel();
m_PersonnelResume = new CPersonnelResume();
InitializeComponent();
}
void ModEmployeeInfo()
{
if (dgvEmployee.CurrentRow != null)
{
FormEmployeeInfo dlg = new FormEmployeeInfo();
DataRowView drv = (DataRowView)dgvEmployee.CurrentRow.DataBoundItem;
dlg.m_Personnel.Name = drv["Name"].ToString();
dlg.m_Personnel.Alias = drv["Alias"].ToString();
dlg.m_Personnel.Addrees = drv["Addrees"].ToString();
if (!Convert.IsDBNull(drv["Birth"]))
{
dlg.m_Personnel.Birth = Convert.ToDateTime(drv["Birth"]);
}
dlg.m_Personnel.EduLevel = drv["EduLevel"].ToString();
dlg.m_Personnel.EMail = drv["EMail"].ToString();
dlg.m_Personnel.Fax = drv["Fax"].ToString();
if (!Convert.IsDBNull(drv["HoldDate"]))
{
dlg.m_Personnel.HoldDate = Convert.ToDateTime(drv["HoldDate"]);
}
dlg.m_Personnel.HomePhone = drv["HomePhone"].ToString();
dlg.m_Personnel.IdentityCard = drv["IdentityCard"].ToString();
dlg.m_Personnel.MobilePhone = drv["MobilePhone"].ToString();
dlg.m_Personnel.MSN = drv["MSN"].ToString();
if (!Convert.IsDBNull(drv["Outjob"]))
{
dlg.m_Personnel.Outjob = Convert.ToInt32(drv["Outjob"]);
}
dlg.m_Personnel.PersonnelID = Convert.ToInt32(drv["PersonnelID"]);
dlg.m_Personnel.QQ = drv["QQ"].ToString();
dlg.m_Personnel.Sex = drv["Sex"].ToString();
dlg.m_Personnel.WorkAddress = drv["WorkAddress"].ToString();
dlg.m_Personnel.WorkID = drv["WorkID"].ToString();
dlg.m_Personnel.WorkPhone = drv["WorkPhone"].ToString();
if (!Convert.IsDBNull(drv["Contract"]))
{
dlg.m_Personnel.ContractDate = Convert.ToDateTime(drv["Contract"]);
}
if (!Convert.IsDBNull(drv["DimissionDate"]))
{
dlg.m_Personnel.DimissionDate = Convert.ToDateTime(drv["DimissionDate"]);
}
dlg.m_PersonnelResume.PersonnelID = dlg.m_Personnel.PersonnelID;
CPersonnelResume PersonnelResume = m_DbAdaHelper.GetEmployeeResume(dlg.m_Personnel.PersonnelID);
if (PersonnelResume != null)
{
dlg.m_PersonnelResume = PersonnelResume;
}
if (dlg.ShowDialog() == DialogResult.OK)
{
m_DbAdaHelper.UpdateEmployee(dlg.m_Personnel);
m_DbAdaHelper.UpdateEmployeeResume(dlg.m_PersonnelResume);
}
dgvEmployee.DataSource = m_DbAdaHelper.GetEmployee();
}
}