m_Plane = new Document();
}
}
private int LoadFromDB()
{
try
{
DataSet _landDataSet = new DataSet();
string _queryLand = "SELECT t_land.* FROM t_land WHERE id_land = " + m_IDLand. ToString();
OleDbDataAdapter _landDataAdapter = new OleDbDataAdapter(_queryLand, Program. accessConnection);
_landDataAdapter. Fill(_landDataSet, "t_land");
if (_landDataSet. Tables["t_land"].Rows. Count == 0) return Constants. LOAD_NO_DATA;
DataRow _row = _landDataSet. Tables["t_land"].Rows[0];
m_NumCadastr = _row["num_cadastr"] as string;
m_Area = (float)_row["area"];
m_Price = (float)_row["price"];
m_DateReestr = (DateTime)_row["date_reestr"];
m_Address = new Address(_row["addr_region"] as string, _row["addr_district"] as string, _row["addr_city"] as string, _row["addr_place"] as string, _row["addr_street"] as string, _row["addr_home"] as string, "", "");
return Constants. LOAD_OK;
}
catch (OleDbException _ex)
{
return Constants. LOAD_NO_DATA;
}
}
public int SaveToDB()
{
try
{
string _commText = "";
if (m_IDLand == 0)
{
m_IDLand = GetNewID();
_commText = String. Format("INSERT INTO t_land ([id_land],[num_cadastr],[area],[price],[date_reestr],[addr_region],[addr_district],[addr_city],[addr_place],[addr_street],[addr_home]) VALUES ({0},'{1}',{2},{3},'{4}','{5}','{6}','{7}','{8}','{9}','{10}')", m_IDLand. ToString(), m_NumCadastr, m_Area. ToString(), m_Price. ToString(), m_DateReestr. ToShortDateString(), m_Address. m_Region, m_Address. m_District, m_Address. m_City, m_Address. m_Place, m_Address. m_Street, m_Address. m_House);
}
else
{
_commText = String. Format("UPDATE t_land SET [num_cadastr]='{1}',[area]={2},[price]={3},[date_reestr]='{4}',[addr_region]='{5}',[addr_district]='{6}',[addr_city]='{7}',[addr_place]='{8}',[addr_street]='{9}',[addr_home]='{10}' WHERE [id_land]={0}", m_IDLand. ToString(), m_NumCadastr, m_Area. ToString(), m_Price. ToString(), m_DateReestr. ToShortDateString(), m_Address. m_Region, m_Address. m_District, m_Address. m_City, m_Address. m_Place, m_Address. m_Street, m_Address. m_House);
}
OleDbCommand _command = new OleDbCommand(_commText, Program. accessConnection);
int _result = _command. ExecuteNonQuery();
if (_result == 1)
{
m_Plane. m_IDLand = m_IDLand;
m_Plane. m_TypeDoc = 2;
m_Plane. SaveToDB();
m_OwnRegistr. m_IDLand = m_IDLand;
m_OwnRegistr. m_TypeDoc = 3;
m_OwnRegistr. SaveToDB();
return Constants. LOAD_OK;
}
else return Constants. LOAD_NO_DATA;
}
catch (OleDbException _ex)
{
return Constants. LOAD_NO_DATA;
}
}
private int GetNewID()
{
int _newID = 0;
try
{
OleDbCommand _command = new OleDbCommand("SELECT Max(id_land) FROM t_land", Program. accessConnection);
mandType = CommandType. Text;
object _obj = _command. ExecuteScalar();
_newID = ((_obj. Equals(DBNull. Value)) ? 0 : (int)_obj) + 1;
return _newID;
}
catch (OleDbException _ex)
{
return Constants. LOAD_NO_DATA;
}
}
}
}
Файл RealObject. cs
using System;
using System. Collections. Generic;
using System. Linq;
using System. Text;
using System. Data;
using System. Data. OleDb;
using System. Windows. Forms;
namespace Realty
{
public class RealObject
{
public int m_IDObject = 0;
public int m_TypeObject = 0;
public string m_NameObject = "";
public Address m_Address = null;
public float m_TotalVolume = 0;
public float m_OvergroundVolume = 0;
public float m_TotalArea = 0;
public float m_AddingArea = 0;
public int m_BuildCount = 0;
public int m_FloorCount = 0;
public int m_PlacesCount = 0;
public int m_VisitsCount = 0;
public int m_Capacity = 0;
public float m_Power = 0;
public float m_Productivity = 0;
public float m_Length = 0;
public int m_SectionCount = 0;
public int m_AppartmentTotal = 0;
public int m_OneRoomCnt = 0;
public int m_TwoRoomCnt = 0;
public int m_ThreeRoomCnt = 0;
public int m_FourRoomCnt = 0;
public int m_ManyRoomCnt = 0;
public float m_LiveArea = 0;
public int m_BaseMaterial = 0;
public int m_WallMaterial = 0;
public int m_FloorMaterial = 0;
public int m_RoofMaterial = 0;
public string m_BaseMaterialStr = "";
public string m_WallMaterialStr = "";
public string m_FloorMaterialStr = "";
public string m_RoofMaterialStr = "";
public float m_TotalPrice = 0;
public float m_BuildingPrice = 0;
public Document m_Document = null;
public int m_ResultDB = Constants. LOAD_OK;
public RealObject()
{}
public RealObject(int _index = 0)
{
m_IDObject = _index;
if (m_IDObject > 0)
{
m_ResultDB = LoadFromDB();
}
else
{
m_Address = new Address();
}
m_Document = new Document(0, m_IDObject, 0, 0);
}
private int LoadFromDB()
{
try
{
DataSet _objectDataSet = new DataSet();
string _queryObject = "SELECT t_objects.* FROM t_objects WHERE id_object = " + m_IDObject. ToString();
OleDbDataAdapter _objectDataAdapter = new OleDbDataAdapter(_queryObject, Program. accessConnection);
_objectDataAdapter. Fill(_objectDataSet, "t_object");
if (_objectDataSet. Tables["t_object"].Rows. Count == 0) return Constants. LOAD_NO_DATA;
DataRow _row = _objectDataSet. Tables["t_object"].Rows[0];
m_TypeObject = (int)_row["type_object"];
m_NameObject = _row["name_object"] as string;
m_Address = new Address(_row["addr_region"] as string, _row["addr_district"] as string, _row["addr_city"] as string, _row["addr_place"] as string, _row["addr_street"] as string, _row["addr_home"] as string, "", "");
m_TotalVolume = (float)_row["total_volume"];
m_OvergroundVolume = (float)_row["overground_volume"];
object _obj = _row["total_area"];
m_TotalArea = (float)_row["total_area"];
m_AddingArea = (float)_row["adding_area"];
m_BuildCount = (int)_row["build_count"];
m_FloorCount = (int)_row["floor_count"];
m_PlacesCount = (int)_row["places_count"];
m_VisitsCount = (int)_row["visits_count"];
m_Capacity = (int)_row["capacity"];
m_Power = (float)_row["power"];
m_Productivity = (float)_row["productivity"];
m_Length = (float)_row["length"];
m_SectionCount = (int)_row["section_count"];
m_AppartmentTotal = (int)_row["appartment_total"];
m_OneRoomCnt = (int)_row["oneroom_cnt"];
m_TwoRoomCnt = (int)_row["tworoom_cnt"];
m_ThreeRoomCnt = (int)_row["threeroom_cnt"];
m_FourRoomCnt = (int)_row["fourroom_cnt"];
m_ManyRoomCnt = (int)_row["manyroom_cnt"];
m_LiveArea = (float)_row["live_area"];
m_BaseMaterial = (int)_row["base_material"];
m_WallMaterial = (int)_row["wall_material"];
m_FloorMaterial = (int)_row["floor_material"];
m_RoofMaterial = (int)_row["roof_material"];
m_TotalPrice = (float)_row["total_price"];
m_BuildingPrice = (float)_row["building_price"];
//Загрузка строковых значений из справочников
string _querySpr = String. Format("SELECT val_2 FROM t_sprav WHERE id_sprav=5 AND id_item={0}", m_BaseMaterial);
OleDbCommand _command = new OleDbCommand(_querySpr, Program. accessConnection);
m_BaseMaterialStr = _command. ExecuteScalar() as string;
_querySpr = String. Format("SELECT val_2 FROM t_sprav WHERE id_sprav=5 AND id_item={0}", m_WallMaterial);
_command = new OleDbCommand(_querySpr, Program. accessConnection);
m_WallMaterialStr = _command. ExecuteScalar() as string;
_querySpr = String. Format("SELECT val_2 FROM t_sprav WHERE id_sprav=5 AND id_item={0}", m_FloorMaterial);
_command = new OleDbCommand(_querySpr, Program. accessConnection);
m_FloorMaterialStr = _command. ExecuteScalar() as string;
_querySpr = String. Format("SELECT val_2 FROM t_sprav WHERE id_sprav=5 AND id_item={0}", m_RoofMaterial);
_command = new OleDbCommand(_querySpr, Program. accessConnection);
m_RoofMaterialStr = _command. ExecuteScalar() as string;
return Constants. LOAD_OK;
}
catch (OleDbException _ex)
{
return Constants. LOAD_NO_DATA;
}
}
public int SaveToDB()
{
try
{
string _commText = "";
if (m_IDObject == 0)
{
m_IDObject = GetNewID();
_commText = String. Format("INSERT INTO t_objects (id_object, type_object, name_object, addr_region, addr_district, addr_city, addr_place, addr_street, addr_home, total_volume, overground_volume, total_area, adding_area, build_count, floor_count, places_count, visits_count, capacity, power, productivity, length, section_count, appartment_total, oneroom_cnt, tworoom_cnt, threeroom_cnt, fourroom_cnt, manyroom_cnt, live_area, base_material, wall_material, floor_material, roof_material, total_price, building_price) VALUES ({0},{1},'{2}','{3}','{4}','{5}','{6}','{7}',{8},{9},{10},{11},{12},{13},{14},{15},{16},{17},{18},{19},{20},{21},{22},{23},{24},{25},{26},{27},{28},{29},{30},{31},{32},{33},{34})",
|
Из за большого объема этот материал размещен на нескольких страницах:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 |
