m_FirstName = _row["first_name"] as string;
m_SecondName = _row["second_name"] as string;
m_DateBirth = (DateTime)_row["date_birth"];
m_PlaceBirth = _row["place_birth"] 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,_row["addr_build"] as string, _row["addr_flat"] as string);
_clientDataSet. Dispose();
return Constants. LOAD_OK;
}
catch (OleDbException _ex)
{
return Constants. LOAD_NO_DATA;
}
}
public int SaveToDB()
{
try
{
string _commText = "";
if (m_ID == 0)
{
m_ID = GetNewID();
_commText = String. Format("INSERT INTO t_clients ([id_client],[last_name],[first_name],[second_name],[date_birth],[place_birth],[addr_region],[addr_district],[addr_city],[addr_place],[addr_street],[addr_home],[addr_build],[addr_flat]) VALUES ({0},'{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}')", m_ID. ToString(), m_LastName, m_FirstName, m_SecondName, m_DateBirth. ToShortDateString(),m_PlaceBirth, m_Address. m_Region, m_Address. m_District, m_Address. m_City, m_Address. m_Place, m_Address. m_Street, m_Address. m_House, m_Address. m_Build, m_Address. m_Appartment);
}
else
{
_commText = String. Format("UPDATE t_clients SET [last_name]='{1}',[first_name]='{2}',[second_name]='{3}',[date_birth]='{4}',[place_birth]='{5}',[addr_region]='{6}',[addr_district]='{7}',[addr_city]='{8}',[addr_place]='{9}',[addr_street]='{10}',[addr_home]='{11}',[addr_build]='{12}',[addr_flat]='{13}' WHERE [id_client]={0}", m_ID. ToString(), m_LastName, m_FirstName, m_SecondName, m_DateBirth. ToShortDateString(),m_PlaceBirth, m_Address. m_Region, m_Address. m_District, m_Address. m_City, m_Address. m_Place, m_Address. m_Street, m_Address. m_House, m_Address. m_Build, m_Address. m_Appartment);
}
OleDbCommand _command = new OleDbCommand(_commText, Program. accessConnection);
int _result = _command. ExecuteNonQuery();
if (_result == 1)
{
m_Document. m_IDClient = m_ID;
m_Document. 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_client) FROM t_clients", 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;
}
}
public string GetFullName()
{
return m_LastName + " " + m_FirstName + " " + m_SecondName;
}
}
}
Файл Document. cs
using System;
using System. Collections. Generic;
using System. Linq;
using System. Text;
using System. Data;
using System. Data. OleDb;
namespace Realty
{
public class Document
{
public int m_IDClient = 0;
public int m_IDObject = 0;
public int m_IDLand = 0;
public int m_IDDocument = 0;
public string m_Seria = "";
public string m_Number = "";
public DateTime m_DateIssue = DateTime. Today;
public string m_Issuer = "";
public int m_TypeDoc = 0;
public string m_TypeDocStr = "";
public int m_ResultDB=Constants. LOAD_OK;
public Document()
{}
public Document(int _idClient, int _idObject, int _idLand, int _typeDocument)
{
m_IDClient = _idClient;
m_IDObject = _idObject;
m_IDLand = _idLand;
m_TypeDoc = _typeDocument;
m_ResultDB = LoadFromDB();
}
private int LoadFromDB()
{
string _queryDocument;
string _queryType;
string _clientParam = (m_IDClient!= -1) ? String. Format(" id_client = {0} ",m_IDClient. ToString()) : " id_client > 0 ";
string _objectParam = (m_IDObject!= -1) ? String. Format(" id_object = {0} ",m_IDObject. ToString()) : " id_object > 0 ";
string _landParam = (m_IDLand!= -1) ? String. Format(" id_land = {0} ",m_IDLand. ToString()) : " id_land > 0 ";
try
{
DataSet _documentDataSet = new DataSet();
if (m_TypeDoc == 0) _queryDocument = "SELECT t_documents.* FROM t_documents WHERE "+_clientParam+" AND "+_objectParam+" AND "+_landParam;
else _queryDocument = String. Format("SELECT t_documents.* FROM t_documents WHERE "+_clientParam+" AND "+_objectParam+" AND "+_landParam+"AND type_document={0}", m_TypeDoc. ToString());
OleDbDataAdapter _documentDataAdapter = new OleDbDataAdapter(_queryDocument, Program. accessConnection);
_documentDataAdapter. Fill(_documentDataSet, "t_documents");
if (_documentDataSet. Tables["t_documents"].Rows. Count == 0) return Constants. LOAD_NO_DATA;
DataRow _row = _documentDataSet. Tables["t_documents"].Rows[0];
m_IDClient = (int)_row["id_client"];
m_IDObject = (int)_row["id_object"];
m_IDLand = (int)_row["id_land"];
m_TypeDoc = (int)_row["type_document"];
m_IDDocument = (int)_row["id_document"];
m_Seria = _row["seria"] as string;
m_Number = _row["number"] as string;
m_DateIssue = (DateTime)_row["date_issue"];
m_Issuer = _row["issuer"] as string;
if (m_IDObject == 0 && m_IDLand == 0) _queryType = String. Format("SELECT val_2 FROM t_sprav WHERE id_sprav=1 AND id_item={0}", m_TypeDoc);
else _queryType = String. Format("SELECT val_2 FROM t_sprav WHERE id_sprav=6 AND id_item={0}", m_TypeDoc);
OleDbCommand _command = new OleDbCommand(_queryType, Program. accessConnection);
m_TypeDocStr = _command. ExecuteScalar() as string;
_documentDataSet. Dispose();
return Constants. LOAD_OK;
}
catch (OleDbException _ex)
{
return Constants. LOAD_NO_DATA;
}
}
public int SaveToDB()
{
try
{
string _commText = "";
if (m_IDDocument == 0)
{
m_IDDocument = GetNewID();
_commText = String. Format("INSERT INTO t_documents ([id_client],[id_object],[id_land],[id_document],[seria],[number],[type_document],[date_issue],[issuer]) VALUES ({0},{1},{2},{3},'{4}','{5}',{6},'{7}','{8}')",m_IDClient. ToString(),m_IDObject. ToString(),m_IDLand. ToString(),m_IDDocument. ToString(),m_Seria, m_Number, m_TypeDoc. ToString(),m_DateIssue. ToShortDateString(),m_Issuer);
}
else
{
_commText = String. Format("UPDATE t_documents SET [seria]='{4}',[number]='{5}',[type_document]={6},[date_issue]='{7}',[issuer]='{8}' WHERE [id_client]={0} AND [id_object]={1} AND [id_land]={2} AND [id_document]={3}", m_IDClient. ToString(), m_IDObject. ToString(), m_IDLand. ToString(), m_IDDocument. ToString(), m_Seria, m_Number, m_TypeDoc. ToString(), m_DateIssue. ToShortDateString(), m_Issuer);
}
OleDbCommand _command = new OleDbCommand(_commText, Program. accessConnection);
int _result = _command. ExecuteNonQuery();
if (_result == 1) return Constants. LOAD_OK;
else return Constants. LOAD_NO_DATA;
}
catch (OleDbException _ex)
{
return Constants. LOAD_NO_DATA;
}
}
private int GetNewID()
{
int _newIDDocument = 0;
try
{
OleDbCommand _command = new OleDbCommand(String. Format("SELECT Max(id_document) FROM t_documents WHERE [id_client]={0} AND [id_object]={1} AND [id_land]={2}", m_IDClient. ToString(), m_IDObject. ToString(), m_IDLand. ToString()), Program. accessConnection);
mandType = CommandType. Text;
object _obj = _command. ExecuteScalar();
_newIDDocument = ((_obj. Equals(DBNull. Value)) ? 0 : (int)_obj) + 1;
return _newIDDocument;
}
catch (OleDbException _ex)
{
return Constants. LOAD_NO_DATA;
}
}
public string GetDocInfo()
{
return m_TypeDocStr + " " + m_Seria + " " + m_Number + " выдан " + m_DateIssue. ToShortDateString() + " " + m_Issuer;
}
}
}
Файл Land. cs
using System;
using System. Collections. Generic;
using System. Linq;
using System. Text;
using System. Data;
using System. Data. OleDb;
namespace Realty
{
public class Land
{
public int m_IDLand = 0;
public string m_NumCadastr = "";
public float m_Area = 0;
public float m_Price = 0;
public DateTime m_DateReestr = DateTime. Today;
public Address m_Address;
public Document m_Plane;
public Document m_OwnRegistr;
public int m_ResultDB = Constants. LOAD_OK;
public Land()
{}
public Land(int _index = 0)
{
m_IDLand = _index;
if (m_IDLand > 0)
{
m_ResultDB = LoadFromDB();
if (m_ResultDB == Constants. LOAD_OK)
{
m_OwnRegistr = new Document(-1, 0, m_IDLand, 0);
m_Plane = new Document(0, 0, m_IDLand, 0);
}
else
{
m_OwnRegistr = new Document();
m_Plane = new Document();
}
}
else
{
m_Address = new Address();
m_OwnRegistr = new Document();
|
Из за большого объема этот материал размещен на нескольких страницах:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 |
