/// <summary> /// Set Grid Data source /// </summary> /// <param name="addRow"></param> /// <param name="deleteRow"></param>e private void BindGrid() { DistrictBLL DistrictBLLobj = new DistrictBLL(); grdDistrict.DataSource = DistrictBLLobj.GetAllDistricts(); grdDistrict.DataBind(); }
public ActionResult GetDistricts(string countryId, string regionId, string provinceId) { DistrictBLL districtBLL = new DistrictBLL(WebApp.Connector); IEnumerable <DistrictDTO> districts = districtBLL.ReadByCountryAndRegionAndProvince(countryId, regionId, provinceId); return(Json(districts)); }
private void AddEditProperty_BasePost(Connector connector, PropertyDTO property) { RegionBLL regionBLL = new RegionBLL(connector); ProvinceBLL provinceBLL = new ProvinceBLL(connector); DistrictBLL districtBLL = new DistrictBLL(connector); CountryDTO country = property.Country; RegionDTO region = property.Region; ProvinceDTO province = property.Province; DistrictDTO district = property.District; if (country != null) { country.Regions = regionBLL.ReadByCountry(country.Id); if (region != null) { region.Country = country; } if (province != null) { province.Country = country; } if (district != null) { district.Country = country; } } if (region != null) { region.Provinces = provinceBLL.ReadByCountryAndRegion(country.Id, region.Code); } if (province != null) { province.Districts = districtBLL.ReadByCountryAndRegionAndProvince(country.Id, region.Code, province.Code); } }
public bool BLLIsExistDistrictName(DistrictBLL bt) { bool flag = false; flag = districtBLLObj.DALIsExistDistrictName(bt); return(flag); }
/// <summary> /// Update Database Make data as Obsoluted /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void IsObsolete_CheckedChanged(Object sender, EventArgs e) { string message = string.Empty; try { CheckBox chk = (CheckBox)sender; GridViewRow gr = (GridViewRow)chk.Parent.Parent; string DISTRICTID = ((Literal)gr.FindControl("litDISTRICTID")).Text; DistrictBLL DistrictBLLobj = new DistrictBLL(); message = DistrictBLLobj.ObsoleteDistrict(Convert.ToInt32(DISTRICTID), Convert.ToString(chk.Checked), Convert.ToInt32(Session["USER_ID"])); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data updated successfully"; } ClearData(); BindGrid(); if (message != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Obsoleted", "alert('" + message + "');", true); } } catch (Exception ex) { throw ex; } }
/// <summary> /// 作业实时分布统计表 /// </summary> /// <returns></returns> public ActionResult GetWorkRealTimeTableJson() { DistrictBLL districtbll = new DistrictBLL(); List <DistrictEntity> AreaList = districtbll.GetListByOrgIdAndParentId("", "0"); List <SafeworkcontrolEntity> WorkList = safeworkcontrolbll.GetNowWork(); List <KbssEntity> klist = new List <KbssEntity>(); int Znum = 0; foreach (var item in AreaList) { KbssEntity kbs = new KbssEntity(); kbs.Name = item.DistrictName; kbs.Num = WorkList.Where(a => a.Taskregioncode.Contains(item.DistrictCode)).Count(); kbs.DistrictCode = item.DistrictCode; Znum += kbs.Num; kbs.OnNum = WorkList.Where(a => a.Taskregioncode.Contains(item.DistrictCode)).Count(); klist.Add(kbs); } for (int j = 0; j < klist.Count; j++) { double Proportion = 0; if (Znum != 0) { Proportion = (double)klist[j].Num / Znum; Proportion = Proportion * 100; } klist[j].OnNum = Znum; klist[j].OnProportion = Proportion.ToString("0") + "%"; } return(Content(klist.ToJson())); }
/// <summary> /// Set edit mode for edit comand /// Delete data from the database for delete comand /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void grdDistrict_RowCommand(object sender, GridViewCommandEventArgs e) { string message = string.Empty; if (e.CommandName == "EditRow") { ShowHideSections(true, false); ViewState["District_ID"] = e.CommandArgument; DistrictBLL objDistrictBLL = new DistrictBLL(); DistrictBO objDistrict = objDistrictBLL.GetDistrictById(Convert.ToInt32(ViewState["District_ID"])); txtDistrict.Text = objDistrict.DistrictName; btnSave.Text = "Update"; btnClear.Text = "Cancel"; } else if (e.CommandName == "DeleteRow") { // ViewState["CDAPBUDGETID"] = e.CommandArgument; DistrictBLL DistrictBLLobj = new DistrictBLL(); message = DistrictBLLobj.DeleteDistrict(Convert.ToInt32(e.CommandArgument)); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data deleted successfully"; } SetUpdateMode(false); BindGrid(); ClearData(); } if (message != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); } }
public ActionResult GetLableStatistics() { var data = basebll.GetPageList(""); DistrictBLL districtbll = new DistrictBLL(); List <DistrictEntity> AreaList = districtbll.GetListByOrgIdAndParentId("", "0"); List <KbsEntity> klist = new List <KbsEntity>(); int Znum = 0; foreach (var item in AreaList) { KbsEntity kbs = new KbsEntity(); kbs.Name = item.DistrictName; kbs.Num = data.Where(a => a.AreaCode.Contains(item.DistrictCode)).Count(); Znum += kbs.Num; kbs.Num2 = kbs.Num; klist.Add(kbs); } for (int j = 0; j < klist.Count; j++) { double Proportion = 0; if (Znum != 0) { Proportion = (double)klist[j].Num / Znum; Proportion = Proportion * 100; } klist[j].Proportion = Proportion.ToString("0") + "%"; } return(Content(klist.ToJson())); }
/// <summary> /// Set Grid Data source /// </summary> /// <param name="addRow"></param> /// <param name="deleteRow"></param>e private void SearchBind() { string districtName = txtSearchDistrictName.Text.Trim(); DistrictBLL objDistrictBLL = new DistrictBLL(); grdDistrict.DataSource = objDistrictBLL.SearchDistrict(districtName); grdDistrict.DataBind(); }
/// <summary> /// To display details on click of button /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSearch_Click(object sender, EventArgs e) { string districtName = txtSearchDistrictName.Text.Trim(); DistrictBLL objDistrictBLL = new DistrictBLL(); grdDistrict.DataSource = objDistrictBLL.SearchDistrict(districtName); grdDistrict.DataBind(); }
private void GetProviceList(HttpContext context) { var list = new DistrictBLL().GetProvinceList(); var result = new ApiResultDto { code = 0, data = list }; context.Response.Write(new Tools.Serialize().SerializeJson(result)); return; }
public string ImportEquipment() { int error = 0; int sussceed = 0; string message = "请选择格式正确的文件再导入!"; string falseMessage = ""; int count = HttpContext.Request.Files.Count; if (count > 0) { HttpPostedFileBase file = HttpContext.Request.Files[0]; if (string.IsNullOrEmpty(file.FileName)) { return(message); } if (!(file.FileName.Substring(file.FileName.IndexOf('.')).Contains("xls") || file.FileName.Substring(file.FileName.IndexOf('.')).Contains("xlsx"))) { return(message); } string fileName = DateTime.Now.ToString("yyyyMMddHHmmss") + System.IO.Path.GetExtension(file.FileName); string filePath = Server.MapPath("~/Resource/temp/" + fileName); file.SaveAs(filePath); DataTable dt = ExcelHelper.ExcelImport(filePath); var districtList = new DistrictBLL().GetList().Where(x => x.OrganizeId == ERCHTMS.Code.OperatorProvider.Provider.Current().OrganizeId).ToList(); var deptList = new DepartmentBLL().GetList().Where(x => x.OrganizeId == ERCHTMS.Code.OperatorProvider.Provider.Current().OrganizeId).ToList(); var eno = int.Parse(equipmentbll.GetEquipmentNo("P1-", ERCHTMS.Code.OperatorProvider.Provider.Current().OrganizeCode)) + 1; for (int i = 0; i < dt.Rows.Count; i++) { object[] vals = dt.Rows[i].ItemArray; if (IsEndRow(vals) == true) { break; } var msg = ""; if (Validate(i, vals, deptList, districtList, out msg) == true) { var entity = GenEntity(vals, deptList, districtList, "P1-" + eno.ToString().PadLeft(4, '0')); equipmentbll.SaveForm("", entity); eno++; sussceed++; } else { falseMessage += "第" + (i + 1) + "行" + msg + "</br>"; error++; } } count = dt.Rows.Count; message = "共有" + count + "条记录,成功导入" + sussceed + "条,失败" + error + "条"; message += "</br>" + falseMessage; //删除临时文件 System.IO.File.Delete(filePath); } return(message); }
private void GetDistrictList(HttpContext context) { int parentId = EMT.Tools.Common.StrToInt(HttpContext.Current.Request["pid"], 1); var list = new DistrictBLL().GetDistrictList(parentId); var result = new ApiResultDto { code = 0, data = list }; context.Response.Write(new Tools.Serialize().SerializeJson(result)); return; }
public string GetAreas(string OrgId = "") { DistrictBLL districtBLL = new DistrictBLL(); var data = districtBLL.GetList(OrgId); StringBuilder sb = new StringBuilder(); foreach (DistrictEntity dist in data) { sb.AppendFormat("<option value='{0}'>{1}</option>", dist.DistrictID, dist.DistrictName); } return(sb.ToString()); }
public ActionResult SaveForm(string ID, string DistrictId, string PostList, string ModelIds) { DistrictBLL disbll = new DistrictBLL(); var dis = disbll.GetEntity(DistrictId); ArealocationEntity Area = new ArealocationEntity(); Area.AreaCode = dis.DistrictCode; Area.AreaId = DistrictId; Area.AreaName = dis.DistrictName; Area.AreaParentId = dis.ParentID; if (ID == "") { Area.Create(); } else { Area.Modify(ID); } Area.AreaParentId = dis.ParentID; Area.PointList = PostList; Area.ModelIds = ModelIds; arealocationbll.SaveForm(ID, Area); KbsAreaLocation ka = new KbsAreaLocation(); ka.DistrictCode = Area.AreaCode; ka.DistrictID = Area.AreaId; ka.DistrictName = Area.AreaName; ka.ID = Area.ID; ka.ModelIds = Area.ModelIds; ka.OrganizeId = dis.OrganizeId; ka.ParentID = Area.AreaParentId; ka.PointList = Area.PointList; ka.SortCode = dis.SortCode; SendData sd = new SendData(); if (ID == "") { sd.DataName = "AddArea"; } else { sd.DataName = "UpdateArea"; } sd.EntityString = JsonConvert.SerializeObject(ka); //将新绑定的标签信息同步到后台计算服务中 RabbitMQHelper rh = RabbitMQHelper.CreateInstance(); rh.SendMessage(JsonConvert.SerializeObject(sd)); return(Success("操作成功。")); }
/// <summary> /// to get district names /// </summary> /// <returns></returns> private void GetDistrictName() { DistrictBLL BLLobj = new DistrictBLL(); ddlDistrictName.DataSource = BLLobj.GetDistrict(); ddlDistrictName.DataTextField = "DISTRICTNAME"; ddlDistrictName.DataValueField = "DISTRICTID"; ddlDistrictName.DataBind(); //DDLSearchDistrictName.DataSource = BLLobj.GetDistrict(); //DDLSearchDistrictName.DataTextField = "DISTRICTNAME"; //DDLSearchDistrictName.DataValueField = "DISTRICTID"; //DDLSearchDistrictName.DataBind(); }
//protected void ChangePage(object sender, GridViewPageEventArgs e) //{ // grdDistrict.PageIndex = e.NewPageIndex; // BindGrid(); //} /// <summary> /// to get details to textbox /// </summary> /// <returns></returns> private void GetDistrictById() { DistrictBLL DistrictBLLobj = new DistrictBLL(); DistrictBO DistrictBOobj = DistrictBLLobj.GetDistrictById(Convert.ToInt32(ViewState["DISTRICTID"])); if (DistrictBOobj != null) { txtDistrict.Text = DistrictBOobj.DistrictName; } DistrictBOobj = null; DistrictBLLobj = null; }
public ActionResult SignupStep3(PartnerCompanyInfoDTO companyInfo) { Connector connector = WebApp.Connector; RegionBLL regionBLL = new RegionBLL(connector); ProvinceBLL provinceBLL = new ProvinceBLL(connector); DistrictBLL districtBLL = new DistrictBLL(connector); CountryDTO country = companyInfo.Country; RegionDTO region = companyInfo.Region; ProvinceDTO province = companyInfo.Province; DistrictDTO district = companyInfo.District; if (country != null) { country.Regions = regionBLL.ReadByCountry(country.Id); if (region != null) { region.Country = country; } if (province != null) { province.Country = country; } if (district != null) { district.Country = country; } } if (region != null) { region.Provinces = provinceBLL.ReadByCountryAndRegion(country.Id, region.Code); } if (province != null) { province.Districts = districtBLL.ReadByCountryAndRegionAndProvince(country.Id, region.Code, province.Code); } if (ModelState.IsValid) { Session["Signup$CompanyInfo"] = companyInfo; return(RedirectToAction("SignupStep4")); } else { CountryBLL countryBLL = new CountryBLL(WebApp.Connector); ViewBag.Countries = countryBLL.ReadAll(); return(BadRequestWithErrors(companyInfo)); } }
public bool BLLIsExistDistrict(DistrictBLL dt) { bool flag = false; int i; flag = districtBLLObj.DALIsExistDistrict(dt); if (flag == false) { i = districtBLLObj.DALDistrictUpdate(dt); if (i == 0) { flag = true; } } return(flag); }
public string GetAreasOptionsStringByAreaId(string areaId) { if (string.IsNullOrEmpty(areaId)) { return(GetAreasOptionsString()); } else { DistrictBLL districtBLL = new DistrictBLL(); var data = districtBLL.GetNameAndID(areaId); StringBuilder sb = new StringBuilder(); foreach (DataRow dr in data.Rows) { sb.AppendFormat("<option value='{0}'>{1}</option>", dr["DistrictID"].ToString(), dr["DistrictName"].ToString()); } return(sb.ToString()); } }
/// <summary> /// To update details to database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void UpdateBudgetItem() { DistrictBLL DistrictBLLobj = new DistrictBLL(); DistrictBO DistrictBOobj = new DistrictBO(); string message = ""; try { if (ViewState["District_ID"] != null) { DistrictBOobj.DistrictID = Convert.ToInt32(ViewState["District_ID"].ToString()); } string uID = string.Empty; uID = Session["USER_ID"].ToString(); DistrictBOobj.DistrictName = txtDistrict.Text.Trim(); DistrictBOobj.UpdatedBy = Convert.ToInt32(uID); message = DistrictBLLobj.UpdateDistrict(DistrictBOobj); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data updated successfully"; } ClearData(); SetUpdateMode(false); BindGrid(); if (message != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Updated", "alert('" + message + "');", true); } } catch (Exception ex) { throw ex; } finally { DistrictBLLobj = null; } }
public string GetLableChart() { List <object[]> list = new List <object[]>(); var data = basebll.GetPageList(""); DistrictBLL districtbll = new DistrictBLL(); List <DistrictEntity> AreaList = districtbll.GetListByOrgIdAndParentId("", "0"); List <KbsEntity> klist = new List <KbsEntity>(); foreach (var item in AreaList) { int num = 0; num = data.Where(it => it.AreaCode.Contains(item.DistrictCode)).Count(); object[] arr = { item.DistrictName, num }; if (num > 0) { list.Add(arr); } } return(Newtonsoft.Json.JsonConvert.SerializeObject(list)); }
/// <summary> /// To save details to database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void SaveBudgetItem() { DistrictBLL DistrictBLLobj = new DistrictBLL(); DistrictBO DistrictBOobj = new DistrictBO(); string message = ""; string uID = string.Empty; uID = Session["USER_ID"].ToString(); DistrictBOobj.DistrictName = txtDistrict.Text.Trim(); DistrictBOobj.CreatedBy = Convert.ToInt32(uID); try { message = DistrictBLLobj.AddDistrict(DistrictBOobj); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data saved successfully"; } if (message != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); } ClearData(); BindGrid(); } catch (Exception ee) { throw ee; } finally { DistrictBLLobj = null; } }
public ActionResult GetCameraStatistics() { var data = kbscameramanagebll.GetPageList("").Where(a => a.CameraTypeId == 0); DistrictBLL districtbll = new DistrictBLL(); List <DistrictEntity> AreaList = districtbll.GetListByOrgIdAndParentId("", "0"); List <KbssEntity> klist = new List <KbssEntity>(); int Znum = 0; foreach (var item in AreaList) { KbssEntity kbs = new KbssEntity(); kbs.Name = item.DistrictName; kbs.Num = data.Where(a => a.AreaCode.Contains(item.DistrictCode)).Count(); kbs.DistrictCode = item.DistrictCode; Znum += kbs.Num; kbs.OnNum = data.Where(a => a.AreaCode.Contains(item.DistrictCode) && a.State == "在线").Count(); kbs.OffNum = data.Where(a => a.AreaCode.Contains(item.DistrictCode) && a.State == "离线").Count(); klist.Add(kbs); } for (int j = 0; j < klist.Count; j++) { double Proportion = 0; double offProportion = 0; double OnProportion = 0; if (Znum != 0) { Proportion = (double)klist[j].Num / Znum; offProportion = (double)klist[j].OffNum / Znum; OnProportion = (double)klist[j].OnNum / Znum; Proportion = Proportion * 100; offProportion = offProportion * 100; OnProportion = OnProportion * 100; } klist[j].Count = Znum; klist[j].OnProportion = OnProportion.ToString("0") + "%"; klist[j].OfflineProportion = offProportion.ToString("0") + "%"; klist[j].Proportion = Proportion.ToString("0") + "%"; } return(Content(klist.ToJson())); }
public string ImportObj(string objname, string objid, string objtype, string qyid, string qyname) { int error = 0; string message = "请选择格式正确的文件再导入!"; string falseMessage = ""; int count = HttpContext.Request.Files.Count; if (count > 0) { HttpPostedFileBase file = HttpContext.Request.Files[0]; if (string.IsNullOrEmpty(file.FileName)) { return(message); } if (!(file.FileName.Substring(file.FileName.IndexOf('.')).Contains("xls") || file.FileName.Substring(file.FileName.IndexOf('.')).Contains("xlsx"))) { return(message); } objtype = string.IsNullOrEmpty(objtype) ? "3" : objtype; string fileName = DateTime.Now.ToString("yyyyMMddHHmmss") + System.IO.Path.GetExtension(file.FileName); file.SaveAs(Server.MapPath("~/Resource/temp/" + fileName)); DataTable dt = ExcelHelper.ExcelImport(Server.MapPath("~/Resource/temp/" + fileName)); int success = 0; DistrictBLL districtbll = new DistrictBLL(); //先获取区域 IEnumerable <DistrictEntity> AreaList = districtbll.GetOrgList(OperatorProvider.Provider.Current().OrganizeId); List <SaftyCheckModel> sclist = new List <SaftyCheckModel>(); for (int i = 1; i < dt.Rows.Count; i++) { string checkObj = dt.Rows[i][0].ToString(); //检查对象 string content = dt.Rows[i][1].ToString(); //检查内容 // string desc = dt.Rows[i][2].ToString();//隐患描述 if (!string.IsNullOrEmpty(objname)) //选择了检查对象的情况下区域用对象中的数据 { if (!string.IsNullOrEmpty(content)) { string[] arrContent = content.TrimEnd('$').Split('$'); foreach (string str in arrContent) { if (!string.IsNullOrWhiteSpace(str)) { SaftyCheckModel sc = new SaftyCheckModel(); sc.CheckObject = objname; sc.CheckObjectId = objid; sc.CheckObjectType = objtype; sc.CheckContent = str; sc.RiskName = ""; if (AreaList.Where(it => it.DistrictID == qyid).FirstOrDefault() != null) { sc.BelongDistrictCode = AreaList.Where(it => it.DistrictID == qyid).FirstOrDefault().DistrictCode; } //else //{ // falseMessage += "</br>" + "检查对象区域值不在可选范围内,未能导入."; // error++; // continue; //} sc.BelongDistrictID = qyid; sc.BelongDistrict = qyname; sclist.Add(sc); success++; } } } } else//选择对象情况下用对象的区域 没有对象的情况下 才用导入文档中区域 { if (!string.IsNullOrEmpty(content)) { string[] arrContent = content.TrimEnd('$').Split('$'); objid = Guid.NewGuid().ToString(); int j = 0; foreach (string str in arrContent) { if (!string.IsNullOrWhiteSpace(str)) { SaftyCheckModel sc = new SaftyCheckModel(); sc.CheckObject = checkObj; sc.CheckObjectId = objid; sc.CheckObjectType = ""; sc.CheckContent = str; sc.RiskName = ""; sclist.Add(sc); success++; } } } } } //将导入成功的数据存入缓存中 CacheHelper.SetChache(sclist, "SaftyCheck"); count = dt.Rows.Count - 1; message = "共有" + success + "条记录,成功导入" + (success - error) + "条,失败" + error + "条"; message += "</br>" + falseMessage; } return(message); }
public DistrictController(DistrictBLL bll) { _bll = bll; }
//[AjaxOnly] //[HandlerAuthorize(PermissionMode.Ignore)] // [ValidateAntiForgeryToken] public string ImportGenericFirefighting() { if (OperatorProvider.Provider.Current().IsSystem) { return("超级管理员无此操作权限"); } string orgId = OperatorProvider.Provider.Current().OrganizeId;//所属公司 int error = 0; string message = "请选择格式正确的文件再导入!"; string falseMessage = ""; int count = HttpContext.Request.Files.Count; if (count > 0) { HttpPostedFileBase file = HttpContext.Request.Files[0]; if (string.IsNullOrEmpty(file.FileName)) { return(message); } if (!(file.FileName.Substring(file.FileName.IndexOf('.')).Contains("xls") || file.FileName.Substring(file.FileName.IndexOf('.')).Contains("xlsx"))) { return(message); } string fileName = DateTime.Now.ToString("yyyyMMddHHmmss") + System.IO.Path.GetExtension(file.FileName); file.SaveAs(Server.MapPath("~/Resource/temp/" + fileName)); DataTable dt = ExcelHelper.ExcelImport(Server.MapPath("~/Resource/temp/" + fileName)); int order = 1; string orgid = OperatorProvider.Provider.Current().OrganizeId; for (int i = 0; i < dt.Rows.Count; i++) { KeyPartEntity item = new KeyPartEntity(); order = i + 1; #region 重点防火部位名称 string partname = dt.Rows[i][0].ToString(); if (!string.IsNullOrEmpty(partname)) { item.PartName = partname; item.PartNo = partname; //var data = new DataItemCache().ToItemValue("PartName", partname); //if (data != null && !string.IsNullOrEmpty(data)) // item.PartNo = data; //else //{ // falseMessage += string.Format(@"第{0}行导入失败,重点防火部位名称不存在!</br>", order); // error++; // continue; //} } else { falseMessage += string.Format(@"第{0}行导入失败,重点防火部位名称不能为空!</br>", order); error++; continue; } #endregion #region 所在位置 string district = dt.Rows[i][1].ToString(); if (!string.IsNullOrEmpty(district)) { var disItem = new DistrictBLL().GetListForCon(x => x.DistrictName == district && x.OrganizeId == orgid).FirstOrDefault(); if (disItem != null) { item.DistrictId = disItem.DistrictID; item.DistrictCode = disItem.DistrictCode; item.District = district; } else { falseMessage += string.Format(@"第{0}行导入失败,所在位置不存在!</br>", order); error++; continue; } } else { falseMessage += string.Format(@"第{0}行导入失败,所在位置不能为空!</br>", order); error++; continue; } #endregion #region 责任部门 string dutydept = dt.Rows[i][2].ToString(); if (!string.IsNullOrEmpty(dutydept)) { var data = departBLL.GetList().FirstOrDefault(e => e.FullName == dutydept && e.OrganizeId == orgid); if (data != null) { item.DutyDept = dutydept; item.DutyDeptCode = data.EnCode; } else { falseMessage += string.Format(@"第{0}行导入失败,责任部门不存在!</br>", order); error++; continue; } } else { falseMessage += string.Format(@"第{0}行导入失败,责任部门不能为空!</br>", order); error++; continue; } #endregion #region 责任人 string dutyUser = dt.Rows[i][3].ToString(); if (!string.IsNullOrEmpty(dutyUser)) { var userEntity = userBLL.GetListForCon(x => x.RealName == dutyUser && x.OrganizeId == orgid).FirstOrDefault(); if (userEntity != null) { item.DutyUserId = userEntity.UserId; item.DutyUser = dutyUser; } else { falseMessage += string.Format(@"第{0}行导入失败,责任人不存在!</br>", order); error++; continue; } } else { falseMessage += string.Format(@"第{0}行导入失败,责任人不能为空!</br>", order); error++; continue; } #endregion #region 责任人电话 string dutyTel = dt.Rows[i][4].ToString(); if (!string.IsNullOrEmpty(dutyTel)) { item.DutyTel = dutyTel; } #endregion #region 建筑结构 string structure = dt.Rows[i][5].ToString(); if (!string.IsNullOrEmpty(structure)) { item.Structure = structure; var data = new DataItemCache().ToItemValue("Structure", structure); if (data != null && !string.IsNullOrEmpty(data)) { item.Structure = data; } else { falseMessage += string.Format(@"第{0}行导入失败,建筑结构不存在!</br>", order); error++; continue; } } //else //{ // falseMessage += string.Format(@"第{0}行导入失败,建筑结构不能为空!</br>", order); // error++; // continue; //} #endregion #region 建筑面积(m2) string acreage = dt.Rows[i][6].ToString(); int tempAcreage; if (!string.IsNullOrEmpty(acreage)) { if (int.TryParse(acreage, out tempAcreage)) { item.Acreage = tempAcreage; } else { falseMessage += string.Format(@"第{0}行导入失败,建筑面积(m2)必须为数字!</br>", order); error++; continue; } } //else //{ // falseMessage += string.Format(@"第{0}行导入失败,建筑面积(m2)不能为空!</br>", order); // error++; // continue; //} #endregion #region 主要存储物品 string storegoods = dt.Rows[i][7].ToString(); if (!string.IsNullOrEmpty(storegoods)) { item.StoreGoods = storegoods; } #endregion #region 主要灭火器装备 string outfireequip = dt.Rows[i][8].ToString(); if (!string.IsNullOrEmpty(outfireequip)) { item.OutfireEquip = outfireequip; } else { falseMessage += string.Format(@"第{0}行导入失败,主要灭火器装备不能为空!</br>", order); error++; continue; } #endregion #region 重点防火部位人数 string peoplenum = dt.Rows[i][9].ToString(); int tempPeopleNum; if (!string.IsNullOrEmpty(peoplenum)) { if (int.TryParse(peoplenum, out tempPeopleNum)) { item.PeopleNum = tempPeopleNum; } else { falseMessage += string.Format(@"第{0}行导入失败,重点防火部位人数必须为数字!</br>", order); error++; continue; } } #endregion #region 动火级别 string rank = dt.Rows[i][10].ToString(); if (!string.IsNullOrEmpty(rank)) { if (rank == "一级动火区域") { item.Rank = 1; } else if (rank == "二级动火区域") { item.Rank = 2; } else { falseMessage += string.Format(@"第{0}行导入失败,动火级别不存在!</br>", order); error++; continue; } } else { falseMessage += string.Format(@"第{0}行导入失败,动火级别不能为空!</br>", order); error++; continue; } #endregion #region 最近巡查日期(年月日) string latelypatroldate = dt.Rows[i][11].ToString(); DateTime tempLatelyPatrolDate; if (!string.IsNullOrEmpty(latelypatroldate)) { if (DateTime.TryParse(latelypatroldate, out tempLatelyPatrolDate)) { item.LatelyPatrolDate = tempLatelyPatrolDate; } else { falseMessage += string.Format(@"第{0}行导入失败,最近巡查日期不对!</br>", order); error++; continue; } } #endregion #region 巡查周期(天) string patrolperiod = dt.Rows[i][12].ToString(); int tempPatrolPeriod; if (!string.IsNullOrEmpty(patrolperiod)) { if (int.TryParse(patrolperiod, out tempPatrolPeriod)) { item.PatrolPeriod = tempPatrolPeriod; } else { falseMessage += string.Format(@"第{0}行导入失败,巡查周期(天)必须为数字!</br>", order); error++; continue; } } #endregion #region 次巡查日期 string nextpatroldate = dt.Rows[i][13].ToString(); DateTime tempNextPatrolDate; if (!string.IsNullOrEmpty(nextpatroldate)) { if (DateTime.TryParse(nextpatroldate, out tempNextPatrolDate)) { item.NextPatrolDate = tempNextPatrolDate; } else { falseMessage += string.Format(@"第{0}行导入失败,下次巡查日期不对!</br>", order); error++; continue; } } else { falseMessage += string.Format(@"第{0}行导入失败,下次巡查日期不能为空!</br>", order); error++; continue; } #endregion #region 使用状态 string employstate = dt.Rows[i][14].ToString(); if (!string.IsNullOrEmpty(employstate)) { if (employstate == "在用") { item.EmployState = 0; } else if (employstate == "停用") { item.EmployState = 1; } else if (employstate == "其他") { item.EmployState = 2; } else { falseMessage += string.Format(@"第{0}行导入失败,使用状态不存在!</br>", order); error++; continue; } } else { falseMessage += string.Format(@"第{0}行导入失败,使用状态不能为空!</br>", order); error++; continue; } #endregion #region 火灾危险性分析 string analyze = dt.Rows[i][15].ToString(); if (!string.IsNullOrEmpty(analyze)) { item.Analyze = analyze; } else { falseMessage += string.Format(@"第{0}行导入失败,火灾危险性分析不能为空!</br>", order); error++; continue; } #endregion #region 防火措施 string measure = dt.Rows[i][16].ToString(); if (!string.IsNullOrEmpty(measure)) { item.Measure = measure; } else { falseMessage += string.Format(@"第{0}行导入失败,防火措施不能为空!</br>", order); error++; continue; } #endregion //管理要求 string require = dt.Rows[i][17].ToString(); if (!string.IsNullOrEmpty(require)) { item.Require = require; } //备注 string remark = dt.Rows[i][18].ToString(); if (!string.IsNullOrEmpty(remark)) { item.Remark = remark; } try { keypartbll.SaveForm("", item); } catch { error++; } } count = dt.Rows.Count; message = "共有" + count + "条记录,成功导入" + (count - error) + "条,失败" + error + "条"; message += "</br>" + falseMessage; } return(message); }
public object GetEngineerDetails([FromBody] JObject json) { string res = json.Value <string>("json"); dynamic dy = JsonConvert.DeserializeObject <ExpandoObject>(res); string userid = dy.userid; //获取用户基本信息 OperatorProvider.AppUserId = userid; //设置当前用户 Operator curUser = OperatorProvider.Provider.Current(); if (null == curUser) { return(new { code = -1, count = 0, info = "请求失败,请登录!", data = new object() }); } try { string id = dy.data ?? ""; var disBll = new DistrictBLL(); var didBll = new DataItemDetailBLL(); var deptBll = new DepartmentBLL(); var data = outsouringengineerbll.GetEntity(id); if (!string.IsNullOrWhiteSpace(data.ENGINEERAREA)) { var area = disBll.GetEntity(data.ENGINEERAREA); if (area != null) { data.ENGINEERAREANAME = area.DistrictName; } } if (!string.IsNullOrWhiteSpace(data.ENGINEERTYPE)) { var listType = didBll.GetDataItem("ProjectType", data.ENGINEERTYPE).ToList(); if (listType != null && listType.Count > 0) { data.ENGINEERTYPENAME = listType[0].ItemName; } } if (!string.IsNullOrWhiteSpace(data.ENGINEERLEVEL)) { var listLevel = didBll.GetDataItem("ProjectLevel", data.ENGINEERLEVEL).ToList(); if (listLevel != null && listLevel.Count > 0) { data.ENGINEERLEVELNAME = listLevel[0].ItemName; } } if (!string.IsNullOrWhiteSpace(data.OUTPROJECTID)) { var dept = deptbll.GetEntity(data.OUTPROJECTID); data.OUTPROJECTCODE = dept.EnCode; data.OUTPROJECTNAME = dept.FullName; } //return Json(new //{ // code = 0, // info = "获取数据成功", // count = 0, // data = data //}, new JsonSerializerSettings() { DateFormatString = "yyyy-MM-dd HH:mm:ss" }); JsonSerializerSettings settings = new JsonSerializerSettings { //ContractResolver = new LowercaseContractResolver(dict_props), //转小写,并对指定的列进行自定义名进行更换 DateFormatString = "yyyy-MM-dd HH:mm:ss", //格式化日期 //NullValueHandling = NullValueHandling.Ignore 值为空则在JSON中体现 }; return(new { code = 0, info = "获取数据成功", count = 1, data = JObject.Parse(JsonConvert.SerializeObject(data, Formatting.None, settings)) }); //return new //{ // code = 0, // info = "获取数据成功", // count = 0, // data = data //}; } catch (Exception ex) { return(new { code = -1, count = 0, info = "获取失败,错误:" + ex.Message, data = new object() }); } }
public object GetInfo([FromBody] JObject json) { try { string res = json.Value <string>("json"); dynamic dy = JsonConvert.DeserializeObject <ExpandoObject>(res); string userId = dy.userid; string disid = dy.data.disid; var disBll = new DistrictBLL(); var didBll = new DataItemDetailBLL(); var deptBll = new DepartmentBLL(); //获取用户基本信息 OperatorProvider.AppUserId = userId; //设置当前用户 Operator user = OperatorProvider.Provider.Current(); var entity = techdisclosurebll.GetEntity(disid); var project = new OutsouringengineerBLL().GetEntity(entity.PROJECTID); if (project != null) { if (!string.IsNullOrWhiteSpace(project.OUTPROJECTID)) { var dept = new DepartmentBLL().GetEntity(project.OUTPROJECTID); project.OUTPROJECTCODE = dept.EnCode; project.OUTPROJECTNAME = dept.FullName; } //if (!string.IsNullOrWhiteSpace(project.ENGINEERAREA)) //{ // var area = disBll.GetEntity(project.ENGINEERAREA); // if (area != null) project.ENGINEERAREANAME = project.EngAreaName; //} if (!string.IsNullOrWhiteSpace(project.ENGINEERTYPE)) { var listType = didBll.GetDataItem("ProjectType", project.ENGINEERTYPE).ToList(); if (listType != null && listType.Count > 0) { entity.ENGINEERTYPENAME = listType[0].ItemName; } } if (!string.IsNullOrWhiteSpace(project.ENGINEERLEVEL)) { var listLevel = didBll.GetDataItem("ProjectLevel", project.ENGINEERLEVEL).ToList(); if (listLevel != null && listLevel.Count > 0) { entity.ENGINEERLEVELNAME = listLevel[0].ItemName; } } } else { var listLevel = didBll.GetDataItem("ProjectLevel", entity.ENGINEERLEVEL).ToList(); if (listLevel != null && listLevel.Count > 0) { entity.ENGINEERLEVELNAME = listLevel[0].ItemName; } var listType = didBll.GetDataItem("ProjectType", entity.ENGINEERTYPE).ToList(); if (listType != null && listType.Count > 0) { entity.ENGINEERTYPENAME = listType[0].ItemName; } } var listmaj = didBll.GetDataItem("BelongMajor", entity.DISCLOSUREMAJOR).ToList(); if (listmaj != null && listmaj.Count > 0) { entity.DISCLOSUREMAJORNAME = listmaj[0].ItemName; } var files = new FileInfoBLL().GetFiles(disid); //获取相关附件 var pics = new FileInfoBLL().GetFiles(disid + "01"); //获取相关附件 string webUrl = new DataItemDetailBLL().GetItemValue("imgUrl"); foreach (DataRow dr in files.Rows) { dr["filepath"] = dr["filepath"].ToString().Replace("~/", webUrl + "/"); } foreach (DataRow dr in pics.Rows) { dr["filepath"] = dr["filepath"].ToString().Replace("~/", webUrl + "/"); } List <AptitudeinvestigateauditEntity> AptitudeList = aptitudeinvestigateauditbll.GetAuditList(entity.ID); for (int i = 0; i < AptitudeList.Count; i++) { if (string.IsNullOrWhiteSpace(AptitudeList[i].AUDITSIGNIMG)) { AptitudeList[i].AUDITSIGNIMG = string.Empty; } else { AptitudeList[i].AUDITSIGNIMG = webUrl + AptitudeList[i].AUDITSIGNIMG.ToString().Replace("../../", "/").ToString(); } } //查询审核流程图 List <CheckFlowData> nodeList = new AptitudeinvestigateinfoBLL().GetAppFlowList(entity.ID, "13", curUser); var data = new { AuditInfo = AptitudeList, nodeList = nodeList, project = project, entity = entity, piclist = pics, filelist = files }; Dictionary <string, string> dict_props = new Dictionary <string, string>(); //Id 转换前的列名 keyvalue 转换后的列名 //dict_props.Add("Id", "keyvalue"); JsonSerializerSettings settings = new JsonSerializerSettings { ContractResolver = new LowercaseContractResolver(dict_props), //转小写,并对指定的列进行自定义名进行更换 DateFormatString = "yyyy-MM-dd HH:mm", //格式化日期 //NullValueHandling = NullValueHandling.Ignore 值为空则在JSON中体现 }; return(new { code = 0, info = "获取数据成功", count = 1, data = JObject.Parse(JsonConvert.SerializeObject(data, Formatting.None, settings)) }); } catch (Exception ex) { return(new { code = -1, count = 0, info = ex.Message }); } }
public string ImportCamera() { int error = 0; string message = "请选择格式正确的文件再导入!"; string falseMessage = ""; int count = HttpContext.Request.Files.Count; if (count > 0) { HttpPostedFileBase file = HttpContext.Request.Files[0]; if (string.IsNullOrEmpty(file.FileName)) { return(message); } if (!(file.FileName.Substring(file.FileName.IndexOf('.')).Contains("xls") || file.FileName.Substring(file.FileName.IndexOf('.')).Contains("xlsx"))) { return(message); } string fileName = DateTime.Now.ToString("yyyyMMddHHmmss") + System.IO.Path.GetExtension(file.FileName); file.SaveAs(Server.MapPath("~/Resource/temp/" + fileName)); DataTable dt = ExcelHelper.ExcelImport(Server.MapPath("~/Resource/temp/" + fileName)); int order = 1; DistrictBLL districtbll = new DistrictBLL(); List <DistrictEntity> AreaList = districtbll.GetListByOrgIdAndParentId("", ""); DataItemDetailBLL dataItemDetailBLL = new DataItemDetailBLL(); List <DataItemModel> data = dataItemDetailBLL.GetDataItemListByItemCode("'CameraType'").ToList(); for (int i = 0; i < dt.Rows.Count; i++) { string CameraID = dt.Rows[i][0].ToString(); string CameraName = dt.Rows[i][1].ToString(); string CameraType = dt.Rows[i][2].ToString(); string CameraTypeId = ""; //区域 string AreaName = dt.Rows[i][3].ToString(); string AreaValue = ""; string AreaCode = ""; //楼层编号 string FloorNo = dt.Rows[i][4].ToString(); string CameraPoint = dt.Rows[i][5].ToString(); string CameraIp = dt.Rows[i][6].ToString(); if (string.IsNullOrEmpty(CameraID)) { falseMessage += "</br>" + "第" + (i + 2) + "摄像头ID为空,未能导入."; error++; continue; } if (string.IsNullOrEmpty(CameraName)) { falseMessage += "</br>" + "第" + (i + 2) + "摄像头名称为空,未能导入."; error++; continue; } if (string.IsNullOrEmpty(CameraType)) { falseMessage += "</br>" + "第" + (i + 2) + "摄像头类别为空,未能导入."; error++; continue; } if (string.IsNullOrEmpty(AreaName)) { falseMessage += "</br>" + "第" + (i + 2) + "区域名称为空,未能导入."; error++; continue; } if (string.IsNullOrEmpty(FloorNo)) { falseMessage += "</br>" + "第" + (i + 2) + "楼层编号为空,未能导入."; error++; continue; } if (string.IsNullOrEmpty(CameraPoint)) { falseMessage += "</br>" + "第" + (i + 2) + "摄像头坐标为空,未能导入."; error++; continue; } if (string.IsNullOrEmpty(CameraIp)) { falseMessage += "</br>" + "第" + (i + 2) + "IP地址为空,未能导入."; error++; continue; } var IP = @"(^(\d+)\.(\d+)\.(\d+)\.(\d+)$)";//@"/^(\d+)\.(\d+)\.(\d+)\.(\d+)$/g"; var point = @"(^\d{1,9}(.\d{1,2});\d{1,9}(.\d{1,2})$)"; ////验证是否是IP if (!Regex.IsMatch(CameraIp, IP)) { falseMessage += "</br>" + "第" + (i + 2) + "行IP地址格式填写错误,未能导入."; error++; continue; } ////验证是否是坐标 if (!Regex.IsMatch(CameraPoint, point)) { falseMessage += "</br>" + "第" + (i + 2) + "行坐标格式填写错误,格式应为xx.xx;xx.xx,未能导入."; error++; continue; } var ct = data.Where(it => it.ItemName == CameraType).FirstOrDefault(); if (ct == null) { falseMessage += "</br>" + "第" + (i + 2) + "行摄像头类别填写错误,未找到对应的摄像头类别,未能导入."; error++; continue; } CameraTypeId = ct.ItemValue; var area = AreaList.Where(it => it.DistrictName == AreaName).FirstOrDefault(); if (area == null) { falseMessage += "</br>" + "第" + (i + 2) + "行区域名称填写错误,未找到对应的区域,未能导入."; error++; continue; } AreaValue = area.DistrictID; AreaCode = area.DistrictCode; KbscameramanageEntity kbs = new KbscameramanageEntity(); kbs.AreaCode = AreaCode; kbs.AreaName = AreaName; kbs.CameraId = CameraID; kbs.CameraName = CameraName; kbs.CameraType = CameraType; kbs.FloorNo = FloorNo; kbs.OperuserName = OperatorProvider.Provider.Current().UserName; kbs.AreaId = AreaValue; kbs.CameraIP = CameraIp; kbs.CameraPoint = CameraPoint; kbs.CameraTypeId = Convert.ToInt32(CameraTypeId); kbs.State = "在线"; try { kbscameramanagebll.SaveForm("", kbs); } catch { error++; } } count = dt.Rows.Count; message = "共有" + count + "条记录,成功导入" + (count - error) + "条,失败" + error + "条"; message += "</br>" + falseMessage; } return(message); }