protected void Bind()
{
string strWhere = " Agency_type=" + DataDic.CCOM_Clique_type;
BLL.CCOM.Agency Bll = new BLL.CCOM.Agency();
DataSet ds = Bll.GetList(strWhere);
this.ddlClique.DataSource = ds.Tables[0].DefaultView;
this.ddlClique.DataTextField = "Agency_name";
this.ddlClique.DataValueField = "Agency_id";
this.ddlClique.DataBind();
if (agency_id == 1)
{
this.ddlClique.SelectedIndex = 0;
clique_id = this.ddlClique.SelectedValue;
}
else
{
this.ddlClique.SelectedValue = agency_id.ToString();
this.ddlClique.Enabled = false;
}
clique_id = this.ddlClique.SelectedValue;
ddlClique_SelectedIndexChanged(null, null);
var bll = new BLL.CCOM.Province();
this.rptList1.DataSource = bll.GetList("");
this.rptList1.DataBind();
}
private void RptBind()
{
string order = "UP_CCOM_number asc";
string strWhere = CombSqlTxt(this.keywords);
var bll = new BLL.CCOM.Province();
this.ddlProvince.DataSource = bll.GetAllList();
this.ddlProvince.DataTextField = "Province_name";
this.ddlProvince.DataValueField = "Province_id";
this.ddlProvince.DataBind();
ListItem item = new ListItem("--所有省份--", "0");
this.ddlProvince.Items.Insert(0, item);
if (!string.IsNullOrEmpty(pro_id))
{
this.ddlProvince.SelectedValue = pro_id;
}
try
{
RptBind(strWhere, order);
}
catch
{
JscriptMsg("获取考生成绩出错", "", "Error");
}
}
public string GetProvinceName(int id)
{
var model = new BLL.CCOM.Province().GetModel(id);
if (model != null)
{
return(model.Province_name);
}
return("--");
}
private void RptBind()
{
var bll = new BLL.CCOM.Province();
this.ddlPro_ID.DataSource = bll.GetAllList();
this.ddlPro_ID.DataTextField = "Province_name";
this.ddlPro_ID.DataValueField = "Province_id";
this.ddlPro_ID.DataBind();
ListItem item = new ListItem("--请选择省份--", "#");
this.ddlPro_ID.Items.Insert(0, item);
}
public string GetProvinceName(string pro_id)
{
string pro_name = "";
try
{
var bll = new BLL.CCOM.Province();
var model = bll.GetModel(" Province_id=" + pro_id);
pro_name = model.Province_name;
}
catch
{
}
return(pro_name);
}
public string GetProvince(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.Province().GetModel((int)model.UP_province).Province_name;
}
catch
{
str = "未设置";
}
return(str);
}
protected String GetName(int id)
{
switch (this.selectid)
{
case "1":
bll_province = new BLL.CCOM.Province();
return(bll_province.GetModel(" " + selectIndex + "=" + id).Province_name);
case "2":
bll_politics = new BLL.CCOM.Politics();
return(bll_politics.GetModel(" " + selectIndex + "=" + id).Politics_name);
case "3":
bll_nationality = new BLL.CCOM.Nationality();
return(bll_nationality.GetModel(" " + selectIndex + "=" + id).Nationality_name);
case "4":
bll_nation = new BLL.CCOM.Nation();
return(bll_nation.GetModel(" " + selectIndex + "=" + id).Nation_name);
case "5":
bll_musical_instrument = new BLL.CCOM.Musical_instrument();
return(bll_musical_instrument.GetModel(" " + selectIndex + "=" + id).Mi_name);
case "6":
bll_degree = new BLL.CCOM.Degree();
return(bll_degree.GetModel(" " + selectIndex + "=" + id).Degree_name);
case "7":
bll_certivicate_type = new BLL.CCOM.Certificate_type();
return(bll_certivicate_type.GetModel(" " + selectIndex + "=" + id).Ct_name);
default:
return("");
}
}
//动态生成Excel
protected void prodExcel_Click(object sender, EventArgs e)
{
bool res = true;
string xlsName = "批量导入分数线模板";
Application excel = new Application();
try
{
excel.Workbooks.Add(true);
excel.Visible = false;
excel.Cells[1, 1] = "省份";
excel.Cells[1, 2] = "文科一本线";
excel.Cells[1, 3] = "理科一本线";
excel.Cells[1, 4] = "文科二本线";
excel.Cells[1, 5] = "理科二本线";
excel.Cells[1, 6] = "文科三本线";
excel.Cells[1, 7] = "理科三本线";
excel.Cells[1, 8] = "艺术类最低控制线（文科）";
excel.Cells[1, 9] = "艺术类最低控制线（理科）";
excel.Cells[1, 10] = "文科满分";
excel.Cells[1, 11] = "理科满分";
Range noticerange = excel.Range[excel.Cells[1, 12], excel.Cells[11, 15]];
noticerange.MergeCells = true;
noticerange.WrapText = true;
noticerange.Font.Size = 15;
noticerange.set_Value(Type.Missing, "提示：请勿修改默认字段名称以及顺序，个别字段需从下拉列表中选取填写内容，给您带来的不便敬请见谅！");
noticerange.Font.ColorIndex = 3;
noticerange.Font.Bold = true;
//获取标题行的单元格
Range range = excel.Range[excel.Cells[1, 1], excel.Cells[1, 11]];
range.Font.Bold = true; //设置字体加粗
range.Font.ColorIndex = 0; //设置字体颜色
//设置颜色背景
//range.Interior.ColorIndex = 15;
//给必填项添加样式
range = excel.Range[excel.Cells[1, 1], excel.Cells[1, 1]]; //获取标题行的单元格
range.Font.ColorIndex = 3; //设置字体颜色
range = excel.Range[excel.Cells[1, 10], excel.Cells[1, 11]]; //获取标题行的单元格
range.Font.ColorIndex = 3; //设置字体颜色
//-----做省份的下拉列表-----//
range = excel.Range[excel.Cells[2, 1], excel.Cells[9999, 1]];
string listStr = "";
BLL.CCOM.Province bllPro = new BLL.CCOM.Province();
DataSet dsPro = bllPro.GetList("");
for (int i = 0; i < dsPro.Tables["ds"].Rows.Count; i++)
{
listStr += dsPro.Tables["ds"].Rows[i]["Province_name"].ToString().Trim() + ",";
}
listStr = listStr.Substring(0, listStr.Length - 1);
range.Validation.Add(Excel.XlDVType.xlValidateList, Excel.XlDVAlertStyle.xlValidAlertStop, Type.Missing, listStr, Type.Missing);
xlsName = xlsName + ".xlsx";
string serverUrl = Server.MapPath("~/");//serverUrl + xlsName
//excel.ActiveWorkbook.SaveAs(serverUrl + xlsName,Excel.XlFileFormat.xlExcel8);
excel.ActiveWorkbook.SaveCopyAs(serverUrl + xlsName);
FileStream myFileStream = new FileStream(serverUrl + xlsName, FileMode.Open);
long fileSize = myFileStream.Length;
byte[] buffer = new byte[(int)fileSize];
myFileStream.Read(buffer, 0, (int)fileSize);
myFileStream.Close();
HttpResponse response = System.Web.HttpContext.Current.Response;
response.Clear();
response.Charset = "UTF-8";
response.ContentType = "application/vnd.ms-excel";
response.AppendHeader("Content-Disposition", string.Format("attachment; filename=" + HttpUtility.UrlEncode(xlsName, Encoding.UTF8).ToString()));
response.BinaryWrite(buffer);
response.Flush();
response.Close();
File.Delete(serverUrl + xlsName);
}
catch (Exception ex)
{
LOGGER.Debug(ex.Message, ex);
res = false;
}
finally
{
excel.DisplayAlerts = false;
excel.ActiveWorkbook.Application.DisplayAlerts = false;
excel.Quit();
excel = null;//这一句是非常重要的，否则Excel对象不能从内存中退出
}
if (!res)
{
string msbox = "parent.f_errorTab(\"错误提示\", \"对不起，导出出错，请重新尝试！\");";
Response.Write("<script type=\"text/javascript\">" + msbox + "</script>");
Response.End();
}
}
protected void btnUpload_Click(object sender, EventArgs e)
{
string result = "";
if (this.txtFraUpload.PostedFile.FileName == "")
{
JscriptMsg("请选择上传文件", "", "Error");
return;
}
DataSet ds = new DataSet();
string path = "/upload/excel/";
#region 解决360获取绝对路径导致出错的问题
string AbsolutePath = this.txtFraUpload.PostedFile.FileName;
string[] pathList = new string[] { };
pathList = AbsolutePath.Split('\\');
AbsolutePath = pathList[pathList.Length - 1];
#endregion
string fileName = DateTime.Now.ToFileTime() + "_" + AbsolutePath;
string FexName = fileName.Substring(fileName.LastIndexOf(".") + 1);
if (FexName != "xls" && FexName != "xlsx")
{
JscriptMsg("请上传Excel文件", "", "Error");
return;
}
string filePath = Server.MapPath(path + fileName);
this.txtFraUpload.SaveAs(filePath);
int success = 0, error = 0;
try
{
BLL.CCOM.Province PBll = new BLL.CCOM.Province();
var excel = new Common.ExcelToData();
ds = excel.GetExcelData(filePath);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
string _ProName = ds.Tables[0].Rows[i]["省份"].ToString().Trim();
var p_model = PBll.GetModel("Province_name='" + _ProName + "'");
if (p_model == null)
{
result += "×第" + (i + 1).ToString() + "行添加失败，该省份‘" + ds.Tables[0].Rows[i]["省份"].ToString().Trim() + "’不存在，请按照模板格式下拉选择；<br/>";
error++;
continue;
}
var model = new Model.CCOM.Fractional_line();
var _model = new Model.CCOM.Fractional_line();
int Pro_id = p_model.Province_id;
model = new BLL.CCOM.Fractional_line().GetModel(" Period_id = " + period_id + " and Fl_Province=" + Pro_id);
_model.WenKeYiBen = ((ds.Tables[0].Rows[i]["文科一本线"].ToString().Trim() == "") ? 0 : (Convert.ToDecimal(ds.Tables[0].Rows[i]["文科一本线"].ToString().Trim())));
_model.LiKeYiBen = (ds.Tables[0].Rows[i]["理科一本线"].ToString().Trim() == "" ? 0 : Convert.ToDecimal(ds.Tables[0].Rows[i]["理科一本线"].ToString().Trim()));
_model.WenKeErBen = (ds.Tables[0].Rows[i]["文科二本线"].ToString().Trim() == "" ? 0 : Convert.ToDecimal(ds.Tables[0].Rows[i]["文科二本线"].ToString().Trim()));
_model.LiKeErBen = (ds.Tables[0].Rows[i]["理科二本线"].ToString().Trim() == "" ? 0 : Convert.ToDecimal(ds.Tables[0].Rows[i]["理科二本线"].ToString().Trim()));
_model.WenKeSanBen = (ds.Tables[0].Rows[i]["文科三本线"].ToString().Trim() == "" ? 0 : Convert.ToDecimal(ds.Tables[0].Rows[i]["文科三本线"].ToString().Trim()));
_model.LiKeSanBen = (ds.Tables[0].Rows[i]["理科三本线"].ToString().Trim() == "" ? 0 : Convert.ToDecimal(ds.Tables[0].Rows[i]["理科三本线"].ToString().Trim()));
_model.WenKeYiShuXian = (ds.Tables[0].Rows[i]["艺术类最低控制线（文科）"].ToString().Trim() == "" ? 0 : Convert.ToDecimal(ds.Tables[0].Rows[i]["艺术类最低控制线（文科）"].ToString().Trim()));
_model.LiKeYiShuXian = (ds.Tables[0].Rows[i]["艺术类最低控制线（理科）"].ToString().Trim() == "" ? 0 : Convert.ToDecimal(ds.Tables[0].Rows[i]["艺术类最低控制线（理科）"].ToString().Trim()));
if (ds.Tables[0].Rows[i]["文科满分"].ToString().Trim() == "")
{
result += "×第" + (i + 1).ToString() + "行添加失败，文科满分不能为空；<br/>";
error++;
continue;
}
_model.WenKeZongFen = Convert.ToDecimal(ds.Tables[0].Rows[i]["文科满分"].ToString().Trim());
if (ds.Tables[0].Rows[i]["理科满分"].ToString().Trim() == "")
{
result += "×第" + (i + 1).ToString() + "行添加失败，理科满分不能为空；<br/>";
error++;
continue;
}
_model.LiKeZongFen = Convert.ToDecimal(ds.Tables[0].Rows[i]["理科满分"].ToString().Trim());
bool isOK = false;
if (model != null)
{
_model.Fl_id = model.Fl_id;
_model.Period_id = model.Period_id;
_model.Fl_Province = model.Fl_Province;
_model.Fl_addtime = model.Fl_addtime;
isOK = DoUpdate(_model);
}
else
{
_model.Fl_Province = Pro_id;
_model.Period_id = period_id;
_model.Fl_addtime = DateTime.Now;
isOK = DoAdd(_model);
}
if (isOK)
{
success++;
}
else
{
result += "×第" + (i + 1).ToString() + "行‘" + ds.Tables[0].Rows[i]["省份"].ToString().Trim() + "’信息异常，导入失败。<br/>";
error++;
}
}
new Calculation().calculateFenShuXian();
}
catch (Exception ex)
{
ILog LOGGER = LogManager.GetLogger("quanquan");
LOGGER.Debug("导入分数线异常" + ex.Message, ex);
result = "导入分数线异常，请联系客服";
}
string divinfo = "<div class=\"alert alert-block alert-info fade in\">";
divinfo += "<button data-dismiss=\"alert\" class=\"close\" type=\"button\">×</button>";
divinfo += "<h4 class=\"alert-heading\">导入结果</h4>";
divinfo += "<p>";
if (success != ds.Tables[0].DefaultView.Count)
{
divinfo += "部分导入成功，您可以按照提示修改Excel并重新提交<br>";
}
else
{
divinfo += "全部导入成功，请您进入下一步确认导入信息<br>";
}
divinfo += "*共有" + ds.Tables[0].DefaultView.Count + "条数据，成功" + success + "条，失败" + error + "条；<br/>";
if (result != "")
{
divinfo += "详细信息如下:<br><font color='red'>" + result;
}
divinfo += "</font></p>";
divinfo += "</div>";
this.lblError.Text = divinfo;
//显示下一步
if (success > 0)
{
this.btnSubmit.Visible = true;
}
//删除上传的文件
File.Delete(filePath);
}
//tab1===================
#region 数据绑定=================================
private void RptBind(string _strWhere, string _order)
{
int pageSize = GetPageSize(15); //每页数量
int page = MyRequest.GetQueryInt("page", 1);
//string keywords = MyRequest.GetQueryString("keywords");
string keywords = this.keywordTab0;
int start_index = pageSize * (page - 1) + 1;
int end_index = pageSize * page;
this.txtKeywords.Text = keywords;
int totalCount = 0;
switch (this.ddlResourceType.SelectedValue)
{
case "1":
bll_province = new BLL.CCOM.Province();
totalCount = bll_province.GetRecordCount(_strWhere);
this.rptList.DataSource = bll_province.GetListByPage(_strWhere, _order, start_index, end_index);
break;
case "2":
bll_politics = new BLL.CCOM.Politics();
totalCount = bll_politics.GetRecordCount(_strWhere);
this.rptList.DataSource = bll_politics.GetListByPage(_strWhere, _order, start_index, end_index);
break;
case "3":
bll_nationality = new BLL.CCOM.Nationality();
totalCount = bll_nationality.GetRecordCount(_strWhere);
this.rptList.DataSource = bll_nationality.GetListByPage(_strWhere, _order, start_index, end_index);
break;
case "4":
bll_nation = new BLL.CCOM.Nation();
totalCount = bll_nation.GetRecordCount(_strWhere);
this.rptList.DataSource = bll_nation.GetListByPage(_strWhere, _order, start_index, end_index);
break;
case "5":
bll_musical_instrument = new BLL.CCOM.Musical_instrument();
totalCount = bll_musical_instrument.GetRecordCount(_strWhere);
this.rptList.DataSource = bll_musical_instrument.GetListByPage(_strWhere, _order, start_index, end_index);
break;
case "6":
bll_degree = new BLL.CCOM.Degree();
totalCount = bll_degree.GetRecordCount(_strWhere);
this.rptList.DataSource = bll_degree.GetListByPage(_strWhere, _order, start_index, end_index);
break;
case "7":
bll_certivicate_type = new BLL.CCOM.Certificate_type();
totalCount = bll_certivicate_type.GetRecordCount(_strWhere);
this.rptList.DataSource = bll_certivicate_type.GetListByPage(_strWhere, _order, start_index, end_index);
break;
default:
break;
}
this.rptList.DataBind();
//绑定页码
txtPageNum.Text = pageSize.ToString();
string pageUrl = Utils.CombUrlTxt("ResourceList.aspx", "fun_id={0}&keywords={1}&page={2}&selectid={3}", DESEncrypt.Encrypt(this.fun_id), keywords, "__id__", this.ddlResourceType.SelectedValue);
this.PageContent.InnerHtml = Utils.OutPageList(pageSize, page, totalCount, pageUrl, 8, true);
}
public String GetResourseName(String signId)
{
switch (this.ddlResourceType.SelectedValue)
{
case "1":
Model.CCOM.Province model_province = new BLL.CCOM.Province().GetModel(" Province_id=" + signId);
if (model_province != null)
{
return(model_province.Province_name);
}
return("");
case "2":
Model.CCOM.Politics model_politics = new BLL.CCOM.Politics().GetModel(" Politics_id=" + signId);
if (model_politics != null)
{
return(model_politics.Politics_name);
}
return("");
case "3":
Model.CCOM.Nationality model_nationality = new BLL.CCOM.Nationality().GetModel(" Nationality_id=" + signId);
if (model_nationality != null)
{
return(model_nationality.Nationality_name);
}
return("");
case "4":
Model.CCOM.Nation model_nation = new BLL.CCOM.Nation().GetModel(" Nation_id=" + signId);
if (model_nation != null)
{
return(model_nation.Nation_name);
}
return("");
case "5":
Model.CCOM.Musical_instrument model_musical_instrument = new BLL.CCOM.Musical_instrument().GetModel(" Mi_id=" + signId);
if (model_musical_instrument != null)
{
return(model_musical_instrument.Mi_name);
}
return("");
case "6":
Model.CCOM.Degree model_degree = new BLL.CCOM.Degree().GetModel(" Degree_id=" + signId);
if (model_degree != null)
{
return(model_degree.Degree_name);
}
return("");
case "7":
Model.CCOM.Certificate_type model_certificate_type = new BLL.CCOM.Certificate_type().GetModel(" Ct_id=" + signId);
if (model_certificate_type != null)
{
return(model_certificate_type.Ct_name);
}
return("");
default:
return("");
}
}
//删除
protected void lbtSingleDelete_Click(object sender, EventArgs e)
{
var lbtn = sender as LinkButton;
if (lbtn != null)
{
var id = Int32.Parse(DESEncrypt.Decrypt(lbtn.ToolTip.ToString()));
bool result = true;
try
{
switch (this.ddlResourceType.SelectedValue)
{
case "1":
bll_province = new BLL.CCOM.Province();
result = bll_province.Delete(id);
break;
case "2":
bll_politics = new BLL.CCOM.Politics();
result = bll_politics.Delete(id);
break;
case "3":
bll_nationality = new BLL.CCOM.Nationality();
result = bll_nationality.Delete(id);
break;
case "4":
bll_nation = new BLL.CCOM.Nation();
result = bll_nation.Delete(id);
break;
case "5":
bll_musical_instrument = new BLL.CCOM.Musical_instrument();
result = bll_musical_instrument.Delete(id);
break;
case "6":
bll_degree = new BLL.CCOM.Degree();
result = bll_degree.Delete(id);
break;
case "7":
bll_certivicate_type = new BLL.CCOM.Certificate_type();
result = bll_certivicate_type.Delete(id);
break;
default:
break;
}
}
catch
{
result = false;
}
string keywords = this.keywordTab0;
int page = MyRequest.GetQueryInt("page", 1);
if (result == true)
{
JscriptMsg("删除成功！", Utils.CombUrlTxt("ResourceList.aspx", "fun_id={0}&keywords={1}&page={2}&selectid={3}",
DESEncrypt.Encrypt(this.fun_id), keywords, page.ToString(), this.ddlResourceType.SelectedValue), "Success");
}
else
{
JscriptMsg("删除失败！", Utils.CombUrlTxt("ResourceList.aspx", "fun_id={0}&keywords={1}&page={2}&selectid={3}",
DESEncrypt.Encrypt(this.fun_id), keywords, page.ToString(), this.ddlResourceType.SelectedValue), "Error");
}
}
}
private void bindData()
{
long _id = GetAdminInfo_CCOM().User_id;
if (_id > 0)
{
Model.CCOM.User_infomation user_model = new BLL.CCOM.User_infomation().GetModel(_id);
if ((int)user_model.User_type != 1)
{
JscriptMsg("只有考生才有打印报名表功能", "/AdminMetro/index.aspx", "Error");
return;
}
Model.CCOM.User_property property_model = new BLL.CCOM.User_property().GetModel(" User_id=" + _id);
try
{
int period = int.Parse(new BLL.CCOM.Period().GetModel(property_model.Period_id).Period_year);
this.title.Text = "中央音乐学院" + period + "年本科招生专业考试报名表";
}
catch
{
JscriptMsg("考生信息出错", "/AdminMetro/index.aspx", "Error");
//Response.Redirect("");
}
if (user_model != null && property_model != null)
{
this.name.Text = user_model.User_realname;
this.id_number.Text = user_model.User_ID_number;
if (user_model.User_gender != null && (bool)user_model.User_gender)
{
this.gender.Text = "女";
}
else
{
this.gender.Text = "男";
}
if (user_model.User_birthday != null)
{
this.birthday.Text = ((DateTime)user_model.User_birthday).ToString("yyyyMMdd");
}
else
{
JscriptMsg("出生日期信息不全，请先完善信息再行打印", "/AdminMetro/index.aspx", "Error");
return;
}
var nation_model = new BLL.CCOM.Nationality().GetModel(property_model.UP_nationality);
if (nation_model != null)
{
this.nation.Text = nation_model.Nationality_name;
}
else
{
JscriptMsg("民族不存在", "/AdminMetro/index.aspx", "Error");
return;
}
var province_model = new BLL.CCOM.Province().GetModel(property_model.UP_province);
if (province_model != null)
{
this.birth_place.Text = province_model.Province_name;
this.stu_province.Text = province_model.Province_name;
}
else
{
JscriptMsg("省份不存在，请先完善信息再行打印", "/AdminMetro/index.aspx", "Error");
return;
}
if (property_model.UP_high_school != null)
{
this.file_address.Text = property_model.UP_high_school;
}
else
{
JscriptMsg("高中院校信息不全，请先完善信息再行打印", "/AdminMetro/index.aspx", "Error");
return;
}
var politics_model = new BLL.CCOM.Politics().GetModel(property_model.UP_politics);
if (politics_model != null)
{
this.politics.Text = politics_model.Politics_name;
}
else
{
JscriptMsg("政治面貌不存在，请先完善信息再行打印", "/AdminMetro/index.aspx", "Error");
return;
}
if (property_model.UP_picture != null)
{
this.head_pic.Src = property_model.UP_picture;
}
else
{
JscriptMsg("证件照信息不全，请先完善信息再行打印", "/AdminMetro/index.aspx", "Error");
return;
}
var agency_model = new BLL.CCOM.Agency().GetModel(property_model.Agency_id);
if (agency_model != null)
{
this.major.Text = agency_model.Agency_name;
}
else
{
JscriptMsg("专业不存在，请先完善信息再行打印", "/AdminMetro/index.aspx", "Error");
return;
}
this.entrance_exam_number.Text = property_model.UP_CCOM_number;
this.stu_entrance_number.Text = property_model.UP_CCOM_number;
if (property_model.UP_receiver_phone != null)
{
this.exam_phone.Text = property_model.UP_receiver_phone;
this.reciever_phone.Text = property_model.UP_receiver_phone;
}
else
{
JscriptMsg("联系电话信息不全，请先完善信息再行打印", "/AdminMetro/index.aspx", "Error");
return;
}
if (property_model.UP_address != null)
{
this.admit_address.Text = property_model.UP_address;
}
else
{
JscriptMsg("录取通知书邮寄地址信息不全，请先完善信息再行打印", "/AdminMetro/index.aspx", "Error");
return;
}
if (property_model.UP_postal_code != null)
{
this.city_id.Text = property_model.UP_postal_code;
}
else
{
JscriptMsg("邮编信息不全，请先完善信息再行打印", "/AdminMetro/index.aspx", "Error");
return;
}
this.reciever.Text = user_model.User_realname;
this.stu_name.Text = user_model.User_realname;
}
else
{
JscriptMsg("考生不存在", "/AdminMetro/index.aspx", "Error");
return;
}
//获取报考科目
int majorId = property_model.Agency_id;
//科目字典
BLL.CCOM.Subject sub_bll = new BLL.CCOM.Subject();
try
{
List <Model.CCOM.Subject> subjectList = sub_bll.GetModelList("Major_Agency_id=" + majorId);
foreach (Model.CCOM.Subject subject in subjectList)
{
subjectDic.Add(subject.Subject_id, subject);
}
}
catch (Exception e)
{
return;
}
root = sub_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)
{
BindSubject(Cmodel, 0, true);
}
}
StringBuilder sb = new StringBuilder();
Model.CCOM.Subject sub_model = null;
int flag = 0;
for (int i = 0; i < sub.Count; i++)
{
sub_model = sub_bll.GetModel(sub[i]);
if (sub_model != null)
{
if (flag == 1)
{
flag = 0;
continue;
}
if (sub_model.Value_type == 1 && flag == 0)
{
flag = 1;
}
sb.Append("<div class=\"control-group\" style=\"margin-top:5px;\"><div class=\"line\">");
sb.Append("<div class=\"course_name\">");
sb.Append("<span>");
sb.Append(sub_model.Subject_title);
sb.Append("</span>");
sb.Append("</div>");
sb.Append("<div class=\"exam_form\">");
sb.Append("<span>");
if (sub_model.Subject_type != null && (bool)sub_model.Subject_type)
{
sb.Append("面试");
}
else
{
sb.Append("笔试");
}
sb.Append("</span>");
sb.Append("</div>");
Label chapter = newChapterLabel(_id, sub[i]);
sb.Append("<div class=\"exam_song\">");
sb.Append(chapter.Text.ToString());
sb.Append("</div>");
sb.Append("</div></div><br>");
//sb.Append("<div class=\"line_decration\"></div>");
}
}
this.examination_course.InnerHtml = sb.ToString();
}
}
//保存
protected void btnSubmit_Click(object sender, EventArgs e)
{
String select = this.ddlResourceType.SelectedValue;
String name = this.nameText.Text;
if (name == "")
{
JscriptMsg("资源名称不能为空！", "", "Error");
return;
}
if (select == "")
{
JscriptMsg("资源类型不能为空！", "", "Error");
return;
}
if (Tools.CheckParams(name + select))
{
JscriptMsg("输入参数不合法！", "", "Error");
return;
}
if (action == MyEnums.ActionEnum.Edit.ToString()) //修改
{
if (signId != 0)
{
string pageUrl = Utils.CombUrlTxt("ResourceList.aspx", "fun_id={0}&selectid={1}",
DESEncrypt.Encrypt(this.fun_id), selectid);
switch (select)
{
case "1":
Model.CCOM.Province model_province = new BLL.CCOM.Province().GetModel(" Province_id=" + signId);
if (model_province != null)
{
model_province.Province_name = name;
if (new BLL.CCOM.Province().GetModel(" Province_name='" + name + "'") != null)
{
JscriptMsg("系统中已有该资源！", "", "Error");
}
else if (new BLL.CCOM.Province().Update(model_province))
{
JscriptMsg("生源地编辑成功！^_^", pageUrl, "Success");
}
else
{
JscriptMsg("出现异常，生源地编辑失败！", "", "Error");
}
}
break;
case "2":
Model.CCOM.Politics model_politics = new BLL.CCOM.Politics().GetModel(" Politics_id=" + signId);
if (model_politics != null)
{
model_politics.Politics_name = name;
if (new BLL.CCOM.Politics().GetModel(" Politics_name='" + name + "'") != null)
{
JscriptMsg("系统中已有该资源！", "", "Error");
}
else if (new BLL.CCOM.Politics().Update(model_politics))
{
JscriptMsg("政治面貌编辑成功！^_^", pageUrl, "Success");
}
else
{
JscriptMsg("出现异常，政治面貌编辑失败！", "", "Error");
}
}
break;
case "3":
Model.CCOM.Nationality model_nationality = new BLL.CCOM.Nationality().GetModel(" Nationality_id=" + signId);
if (model_nationality != null)
{
model_nationality.Nationality_name = name;
if (new BLL.CCOM.Nationality().GetModel(" Nationality_name='" + name + "'") != null)
{
JscriptMsg("系统中已有该资源！", "", "Error");
}
else if (new BLL.CCOM.Nationality().Update(model_nationality))
{
JscriptMsg("民族编辑成功！^_^", pageUrl, "Success");
}
else
{
JscriptMsg("出现异常，民族编辑失败！", "", "Error");
}
}
break;
case "4":
Model.CCOM.Nation model_nation = new BLL.CCOM.Nation().GetModel(" Nation_id=" + signId);
if (model_nation != null)
{
model_nation.Nation_name = name;
if (new BLL.CCOM.Nation().GetModel(" Nation_name='" + name + "'") != null)
{
JscriptMsg("系统中已有该资源！", "", "Error");
}
else if (new BLL.CCOM.Nation().Update(model_nation))
{
JscriptMsg("国籍编辑成功！^_^", pageUrl, "Success");
}
else
{
JscriptMsg("出现异常，国籍编辑失败！", "", "Error");
}
}
break;
case "5":
Model.CCOM.Musical_instrument model_musical_instrument = new BLL.CCOM.Musical_instrument().GetModel(" Mi_id=" + signId);
if (model_musical_instrument != null)
{
model_musical_instrument.Mi_name = name;
if (new BLL.CCOM.Musical_instrument().GetModel(" Mi_name='" + name + "'") != null)
{
JscriptMsg("系统中已有该资源！", "", "Error");
}
else if (new BLL.CCOM.Musical_instrument().Update(model_musical_instrument))
{
JscriptMsg("乐器编辑成功！^_^", pageUrl, "Success");
}
else
{
JscriptMsg("出现异常，乐器编辑失败！", "", "Error");
}
}
break;
case "6":
Model.CCOM.Degree model_degree = new BLL.CCOM.Degree().GetModel(" Degree_id=" + signId);
if (model_degree != null)
{
model_degree.Degree_name = name;
if (new BLL.CCOM.Degree().GetModel(" Degree_name='" + name + "'") != null)
{
JscriptMsg("系统中已有该资源！", "", "Error");
}
else if (new BLL.CCOM.Degree().Update(model_degree))
{
JscriptMsg("教育程度编辑成功！^_^", pageUrl, "Success");
}
else
{
JscriptMsg("出现异常，教育程度编辑失败！", "", "Error");
}
}
break;
case "7":
Model.CCOM.Certificate_type model_certificate_type = new BLL.CCOM.Certificate_type().GetModel(" Ct_id=" + signId);
if (model_certificate_type != null)
{
model_certificate_type.Ct_name = name;
if (new BLL.CCOM.Certificate_type().GetModel(" Ct_name='" + name + "'") != null)
{
JscriptMsg("系统中已有该资源！", "", "Error");
}
else if (new BLL.CCOM.Certificate_type().Update(model_certificate_type))
{
JscriptMsg("证件类型编辑成功！^_^", pageUrl, "Success");
}
else
{
JscriptMsg("出现异常，证件类型编辑失败！", "", "Error");
}
}
break;
default:
break;
}
}
}
else
{
//add
string pageUrl = Utils.CombUrlTxt("ResourceList.aspx", "fun_id={0}&selectid={1}", DESEncrypt.Encrypt(this.fun_id), select);
int id = 0;
switch (select)
{
case "1":
Model.CCOM.Province model_province = new Model.CCOM.Province();
model_province.Province_name = name;
if (new BLL.CCOM.Province().GetModel(" Province_name='" + name + "'") != null)
{
id = -100;
}
else
{
id = new BLL.CCOM.Province().Add(model_province);
}
break;
case "2":
Model.CCOM.Politics model_politics = new Model.CCOM.Politics();
model_politics.Politics_name = name;
if (new BLL.CCOM.Politics().GetModel(" Politics_name='" + name + "'") != null)
{
id = -100;
}
else
{
id = new BLL.CCOM.Politics().Add(model_politics);
}
break;
case "3":
Model.CCOM.Nationality model_nationality = new Model.CCOM.Nationality();
model_nationality.Nationality_name = name;
if (new BLL.CCOM.Nationality().GetModel(" Nationality_name='" + name + "'") != null)
{
id = -100;
}
else
{
id = new BLL.CCOM.Nationality().Add(model_nationality);
}
break;
case "4":
Model.CCOM.Nation model_nation = new Model.CCOM.Nation();
model_nation.Nation_name = name;
if (new BLL.CCOM.Nation().GetModel(" Nation_name='" + name + "'") != null)
{
id = -100;
}
else
{
id = new BLL.CCOM.Nation().Add(model_nation);
}
break;
case "5":
Model.CCOM.Musical_instrument model_musical_instrument = new Model.CCOM.Musical_instrument();
model_musical_instrument.Mi_name = name;
if (new BLL.CCOM.Musical_instrument().GetModel(" Mi_name='" + name + "'") != null)
{
id = -100;
}
else
{
id = new BLL.CCOM.Musical_instrument().Add(model_musical_instrument);
}
break;
case "6":
Model.CCOM.Degree model_degree = new Model.CCOM.Degree();
model_degree.Degree_name = name;
if (new BLL.CCOM.Degree().GetModel(" Degree_name='" + name + "'") != null)
{
id = -100;
}
else
{
id = new BLL.CCOM.Degree().Add(model_degree);
}
break;
case "7":
Model.CCOM.Certificate_type model_certificate_type = new Model.CCOM.Certificate_type();
model_certificate_type.Ct_name = name;
if (new BLL.CCOM.Certificate_type().GetModel(" Ct_name='" + name + "'") != null)
{
id = -100;
}
else
{
id = new BLL.CCOM.Certificate_type().Add(model_certificate_type);
}
break;
default:
break;
}
if (id > 0)
{
JscriptMsg("添加资源成功！^_^", pageUrl, "Success");
}
else if (id == -100)
{
JscriptMsg("系统中已有该资源！", "", "Error");
}
else
{
JscriptMsg("出现异常，添加资源失败！", "", "Error");
}
}
}
protected void BindSignInfo(long signId)
{
this.ddlResourceType.SelectedValue = selectid;
switch (this.selectid)
{
case "1":
Model.CCOM.Province model_province = new BLL.CCOM.Province().GetModel(" Province_id=" + signId);
if (model_province != null)
{
this.nameText.Text = model_province.Province_name;
}
else
{
JscriptMsg("传输参数不正确！", "back", "Error");
}
break;
case "2":
Model.CCOM.Politics model_politics = new BLL.CCOM.Politics().GetModel(" Politics_id=" + signId);
if (model_politics != null)
{
this.nameText.Text = model_politics.Politics_name;
}
else
{
JscriptMsg("传输参数不正确！", "back", "Error");
}
break;
case "3":
Model.CCOM.Nationality model_nationality = new BLL.CCOM.Nationality().GetModel(" Nationality_id=" + signId);
if (model_nationality != null)
{
this.nameText.Text = model_nationality.Nationality_name;
}
else
{
JscriptMsg("传输参数不正确！", "back", "Error");
}
break;
case "4":
Model.CCOM.Nation model_nation = new BLL.CCOM.Nation().GetModel(" Nation_id=" + signId);
if (model_nation != null)
{
this.nameText.Text = model_nation.Nation_name;
}
else
{
JscriptMsg("传输参数不正确！", "back", "Error");
}
break;
case "5":
Model.CCOM.Musical_instrument model_musical_instrument = new BLL.CCOM.Musical_instrument().GetModel(" Mi_id=" + signId);
if (model_musical_instrument != null)
{
this.nameText.Text = model_musical_instrument.Mi_name;
}
else
{
JscriptMsg("传输参数不正确！", "back", "Error");
}
break;
case "6":
Model.CCOM.Degree model_degree = new BLL.CCOM.Degree().GetModel(" Degree_id=" + signId);
if (model_degree != null)
{
this.nameText.Text = model_degree.Degree_name;
}
else
{
JscriptMsg("传输参数不正确！", "back", "Error");
}
break;
case "7":
Model.CCOM.Certificate_type model_certificate_type = new BLL.CCOM.Certificate_type().GetModel(" Ct_id=" + signId);
if (model_certificate_type != null)
{
this.nameText.Text = model_certificate_type.Ct_name;
}
else
{
JscriptMsg("传输参数不正确！", "back", "Error");
}
break;
default:
break;
}
}
/// <summary>
/// 如果某省市没有设定分数线，那么用北京的分数线进行折算
/// </summary>
/// <returns>成功返回true</returns>
public bool calculateFenShuXian()
{
var bll = new BLL.CCOM.Fractional_line();
var modelBJ = bll.GetModelList("Fl_Province in (select Province_id from Province where Province_name = '北京市') and Period_id = " + period_id);
if (modelBJ != null && modelBJ.Count > 0)
{
var BeiJingXian = modelBJ[0];
var provinceList = new BLL.CCOM.Province().GetModelList("");
foreach (var province in provinceList)
{
var model = bll.GetModelList("Fl_Province = " + province.Province_id + " and Period_id = " + period_id);
if (model != null && model.Count > 0)
{
///先算三本线
//理科
if (model[0].LiKeSanBen.ToString() == "0")
{
if (model[0].LiKeErBen.ToString() != "0")
{
model[0].LiKeSanBen = BeiJingXian.LiKeSanBen * model[0].LiKeErBen / BeiJingXian.LiKeErBen;
}
else if (model[0].LiKeYiBen.ToString() != "0")
{
model[0].LiKeSanBen = BeiJingXian.LiKeSanBen * model[0].LiKeYiBen / BeiJingXian.LiKeYiBen;
}
}
//文科
if (model[0].WenKeSanBen.ToString() == "0")
{
if (model[0].WenKeErBen.ToString() != "0")
{
model[0].WenKeSanBen = BeiJingXian.WenKeSanBen * model[0].WenKeErBen / BeiJingXian.WenKeErBen;
}
else if (model[0].WenKeYiBen.ToString() != "0")
{
model[0].WenKeSanBen = BeiJingXian.WenKeSanBen * model[0].WenKeYiBen / BeiJingXian.WenKeYiBen;
}
}
///再算艺术线
//理科
if (model[0].LiKeYiShuXian.ToString() == "0")
{
if (model[0].LiKeSanBen.ToString() != "0")
{
model[0].LiKeYiShuXian = BeiJingXian.LiKeYiShuXian * model[0].LiKeSanBen / BeiJingXian.LiKeSanBen;
}
}
//文科
if (model[0].WenKeYiShuXian.ToString() == "0")
{
if (model[0].WenKeSanBen.ToString() != "0")
{
model[0].WenKeYiShuXian = BeiJingXian.WenKeYiShuXian * model[0].WenKeSanBen / BeiJingXian.WenKeSanBen;
}
}
bll.Update(model[0]);
}
}
}
return(true);
}
protected string ImportDataItem(DataSet ds, ref int success, ref int error)//基础数据
{
string result = "";
BLL.CCOM.Province bll_Province = new BLL.CCOM.Province();
Model.CCOM.Province model_Province = new Model.CCOM.Province();
BLL.CCOM.Politics bll_Politics = new BLL.CCOM.Politics();
Model.CCOM.Politics model_Politics = new Model.CCOM.Politics();
BLL.CCOM.Nationality bll_Nationality = new BLL.CCOM.Nationality();
Model.CCOM.Nationality model_Nationality = new Model.CCOM.Nationality();
BLL.CCOM.Nation bll_Nation = new BLL.CCOM.Nation();
Model.CCOM.Nation model_Nation = new Model.CCOM.Nation();
BLL.CCOM.Musical_instrument bll_Musical_instrument = new BLL.CCOM.Musical_instrument();
Model.CCOM.Musical_instrument model_Musical_instrument = new Model.CCOM.Musical_instrument();
BLL.CCOM.Degree bll_Degree = new BLL.CCOM.Degree();
Model.CCOM.Degree model_Degree = new Model.CCOM.Degree();
BLL.CCOM.Certificate_type bll_Certificate_type = new BLL.CCOM.Certificate_type();
Model.CCOM.Certificate_type model_Certificate_type = new Model.CCOM.Certificate_type();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
string checkmsg = null;
string name = ds.Tables[0].Rows[i]["名称"].ToString().Trim();
if (!ValidDFValue(name, true, "", ref checkmsg))
{
result += "×第" + (i + 1).ToString() + "行数据更新失败，名称" + checkmsg + "<br/>";
error++;
continue;
}
switch (this.ddlResourceType.SelectedValue)
{
case "1":
if (name != "")
{
model_Province.Province_name = name;
}
if (bll_Province.GetModel(" Province_name='" + name + "'") != null)
{
result += "×第" + (i + 1).ToString() + "行，系统已存在该数据<br/>";
error++;
continue;
}
else if (bll_Province.Add(model_Province) == 0)
{
result += "×第" + (i + 1).ToString() + "行数据更新异常<br/>";
error++;
continue;
}
else
{
success++;
}
break;
case "2":
if (name != "")
{
model_Politics.Politics_name = name;
}
if (bll_Politics.GetModel(" Politics_name='" + name + "'") != null)
{
result += "×第" + (i + 1).ToString() + "行，系统已存在该数据<br/>";
error++;
continue;
}
else if (bll_Politics.Add(model_Politics) == 0)
{
result += "×第" + (i + 1).ToString() + "行数据更新异常<br/>";
error++;
continue;
}
else
{
success++;
}
break;
case "3":
if (name != "")
{
model_Nationality.Nationality_name = name;
}
if (bll_Nationality.GetModel(" Nationality_name='" + name + "'") != null)
{
result += "×第" + (i + 1).ToString() + "行，系统已存在该数据<br/>";
error++;
continue;
}
else if (bll_Nationality.Add(model_Nationality) == 0)
{
result += "×第" + (i + 1).ToString() + "行数据更新异常<br/>";
error++;
continue;
}
else
{
success++;
}
break;
case "4":
if (name != "")
{
model_Nation.Nation_name = name;
}
if (bll_Nation.GetModel(" Nation_name='" + name + "'") != null)
{
result += "×第" + (i + 1).ToString() + "行，系统已存在该数据<br/>";
error++;
continue;
}
else if (bll_Nation.Add(model_Nation) == 0)
{
result += "×第" + (i + 1).ToString() + "行数据更新异常<br/>";
error++;
continue;
}
else
{
success++;
}
break;
case "5":
if (name != "")
{
model_Musical_instrument.Mi_name = name;
}
if (bll_Musical_instrument.GetModel(" Mi_name='" + name + "'") != null)
{
result += "×第" + (i + 1).ToString() + "行，系统已存在该数据<br/>";
error++;
continue;
}
else if (bll_Musical_instrument.Add(model_Musical_instrument) == 0)
{
result += "×第" + (i + 1).ToString() + "行数据更新异常<br/>";
error++;
continue;
}
else
{
success++;
}
break;
case "6":
if (name != "")
{
model_Degree.Degree_name = name;
}
if (bll_Degree.GetModel(" Degree_name='" + name + "'") != null)
{
result += "×第" + (i + 1).ToString() + "行，系统已存在该数据<br/>";
error++;
continue;
}
else if (bll_Degree.Add(model_Degree) == 0)
{
result += "×第" + (i + 1).ToString() + "行数据更新异常<br/>";
error++;
continue;
}
else
{
success++;
}
break;
case "7":
if (name != "")
{
model_Certificate_type.Ct_name = name;
}
if (bll_Certificate_type.GetModel(" Ct_name='" + name + "'") != null)
{
result += "×第" + (i + 1).ToString() + "行，系统已存在该数据<br/>";
error++;
continue;
}
else if (bll_Certificate_type.Add(model_Certificate_type) == 0)
{
result += "×第" + (i + 1).ToString() + "行数据更新异常<br/>";
error++;
continue;
}
else
{
success++;
}
break;
default:
break;
}
}
return(result);
}
