Диплом: Автоматизация учета товаро-материальных ценностей в розничном магазине ООО "Эллада", страницы 111-120

111

this.panel1.Controls.Add(this.EChoSpis);

this.panel1.Controls.Add(this.label4);

this.panel1.Controls.Add(this.cbFrom);

this.panel1.Controls.Add(this.btRPT);

this.panel1.Controls.Add(this.OSComent);

this.panel1.Controls.Add(this.lbComent);

this.panel1.Dock = System.Windows.Forms.DockStyle.Bottom;

this.panel1.Location = new System.Drawing.Point(0, 199);

this.panel1.Name = "panel1";

this.panel1.Padding = new System.Windows.Forms.Padding(2);

this.panel1.Size = new System.Drawing.Size(745, 188);

this.panel1.TabIndex = 1;

//

// gbMet

//

this.gbMet.Controls.Add(this.DGVM);

this.gbMet.Dock = System.Windows.Forms.DockStyle.Right;

this.gbMet.Location = new System.Drawing.Point(464, 2);

this.gbMet.Name = "gbMet";

this.gbMet.Size = new System.Drawing.Size(279, 184);

this.gbMet.TabIndex = 17;

this.gbMet.TabStop = false;

this.gbMet.Text = " Драгоценные металлы ";

//

// DGVM

//

this.DGVM.AllowUserToAddRows = false;

this.DGVM.AllowUserToDeleteRows = false;

this.DGVM.ColumnHeadersHeightSizeMode =

System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;

this.DGVM.Columns.AddRange(new

System.Windows.Forms.DataGridViewColumn[] {

this.xId_DM,

this.xDMName,

this.xMasa});

this.DGVM.Dock = System.Windows.Forms.DockStyle.Fill;

this.DGVM.Location = new System.Drawing.Point(3, 16);

this.DGVM.Name = "DGVM";

this.DGVM.ReadOnly = true;

this.DGVM.RowHeadersVisible = false;

this.DGVM.Size = new System.Drawing.Size(273, 165);

this.DGVM.TabIndex = 1;

//

// xId_DM

//

this.xId_DM.DataPropertyName = "Id_DM";

this.xId_DM.HeaderText = "Код";

this.xId_DM.Name = "xId_DM";

112

this.xId_DM.ReadOnly = true;

this.xId_DM.Width = 50;

//

// xDMName

//

this.xDMName.AutoSizeMode =

System.Windows.Forms.DataGridViewAutoSizeColumnMode.Fill;

this.xDMName.DataPropertyName = "DMName";

this.xDMName.HeaderText = "Наименование";

this.xDMName.Name = "xDMName";

this.xDMName.ReadOnly = true;

//

// xMasa

//

this.xMasa.DataPropertyName = "Masa";

this.xMasa.HeaderText = "Масса";

this.xMasa.Name = "xMasa";

this.xMasa.ReadOnly = true;

this.xMasa.Width = 55;

//

// label5

//

this.label5.TextAlign = System.Drawing.ContentAlignment.MiddleRight;

//

// EChoKod

//

this.EChoKod.Location = new System.Drawing.Point(379, 72);

this.EChoKod.MaxLength = 20;

this.EChoKod.Name = "EChoKod";

this.EChoKod.Size = new System.Drawing.Size(65, 20);

this.EChoKod.TabIndex = 24;

//

// EChoName

//

this.EChoName.Location = new System.Drawing.Point(252, 73);

this.EChoName.MaxLength = 20;

this.EChoName.Name = "EChoName";

this.EChoName.Size = new System.Drawing.Size(80, 20);

this.EChoName.TabIndex = 23;

//

// EChoSpis

//

this.EChoSpis.Location = new System.Drawing.Point(18, 98);

this.EChoSpis.MaxLength = 0;

this.EChoSpis.Multiline = true;

this.EChoSpis.Name = "EChoSpis";

this.EChoSpis.Size = new System.Drawing.Size(426, 55);

this.EChoSpis.TabIndex = 21;

113

this.EChoSpis.TabStop = false;

//

// label4

//

this.label4.TextAlign = System.Drawing.ContentAlignment.MiddleRight;

//

// cbFrom

//

this.cbFrom.DropDownStyle =

