public System.Data.DataSet FindByAccount(ObjectList<Organization> providers, ObjectList<Organization> holders, ObjectList<ServiceTypeOld> serviceTypes, ObjectList<ServiceOld> services, Account account, System.DateTime period, bool isReport, long apartmentTypeId, System.DateTime periodPayment, FasetItem cityBoroughs, ObjectList<Organization> accountHolders)
{
ObjectList<Account> accounts = new ObjectList<Account> {
account
};
return this.FindByAccounts(providers, holders, serviceTypes, services, accounts, period, Constants.NullDate, isReport, apartmentTypeId, periodPayment, cityBoroughs, accountHolders);
}
public AddChangeCounterPlaceFactorForm(FasetItem place, System.DateTime period, decimal value)
{
this.p_ACPF = AIS.SN.Model.DomainObjects.ApartmentCounterPlaceFactor.Null;
this.InitializeComponent();
this.sfdPlaces.SelectedFasetItem = place;
this.periodSelector.Period = period;
this.numFactor.set_Value(value);
this.btnAccept.set_Text("Добавить");
this.set_Text("Добавление температурного коэффициента");
}
private void selectVacationTypes_SelectedIndexChanged(object sender, System.EventArgs e)
{
this.vacationType = this.selectVacationTypes.SelectedFasetItem;
}
private void FindReesters()
{
this.m_fromDate = this.datePeriod.DateBeginIsNull ? Constants.NullDate : this.datePeriod.DateBegin;
this.m_fromDatePay = this.datePeriodPay.DateBeginIsNull ? Constants.NullDate : this.datePeriodPay.DateBegin;
this.m_toDate = this.datePeriod.DateEndIsNull ? Constants.NullDate : this.datePeriod.DateEnd;
this.m_toDate = (this.m_toDate == Constants.NullDate) ? this.m_toDate : new System.DateTime(this.m_toDate.get_Year(), this.m_toDate.get_Month(), this.m_toDate.get_Day(), 0x17, 0x3b, 0x3b);
this.m_toDatePay = this.datePeriodPay.DateEndIsNull ? Constants.NullDate : this.datePeriodPay.DateEnd;
this.m_toDatePay = (this.m_toDatePay == Constants.NullDate) ? this.m_toDatePay : new System.DateTime(this.m_toDatePay.get_Year(), this.m_toDatePay.get_Month(), this.m_toDatePay.get_Day(), 0x17, 0x3b, 0x3b);
this.m_paymentOrderDate = this.dbPaymentOrderDate.Value;
this.m_isWithUnProccessed = this.cbWithUnProccessed.get_Checked();
this.m_fasetItemStatus = (FasetItem) this.selectStatus.get_SelectedItem();
this.m_foundPayReesters = PayReester.FindByWithNotProcessed(this.m_fromDate, this.m_toDate, this.tbxNumber.get_Text().Trim(), this.selectStatus.SelectedFasetItem, this.m_fromDatePay, this.m_toDatePay, this.m_isWithUnProccessed, this.m_paymentOrderDate);
}
public static void DeleteFasetItem(FasetItem data)
{
Mappers.FasetItemMapper.Delete(data);
faset_items[(int) data.FasetId].Remove(data.Id);
}
private void InitializeComponent()
{
this.components = new Container();
FasetItem item = new FasetItem();
this.bsApartmentHousekeeping = new System.Windows.Forms.BindingSource(this.components);
this.btCancel = new System.Windows.Forms.Button();
this.btOk = new System.Windows.Forms.Button();
this.gbBox = new System.Windows.Forms.GroupBox();
this.cbEquipments = new SelectFasetData();
this.bsEquipments = new System.Windows.Forms.BindingSource(this.components);
this.label3 = new System.Windows.Forms.Label();
this.label2 = new System.Windows.Forms.Label();
this.label1 = new System.Windows.Forms.Label();
this.dbEnd = new DateBox();
this.bsApartmentHousekeepingEquipments = new System.Windows.Forms.BindingSource(this.components);
this.dbBegin = new DateBox();
this.cbHousekeeping = new SelectFasetData();
this.lTypeHousekeeping = new System.Windows.Forms.Label();
this.bsApartmentHousekeeping.BeginInit();
this.gbBox.SuspendLayout();
this.bsEquipments.BeginInit();
this.bsApartmentHousekeepingEquipments.BeginInit();
base.SuspendLayout();
this.bsApartmentHousekeeping.set_DataSource(typeof(ApartmentHousekeeping));
this.btCancel.set_DialogResult(System.Windows.Forms.DialogResult.Cancel);
this.btCancel.set_Location(new System.Drawing.Point(0x12a, 0x93));
this.btCancel.set_Margin(new System.Windows.Forms.Padding(2));
this.btCancel.set_Name("btCancel");
this.btCancel.set_Size(new System.Drawing.Size(80, 0x19));
this.btCancel.set_TabIndex(3);
this.btCancel.set_Text("Отмена");
this.btCancel.set_UseVisualStyleBackColor(true);
this.btOk.set_Location(new System.Drawing.Point(0xd6, 0x93));
this.btOk.set_Margin(new System.Windows.Forms.Padding(2));
this.btOk.set_Name("btOk");
this.btOk.set_Size(new System.Drawing.Size(80, 0x19));
this.btOk.set_TabIndex(2);
this.btOk.set_UseVisualStyleBackColor(true);
this.btOk.add_Click(new System.EventHandler(this.btOk_Click));
this.gbBox.Controls.Add(this.cbEquipments);
this.gbBox.Controls.Add(this.label3);
this.gbBox.Controls.Add(this.label2);
this.gbBox.Controls.Add(this.label1);
this.gbBox.Controls.Add(this.dbEnd);
this.gbBox.Controls.Add(this.dbBegin);
this.gbBox.Controls.Add(this.cbHousekeeping);
this.gbBox.Controls.Add(this.lTypeHousekeeping);
this.gbBox.set_Dock(System.Windows.Forms.DockStyle.Top);
this.gbBox.set_FlatStyle(System.Windows.Forms.FlatStyle.System);
this.gbBox.set_Location(new System.Drawing.Point(0, 0));
this.gbBox.set_Margin(new System.Windows.Forms.Padding(2));
this.gbBox.set_Name("gbBox");
this.gbBox.set_Padding(new System.Windows.Forms.Padding(2));
this.gbBox.set_Size(new System.Drawing.Size(380, 0x89));
this.gbBox.set_TabIndex(1);
this.gbBox.set_TabStop(false);
this.gbBox.set_Text("Совместное использование приусадебного хозяйства и оборудования");
this.cbEquipments.set_DataSource(this.bsEquipments);
this.cbEquipments.set_FormattingEnabled(true);
this.cbEquipments.set_Location(new System.Drawing.Point(8, 0x43));
this.cbEquipments.set_Margin(new System.Windows.Forms.Padding(2));
this.cbEquipments.set_Name("cbEquipments");
item.FasetId = FasetsEnum.None;
item.Id = 0;
item.Name = "<не выбрано>";
this.cbEquipments.SelectedFasetItem = item;
this.cbEquipments.set_Size(new System.Drawing.Size(0x16e, 0x15));
this.cbEquipments.set_Sorted(true);
this.cbEquipments.set_TabIndex(2);
this.bsEquipments.set_DataSource(typeof(ApartmentEquipment));
this.label3.set_AutoSize(true);
this.label3.set_Location(new System.Drawing.Point(4, 0x34));
this.label3.set_Margin(new System.Windows.Forms.Padding(2, 0, 2, 0));
this.label3.set_Name("label3");
this.label3.set_Size(new System.Drawing.Size(80, 13));
this.label3.set_TabIndex(0x2f);
this.label3.set_Text("Оборудование");
this.label2.set_AutoSize(true);
this.label2.set_Location(new System.Drawing.Point(4, 0x77));
this.label2.set_Margin(new System.Windows.Forms.Padding(2, 0, 2, 0));
this.label2.set_Name("label2");
this.label2.set_Size(new System.Drawing.Size(0x67, 13));
this.label2.set_TabIndex(0x2e);
this.label2.set_Text("Совместно по дату");
this.label1.set_AutoSize(true);
this.label1.set_Location(new System.Drawing.Point(4, 0x5f));
this.label1.set_Margin(new System.Windows.Forms.Padding(2, 0, 2, 0));
this.label1.set_Name("label1");
this.label1.set_Size(new System.Drawing.Size(100, 13));
this.label1.set_TabIndex(0x2d);
this.label1.set_Text("Совместно с даты");
this.dbEnd.AttachToPeriod = false;
this.dbEnd.DataBindings.Add(new System.Windows.Forms.Binding("Value", this.bsApartmentHousekeepingEquipments, "Datee", true));
this.dbEnd.set_Location(new System.Drawing.Point(0x73, 0x73));
this.dbEnd.set_Margin(new System.Windows.Forms.Padding(2));
this.dbEnd.set_Mask("00/00/0000");
this.dbEnd.set_Name("dbEnd");
this.dbEnd.set_Size(new System.Drawing.Size(0x5b, 20));
this.dbEnd.set_TabIndex(4);
this.bsApartmentHousekeepingEquipments.set_DataSource(typeof(ApartmentEquipmentHousekeeping));
this.dbBegin.AttachToPeriod = false;
this.dbBegin.DataBindings.Add(new System.Windows.Forms.Binding("Value", this.bsApartmentHousekeepingEquipments, "Dateb", true));
this.dbBegin.set_Location(new System.Drawing.Point(0x73, 0x5c));
this.dbBegin.set_Margin(new System.Windows.Forms.Padding(2));
this.dbBegin.set_Mask("00/00/0000");
this.dbBegin.set_Name("dbBegin");
this.dbBegin.set_Size(new System.Drawing.Size(0x5b, 20));
this.dbBegin.set_TabIndex(3);
this.cbHousekeeping.set_DataSource(this.bsApartmentHousekeeping);
this.cbHousekeeping.set_FormattingEnabled(true);
this.cbHousekeeping.set_Location(new System.Drawing.Point(8, 0x1d));
this.cbHousekeeping.set_Margin(new System.Windows.Forms.Padding(2));
this.cbHousekeeping.set_Name("cbHousekeeping");
this.cbHousekeeping.SelectedFasetItem = item;
this.cbHousekeeping.set_Size(new System.Drawing.Size(0x16e, 0x15));
this.cbHousekeeping.set_Sorted(true);
this.cbHousekeeping.set_TabIndex(1);
this.lTypeHousekeeping.set_AutoSize(true);
this.lTypeHousekeeping.set_Location(new System.Drawing.Point(4, 14));
this.lTypeHousekeeping.set_Margin(new System.Windows.Forms.Padding(2, 0, 2, 0));
this.lTypeHousekeeping.set_Name("lTypeHousekeeping");
this.lTypeHousekeeping.set_Size(new System.Drawing.Size(0x87, 13));
this.lTypeHousekeeping.set_TabIndex(0x29);
this.lTypeHousekeeping.set_Text("Приусадебное хозяйство");
base.set_AutoScaleDimensions(new System.Drawing.SizeF(6f, 13f));
base.set_AutoScaleMode(System.Windows.Forms.AutoScaleMode.Font);
base.set_ClientSize(new System.Drawing.Size(380, 0xb1));
base.Controls.Add(this.gbBox);
base.Controls.Add(this.btCancel);
base.Controls.Add(this.btOk);
base.set_FormBorderStyle(System.Windows.Forms.FormBorderStyle.FixedSingle);
base.set_MaximizeBox(false);
base.set_Name("ApartmentHousekeepingEquipmentChangeForm");
base.set_StartPosition(System.Windows.Forms.FormStartPosition.CenterScreen);
this.set_Text("ApartmentHousekeepingEquipmentChangeForm");
base.add_Load(new System.EventHandler(this.ApartmentHousekeepingEquipmentAnnChangeForm_Load));
this.bsApartmentHousekeeping.EndInit();
this.gbBox.ResumeLayout(false);
this.gbBox.PerformLayout();
this.bsEquipments.EndInit();
this.bsApartmentHousekeepingEquipments.EndInit();
base.ResumeLayout(false);
}
private void уведомленияToolStripMenuItem_Click(object sender, System.EventArgs e)
{
if (!this.IsBusy())
{
this.m_SelectedAccounts = this.GetSelectedAccounts();
if (this.m_SelectedAccounts.get_Count() == 0)
{
Messages.ShowMessage("Выберите лицевые счета из выведенного результата");
}
else
{
this.tsBtnShowReports.set_Image(Resources.LOADING);
this.selectFasetApartmentType = this.FasetApartmentType;
this.selectFasetAccountProperty = this.FasetAccountProperty;
this.m_WorkerGetNoticeMode = WorkerGetNoticeMode.Уведомления;
this.m_WorkerGetNotices.RunWorkerAsync();
}
}
}
private void отчетыПоЛицевымСчетамБезГруппировкиПоТипуЖильяToolStripMenuItem_Click(object sender, System.EventArgs e)
{
if (!this.IsBusy())
{
this.m_TypeReport = 1;
this.m_SubtypeReport = 2;
if (this.Verify())
{
this.tsBtnShowReports.set_Image(Resources.LOADING);
this.selectFasetApartmentType = this.FasetApartmentType;
this.selectFasetAccountProperty = this.FasetAccountProperty;
this.m_WorkerGetReports.RunWorkerAsync();
}
}
}
private void InitializeComponent()
{
this.components = new Container();
FasetItem item = new FasetItem();
Organization organization = new Organization();
Benefit benefit = new Benefit();
this.bsBenefitNormsForGaz = new System.Windows.Forms.BindingSource(this.components);
this.btnCancel = new System.Windows.Forms.Button();
this.btnYes = new System.Windows.Forms.Button();
this.label4 = new System.Windows.Forms.Label();
this.label1 = new System.Windows.Forms.Label();
this.nudSumm = new System.Windows.Forms.NumericUpDown();
this.dbFromDate = new DateBox();
this.selectFasetData = new SelectFasetData();
this.bsFasets = new System.Windows.Forms.BindingSource(this.components);
this.selectFasetDataExcept = new SelectFasetData();
this.cbSelectFaset = new System.Windows.Forms.ComboBox();
this.cbSelectFasetExcept = new System.Windows.Forms.ComboBox();
this.bsFasetsExcept = new System.Windows.Forms.BindingSource(this.components);
this.label2 = new System.Windows.Forms.Label();
this.label3 = new System.Windows.Forms.Label();
this.selectBenefit1 = new SelectBenefit();
this.label5 = new System.Windows.Forms.Label();
this.bsBenefitNormsForGaz.BeginInit();
this.nudSumm.BeginInit();
this.bsFasets.BeginInit();
this.bsFasetsExcept.BeginInit();
base.SuspendLayout();
this.bsBenefitNormsForGaz.set_DataSource(typeof(BenefitNormsForGas));
this.btnCancel.set_Anchor(System.Windows.Forms.AnchorStyles.Right | System.Windows.Forms.AnchorStyles.Bottom);
this.btnCancel.set_Location(new System.Drawing.Point(430, 0x8e));
this.btnCancel.set_Name("btnCancel");
this.btnCancel.set_Size(new System.Drawing.Size(0x4b, 0x17));
this.btnCancel.set_TabIndex(3);
this.btnCancel.set_Text("Отмена");
this.btnCancel.set_UseVisualStyleBackColor(true);
this.btnCancel.add_Click(new System.EventHandler(this.btnCancel_Click));
this.btnYes.set_Anchor(System.Windows.Forms.AnchorStyles.Right | System.Windows.Forms.AnchorStyles.Bottom);
this.btnYes.set_Location(new System.Drawing.Point(0x15d, 0x8e));
this.btnYes.set_Name("btnYes");
this.btnYes.set_Size(new System.Drawing.Size(0x4b, 0x17));
this.btnYes.set_TabIndex(2);
this.btnYes.set_UseVisualStyleBackColor(true);
this.btnYes.add_Click(new System.EventHandler(this.btnYes_Click));
this.label4.set_AutoSize(true);
this.label4.set_Location(new System.Drawing.Point(13, 90));
this.label4.set_Name("label4");
this.label4.set_Size(new System.Drawing.Size(0x3d, 13));
this.label4.set_TabIndex(0x17);
this.label4.set_Text("Норматив:");
this.label1.set_AutoSize(true);
this.label1.set_Location(new System.Drawing.Point(12, 9));
this.label1.set_Name("label1");
this.label1.set_Size(new System.Drawing.Size(0x5e, 13));
this.label1.set_TabIndex(20);
this.label1.set_Text("Дата норматива:");
this.nudSumm.DataBindings.Add(new System.Windows.Forms.Binding("Value", this.bsBenefitNormsForGaz, "Value", true));
this.nudSumm.set_DecimalPlaces(2);
this.nudSumm.set_Location(new System.Drawing.Point(0x70, 0x58));
int[] numArray = new int[4];
numArray[0] = 0x6fc10000;
numArray[1] = 0x2386f2;
this.nudSumm.set_Maximum(new decimal(numArray));
this.nudSumm.set_Name("nudSumm");
this.nudSumm.set_Size(new System.Drawing.Size(190, 20));
this.nudSumm.set_TabIndex(15);
this.dbFromDate.AttachToPeriod = false;
this.dbFromDate.AttachToPeriodEnd = false;
this.dbFromDate.DataBindings.Add(new System.Windows.Forms.Binding("Value", this.bsBenefitNormsForGaz, "FromDate", true));
this.dbFromDate.set_Location(new System.Drawing.Point(0x70, 6));
this.dbFromDate.set_Mask("00/00/0000");
this.dbFromDate.set_Name("dbFromDate");
this.dbFromDate.set_Size(new System.Drawing.Size(100, 20));
this.dbFromDate.set_TabIndex(14);
this.selectFasetData.set_FormattingEnabled(true);
this.selectFasetData.set_Location(new System.Drawing.Point(0x134, 0x20));
this.selectFasetData.set_Name("selectFasetData");
this.selectFasetData.set_Size(new System.Drawing.Size(0xc2, 0x15));
this.selectFasetData.set_Sorted(true);
this.selectFasetData.set_TabIndex(0x18);
this.bsFasets.set_DataSource(typeof(Faset));
this.selectFasetDataExcept.set_FormattingEnabled(true);
this.selectFasetDataExcept.set_Location(new System.Drawing.Point(0x134, 0x40));
this.selectFasetDataExcept.set_Name("selectFasetDataExcept");
this.selectFasetDataExcept.set_Size(new System.Drawing.Size(0xc2, 0x15));
this.selectFasetDataExcept.set_Sorted(true);
this.selectFasetDataExcept.set_TabIndex(0x19);
this.cbSelectFaset.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.bsBenefitNormsForGaz, "FasetName", true));
this.cbSelectFaset.set_DataSource(this.bsFasets);
this.cbSelectFaset.set_DisplayMember("Name");
this.cbSelectFaset.set_FormattingEnabled(true);
this.cbSelectFaset.set_Location(new System.Drawing.Point(0x70, 0x20));
this.cbSelectFaset.set_Name("cbSelectFaset");
this.cbSelectFaset.set_Size(new System.Drawing.Size(190, 0x15));
this.cbSelectFaset.set_TabIndex(0x1a);
this.cbSelectFaset.set_ValueMember("Id");
this.cbSelectFaset.add_SelectedIndexChanged(new System.EventHandler(this.cbSelectFaset_SelectedIndexChanged));
this.cbSelectFasetExcept.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.bsBenefitNormsForGaz, "ExceptFasetName", true));
this.cbSelectFasetExcept.set_DataSource(this.bsFasetsExcept);
this.cbSelectFasetExcept.set_DisplayMember("Name");
this.cbSelectFasetExcept.set_FormattingEnabled(true);
this.cbSelectFasetExcept.set_Location(new System.Drawing.Point(0x70, 0x3d));
this.cbSelectFasetExcept.set_Name("cbSelectFasetExcept");
this.cbSelectFasetExcept.set_Size(new System.Drawing.Size(190, 0x15));
this.cbSelectFasetExcept.set_TabIndex(0x1b);
this.cbSelectFasetExcept.set_ValueMember("Id");
this.cbSelectFasetExcept.add_SelectedIndexChanged(new System.EventHandler(this.cbSelectFasetExcept_SelectedIndexChanged));
this.bsFasetsExcept.set_DataSource(typeof(Faset));
this.label2.set_AutoSize(true);
this.label2.set_Location(new System.Drawing.Point(13, 0x20));
this.label2.set_Name("label2");
this.label2.set_Size(new System.Drawing.Size(0x4c, 13));
this.label2.set_TabIndex(0x1c);
this.label2.set_Text("Норматив на:");
this.label3.set_AutoSize(true);
this.label3.set_Location(new System.Drawing.Point(12, 0x40));
this.label3.set_Name("label3");
this.label3.set_Size(new System.Drawing.Size(0x59, 13));
this.label3.set_TabIndex(0x1d);
this.label3.set_Text("При отсутствии:");
item.FasetId = FasetsEnum.None;
item.Id = 0;
item.Name = "<не выбрано>";
organization.Code = 0L;
organization.Created = new System.DateTime(0L);
organization.FromDate = new System.DateTime(0L);
organization.Created = new System.DateTime(0L);
organization.ToDate = new System.DateTime(0L);
organization.FromDate = new System.DateTime(0L);
organization.Id = 0L;
organization.Inn = 0L;
organization.IsBenefitTransferrer = false;
organization.IsCashlessTransferrer = false;
organization.IsDeleted = false;
organization.IsDirty = false;
organization.IsFlatOwner = false;
organization.IsHouseHolder = false;
organization.IsServiceProvider = false;
organization.Kpp = 0L;
organization.LongName = "<не выбрано>";
organization.ObjectWithIdType = null;
organization.Ogrn = 0L;
organization.Parent = organization;
organization.ParentId = 0L;
organization.ShortName = "<не выбрано>";
organization.ToDate = new System.DateTime(0L);
this.selectBenefit1.set_Location(new System.Drawing.Point(0x70, 0x72));
this.selectBenefit1.set_Name("selectBenefit1");
benefit.CalcFeature = 0;
benefit.CalcFeatureName = null;
benefit.Code = null;
benefit.Id = 0L;
benefit.IsAddress = 0;
benefit.IsDeleted = false;
benefit.IsDirty = false;
benefit.LongName = null;
benefit.ObjectWithIdType = null;
benefit.ShortName = null;
this.selectBenefit1.set_Size(new System.Drawing.Size(390, 20));
this.selectBenefit1.set_TabIndex(30);
this.label5.set_AutoSize(true);
this.label5.set_Location(new System.Drawing.Point(13, 0x77));
this.label5.set_Name("label5");
this.label5.set_Size(new System.Drawing.Size(0x2e, 13));
this.label5.set_TabIndex(0x1f);
this.label5.set_Text("Льгота:");
base.set_AutoScaleDimensions(new System.Drawing.SizeF(6f, 13f));
base.set_AutoScaleMode(System.Windows.Forms.AutoScaleMode.Font);
base.set_ClientSize(new System.Drawing.Size(0x205, 0xb1));
base.Controls.Add(this.label5);
base.Controls.Add(this.selectBenefit1);
base.Controls.Add(this.label3);
base.Controls.Add(this.label2);
base.Controls.Add(this.cbSelectFasetExcept);
base.Controls.Add(this.cbSelectFaset);
base.Controls.Add(this.selectFasetDataExcept);
base.Controls.Add(this.selectFasetData);
base.Controls.Add(this.label4);
base.Controls.Add(this.label1);
base.Controls.Add(this.nudSumm);
base.Controls.Add(this.dbFromDate);
base.Controls.Add(this.btnCancel);
base.Controls.Add(this.btnYes);
base.set_FormBorderStyle(System.Windows.Forms.FormBorderStyle.FixedDialog);
base.set_MaximizeBox(false);
base.set_MinimizeBox(false);
base.set_Name("BenefitNormsForGasAddChangeForm");
base.set_StartPosition(System.Windows.Forms.FormStartPosition.CenterParent);
this.set_Text("BenefitNormsForGazAddChangeForm");
base.add_FormClosing(new System.Windows.Forms.FormClosingEventHandler(this.BenefitNormsForGazAddChangeForm_FormClosing));
base.add_Load(new System.EventHandler(this.BenefitNormsForGazAddChangeForm_Load));
this.bsBenefitNormsForGaz.EndInit();
this.nudSumm.EndInit();
this.bsFasets.EndInit();
this.bsFasetsExcept.EndInit();
base.ResumeLayout(false);
base.PerformLayout();
}
public override void SaveProperties(DataTransferObject ddto)
{
ServiceNormDTO mdto = (ServiceNormDTO) ddto;
this.ServiceOld = mdto.ServiceOld;
this.Rate = mdto.Rate;
this.Unit = mdto.Unit;
this.ByUnit = mdto.ByUnit;
base.OrgDocument = mdto.OrgDocument;
base.Dateb = mdto.Dateb;
base.Datee = mdto.Datee;
this.FromValue = mdto.FromValue;
this.ToValue = mdto.ToValue;
}
private void sfdPaymentAgentType_SelectedIndexChanged(object sender, System.EventArgs e)
{
this.m_PaymentType = this.sfdPaymentType.SelectedFasetItem;
}
public static System.Data.DataSet GetPaymentReportByParameters(string packNumber, System.DateTime fromOrderDate, System.DateTime toOrderDate, System.DateTime fromDate, System.DateTime toDate, Area area, FasetItem paymentAgentType)
{
return Mappers.PayRequestMapper.GetPaymentReportByParameters(packNumber, fromOrderDate, toOrderDate, fromDate, toDate, area, paymentAgentType);
}
public System.Data.DataSet Recalc(System.DateTime fromDate, System.DateTime toDate, System.DateTime fromPeriod, System.DateTime toPeriod, FasetItem subType, Organization provider, ServiceTypeOld serviceType, ServiceOld serviceOld, Organization houseHolder, OrgDocument orgDocument, ObjectList<LocalAddress> addresses)
{
System.Data.SqlClient.SqlParameter[] parameters = new System.Data.SqlClient.SqlParameter[12];
parameters[0] = new System.Data.SqlClient.SqlParameter("@areaId", System.Data.SqlDbType.BigInt);
parameters[0].set_Value((long) Area.GetAreaIdByLocalAddresses(addresses));
parameters[1] = new System.Data.SqlClient.SqlParameter("@fromDate", System.Data.SqlDbType.DateTime);
parameters[1].set_Value(fromDate);
parameters[2] = new System.Data.SqlClient.SqlParameter("@toDate", System.Data.SqlDbType.DateTime);
parameters[2].set_Value((toDate == Constants.NullDate) ? ((object) System.DBNull.Value) : ((object) toDate));
parameters[3] = new System.Data.SqlClient.SqlParameter("@fromPeriod", System.Data.SqlDbType.DateTime);
parameters[3].set_Value(fromPeriod);
parameters[4] = new System.Data.SqlClient.SqlParameter("@toPeriod", System.Data.SqlDbType.DateTime);
parameters[4].set_Value((toPeriod == Constants.NullDate) ? ((object) System.DBNull.Value) : ((object) toPeriod));
parameters[5] = new System.Data.SqlClient.SqlParameter("@subTypeId", System.Data.SqlDbType.BigInt);
parameters[5].set_Value((subType == FasetItem.Null) ? ((object) System.DBNull.Value) : ((object) ((int) subType.Id)));
parameters[6] = new System.Data.SqlClient.SqlParameter("@providerId", System.Data.SqlDbType.BigInt);
parameters[6].set_Value((provider == Organization.Null) ? ((object) System.DBNull.Value) : ((object) ((long) provider.Id)));
parameters[7] = new System.Data.SqlClient.SqlParameter("@serviceTypeId", System.Data.SqlDbType.BigInt);
parameters[7].set_Value((serviceType == ServiceTypeOld.Null) ? ((object) System.DBNull.Value) : ((object) ((long) serviceType.Id)));
parameters[8] = new System.Data.SqlClient.SqlParameter("@serviceId", System.Data.SqlDbType.BigInt);
parameters[8].set_Value((serviceOld == ServiceOld.Null) ? ((object) System.DBNull.Value) : ((object) ((long) serviceOld.Id)));
parameters[9] = new System.Data.SqlClient.SqlParameter("@houseHolderId", System.Data.SqlDbType.BigInt);
parameters[9].set_Value((houseHolder == Organization.Null) ? ((object) System.DBNull.Value) : ((object) ((long) houseHolder.Id)));
parameters[10] = new System.Data.SqlClient.SqlParameter("@orgDocumentId", System.Data.SqlDbType.BigInt);
parameters[10].set_Value((orgDocument == OrgDocument.Null) ? ((object) System.DBNull.Value) : ((object) ((long) orgDocument.Id)));
parameters[11] = new System.Data.SqlClient.SqlParameter("@summ", System.Data.SqlDbType.Decimal);
parameters[11].set_Direction(System.Data.ParameterDirection.Output);
System.Data.DataSet set = new System.Data.DataSet();
set.Tables.Add(DALSql.ExecuteDataTable("exec sn.GetJnRecalcReport @areaId,@fromDate,@toDate,@fromPeriod,@toPeriod,\r\n\t\t\t\t\t\t\t\t\t\t\t\t@subTypeId,@providerId,@serviceTypeId,@serviceId,\r\n\t\t\t\t\t\t\t\t\t\t\t\t@houseHolderId,@orgDocumentId,@summ output ", parameters));
set.Tables.Add(DALSql.ExecuteDataTable("select sn.User_GetName() userName", null));
return set;
}
public System.Data.DataSet GetResidentVacationsReport(System.DateTime fromDate, System.DateTime toDate, FasetItem vacationType, ObjectList<Organization> houseHolders, Area area)
{
string str = "create table #tHouseHolders(houseHolderId bigint)" + System.Environment.get_NewLine();
if (houseHolders != null)
{
foreach (Organization organization in houseHolders)
{
object obj2 = str;
str = string.Concat((object[]) new object[] { obj2, "insert #tHouseHolders(houseHolderId) values(", ((long) organization.Id), ")", System.Environment.get_NewLine() });
}
}
System.Data.SqlClient.SqlParameter[] parameters = new System.Data.SqlClient.SqlParameter[4];
parameters[0] = new System.Data.SqlClient.SqlParameter("@areaId", System.Data.SqlDbType.BigInt);
parameters[0].set_Value((area.Id == -1L) ? ((object) System.DBNull.Value) : ((object) ((long) area.Id)));
parameters[1] = new System.Data.SqlClient.SqlParameter("@fromDate", System.Data.SqlDbType.DateTime);
parameters[1].set_Value((fromDate == Constants.NullDate) ? ((object) System.DBNull.Value) : ((object) fromDate));
parameters[2] = new System.Data.SqlClient.SqlParameter("@toDate", System.Data.SqlDbType.DateTime);
parameters[2].set_Value((toDate == Constants.NullDate) ? ((object) System.DBNull.Value) : ((object) toDate));
parameters[3] = new System.Data.SqlClient.SqlParameter("@vacationId", System.Data.SqlDbType.Int);
parameters[3].set_Value((vacationType == FasetItem.Null) ? ((object) System.DBNull.Value) : ((object) ((int) vacationType.Id)));
System.Data.DataSet set = DALSql.ExecuteDataSet(str + "exec sn.GetResidentVacationsReport @areaId,@vacationId,@fromDate,@toDate", parameters);
set.Tables.get_Item(0).set_TableName("tuning");
set.Tables.get_Item(1).set_TableName("crit");
set.Tables.get_Item(2).set_TableName("data");
return set;
}
public bool IsHavingParentSequence(FasetItem typeSequence)
{
return Mappers.GroupOperationMapper.IsHavingParentSequence(base.Id, typeSequence.Id);
}
private void InitializeComponent()
{
FasetItem item = new FasetItem();
this.label9 = new System.Windows.Forms.Label();
this.label8 = new System.Windows.Forms.Label();
this.label7 = new System.Windows.Forms.Label();
this.label11 = new System.Windows.Forms.Label();
this.label2 = new System.Windows.Forms.Label();
this.label3 = new System.Windows.Forms.Label();
this.label4 = new System.Windows.Forms.Label();
this.label5 = new System.Windows.Forms.Label();
this.label6 = new System.Windows.Forms.Label();
this.label10 = new System.Windows.Forms.Label();
this.selectFireAlarmType = new SelectFasetData();
this.selectTVEnquipmentType = new SelectFasetData();
this.selectLocalBroadcastingType = new SelectFasetData();
this.selectUtilizationType = new SelectFasetData();
this.selectHeatingType = new SelectFasetData();
this.selectOverflowType = new SelectFasetData();
this.selectStoveType = new SelectFasetData();
this.selectSewerType = new SelectFasetData();
this.selectGvsType = new SelectFasetData();
this.selectHvsType = new SelectFasetData();
base.SuspendLayout();
this.label9.set_Location(new System.Drawing.Point(5, 0x102));
this.label9.set_Margin(new System.Windows.Forms.Padding(4, 0, 4, 0));
this.label9.set_Name("label9");
this.label9.set_Size(new System.Drawing.Size(0x8b, 0x16));
this.label9.set_TabIndex(0x1c);
this.label9.set_Text("Канализация");
this.label8.set_Location(new System.Drawing.Point(5, 0x24));
this.label8.set_Margin(new System.Windows.Forms.Padding(4, 0, 4, 0));
this.label8.set_Name("label8");
this.label8.set_Size(new System.Drawing.Size(0xad, 0x16));
this.label8.set_TabIndex(0x1a);
this.label8.set_Text("Горячее водоснабжение");
this.label7.set_Location(new System.Drawing.Point(5, 5));
this.label7.set_Margin(new System.Windows.Forms.Padding(4, 0, 4, 0));
this.label7.set_Name("label7");
this.label7.set_Size(new System.Drawing.Size(0xbc, 0x16));
this.label7.set_TabIndex(0x18);
this.label7.set_Text("Холодное водоснабжение");
this.label11.set_Location(new System.Drawing.Point(4, 120));
this.label11.set_Name("label11");
this.label11.set_Size(new System.Drawing.Size(0x8b, 0x16));
this.label11.set_TabIndex(0x20);
this.label11.set_Text("Тип плиты");
this.label2.set_AutoSize(true);
this.label2.set_Location(new System.Drawing.Point(5, 0x40));
this.label2.set_Name("label2");
this.label2.set_Size(new System.Drawing.Size(0x55, 13));
this.label2.set_TabIndex(0x24);
this.label2.set_Text("Водоотведение");
this.label3.set_AutoSize(true);
this.label3.set_Location(new System.Drawing.Point(4, 0x5b));
this.label3.set_Name("label3");
this.label3.set_Size(new System.Drawing.Size(0x3e, 13));
this.label3.set_TabIndex(0x26);
this.label3.set_Text("Отопление");
this.label4.set_Location(new System.Drawing.Point(5, 0x94));
this.label4.set_Name("label4");
this.label4.set_Size(new System.Drawing.Size(0x8b, 0x16));
this.label4.set_TabIndex(40);
this.label4.set_Text("Утилизация ТБО");
this.label5.set_Location(new System.Drawing.Point(5, 200));
this.label5.set_Name("label5");
this.label5.set_Size(new System.Drawing.Size(0xda, 0x16));
this.label5.set_TabIndex(0x2a);
this.label5.set_Text("Телевизионное оборудование");
this.label6.set_Location(new System.Drawing.Point(5, 0xe3));
this.label6.set_Name("label6");
this.label6.set_Size(new System.Drawing.Size(0xda, 0x16));
this.label6.set_TabIndex(0x2b);
this.label6.set_Text("Пожарная сигнализация");
this.label10.set_Location(new System.Drawing.Point(5, 0xaf));
this.label10.set_Name("label10");
this.label10.set_Size(new System.Drawing.Size(0xad, 0x16));
this.label10.set_TabIndex(0x2e);
this.label10.set_Text("Местное радиовещание");
this.selectFireAlarmType.set_Anchor(System.Windows.Forms.AnchorStyles.Right | System.Windows.Forms.AnchorStyles.Left | System.Windows.Forms.AnchorStyles.Top);
this.selectFireAlarmType.set_FormattingEnabled(true);
this.selectFireAlarmType.set_Location(new System.Drawing.Point(0xcb, 0xe4));
this.selectFireAlarmType.set_Name("selectFireAlarmType");
item.FasetId = FasetsEnum.None;
item.Id = 0;
item.Name = "<не выбрано>";
this.selectFireAlarmType.SelectedFasetItem = item;
this.selectFireAlarmType.set_Size(new System.Drawing.Size(0xb2, 0x15));
this.selectFireAlarmType.set_Sorted(true);
this.selectFireAlarmType.set_TabIndex(0x35);
this.selectTVEnquipmentType.set_Anchor(System.Windows.Forms.AnchorStyles.Right | System.Windows.Forms.AnchorStyles.Left | System.Windows.Forms.AnchorStyles.Top);
this.selectTVEnquipmentType.set_FormattingEnabled(true);
this.selectTVEnquipmentType.set_Location(new System.Drawing.Point(0xcb, 0xc9));
this.selectTVEnquipmentType.set_Name("selectTVEnquipmentType");
this.selectTVEnquipmentType.SelectedFasetItem = item;
this.selectTVEnquipmentType.set_Size(new System.Drawing.Size(0xb2, 0x15));
this.selectTVEnquipmentType.set_Sorted(true);
this.selectTVEnquipmentType.set_TabIndex(0x34);
this.selectLocalBroadcastingType.set_Anchor(System.Windows.Forms.AnchorStyles.Right | System.Windows.Forms.AnchorStyles.Left | System.Windows.Forms.AnchorStyles.Top);
this.selectLocalBroadcastingType.set_FormattingEnabled(true);
this.selectLocalBroadcastingType.set_Location(new System.Drawing.Point(0xcb, 0xae));
this.selectLocalBroadcastingType.set_Name("selectLocalBroadcastingType");
this.selectLocalBroadcastingType.SelectedFasetItem = item;
this.selectLocalBroadcastingType.set_Size(new System.Drawing.Size(0xb2, 0x15));
this.selectLocalBroadcastingType.set_Sorted(true);
this.selectLocalBroadcastingType.set_TabIndex(0x33);
this.selectUtilizationType.set_Anchor(System.Windows.Forms.AnchorStyles.Right | System.Windows.Forms.AnchorStyles.Left | System.Windows.Forms.AnchorStyles.Top);
this.selectUtilizationType.set_FormattingEnabled(true);
this.selectUtilizationType.set_Location(new System.Drawing.Point(0xcb, 0x93));
this.selectUtilizationType.set_Name("selectUtilizationType");
this.selectUtilizationType.SelectedFasetItem = item;
this.selectUtilizationType.set_Size(new System.Drawing.Size(0xb2, 0x15));
this.selectUtilizationType.set_Sorted(true);
this.selectUtilizationType.set_TabIndex(50);
this.selectHeatingType.set_Anchor(System.Windows.Forms.AnchorStyles.Right | System.Windows.Forms.AnchorStyles.Left | System.Windows.Forms.AnchorStyles.Top);
this.selectHeatingType.set_FormattingEnabled(true);
this.selectHeatingType.set_Location(new System.Drawing.Point(0xcb, 0x5b));
this.selectHeatingType.set_Name("selectHeatingType");
this.selectHeatingType.SelectedFasetItem = item;
this.selectHeatingType.set_Size(new System.Drawing.Size(0xb2, 0x15));
this.selectHeatingType.set_Sorted(true);
this.selectHeatingType.set_TabIndex(0x31);
this.selectOverflowType.set_Anchor(System.Windows.Forms.AnchorStyles.Right | System.Windows.Forms.AnchorStyles.Left | System.Windows.Forms.AnchorStyles.Top);
this.selectOverflowType.set_FormattingEnabled(true);
this.selectOverflowType.set_Location(new System.Drawing.Point(0xcb, 0x40));
this.selectOverflowType.set_Name("selectOverflowType");
this.selectOverflowType.SelectedFasetItem = item;
this.selectOverflowType.set_Size(new System.Drawing.Size(0xb2, 0x15));
this.selectOverflowType.set_Sorted(true);
this.selectOverflowType.set_TabIndex(0x30);
this.selectStoveType.set_Anchor(System.Windows.Forms.AnchorStyles.Right | System.Windows.Forms.AnchorStyles.Left | System.Windows.Forms.AnchorStyles.Top);
this.selectStoveType.set_FormattingEnabled(true);
this.selectStoveType.set_Location(new System.Drawing.Point(0xcb, 0x75));
this.selectStoveType.set_Name("selectStoveType");
this.selectStoveType.SelectedFasetItem = item;
this.selectStoveType.set_Size(new System.Drawing.Size(0xb2, 0x15));
this.selectStoveType.set_Sorted(true);
this.selectStoveType.set_TabIndex(0x21);
this.selectStoveType.add_SelectedIndexChanged(new System.EventHandler(this.selectStoveType_SelectedIndexChanged));
this.selectSewerType.set_Anchor(System.Windows.Forms.AnchorStyles.Right | System.Windows.Forms.AnchorStyles.Left | System.Windows.Forms.AnchorStyles.Top);
this.selectSewerType.set_FormattingEnabled(true);
this.selectSewerType.set_Location(new System.Drawing.Point(0xcb, 0xff));
this.selectSewerType.set_Name("selectSewerType");
this.selectSewerType.SelectedFasetItem = item;
this.selectSewerType.set_Size(new System.Drawing.Size(0xb2, 0x15));
this.selectSewerType.set_Sorted(true);
this.selectSewerType.set_TabIndex(0x1f);
this.selectGvsType.set_Anchor(System.Windows.Forms.AnchorStyles.Right | System.Windows.Forms.AnchorStyles.Left | System.Windows.Forms.AnchorStyles.Top);
this.selectGvsType.set_FormattingEnabled(true);
this.selectGvsType.set_Location(new System.Drawing.Point(0xcb, 0x21));
this.selectGvsType.set_Name("selectGvsType");
this.selectGvsType.SelectedFasetItem = item;
this.selectGvsType.set_Size(new System.Drawing.Size(0xb2, 0x15));
this.selectGvsType.set_Sorted(true);
this.selectGvsType.set_TabIndex(0x1b);
this.selectHvsType.set_Anchor(System.Windows.Forms.AnchorStyles.Right | System.Windows.Forms.AnchorStyles.Left | System.Windows.Forms.AnchorStyles.Top);
this.selectHvsType.set_FormattingEnabled(true);
this.selectHvsType.set_Location(new System.Drawing.Point(0xcb, 3));
this.selectHvsType.set_Name("selectHvsType");
this.selectHvsType.SelectedFasetItem = item;
this.selectHvsType.set_Size(new System.Drawing.Size(0xb2, 0x15));
this.selectHvsType.set_Sorted(true);
this.selectHvsType.set_TabIndex(0x19);
base.set_AutoScaleDimensions(new System.Drawing.SizeF(6f, 13f));
base.set_AutoScaleMode(System.Windows.Forms.AutoScaleMode.Font);
base.Controls.Add(this.selectFireAlarmType);
base.Controls.Add(this.selectTVEnquipmentType);
base.Controls.Add(this.selectLocalBroadcastingType);
base.Controls.Add(this.selectUtilizationType);
base.Controls.Add(this.selectHeatingType);
base.Controls.Add(this.selectOverflowType);
base.Controls.Add(this.label10);
base.Controls.Add(this.label6);
base.Controls.Add(this.label5);
base.Controls.Add(this.label4);
base.Controls.Add(this.label3);
base.Controls.Add(this.label2);
base.Controls.Add(this.selectStoveType);
base.Controls.Add(this.label11);
base.Controls.Add(this.selectSewerType);
base.Controls.Add(this.label9);
base.Controls.Add(this.selectGvsType);
base.Controls.Add(this.label8);
base.Controls.Add(this.selectHvsType);
base.Controls.Add(this.label7);
base.set_Name("HouseIngenerView");
base.set_Size(new System.Drawing.Size(0x180, 0x11a));
base.add_Load(new System.EventHandler(this.HousePassportIngener_Load));
base.ResumeLayout(false);
base.PerformLayout();
}
private void отчетПоПериодамЗадолженностиToolStripMenuItem_Click(object sender, System.EventArgs e)
{
if (!this.IsBusy())
{
this.m_TypeReport = 2;
this.m_SubtypeReport = 2;
if (this.Verify())
{
this.tsBtnShowReports.set_Image(Resources.LOADING);
this.selectFasetApartmentType = this.FasetApartmentType;
this.selectFasetAccountProperty = this.FasetAccountProperty;
this.m_WorkerGetReports.RunWorkerAsync();
}
}
}
public void Filter(System.DateTime period, string accountNumber, FasetItem status)
{
this.m_IsFiltered = true;
this.m_Period = period;
this.m_AccountNumber = accountNumber;
this.m_Status = status;
this.bsPayReesterRecords.SuspendBinding();
this.bsPayReesterRecords.set_DataSource(this.mPayReester.GetPayReesterRecordsBy(period, accountNumber, status));
this.bsPayReesterRecords.ResumeBinding();
if ((this.bsPayReesterRecords.get_Count() == 0) && (this.OnSelectedReesterRecords != null))
{
this.OnSelectedReesterRecords(this.SelectedReesterRecords);
}
if (this.bsPayReesterRecords.get_Count() == 0)
{
Messages.ShowMessage("Нет записей реестра, удовлетворящих заданным критериям.");
}
}
private void поЛицевымСчетамToolStripMenuItem_Click(object sender, System.EventArgs e)
{
if (!this.IsBusy())
{
this.m_TypeReport = 0;
this.tsBtnSelectAll.set_Visible(true);
this.splitContainer1.set_Panel2Collapsed(false);
if (this.Verify())
{
this.Clear();
this.dbxSaveDate.set_Visible(true);
this.labelSaveDate.set_Visible(true);
string str = (((int) this.Period.get_Month()).ToString() + "/" + ((int) this.Period.get_Year()).ToString()).Replace("0", @"\0").Replace("9", @"\9");
this.dbxSaveDate.set_Mask((this.Period.get_Month() < 10) ? (@"00/\0" + str) : ("00/" + str));
this.dbxSaveDate.Value = this.Period;
this.tsLabelAccountServices.set_Text("Услуги лицевого счета");
this.selectFasetApartmentType = this.FasetApartmentType;
this.selectFasetAccountProperty = this.FasetAccountProperty;
this.m_cityBoroughs = this.selectCityBoroughs.SelectedFasetItem;
if ((((this.Adresses.get_Count() != 0) && (this.Providers.get_Count() == 0)) && ((this.Holders.get_Count() == 0) && (this.Services.get_Count() == 0))) && (((this.ServiceTypes.get_Count() == 0) && (this.AccountHolders.get_Count() == 0)) && ((this.selectFasetAccountProperty.Id == 0) && (this.selectFasetApartmentType.Id == 0))))
{
if (Messages.QuestionYesNo(this, "Вы не выбрали ни одного параметра. Данное действие без ограниения по параметрам может занять продолжительное время.\nВы уверены что хотите продолжить?") == System.Windows.Forms.DialogResult.Yes)
{
this.tsBtnShow.set_Image(Resources.LOADING);
this.m_WorkerGetAccounts.RunWorkerAsync();
}
}
else
{
this.tsBtnShow.set_Image(Resources.LOADING);
this.m_WorkerGetAccounts.RunWorkerAsync();
}
}
}
}
public static ObjectList<Benefit> FindBy(Organization organization, FasetItem type)
{
return Mappers.BenefitMapper.FindBy(organization, type);
}
private void btnSearch_Click(object sender, System.EventArgs e)
{
this.m_period = this.cbEnablePeriod.get_Checked() ? this.dpsPeriod.DateBegin : Constants.NullDate;
this.m_AccountNumber = this.tbAccountNumber.get_Text().Trim();
this.m_Status = this.sfdStatus.SelectedFasetItem;
base.set_DialogResult(System.Windows.Forms.DialogResult.OK);
base.Close();
}
public PayReesterRecordsForm(PayReester payReester, FasetItem status)
: this(payReester)
{
this.payReesterRecordsView.PayReester = payReester;
this.payReesterRecordsView.Filter(Constants.NullDate, string.Empty, status);
}
public static FasetItem AddFasetItem(int fasetId, string name)
{
FasetItem data = new FasetItem((FasetsEnum) fasetId, name);
Mappers.FasetItemMapper.Insert(data);
faset_items[fasetId].Add(data.Id, data);
return data;
}
public void Insert(FasetItem data)
{
System.Data.SqlClient.SqlParameter[] parameters = new System.Data.SqlClient.SqlParameter[3];
parameters[0] = new System.Data.SqlClient.SqlParameter("@id", System.Data.SqlDbType.Int);
parameters[0].set_Direction(System.Data.ParameterDirection.Output);
parameters[1] = new System.Data.SqlClient.SqlParameter("@fasetId", System.Data.SqlDbType.SmallInt);
parameters[1].set_Value(data.FasetId);
parameters[2] = new System.Data.SqlClient.SqlParameter("@name", System.Data.SqlDbType.VarChar, 0xff);
parameters[2].set_Value(data.Name);
DALSql.ExecuteNonQuery("EXEC sn.FasetItem$Add @id output, @fasetId, @name", parameters);
data.Id = (int) ((int) parameters[0].get_Value());
}
public static ObjectList<PayRequestGate> FindBy(string account, System.DateTime fromDay, System.DateTime toDay, FasetItem status, bool isOnlyConfirmed, bool isOnlyNotConfirmed, int topRecordCount)
{
return Mappers.PayRequestGateMapper.FindBy(account, fromDay, toDay, status.Id, isOnlyConfirmed, isOnlyNotConfirmed, topRecordCount);
}
public void Update(FasetItem data)
{
System.Data.SqlClient.SqlParameter[] parameters = new System.Data.SqlClient.SqlParameter[2];
parameters[0] = new System.Data.SqlClient.SqlParameter("@id", System.Data.SqlDbType.Int);
parameters[0].set_Value((int) data.Id);
parameters[1] = new System.Data.SqlClient.SqlParameter("@name", System.Data.SqlDbType.VarChar, 0xff);
parameters[1].set_Value(data.Name);
DALSql.ExecuteNonQuery("EXEC sn.FasetItem$Change @id, @name", parameters);
}
private void InitializeComponent()
{
this.components = new Container();
FasetItem item = new FasetItem();
this.btCancel = new System.Windows.Forms.Button();
this.btOk = new System.Windows.Forms.Button();
this.gbBox = new System.Windows.Forms.GroupBox();
this.udSquare = new System.Windows.Forms.NumericUpDown();
this.bsApartmentHousekeeping = new System.Windows.Forms.BindingSource(this.components);
this.label2 = new System.Windows.Forms.Label();
this.label1 = new System.Windows.Forms.Label();
this.dbEnd = new DateBox();
this.dbBegin = new DateBox();
this.lSquare = new System.Windows.Forms.Label();
this.textBox1 = new System.Windows.Forms.TextBox();
this.lName = new System.Windows.Forms.Label();
this.cbTypeHousekeeping = new SelectFasetData();
this.lTypeHousekeeping = new System.Windows.Forms.Label();
this.gbBox.SuspendLayout();
this.udSquare.BeginInit();
this.bsApartmentHousekeeping.BeginInit();
base.SuspendLayout();
this.btCancel.set_DialogResult(System.Windows.Forms.DialogResult.Cancel);
this.btCancel.set_Location(new System.Drawing.Point(0x132, 0xa9));
this.btCancel.set_Margin(new System.Windows.Forms.Padding(2));
this.btCancel.set_Name("btCancel");
this.btCancel.set_Size(new System.Drawing.Size(80, 0x19));
this.btCancel.set_TabIndex(3);
this.btCancel.set_Text("Отмена");
this.btCancel.set_UseVisualStyleBackColor(true);
this.btCancel.add_Click(new System.EventHandler(this.btCancel_Click));
this.btOk.set_Location(new System.Drawing.Point(0xde, 0xa9));
this.btOk.set_Margin(new System.Windows.Forms.Padding(2));
this.btOk.set_Name("btOk");
this.btOk.set_Size(new System.Drawing.Size(80, 0x19));
this.btOk.set_TabIndex(2);
this.btOk.set_UseVisualStyleBackColor(true);
this.btOk.add_Click(new System.EventHandler(this.btOk_Click));
this.gbBox.Controls.Add(this.udSquare);
this.gbBox.Controls.Add(this.label2);
this.gbBox.Controls.Add(this.label1);
this.gbBox.Controls.Add(this.dbEnd);
this.gbBox.Controls.Add(this.dbBegin);
this.gbBox.Controls.Add(this.lSquare);
this.gbBox.Controls.Add(this.textBox1);
this.gbBox.Controls.Add(this.lName);
this.gbBox.Controls.Add(this.cbTypeHousekeeping);
this.gbBox.Controls.Add(this.lTypeHousekeeping);
this.gbBox.set_Dock(System.Windows.Forms.DockStyle.Top);
this.gbBox.set_FlatStyle(System.Windows.Forms.FlatStyle.System);
this.gbBox.set_Location(new System.Drawing.Point(0, 0));
this.gbBox.set_Margin(new System.Windows.Forms.Padding(2));
this.gbBox.set_Name("gbBox");
this.gbBox.set_Padding(new System.Windows.Forms.Padding(2));
this.gbBox.set_Size(new System.Drawing.Size(0x182, 0xa2));
this.gbBox.set_TabIndex(4);
this.gbBox.set_TabStop(false);
this.gbBox.set_Text("Свойства приусадебного хозяйства");
this.udSquare.DataBindings.Add(new System.Windows.Forms.Binding("Value", this.bsApartmentHousekeeping, "SquareHk", true));
this.udSquare.set_DecimalPlaces(3);
this.udSquare.set_Location(new System.Drawing.Point(0xb3, 0x5d));
this.udSquare.set_Margin(new System.Windows.Forms.Padding(2));
int[] numArray = new int[4];
numArray[0] = 0x2710;
this.udSquare.set_Maximum(new decimal(numArray));
this.udSquare.set_Name("udSquare");
this.udSquare.set_Size(new System.Drawing.Size(90, 20));
this.udSquare.set_TabIndex(0x19);
this.bsApartmentHousekeeping.set_DataSource(typeof(ApartmentHousekeeping));
this.label2.set_AutoSize(true);
this.label2.set_Location(new System.Drawing.Point(6, 0x8d));
this.label2.set_Margin(new System.Windows.Forms.Padding(2, 0, 2, 0));
this.label2.set_Name("label2");
this.label2.set_Size(new System.Drawing.Size(170, 13));
this.label2.set_TabIndex(0x18);
this.label2.set_Text("Дата окончания использования");
this.label1.set_AutoSize(true);
this.label1.set_Location(new System.Drawing.Point(6, 0x77));
this.label1.set_Margin(new System.Windows.Forms.Padding(2, 0, 2, 0));
this.label1.set_Name("label1");
this.label1.set_Size(new System.Drawing.Size(0x98, 13));
this.label1.set_TabIndex(0x17);
this.label1.set_Text("Дата начала использования");
this.dbEnd.AttachToPeriod = false;
this.dbEnd.DataBindings.Add(new System.Windows.Forms.Binding("Value", this.bsApartmentHousekeeping, "Datee", true));
this.dbEnd.set_Location(new System.Drawing.Point(0xb3, 0x88));
this.dbEnd.set_Margin(new System.Windows.Forms.Padding(2));
this.dbEnd.set_Mask("00/00/0000");
this.dbEnd.set_Name("dbEnd");
this.dbEnd.set_Size(new System.Drawing.Size(0x5b, 20));
this.dbEnd.set_TabIndex(0x16);
this.dbBegin.AttachToPeriod = false;
this.dbBegin.DataBindings.Add(new System.Windows.Forms.Binding("Value", this.bsApartmentHousekeeping, "Dateb", true));
this.dbBegin.set_Location(new System.Drawing.Point(0xb3, 0x73));
this.dbBegin.set_Margin(new System.Windows.Forms.Padding(2));
this.dbBegin.set_Mask("00/00/0000");
this.dbBegin.set_Name("dbBegin");
this.dbBegin.set_Size(new System.Drawing.Size(0x5b, 20));
this.dbBegin.set_TabIndex(0x15);
this.lSquare.set_AutoSize(true);
this.lSquare.set_Location(new System.Drawing.Point(6, 0x5d));
this.lSquare.set_Margin(new System.Windows.Forms.Padding(2, 0, 2, 0));
this.lSquare.set_Name("lSquare");
this.lSquare.set_Size(new System.Drawing.Size(0x36, 13));
this.lSquare.set_TabIndex(20);
this.lSquare.set_Text("Площадь");
this.textBox1.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.bsApartmentHousekeeping, "NameHk", true));
this.textBox1.set_Location(new System.Drawing.Point(6, 0x1b));
this.textBox1.set_Margin(new System.Windows.Forms.Padding(2));
this.textBox1.set_Name("textBox1");
this.textBox1.set_Size(new System.Drawing.Size(0x174, 20));
this.textBox1.set_TabIndex(0x13);
this.lName.set_AutoSize(true);
this.lName.set_Location(new System.Drawing.Point(3, 14));
this.lName.set_Margin(new System.Windows.Forms.Padding(2, 0, 2, 0));
this.lName.set_Name("lName");
this.lName.set_Size(new System.Drawing.Size(0x39, 13));
this.lName.set_TabIndex(0x12);
this.lName.set_Text("Название");
this.cbTypeHousekeeping.DataBindings.Add(new System.Windows.Forms.Binding("SelectedValue", this.bsApartmentHousekeeping, "TypeHkName", true));
this.cbTypeHousekeeping.set_FormattingEnabled(true);
this.cbTypeHousekeeping.set_Location(new System.Drawing.Point(6, 0x42));
this.cbTypeHousekeeping.set_Margin(new System.Windows.Forms.Padding(2));
this.cbTypeHousekeeping.set_Name("cbTypeHousekeeping");
item.FasetId = FasetsEnum.None;
item.Id = 0;
item.Name = "<не выбрано>";
this.cbTypeHousekeeping.SelectedFasetItem = item;
this.cbTypeHousekeeping.set_Size(new System.Drawing.Size(0x174, 0x15));
this.cbTypeHousekeeping.set_Sorted(true);
this.cbTypeHousekeeping.set_TabIndex(0x11);
this.lTypeHousekeeping.set_AutoSize(true);
this.lTypeHousekeeping.set_Location(new System.Drawing.Point(3, 50));
this.lTypeHousekeeping.set_Margin(new System.Windows.Forms.Padding(2, 0, 2, 0));
this.lTypeHousekeeping.set_Name("lTypeHousekeeping");
this.lTypeHousekeeping.set_Size(new System.Drawing.Size(160, 13));
this.lTypeHousekeeping.set_TabIndex(0x10);
this.lTypeHousekeeping.set_Text("Тип приусадебного хозяйства");
base.set_AutoScaleDimensions(new System.Drawing.SizeF(6f, 13f));
base.set_AutoScaleMode(System.Windows.Forms.AutoScaleMode.Font);
base.set_ClientSize(new System.Drawing.Size(0x182, 0xc9));
base.Controls.Add(this.gbBox);
base.Controls.Add(this.btCancel);
base.Controls.Add(this.btOk);
base.set_FormBorderStyle(System.Windows.Forms.FormBorderStyle.FixedSingle);
base.set_Margin(new System.Windows.Forms.Padding(2));
base.set_MaximizeBox(false);
base.set_Name("ApartmentHousekeepingAddChangeForm");
base.set_StartPosition(System.Windows.Forms.FormStartPosition.CenterScreen);
this.set_Text("Изменить свойства Приусадебного хозяйства");
base.add_Load(new System.EventHandler(this.ApartmentHousekeepingChangeForm_Load));
this.gbBox.ResumeLayout(false);
this.gbBox.PerformLayout();
this.udSquare.EndInit();
this.bsApartmentHousekeeping.EndInit();
base.ResumeLayout(false);
}
public void Delete(FasetItem data)
{
System.Data.SqlClient.SqlParameter[] parameters = new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@id", System.Data.SqlDbType.Int) };
parameters[0].set_Value((int) data.Id);
DALSql.ExecuteNonQuery("delete sn.FasetItems where id = @id", parameters);
}
public void InsertReportShedulerParameters(long reportId, System.DateTime fromDate, System.DateTime toDate, ObjectList<Organization> houseHolders, ObjectList<Organization> serviceHouseHolders, ObjectList<Organization> accountHouseHolders, ObjectList<Organization> serviceProviders, ObjectList<Organization> resourceProviders, ObjectList<Organization> cashlessTransferrers, ObjectList<ServiceTypeOld> serviceTypes, ObjectList<CanonicalService> canonicalServices, ObjectList<ServiceOld> services, System.Collections.Generic.List<FasetItem> fasetItemApartmentTypes, System.Collections.Generic.List<FasetItem> fasetItemConvenienceTypes, System.Collections.Generic.List<FasetItem> fasetItemRecalcReasons, ObjectList<LocalAddress> localAddresses, Area selectedByUserArea, ObjectList<Benefit> benefits, bool isDebt, bool existsBenefitDiff, string paymentType, string apartamentArea, long minSumm, System.DateTime fromDay, System.DateTime toDay, bool withoutBankrupt, bool withoutClosesApartments, System.Collections.Generic.List<FasetItem> fasetFilterItems, ObjectList<Organization> paymentAgents, System.Collections.Generic.List<FasetItem> fasetItemHouseTypes, FasetItem cityBoroughs, string textParameter)
{
if (reportId != RepReportSheduler.Null.Id)
{
RepReportShedulerParameter parameter;
if (fromDate != AIS.SN.Model.Constants.NullDate)
{
parameter = new RepReportShedulerParameter {
ReportId = reportId,
Name = "fromDate",
Value = fromDate.ToShortDateString(),
PrintName = "Начало периода",
PrintValue = fromDate.ToShortDateString()
};
parameter.SaveChanges();
}
if (toDate != AIS.SN.Model.Constants.NullDate)
{
parameter = new RepReportShedulerParameter {
ReportId = reportId,
Name = "toDate",
Value = toDate.ToShortDateString(),
PrintName = "Окончание периода",
PrintValue = toDate.ToShortDateString()
};
parameter.SaveChanges();
}
if (houseHolders != null)
{
foreach (Organization organization in houseHolders)
{
parameter = new RepReportShedulerParameter {
ReportId = reportId,
Name = "houseHolderId",
Value = ((long) organization.Id).ToString(),
PrintName = "Управляющая компания жилья",
PrintValue = organization.ShortName
};
parameter.SaveChanges();
}
}
if (serviceHouseHolders != null)
{
foreach (Organization organization2 in serviceHouseHolders)
{
parameter = new RepReportShedulerParameter {
ReportId = reportId,
Name = "serviceHouseHolderId",
Value = ((long) organization2.Id).ToString(),
PrintName = "Управляющая компания услуги",
PrintValue = organization2.ShortName
};
parameter.SaveChanges();
}
}
if (accountHouseHolders != null)
{
foreach (Organization organization3 in accountHouseHolders)
{
parameter = new RepReportShedulerParameter {
ReportId = reportId,
Name = "accountHouseHolderId",
Value = ((long) organization3.Id).ToString(),
PrintName = "Управляющая компания ЛС",
PrintValue = organization3.ShortName
};
parameter.SaveChanges();
}
}
if (serviceProviders != null)
{
foreach (Organization organization4 in serviceProviders)
{
parameter = new RepReportShedulerParameter {
ReportId = reportId,
Name = "serviceProviderId",
Value = ((long) organization4.Id).ToString(),
PrintName = "Поставщик",
PrintValue = organization4.ShortName
};
parameter.SaveChanges();
}
}
if (resourceProviders != null)
{
foreach (Organization organization5 in resourceProviders)
{
parameter = new RepReportShedulerParameter {
ReportId = reportId,
Name = "resourceProviderId",
Value = ((long) organization5.Id).ToString(),
PrintName = "Ресурсоснабжающая организация",
PrintValue = organization5.ShortName
};
parameter.SaveChanges();
}
}
if (cashlessTransferrers != null)
{
foreach (Organization organization6 in cashlessTransferrers)
{
parameter = new RepReportShedulerParameter {
ReportId = reportId,
Name = "cashlessTransferrerId",
Value = ((long) organization6.Id).ToString(),
PrintName = "Организация по безналичным перечислениям",
PrintValue = organization6.ShortName
};
parameter.SaveChanges();
}
}
if (serviceTypes != null)
{
foreach (ServiceTypeOld old in serviceTypes)
{
parameter = new RepReportShedulerParameter {
ReportId = reportId,
Name = "serviceTypeId",
Value = ((long) old.Id).ToString(),
PrintName = "Группа услуг",
PrintValue = old.ShortName
};
parameter.SaveChanges();
}
}
if (canonicalServices != null)
{
foreach (CanonicalService service in canonicalServices)
{
parameter = new RepReportShedulerParameter {
ReportId = reportId,
Name = "canonicalId",
Value = ((long) service.Id).ToString(),
PrintName = "Вид благоустройства",
PrintValue = service.ShortName
};
parameter.SaveChanges();
}
}
if (services != null)
{
foreach (ServiceOld old2 in services)
{
parameter = new RepReportShedulerParameter {
ReportId = reportId,
Name = "serviceId",
Value = ((long) old2.Id).ToString(),
PrintName = "Услуга",
PrintValue = old2.ShortName
};
parameter.SaveChanges();
}
}
if (fasetItemApartmentTypes != null)
{
foreach (FasetItem item in fasetItemApartmentTypes)
{
parameter = new RepReportShedulerParameter {
ReportId = reportId,
Name = "fasetItemApartmentTypeId",
Value = ((int) item.Id).ToString(),
PrintName = "Тип жилья",
PrintValue = item.Name
};
parameter.SaveChanges();
}
}
if (fasetItemHouseTypes != null)
{
foreach (FasetItem item2 in fasetItemHouseTypes)
{
parameter = new RepReportShedulerParameter {
ReportId = reportId,
Name = "fasetItemHouseTypeId",
Value = ((int) item2.Id).ToString(),
PrintName = "Тип дома",
PrintValue = item2.Name
};
parameter.SaveChanges();
}
}
if (fasetItemConvenienceTypes != null)
{
foreach (FasetItem item3 in fasetItemConvenienceTypes)
{
parameter = new RepReportShedulerParameter {
ReportId = reportId,
Name = "convenienceTypeId",
Value = ((int) item3.Id).ToString(),
PrintName = "Тип благоустройства",
PrintValue = item3.Name
};
parameter.SaveChanges();
}
}
if (fasetItemRecalcReasons != null)
{
foreach (FasetItem item4 in fasetItemRecalcReasons)
{
parameter = new RepReportShedulerParameter {
ReportId = reportId,
Name = "typeReasonRecalcId",
Value = ((int) item4.Id).ToString(),
PrintName = "Причина перерасчёта",
PrintValue = item4.Name
};
parameter.SaveChanges();
}
}
if ((localAddresses != null) && (localAddresses.get_Count() != 0))
{
parameter = new RepReportShedulerParameter {
ReportId = reportId,
Name = "areaId",
Value = ((long) Area.GetAreaIdByLocalAddresses(localAddresses)).ToString()
};
if (selectedByUserArea == Area.Null)
{
parameter.Value = ((long) Area.GetAreaIdByLocalAddresses(localAddresses)).ToString();
}
else
{
parameter.Value = ((long) selectedByUserArea.Id).ToString();
}
parameter.SaveChanges();
}
if (benefits != null)
{
foreach (Benefit benefit in benefits)
{
parameter = new RepReportShedulerParameter {
ReportId = reportId,
Name = "benefitId",
Value = ((long) benefit.Id).ToString(),
PrintName = "Льгота",
PrintValue = benefit.ShortName
};
parameter.SaveChanges();
}
}
if (isDebt)
{
parameter = new RepReportShedulerParameter {
ReportId = reportId,
Name = "isDebt",
Value = "1",
PrintName = "Разделение долгов",
PrintValue = "учтено"
};
parameter.SaveChanges();
}
if (existsBenefitDiff)
{
parameter = new RepReportShedulerParameter {
ReportId = reportId,
Name = "isExistsBenefitDiff",
Value = "1",
PrintName = "Расхождения с КСЗН",
PrintValue = "учтены"
};
parameter.SaveChanges();
}
if (fasetFilterItems != null)
{
foreach (FasetItem item5 in fasetFilterItems)
{
parameter = new RepReportShedulerParameter {
ReportId = reportId,
Name = "fasetFilterItemId",
Value = ((int) item5.Id).ToString(),
PrintName = item5.Faset.Name,
PrintValue = item5.Name
};
parameter.SaveChanges();
}
}
if (paymentAgents != null)
{
foreach (Organization organization7 in paymentAgents)
{
parameter = new RepReportShedulerParameter {
ReportId = reportId,
Name = "paymentAgentId",
Value = ((long) organization7.Id).ToString(),
PrintName = "Платежный агент",
PrintValue = organization7.ShortName
};
parameter.SaveChanges();
}
}
RepReportTemplate template = RepReportTemplate.FindById(((RepReportTemplate) this.reportsTree.SelectedNode.get_Tag()).Id);
if (template.MinSumm)
{
parameter = new RepReportShedulerParameter {
ReportId = reportId,
Name = "minSumm",
Value = this.numMinSumm.Value.ToString(),
PrintName = "Минимальная сумма",
PrintValue = ((long) minSumm).ToString()
};
parameter.SaveChanges();
}
if (template.DatePeriod)
{
if (fromDay != AIS.SN.Model.Constants.NullDate)
{
parameter = new RepReportShedulerParameter {
ReportId = reportId,
Name = "fromDay",
Value = fromDay.ToShortDateString(),
PrintName = "Дата начала",
PrintValue = fromDay.ToShortDateString()
};
parameter.SaveChanges();
}
if (toDay != AIS.SN.Model.Constants.NullDate)
{
parameter = new RepReportShedulerParameter {
ReportId = reportId,
Name = "toDay",
Value = toDay.ToShortDateString(),
PrintName = "Дата окончания",
PrintValue = toDay.ToShortDateString()
};
parameter.SaveChanges();
}
}
if (template.CalcOperationGroups)
{
CalcOperationGroup group = ((CalcOperationGroup) this.bsCalcOperationGroups.get_Current()) ?? CalcOperationGroup.Null;
if (group != CalcOperationGroup.Null)
{
parameter = new RepReportShedulerParameter {
ReportId = reportId,
Name = "calcOperGroupId",
Value = ((long) group.Id).ToString(),
PrintName = "Тип оплаты",
PrintValue = group.Name
};
parameter.SaveChanges();
}
}
if (paymentType != string.Empty)
{
parameter = new RepReportShedulerParameter {
ReportId = reportId,
Name = "paymentType",
Value = paymentType,
PrintName = "Тип оплаты",
PrintValue = paymentType
};
parameter.SaveChanges();
}
if (apartamentArea != string.Empty)
{
parameter = new RepReportShedulerParameter {
ReportId = reportId,
Name = "apartamentArea",
Value = apartamentArea,
PrintName = "Площадь",
PrintValue = apartamentArea
};
parameter.SaveChanges();
}
if (template.PaymentAgentTypes)
{
FasetItem selectedFasetItem = this.selectPaymentAgentTypes.SelectedFasetItem;
if (selectedFasetItem != FasetItem.Null)
{
parameter = new RepReportShedulerParameter {
ReportId = reportId,
Name = "paymentAgentTypeId",
Value = ((int) selectedFasetItem.Id).ToString(),
PrintName = "Режим работы",
PrintValue = selectedFasetItem.Name
};
parameter.SaveChanges();
}
}
if (withoutBankrupt)
{
parameter = new RepReportShedulerParameter {
ReportId = reportId,
Name = "withoutBankrupt",
Value = "1",
PrintName = "Организации-банкроты",
PrintValue = "Не учитывать"
};
parameter.SaveChanges();
}
if (withoutClosesApartments)
{
parameter = new RepReportShedulerParameter {
ReportId = reportId,
Name = "withoutClosesApartments",
Value = "1",
PrintName = "Закрытые паспорта жилья",
PrintValue = "Не учитывать"
};
parameter.SaveChanges();
}
if (template.AccountProperty)
{
FasetItem item7 = this.selectAccountPropertyFaset.SelectedFasetItem;
if (item7 != FasetItem.Null)
{
parameter = new RepReportShedulerParameter {
ReportId = reportId,
Name = "accountPropertyId",
Value = ((int) item7.Id).ToString(),
PrintName = "Параметры ЛС",
PrintValue = item7.Name
};
parameter.SaveChanges();
}
}
if (template.AccountProperty)
{
FasetItem item8 = this.selectAccountPropertyFaset.SelectedFasetItem;
if (item8 != FasetItem.Null)
{
parameter = new RepReportShedulerParameter {
ReportId = reportId,
Name = "accountPropertyId",
Value = ((int) item8.Id).ToString(),
PrintName = "Параметры ЛС",
PrintValue = item8.Name
};
parameter.SaveChanges();
}
}
if (template.CityBorough && (cityBoroughs != FasetItem.Null))
{
parameter = new RepReportShedulerParameter {
ReportId = reportId,
Name = "boroughId",
Value = ((int) cityBoroughs.Id).ToString(),
PrintName = "Район города",
PrintValue = cityBoroughs.Name
};
parameter.SaveChanges();
}
if (!string.IsNullOrEmpty(textParameter))
{
new RepReportShedulerParameter { ReportId = reportId, Name = "textParameter", Value = textParameter, PrintName = template.TextParameter, PrintValue = textParameter }.SaveChanges();
}
}
}
public static ObjectList<ApartmentCounterPlaceFactor> Search(FasetItem place, System.DateTime period, decimal value, string oper)
{
return Mappers.ApartmentCounterPlaceFactorMapper.Search(place, period, value, oper);
}
