public List <ZRZ> findByExample(ZRZ key)
{
if (key == null)
{
return(null);
}
return(useDbContext(ctx => {
IQueryable <ZRZ> query = ctx.ZRZ.Where(zrz => (zrz.ZT == 0 || zrz.ZT == 1));
if (!String.IsNullOrEmpty(key.XMMC))
{
query = query.Where(zrz => zrz.XMMC.Contains(key.XMMC));
}
if (!String.IsNullOrEmpty(key.ZDDM))
{
query = query.Where(zrz => zrz.ZDDM == key.ZDDM);
}
if (!String.IsNullOrEmpty(key.ZRZH))
{
query = query.Where(zrz => zrz.ZRZH == key.ZRZH);
}
if (!String.IsNullOrEmpty(key.JZWMC))
{
query = query.Where(zrz => zrz.JZWMC.Contains(key.JZWMC));
}
return query.OrderBy(zrz => zrz.XMMC).ThenBy(zrz => zrz.JZWMC).ToList();
}));
}
private void list_zrz_SelectedIndexChanged(object sender, EventArgs e)
{
ZRZ zrz = (ZRZ)list_zrz.SelectedItem;
loadLjzList(zrz);
this.selectedZrz = zrz;
}
private void b_associate_zrz_Click(object sender, EventArgs e)
{
if (!String.IsNullOrEmpty(ljz.ZRZH))
{
DialogResult confirm = UiUtils.confirm(this, "警告", "该操作将重新关联逻辑幢与自然幢的关联关系，逻辑幢和逻辑幢下所有房屋的不动产单元号将会受到影响,是否继续操作？");
if (confirm != DialogResult.Yes)
{
return;
}
}
try
{
FormZrzSelect f = new FormZrzSelect();
DialogResult r = f.ShowDialog(this);
if (r == DialogResult.OK)
{
ZRZ zrz = f.getSelectedData();
ls.associateZrz(ljz, zrz);
tb_zrzh.Text = zrz.ZRZH;
}
}catch (Exception ex)
{
UiUtils.alertException(this, ex);
}
}
public ZRZ newZrz(int dcxmId)
{
ZRZ z = new ZRZ();
z.ZT = 0;
z.QJDCXMID = dcxmId;
return(z);
}
private void loadLjzList(ZRZ zrz)
{
List <LJZ> list = ls.findByZrzh(zrz.ZRZH);
list_ljz.DataSource = list;
list_ljz.DisplayMember = "LJZH";
list_ljz.ValueMember = "fId";
}
//保存或更新 ZRZ
public void saveWithoutValidate(ZRZ zrz)
{
useTransaction(ctx =>
{
insertOrUpdate(zrz, ctx);
return(zrz);
});
}
public void importZrzFeatures(int dcxmId, List <IFeature> features)
{
foreach (IFeature feature in features)
{
ZRZ zrz = zrzServ.newZrz(dcxmId);
zrz.SHAPE = ArcgisService.featureToDbGeometry(feature);
zrzServ.saveWithoutValidate(zrz);
}
}
private void b_ok_Click(object sender, EventArgs e)
{
if (dgv.SelectedRows.Count == 0)
{
UiUtils.alertInfo(this, "错误", "请选择一个自然幢");
return;
}
selected = (ZRZ)dgv.SelectedRows[0].DataBoundItem;
this.DialogResult = DialogResult.OK;
this.Close();
}
public List <string> findZddmIntersectZrz(ZRZ zrz)
{
ITable table = ArcgisService.queryTable("ZDJBXX", "ZT in (0,1)");
IGeometry geom = ArcgisService.dbGeometryToGeometry(zrz.SHAPE);
List <IFeature> list = ArcgisService.spatialQuery(table as IFeatureClass, geom, esriSpatialRelEnum.esriSpatialRelIntersects);
List <string> result = new List <string>();
foreach (IFeature feature in list)
{
int idx_zddm = feature.Fields.FindField("ZDDM");
string dm = feature.Value[idx_zddm].ToString();
result.Add(dm);
}
return(result);
}
public string generateZl(H h)
{
ZRZ zrz = rs.findByZrzh(h.ZRZH);
ZDJBXX zd = zs.findByZdmd(zrz.ZDDM);
string zdzl = zd.ZL;
string jzwmc = zrz.JZWMC;
string dyh = ""+h.DYH;
if(!String.IsNullOrEmpty(dyh) && !dyh.Contains("单元"))
{
dyh += "单元";
}
string shbw = h.SHBW+"号";
string zl = zdzl + jzwmc + dyh + shbw;
return zl;
}
public H newH(int dcxmId, ZRZ zrz, LJZ ljz)
{
H h = new H();
h.QJDCXMID = dcxmId;
h.ZT = 0;
h.ZRZH = zrz.ZRZH;
h.ZRZBDCDYH = zrz.BDCDYH;
h.LJZH = ljz.LJZH;
h.LJZID = ljz.fId;
h.FWYT1 = ljz.FWYT1;
h.FWLX = "1";
h.FWXZ = "99";
h.GYTDMJ = zs.getZdmjByZddm(zrz.ZDDM);
return h;
}
private void create_h_Click(object sender, EventArgs e)
{
FormLjzSelect f = new FormLjzSelect();
DialogResult r = f.ShowDialog(this);
if (r == DialogResult.OK)
{
ZRZ z = f.selectedZrz;
LJZ l = f.selectedLjz;
H h = hs.newH(dcxm.fId, z, l);
FormH fh = new FormH(h);
DialogResult rh = fh.ShowDialog(this);
if (rh == DialogResult.OK)
{
loadHList();
}
}
}
private DialogResult promptEditForm(IFeature feature)
{
IFeatureClass fc = feature.Table as IFeatureClass;
string name = fc.AliasName;
if (name.Contains("ZDJBXX"))
{
ZDJBXX zd = zdServ.findById(feature.OID);
FormZdjbxx form = new FormZdjbxx(zd);
return(form.ShowDialog(this));
}
else if (name.Contains("ZRZ"))
{
ZRZ zrz = zrzServ.findById(feature.OID);
FormZrz form = new FormZrz(zrz);
return(form.ShowDialog(this));
}
else
{
MessageBox.Show("仅支持宗地和自然幢图层属性编辑。");
return(DialogResult.Abort);
}
}
private void search(ZRZ queryKey)
{
List <ZRZ> list = zs.findByExample(queryKey);
loadDgvData(list);
}
public void validate(ZRZ zrz)
{
if (!StringUtils.checkZddm(zrz.ZDDM))
{
throw new Exception("宗地代码无效");
}
if (String.IsNullOrEmpty(zrz.BDCDYH))
{
throw new Exception("不动产单元号不能为空");
}
if (String.IsNullOrEmpty(zrz.ZRZH))
{
throw new Exception("自然幢号不能为空");
}
if (zrz.SHAPE == null)
{
throw new Exception("自然幢图形不能为空");
}
if (String.IsNullOrEmpty(zrz.XMMC))
{
throw new Exception("项目名称不能为空");
}
if (String.IsNullOrEmpty(zrz.JZWMC))
{
throw new Exception("建筑物名称不能为空");
}
if (String.IsNullOrEmpty(zrz.GHYT))
{
throw new Exception("规划用途称不能为空");
}
if (String.IsNullOrEmpty(zrz.FWJG))
{
throw new Exception("建筑物结构不能为空");
}
if (zrz.ZTS == null)
{
throw new Exception("总套数不能为空");
}
if (zrz.ZCS == null)
{
throw new Exception("总层数不能为空");
}
if (zrz.ZCS == null)
{
throw new Exception("幢占地面积不能为空");
}
if (zrz.ZYDMJ == null)
{
throw new Exception("幢用地面积不能为空");
}
if (zrz.SCJZMJ == null)
{
throw new Exception("实测建筑面积不能为空");
}
}
public FormZrz(ZRZ zrz)
{
InitializeComponent();
this.zrz = zrz;
init();
}
private string getZrzDisplayText(ZRZ zrz)
{
return(zrz.ZRZH == null ? "未编号建筑物" : (zrz.ZRZH + "(" + zrz.JZWMC + ")"));
}
