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"); } } }