void IEditTableView.DbConnectOccur()
{
_isConnected = true;
if (this._tableName == "")
{
return;
}
SdeConnection conn = new SdeConnection();
ISdeConnectionInfo sdeConn = (ISdeConnectionInfo)conn;
IFeatureWorkspace fw = (IFeatureWorkspace)sdeConn.Workspace;
ITable table = null;
try
{
table = fw.OpenTable(this._tableName);
loadData(this._tableName);
}
catch (Exception e)
{
MessageBox.Show(string.Format("Không tìm thấy bảng {0}", this._tableName));
return;
}
this._sdeEditor = new SDETable(table, sdeConn.Workspace);
}
void ILandprice.LoadPrice()
{
_conn = new SdeConnection();
_sdeConn = (ISdeConnectionInfo)_conn;
_fw = (IFeatureWorkspace)_sdeConn.Workspace;
IQueryFilter qrf = new QueryFilterClass();
_fcName=new TnFeatureClassName(_sdeConn.Workspace);
_nameOfThuaGiaDat=string.Format("{0}_{1}",_tableName,_conf.NamApDung);
_nameOfThua=string.Format("{0}_{1}",DataNameTemplate.Thua,_conf.NamApDung);
try
{
_thuaGiaDatFc = _fw.OpenFeatureClass(_nameOfThuaGiaDat);
_thuaGiaDatTable = (ITable)_thuaGiaDatFc;
}
catch { MessageBox.Show(string.Format("Không tìm thấy bảng {0}", _nameOfThuaGiaDat)); return; }
try
{
_thuaFc = _fw.OpenFeatureClass(_nameOfThua);
_thuaTable = (ITable)_thuaFc;
}
catch { MessageBox.Show(string.Format("Không tìm thấy bảng {0}", _nameOfThua)); return; }
_fcName.FC_THUA_GIADAT.NAME = _nameOfThuaGiaDat;
_fcName.FC_THUA_GIADAT.InitIndex();
_fcName.FC_THUA.NAME = _nameOfThua;
_fcName.FC_THUA.InitIndex();
_editorThua = new SDETable(_thuaTable, _sdeConn.Workspace);
_editorTgd = new SDETable(_thuaGiaDatTable, _sdeConn.Workspace);
List<ThuaGiaDatInfo> thuaGiaDat = new List<ThuaGiaDatInfo>();
if (this._mathua != null)
{
//object giadat;
//object dongia;
//object dientich;
//object dientichpl;
//object giadatTheoDientich;
int khoaGia;
//int khoaGiaTay;
//int khoaGiaTuDong;
//object khoaViTri;
//object soMatTien;
//object soMatHem;
//object cachtinh;
qrf.WhereClause = string.Format("{0}='{1}'", _fcName.FC_THUA.MA_THUA, _mathua);
IFeatureCursor thuaFcur = _thuaFc.Search(qrf, false);
IFeature thuaFt = null;
int khoavitri = 0;
bool result = false;
try
{
if ((thuaFt = thuaFcur.NextFeature()) != null)
{
result = int.TryParse(thuaFt.get_Value(thuaFt.Fields.FindField(_fcName.FC_THUA.LOCKED)).ToString(), out khoavitri);
if (!result)
{
khoavitri = 0;
}
}
}
catch (Exception e1) { MessageBox.Show(string.Format("Line 172 - GLandprice - {0}", e1)); }
finally { Marshal.ReleaseComObject(thuaFcur); }
qrf.WhereClause = string.Format("{0}='{1}'", _fcName.FC_THUA_GIADAT.MA_THUA, _mathua);
//MessageBox.Show(string.Format("line 139 {0}", qrf.WhereClause));
IFeatureCursor fcur=_thuaGiaDatFc.Search(qrf, false);
IFeature ft = null;
try
{
int i = 0;
while ((ft = fcur.NextFeature()) != null)
{
thuaGiaDat.Add(new ThuaGiaDatInfo());
//MessageBox.Show(string.Format("line 147 - {0}_{1}",thuaGiaDat.Count,i));
thuaGiaDat[i].Mathua = this._mathua;
thuaGiaDat[i].Oid = ft.get_Value(ft.Fields.FindField(_fcName.FC_THUA_GIADAT.OID));
thuaGiaDat[i].Dongia = ft.get_Value(ft.Fields.FindField(_fcName.FC_THUA_GIADAT.DON_GIA));
thuaGiaDat[i].Giadat = ft.get_Value(ft.Fields.FindField(_fcName.FC_THUA_GIADAT.GIA_DAT));
result=int.TryParse(ft.get_Value(ft.Fields.FindField(_fcName.FC_THUA_GIADAT.LOCKED)).ToString(),out khoaGia);
if(!result)
{
khoaGia=0;
}
thuaGiaDat[i].Khoagia = khoaGia;
thuaGiaDat[i].Hesovitri = ft.get_Value(ft.Fields.FindField(_fcName.FC_THUA_GIADAT.HE_SO_K));
thuaGiaDat[i].Cachtinh = ft.get_Value(ft.Fields.FindField(_fcName.FC_THUA_GIADAT.CACH_TINH));
thuaGiaDat[i].Dientich = ft.get_Value(ft.Fields.FindField(_fcName.FC_THUA_GIADAT.DIEN_TICH));
thuaGiaDat[i].Dientichpl = ft.get_Value(ft.Fields.FindField(_fcName.FC_THUA_GIADAT.DIEN_TICH_PHAP_LY));
thuaGiaDat[i].Maduong = ft.get_Value(ft.Fields.FindField(_fcName.FC_THUA_GIADAT.MA_DUONG));
thuaGiaDat[i].Mahem = ft.get_Value(ft.Fields.FindField(_fcName.FC_THUA_GIADAT.MA_HEM));
thuaGiaDat[i].KhoaVitri = khoavitri;
i++;
}
//MessageBox.Show(string.Format("line 157 - {0}_{1}", thuaGiaDat.Count, i));
//if (thuaGiaDat.Count > 0)
//{
_view.UpDate(thuaGiaDat);
//}
}
catch (Exception e1) { MessageBox.Show(string.Format("Line 167 - GLandprice - {0}", e1)); }
finally { Marshal.ReleaseComObject(fcur); }
}
}
