protected string getSubjectAverageXu(string _user_id, string _esn_id)
{
string strWhere = " User_id=" + _user_id + " AND Esn_id=" + _esn_id;
Model.CCOM.Examination_subject_average_score sub = new BLL.CCOM.Examination_subject_average_score().GetModel(strWhere);
string Xu = "";
if (sub != null)
{
Xu = ((decimal)(sub.Esas_sequence)).ToString("F2");
}
return(Xu);
}
protected string getSubjectAverageScore(string _user_id, string _esn_id)
{
string strWhere = " User_id=" + _user_id + " AND Esn_id=" + _esn_id;
Model.CCOM.Examination_subject_average_score subAvgScore = new BLL.CCOM.Examination_subject_average_score().GetModel(strWhere);
string score = "";
if (subAvgScore != null)
{
score = subAvgScore.Esas_score.ToString("F2");
}
return(score);
}
public bool DoAvgScore(Model.CCOM.Examination_subject_average_score _model)
{
try
{
BLL.CCOM.Examination_subject_average_score bll = new BLL.CCOM.Examination_subject_average_score();
var model = bll.GetModel(" Esn_id= " + _model.Esn_id + " AND User_id=" + _model.User_id);
if (model != null)
{
_model.Esas_id = model.Esas_id;
bll.Update(_model);
}
else
{
bll.Add(_model);
}
return(true);
}
catch
{
JscriptMsg("计算考生平均成绩出错", "", "Error");
return(false);
}
}
public bool calPreliminary(string subject_id)
{
try
{
decimal weights = 0;
string strWhere = " Fs_id=" + subject_id;
var subjectList = new BLL.CCOM.Subject().GetModelList(strWhere);
if (subjectList.Count > 0)
{
foreach (var model in subjectList)
{
weights += (decimal)(model.Subject_weight);
}
}
if (weights != 0)
{
strWhere = " Agency_id=" + this.ddlMajor.SelectedValue + " AND UP_calculation_status > 0";
var examineeList = new BLL.CCOM.View_GetExaminee().GetModelList(strWhere);
foreach (var model in examineeList)
{
long user_id = model.User_id;
decimal score = 0, xu = 0;
int num = 0;
foreach (var _model in subjectList)
{
var __model = new BLL.CCOM.Examination_subject_average_score().GetModel(" Esn_id=" + _model.Subject_id + " AND User_id=" + user_id);
if (__model != null)
{
num++;
score += (decimal)(__model.Esas_score * (_model.Subject_weight / weights));
if (__model.Esas_sequence != null)
{
xu += (decimal)(__model.Esas_sequence * (_model.Subject_weight / weights));
}
}
}
if (num > 0)
{
var model1 = new BLL.CCOM.Exam_firstin_subject().GetModel(" Esn_id=" + subject_id + " AND Major_id=" + this.major_id + " AND Period_id=" + period_id);
BLL.CCOM.Exam_firstin_subject_score bll2 = new BLL.CCOM.Exam_firstin_subject_score();
var model2 = bll2.GetModel(" Efs_id=" + model1.Efs_id + " AND User_id=" + user_id);
var _model2 = new Model.CCOM.Exam_firstin_subject_score();
if (model2 != null)
{
model2.Efs_id = model1.Efs_id;
model2.User_id = user_id;
model2.Efss_score = score;
if (xu != 0)
{
model2.Efss_sequence = xu;
}
else
{
model2.Efss_sequence = null;
}
bll2.Update(model2);
}
else
{
_model2.Efs_id = model1.Efs_id;
_model2.User_id = user_id;
_model2.Efss_score = score;
if (xu != 0)
{
_model2.Efss_sequence = xu;
}
else
{
_model2.Efss_sequence = null;
}
bll2.Add(_model2);
}
}
}
JscriptMsg("设置初试二轮科目成功", "SelectToPreliminary.aspx?fun_id=" + get_fun_id("CCOM/AEEManage/SelectToPreliminary.aspx"), "Success");
return(true);
}
else
{
JscriptMsg("总权重为零", "", "Error");
return(false);
}
}
catch
{
JscriptMsg("填加数据出错", "", "Error");
}
return(false);
}
public void ScoreManege()
{
string str = CombSqlTxt("");
BLL.CCOM.View_AEE_Subject_Score bll1 = new BLL.CCOM.View_AEE_Subject_Score();
var userModelList = bll1.GetModelList(str);
foreach (var user_model in userModelList)
{
string sqlStr = "SELECT DISTINCT Judge_id FROM Examination_subject_score WHERE Esn_id=" + esn_id + " AND User_id =" + user_model.User_id;
var judgeList = DBSQL.Query(sqlStr);
int _count = judgeList.Tables[0].Rows.Count;
string strWhere = " Esn_id= " + esn_id + " AND User_id=" + user_model.User_id + " order by Ess_score DESC";
var scoreList = new BLL.CCOM.Examination_subject_score().GetModelList(strWhere);
int score_count = scoreList.Count;
BLL.CCOM.Examination_subject_score blls = new BLL.CCOM.Examination_subject_score();
BLL.CCOM.Examination_subject_average_score bll = new BLL.CCOM.Examination_subject_average_score();
int now = 0;
int num = DelScore(_count);
int chushu = 0;
decimal avgScore = 0;
int? avgXu = 0;
foreach (var score_model in scoreList)
{
if (now > num - 1 && now < _count - num)
{
avgScore += score_model.Ess_score;
avgXu += score_model.Ess_sequence;
chushu++;
score_model.Ess_score_status = true;
score_model.Ess_order_status = true;
}
else
{
score_model.Ess_score_status = false;
score_model.Ess_order_status = false;
}
blls.Update(score_model);
if (now == _count - 1)
{
Model.CCOM.Examination_subject_average_score _model = new Model.CCOM.Examination_subject_average_score();
_model.Esas_score = avgScore / chushu;
_model.Esas_sequence = (decimal)(avgXu / (1.0 * chushu));
_model.User_id = score_model.User_id;
_model.Esn_id = score_model.Esn_id;
DoAvgScore(_model);
avgScore = 0;
avgXu = 0;
now = chushu = 0;
continue;
}
now++;
}
}
JscriptMsg("计算科目成绩成功", "SubjectScoreList.aspx?fun_id=" + DESEncrypt.Encrypt(this.fun_id) + "&keywords=" + this.txtKeywords.Text + "&esn_id=" + DESEncrypt.Encrypt(esn_id) + "&major_id=" + DESEncrypt.Encrypt(major_id), "Success");
}
