/// <summary>
/// 获取工作经验对象
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <reamrks>tianzhenyun 2012-03-09</reamrks>
public E_JobExperience GetModel(E_JobExperience data)
{
SqlParameter[] parms =
{
new SqlParameter("@JobExperienceID", SqlDbType.BigInt),
new SqlParameter("@PersonalID", SqlDbType.Int),
new SqlParameter("@UserID", SqlDbType.Int)
};
parms[0].Value = data.JobExperienceID;
parms[1].Value = data.PersonalID;
parms[2].Value = data.UserID;
DataTable dt = DbHelperSQL.RunProcedureTable("ProcPI_B_JobExperienceS_Select", parms);
if (dt != null && dt.Rows.Count == 1)
{
DataRow row = dt.Rows[0];
//封装对象
data.StartDate = row["StartDate"] == DBNull.Value ? DateTime.Now : Convert.ToDateTime(row["StartDate"]);
if (row["EndDate"] != DBNull.Value)
{
data.EndDate = Convert.ToDateTime(row["EndDate"]);
}
data.CompanyName = row["CompanyName"].ToString();
data.SetScale = row["Scale"] == DBNull.Value ? 0 : Convert.ToInt32(row["Scale"]);
data.Departments = row["Departments"].ToString();
data.Position = row["Position"].ToString();
data.JobDescription = row["JobDescription"].ToString();
return(data);
}
return(null);
}
/// <summary>
/// 修改工作经验
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <reamrks>tianzhenyun 2012-03-09</reamrks>
public bool Update(E_JobExperience data)
{
int ReturnValue;
SqlParameter[] parms =
{
new SqlParameter("@JobExperienceID", SqlDbType.BigInt),
new SqlParameter("@PersonalID", SqlDbType.Int),
new SqlParameter("@StartDate", SqlDbType.SmallDateTime),
new SqlParameter("@EndDate", SqlDbType.SmallDateTime),
new SqlParameter("@CompanyName", SqlDbType.VarChar, 128),
new SqlParameter("@Scale", SqlDbType.Int),
new SqlParameter("@Departments", SqlDbType.VarChar, 64),
new SqlParameter("@Position", SqlDbType.VarChar, 64),
new SqlParameter("@JobDescription", SqlDbType.VarChar, 512),
new SqlParameter("@UserID", SqlDbType.Int)
};
parms[0].Value = data.JobExperienceID;
parms[1].Value = data.PersonalID;
parms[2].Value = data.StartDate;
parms[3].Value = data.EndDate;
parms[4].Value = data.CompanyName;
parms[5].Value = (int)data.Scale;
parms[6].Value = data.Departments;
parms[7].Value = data.Position;
parms[8].Value = data.JobDescription;
parms[9].Value = data.UserID;
DbHelperSQL.RunProcedures("ProcPI_B_JobExperienceS_Update", parms, out ReturnValue);
return(ReturnValue > 0);
}
/// <summary>
/// 获取个人经验信息详情
/// </summary>
private void GetJob()
{
int jobid;
if (!int.TryParse(nv["jobid"], out jobid))
{
HttpContext.Current.Response.Write("参数错误");
return;
}
E_JobExperience data = new E_JobExperience();
data.PersonalID = pp.PersonalID;
data.UserID = pp.UserID;
data.JobExperienceID = jobid;
data = new T_JobExperience().GetModel(data);
if (data != null)
{
JsonObjectCollection colDR = new JsonObjectCollection();
colDR.Add(new JsonStringValue("startdate", string.Format("{0:yyyy-MM-dd}", data.StartDate)));
colDR.Add(new JsonStringValue("enddate", string.Format("{0:yyyy-MM-dd}", data.EndDate)));
colDR.Add(new JsonStringValue("companyname", data.CompanyName));
colDR.Add(new JsonStringValue("scale", data.Scale.ToString()));
colDR.Add(new JsonStringValue("departments", data.Departments));
colDR.Add(new JsonStringValue("position", data.Position));
colDR.Add(new JsonStringValue("description", data.JobDescription));
HttpContext.Current.Response.Write(colDR.ToString());
}
}
/// <summary>
/// 修改工作信息
/// </summary>
private void UpdateJob()
{
//获取数据
DateTime startdate;
int jobid = 0, scale;
string type = nv["type"];
if (type == "update")
{
if (!int.TryParse(nv["jobid"], out jobid))
{
HttpContext.Current.Response.Write("参数错误");
return;
}
}
if (!DateTime.TryParse(nv["startdate"], out startdate) || !int.TryParse(nv["scale"], out scale) || string.IsNullOrEmpty(nv["companyname"]))
{
HttpContext.Current.Response.Write("参数错误");
return;
}
string companyname = nv["companyname"];
string departments = nv["departments"];
string position = nv["position"];
string description = nv["description"];
E_JobExperience data = new E_JobExperience();
data.JobExperienceID = jobid;
data.UserID = pp.UserID;
data.PersonalID = pp.PersonalID;
data.StartDate = startdate;
if (nv["enddate"] == "")
{
data.EndDate = null;
}
else
{
data.EndDate = Convert.ToDateTime(nv["enddate"]);
}
data.CompanyName = companyname;
data.SetScale = scale;
data.Departments = departments;
data.Position = position;
data.JobDescription = description;
bool flag;
if (type == "add")
{
flag = new T_JobExperience().Add(data);
}
else
{
flag = new T_JobExperience().Update(data);
}
HttpContext.Current.Response.Write(flag ? data.JobExperienceID.ToString() : "0");
}
/// <summary>
/// 绑定数据
/// </summary>
protected void databind()
{
//获取个人基本信息
E_Personal data = new E_Personal();
data.UserID = UserID;
data.PersonalID = PersonalID;
data = new T_Personal().GetModel(data);
if (data == null)
{
return;
}
EnumUtil.BindList <EnumWorkYear>(ddlWorkYear);
EnumUtil.BindList <EnumScale>(ddlScale);
//-----------Info---------
lblBName.Text = data.RealName;
lblBSex.Text = data.Sex == 0 ? "男" : "女";
lblBMarital.Text = data.MaritalStatus.ToString();
lblBBirthday.Text = string.Format("{0:yyyy-MM-dd}", data.Birthday);
lblBWorkYear.Text = data.WorkYears.ToString();
//居住地
//户口所在地
lblBEmail.Text = data.Email;
lblBMobile.Text = data.Mobile;
lblBTel.Text = data.Tel;
lblBFax.Text = data.Fax;
lblBKeyword.Text = data.KeyWord;
lblBAddress.Text = data.Address;
//-----------Edit----------
txtBName.Text = data.RealName;
rdBGender.SelectedValue = data.Sex.ToString();
rdBMarital.SelectedValue = ((int)data.MaritalStatus).ToString();
txtBBirthday.Text = string.Format("{0:yyyy-MM-dd}", data.Birthday);
ddlWorkYear.SelectedValue = ((int)data.WorkYears).ToString();
//居住地
//户口所在地
txtBEmail.Text = data.Email;
txtBMobile.Text = data.Mobile;
txtBTel.Text = data.Tel;
txtBFax.Text = data.Fax;
txtBKeyword.Text = data.KeyWord;
txtBAddress.Text = data.Address;
//获取个人的工作经验
E_JobExperience dataJob = new E_JobExperience();
dataJob.PersonalID = PersonalID;
dataJob.UserID = UserID;
rpList.DataSource = new T_JobExperience().GetList(dataJob);
rpList.DataBind();
}
/// <summary>
/// 查看工作经验列表
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <reamrks>tianzhenyun 2012-03-09</reamrks>
public DataTable GetList(E_JobExperience data)
{
SqlParameter[] parms =
{
new SqlParameter("@PersonalID", SqlDbType.Int),
new SqlParameter("@UserID", SqlDbType.Int)
};
parms[0].Value = data.PersonalID;
parms[1].Value = data.UserID;
return(DbHelperSQL.RunProcedureTable("ProcPI_B_JobExperienceS_SelectList", parms));
}
/// <summary>
/// 删除工作经验
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <reamrks>tianzhenyun 2012-03-09</reamrks>
public bool Delete(E_JobExperience data)
{
SqlParameter[] parms =
{
new SqlParameter("@JobExperienceID", SqlDbType.BigInt),
new SqlParameter("@PersonalID", SqlDbType.Int),
new SqlParameter("@UserID", SqlDbType.Int)
};
parms[0].Value = data.JobExperienceID;
parms[1].Value = data.PersonalID;
parms[2].Value = data.UserID;
int ReturnValue;
DbHelperSQL.RunProcedures("ProcPI_B_JobExperienceS_Delete", parms, out ReturnValue);
return(ReturnValue > 0);
}
/// <summary>
/// 删除工作信息
/// </summary>
private void DeleteJob()
{
int jobid;
if (!int.TryParse(nv["jobid"], out jobid))
{
HttpContext.Current.Response.Write("参数错误");
return;
}
E_JobExperience data = new E_JobExperience();
data.PersonalID = pp.PersonalID;
data.UserID = pp.UserID;
data.JobExperienceID = jobid;
bool flag = new T_JobExperience().Delete(data);
HttpContext.Current.Response.Write(flag ? "1" : "0");
}
/// <summary>
/// 绑定数据
/// </summary>
protected void databind()
{
//获取个人基本信息
E_Personal data = new E_Personal();
data.UserID = userid;
data.PersonalID = personalid;
data = new T_Personal().GetModel(data);
if (data == null)
{
return;
}
//-----------Info---------
lblBName.Text = data.RealName;
lblBSex.Text = data.Sex == 0 ? "男" : "女";
lblBMarital.Text = data.MaritalStatus.ToString();
lblBBirthday.Text = string.Format("{0:yyyy-MM-dd}", data.Birthday);
lblBWorkYear.Text = data.WorkYears.ToString();
//居住地
//户口所在地
lblBEmail.Text = data.Email;
lblBMobile.Text = data.Mobile;
lblBTel.Text = data.Tel;
lblBFax.Text = data.Fax;
lblBKeyword.Text = data.KeyWord;
lblBAddress.Text = data.Address;
//获取个人的工作经验
E_JobExperience dataJob = new E_JobExperience();
dataJob.PersonalID = personalid;
dataJob.UserID = userid;
rpList.DataSource = new T_JobExperience().GetList(dataJob);
rpList.DataBind();
}
/// <summary>
/// 获取工作经验对象
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <reamrks>tianzhenyun 2012-03-09</reamrks>
public E_JobExperience GetModel(E_JobExperience data)
{
return(dal.GetModel(data));
}
/// <summary>
/// 查看工作经验列表
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <reamrks>tianzhenyun 2012-03-09</reamrks>
public DataTable GetList(E_JobExperience data)
{
return(dal.GetList(data));
}
/// <summary>
/// 删除工作经验
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <reamrks>tianzhenyun 2012-03-09</reamrks>
public bool Delete(E_JobExperience data)
{
return(dal.Delete(data));
}
/// <summary>
/// 修改工作经验
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <reamrks>tianzhenyun 2012-03-09</reamrks>
public bool Update(E_JobExperience data)
{
return(dal.Update(data));
}
/// <summary>
/// 添加工作经验
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <reamrks>tianzhenyun 2012-03-09</reamrks>
public bool Add(E_JobExperience data)
{
return(dal.Add(data));
}
