protected int getMajorRetrialNum(string _major_id)
{
string strWhere = " Agency_id=" + _major_id + " AND UP_calculation_status > 2" + " AND Period_id=" + period_id;
var numModel = new BLL.CCOM.User_property().GetModelList(strWhere);
return(numModel.Count);
}
protected void ddlMajor_SelectedIndexChanged(object sender, EventArgs e)
{
string str1 = " Agency_id=" + major_id + " AND Period_id=" + period_id + " AND UP_calculation_status > 2";
var model1 = new BLL.CCOM.User_property().GetModelList(str1);
if (model1.Count > 0)
{
hasRetrial = false;
}
this.btnCalculation.Enabled = hasRetrial;
string order = "";
string strWhere = " Major_id=" + major_id + " AND Period_id=" + period_id;
BLL.CCOM.Exam_preliminary_subject bll = new BLL.CCOM.Exam_preliminary_subject();
var epsmodel = bll.GetModel(strWhere);
if (epsmodel != null)
{
int Esn_id = epsmodel.Esn_id;
subList = new BLL.CCOM.Subject().GetModelList(" Fs_id=" + Esn_id);
count = subList.Count;
}
order = "Epss_score DESC, Epss_sequence DESC ,UP_CCOM_number asc";
strWhere = CombSqlTxt(this.keywords);
try
{
RptBind(strWhere, order);
}
catch
{
JscriptMsg("获取考生成绩出错", "", "Error");
}
}
protected void ddlMajor_SelectedIndexChanged(object sender, EventArgs e)
{
string str1 = " Agency_id=" + major_id + " AND Period_id=" + period_id + " AND UP_calculation_status > 3";
var model1 = new BLL.CCOM.User_property().GetModelList(str1);
if (model1.Count > 0)
{
hasCEE = false;
}
this.btnCalculation.Enabled = hasCEE;
string order = "";
string strWhere = "";
order = "AEE_score DESC, AEE_sequence DESC ,UP_CCOM_number asc";
strWhere = CombSqlTxt(this.keywords);
try
{
RptBind(strWhere, order);
}
catch
{
JscriptMsg("获取考生成绩出错", "", "Error");
}
}
protected int getProvinceAdmissionNum(string _pro_id)
{
string strWhere = " UP_province=" + _pro_id + " AND UP_calculation_status > 4" + " AND Period_id=" + period_id;
var numModel = new BLL.CCOM.User_property().GetModelList(strWhere);
return(numModel.Count);
}
public string GetUserFace(string UserID)
{
BLL.CCOM.User_property bll = new BLL.CCOM.User_property();
String facePath = "";
try
{
Model.CCOM.User_property model = bll.GetModel(" User_id='" + UserID + "'");
facePath = model.UP_picture.Trim();
}
catch {
facePath = "/images/login/logo_left1.png";
}
if (facePath.Trim() != "" && facePath.Trim().StartsWith("http"))
{
return("<img style=\"width:48px;\" src=\"" + facePath.Trim() + "\" alt=\"\" />");
}
else
{
if (facePath.Trim() != "")
{
return("<img style=\"width:48px;\" src=\"" + DataDic.FILE_URL + facePath.Trim() + "\" alt=\"\" />");
}
else
{
return("<img style=\"width:48px;\" src=\"/images/login/logo_left1.png\" alt=\"\" />");
}
}
}
protected void btnCalculationScore_Click(object sender, EventArgs e)
{
string strWhere = " Agency_id= " + major_id + " order by User_id"; //获取当前计算考生列表
var userList = new BLL.CCOM.User_property().GetModelList(strWhere);
int user_count = userList.Count;
ScoreManege();
}
//获取机构
protected string GetAgency(int user_id)
{
var model = new BLL.CCOM.User_property().GetModel(" User_id=" + user_id);
if (model != null)
{
return(new BLL.CCOM.Agency().GetModel(model.Agency_id).Agency_name);
}
return("---");
}
protected void BindAllSubject()
{
userId = GetAdminInfo_CCOM().User_id;
BLL.CCOM.User_property pbll = new BLL.CCOM.User_property();
Model.CCOM.User_property pmodel = pbll.GetModel("User_id=" + userId);
int majorId = pmodel.Agency_id;
//科目字典
BLL.CCOM.Subject bll = new BLL.CCOM.Subject();
try
{
List <Model.CCOM.Subject> subjectList = bll.GetModelList("Major_Agency_id=" + majorId);
foreach (Model.CCOM.Subject subject in subjectList)
{
subjectDic.Add(subject.Subject_id, subject);
}
}
catch (Exception e)
{
return;
}
//旧值字典
BLL.CCOM.User_subject_value vbll = new BLL.CCOM.User_subject_value();
try
{
List <Model.CCOM.User_subject_value> valueList = vbll.GetModelList("User_id=" + GetAdminInfo_CCOM().User_id);
foreach (Model.CCOM.User_subject_value value in valueList)
{
if (!oldDic.ContainsKey(value.Subject_id))
{
oldDic.Add(value.Subject_id, new Dictionary <int, Model.CCOM.User_subject_value>());
}
if (value.Usv_children == null)
{
oldDic[value.Subject_id].Add(0, value);
}
else
{
oldDic[value.Subject_id].Add((int)value.Usv_children, value);
}
}
}
catch (Exception e)
{
return;
}
root = bll.GetModel("Major_Agency_id=" + majorId + "and Subject_level=0");
foreach (Model.CCOM.Subject Cmodel in subjectDic.Values)
{
if (Cmodel.Fs_id == root.Subject_id)
{
BindTest(Cmodel);
}
}
}
protected string getMajorNum(string _major_id)
{
string strWhere = " Agency_id=" + _major_id + " AND Period_id=" + period_id + " AND UP_calculation_status > 0";
var user_modellist = new BLL.CCOM.User_property().GetModelList(strWhere);
string num = "";
if (user_modellist != null)
{
num = user_modellist.Count.ToString();
}
return(num);
}
protected string getMajorRetrial(string _major_id)
{
string strWhere = " Agency_id=" + _major_id + " AND UP_calculation_status > 2" + " AND Period_id=" + period_id;
var numModel = new BLL.CCOM.User_property().GetModelList(strWhere);
var allnumModel = new BLL.CCOM.User_property().GetModelList(" Agency_id=" + _major_id + " AND UP_calculation_status > 0" + " AND Period_id=" + period_id);
if (allnumModel.Count == 0)
{
return("");
}
int wid = (int)(numModel.Count * 1.0 / allnumModel.Count * 100);
string txt = "<div style='width:" + wid + "px;height:14px;background:blue;margin-right:6px;float:left;'></div> ";
return(txt + (numModel.Count * 1.0 / allnumModel.Count * 100).ToString("F2") + "%");
}
protected void setAgencyDetail()
{
Model.CCOM.User_property model = new BLL.CCOM.User_property().GetModel(" User_id='" + GetAdminInfo_CCOM().User_id + "'");
Model.CCOM.Major major_model = new BLL.CCOM.Major().GetModel(" Agency_id='" + model.Agency_id + "'");
if (major_model == null)
{
this.Details.InnerHtml = ("<asp:Label runat=\"server\" Style=\"color: green; font-size: 13px;\" ID=\"lblTip\">无</asp:Label><br/>");
}
else
{
this.Details.InnerHtml = this.Details.InnerHtml + ("<asp:Label runat=\"server\" Style=\"color: green; font-size: 13px;\" ID=\"lblTip\">学制：" + major_model.Major_academic + "</asp:Label><br/>");
this.Details.InnerHtml = this.Details.InnerHtml + ("<asp:Label runat=\"server\" Style=\"color: green; font-size: 13px;\" ID=\"lblTip\">专业要求：" + major_model.Major_require + "</asp:Label><br/>");
this.Details.InnerHtml = this.Details.InnerHtml + ("<asp:Label runat=\"server\" Style=\"color: green; font-size: 13px;\" ID=\"lblTip\">专业参考书目：" + major_model.Major_reference + "</asp:Label><br/>");
this.Details.InnerHtml = this.Details.InnerHtml + ("<asp:Label runat=\"server\" Style=\"color: green; font-size: 13px;\" ID=\"lblTip\">备注：" + major_model.Major_remark + "</asp:Label><br/>");
}
}
public string GetAgency(string UserID)
{
BLL.CCOM.User_property bll = new BLL.CCOM.User_property();
string str = string.Empty;
try
{
Model.CCOM.User_property model = bll.GetModel(" User_id='" + UserID + "'");
str = new BLL.CCOM.Agency().GetModel((int)model.Agency_id).Agency_name;
}
catch
{
str = "未设置";
}
return(str);
}
public string GetPolitics(string UserID)
{
BLL.CCOM.User_property bll = new BLL.CCOM.User_property();
string str = string.Empty;
try
{
Model.CCOM.User_property model = bll.GetModel(" User_id='" + UserID + "'");
str = new BLL.CCOM.Politics().GetModel((int)model.UP_politics).Politics_name;
}
catch
{
str = "未设置";
}
return(str);
}
public string GetExamNumber(string UserID)
{
BLL.CCOM.User_property bll = new BLL.CCOM.User_property();
string str = string.Empty;
try
{
Model.CCOM.User_property model = bll.GetModel(" User_id='" + UserID + "'");
str = model.UP_CEE_number;
}
catch
{
str = "未设置";
}
return(str);
}
//学生联系方式
public void bllStuInfo(long SchoolUserID)
{
Model.CCOM.User_infomation user_model = new BLL.CCOM.User_infomation().GetModel(id);
Model.CCOM.User_property userEx_model = new BLL.CCOM.User_property().GetModel(" User_id=" + id);
if (userEx_model != null)
{
if (userEx_model.UP_province != null && userEx_model.UP_province > 0)
{
this.lblOrigin.Text = new BLL.CCOM.Province().GetModel((int)userEx_model.UP_province).Province_name.Trim();
}
this.lblAddress.Text = userEx_model.UP_address.Trim();
this.lblPhoneNumber.Text = userEx_model.UP_PE_Aphone.Trim();
this.lblykPhoneNumber.Text = userEx_model.UP_PE_Iphone.Trim();
this.lblZipCode.Text = userEx_model.UP_postal_code.Trim();
this.lblAddressee.Text = userEx_model.UP_receiver.Trim();
this.lblAddresseeNumber.Text = userEx_model.UP_receiver_phone.Trim();
}
}
protected void Page_Load(object sender, EventArgs e)
{
//获取SchoolUserID
try
{
Model.CCOM.User_infomation user_model = new BLL.CCOM.User_infomation().GetModel(GetAdminInfo_CCOM().User_id);
Model.CCOM.User_property userEx_model = new BLL.CCOM.User_property().GetModel(" User_id='" + GetAdminInfo_CCOM().User_id + "'");
this.id = user_model.User_id;
//if (user_model.User_type == 6)
//{
// JscriptMsg("只有考生用户可以报考！", "back", "Error");
// return;
//}
Model.CCOM.Period period_model = new BLL.CCOM.Period().GetModel(" Period_state=1");
if (period_model == null)
{
JscriptMsg("目前尚未开启报名！", "back", "Error");
return;
}
else if (userEx_model.Period_id != period_model.Period_id)
{
JscriptMsg("您所处周期不在当前报名周期内！", "back", "Error");
return;
}
else if (period_model.Period_register_start > DateTime.Now)
{
JscriptMsg("尚未开启报考！", "back", "Error");
return;
}
}
catch
{
Response.Redirect("/adminmetro/center.aspx");
}
if (!Page.IsPostBack)
{
bllBasicInfo(id);
bllNatureInfo(id);
bllStuInfo(id);
MemberBing(id);
checkIsPay();
setAgencyDetail();
}
}
protected void btnSelectRetrial_Click(object sender, EventArgs e)
{
if (hasPrelimary == false)
{
JscriptMsg("已添加初试二轮名单", "", "Error");
return;
}
string order = "Epss_score DESC, Epss_sequence DESC ,UP_CCOM_number asc";
string strWhere = CombSqlTxt(this.keywords);
try
{
//var bll = new BLL.CCOM.View_Preliminary_Score();
//List<Model.CCOM.View_Preliminary_Score> modelList = bll.GetModelList(strWhere + " order by " + order);
var bll = new BLL.CCOM.User_property();
//增加只导出选择部分学生的功能
string name = "";
for (int i = 0; i < rptList.Items.Count; i++)
{
CheckBox cb = (CheckBox)rptList.Items[i].FindControl("chkId");
if (cb.Checked == true)
{
HiddenField hf = (HiddenField)rptList.Items[i].FindControl("hidChkId");
string _user_id = hf.Value;
var model = new BLL.CCOM.User_property().GetModel(" User_id=" + _user_id + " AND Period_id=" + period_id);
model.UP_calculation_status = 2;
bll.Update(model);
name += model.UP_CCOM_number + ", ";
}
}
if (name == "")
{
JscriptMsg("请勾选进入初试二轮名单", "", "Error");
return;
}
JscriptMsg("已添加初试二轮名单：" + name + "", "SelectToPreliminary.aspx?fun_id=" + DESEncrypt.Encrypt(this.fun_id) + "&keywords=" + this.txtKeywords.Text + "&major_id=" + DESEncrypt.Encrypt(this.major_id), "Success");
}
catch
{
JscriptMsg("添加初试二轮名单出错", "", "Success");
}
}
protected void OnClickNextStep(object sender, EventArgs e)
{
//添加验证信息是否齐全
Model.CCOM.User_infomation user_model = new BLL.CCOM.User_infomation().GetModel(GetAdminInfo_CCOM().User_id);
Model.CCOM.User_property userEx_model = new BLL.CCOM.User_property().GetModel(" User_id=" + user_model.User_id);
//if (user_model.User_ID_number_type == null || user_model.User_ID_number_type < 1)
//{
// JscriptMsg("请填加证件类型！", "", "Error");
// return;
//}
//if (user_model.User_ID_number == null || user_model.User_ID_number == "")
//{
// JscriptMsg("请填写证件号码！", "", "Error");
// return;
//}
if (userEx_model == null)
{
JscriptMsg("请完善用户信息！", "", "Error");
return;
}
if (userEx_model.UP_ID_picture == null || userEx_model.UP_ID_picture == "")
{
JscriptMsg("请上传证件照片！", "", "Error");
return;
}
if (userEx_model.UP_picture == null || userEx_model.UP_picture == "")
{
JscriptMsg("请上传近期免冠照片！", "", "Error");
return;
}
if (userEx_model.UP_AEE_number == null || userEx_model.UP_AEE_number == "")
{
JscriptMsg("请填写省艺术联考考生号！", "", "Error");
return;
}
if (userEx_model.UP_AEE_picture == null || userEx_model.UP_AEE_picture == "")
{
JscriptMsg("请上传省艺术联考合格证！", "", "Error");
return;
}
//跳转到第三步
JscriptMsg("证件上传成功！", Utils.CombUrlTxt("StudentApply3.aspx", "fun_id={0}", DESEncrypt.Encrypt(this.fun_id)), "Success");
}
protected void showStudentInfo()
{
BLL.CCOM.User_information ubll = new BLL.CCOM.User_information();
BLL.CCOM.User_property pbll = new BLL.CCOM.User_property();
List <Model.CCOM.Examination_arrangement_detail> EadList = new BLL.CCOM.Examination_arrangement_detail().GetModelList(" Ea_id=" + examId);
int num = 0;
TableRow studentRow = new TableRow();
foreach (Model.CCOM.Examination_arrangement_detail EadModel in EadList)
{
num++;
var umodel = ubll.GetModel(EadModel.User_id);
var pmodel = pbll.GetModel("User_id=" + EadModel.User_id);
TableCell studentCell = new TableCell();
studentCell.HorizontalAlign = HorizontalAlign.Center;
studentRow.Cells.Add(studentCell);
Image upPicture = new Image();
upPicture.ImageUrl = "../../.." + pmodel.UP_picture;
upPicture.Width = 60;
studentCell.Controls.Add(upPicture);
Panel panel1 = new Panel();
studentCell.Controls.Add(panel1);
Label upCcomNum = new Label();
upCcomNum.Text = pmodel.UP_CCOM_number;
panel1.Controls.Add(upCcomNum);
Panel panel2 = new Panel();
studentCell.Controls.Add(panel2);
Label name = new Label();
name.Text = umodel.User_realname;
panel2.Controls.Add(name);
if (num % 6 == 0)
{
studentTable.Rows.Add(studentRow);
studentRow = new TableRow();
}
}
if (num % 6 != 0)
{
studentTable.Rows.Add(studentRow);
}
}
private void GetSelectedUserCount(HttpContext context)
{
string deptList = context.Request.Params["deptList"];
string groupList = context.Request.Params["groupList"];
string userList = context.Request.Params["userList"];
List<string> userIdList = new List<string>();
if(!string.IsNullOrEmpty(deptList))
{
var list = deptList.Split(',').ToList();
}
if(!string.IsNullOrEmpty(groupList))
{
var list = groupList.Split(',').ToList();
var bll = new BLL.CCOM.User_property();
for(int i=0;i<list.Count;i++)
{
var modelList = bll.GetModelList(" Agency_id=" + list[i]);
for(int j=0;j<modelList.Count;j++)
{
if(!userIdList.Contains(modelList[j].User_id.ToString()))
{
userIdList.Add(modelList[j].User_id.ToString());
}
}
}
}
if(!string.IsNullOrEmpty(userList))
{
var list = userList.Split(',').ToList();
for(int i=0;i<list.Count;i++)
{
if(!userIdList.Contains(list[i]))
{
userIdList.Add(list[i]);
}
}
}
FlushResponse(context, JsonConvert.SerializeObject(new ReturnObject() { Result = OK, Msg = userIdList.Count.ToString() }));
//context.Response.Write(count);
}
//自然属性基础信息
public void bllNatureInfo(long SchoolUserID)
{
Model.CCOM.User_infomation user_model = new BLL.CCOM.User_infomation().GetModel(id);
Model.CCOM.User_property userEx_model = new BLL.CCOM.User_property().GetModel(" User_id=" + id);
this.lblRealName.Text = user_model.User_realname.Trim();
if (user_model.User_gender == true)
{
this.lblSex.Text = "女";
}
else if (user_model.User_gender == false)
{
this.lblSex.Text = "男";
}
this.lblBirthday.Text = Convert.ToDateTime(user_model.User_birthday).ToString("yyyy-MM-dd");
if (userEx_model != null)
{
if (userEx_model.Agency_id != null && userEx_model.Agency_id > 0)
{
this.lblDirection.Text = new BLL.CCOM.Agency().GetModel(userEx_model.Agency_id).Agency_name.Trim();
}
if (userEx_model.UP_nationality != null && userEx_model.UP_nationality > 0)
{
this.lblNationality.Text = new BLL.CCOM.Nationality().GetModel((int)userEx_model.UP_nationality).Nationality_name.Trim();
}
if (userEx_model.UP_nation != null && userEx_model.UP_nation > 0)
{
this.lblNation.Text = new BLL.CCOM.Nation().GetModel((int)userEx_model.UP_nation).Nation_name.Trim();
}
this.lblOverSeas.Text = userEx_model.UP_overseas ? "是" : "否";
if (userEx_model.UP_degree != null && userEx_model.UP_degree > 0)
{
this.lblDegree.Text = new BLL.CCOM.Degree().GetModel((int)userEx_model.UP_degree).Degree_name.Trim();
}
if (userEx_model.UP_politics != null && userEx_model.UP_politics > 0)
{
this.lblPolitical.Text = new BLL.CCOM.Politics().GetModel((int)userEx_model.UP_politics).Politics_name.Trim();
}
this.lblSeniorSchool.Text = userEx_model.UP_high_school.Trim();
this.lblExaminationID.Text = userEx_model.UP_CEE_number.Trim();
}
}
public string getUserDetail(string _user_id)
{
string str = "";
var model = new BLL.CCOM.User_property().GetModel("User_id=" + _user_id + " AND Period_id=" + period_id);
if (model != null)
{
str += "<td align=\"center\">" + model.UP_CEE_number + "</td>";
str += "<td align=\"center\">" + GetAgencyName(model.Agency_id.ToString()) + "</td>";
str += "<td align=\"center\">" + GetProvinceName(model.UP_province.ToString()) + "</td>";
str += "<td align=\"center\">" + model.UP_high_school + "</td>";
}
else
{
str += "<td align=\"center\"></td>";
str += "<td align=\"center\"></td>";
str += "<td align=\"center\"></td>";
str += "<td align=\"center\"></td>";
}
return(str);
}
protected void showStudentInfo()
{
BLL.CCOM.User_information ubll = new BLL.CCOM.User_information();
BLL.CCOM.User_property pbll = new BLL.CCOM.User_property();
List <Model.CCOM.Examination_arrangement_detail> EadList = new BLL.CCOM.Examination_arrangement_detail().GetModelList(" Ea_id=" + examId);
int num = 0;
foreach (Model.CCOM.Examination_arrangement_detail EadModel in EadList)
{
TableRow studentRow = new TableRow();
studentTable.Rows.Add(studentRow);
var umodel = ubll.GetModel(EadModel.User_id);
var pmodel = pbll.GetModel("User_id=" + EadModel.User_id);
TableCell numCell = new TableCell();
numCell.HorizontalAlign = HorizontalAlign.Center;
studentRow.Cells.Add(numCell);
TableCell idCell = new TableCell();
idCell.HorizontalAlign = HorizontalAlign.Center;
studentRow.Cells.Add(idCell);
TableCell nameCell = new TableCell();
nameCell.HorizontalAlign = HorizontalAlign.Center;
studentRow.Cells.Add(nameCell);
TableCell scoreCell = new TableCell();
scoreCell.HorizontalAlign = HorizontalAlign.Center;
studentRow.Cells.Add(scoreCell);
TableCell chapterCell = new TableCell();
studentRow.Cells.Add(chapterCell);
Label numLabel = new Label();
numLabel.Text = (++num).ToString();
numCell.Controls.Add(numLabel);
Label upCcomNum = new Label();
upCcomNum.Text = pmodel.UP_CCOM_number;
idCell.Controls.Add(upCcomNum);
Label name = new Label();
name.Text = umodel.User_realname;
nameCell.Controls.Add(name);
Label chapter = newChapterLabel(umodel.User_id);
chapterCell.Controls.Add(chapter);
}
}
//计算选中的推送用户数
private int GetTotalUserCount(List <string> deptIdList, List <string> groupIdList, List <string> userIdList, Hashtable nameNodeList)
{
//list参数是引用传递，会影响原来的值，不能直接加入到userIdList
List <string> idList = new List <string>(userIdList);
var period = new BLL.CCOM.Period().GetModel(" Period_state=1");
//加入机构列表包含的所有UserId
if (deptIdList != null && deptIdList.Count > 0)
{
}
//加入通讯组列表包含的所有UserId
if (groupIdList != null && groupIdList.Count > 0)
{
for (int i = 0; i < groupIdList.Count; i++)
{
var model_list = new BLL.CCOM.User_property().GetModelList(" Agency_id=" + groupIdList[i] + " and Period_id=" + period.Period_id);
if (model_list != null && model_list.Count > 0)
{
for (int j = 0; j < model_list.Count; j++)
{
if (!userIdList.Contains(model_list[j].User_id.ToString()))
{
idList.Add(model_list[j].User_id.ToString());
userIdList.Add(model_list[j].User_id.ToString());
var _model = new BLL.CCOM.User_information().GetModel("User_id=" + model_list[j].User_id);
if (_model != null)
{
string realname = _model.User_realname;
nameNodeList.Add(USER_TYPE + "|" + model_list[j].User_id, realname);
}
}
}
}
}
}
return(idList.Count);
}
protected void checkIsPay()
{
Model.CCOM.User_property userEx_model = new BLL.CCOM.User_property().GetModel(" User_id='" + GetAdminInfo_CCOM().User_id + "'");
Model.CCOM.Period period_model = new BLL.CCOM.Period().GetModel(" Period_state=1");
if (userEx_model.UP_calculation_status == 0)
{
this.deps.InnerHtml = this.deps.InnerHtml + ("<asp:Label runat=\"server\" Style=\"color: red; font-size: 13px;\" ID=\"lblTip\">报名状态：未报名</asp:Label><br/>");
}
else if (userEx_model.UP_calculation_status == 1)
{
this.deps.InnerHtml = this.deps.InnerHtml + ("<asp:Label runat=\"server\" Style=\"color: green; font-size: 13px;\" ID=\"lblTip\">缴费状态：已缴费成功</asp:Label><br/>");
}
else
{
this.deps.InnerHtml = this.deps.InnerHtml + ("<asp:Label runat=\"server\" Style=\"color: green; font-size: 13px;\" ID=\"lblTip\">缴费状态：已缴费成功</asp:Label><br/>");
}
this.deps.InnerHtml = this.deps.InnerHtml + ("<asp:Label runat=\"server\" Style=\"color: red; font-size: 13px;\" ID=\"lblTip\">报考时间结束后不可更改信息，报名结束时间：" + period_model.Period_register_end + "</asp:Label><br/>");
if (period_model.Period_register_end < DateTime.Now)
{
this.deps.InnerHtml = ("<asp:Label runat=\"server\" Style=\"color: red; font-size: 13px;\" ID=\"lblTip\">报名已结束</asp:Label><br/>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
//获取SchoolUserID
try
{
Model.CCOM.User_infomation user_model = new BLL.CCOM.User_infomation().GetModel(GetAdminInfo_CCOM().User_id);
this.id = user_model.User_id;
//if (user_model.User_type == 6)
//{
// JscriptMsg("只有考生用户可以报考！", "back", "Error");
// return;
//}
Model.CCOM.User_property userEx_model = new BLL.CCOM.User_property().GetModel(" User_id=" + id);
}
catch
{
Response.Redirect("/adminmetro/center.aspx");
}
if (!Page.IsPostBack)
{
bllBasicInfo(id);
}
}
protected string CombSqlTxt(string _keywords)
{
if (Tools.CheckParams(_keywords))
{
return(" 1=0 ");
}
StringBuilder strTemp = new StringBuilder();
//搜索关键字
_keywords = _keywords.Trim();
if (!_keywords.Equals(""))
{
strTemp.Append(" (User_realname like '%" + _keywords + "%'");
strTemp.Append(" or UP_CCOM_number= '" + _keywords + "')");
}
else
{
strTemp.Append(" 1=1 ");
}
strTemp.Append(" AND Period_id=" + period_id + " AND Major_id=" + major_id);
var hasSecondTry = new BLL.CCOM.User_property().GetModelList(" Agency_id=" + major_id + " AND UP_calculation_status = 2");
if (hasSecondTry.Count > 0)
{
strTemp.Append(" AND UP_calculation_status > 1");
}
else
{
strTemp.Append(" AND UP_calculation_status > 0");
}
return(strTemp.ToString());
}
//证件照
public void bllBasicFace(long SchoolUserID)
{
string photoUrl = "";
Model.CCOM.User_infomation user_model = new BLL.CCOM.User_infomation().GetModel(id);
Model.CCOM.User_property userEx_model = new BLL.CCOM.User_property().GetModel(" User_id=" + id);
try
{
photoUrl = userEx_model.UP_picture;
}
catch (Exception)
{
photoUrl = "";
}
if (photoUrl == null || photoUrl == "")
{
photoUrl = DataDic.FILE_URL + "images/login/logo_left1.png";
}
else if (!photoUrl.StartsWith("http"))
{
photoUrl = DataDic.FILE_URL + photoUrl;
}
this.lblFace.Text = "<img style='height:100px;' src=\"" + photoUrl + "\" alt=\"近期免冠照\" title=\"近期免冠照\" />";
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
string phoneNumber = this.txtPhoneNumber.Text.Trim();
string password = this.txtUserPwd.Text.Trim();
string password_confer = this.txtUser_pasword_confer.Text.Trim();
if (phoneNumber.Length <= 0)
{
lblTip.Visible = true;
lblTip.Text = "请填写手机号";
return;
}
if (phoneNumber.Length > 14 || !IsNumber(phoneNumber))
{
lblTip.Visible = true;
lblTip.Text = "请正确填写手机号";
return;
}
if (Tools.CheckParams(phoneNumber))
{
lblTip.Visible = true;
lblTip.Text = "手机号包含非法字符，请修改";
return;
}
//查询数据库中是否已经注册过
BLL.CCOM.User_infomation bll = new BLL.CCOM.User_infomation();
if (bll.GetRecordCount(" User_mobile='" + phoneNumber + "'") > 0)
{
lblTip.Visible = true;
lblTip.Text = "该账号已被注册";
return;
}
if (password.Length <= 0)
{
lblTip.Visible = true;
lblTip.Text = "请填写密码";
return;
}
if (password.Length < 6 || password.Length > 16 || !IsNumAndEnCh(password))
{
lblTip.Visible = true;
lblTip.Text = "请正确填写密码";
return;
}
if (Tools.CheckParams(password))
{
lblTip.Visible = true;
lblTip.Text = "密码包含非法字符，请修改";
return;
}
if (!password.Equals(password_confer))
{
lblTip.Visible = true;
lblTip.Text = "密码前后不一，请确认";
return;
}
if (Session[MyKeys.SESSION_PHONE_CODE] == null)
{
lblTip.Visible = true;
lblTip.Text = "请获取手机验证码";
return;
}
if (Session[MyKeys.SESSION_PHONE_CODE].ToString() != this.txtSmsCode.Text)
{
lblTip.Visible = true;
lblTip.Text = "手机验证码不正确";
return;
}
BLL.CCOM.Period period_bll = new BLL.CCOM.Period();
int open_year = DateTime.Now.Year;
var period_model = period_bll.GetModel(" Period_state=1");
if (period_model != null)
{
try
{
open_year = int.Parse(period_model.Period_year);
}
catch
{
}
}
else
{
lblTip.Visible = true;
lblTip.Text = "当前暂未开启注册";
return;
}
Model.CCOM.User_infomation UserModel = new Model.CCOM.User_infomation();
UserModel.User_mobile = phoneNumber;
UserModel.User_password = DESEncrypt.MD5Encrypt(password);
UserModel.User_type = 1; //默认为大陆考生
UserModel.User_status = true; //默认为启用状态
UserModel.User_addtime = DateTime.Now;
UserModel.User_gender = false; //默认为男
UserModel.User_realname = "请填写姓名";
BLL.CCOM.User_infomation user_bll = new BLL.CCOM.User_infomation();
long _id = user_bll.Add(UserModel);//这里不知为什么返回值不是User_id;
if (_id > 0)
{
//鉴于上述问题，这里重新查询User_id;
DataTable user_table = user_bll.GetList(1, "", " User_id DESC").Tables[0];
_id = long.Parse(user_table.Rows[0]["User_id"].ToString());
lblTip.Visible = false;
BLL.CCOM.User_property User_property_bll = new BLL.CCOM.User_property();
Model.CCOM.User_property User_property_model = new Model.CCOM.User_property();
User_property_model.User_id = _id;
User_property_model.Period_id = period_bll.GetModel(" Period_year=" + open_year).Period_id;
BLL.CCOM.Temp_record temp_record_bll = new BLL.CCOM.Temp_record();
var temp_record_model = temp_record_bll.GetModel(" Period_year=" + open_year);
//临时表中无该年度记录，则需创建该年度记录
if (temp_record_model == null)
{
string last_record = open_year + "B" + "0001";
Model.CCOM.Temp_record record_model = new Model.CCOM.Temp_record();
record_model.Last_CCOM_number = last_record;
record_model.Period_year = open_year + "";
DataTable table = User_property_bll.GetList(1, "", "UP_id DESC").Tables[0];
if (table != null && table.Rows.Count > 0)
{
DataRow dr = table.Rows[0];
last_record = dr["UP_CCOM_number"].ToString();
record_model.Last_CCOM_number = open_year + "B" + (int.Parse(last_record.Substring(5)) + 1).ToString("0000");
}
//插入最后一条记录到临时表
temp_record_bll.Add(record_model);
//插入个人属性表
User_property_model.UP_CCOM_number = record_model.Last_CCOM_number;
User_property_model.UP_calculation_status = 0;
User_property_bll.Add(User_property_model);
}
else//临时表中有该年度记录，则直接取该年度记录
{
int last_record = int.Parse(temp_record_model.Last_CCOM_number.Substring(5));
//更新临时表
temp_record_model.Last_CCOM_number = open_year + "B" + (last_record + 1).ToString("0000");
temp_record_bll.Update(temp_record_model);
//插入个人属性表
User_property_model.UP_CCOM_number = temp_record_model.Last_CCOM_number;
User_property_model.UP_calculation_status = 0;
User_property_bll.Add(User_property_model);
}
//JscriptMsg("注册成功！", "/AdminMetro/login_page.aspx", "Success");
var user_notice_bll = new BLL.CCOM.User_notice();
var user_notice_model = new Model.CCOM.User_notice();
user_notice_model.User_id = _id;
var notice_model = new BLL.CCOM.Notice().GetModel(" Notice_flag=1");
user_notice_model.Notice_id = notice_model.Notice_id.ToString();
user_notice_bll.Add(user_notice_model);
Response.Write("<script>window.location.href='/AdminMetro/login_page.aspx';</script>");
}
else
{
//JscriptMsg("注册失败！", "/AdminMetro/CCOM/register/Register.aspx", "Error");
Response.Write("<script>window.location.href='/AdminMetro/CCOM/register/Register.aspx';</script>");
}
}
//基本信息绑定
public void bllBasicInfo(long SchoolUserID)
{
Model.CCOM.User_infomation user_model = new BLL.CCOM.User_infomation().GetModel(id);
Model.CCOM.User_property userEx_model = new BLL.CCOM.User_property().GetModel(" User_id=" + id);
BLL.CCOM.Agency agencyBll = new BLL.CCOM.Agency();
this.txtRealName.Text = user_model.User_realname.Trim();
if (user_model.User_gender == true)
{
this.ddlSex.SelectedValue = "1";
}
else if (user_model.User_gender == false)
{
this.ddlSex.SelectedValue = "0";
}
try
{
this.txtBirthday.Text = ((DateTime)user_model.User_birthday).ToString("yyyy-MM-dd");
}
catch (Exception) {
}
//专业方向
this.ddlDepartment.DataSource = new BLL.CCOM.Agency().GetList(" Agency_type=2");
this.ddlDepartment.DataTextField = "Agency_name";
this.ddlDepartment.DataValueField = "Agency_id";
this.ddlDepartment.DataBind();
this.ddlDepartment.Items.Insert(0, new ListItem("请选择", "0"));
this.ddlMajor.Items.Insert(0, new ListItem("请选择", "0"));
int depID = 0;
try
{
depID = agencyBll.GetModel(" Agency_id=" + agencyBll.GetModel(" Agency_id=" + userEx_model.Agency_id).Agency_father).Agency_id;
this.ddlDepartment.SelectedValue = depID.ToString();
this.ddlMajor.DataSource = agencyBll.GetList(" Agency_father=" + agencyBll.GetModel(" Agency_id=" + userEx_model.Agency_id).Agency_father);
this.ddlMajor.DataTextField = "Agency_name";
this.ddlMajor.DataValueField = "Agency_id";
this.ddlMajor.DataBind();
this.ddlMajor.SelectedValue = userEx_model.Agency_id.ToString();
}
catch { }
new BLL.CCOM.Nationality().BindDDL(this.ddlNationality);
new BLL.CCOM.Politics().BindDDL(this.ddlPolitical);
new BLL.CCOM.Province().BindDDL(this.ddlOrigin);
new BLL.CCOM.Nation().BindDDL(this.ddlNation);
new BLL.CCOM.Degree().BindDDL(this.ddlDegree);
this.ddlNationality.Items.Insert(0, new ListItem("请选择", "0"));
this.ddlPolitical.Items.Insert(0, new ListItem("请选择", "0"));
this.ddlOrigin.Items.Insert(0, new ListItem("请选择", "0"));
this.ddlNation.Items.Insert(0, new ListItem("请选择", "0"));
this.ddlDegree.Items.Insert(0, new ListItem("请选择", "0"));
if (userEx_model != null)
{
if (userEx_model.Agency_id != null && userEx_model.Agency_id > 0)
{
this.ddlMajor.Text = agencyBll.GetModel(userEx_model.Agency_id).Agency_name;
}
//民族
this.ddlNationality.SelectedValue = userEx_model.UP_nationality.ToString();
//国籍
this.ddlNation.SelectedValue = userEx_model.UP_nation.ToString();
//是否华侨
this.ddlOverSeas.SelectedValue = userEx_model.UP_overseas ? "1" : "0";
//文化程度
this.ddlDegree.SelectedValue = userEx_model.UP_degree.ToString();
//政治面貌
this.ddlPolitical.SelectedValue = userEx_model.UP_politics.ToString();
//高中毕业院校
this.txtSeniorSchool.Text = userEx_model.UP_high_school;
//高考报名号
this.txtExaminationID.Text = userEx_model.UP_CEE_number;
//生源地
this.ddlOrigin.SelectedValue = userEx_model.UP_province.ToString();
//考生联系电话
this.txtPhoneNumber.Text = userEx_model.UP_PE_Aphone;
//艺考期间电话
this.txtykPhoneNumber.Text = userEx_model.UP_PE_Iphone;
//录取通知书邮寄地址
this.txtAddress.Text = userEx_model.UP_address;
//邮编
this.txtZipCode.Text = userEx_model.UP_postal_code;
//收件人
this.txtAddressee.Text = userEx_model.UP_receiver;
//收件人电话
this.txtAddresseeNumber.Text = userEx_model.UP_receiver_phone;
}
}
