protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) { return; } try { if (string.IsNullOrEmpty(Request.Form["id"])) { return; } var id = Request.Form["id"]; if (string.IsNullOrEmpty(Request.Form["name"])) { return; } var pcname = Request.Form["name"]; var bll = new OrgArea(); var model = bll.GetModel(id); model.AreaName = pcname; List <SqlParameter> parameters = new List <SqlParameter>(); var parameter = new SqlParameter("@AreaName", DbType.AnsiString) { Value = pcname }; parameters.Add(parameter); var parameter1 = new SqlParameter("@AreaId", DbType.AnsiString) { Value = id }; parameters.Add(parameter1); var parameter2 = new SqlParameter("@ParentId", DbType.AnsiString) { Value = model.ParentId }; parameters.Add(parameter2); if (bll.GetList(" AreaName=@AreaName and Status=1 and AreaId!=@AreaId ", parameters).Tables[0].Rows.Count > 0) { Response.Write("区域名称已存在"); Response.End(); } Response.Write(bll.Update(model) ? "修改成功" : "修改失败"); Response.End(); } catch (System.Threading.ThreadAbortException ex) { } catch (Exception) { Response.Write("修改失败"); Response.End(); } }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) { return; } try { if (string.IsNullOrEmpty(Request.Form["id"])) { return; } var id = Request.Form["id"]; if (string.IsNullOrEmpty(Request.Form["name"])) { return; } var pcname = Request.Form["name"]; var bll = new OrgArea(); List <SqlParameter> parameters = new List <SqlParameter>(); var parameter = new SqlParameter("@AreaName", DbType.AnsiString) { Value = pcname }; parameters.Add(parameter); if (bll.GetList(" AreaName=@AreaName and Status=1 ", parameters).Tables[0].Rows.Count > 0) { Response.Write("区域名称已存在"); Response.End(); } var model = new Admin.Model.OrgArea { AreaName = pcname, ParentId = id, AreaId = bll.MaxAreaId(), AreaLevel = 3, Status = 1 }; Response.Write(bll.Add(model) ? "保存成功" : "保存失败"); Response.End(); } catch (System.Threading.ThreadAbortException ex) { } catch (Exception) { Response.Write("保存失败"); Response.End(); } }
/// <summary> /// 根据机构id获取机构信息 /// </summary> /// <param name="id"></param> /// <returns></returns> public OrganDto GetOrganDtoInfo(Organ orginfo, string pName) { OrganDto model = new OrganDto(); try { model.id = orginfo.id; model.级id = orginfo.级id; model.称 = orginfo.称; model.地址 = orginfo.地址; model.性质 = orginfo.性质; model.执业证代码 = orginfo.执业证代码; model.机构码 = orginfo.机构码; model.电话 = orginfo.电话; model.简码 = orginfo.简码; model.简称 = orginfo.简称; model.组织机构代码证 = orginfo.组织机构代码证; model.编码 = orginfo.编码; model.行政级别 = orginfo.行政级别; model.级机构名称 = pName; //机构行政区划信息 if (!string.IsNullOrEmpty(orginfo.所属行政区划)) { using (var db = new DbContext()) { //根据编码查询行政区划 var sqlStr = db.GetSql("CA00004-根据编码查询行政区划", null, null); ISqlBuilder sqlBuilder = db.Sql(sqlStr).Parameters("bianma", orginfo.所属行政区划); //执行SQL脚本 var item = sqlBuilder.GetModel <OrgArea>(); //组装行政区划市区县数据,判断性质 if (item != null && item.level > 0) { var Areadata = item.code; GetAreaData(ref model, item.level, item.code, ref Areadata, item.bmcode); //根据性质反向查询 for (int i = 1; i <= item.level; i++) { if (Areadata == null) { continue; } var dd = new OrgArea(); if (item.level - i >= 0) { sqlStr = db.GetSql("CA00004-根据编码查询行政区划", null, null); sqlBuilder = db.Sql(sqlStr).Parameters("bianma", Areadata); //执行SQL脚本 dd = sqlBuilder.GetModel <OrgArea>(); GetAreaData(ref model, dd.level, dd.code, ref Areadata, dd.bmcode); } } } } } } catch (Exception ex) { Logger.Instance.Error("根据机构id获取机构信息错误:!", ex); } return(model); }