public static bool Insert(User[] model, ref string e)
{
int count = model.Length;
for (int i = 0; i < count; i++)
{
string sql = "insert into tb_User values(@uID,@uPassword,@uType)";
SqlParameter[] parameters =
{
new SqlParameter("@uID", SqlDbType.VarChar,10),
new SqlParameter("@uPassword",SqlDbType.Char,6),
new SqlParameter("@uType", SqlDbType.VarChar,10)
};
//获取身份证号作密码
List<EvaluatorInfo> evis = new List<EvaluatorInfo>();
if (!EvaluatorInfoBLL.Select(evis, model[i].UID, ref e))
{
return false;
}
parameters[0].Value = evis.ElementAt(0).EvID;
parameters[1].Value = evis.ElementAt(0).EvMobPhone.Substring(5, 6);
parameters[2].Value = "00010";
string exception = db.InsertExec(sql, parameters);
if (exception != "" && exception != null)
{
e = exception;
return false;
}
}
return true;
}
protected void Delete_Click(object sender, EventArgs e)
{
exception = "";
List<EvaluatorInfo> evaluatorinfo = new List<EvaluatorInfo>();
evaluatorinfo = JSON.isEfect1(UserID.Value);
EvaluatorInfo deleted = evaluatorinfo.ElementAt(0);
EvaluatorInfoBLL.Delete(deleted.EvID, ref exception);
DataTable table = new DataTable();
table = searchSql();
string json = JSON.DataTableToJson(table);
JsonData.Value = json;
ClientScript.RegisterStartupScript(this.GetType(), "", "load_userinfo()", true);
return;
}
protected void Delete_Click(object sender, EventArgs e)
{
exception = "";
List<UserInfo> userinfo = new List<UserInfo>();
userinfo = JSON.isEfect(UserID.Value);
UserInfo deleted = userinfo.ElementAt(0);
deleted.UiType = deleted.UiType.Remove(4, 1).Insert(4, "0");
UserInfoBLL.Update(deleted, ref exception);
DataTable table = new DataTable();
table = searchSql();
string json = JSON.DataTableToJson(table);
JsonData.Value = json;
ClientScript.RegisterStartupScript(this.GetType(), "", "load_userinfo()", true);
return;
}
protected void Delete_Click(object sender, EventArgs e)
{
exception = "";
string userID = "";
string userType = "-1";
List<UserInfo> userinfo = new List<UserInfo>();
userinfo = JSON.isEfect(UserID.Value);
UserInfo deleted = userinfo.ElementAt(0);
userID = deleted.UiID;
userType = deleted.UiType;
//if (userType == 2 || userType == 6)
if(userType.Substring(2, 5) == "100")
{
UserBLL.Delete(userID, ref exception);
}
else
{
List<User> model = new List<Model.User>();
if (UserBLL.Select(deleted.UiID, ref model, ref exception))
{
User user = model.ElementAt(0);
user.UType = user.UType.Remove(2, 1).Insert(2, "1");
UserBLL.Update(user, ref exception);
}
}
deleted.UiType = deleted.UiType.Remove(2, 1).Insert(2, "1");
UserInfoBLL.Update(deleted, ref exception);
DataTable table = new DataTable();
table = searchSql();
if (table == null)
return;
string json = JSON.DataTableToJson(table);
JsonData.Value = json;
ClientScript.RegisterStartupScript(this.GetType(), "", "load_userinfo()", true);
return;
}
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 Search(object sender, EventArgs e)
{
string username = (string)Session["username"];
//string username = "******";
string uiDepart = "";
List<Manager> manager = new List<Manager>();
exception = "";
if (ManagerBLL.SelectByID(username, ref manager, ref exception))
{
uiDepart = manager.ElementAt(0).MDepartment;
Session["ManagerDepartment"] = uiDepart;
Title.Text = uiDepart + "被考评人名单：";
List<UserInfo> Evaluated = new List<UserInfo>();
string type = "____1%";
bool b = UserInfoBLL.Select(uiDepart, type, ref Evaluated, ref exception);
if (b)
{
DataTable table = new DataTable();
table = Evaluated.ListToDataTable();
//给table添加prbComment栏
adjustTable(table, ref exception);
int sumCount = 0, unPassCount = 0, passCount = 0, savedCount = 0, unMakeCount = 0;
countNumber(table, ref sumCount, ref unPassCount, ref passCount, ref savedCount, ref unMakeCount);//做汇总
Title.Text += "( 未制作：" + unMakeCount + ", 已保存：" + savedCount + ", 已提交：" + unPassCount + ", 已审核：" + passCount + "\\总人数：" + sumCount + " )";
table.DefaultView.Sort = "PrbPassed desc"; //给table按状态排序
table = table.DefaultView.ToTable();
string json = JSON.DataTableToJson(table);
JsonData.Value = json;
ClientScript.RegisterStartupScript(this.GetType(), "", "load_userinfo()", true);
return;
}
else
{
Errors.Value = "本部门尚无被考评人！";
ClientScript.RegisterStartupScript(this.GetType(), "", "tanchuang()", true);
return;
}
}
else
{
Errors.Value = "您无此操作权限！";
ClientScript.RegisterStartupScript(this.GetType(), "", "tanchuang()", true);
return;
}
}
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);
}
public static bool Insert(AssessTable[] at, ref string e)
{
int count = at.Length;
for (int i = 0; i < count; i++)
{
List<AssessTable> model = new List<AssessTable>();
if (Select(at[i].AtUserID, at[i].AtDep, at[i].AtDate, ref model, ref e))
{
if (model.ElementAt(0).AtPass == 0)
e = "部门 " + at[i].AtDep + " " + at[i].AtDate + " 的考核表已存在，尚未通过审核";
else
{
e = "部门 " + at[i].AtDep + " " + at[i].AtDate + " 的考核表已存在，并通过审核";
}
return false;
}
string sql = "insert into tb_AssessTable values(@atUserID,@atDep,@atDate,@atPass,"
+ "@atKeyResponse1,@atKeyResponse2,@atKeyResponse3,@atKeyResponse4,@atKeyResponse5,"
+ "@atKeyAbility1,@atKeyAbility2,@atKeyAbility3,@atKeyAbility4,@atKeyAbility5,"
+ "@atKeyAttitude1,@atKeyAttitude2,@atKeyAttitude3,@atKeyAttitude4,@atKeyAttitude5,"
+ "@atResponse1,@atResponse2,@atResponse3,@atResponse4,@atResponse5,"
+ "@atAbility1,@atAbility2,@atAbility3,@atAbility4,@atAbility5,"
+ "@atAttitude1,@atAttitude2,@atAttitude3,@atAttitude4,@atAttitude5,"
+ "@atVeto1,@atVeto2,@atVeto3,@atVeto4,@atVeto5,@atVetoOthers,@atComment)";
SqlParameter[] parameters =
{
new SqlParameter("@atUserID", SqlDbType.VarChar,10),
new SqlParameter("@atDep", SqlDbType.NVarChar,50),
new SqlParameter("@atDate", SqlDbType.DateTime),
new SqlParameter("@atPass", SqlDbType.Int,4),
new SqlParameter("@atKeyResponse1", SqlDbType.NVarChar,int.MaxValue),
new SqlParameter("@atKeyResponse2", SqlDbType.NVarChar,int.MaxValue),
new SqlParameter("@atKeyResponse3", SqlDbType.NVarChar,int.MaxValue),
new SqlParameter("@atKeyResponse4", SqlDbType.NVarChar,int.MaxValue),
new SqlParameter("@atKeyResponse5", SqlDbType.NVarChar,int.MaxValue),
new SqlParameter("@atKeyAbility1", SqlDbType.Int,4),
new SqlParameter("@atKeyAbility2", SqlDbType.Int,4),
new SqlParameter("@atKeyAbility3", SqlDbType.Int,4),
new SqlParameter("@atKeyAbility4", SqlDbType.Int,4),
new SqlParameter("@atKeyAbility5", SqlDbType.Int,4),
new SqlParameter("@atKeyAttitude1", SqlDbType.Int,4),
new SqlParameter("@atKeyAttitude2", SqlDbType.Int,4),
new SqlParameter("@atKeyAttitude3", SqlDbType.Int,4),
new SqlParameter("@atKeyAttitude4", SqlDbType.Int,4),
new SqlParameter("@atKeyAttitude5", SqlDbType.Int,4),
new SqlParameter("@atResponse1", SqlDbType.NVarChar,int.MaxValue),
new SqlParameter("@atResponse2", SqlDbType.NVarChar,int.MaxValue),
new SqlParameter("@atResponse3", SqlDbType.NVarChar,int.MaxValue),
new SqlParameter("@atResponse4", SqlDbType.NVarChar,int.MaxValue),
new SqlParameter("@atResponse5", SqlDbType.NVarChar,int.MaxValue),
new SqlParameter("@atAbility1", SqlDbType.Int,4),
new SqlParameter("@atAbility2", SqlDbType.Int,4),
new SqlParameter("@atAbility3", SqlDbType.Int,4),
new SqlParameter("@atAbility4", SqlDbType.Int,4),
new SqlParameter("@atAbility5", SqlDbType.Int,4),
new SqlParameter("@atAttitude1", SqlDbType.Int,4),
new SqlParameter("@atAttitude2", SqlDbType.Int,4),
new SqlParameter("@atAttitude3", SqlDbType.Int,4),
new SqlParameter("@atAttitude4", SqlDbType.Int,4),
new SqlParameter("@atAttitude5", SqlDbType.Int,4),
new SqlParameter("@atVeto1", SqlDbType.Int,4),
new SqlParameter("@atVeto2", SqlDbType.Int,4),
new SqlParameter("@atVeto3", SqlDbType.Int,4),
new SqlParameter("@atVeto4", SqlDbType.Int,4),
new SqlParameter("@atVeto5", SqlDbType.Int,4),
new SqlParameter("@atVetoOthers", SqlDbType.NVarChar,int.MaxValue),
new SqlParameter("@atComment", SqlDbType.NVarChar, 50)
};
parameters[0].Value = at[i].AtUserID;
parameters[1].Value = at[i].AtDep;
parameters[2].Value = at[i].AtDate;
parameters[3].Value = at[i].AtPass;
parameters[4].Value = at[i].AtKeyResponse1;
parameters[5].Value = at[i].AtKeyResponse2;
parameters[6].Value = at[i].AtKeyResponse3;
parameters[7].Value = at[i].AtKeyResponse4;
parameters[8].Value = at[i].AtKeyResponse5;
parameters[9].Value = at[i].AtKeyAbility1;
parameters[10].Value = at[i].AtKeyAbility2;
parameters[11].Value = at[i].AtKeyAbility3;
parameters[12].Value = at[i].AtKeyAbility4;
parameters[13].Value = at[i].AtKeyAbility5;
parameters[14].Value = at[i].AtKeyAttitude1;
parameters[15].Value = at[i].AtKeyAttitude2;
parameters[16].Value = at[i].AtKeyAttitude3;
parameters[17].Value = at[i].AtKeyAttitude4;
parameters[18].Value = at[i].AtKeyAttitude5;
parameters[19].Value = at[i].AtResponse1;
parameters[20].Value = at[i].AtResponse2;
parameters[21].Value = at[i].AtResponse3;
parameters[22].Value = at[i].AtResponse4;
parameters[23].Value = at[i].AtResponse5;
parameters[24].Value = at[i].AtAbility1;
parameters[25].Value = at[i].AtAbility2;
parameters[26].Value = at[i].AtAbility3;
parameters[27].Value = at[i].AtAbility4;
parameters[28].Value = at[i].AtAbility5;
parameters[29].Value = at[i].AtAttitude1;
parameters[30].Value = at[i].AtAttitude2;
parameters[31].Value = at[i].AtAttitude3;
parameters[32].Value = at[i].AtAttitude4;
parameters[33].Value = at[i].AtAttitude5;
parameters[34].Value = at[i].AtVeto1;
parameters[35].Value = at[i].AtVeto2;
parameters[36].Value = at[i].AtVeto3;
parameters[37].Value = at[i].AtVeto4;
parameters[38].Value = at[i].AtVeto5;
parameters[39].Value = at[i].AtVetoOthers;
parameters[40].Value = at[i].AtComment;
string exception = db.InsertExec(sql, parameters);
if (exception != "" && exception != null)
{
e = exception;
return false;
}
}
return true;
}
//更新通过,同时要更新User
public static bool Update1(Evaluator model, ref string e)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_Evaluator set ");
strSql.Append("pass=@pass");
strSql.Append(" where uiID=@uiID and EvaluatedID=@EvaluatedID");
SqlParameter[] parameters =
{
new SqlParameter("@pass", SqlDbType.Int,4),
new SqlParameter("@uiID", SqlDbType.VarChar,10),
new SqlParameter("@EvaluatedID",SqlDbType.VarChar,10)
};
parameters[0].Value = model.Pass;
parameters[1].Value = model.UiID;
parameters[2].Value = model.EvaluatedID;
//更新Evaluator表
e = db.QueryExec(strSql.ToString(), parameters);
if (e != "" && e != null)
{
return false;
}
//更新User表
if (model.Pass == 1)
{
List<User> users = new List<User>();
if (UserBLL.Select(model.UiID, ref users, ref e))
{
e = "";
User user = new Model.User();
user = users.ElementAt(0);
user.UType = user.UType.Remove(3, 1).Insert(3, "1");
if (!UserBLL.Update(user, ref e))
{
return false;
}
}
else
{
e = "";
User[] user = new User[1];
user[0] = new User();
user[0].UID = model.UiID;
user[0].UType = "00010";//考评者
if (!UserBLL.Insert(user, ref e))
{
return false;
}
}
if (e != "" && e != null)
{
return false;
}
}
else
{
List<Evaluator> evaluators = new List<Evaluator>();
if (EvaluatorBLL.Select1(ref evaluators, model.UiID, 1, ref e))
{
//更新User表，
string UID = model.UiID;
UserBLL.Delete(UID, ref e);
}
}
return true;
}
//搜索考评者
private bool searchEvaluator()
{
exception = "";
string username = (string)Session["username"];
//string username = "******";
string mDepart = "";
string evaluatedID = UserID.Value;
List<Manager> managers = new List<Manager>();
if (ManagerBLL.SelectByID(username, ref managers, ref exception))
{
mDepart = managers.ElementAt(0).MDepartment;
List<EvaluatorInfo> evi = new List<EvaluatorInfo>();
exception = "";
EvaluatorInfoBLL.SelectByDepartment(evi, mDepart, ref exception);
if (evi.Count <= 0)
return false;
DataTable table = new DataTable();
table = evi.ListToDataTable();
string json = JSON.DataTableToJson(table);
JsonEvaluator.Value = json;
return true;
}
else
return false;
}
private bool searchEvaluated()
{
exception = "";
string username = (string)Session["username"];
//string username = "******";
string uiDepart = "";
List<Manager> managers = new List<Manager>();
if (ManagerBLL.SelectByID(username, ref managers, ref exception))
{
uiDepart = managers.ElementAt(0).MDepartment;
Title.Text = uiDepart + "被考评人名单：";
List<UserInfo> Evaluated = new List<UserInfo>();
string type = "____1%";
bool b = UserInfoBLL.Select(uiDepart, type, ref Evaluated, ref exception);
if (b)
{
DataTable table = new DataTable();
table = Evaluated.ListToDataTable();
//给table增加Comment和Passed栏
adjustTable2(table, ref exception);
int sumCount = 0, unPassCount = 0, passCount = 0, unMakeCount = 0;
countNumber(table, ref sumCount, ref unPassCount, ref passCount, ref unMakeCount);//做汇总
//Title.Text += "（总人数：" + sumCount + " \\未制作：" + unMakeCount + " \\已保存：" + savedCount + " \\已提交：" + unPassCount + " \\已审核：" + passCount + "）";
Title.Text += "( 未制作：" + unMakeCount + ", 已提交：" + unPassCount + ", 已审核：" + passCount + ", 总人数：" + sumCount + " )";
table.DefaultView.Sort = "Passed desc"; //给table按状态排序
table = table.DefaultView.ToTable();
string json = JSON.DataTableToJson(table);
JsonData.Value = json;
return true;
}
else
{
Errors.Value = "本部门尚无被考评人！";
//
return false;
}
}
else
{
Errors.Value = "您无此操作权限！";
return false;
}
}