260, 96) ;. txtTotal.Name= txtTotal raquo ;;. txtTotal.Size=new System.Drawing.Size (182, 19) ; .txtTotal.TabIndex=4; .txtTotal.Text= 0 raquo ;;. txtTotal.TextAlign=System.Drawing.ContentAlignment.TopRight; .txtCount.Anchor=((System.Windows.Forms.AnchorStyles) ((System. Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right))) ;. txtCount.Location=new System.Drawing.Point (256, 34) ;. txtCount.Name= txtCount raquo ;;. txtCount.Size=new System.Drawing.Size (186, 19) ;. txtCount.TabIndex=3; .txtCount.Text= 0 raquo ;;. txtCount.TextAlign=System.Drawing.ContentAlignment.TopRight; .lbTotal.AutoSize= true; .lbTotal.Location=new System.Drawing.Point (6, 96) ;. lbTotal.Name= lbTotal raquo ;;. lbTotal.Size=new System.Drawing.Size (127, 19) ;. lbTotal.TabIndex =2; .lbTotal.Text= Буде на складі raquo ;;. lbInOut.AutoSize=true; .lbInOut.Location=new System.Drawing.Point (6, 65) ;. lbInOut.Name= lbInOut raquo ;;. lbInOut.Size=new System.Drawing.Size (112, 19) ;. lbInOut.TabIndex=1; .lbInOut.Text= Введення на склад raquo ;;. lbStorage.AutoSize=true; .lbStorage.Location=new System. Drawing.Point (6, 34) ;. lbStorage.Name= lbStorage raquo ;;. lbStorage.Size=new System.Drawing.Size (145, 19) ;. lbStorage.TabIndex=0; .lbStorage.Text= Мається на складі raquo ;;. AutoScaleDimensions=new System.Drawing.SizeF (9F, 19F) ;. AutoScaleMode=System.Windows.Forms.AutoScaleMode.Font; .ClientSize=new System.Drawing.Size (472, 195) ;. Controls.Add (this.gbMaterial) ;. Font=new System.Drawing.Font ( Tahoma raquo ;, 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte) (204))) ; .FormBorderStyle=System.Windows.Forms.FormBorderStyle.FixedToolWindow; .Margin=new System.Windows.Forms.Padding (4) ;. Name= FormMatCount raquo ;;. Text= Додати raquo ;;. Load +=new System.EventHandler(this.FormMatCount_Load);.gbMaterial.ResumeLayout(false);.gbMaterial.PerformLayout();
((System.ComponentModel.ISupportInitialize)(this.nudInOut)).EndInit();.ResumeLayout(false);
}
# endregionSystem.Windows.Forms.GroupBox gbMaterial; System.Windows.Forms.Button btOk; System.Windows.Forms.NumericUpDown nudInOut; System.Windows.Forms.Label txtTotal; System.Windows.Forms.Label txtCount; System.Windows.Forms.Label lbTotal; System.Windows.Forms.Label lbInOut; System.Windows.Forms.Label lbStorage;
}System;System.Collections.Generic;System.Linq;System.Text;System.Threading.Tasks;System.Data;Storage_Coursework
{
public class ObjectProvider
{
public ObjectProvider ()
} static object GetObject (DataRow r, Type objectType)
{. Reflection.ConstructorInfo cnstr=objectType.GetConstructor (System.Type.EmptyTypes); o=cnstr.Invoke (null) ;. Reflection.MemberInfo [] members=objectType.GetMembers (); fieldsCount =r.Table.Columns.Count; (int i=0; i lt; fieldsCount; i ++)
{fieldName=r.Table.Columns [i] .ColumnName; fieldValue=r [fieldName]; member=members.First (t= gt; t.Name == fieldName amp; amp; t.MemberType == System.Reflection.MemberTypes.Property); (member!=null)
{. Reflection.PropertyInfo property=(System.Reflection.PropertyInfo) member; t=property.PropertyType; val; (t.Name == String || t.Name == laquo ; Char ) (fieldValue.ToString ()!= )=fieldValue;=null;
{(fieldValue.ToString () == )=null;
{. Reflection.MethodInfo parseMethod=t.GetMethod ( Parse raquo ;, new Type [] { s .GetType ()});=parseMethod.Invoke (o, new object [ ] {fieldValue.ToString ()});
}. SetValue (o, val, null);
} o;
}System;System.Collections.Generic;System.Linq;System.Text;System.Threading.Tasks;System.Data;System.Data.OleDb;Storage_Coursework
{
public static class OleDB
{static OleDbConnection ole; OleDB ()
{connStr= Provider=Microsoft.Ace.OLEDB.12.0; Data Source=Storage_CourseworkDB.accdb raquo ;;=new OleDbConnection (connStr) ;. Open ();
} static DataSet ExecuteQuery (string query)
{
{adapter=new OleDbDataAdapter (query, ole); ds=new DataSet ( Data ) ;. FillSchema (ds, SchemaType.Source, Table ) ;. Fill (ds, Table ); ds;
} (Exception e)
{
return null;
} static bool DsIsNullOrEmpty (DataSet ds)
{(ds == null || ds.Tables [0] .Rows.Count == 0) true; false;
}System;System.Collections.Generic;System.Linq;System.Threading.Tasks;System.Windows.Forms;Storage_Coursework
{c...
