public static bool Insert(EvaluatorTable model, ref string e)
        {
            string sql = "insert into tb_EvaluatorTable values("
                                + "@etEvaluatedID,@etEvaluateID,@etAssessTableID,@etEvaluationID,@etRelation,@etKey,@etResponse,@etAbility,@etAttitude,@etVeto,@etSum)";
            SqlParameter[] parameters =
            {
                new SqlParameter("@etEvaluatedID", SqlDbType.VarChar,10),
                new SqlParameter("@etEvaluateID",SqlDbType.VarChar,10),
                new SqlParameter("@etAssessTableID", SqlDbType.Int,4),
                new SqlParameter("@etEvaluationID", SqlDbType.Int,4),
                new SqlParameter("@etRelation", SqlDbType.VarChar,10),
                new SqlParameter("@etKey",SqlDbType.Float),
                new SqlParameter("@etResponse", SqlDbType.Float),
                new SqlParameter("@etAbility", SqlDbType.Float),
                new SqlParameter("@etAttitude", SqlDbType.Float),
                new SqlParameter("@etVeto",SqlDbType.Float),
                new SqlParameter("@etSum", SqlDbType.Float)

            };
            parameters[0].Value = model.EtEvaluatedID;
            parameters[1].Value = model.EtEvaluateID;
            parameters[2].Value = model.EtAssessTableID;
            parameters[3].Value = model.EtEvaluationID;
            parameters[4].Value = model.EtRelation;
            parameters[5].Value = model.EtKey;
            parameters[6].Value = model.EtResponse;
            parameters[7].Value = model.EtAbility;
            parameters[8].Value = model.EtAttitude;
            parameters[9].Value = model.EtVeto;
            parameters[10].Value = model.EtSum;

            string exception = db.InsertExec(sql, parameters);
            if (exception != "" && exception != null)
            {
                e = exception;
                return false;
            }
            return true;
        }
 //提交考评结果
 //成功返回true,否则返回false
 public static bool SubmitEvaluateResult(EvaluatorTable et)
 {
     if (et == null)
         return false;
     //获取EvaluationID
     string e = "";
     if (Insert(et, ref e))
         return true;
     else
         return false;
 }
        public static bool Update(EvaluatorTable model, ref string e)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update tb_EvaluatorTable set ");
            strSql.Append("etRelation=@etRelation,");
            strSql.Append("etKey=@etKey,");
            strSql.Append("etResponse=@etResponse,");
            strSql.Append("etAbility=@etAbility,");
            strSql.Append("etAttitude=@etAttitude,");
            strSql.Append("etVeto=@etVeto,");
            strSql.Append("etSum=@etSum");
            strSql.Append(" where etEvaluatedID=@etEvaluatedID and  etEvaluateID=@etEvaluateID");
            SqlParameter[] parameters =
            {
                    new SqlParameter("@etEvaluatedID", SqlDbType.VarChar,10),
                    new SqlParameter("@etEvaluateID",SqlDbType.VarChar,10),
                    new SqlParameter("@etRelation", SqlDbType.VarChar,10),
                    new SqlParameter("@etKey",SqlDbType.Float),
                    new SqlParameter("@etResponse", SqlDbType.Float),
                    new SqlParameter("@etAbility", SqlDbType.Float),
                    new SqlParameter("@etAttitude", SqlDbType.Float),
                    new SqlParameter("@etVeto",SqlDbType.Float),
                    new SqlParameter("@etSum", SqlDbType.Float)

                };
            parameters[0].Value = model.EtEvaluatedID;
            parameters[1].Value = model.EtEvaluateID;
            parameters[2].Value = model.EtRelation;
            parameters[3].Value = model.EtKey;
            parameters[4].Value = model.EtResponse;
            parameters[5].Value = model.EtAbility;
            parameters[6].Value = model.EtAttitude;
            parameters[7].Value = model.EtVeto;
            parameters[8].Value = model.EtSum;

            e = db.QueryExec(strSql.ToString(), parameters);
            if (e != "" && e != null)
            {
                return false;
            }
            return true;
        }
 public static bool Select(ref List<EvaluatorTable> 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++)
         {
             EvaluatorTable et = new EvaluatorTable();
             et.EtEvaluatedID = (string)table.Rows[i]["etEvaluatedID"];
             et.EtEvaluateID = (string)table.Rows[i]["etEvaluateID"];
             et.EtAssessTableID= (int)table.Rows[i]["etAssessTableID"];
             et.EtEvaluationID = (int)table.Rows[i]["etEvaluationID"];
             et.EtRelation = (string)table.Rows[i]["etRelation"];
             var test = table.Rows[i][4];
             et.EtKey = (float)Convert.ToDouble(table.Rows[i]["etKey"]);
             et.EtResponse = (float)Convert.ToDouble(table.Rows[i]["etResponse"]);
             et.EtAbility = (float)Convert.ToDouble(table.Rows[i]["etAbility"]);
             et.EtAttitude = (float)Convert.ToDouble(table.Rows[i]["etAttitude"]);
             et.EtVeto = (float)Convert.ToDouble(table.Rows[i]["etVeto"]);
             et.EtSum = (float)Convert.ToDouble(table.Rows[i]["etSum"]);
             model.Add(et);
         }
         return true;
     }
     else
     {
         if (e != "" && e != null)
             return false;
         e = "被考核者尚未被考核";
         return false;
     }
 }