public static bool Insert(Evaluator[] model, ref string e)
{
int count = model.Length;
for (int i = 0; i < count; i++)
{
string sql = "insert into tb_Evaluator values("
+ "@uiID,@EvaluatedID,@relation,@pass,@status)";
SqlParameter[] parameters =
{
new SqlParameter("@uiID", SqlDbType.VarChar,10),
new SqlParameter("@EvaluatedID",SqlDbType.VarChar,10),
new SqlParameter("@relation", SqlDbType.VarChar,10),
new SqlParameter("@pass", SqlDbType.Int,4),
new SqlParameter("@status", SqlDbType.Int,4)
};
parameters[0].Value = model[i].UiID;
parameters[1].Value = model[i].EvaluatedID;
parameters[2].Value = model[i].Relation;
parameters[3].Value = model[i].Pass;
parameters[4].Value = model[i].Status;
string exception = db.InsertExec(sql, parameters);
if (exception != "" && exception != null)
{
e = exception;
return false;
}
}
return true;
}
//退回,同时要更新User Userinfo
public static bool Update3(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("@uiID", SqlDbType.VarChar,10),
new SqlParameter("@EvaluatedID",SqlDbType.VarChar,10),
new SqlParameter("@relation", SqlDbType.VarChar,10),
new SqlParameter("@pass", SqlDbType.Int,4)
};
parameters[0].Value = model.UiID;
parameters[1].Value = model.EvaluatedID;
parameters[2].Value = model.Relation;
parameters[3].Value = model.Pass;
//查找Evaluator表，如果考评人姓名等于UiID只有一人，就更新user表
List<Evaluator> evaluators = new List<Evaluator>();
if (EvaluatorBLL.Select1(ref evaluators, model.UiID, 1, ref e))
{
//更新User表，
if (model.Pass == 0)
{
string UID = model.UiID;
UserBLL.Delete(UID, ref e);
}
}
//更新Evaluator表
e = db.QueryExec(strSql.ToString(), parameters);
if (e != "" && e != null)
{
return false;
}
return true;
}
//更新考评人名单
public static bool Update2(Evaluator model, ref string e)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_Evaluator set ");
strSql.Append("relation=@relation,");
strSql.Append("uiID=@uiID");
strSql.Append(" where EvaluatedID=@EvaluatedID and pass=@pass");
SqlParameter[] parameters =
{
new SqlParameter("@uiID", SqlDbType.VarChar,10),
new SqlParameter("@EvaluatedID",SqlDbType.VarChar,10),
new SqlParameter("@relation", SqlDbType.VarChar,10),
new SqlParameter("@pass", SqlDbType.Int,4),
};
parameters[0].Value = model.UiID;
parameters[1].Value = model.EvaluatedID;
parameters[2].Value = model.Relation;
parameters[3].Value = model.Pass;
e = db.QueryExec(strSql.ToString(), parameters);
if (e != "" && e != null)
{
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;
}
public static bool Select(ref List<Evaluator> 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++)
{
Evaluator evaluator = new Evaluator();
evaluator.UiID = (string)table.Rows[i][0];
evaluator.EvaluatedID = (string)table.Rows[i][1];
evaluator.Relation = (string)table.Rows[i][2];
evaluator.Pass = (int)table.Rows[i][3];
evaluator.Status = (int)table.Rows[i][4];
model.Add(evaluator);
}
return true;
}
else
{
if (e != "" && e != null)
return false;
e = "考评人名单尚未制定";
return false;
}
}
protected void Submit(object sender, EventArgs e)
{
exception = "";
string strData = JsonChose.Value;
List<tempui> userData = JSON.ScriptDeserialize<List<tempui>>(strData);
Evaluator[] model = new Evaluator[userData.Count];
for (int i = 0; i < userData.Count; i++)
{
tempui userinfo = new tempui();
userinfo = userData.ElementAt(i);
model[i] = new Evaluator();
model[i].UiID = userinfo.EvID;
model[i].EvaluatedID = UserID.Value;
model[i].Pass = 0;
model[i].Relation = userinfo.Relation;
}
if (EvaluatorBLL.Insert(model, ref exception))
{
Errors.Value = "提交成功！";
this.Chose.Value = "submit";
ClientScript.RegisterStartupScript(this.GetType(), "", "tanchuang()", true);
return;
}
else
{
if (exception != "" || exception != null)
{
Errors.Value = exception;
this.Chose.Value = "submit";
ClientScript.RegisterStartupScript(this.GetType(), "", "tanchuang()", true);
return;
}
}
}