protected bool DoUpdate(Model.CCOM.Fractional_line Fl)
{
try
{
BLL.CCOM.Fractional_line Bfl = new BLL.CCOM.Fractional_line();
Bfl.Update(Fl);
}
catch (Exception ex)
{
return(false);
}
return(true);
}
protected bool DoUpdate(Model.CCOM.Fractional_line Fl)
{
try
{
BLL.CCOM.Fractional_line Bfl = new BLL.CCOM.Fractional_line();
Bfl.Update(Fl);
}
catch (Exception ex)
{
JscriptMsg("添加出错，请重新提交", "", "Error");
return(false);
}
return(true);
}
public decimal guoxianFen(String zhuanye, int WenLi, Model.CCOM.Fractional_line fenshuxian)
{
try
{
if (WenLi == 1) //文科
{
if (zhuanye == "音乐学" || zhuanye == "音乐艺术管理" || zhuanye == "音乐治疗")
{
return(Convert.ToDecimal(fenshuxian.WenKeSanBen));
}
else if (zhuanye == "音乐教育" || zhuanye == "音乐教育（协作计划）")
{
return(Convert.ToDecimal(fenshuxian.WenKeSanBen) * (decimal)0.8);
}
else
{
return(Convert.ToDecimal(fenshuxian.WenKeYiShuXian));
}
}
else if (WenLi == 2) //理科
{
if (zhuanye == "音乐学" || zhuanye == "音乐艺术管理" || zhuanye == "音乐治疗")
{
return(Convert.ToDecimal(fenshuxian.LiKeSanBen));
}
else if (zhuanye == "音乐教育" || zhuanye == "音乐教育（协作计划）")
{
return(Convert.ToDecimal(fenshuxian.LiKeSanBen) * (decimal)0.8);
}
else
{
return(Convert.ToDecimal(fenshuxian.LiKeYiShuXian));
}
}
else
{
return(0);
}
}
catch
{
return(0);
}
}
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);
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (this.ddlPro_ID.SelectedItem.Value == "#")
{
JscriptMsg("请选择省份！", "", "Error");
return;
}
if (this.txtManWen.Text.ToString().Trim() == "" || this.txtManLi.Text.ToString().Trim() == "")
{
JscriptMsg("文理科满分不能为空！", "", "Error");
return;
}
var model = new Model.CCOM.Fractional_line();
var _model = new Model.CCOM.Fractional_line();
int Pro_id = Convert.ToInt32(this.ddlPro_ID.SelectedItem.Value);
model = new BLL.CCOM.Fractional_line().GetModel(" Period_id = " + period_id + " and Fl_Province=" + Pro_id);
_model.WenKeYiBen = ((this.txtYiBenWen.Text.ToString() == "") ? 0 : (Convert.ToDecimal(this.txtYiBenWen.Text.ToString().Trim())));
_model.LiKeYiBen = (this.txtYiBenLi.Text.ToString() == "" ? 0 : Convert.ToDecimal(this.txtYiBenLi.Text.ToString().Trim()));
_model.WenKeErBen = (this.txtErBenWen.Text.ToString() == "" ? 0 : Convert.ToDecimal(this.txtErBenWen.Text.ToString().Trim()));
_model.LiKeErBen = (this.txtErBenLi.Text.ToString() == "" ? 0 : Convert.ToDecimal(this.txtErBenLi.Text.ToString().Trim()));
_model.WenKeSanBen = (this.txtSanBenWen.Text.ToString() == "" ? 0 : Convert.ToDecimal(this.txtSanBenWen.Text.ToString().Trim()));
_model.LiKeSanBen = (this.txtSanBenLi.Text.ToString() == "" ? 0 : Convert.ToDecimal(this.txtSanBenLi.Text.ToString().Trim()));
_model.WenKeYiShuXian = (this.txtYiShuWen.Text.ToString() == "" ? 0 : Convert.ToDecimal(this.txtYiShuWen.Text.ToString().Trim()));
_model.LiKeYiShuXian = (this.txtYiShuLi.Text.ToString() == "" ? 0 : Convert.ToDecimal(this.txtYiShuLi.Text.ToString().Trim()));
_model.WenKeZongFen = Convert.ToDecimal(this.txtManWen.Text.ToString().Trim());
_model.LiKeZongFen = Convert.ToDecimal(this.txtManLi.Text.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)
{
try
{
new Calculation().calculateFenShuXian();
JscriptMsg("分数线添加成功", "FractionallineList.aspx?fun_id=" + get_fun_id("CCOM/CEEManege/FractionallineList.aspx"), "Success");
}
catch
{
JscriptMsg("分数线添加失败，请重新尝试", "", "Error");
}
}
}
