Партнерка на США и Канаду по недвижимости, выплаты в крипто
- 30% recurring commission
- Выплаты в USDT
- Вывод каждую неделю
- Комиссия до 5 лет за каждого referral
m_IDObject. ToString(),
m_TypeObject,
m_NameObject,
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_TotalVolume,
m_OvergroundVolume,
m_TotalArea,
m_AddingArea,
m_BuildCount,
m_FloorCount,
m_PlacesCount,
m_VisitsCount,
m_Capacity,
m_Power,
m_Productivity,
m_Length,
m_SectionCount,
m_AppartmentTotal,
m_OneRoomCnt,
m_TwoRoomCnt,
m_ThreeRoomCnt,
m_FourRoomCnt,
m_ManyRoomCnt,
m_LiveArea,
m_BaseMaterial,
m_WallMaterial,
m_FloorMaterial,
m_RoofMaterial,
m_TotalPrice,
m_BuildingPrice);
}
else
{
_commText = String. Format("UPDATE t_objects SET type_object={1},name_object='{2}',addr_region='{3}',addr_district='{4}',addr_city='{5}',addr_place='{6}',addr_street='{7}',addr_home='{8}',total_volume={9},overground_volume={10},total_area={11},adding_area={12},build_count={13},floor_count={14},places_count={15},visits_count={16},capacity={17},power={18},productivity={19},length={20},section_count={21},appartment_total={22},oneroom_cnt={23},tworoom_cnt={24},threeroom_cnt={25},fourroom_cnt={26},manyroom_cnt={27},live_area={28},base_material={29},wall_material={30},floor_material={31},roof_material={32},total_price={33},building_price={34} WHERE id_object={0}",
m_IDObject. ToString(),
m_TypeObject,
m_NameObject,
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_TotalVolume,
m_OvergroundVolume,
m_TotalArea,
m_AddingArea,
m_BuildCount,
m_FloorCount,
m_PlacesCount,
m_VisitsCount,
m_Capacity,
m_Power,
m_Productivity,
m_Length,
m_SectionCount,
m_AppartmentTotal,
m_OneRoomCnt,
m_TwoRoomCnt,
m_ThreeRoomCnt,
m_FourRoomCnt,
m_ManyRoomCnt,
m_LiveArea,
m_BaseMaterial,
m_WallMaterial,
m_FloorMaterial,
m_RoofMaterial,
m_TotalPrice,
m_BuildingPrice);
}
OleDbCommand _command = new OleDbCommand(_commText, Program. accessConnection);
int _result = _command. ExecuteNonQuery();
if (_result == 1)
{
m_Document. m_IDObject = m_IDObject;
m_Document. m_TypeDoc = 1;
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_object) FROM t_objects", 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;
}
}
}
}
Файл Request. cs
using System;
using System. Collections. Generic;
using System. Linq;
using System. Text;
using System. Data;
using System. Data. OleDb;
using System. Windows. Forms;
using Microsoft. Office;
using Microsoft. Office. Interop;
using Microsoft. Office. Interop. Word;
namespace Realty
{
public class Request
{
public int m_IDRequest = 0;
public int m_TypeRequest = 0;
public string m_Number = "";
public int m_Status = 1;
public int m_IDClient = 0;
public int m_IDLand = 0;
public int m_IDObject = 0;
public DateTime m_DateRequest = DateTime. Today;
public DateTime m_DateProc = DateTime. Today;
public DateTime m_DateEnd = DateTime. Today;
public Client m_Client=null;
public RealObject m_Object = null;
public Land m_Land=null;
public int m_IDOper = Program. currentUser. m_IDUser;
public int m_IDProc = 0;
public User m_Oper=null;
public User m_Proc=null;
public int m_ResultDB = Constants. LOAD_OK;
private Object oMissing = System. Reflection. Missing. Value;
private Object oTrue = true;
private Object oFalse = false;
public Request(int _index, int _type)
{
m_IDRequest = _index;
m_TypeRequest = _type;
if (m_IDRequest > 0)
{
m_ResultDB = LoadFromDB();
}
}
private int LoadFromDB()
{
try
{
DataSet _requestDataSet = new DataSet();
string _queryRequest = "SELECT t_request.* FROM t_request WHERE id_request = " + m_IDRequest. ToString();
OleDbDataAdapter _requestDataAdapter = new OleDbDataAdapter(_queryRequest, Program. accessConnection);
_requestDataAdapter. Fill(_requestDataSet, "t_request");
if (_requestDataSet. Tables["t_request"].Rows. Count == 0) return Constants. LOAD_NO_DATA;
DataRow _row = _requestDataSet. Tables["t_request"].Rows[0];
m_TypeRequest = (int)_row["type_request"];
m_Number = _row["number"] as string;
m_Status = (int)_row["status"];
m_IDClient = (int)_row["id_client"];
m_IDLand = (int)_row["id_land"];
m_IDObject = (int)_row["id_object"];
m_DateRequest = (DateTime)_row["date_req"];
m_DateProc = (DateTime)_row["date_proc"];
m_DateEnd = (_row["date_end"].Equals(DBNull. Value)) ? DateTime. Today : (DateTime)_row["date_end"];
m_IDOper = (int)_row["id_oper"];
m_IDProc = (int)_row["id_proc"];
if (m_IDClient!= 0) m_Client = new Client(m_IDClient);
if (m_IDLand!= 0) m_Land = new Land(m_IDLand);
if (m_IDObject!= 0) m_Object = new RealObject(m_IDObject);
if (m_IDOper!= 0) m_Oper = new User(m_IDOper);
if (m_IDProc!= 0) m_Proc = new User(m_IDProc);
return Constants. LOAD_OK;
}
catch (OleDbException _ex)
{
return Constants. LOAD_NO_DATA;
}
}
public int SaveToDB()
{
try
{
string _commText = "";
if (m_IDRequest == 0)
{
m_IDRequest = GetNewID();
_commText = String. Format("INSERT INTO t_request ([id_request],[type_request],[number],[id_client],[id_land],[id_object],[status],[date_req],[date_proc],[date_end],[id_oper],[id_proc]) VALUES ({0},{1},'{2}',{3},{4},{5},{6},'{7}','{8}','{9}',{10},{11})", m_IDRequest. ToString(), m_TypeRequest. ToString(), m_Number, m_IDClient. ToString(), m_IDLand. ToString(), m_IDObject. ToString(), m_Status. ToString(), m_DateRequest. ToShortDateString(), m_DateProc. ToShortDateString(), m_DateEnd. ToShortDateString(), m_IDOper. ToString(), m_IDProc. ToString());
}
else
{
_commText = String. Format("UPDATE t_request SET [type_request]={1},[number]='{2}',[id_client]={3},[id_land]={4},[id_object]={5},[status]={6},[date_req]='{7}',[date_proc]='{8}',[date_end]='{9}',[id_oper]={10},[id_proc]={11} WHERE [id_request]={0}", m_IDRequest. ToString(), m_TypeRequest. ToString(), m_Number, m_IDClient. ToString(), m_IDLand. ToString(), m_IDObject. ToString(), m_Status. ToString(), m_DateRequest. ToShortDateString(), m_DateProc. ToShortDateString(), m_DateEnd. ToShortDateString(), m_IDOper. ToString(), m_IDProc. ToString());
}
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 _newID = 0;
try
{
OleDbCommand _command = new OleDbCommand("SELECT Max(id_request) FROM t_request", 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 void ProcRequest()
{
m_Status = 2;
m_IDProc = Program. currentUser. m_IDUser;
m_Proc = new User(m_IDProc);
m_DateProc = DateTime. Now;
SaveToDB();
}
public void PrintDocuments()
{
switch (m_TypeRequest)
{
case 1: //Градостр. план
PrintPlan();
PrintResolution();
MessageBox. Show("Документы напечатаны.", "Сообщение", MessageBoxButtons. OK, MessageBoxIcon. Information);
break;
case 2: //Ввод в эксплуатацию
PrintExploit();
MessageBox. Show("Документы напечатаны.", "Сообщение", MessageBoxButtons. OK, MessageBoxIcon. Information);
break;
case 3: //Разрешение на строительство
PrintBuilding();
MessageBox. Show("Документы напечатаны.", "Сообщение", MessageBoxButtons. OK, MessageBoxIcon. Information);
break;
default:
MessageBox. Show("Непонятно, что печатать!!!");
break;
}
}
//Печать постановления
private void PrintResolution()
|
Из за большого объема этот материал размещен на нескольких страницах:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 |
