salarymanage.cs

Visual C#.NET数据库开发经典案例解析,这里有1到3的案例

			this.label23.Location = new System.Drawing.Point(464, 136);
			this.label23.Name = "label23";
			this.label23.Size = new System.Drawing.Size(64, 16);
			this.label23.TabIndex = 19;
			this.label23.Text = "生育保险";
			// 
			// label2
			// 
			this.label2.Location = new System.Drawing.Point(31, 20);
			this.label2.Name = "label2";
			this.label2.Size = new System.Drawing.Size(56, 16);
			this.label2.TabIndex = 19;
			this.label2.Text = "当前月份";
			// 
			// label21
			// 
			this.label21.Location = new System.Drawing.Point(159, 20);
			this.label21.Name = "label21";
			this.label21.Size = new System.Drawing.Size(56, 16);
			this.label21.TabIndex = 19;
			this.label21.Text = "倒入月份";
			// 
			// txt22
			// 
			this.txt22.Location = new System.Drawing.Point(87, 15);
			this.txt22.Name = "txt22";
			this.txt22.Size = new System.Drawing.Size(64, 21);
			this.txt22.TabIndex = 21;
			this.txt22.Text = "";
			// 
			// txt23
			// 
			this.txt23.Location = new System.Drawing.Point(221, 15);
			this.txt23.Name = "txt23";
			this.txt23.Size = new System.Drawing.Size(64, 21);
			this.txt23.TabIndex = 22;
			this.txt23.Text = "";
			// 
			// btnGetSalary
			// 
			this.btnGetSalary.Location = new System.Drawing.Point(306, 15);
			this.btnGetSalary.Name = "btnGetSalary";
			this.btnGetSalary.Size = new System.Drawing.Size(93, 23);
			this.btnGetSalary.TabIndex = 23;
			this.btnGetSalary.Text = "倒入工资历史";
			this.btnGetSalary.Click += new System.EventHandler(this.btnGetSalary_Click);
			// 
			// btnCalSalary
			// 
			this.btnCalSalary.Location = new System.Drawing.Point(420, 15);
			this.btnCalSalary.Name = "btnCalSalary";
			this.btnCalSalary.Size = new System.Drawing.Size(93, 23);
			this.btnCalSalary.TabIndex = 24;
			this.btnCalSalary.Text = "计算当月工资";
			this.btnCalSalary.Click += new System.EventHandler(this.btnCalSalary_Click);
			// 
			// btnGiveSalary
			// 
			this.btnGiveSalary.Location = new System.Drawing.Point(534, 15);
			this.btnGiveSalary.Name = "btnGiveSalary";
			this.btnGiveSalary.TabIndex = 25;
			this.btnGiveSalary.Text = "工资发放";
			this.btnGiveSalary.Click += new System.EventHandler(this.btnGiveSalary_Click);
			// 
			// groupBox2
			// 
			this.groupBox2.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left) 
				| System.Windows.Forms.AnchorStyles.Right)));
			this.groupBox2.Controls.Add(this.label21);
			this.groupBox2.Controls.Add(this.txt22);
			this.groupBox2.Controls.Add(this.btnCalSalary);
			this.groupBox2.Controls.Add(this.btnGetSalary);
			this.groupBox2.Controls.Add(this.btnGiveSalary);
			this.groupBox2.Controls.Add(this.txt23);
			this.groupBox2.Controls.Add(this.label2);
			this.groupBox2.Location = new System.Drawing.Point(0, 41);
			this.groupBox2.Name = "groupBox2";
			this.groupBox2.Size = new System.Drawing.Size(640, 48);
			this.groupBox2.TabIndex = 21;
			this.groupBox2.TabStop = false;
			// 
			// dataGrid1
			// 
			this.dataGrid1.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) 
				| System.Windows.Forms.AnchorStyles.Left) 
				| System.Windows.Forms.AnchorStyles.Right)));
			this.dataGrid1.CaptionVisible = false;
			this.dataGrid1.DataMember = "";
			this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
			this.dataGrid1.Location = new System.Drawing.Point(0, 96);
			this.dataGrid1.Name = "dataGrid1";
			this.dataGrid1.Size = new System.Drawing.Size(640, 160);
			this.dataGrid1.TabIndex = 26;
			this.dataGrid1.CurrentCellChanged += new System.EventHandler(this.dataGrid1_CurrentCellChanged);
			// 
			// sqlDataAdapter1
			// 
			this.sqlDataAdapter1.SelectCommand = this.sqlSelectCommand1;
			this.sqlDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
																									  new System.Data.Common.DataTableMapping("Table", "职员基本信息表", new System.Data.Common.DataColumnMapping[] {
																																																				 new System.Data.Common.DataColumnMapping("姓名", "姓名"),
																																																				 new System.Data.Common.DataColumnMapping("日期", "日期"),
																																																				 new System.Data.Common.DataColumnMapping("应发金额合计", "应发金额合计"),
																																																				 new System.Data.Common.DataColumnMapping("应扣金额合计", "应扣金额合计"),
																																																				 new System.Data.Common.DataColumnMapping("工资合计", "工资合计"),
																																																				 new System.Data.Common.DataColumnMapping("个人所得税", "个人所得税"),
																																																				 new System.Data.Common.DataColumnMapping("实发金额", "实发金额"),
																																																				 new System.Data.Common.DataColumnMapping("发放否", "发放否"),
																																																				 new System.Data.Common.DataColumnMapping("职员编号", "职员编号"),
																																																				 new System.Data.Common.DataColumnMapping("Expr1", "Expr1")})});
			// 
			// sqlSelectCommand1
			// 
			this.sqlSelectCommand1.CommandText = "SELECT a.姓名, b.日期, b.应发金额合计, b.应扣金额合计, b.工资合计, b.个人所得税, b.实发金额, b.发放否, a.职员编号, b." +
				"职员编号 AS Expr1 FROM 职员基本信息表 a INNER JOIN 月工资统计表 b ON a.职员编号 = b.职员编号";
			this.sqlSelectCommand1.Connection = this.sqlConnection1;
			// 
			// sqlConnection1
			// 
			this.sqlConnection1.ConnectionString = "workstation id=localhost;Integrated Security=SSPI;Database=hrmbook;";
			// 
			// imageList1
			// 
			this.imageList1.ImageSize = new System.Drawing.Size(16, 16);
			this.imageList1.ImageStream = ((System.Windows.Forms.ImageListStreamer)(resources.GetObject("imageList1.ImageStream")));
			this.imageList1.TransparentColor = System.Drawing.Color.Transparent;
			// 
			// toolBar1
			// 
			this.toolBar1.Buttons.AddRange(new System.Windows.Forms.ToolBarButton[] {
																						this.toolBarFirst,
																						this.toolBarPre,
																						this.toolBarNext,
																						this.toolBarLast,
																						this.toolBarSubmit,
																						this.tbarBtnCancell,
																						this.toolBarQuit});
			this.toolBar1.DropDownArrows = true;
			this.toolBar1.ImageList = this.imageList1;
			this.toolBar1.Location = new System.Drawing.Point(0, 0);
			this.toolBar1.Name = "toolBar1";
			this.toolBar1.ShowToolTips = true;
			this.toolBar1.Size = new System.Drawing.Size(640, 41);
			this.toolBar1.TabIndex = 25;
			this.toolBar1.ButtonClick += new System.Windows.Forms.ToolBarButtonClickEventHandler(this.toolBar1_ButtonClick);
			// 
			// toolBarFirst
			// 
			this.toolBarFirst.ImageIndex = 0;
			this.toolBarFirst.Text = "首记录";
			this.toolBarFirst.ToolTipText = "首记录";
			// 
			// toolBarPre
			// 
			this.toolBarPre.ImageIndex = 1;
			this.toolBarPre.Text = "上一记录";
			this.toolBarPre.ToolTipText = "上一记录";
			// 
			// toolBarNext
			// 
			this.toolBarNext.ImageIndex = 2;
			this.toolBarNext.Text = "下一记录";
			this.toolBarNext.ToolTipText = "下一记录";
			// 
			// toolBarLast
			// 
			this.toolBarLast.ImageIndex = 3;
			this.toolBarLast.Text = "尾记录";
			this.toolBarLast.ToolTipText = "尾记录";
			// 
			// toolBarSubmit
			// 
			this.toolBarSubmit.ImageIndex = 4;
			this.toolBarSubmit.Text = "提交修改";
			this.toolBarSubmit.ToolTipText = "提交修改";
			// 
			// tbarBtnCancell
			// 
			this.tbarBtnCancell.ImageIndex = 5;
			this.tbarBtnCancell.Text = "取消修改";
			this.tbarBtnCancell.ToolTipText = "取消修改";
			// 
			// toolBarQuit
			// 
			this.toolBarQuit.ImageIndex = 6;
			this.toolBarQuit.Text = "退出";
			this.toolBarQuit.ToolTipText = "退出";
			// 
			// sqlDataAdapter2
			// 
			this.sqlDataAdapter2.DeleteCommand = this.sqlDeleteCommand1;
			this.sqlDataAdapter2.InsertCommand = this.sqlInsertCommand1;
			this.sqlDataAdapter2.SelectCommand = this.sqlSelectCommand2;
			this.sqlDataAdapter2.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {