Пример #1
0
        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();
            }
        }
Пример #2
0
        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();
            }
        }
Пример #3
0
        /// <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);
        }