protected void SearchPost_Click(object sender, EventArgs e)
{
exception = "";
prbUserID = UserID.Value;
LUserName.Text = "被考评人姓名：" + UserName.Value;
List<PostResponseBook> post = new List<PostResponseBook>();
if (PostResponseBookBLL.Select(prbUserID, ref post, ref exception))
{
PostResponseBook prb = new PostResponseBook();
prb = post.ElementAt(0);
if (prb.PrbPassed == 1)
{
pass.Text = "已审核！";
Passed.Value = "1";
}
else
{
pass.Text = "未审核！";
Passed.Value = "0";
}
if (prb.PrbComment != "")
{
Comment.Text = prb.PrbComment;
}
else
{
Comment.Text = "";
}
if (prb.PrbEmployer == ERadioButton1.Text)
{
ERadioButton1.Checked = true;
}
else
{
ERadioButton2.Checked = true;
}
prbLaborUnit.Text = prb.PrbLaborUnit;
prbLaborDep.Text = prb.PrbLaborDep;
prbPostName.Text = prb.PrbPostName;
if (prb.PrbPostType == PTRadioButton1.Text)
{
PTRadioButton1.Checked = true;
}
else if (prb.PrbPostType == PTRadioButton2.Text)
{
PTRadioButton2.Checked = true;
}
else if (prb.PrbPostType == PTRadioButton3.Text)
{
PTRadioButton3.Checked = true;
}
else if (prb.PrbPostType == PTRadioButton4.Text)
{
PTRadioButton4.Checked = true;
}
else
{
PTRadioButton5.Checked = true;
}
prbEduBg.Text = prb.PrbEduBg;
prbCertificate.Text = prb.PrbCertificate;
prbExperience.Text = prb.PrbExperience;
prbSkill.Text = prb.PrbSkill;
prbPersonality.Text = prb.PrbPersonality;
prbPhycond.Text = prb.PrbPhyCond;
prbWorkOutline.Text = prb.PrbWorkOutline;
prbWorkContentRequest.Value = prb.PrbWorkContntRequest;
prbPower.Text = prb.PrbPower;
prbResponse.Text = prb.PrbResponse;
prbDirectLeader.Text = prb.PrbDirectLeader;
prbSubordinate.Text = prb.PrbSubordinate;
prbColleague.Text = prb.PrbColleague;
prbServices.Text = prb.PrbServices;
prbRelations.Text = prb.PrbReleations;
prbWorkEnter.Text = prb.PrbWorkEnter;
prbPostAssess.Text = prb.PrbPostAssess;
prbOthers.Text = prb.PrbOthers;
}
else
{
pass.Text = "尚未制定！";
Passed.Value = "-1";
//prbEmployer.Text = "";
prbLaborUnit.Text = (string)Session["ManagerDepartment"];
prbLaborDep.Text = "";
prbPostName.Text = "";
//prbPostType.Text = "";
prbEduBg.Text = "";
prbCertificate.Text = "";
prbExperience.Text = "";
prbSkill.Text = "";
prbPersonality.Text = "";
prbPhycond.Text = "";
prbWorkOutline.Text = "";
prbWorkContentRequest.Value = "";
prbPower.Text = "";
prbResponse.Text = "";
prbDirectLeader.Text = "";
prbSubordinate.Text = "";
prbColleague.Text = "";
prbServices.Text = "";
prbRelations.Text = "";
prbWorkEnter.Text = "办公室内，环境舒适，无职业病危害。";
prbPostAssess.Text = "按同济大学派遣员工考核文件的规定执行。";
prbOthers.Text = "本岗位责任书自双方签字盖章且经人才中心审核盖章后生效，与劳动合同具有相同效力，双方均应遵照执行。\n" +
"自本岗位责任书生效之日起，双方之前就受聘人员岗位达成的约定、协议或岗位责任书与本岗位责任书不一致的，以本岗位责任书为准。\n" +
"本岗位责任书一式四份，人才中心持两份，个人及个人所在部门各持一份。";
Comment.Text = "";
}
ClientScript.RegisterStartupScript(this.GetType(), "", "EditPost()", true);
}
protected void SavePost_Click(object sender, EventArgs e)
{
exception = "";
PostResponseBook prb = new PostResponseBook();
prb.PrbUserID = UserID.Value;
prb.PrbPassed = 2;
if (ERadioButton1.Checked == true)
{
prb.PrbEmployer = ERadioButton1.Text;
}
else
{
prb.PrbEmployer = ERadioButton2.Text;
}
prb.PrbLaborUnit = prbLaborUnit.Text;
prb.PrbLaborDep = prbLaborDep.Text;
prb.PrbPostName = prbPostName.Text;
//prb.PrbPostType = prbPostType.Text;
if (PTRadioButton1.Checked == true)
{
prb.PrbPostType = PTRadioButton1.Text;
}
else if (PTRadioButton2.Checked == true)
{
prb.PrbPostType = PTRadioButton2.Text;
}
else if (PTRadioButton3.Checked == true)
{
prb.PrbPostType = PTRadioButton3.Text;
}
else if (PTRadioButton4.Checked == true)
{
prb.PrbPostType = PTRadioButton4.Text;
}
else if (PTRadioButton5.Checked == true)
{
prb.PrbPostType = PTRadioButton5.Text;
}
prb.PrbEduBg = prbEduBg.Text;
prb.PrbCertificate = prbCertificate.Text;
prb.PrbExperience = prbExperience.Text;
prb.PrbSkill = prbSkill.Text;
prb.PrbPersonality = prbPersonality.Text;
prb.PrbPhyCond = prbPhycond.Text;
prb.PrbWorkOutline = prbWorkOutline.Text;
prb.PrbWorkContntRequest = prbWorkContentRequest.Value;
prb.PrbPower = prbPower.Text;
prb.PrbResponse = prbResponse.Text;
prb.PrbDirectLeader = prbDirectLeader.Text;
prb.PrbSubordinate = prbSubordinate.Text;
prb.PrbColleague = prbColleague.Text;
prb.PrbServices = prbServices.Text;
prb.PrbReleations = prbRelations.Text;
prb.PrbWorkEnter = prbWorkEnter.Text;
prb.PrbPostAssess = prbPostAssess.Text;
prb.PrbOthers = prbOthers.Text;
prb.PrbComment = "";
List<PostResponseBook> prblist = new List<PostResponseBook>();
if (PostResponseBookBLL.Select(prb.PrbUserID, ref prblist, ref exception))
{
PostResponseBookBLL.Update(prb, ref exception);
}
else
{
PostResponseBook[] prbs = new PostResponseBook[1];
prbs[0] = prb;
PostResponseBookBLL.Insert(prbs, ref exception);
}
ClientScript.RegisterStartupScript(this.GetType(), "", "doneSave()", true);
}
protected void SearchPost_Click(object sender, EventArgs e)
{
prbUserID = UserID.Value;
List<PostResponseBook> post1 = new List<PostResponseBook>();
exception = "";
LUserName.Text = "被考评人姓名：" + UserName.Value;
if (PostResponseBookBLL.Select(prbUserID, ref post1, ref exception))
{
PostResponseBook prb = new PostResponseBook();
prb = post1.ElementAt(0);
if (prb.PrbPassed == 1)
{
passYoN.Text = "已通过审核！";
Passed.Value = "1";
}
else
{
passYoN.Text = "未通过审核！";
Passed.Value = "0";
}
if (prb.PrbComment != "")
{
Comment.Text = prb.PrbComment;
}
else
{
Comment.Text = "";
}
prbEmployer.Text = prb.PrbEmployer;
prbLaborUnit.Text = prb.PrbLaborUnit;
prbLaborDep.Text = prb.PrbLaborDep;
prbPostName.Text = prb.PrbPostName;
prbPostType.Text = prb.PrbPostType;
prbEduBg.Text = prb.PrbEduBg;
prbCertificate.Text = prb.PrbCertificate;
prbExperience.Text = prb.PrbExperience;
prbSkill.Text = prb.PrbSkill;
prbPersonality.Text = prb.PrbPersonality;
prbPhycond.Text = prb.PrbPhyCond;
prbWorkOutline.Text = prb.PrbWorkOutline;
prbWorkContentRequestTemp.Value = prb.PrbWorkContntRequest;
prbWorkContentRequest.Text = prbWorkContentRequestTemp.Value.Replace("&", "\n").Replace("$", "\n").Replace("*", "");
prbPower.Text = prb.PrbPower;
prbResponse.Text = prb.PrbResponse;
prbDirectLeader.Text = prb.PrbDirectLeader;
prbSubordinate.Text = prb.PrbSubordinate;
prbColleague.Text = prb.PrbColleague;
prbServices.Text = prb.PrbServices;
prbRelations.Text = prb.PrbReleations;
prbWorkEnter.Text = prb.PrbWorkEnter;
prbPostAssess.Text = prb.PrbPostAssess;
prbOthers.Text = prb.PrbOthers;
}
else
{
passYoN.Text = "尚未制定！";
Comment.Text = "";
Passed.Value = "-1";
prbEmployer.Text = "";
prbLaborUnit.Text = "";
prbLaborDep.Text = "";
prbPostName.Text = "";
prbPostType.Text = "";
prbEduBg.Text = "";
prbCertificate.Text = "";
prbExperience.Text = "";
prbSkill.Text = "";
prbPersonality.Text = "";
prbPhycond.Text = "";
prbWorkOutline.Text = "";
prbWorkContentRequest.Text = "";
prbPower.Text = "";
prbResponse.Text = "";
prbDirectLeader.Text = "";
prbSubordinate.Text = "";
prbColleague.Text = "";
prbServices.Text = "";
prbRelations.Text = "";
prbWorkEnter.Text = "";
prbPostAssess.Text = "";
prbOthers.Text = "";
}
ClientScript.RegisterStartupScript(this.GetType(), "", "EditPost()", true);
}
protected void Submit_Click(object sender, EventArgs e)
{
PostResponseBook prb = new PostResponseBook();
if (Passed.Value.Equals(DBNull.Value) || Passed.Value == "")
{
Errors.Value = "无待提交岗位责任书！";
ClientScript.RegisterStartupScript(this.GetType(), "", "tanchuang()", true);
return;
}
if (Passed.Value == "1")
return;
prb.PrbUserID = UserID.Value;
prb.PrbPassed = 1;
prb.PrbEmployer = prbEmployer.Text;
prb.PrbLaborUnit = prbLaborUnit.Text;
prb.PrbLaborDep = prbLaborDep.Text;
prb.PrbPostName = prbPostName.Text;
prb.PrbPostType = prbPostType.Text;
prb.PrbEduBg = prbEduBg.Text;
prb.PrbCertificate = prbCertificate.Text;
prb.PrbExperience = prbExperience.Text;
prb.PrbSkill = prbSkill.Text;
prb.PrbPersonality = prbPersonality.Text;
prb.PrbPhyCond = prbPhycond.Text;
prb.PrbWorkOutline = prbWorkOutline.Text;
prb.PrbWorkContntRequest = prbWorkContentRequestTemp.Value;
prb.PrbPower = prbPower.Text;
prb.PrbResponse = prbResponse.Text;
prb.PrbDirectLeader = prbDirectLeader.Text;
prb.PrbSubordinate = prbSubordinate.Text;
prb.PrbColleague = prbColleague.Text;
prb.PrbServices = prbServices.Text;
prb.PrbReleations = prbRelations.Text;
prb.PrbWorkEnter = prbWorkEnter.Text;
prb.PrbPostAssess = prbPostAssess.Text;
prb.PrbOthers = prbOthers.Text;
prb.PrbComment = "";
exception = "";
PostResponseBookBLL.Update(prb, ref exception);
System.Data.DataTable table = new System.Data.DataTable();
table = searchSql();
if (table == null)
{
return;
}
string json = JSON.DataTableToJson(table);
JsonData.Value = json;
ClientScript.RegisterStartupScript(this.GetType(), "", "donework()", true);
//Response.Write("<script>document.getElementByI</script>");
}
public static bool Insert(PostResponseBook[] prb, ref string e)
{
int count = prb.Length;
for (int i = 0; i < count; i++)
{
string sql = "insert into tb_PostResponseBook values("
+ "@prbUserID,@prbPassed,@prbEmployer,@prbLaborUnit,"
+ "@prbLaborDep,@prbPostName,@prbPostType,@prbEduBg,"
+ "@prbCertificate,@prbExperience,@prbSkill,@prbPersonality,"
+ "@prbPhyCond,@prbWorkOutline,@prbWorkContntRequest,@prbPower,"
+ "@prbResponse,@prbDirectLeader,@prbSubordinate,@prbColleague,"
+ "@prbServices,@prbReleations,@prbWorkEnter,@prbPostAssess,@prbOthers,@prbComment)";
SqlParameter[] parameters =
{
new SqlParameter("@prbUserID", SqlDbType.VarChar,10),
new SqlParameter("@prbPassed", SqlDbType.Int,4),
new SqlParameter("@prbEmployer", SqlDbType.NVarChar,50),
new SqlParameter("@prbLaborUnit", SqlDbType.NVarChar,50),
new SqlParameter("@prbLaborDep", SqlDbType.NVarChar,50),
new SqlParameter("@prbPostName", SqlDbType.NVarChar,50),
new SqlParameter("@prbPostType", SqlDbType.NVarChar,20),
new SqlParameter("@prbEduBg", SqlDbType.NVarChar,int.MaxValue),
new SqlParameter("@prbCertificate",SqlDbType.NVarChar,int.MaxValue),
new SqlParameter("@prbExperience", SqlDbType.NVarChar,int.MaxValue),
new SqlParameter("@prbSkill", SqlDbType.NVarChar,int.MaxValue),
new SqlParameter("@prbPersonality", SqlDbType.NVarChar,int.MaxValue),
new SqlParameter("@prbPhyCond", SqlDbType.NVarChar,int.MaxValue),
new SqlParameter("@prbWorkOutline", SqlDbType.NVarChar,int.MaxValue),
new SqlParameter("@prbWorkContntRequest", SqlDbType.NVarChar,int.MaxValue),
new SqlParameter("@prbPower", SqlDbType.NVarChar,int.MaxValue),
new SqlParameter("@prbResponse", SqlDbType.NVarChar,int.MaxValue),
new SqlParameter("@prbDirectLeader", SqlDbType.NVarChar,int.MaxValue),
new SqlParameter("@prbSubordinate", SqlDbType.NVarChar,int.MaxValue),
new SqlParameter("@prbColleague", SqlDbType.NVarChar,int.MaxValue),
new SqlParameter("@prbServices", SqlDbType.NVarChar,int.MaxValue),
new SqlParameter("@prbReleations", SqlDbType.NVarChar,int.MaxValue),
new SqlParameter("@prbWorkEnter", SqlDbType.NVarChar,int.MaxValue),
new SqlParameter("@prbPostAssess", SqlDbType.NVarChar,int.MaxValue),
new SqlParameter("@prbOthers", SqlDbType.NVarChar,int.MaxValue),
new SqlParameter("@prbComment", SqlDbType.NVarChar, 50)
};
parameters[0].Value = prb[i].PrbUserID;
parameters[1].Value = prb[i].PrbPassed;
parameters[2].Value = prb[i].PrbEmployer;
parameters[3].Value = prb[i].PrbLaborUnit;
parameters[4].Value = prb[i].PrbLaborDep;
parameters[5].Value = prb[i].PrbPostName;
parameters[6].Value = prb[i].PrbPostType;
parameters[7].Value = prb[i].PrbEduBg;
parameters[8].Value = prb[i].PrbCertificate;
parameters[9].Value = prb[i].PrbExperience;
parameters[10].Value = prb[i].PrbSkill;
parameters[11].Value = prb[i].PrbPersonality;
parameters[12].Value = prb[i].PrbPhyCond;
parameters[13].Value = prb[i].PrbWorkOutline;
parameters[14].Value = prb[i].PrbWorkContntRequest;
parameters[15].Value = prb[i].PrbPower;
parameters[16].Value = prb[i].PrbResponse;
parameters[17].Value = prb[i].PrbDirectLeader;
parameters[18].Value = prb[i].PrbSubordinate;
parameters[19].Value = prb[i].PrbColleague;
parameters[20].Value = prb[i].PrbServices;
parameters[21].Value = prb[i].PrbReleations;
parameters[22].Value = prb[i].PrbWorkEnter;
parameters[23].Value = prb[i].PrbPostAssess;
parameters[24].Value = prb[i].PrbOthers;
parameters[25].Value = prb[i].PrbComment;
string exception = db.InsertExec(sql, parameters);
if (exception != "" && exception != null)
{
e = exception;
return false;
}
}
return true;
}
public static bool Update(PostResponseBook model, ref string e)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_PostResponseBook set ");
strSql.Append("prbPassed=@prbPassed,");
strSql.Append("prbEmployer=@prbEmployer,");
strSql.Append("prbLaborUnit=@prbLaborUnit,");
strSql.Append("prbLaborDep=@prbLaborDep,");
strSql.Append("prbPostName=@prbPostName,");
strSql.Append("prbPostType=@prbPostType,");
strSql.Append("prbEduBg=@prbEduBg,");
strSql.Append("prbCertificate=@prbCertificate,");
strSql.Append("prbExperience=@prbExperience,");
strSql.Append("prbSkill=@prbSkill,");
strSql.Append("prbPersonality=@prbPersonality,");
strSql.Append("prbPhyCond=@prbPhyCond,");
strSql.Append("prbWorkOutline=@prbWorkOutline,");
strSql.Append("prbWorkContntRequest=@prbWorkContntRequest,");
strSql.Append("prbPower=@prbPower,");
strSql.Append("prbResponse=@prbResponse,");
strSql.Append("prbDirectLeader=@prbDirectLeader,");
strSql.Append("prbSubordinate=@prbSubordinate,");
strSql.Append("prbColleague=@prbColleague,");
strSql.Append("prbServices=@prbServices,");
strSql.Append("prbReleations=@prbReleations,");
strSql.Append("prbWorkEnter=@prbWorkEnter,");
strSql.Append("prbPostAssess=@prbPostAssess,");
strSql.Append("prbOthers=@prbOthers,");
strSql.Append("prbComment=@prbComment");
strSql.Append(" where prbUserID=@prbUserID");
SqlParameter[] parameters =
{
new SqlParameter("@prbUserID", SqlDbType.VarChar,10),
new SqlParameter("@prbPassed", SqlDbType.Int,4),
new SqlParameter("@prbEmployer", SqlDbType.NVarChar,50),
new SqlParameter("@prbLaborUnit", SqlDbType.NVarChar,50),
new SqlParameter("@prbLaborDep", SqlDbType.NVarChar,50),
new SqlParameter("@prbPostName", SqlDbType.NVarChar,50),
new SqlParameter("@prbPostType", SqlDbType.NVarChar,20),
new SqlParameter("@prbEduBg", SqlDbType.NVarChar,int.MaxValue),
new SqlParameter("@prbCertificate",SqlDbType.NVarChar,int.MaxValue),
new SqlParameter("@prbExperience", SqlDbType.NVarChar,int.MaxValue),
new SqlParameter("@prbSkill", SqlDbType.NVarChar,int.MaxValue),
new SqlParameter("@prbPersonality", SqlDbType.NVarChar,int.MaxValue),
new SqlParameter("@prbPhyCond", SqlDbType.NVarChar,int.MaxValue),
new SqlParameter("@prbWorkOutline", SqlDbType.NVarChar,int.MaxValue),
new SqlParameter("@prbWorkContntRequest", SqlDbType.NVarChar,int.MaxValue),
new SqlParameter("@prbPower", SqlDbType.NVarChar,int.MaxValue),
new SqlParameter("@prbResponse", SqlDbType.NVarChar,int.MaxValue),
new SqlParameter("@prbDirectLeader", SqlDbType.NVarChar,int.MaxValue),
new SqlParameter("@prbSubordinate", SqlDbType.NVarChar,int.MaxValue),
new SqlParameter("@prbColleague", SqlDbType.NVarChar,int.MaxValue),
new SqlParameter("@prbServices", SqlDbType.NVarChar,int.MaxValue),
new SqlParameter("@prbReleations", SqlDbType.NVarChar,int.MaxValue),
new SqlParameter("@prbWorkEnter", SqlDbType.NVarChar,int.MaxValue),
new SqlParameter("@prbPostAssess", SqlDbType.NVarChar,int.MaxValue),
new SqlParameter("@prbOthers", SqlDbType.NVarChar,int.MaxValue),
new SqlParameter("@prbComment", SqlDbType.NVarChar,50)
};
parameters[0].Value = model.PrbUserID;
parameters[1].Value = model.PrbPassed;
parameters[2].Value = model.PrbEmployer;
parameters[3].Value = model.PrbLaborUnit;
parameters[4].Value = model.PrbLaborDep;
parameters[5].Value = model.PrbPostName;
parameters[6].Value = model.PrbPostType;
parameters[7].Value = model.PrbEduBg;
parameters[8].Value = model.PrbCertificate;
parameters[9].Value = model.PrbExperience;
parameters[10].Value = model.PrbSkill;
parameters[11].Value = model.PrbPersonality;
parameters[12].Value = model.PrbPhyCond;
parameters[13].Value = model.PrbWorkOutline;
parameters[14].Value = model.PrbWorkContntRequest;
parameters[15].Value = model.PrbPower;
parameters[16].Value = model.PrbResponse;
parameters[17].Value = model.PrbDirectLeader;
parameters[18].Value = model.PrbSubordinate;
parameters[19].Value = model.PrbColleague;
parameters[20].Value = model.PrbServices;
parameters[21].Value = model.PrbReleations;
parameters[22].Value = model.PrbWorkEnter;
parameters[23].Value = model.PrbPostAssess;
parameters[24].Value = model.PrbOthers;
parameters[25].Value = model.PrbComment;
e = db.QueryExec(strSql.ToString(), parameters);
if (e != "" && e != null)
{
return false;
}
return true;
}
public static bool Select(ref List<PostResponseBook> model, ref string e,string sql)
{
DataTable table = new DataTable();
table = db.QueryDataTable(sql, ref e);
if (table != null && table.Rows.Count > 0)
{
for (int i = 0; i < table.Rows.Count; i++)
{
PostResponseBook prb = new PostResponseBook();
prb.PrbUserID = (string)table.Rows[i]["prbUserID"];
prb.PrbPassed = (Int32)table.Rows[i]["prbPassed"];
prb.PrbEmployer = (string)table.Rows[i]["prbEmployer"];
prb.PrbLaborUnit = (string)table.Rows[i]["prbLaborUnit"];
prb.PrbLaborDep = (string)table.Rows[i]["prbLaborDep"];
prb.PrbPostName = (string)table.Rows[i]["prbPostName"];
prb.PrbPostType = (string)table.Rows[i]["prbPostType"];
prb.PrbEduBg = (string)table.Rows[i]["prbEduBg"];
prb.PrbCertificate = (string)table.Rows[i]["prbCertificate"];
prb.PrbExperience = (string)table.Rows[i]["prbExperience"];
prb.PrbSkill = (string)table.Rows[i]["prbSkill"];
prb.PrbPersonality = (string)table.Rows[i]["prbPersonality"];
prb.PrbPhyCond = (string)table.Rows[i]["prbPhyCond"];
prb.PrbWorkOutline = (string)table.Rows[i]["prbWorkOutline"];
prb.PrbWorkContntRequest = (string)table.Rows[i]["prbWorkContntRequest"];
prb.PrbPower = (string)table.Rows[i]["prbPower"];
prb.PrbResponse = (string)table.Rows[i]["prbResponse"];
prb.PrbDirectLeader = (string)table.Rows[i]["prbDirectLeader"];
prb.PrbSubordinate = (string)table.Rows[i]["prbSubordinate"];
prb.PrbColleague = (string)table.Rows[i]["prbColleague"];
prb.PrbServices = (string)table.Rows[i]["prbServices"];
prb.PrbReleations = (string)table.Rows[i]["prbReleations"];
prb.PrbWorkEnter = (string)table.Rows[i]["prbWorkEnter"];
prb.PrbPostAssess = (string)table.Rows[i]["prbPostAssess"];
prb.PrbOthers = (string)table.Rows[i]["prbOthers"];
if (!table.Rows[i].IsNull("prbComment"))
{
prb.PrbComment = (string)table.Rows[i]["prbComment"];
}
else
{
prb.PrbComment = "";
}
model.Add(prb);
}
return true;
}
else
{
return false;
}
}