System.Windows.Forms.ComboBoxStyle.DropDownList;

this.cbFrom.FormattingEnabled = true;

this.cbFrom.Location = new System.Drawing.Point(18, 159);

this.cbFrom.Name = "cbFrom";

this.cbFrom.Size = new System.Drawing.Size(334, 21);

this.cbFrom.TabIndex = 19;

//

// btRPT

//

this.btRPT.AutoSize = true;

this.btRPT.Location = new System.Drawing.Point(358, 159);

this.btRPT.Name = "btRPT";

this.btRPT.Size = new System.Drawing.Size(86, 23);

this.btRPT.TabIndex = 18;

this.btRPT.Text = "Экспорт";

this.btRPT.UseVisualStyleBackColor = true;

this.btRPT.Click += new System.EventHandler(this.btRPT_Click);

//

// OSComent

//

this.OSComent.Location = new System.Drawing.Point(18, 21);

this.OSComent.MaxLength = 0;

this.OSComent.Multiline = true;

this.OSComent.Name = "OSComent";

this.OSComent.ReadOnly = true;

this.OSComent.Size = new System.Drawing.Size(426, 45);

this.OSComent.TabIndex = 15;

this.OSComent.TabStop = false;

//

// lbComent

//

this.lbComent.AutoSize = true;

this.lbComent.Location = new System.Drawing.Point(11, 5);

this.lbComent.Margin = new System.Windows.Forms.Padding(3);

this.lbComent.Name = "lbComent";

this.lbComent.Size = new System.Drawing.Size(70, 13);

this.lbComent.TabIndex = 12;

this.lbComent.Text = "Примечание";

this.lbComent.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;

114

//

// eAktPP

//

this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);

this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;

this.ClientSize = new System.Drawing.Size(751, 584);

this.Controls.Add(this.gbOS);

this.MaximizeBox = false;

this.MinimizeBox = false;

this.Name = "eAktPP";

this.Text = "Акт приема-передачи / списания";

this.Controls.SetChildIndex(this.BtPanel, 0);

this.Controls.SetChildIndex(this.EdPanel, 0);

this.Controls.SetChildIndex(this.gbOS, 0);

this.EdPanel.ResumeLayout(false);

this.EdPanel.PerformLayout();

this.BtPanel.ResumeLayout(false);

this.BtPanel.PerformLayout();

((System.ComponentModel.ISupportInitialize)(this.EP)).EndInit();

this.gbOS.ResumeLayout(false);

this.zGridPnl.ContentPanel.ResumeLayout(false);

this.zGridPnl.ResumeLayout(false);

this.zGridPnl.PerformLayout();

((System.ComponentModel.ISupportInitialize)(this.DGV)).EndInit();

this.panel1.ResumeLayout(false);

this.panel1.PerformLayout();

this.gbMet.ResumeLayout(false);

((System.ComponentModel.ISupportInitialize)(this.DGVM)).EndInit();

namespace Sklad

