protected void SearchAssess_Click(object sender, EventArgs e)
{
var jser = new JavaScriptSerializer();
string exception = "";
//查询指标库，判断是否为空
string sql2 = "select * from tb_StanderLib";
List<StanderLib> sls = StanderLibBLL.Select(sql2, ref exception);
if (sls == null || sls.Count <= 0 || exception != "")
{
ClientScript.RegisterStartupScript(this.GetType(), "error", "f_alert('error','指标库为空！');", true);
return;
}
var json2 = jser.Serialize(sls);
JsonData2.Value = json2;
//根据ID查询考核表
string evaluatedID = UserID.Value;
AssessTable at = new AssessTable();
exception = "";
if (AssessTableBLL.Select(evaluatedID, ref at, ref exception))
{
//填写表头
LUserName.Text = UserName.Value;
if (at.AtPass == 1)
{
passYoN.Text = "已审核";
Comment.Text = "";
}
else
{
passYoN.Text = "未审核";
Comment.Text = at.AtComment;
}
LEStartEndTime.Text = UserStartTime.Value + " 至 " + UserStopTime.Value;
List<PostResponseBook> prbs = new List<PostResponseBook>();
exception = "";
if (PostResponseBookBLL.Select(evaluatedID, ref prbs, ref exception))
{
LEJobName.Text = prbs[0].PrbPostName;
LEDep.Text = prbs[0].PrbLaborDep;
LEUnit.Text = prbs[0].PrbLaborUnit;
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "error", "f_alert('error','被考评人岗位责任书尚未制定！');", true);
return;
}
List<AssessTable> ats = new List<AssessTable>();
ats.Add(at);
var json = jser.Serialize(ats);
json = "{\"Rows\":" + json + ",\"Total\":" + ats.Count + "}";
JsonData.Value = json;
ClientScript.RegisterStartupScript(this.GetType(), "fun", "ShowDetail();", true);
}
}
//查询考核表状态
//evaluatedID:被考评人ID
//考核表不存在，返回-1；考核表审核未通过，返回0；审核通过返回1
public static int GetAssessTableStatus(string evaluatedID)
{
if (evaluatedID == null || evaluatedID == "")
return -1;
AssessTable at = new AssessTable();
string e = "";
if (!Select(evaluatedID, ref at, ref e))
return -1; //考核表不存在
else
{
if (at.AtPass == 1)
return 1; //审核通过
else
return 0; //审核未通过
}
}
private void adjustTable(DataTable dt, ref string exception)
{
//给table添加prbComment栏
dt.Columns.Add("Comment");
dt.Columns.Add("Passed");
AssessTable assessTable = new AssessTable();
foreach (DataRow dr in dt.Rows)
{
if (AssessTableBLL.Select((string)dr["UiID"], ref assessTable, ref exception))
{
//0：已提交 1：已审核 2：未制作
dr["Comment"] = assessTable.AtComment;
if (assessTable.AtPass.ToString() == "1")
{
dr["Passed"] = "已审核";
}
else if (assessTable.AtPass.ToString() == "0")
{
dr["Passed"] = "未审核";
}
else
{
dr["Passed"] = "未制作";
}
}
else
{
dr["Comment"] = "";
dr["Passed"] = "未制作";
}
}
}
//根据ID获取考核表
protected void BGetEvaluateTable_Click(object sender, EventArgs e)
{
//转换数据
string data = JsonData.Value;
if (data == null || data == "")
{
ScriptManager.RegisterStartupScript(BGetEvaluateTable, this.GetType(), "", "f_alert('error','获取数据失败!');", true);
return;
}
userID = data;
//
if (standerLib == null)
{
//获取指标库
if (!LoadStanderLib())
{
ScriptManager.RegisterStartupScript(BGetEvaluateTable, this.GetType(), "fun", "f_alert('error','获取指标库数据失败，请重试！');", true);
return;
}
}
//获取考核表
//-1:未制作 0：未通过 1：已通过审核 2：已保存
int status = AssessTableBLL.GetAssessTableStatus(userID);
if (status == -1)
{
//获取岗位职责
if (!LoadResponseStander(userID))
{
ScriptManager.RegisterStartupScript(BGetEvaluateTable, this.GetType(), "fun", "f_alert('error','岗位责任书尚未制定，不能制定考核表！');", true);
return;
}
JsonData.Value = standerLib;
//制作考核表
ScriptManager.RegisterStartupScript(BGetEvaluateTable, this.GetType(), "", "MakeAssessTable();", true);
}
else if (status == 0)
{
//获取岗位职责
if (!LoadResponseStander(userID))
{
ScriptManager.RegisterStartupScript(BGetEvaluateTable, this.GetType(), "fun", "f_alert('error','岗位责任书尚未制定，不能制定考核表！');", true);
return;
}
//获取考核表
AssessTable at = new AssessTable();
if (!AssessTableBLL.Select(userID, ref at, ref exception))
{
ScriptManager.RegisterStartupScript(BGetEvaluateTable, this.GetType(), "fun", "f_alert('error','获取考核表数据失败，请重试！');", true);
return;
}
writeTableHead();
JsonData3.Value = JSON.ScriptSerialize<AssessTable>(at);
JsonData.Value = standerLib;
//制作考核表
ScriptManager.RegisterStartupScript(BGetEvaluateTable, this.GetType(), "", "EditAssessTable();", true);
}
else if (status == 1)
{
//获取考核表
AssessTable at = new AssessTable();
if (!AssessTableBLL.Select(userID, ref at, ref exception))
{
ScriptManager.RegisterStartupScript(BGetEvaluateTable, this.GetType(), "fun", "f_alert('error','获取考核表数据失败，请重试！');", true);
return;
}
writeTableHead1();
JsonData3.Value = JSON.ScriptSerialize<AssessTable>(at);
JsonData.Value = standerLib;
//制作考核表
ScriptManager.RegisterStartupScript(BGetEvaluateTable, this.GetType(), "", "ViewAssessTable();", true);
}
else
{
ScriptManager.RegisterStartupScript(BGetEvaluateTable, this.GetType(), "fun", "f_alert('error','获取数据失败，请重试！');", 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;
}
public static bool UpdateStander(AssessTable model, ref string e)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_AssessTable set ");
strSql.Append("atKeyResponse1=@atKeyResponse1,");
strSql.Append("atKeyResponse2=@atKeyResponse2,");
strSql.Append("atKeyResponse3=@atKeyResponse3,");
strSql.Append("atKeyResponse4=@atKeyResponse4,");
strSql.Append("atKeyResponse5=@atKeyResponse5,");
strSql.Append("atKeyAbility1=@atKeyAbility1,");
strSql.Append("atKeyAbility2=@atKeyAbility2,");
strSql.Append("atKeyAbility3=@atKeyAbility3,");
strSql.Append("atKeyAbility4=@atKeyAbility4,");
strSql.Append("atKeyAbility5=@atKeyAbility5,");
strSql.Append("atKeyAttitude1=@atKeyAttitude1,");
strSql.Append("atKeyAttitude2=@atKeyAttitude2,");
strSql.Append("atKeyAttitude3=@atKeyAttitude3,");
strSql.Append("atKeyAttitude4=@atKeyAttitude4,");
strSql.Append("atKeyAttitude5=@atKeyAttitude5,");
strSql.Append("atResponse1=@atResponse1,");
strSql.Append("atResponse2=@atResponse2,");
strSql.Append("atResponse3=@atResponse3,");
strSql.Append("atResponse4=@atResponse4,");
strSql.Append("atResponse5=@atResponse5,");
strSql.Append("atAbility1=@atAbility1,");
strSql.Append("atAbility2=@atAbility2,");
strSql.Append("atAbility3=@atAbility3,");
strSql.Append("atAbility4=@atAbility4,");
strSql.Append("atAbility5=@atAbility5,");
strSql.Append("atAttitude1=@atAttitude1,");
strSql.Append("atAttitude2=@atAttitude2,");
strSql.Append("atAttitude3=@atAttitude3,");
strSql.Append("atAttitude4=@atAttitude4,");
strSql.Append("atAttitude5=@atAttitude5,");
strSql.Append("atVeto1=@atVeto1,");
strSql.Append("atVeto2=@atVeto2,");
strSql.Append("atVeto3=@atVeto3,");
strSql.Append("atVeto4=@atVeto4,");
strSql.Append("atVeto5=@atVeto5,");
strSql.Append("atVetoOthers=@atVetoOthers,");
strSql.Append("atComment=@atComment ");
strSql.Append(" where atUserID=@atUserID");
SqlParameter[] parameters =
{
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),
new SqlParameter("@atUserID", SqlDbType.Int,4)
};
parameters[0].Value = model.AtKeyResponse1;
parameters[1].Value = model.AtKeyResponse2;
parameters[2].Value = model.AtKeyResponse3;
parameters[3].Value = model.AtKeyResponse4;
parameters[4].Value = model.AtKeyResponse5;
parameters[5].Value = model.AtKeyAbility1;
parameters[6].Value = model.AtKeyAbility2;
parameters[7].Value = model.AtKeyAbility3;
parameters[8].Value = model.AtKeyAbility4;
parameters[9].Value = model.AtKeyAbility5;
parameters[10].Value = model.AtKeyAttitude1;
parameters[11].Value = model.AtKeyAttitude2;
parameters[12].Value = model.AtKeyAttitude3;
parameters[13].Value = model.AtKeyAttitude4;
parameters[14].Value = model.AtKeyAttitude5;
parameters[15].Value = model.AtResponse1;
parameters[16].Value = model.AtResponse2;
parameters[17].Value = model.AtResponse3;
parameters[18].Value = model.AtResponse4;
parameters[19].Value = model.AtResponse5;
parameters[20].Value = model.AtAbility1;
parameters[21].Value = model.AtAbility2;
parameters[22].Value = model.AtAbility3;
parameters[23].Value = model.AtAbility4;
parameters[24].Value = model.AtAbility5;
parameters[25].Value = model.AtAttitude1;
parameters[26].Value = model.AtAttitude2;
parameters[27].Value = model.AtAttitude3;
parameters[28].Value = model.AtAttitude4;
parameters[29].Value = model.AtAttitude5;
parameters[30].Value = model.AtVeto1;
parameters[31].Value = model.AtVeto2;
parameters[32].Value = model.AtVeto3;
parameters[33].Value = model.AtVeto4;
parameters[34].Value = model.AtVeto5;
parameters[35].Value = model.AtVetoOthers;
parameters[36].Value = model.AtComment;
parameters[37].Value = model.AtUserID;
e = db.QueryExec(strSql.ToString(), parameters);
if (e != "" && e != null)
{
return false;
}
return true;
}
public static bool Select(string sql, ref List<AssessTable> model, ref string e)
{
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++)
{
AssessTable at = new AssessTable();
at.AtUserID = (string)table.Rows[i]["atUserID"];
at.AtDep = (string)table.Rows[i]["atDep"];
at.AtDate = (DateTime)table.Rows[i]["atDate"];
at.AtPass = (Int32)table.Rows[i]["atPass"];
if (!table.Rows[i]["atKeyResponse1"].Equals(DBNull.Value))
at.AtKeyResponse1 = (string)table.Rows[i]["atKeyResponse1"];
if (!table.Rows[i]["atKeyResponse2"].Equals(DBNull.Value))
at.AtKeyResponse2 = (string)table.Rows[i]["atKeyResponse2"];
if (!table.Rows[i]["atKeyResponse3"].Equals(DBNull.Value))
at.AtKeyResponse3 = (string)table.Rows[i]["atKeyResponse3"];
if (!table.Rows[i]["atKeyResponse4"].Equals(DBNull.Value))
at.AtKeyResponse4 = (string)table.Rows[i]["atKeyResponse4"];
if (!table.Rows[i]["atKeyResponse5"].Equals(DBNull.Value))
at.AtKeyResponse5 = (string)table.Rows[i]["atKeyResponse5"];
if (!table.Rows[i]["atKeyAbility1"].Equals(DBNull.Value))
at.AtKeyAbility1 = (Int32)table.Rows[i]["atKeyAbility1"];
if (!table.Rows[i]["atKeyAbility2"].Equals(DBNull.Value))
at.AtKeyAbility2 = (Int32)table.Rows[i]["atKeyAbility2"];
if (!table.Rows[i]["atKeyAbility3"].Equals(DBNull.Value))
at.AtKeyAbility3 = (Int32)table.Rows[i]["atKeyAbility3"];
if (!table.Rows[i]["atKeyAbility4"].Equals(DBNull.Value))
at.AtKeyAbility4 = (Int32)table.Rows[i]["atKeyAbility4"];
if (!table.Rows[i]["atKeyAbility5"].Equals(DBNull.Value))
at.AtKeyAbility5 = (Int32)table.Rows[i]["atKeyAbility5"];
if (!table.Rows[i]["atKeyAttitude1"].Equals(DBNull.Value))
at.AtKeyAttitude1 = (Int32)table.Rows[i]["atKeyAttitude1"];
if (!table.Rows[i]["atKeyAttitude2"].Equals(DBNull.Value))
at.AtKeyAttitude2 = (Int32)table.Rows[i]["atKeyAttitude2"];
if (!table.Rows[i]["atKeyAttitude3"].Equals(DBNull.Value))
at.AtKeyAttitude3 = (Int32)table.Rows[i]["atKeyAttitude3"];
if (!table.Rows[i]["atKeyAttitude4"].Equals(DBNull.Value))
at.AtKeyAttitude4 = (Int32)table.Rows[i]["atKeyAttitude4"];
if (!table.Rows[i]["atKeyAttitude5"].Equals(DBNull.Value))
at.AtKeyAttitude5 = (Int32)table.Rows[i]["atKeyAttitude5"];
if (!table.Rows[i]["atResponse1"].Equals(DBNull.Value))
at.AtResponse1 = (string)table.Rows[i]["atResponse1"];
if (!table.Rows[i]["atResponse2"].Equals(DBNull.Value))
at.AtResponse2 = (string)table.Rows[i]["atResponse2"];
if (!table.Rows[i]["atResponse3"].Equals(DBNull.Value))
at.AtResponse3 = (string)table.Rows[i]["atResponse3"];
if (!table.Rows[i]["atResponse4"].Equals(DBNull.Value))
at.AtResponse4 = (string)table.Rows[i]["atResponse4"];
if (!table.Rows[i]["atResponse5"].Equals(DBNull.Value))
at.AtResponse5 = (string)table.Rows[i]["atResponse5"];
if (!table.Rows[i]["atAbility1"].Equals(DBNull.Value))
at.AtAbility1 = (Int32)table.Rows[i]["atAbility1"];
if (!table.Rows[i]["atAbility2"].Equals(DBNull.Value))
at.AtAbility2 = (Int32)table.Rows[i]["atAbility2"];
if (!table.Rows[i]["atAbility3"].Equals(DBNull.Value))
at.AtAbility3 = (Int32)table.Rows[i]["atAbility3"];
if (!table.Rows[i]["atAbility4"].Equals(DBNull.Value))
at.AtAbility4 = (Int32)table.Rows[i]["atAbility4"];
if (!table.Rows[i]["atAbility5"].Equals(DBNull.Value))
at.AtAbility5 = (Int32)table.Rows[i]["atAbility5"];
if (!table.Rows[i]["atAttitude1"].Equals(DBNull.Value))
at.AtAttitude1 = (Int32)table.Rows[i]["atAttitude1"];
if (!table.Rows[i]["atAttitude2"].Equals(DBNull.Value))
at.AtAttitude2 = (Int32)table.Rows[i]["atAttitude2"];
if (!table.Rows[i]["atAttitude3"].Equals(DBNull.Value))
at.AtAttitude3 = (Int32)table.Rows[i]["atAttitude3"];
if (!table.Rows[i]["atAttitude4"].Equals(DBNull.Value))
at.AtAttitude4 = (Int32)table.Rows[i]["atAttitude4"];
if (!table.Rows[i]["atAttitude5"].Equals(DBNull.Value))
at.AtAttitude5 = (Int32)table.Rows[i]["atAttitude5"];
if (!table.Rows[i]["atVeto1"].Equals(DBNull.Value))
at.AtVeto1 = (Int32)table.Rows[i]["atVeto1"];
if (!table.Rows[i]["atVeto2"].Equals(DBNull.Value))
at.AtVeto2 = (Int32)table.Rows[i]["atVeto2"];
if (!table.Rows[i]["atVeto3"].Equals(DBNull.Value))
at.AtVeto3 = (Int32)table.Rows[i]["atVeto3"];
if (!table.Rows[i]["atVeto4"].Equals(DBNull.Value))
at.AtVeto4 = (Int32)table.Rows[i]["atVeto4"];
if (!table.Rows[i]["atVeto5"].Equals(DBNull.Value))
at.AtVeto5 = (Int32)table.Rows[i]["atVeto5"];
if (!table.Rows[i]["atVetoOthers"].Equals(DBNull.Value))
at.AtVetoOthers = (string)table.Rows[i]["atVetoOthers"];
if (!table.Rows[i]["atComment"].Equals(DBNull.Value))
at.AtComment = (string)table.Rows[i]["atComment"];
model.Add(at);
}
return true;
}
else
{
if (e != "" && e != null)
return false;
e = "该考核表尚未建立";
return false;
}
}
//根据被考评人ID查询考评表
//evaluaedID:被考评人ID;at:考核表对象；e:异常字符串；
//成功返回true.否则返回fasle;
public static bool Select(string evaluaedID, ref AssessTable at, ref string e)
{
if (evaluaedID == null || evaluaedID == "")
return false;
string sqlcmd = "select * from tb_AssessTable where atUserID='" + evaluaedID + "'";
List<AssessTable> ats = new List<AssessTable>();
if (!Select(sqlcmd, ref ats, ref e) || ats.Count == 0)
return false;
else
{
at = ats[0];
return true;
}
}
