private void SetInfo(ChargeMeter_Project data) { this.tdMeterName.Value = data.MeterName; this.tdMeterNumber.Value = data.MeterNumber; this.tdMeterCategory.Value = data.MeterCategoryID > 0 ? data.MeterCategoryID.ToString() : ""; this.tdMeterType.Value = data.MeterType > 0 ? data.MeterType.ToString() : ""; this.tdMeterSpec.Value = data.MeterSpec > 0 ? data.MeterSpec.ToString() : ""; this.tdMeterCoefficient.Value = data.MeterCoefficient > decimal.MinValue ? data.MeterCoefficient.ToString() : ""; var charge = ChargeSummary.GetChargeSummary(data.MeterChargeID); if (charge != null) { this.tdChargeSummary.InnerHtml = charge.Name; } this.tdMeterHouseNo.Value = data.MeterHouseNo; this.tdMeterLocation.Value = data.MeterLocation; this.tdSortOrder.Value = data.SortOrder > int.MinValue ? data.SortOrder.ToString() : ""; this.tdMeterRemark.Value = data.MeterRemark; var project = Project.GetProject(data.ProjectID); if (project != null) { this.tdProjectNames.InnerHtml = project.FullName + "-" + project.Name; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Request.QueryString["ID"] != null) { int.TryParse(Request.QueryString["ID"], out ID); } ChargeMeter_Project data = null; if (ID > 0) { data = ChargeMeter_Project.GetChargeMeter_Project(ID); } if (data == null) { this.tdMeterCoefficient.Value = "1"; Response.End(); return; } SetInfo(data); } }
private void importmeterpointdata(HttpContext context) { HttpFileCollection uploadFiles = context.Request.Files; if (uploadFiles.Count == 0) { context.Response.Write("请选择一个文件"); return; } if (string.IsNullOrEmpty(uploadFiles[0].FileName)) { context.Response.Write("请选择一个文件"); return; } string msg = string.Empty; bool ImportFailed = false; int TotalNumber = 0; using (SqlHelper helper = new SqlHelper()) { try { helper.BeginTransaction(); #region 导入处理 for (int j = 0; j < uploadFiles.Count; j++) { HttpPostedFile postedFile = uploadFiles[j]; string filepath = HttpContext.Current.Server.MapPath("~/upload/ImportChaoBiao/" + DateTime.Now.ToString("yyyyMMdd")); if (!System.IO.Directory.Exists(filepath)) { System.IO.Directory.CreateDirectory(filepath); } string filename = DateTime.Now.ToLocalTime().ToString("yyyyMMddHHmmss") + "_" + postedFile.FileName; string fullpath = Path.Combine(filepath, filename); postedFile.SaveAs(fullpath); DataTable table = ExcelExportHelper.NPOIReadExcel(fullpath); for (int i = 0; i < table.Rows.Count; i++) { int ID = 0; int.TryParse(table.Rows[i]["仪表ID"].ToString(), out ID); Foresight.DataAccess.ChargeMeter_Project projectbiao = null; if (ID > 0) { projectbiao = Foresight.DataAccess.ChargeMeter_Project.GetChargeMeter_Project(ID, helper); } if (projectbiao == null) { msg += "<p>第" + (i + 2) + "行上传失败。原因:仪表不存在</p>"; ImportFailed = true; break; } projectbiao.MeterName = table.Rows[i]["仪表名称"].ToString(); projectbiao.MeterNumber = table.Rows[i]["仪表编号"].ToString(); projectbiao.MeterCategoryID = ChargeMeter_Project.GetMeterCategoryID(table.Rows[i]["仪表种类"].ToString()); if (projectbiao.MeterCategoryID == 0) { msg += "<p>第" + (i + 2) + "行上传失败。原因:仪表种类不存在</p>"; ImportFailed = true; break; } projectbiao.MeterType = ChargeMeter_Project.GetMeterTypeID(table.Rows[i]["仪表类型"].ToString()); if (projectbiao.MeterType == 0) { msg += "<p>第" + (i + 2) + "行上传失败。原因:仪表类型不存在</p>"; ImportFailed = true; break; } projectbiao.MeterSpec = ChargeMeter_Project.GetMeterSpec(table.Rows[i]["仪表规格"].ToString()); if (projectbiao.MeterSpec == 0) { msg += "<p>第" + (i + 2) + "行上传失败。原因:仪表规格不存在</p>"; ImportFailed = true; break; } projectbiao.MeterCoefficient = WebUtil.GetDecimalByStr(table.Rows[i]["倍率"].ToString()); projectbiao.MeterHouseNo = table.Rows[i]["缴费户号"].ToString(); projectbiao.MeterLocation = table.Rows[i]["仪表位置"].ToString(); projectbiao.MeterRemark = table.Rows[i]["备注"].ToString(); projectbiao.SortOrder = WebUtil.GetIntByStr(table.Rows[i]["排序序号"].ToString()); projectbiao.MeterStartPoint = WebUtil.GetDecimalByStr(table.Rows[i]["上次读数"].ToString()); projectbiao.MeterEndPoint = WebUtil.GetDecimalByStr(table.Rows[i]["本次读数"].ToString()); projectbiao.Save(helper); TotalNumber = i; } } #endregion if (!ImportFailed) { helper.Commit(); msg += "<p>导入完成</p>"; } else { helper.Rollback(); msg += "<p>导入失败</p>"; } } catch (Exception ex) { LogHelper.WriteError("ImportGongTanHandler", "visit: importmeterdata", ex); helper.Rollback(); msg += "<p>第" + (TotalNumber + 2) + "行上传失败。原因:" + ex.Message + "</p>"; } context.Response.Write(msg); } }