{

public partial class eAktPU : zEditX

{

public int TypOS, TypA, Id_Sdal, Id_Fr, Id_Prin, Id_MH, Id_A, Sgn;

protected ds_OSAPU dsOS;

protected ds_Akt dsA;

protected xTables.tABody TTypA;

protected FileInfo[] FI;

public static NameValue[] Rv = null;

public eAktPU(IPY_BindingSource BS, ezStyle eStyle, int typos)

: base(BS, (eStyle | ezStyle.ezMngBS))

{

TypOS = typos;

TypA = 1;

dsA = (ds_Akt)BS.DataSource;

dsOS = new ds_OSAPU();

TTypA = new xTables.tABody(3);

115

dsA.taTypA.FillByStrFLTR(TTypA, "", "Id");

InitializeComponent();

InitComponent(); // ----------------

if (TypOS == 1) this.Text = this.Text + " Основные средства";

if (TypOS == 2) this.Text = this.Text + " Товарно-материальные ценности";

if (TypOS == 3)

{

this.Text = this.Text + " Расходные материалы";

DGV.Columns["xZDat"].Visible = false;

DGV.Columns["xPsw"].HeaderText = "Код единиц измерения";

DGV.Columns["xZNom"].HeaderText = "Название единиц измерения";

gbDM.Enabled = false;

gbDM.Visible = false;

}

InitFinished = true;

btSave.Enabled = this.CanSave();

}

protected override void InitBindings()

((System.ComponentModel.ISupportInitialize)(bs)).BeginInit();

cbTypA.DataSource = TTypA;

cbTypA.DisplayMember = "XName";

cbTypA.ValueMember = "Id";

cbTypOS.DataSource = bs.DataSource;

cbTypOS.DisplayMember = "TypOS.XName";

cbTypOS.ValueMember = "TypOS.Id";

cbTypSg.DataSource = bs.DataSource;

cbTypSg.DisplayMember = "TypSg.XName";

cbTypSg.ValueMember = "TypSg.Id";

((System.ComponentModel.ISupportInitialize)(bs)).EndInit();

BindedOnce = true;

}

eOS.Designer.cs

protected override void InitNotBindings()

{

cbTypA.Enabled = cbTypA.Enabled && mode;

Id_A = (int)R["Id_A"];

dsOS.Id_A = Id_A;

zGridPnl.ZLoad();

EId.Text = R["Id_A"].ToString();

EName.Text = R["NDoc"].ToString();

EComent.Text = R["Coment"].ToString();

Id_Sdal = 0;

if (!R.IsNull("Id_Sdal"))

{

116

Id_Sdal = (int)R["Id_Sdal"];

ESdal.Text = string.Format("[{0}]{1}", Id_Sdal, R["SdalName"]);

}

Id_Fr = 0;

if (!R.IsNull("Id_Fr"))

{

Id_Fr = (int)R["Id_Fr"];

EFr.Text = string.Format("[{0}]{1}", Id_Fr, R["FrName"]);

}

Id_Prin = 0;

if (!R.IsNull("Id_Prin"))

{

Id_Prin = (int)R["Id_Prin"];

EPrin.Text = string.Format("[{0}]{1}", Id_Prin, R["PrinName"]);

}

Id_MH = 0;

if (!R.IsNull("Id_MH"))

{

Id_MH = (int)R["Id_MH"];

EMH.Text = string.Format("[{0}]{1}", Id_MH, R["MHName"]);

}

if (R.IsNull("TypA")) cbTypA.SelectedValue = -1;

else cbTypA.SelectedValue = (int)R["TypA"];

if (R.IsNull("TypOS")) cbTypOS.SelectedValue = -1;

else cbTypOS.SelectedValue = (int)R["TypOS"];

Sgn = 0;

if (!R.IsNull("Sgn")) Sgn = (int)R["Sgn"];

cbTypSg.SelectedValue = Sgn;

if (R.IsNull("RDat")) DTR.Value = null;

else DTR.ValueDay = (int)R["RDat"];

if (!mode)

{

if (zGridPnl.dgv != DGV)

{

dsOS.TypOS = TypOS;

dsOS.Id_A = Id_A;

dsOS.FillByStrFLTR(string.Format("skl_AktD.Id_A={0}", Id_A),

"Id_AD");

DGV.AutoGenerateColumns = false;

DGV.DataSource = dsOS;

DGV.DataMember = "skl_OS";

ZGridPanelStyle ST;

if (Sgn > 0) ST = ZGridPanelStyle.ZSRefresh;

117

else ST = ZGridPanelStyle.ZSAdd | ZGridPanelStyle.ZSEdit |

ZGridPanelStyle.ZSDel;

zGridPnl.InitPanel(ST, ZGridPanelAlign.Top

, DGV

, ""

, "", false

, new NameValue[] { new NameValue("Id_AD", (int)0) }

, null, ref Rv, Program.FndList);

IPY_BindingSource xbs = new IPY_BindingSource();

xbs.DataSource = dsOS;

xbs.DataMember = "skl_OSMet";

xbs.Sort = "Id_DM";

DGVM.AutoGenerateColumns = false;

DGVM.DataSource = xbs;

}

string s = TypOS.ToString() + TypA.ToString();

DirectoryInfo di = new DirectoryInfo(Application.StartupPath+"\\RPT");

FI = di.GetFiles(s+"*.xml");

if (FI != null) foreach (FileInfo f in FI)

{cbFrom.Items.Add(Path.ChangeExtension(f.Name, null).Substring(3)); }

if (cbFrom.Items.Count > 0)

{

cbFrom.SelectedIndex = 0;

btRPT.Enabled = true;

btRPT.Visible = true;

}

eOSA.Designer.cs

protected override void PrepareNewRow()

{

R["Id_A"] = -1;

R["Sgn"] = 0;

R["TypOS"] = TypOS;

R["RDat"] = IPY_Util.Dat2Int(DateTime.Now);

if ((BR != null) && (BR is DataRow))

{ // заповнити за зразком

TypA = 3;

dsA.taTypA.FillByStrFLTR(TTypA, "Id>1", "Id");

}

else cbTypA.Enabled = false;

R["TypA"] = TypA;

}

protected override void PrepareToSave()

{

118

R["NDoc"] = EName.Text.Trim();

R["Coment"] = EComent.Text.Trim();

if (1 != (int)cbTypA.SelectedValue)

{

R["Id_Sdal"] = Id_Sdal;

R["Id_Fr"] = Id_Fr;

}

else

{

R["Id_Sdal"] = DBNull.Value;

R["Id_Fr"] = DBNull.Value;

}

if (2 != (int)cbTypA.SelectedValue)

{

R["Id_Prin"] = Id_Prin;

R["Id_MH"] = Id_MH;

}

else

{

R["Id_Prin"] = DBNull.Value;

R["Id_MH"] = DBNull.Value;

}

if (cbTypA.SelectedValue != null) R["TypA"] = (int)cbTypA.SelectedValue;

else R["TypA"] = DBNull.Value;

if (cbTypOS.SelectedValue != null) R["TypOS"] =

(int)cbTypOS.SelectedValue;

else R["TypOS"] = DBNull.Value;

if (DTR.Value.HasValue) R["RDat"] = DTR.ValueDay;

else R["RDat"] = DBNull.Value;

}

protected override bool IsChanged()

{ // визначає чи змінював користувач дані на формі

bool RetValue = (

(R["NDoc"].ToString() != EName.Text.Trim())

|| (R["Coment"].ToString() != EComent.Text.Trim())

|| (!R["TypA"].Equals(cbTypA.SelectedValue))

|| (!R["TypOS"].Equals(cbTypOS.SelectedValue))

);

if (!RetValue)

if (R.IsNull("Id_Fr")) RetValue = Id_Fr>0;

else RetValue = (Id_Fr != (int)R["Id_Fr"]);

if (!RetValue)

if (R.IsNull("Id_MH")) RetValue = Id_MH > 0;

else RetValue = (Id_MH != (int)R["Id_MH"]);

if (!RetValue)

119

if (R.IsNull("Id_Sdal")) RetValue = Id_Sdal > 0;

else RetValue = (Id_Sdal != (int)R["Id_Sdal"]);

if (!RetValue)

if (R.IsNull("Id_Prin")) RetValue = Id_Prin > 0;

else RetValue = (Id_Prin != (int)R["Id_Prin"]);

if (!RetValue)

if (R.IsNull("RDat")) RetValue = DTR.Value.HasValue;

else RetValue = !(DTR.Value.HasValue &&

(R["RDat"].Equals(DTR.ValueDay)));

return RetValue;

}

protected override bool CanSave()

{

int i = 0;

bool RetValue = false;

if (InitFinished)

{

if (InitFinished && cbTypA.SelectedIndex >= 0)

{

btSdal.Enabled = (1 != (int)cbTypA.SelectedValue);

btPrin.Enabled = (2 != (int)cbTypA.SelectedValue);

}

if (cbTypA.SelectedIndex >= 0)

{

i = (int)cbTypA.SelectedValue;

}

if (// перевірка на коректність-наявність мінімально необхідних даних

(EName.Text.Trim().Length > 0)

&& (i > 0)

&& (DTR.Value.HasValue)

&& (i == 1 || (Id_Sdal > 0 && Id_Fr > 0))

&& (i == 2 || (Id_Prin > 0 && Id_MH > 0))

&&

(

mode || // новий запис або

this.IsChanged() // є дані, що змінювались

)

RetValue = true;

// Попередження про обовязкові поля

EPNeeded = false;

EPSetError(EName, (EName.Text.Trim().Length > 0) ? "" :