sa011.cs
来自「C#简单练习进销存代码」· CS 代码 · 共 491 行 · 第 1/2 页
CS
491 行
this.label2.Location = new System.Drawing.Point(5, 25);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(142, 20);
this.label2.TabIndex = 11;
this.label2.Text = "Date";
this.label2.TextAlign = System.Drawing.ContentAlignment.BottomCenter;
//
// label1
//
this.label1.Dock = System.Windows.Forms.DockStyle.Top;
this.label1.Location = new System.Drawing.Point(5, 5);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(142, 20);
this.label1.TabIndex = 10;
this.label1.Text = "Code";
this.label1.TextAlign = System.Drawing.ContentAlignment.BottomCenter;
//
// textBox9
//
this.textBox9.Dock = System.Windows.Forms.DockStyle.Bottom;
this.textBox9.Location = new System.Drawing.Point(5, 182);
this.textBox9.Name = "textBox9";
this.textBox9.ReadOnly = true;
this.textBox9.Size = new System.Drawing.Size(146, 20);
this.textBox9.TabIndex = 19;
this.textBox9.Text = "textBox9";
//
// textBox8
//
this.textBox8.Dock = System.Windows.Forms.DockStyle.Bottom;
this.textBox8.Location = new System.Drawing.Point(5, 202);
this.textBox8.Name = "textBox8";
this.textBox8.ReadOnly = true;
this.textBox8.Size = new System.Drawing.Size(146, 20);
this.textBox8.TabIndex = 18;
this.textBox8.Text = "textBox8";
//
// textBox7
//
this.textBox7.Dock = System.Windows.Forms.DockStyle.Bottom;
this.textBox7.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.textBox7.Location = new System.Drawing.Point(5, 222);
this.textBox7.Name = "textBox7";
this.textBox7.ReadOnly = true;
this.textBox7.Size = new System.Drawing.Size(146, 20);
this.textBox7.TabIndex = 17;
this.textBox7.Text = "textBox7";
this.textBox7.TextAlign = System.Windows.Forms.HorizontalAlignment.Right;
//
// textBox6
//
this.textBox6.Dock = System.Windows.Forms.DockStyle.Bottom;
this.textBox6.Location = new System.Drawing.Point(5, 242);
this.textBox6.Name = "textBox6";
this.textBox6.ReadOnly = true;
this.textBox6.Size = new System.Drawing.Size(146, 20);
this.textBox6.TabIndex = 16;
this.textBox6.Text = "textBox6";
//
// textBox5
//
this.textBox5.Dock = System.Windows.Forms.DockStyle.Bottom;
this.textBox5.Location = new System.Drawing.Point(5, 262);
this.textBox5.Name = "textBox5";
this.textBox5.ReadOnly = true;
this.textBox5.Size = new System.Drawing.Size(146, 20);
this.textBox5.TabIndex = 15;
this.textBox5.Text = "textBox5";
//
// textBox4
//
this.textBox4.Dock = System.Windows.Forms.DockStyle.Bottom;
this.textBox4.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.textBox4.Location = new System.Drawing.Point(5, 282);
this.textBox4.Name = "textBox4";
this.textBox4.ReadOnly = true;
this.textBox4.Size = new System.Drawing.Size(146, 20);
this.textBox4.TabIndex = 14;
this.textBox4.Text = "textBox4";
this.textBox4.TextAlign = System.Windows.Forms.HorizontalAlignment.Right;
//
// textBox3
//
this.textBox3.Dock = System.Windows.Forms.DockStyle.Top;
this.textBox3.Location = new System.Drawing.Point(5, 65);
this.textBox3.Name = "textBox3";
this.textBox3.Size = new System.Drawing.Size(146, 20);
this.textBox3.TabIndex = 13;
this.textBox3.Text = "textBox3";
//
// textBox2
//
this.textBox2.Dock = System.Windows.Forms.DockStyle.Top;
this.textBox2.Location = new System.Drawing.Point(5, 45);
this.textBox2.Name = "textBox2";
this.textBox2.Size = new System.Drawing.Size(146, 20);
this.textBox2.TabIndex = 12;
this.textBox2.Text = "textBox2";
//
// dateTimePicker1
//
this.dateTimePicker1.CustomFormat = "yyyy-MM-dd";
this.dateTimePicker1.Dock = System.Windows.Forms.DockStyle.Top;
this.dateTimePicker1.Format = System.Windows.Forms.DateTimePickerFormat.Custom;
this.dateTimePicker1.Location = new System.Drawing.Point(5, 25);
this.dateTimePicker1.Name = "dateTimePicker1";
this.dateTimePicker1.Size = new System.Drawing.Size(146, 20);
this.dateTimePicker1.TabIndex = 11;
//
// textBox1
//
this.textBox1.Dock = System.Windows.Forms.DockStyle.Top;
this.textBox1.Location = new System.Drawing.Point(5, 5);
this.textBox1.Name = "textBox1";
this.textBox1.Size = new System.Drawing.Size(146, 20);
this.textBox1.TabIndex = 10;
this.textBox1.Text = "textBox1";
//
// SA011
//
this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
this.ClientSize = new System.Drawing.Size(520, 357);
this.Name = "SA011";
this.Text = "single";
((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
this.panel3.ResumeLayout(false);
this.panel4.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.DsMast)).EndInit();
} #endregion
//
//3. load database
//
protected override void ReFill()
{
//3.1 Mast
int p=0;
this.SelSql=" where SA_ID="+this.saId;
if(BindMast!=null&&BindMast.Position>0)p=BindMast.Position;
this.DaMast.SelectCommand =new System.Data.OleDb.OleDbCommand(BasSql+SelSql,dbCon);
System.Data.OleDb.OleDbCommandBuilder OleDbCommandBuilder1 =new System.Data.OleDb.OleDbCommandBuilder (this.DaMast);
this.DsMast.Clear();
//MessageBox.Show (this.BasSql +this.SelSql );
this.DaMast.Fill(this.DsMast,"Mast");
DsMast.Tables ["Mast"].Columns["RF_CUS"].DefaultValue=0;
DsMast.Tables ["Mast"].Columns["PT_OT"].DefaultValue=0;
//DsMast.Tables ["Mast"].Columns.Add("TOT_SUP",System.Type.GetType("System.Decimal"),"Sum(PT_SUP)");
//DsMast.Tables ["Mast"].Columns.Add("TOT_OT",System.Type.GetType("System.Decimal"),"Sum(PT_OT)");
this.Ref_OV ();
//
//3.2 Initial CurrencyManager;
//
this.BindMast =(CurrencyManager)this.BindingContext[DsMast,"Mast"];
this.BindMast.Position =p;
//this.BindMast.PositionChanged-=new EventHandler(BindMast_PositionChanged);
//this.BindMast.PositionChanged+=new EventHandler(BindMast_PositionChanged);
//
//3.3 Initial DataGrid;
//
this.dataGrid1.TableStyles.Clear();
this.dataGrid1.SetDataBinding (this.DsMast,"Mast");
this.dataGrid1.TableStyles.Add (new DataGridTableStyle());
dataGrid1.TableStyles[0].MappingName="Mast";
dataGrid1.TableStyles[0].GridColumnStyles.RemoveAt (0);
dataGrid1.TableStyles[0].GridColumnStyles.RemoveAt (2);
//dataGrid1.TableStyles[0].GridColumnStyles.RemoveAt (4);
//dataGrid1.TableStyles[0].GridColumnStyles.RemoveAt (4);
//
//3.4 Initial Textbox
//
this.dateTimePicker1.Value=System.DateTime.Now;
if(this.textBox1.DataBindings.Count<=0)this.textBox1.DataBindings.Add("Text",this.DsMast,"Mast.CODE");
if(this.textBox2.DataBindings.Count<=0)this.textBox2.DataBindings.Add("Text",this.DsMast,"Mast.RF_CUS");
if(this.textBox3.DataBindings.Count<=0)this.textBox3.DataBindings.Add("Text",this.DsMast,"Mast.PT_OT");
if(this.textBox4.DataBindings.Count<=0)this.textBox4.DataBindings.Add("Text",this.DsMast,"OV.BL_OT");
if(this.textBox5.DataBindings.Count<=0)this.textBox5.DataBindings.Add("Text",this.DsMast,"OV.PT_OTED");
if(this.textBox6.DataBindings.Count<=0)this.textBox6.DataBindings.Add("Text",this.DsMast,"OV.PT_OT");
if(this.textBox7.DataBindings.Count<=0)this.textBox7.DataBindings.Add("Text",this.DsMast,"OV.BL_CUS");
if(this.textBox8.DataBindings.Count<=0)this.textBox8.DataBindings.Add("Text",this.DsMast,"OV.RF_CUSED");
if(this.textBox9.DataBindings.Count<=0)this.textBox9.DataBindings.Add("Text",this.DsMast,"OV.RF_CUS");
if(this.dateTimePicker1.DataBindings.Count<=0)this.dateTimePicker1.DataBindings.Add("Text",this.DsMast,"Mast.C_DATE");
}
//
//4. Save to Database
//
protected override void Save()
{
this.BindMast.EndCurrentEdit ();
try
{
this.DaMast.Update (DsMast,"Mast");
}
catch(Exception e)
{
MessageBox.Show("Current records have error. The transaction will be ignore! Error:"+e.Message.ToString ());
this.DsMast.RejectChanges();
}
}
//
// 5. this function includes the additional action when save the database.
//
private void DaMast_RowUpdated(object sender, System.Data.OleDb.OleDbRowUpdatedEventArgs e)
{
int newID = 0;
System.Data.OleDb.OleDbCommand idCMD = new System.Data.OleDb.OleDbCommand("SELECT @@IDENTITY",dbCon);
if (e.StatementType == System.Data.StatementType.Insert)
{
// Retrieve the identity value and store it in the CategoryID column.
newID = (int)idCMD.ExecuteScalar();
e.Row["AUTO_NO"] = newID;
// MessageBox.Show (newID.ToString ());
}
this.Ref_OV ();
} //
// 6. Override the AddNew records
//
protected override void AddNew()
{
base.AddNew ();
System.Data.DataRowView drv=(System.Data.DataRowView)this.BindMast.Current ;
drv["SA_ID"]=this.saId;
} private void Ref_OV()
{
System.Data.OleDb.OleDbDataAdapter tmda=new System.Data.OleDb.OleDbDataAdapter ("select * from SA_CF_OV where AUTO_NO="+this.saId,this.dbCon );
if(this.DsMast.Tables.Contains ("OV"))this.DsMast.Tables["OV"].Clear ();
tmda.Fill(this.DsMast,"OV");
tmda.Dispose ();
tmda=null;
} }}⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?