PrintString(((m_Object. m_Length > 0) ? m_Object. m_Length. ToString() : "-"), "bmLength", _wordDoc, 0, 0, false);
PrintString(((m_Object. m_Length > 0) ? m_Object. m_Length. ToString() : "-"), "bmLengthFact", _wordDoc, 0, 0, false);
PrintString(((m_Object. m_SectionCount > 0) ? m_Object. m_SectionCount. ToString() : "-"), "bmSectionCount", _wordDoc, 0, 0, false);
PrintString(((m_Object. m_SectionCount > 0) ? m_Object. m_SectionCount. ToString() : "-"), "bmSectionCountFact", _wordDoc, 0, 0, false);
PrintString(((m_Object. m_FloorCount > 0) ? m_Object. m_FloorCount. ToString() : "-"), "bmFloorCount", _wordDoc, 0, 0, false);
PrintString(((m_Object. m_FloorCount > 0) ? m_Object. m_FloorCount. ToString() : "-"), "bmFloorCountFact", _wordDoc, 0, 0, false);
PrintString(((m_Object. m_AppartmentTotal > 0) ? m_Object. m_AppartmentTotal. ToString() : "-"), "bmAppartmentTotal", _wordDoc, 0, 0, false);
PrintString(((m_Object. m_AppartmentTotal > 0) ? m_Object. m_AppartmentTotal. ToString() : "-"), "bmAppartmentTotalFact", _wordDoc, 0, 0, false);
PrintString(((m_Object. m_OneRoomCnt > 0) ? m_Object. m_OneRoomCnt. ToString() : "-"), "bmOneRoomCnt", _wordDoc, 0, 0, false);
PrintString(((m_Object. m_OneRoomCnt > 0) ? m_Object. m_OneRoomCnt. ToString() : "-"), "bmOneRoomCntFact", _wordDoc, 0, 0, false);
PrintString(((m_Object. m_TwoRoomCnt > 0) ? m_Object. m_TwoRoomCnt. ToString() : "-"), "bmTwoRoomCnt", _wordDoc, 0, 0, false);
PrintString(((m_Object. m_TwoRoomCnt > 0) ? m_Object. m_TwoRoomCnt. ToString() : "-"), "bmTwoRoomCntFact", _wordDoc, 0, 0, false);
PrintString(((m_Object. m_ThreeRoomCnt > 0) ? m_Object. m_ThreeRoomCnt. ToString() : "-"), "bmThreeRoomCnt", _wordDoc, 0, 0, false);
PrintString(((m_Object. m_ThreeRoomCnt > 0) ? m_Object. m_ThreeRoomCnt. ToString() : "-"), "bmThreeRoomCntFact", _wordDoc, 0, 0, false);
PrintString(((m_Object. m_FourRoomCnt > 0) ? m_Object. m_FourRoomCnt. ToString() : "-"), "bmFourRoomCnt", _wordDoc, 0, 0, false);
PrintString(((m_Object. m_FourRoomCnt > 0) ? m_Object. m_FourRoomCnt. ToString() : "-"), "bmFourRoomCntFact", _wordDoc, 0, 0, false);
PrintString(((m_Object. m_ManyRoomCnt > 0) ? m_Object. m_ManyRoomCnt. ToString() : "-"), "bmManyRoomCnt", _wordDoc, 0, 0, false);
PrintString(((m_Object. m_ManyRoomCnt > 0) ? m_Object. m_ManyRoomCnt. ToString() : "-"), "bmManyRoomCntFact", _wordDoc, 0, 0, false);
PrintString(((m_Object. m_LiveArea > 0) ? m_Object. m_LiveArea. ToString() : "-"), "bmLiveArea", _wordDoc, 0, 0, false);
PrintString(((m_Object. m_LiveArea > 0) ? m_Object. m_LiveArea. ToString() : "-"), "bmLiveAreaFact", _wordDoc, 0, 0, false);
PrintString(m_Object. m_BaseMaterialStr, "bmBaseMaterial", _wordDoc, 0, 0, false);
PrintString(m_Object. m_BaseMaterialStr, "bmBaseMaterialFact", _wordDoc, 0, 0, false);
PrintString(m_Object. m_WallMaterialStr, "bmWallMaterial", _wordDoc, 0, 0, false);
PrintString(m_Object. m_WallMaterialStr, "bmWallMaterialFact", _wordDoc, 0, 0, false);
PrintString(m_Object. m_FloorMaterialStr, "bmFloorMaterial", _wordDoc, 0, 0, false);
PrintString(m_Object. m_FloorMaterialStr, "bmFloorMaterialFact", _wordDoc, 0, 0, false);
PrintString(m_Object. m_RoofMaterialStr, "bmRoofMaterial", _wordDoc, 0, 0, false);
PrintString(m_Object. m_RoofMaterialStr, "bmRoofMaterialFact", _wordDoc, 0, 0, false);
PrintString(((m_Object. m_TotalPrice > 0) ? m_Object. m_TotalPrice. ToString() : "-"), "bmTotalPrice", _wordDoc, 0, 0, false);
PrintString(((m_Object. m_TotalPrice > 0) ? m_Object. m_TotalPrice. ToString() : "-"), "bmTotalPriceFact", _wordDoc, 0, 0, false);
PrintString(((m_Object. m_BuildingPrice > 0) ? m_Object. m_BuildingPrice. ToString() : "-"), "bmBuildingPrice", _wordDoc, 0, 0, false);
PrintString(((m_Object. m_BuildingPrice > 0) ? m_Object. m_BuildingPrice. ToString() : "-"), "bmBuildingPriceFact", _wordDoc, 0, 0, false);
PrintString(m_Proc. m_PositionStr, "bmPosition", _wordDoc, 0, 0, false);
PrintString(m_Proc. GetShortName(), "bmProcName", _wordDoc, 0, 0, false);
PrintString(m_DateProc. ToLongDateString(), "bmProcDate", _wordDoc, 0, 0, false);
_wordApp. Visible = true;
_wordDoc. SaveAs(System. Windows. Forms. Application. StartupPath + "\\DOCUMENTS\\ВводВЭкспл" + m_Client. m_LastName + m_Client. m_FirstName + m_Client. m_SecondName + ".doc");
}
catch (System. Exception ex)
{
MessageBox. Show(ex. Message, "Ошибка " + ex. Source);
}
}
private Microsoft. Office. Interop. Word. Document OpenDocument(Microsoft. Office. Interop. Word. Application _wordApp, string _docName)
{
_wordApp. Visible = false;
_wordApp. DisplayAlerts = Microsoft. Office. Interop. Word. WdAlertLevel. wdAlertsNone;
return _wordApp. Documents. Open(System. Windows. Forms. Application. StartupPath + "\\FORMS\\" + _docName);
}
//Печать строки в документе на месте закладки
private void PrintString(string aString, string aBookmark, Microsoft. Office. Interop. Word. Document docWord, int aTypeObject, int aBold, bool aUnderline)
{
Microsoft. Office. Interop. Word. Selection currSelection = null;
if (aTypeObject == 0) //Печатаем в закладке
{
if (aBookmark!= "")
{
Microsoft. Office. Interop. Word. Range currPos = docWord. GoTo(Microsoft. Office. Interop. Word. WdGoToItem. wdGoToBookmark, oMissing, oMissing, aBookmark);
currPos. Select();
}
currSelection = docWord. Application. Selection;
}
if (aTypeObject == 1) //Печатаем в картинке
{
docWord. Shapes[aBookmark].Select();
currSelection = docWord. Application. Selection;
currSelection. ShapeRange. TextFrame. TextRange. Select();
currSelection = docWord. Application. Selection;
currSelection. Collapse();
}
if (aTypeObject == 2) //Печатаем в таблице по одному символу в ячейке
{
Microsoft. Office. Interop. Word. Range currPos = docWord. GoTo(Microsoft. Office. Interop. Word. WdGoToItem. wdGoToBookmark, oMissing, oMissing, aBookmark);
currPos. Select();
currSelection = docWord. Application. Selection;
for (int symb = 0; symb < aString. Length; symb++)
{
if (aUnderline)
currSelection. Font. Underline = Microsoft. Office. Interop. Word. WdUnderline. wdUnderlineSingle;
else
currSelection. Font. Underline = Microsoft. Office. Interop. Word. WdUnderline. wdUnderlineNone;
currSelection. Font. Bold = aBold;
currSelection. TypeText(bstring(symb, 1));
currSelection. MoveRight(Microsoft. Office. Interop. Word. WdUnits. wdCharacter, 1, oMissing);
}
currSelection. Font. Underline = Microsoft. Office. Interop. Word. WdUnderline. wdUnderlineNone;
currSelection. Font. Bold = 0;
return;
}
if (aUnderline)
currSelection. Font. Underline = Microsoft. Office. Interop. Word. WdUnderline. wdUnderlineSingle;
else
currSelection. Font. Underline = Microsoft. Office. Interop. Word. WdUnderline. wdUnderlineNone;
currSelection. Font. Bold = aBold;
currSelection. TypeText(aString);
currSelection. Font. Underline = Microsoft. Office. Interop. Word. WdUnderline. wdUnderlineNone;
currSelection. Font. Bold = 0;
}
}
}
Файл User. cs
using System;
using System. Collections. Generic;
using System. Linq;
using System. Text;
using System. Data. OleDb;
using System. Data;
namespace Realty
{
public class User
{
public int m_IDUser = 0;
public string m_Login="";
public string m_Password="";
public string m_LastName="";
public string m_SecondName="";
public string m_FirstName="";
public int m_Position=0;
public string m_PositionStr = "";
public string m_FullPositionStr = "";
public int m_Permission=0;
public string m_PermissionStr = "";
public bool m_ChangePass = false;
public int m_ResultDB = Constants. LOAD_OK;
public User()
{}
public User(int _index)
{
GetDataFromBase(_index);
}
public User(string _login)
{
GetDataFromBase(_login);
}
public string GetShortName()
{
if (m_LastName == "" || m_FirstName == "" || m_SecondName == "") return "";
return m_LastName + " " + bstring(0, 1) + "." + bstring(0, 1) + ".";
}
public string GetMediumName()
{
if (m_FirstName == "" || m_SecondName == "") return "";
return m_FirstName + " " + m_SecondName;
}
public int GetDataFromBase(string login)
{
int _result = Constants. LOAD_OK;
OleDbDataAdapter userAdapter = new OleDbDataAdapter(string. Format("SELECT t_users.*, t_sprav1.val_1 AS permStr, t_sprav2.val_1 AS posStr, t_sprav2.val_2 AS fullPosStr FROM ((t_users LEFT OUTER JOIN t_sprav t_sprav1 ON t_users. permission = t_sprav1.id_item) LEFT OUTER JOIN t_sprav t_sprav2 ON t_users.[position] = t_sprav2.id_item) WHERE (t_users. login = '{0}') AND (t_sprav2.id_sprav = 2) AND (t_sprav1.id_sprav = 3)", login), Program. accessConnection);
_result = LoadData(userAdapter);
return _result;
}
public int GetDataFromBase(int index)
{
int _result = Constants. LOAD_OK;
OleDbDataAdapter userAdapter = new OleDbDataAdapter(string. Format("SELECT t_users.*, t_sprav1.val_1 AS permStr, t_sprav2.val_1 AS posStr, t_sprav2.val_2 AS fullPosStr FROM ((t_users LEFT OUTER JOIN t_sprav t_sprav1 ON t_users. permission = t_sprav1.id_item) LEFT OUTER JOIN t_sprav t_sprav2 ON t_users.[position] = t_sprav2.id_item) WHERE (t_users. id_user = {0}) AND (t_sprav2.id_sprav = 2) AND (t_sprav1.id_sprav = 3)", index. ToString()), Program. accessConnection);
|
Из за большого объема этот материал размещен на нескольких страницах:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 |
