?? createbranch.cs
字號:
?using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace 人事管理
{
public partial class createbranch : Form
{
data da = new data();
public createbranch()
{
InitializeComponent();
}
private void label2_Click(object sender, EventArgs e)
{
}
private void createbranch_Load(object sender, EventArgs e)
{
}
//瀏覽員工
private void positonbtn_Click(object sender, EventArgs e)
{
selectboss sebo = new selectboss();
sebo.crbr = this;
sebo.ShowDialog();
}
//確定
private void yesbtn_Click(object sender, EventArgs e)
{
DataSet ds1 = new DataSet();
SqlDataAdapter sqlda1 = new SqlDataAdapter("SELECT branchnumname from branchnum where branchnumname='" + branchnametxt.Text + "'", da.link());
sqlda1.Fill(ds1, "branchnum1");
if (ds1.Tables["branchnum1"].Rows.Count > 0)
{
MessageBox.Show("同名部門已存在!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
if (mangernametxt.Text.Trim() == "")
{
MessageBox.Show("創建部門失敗!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
DataSet ds = new DataSet();
SqlDataAdapter sqlda = new SqlDataAdapter("SELECT dbo.Worker.WorkerID FROM dbo.branchnum iNNER JOIN dbo.Worker ON dbo.branchnum.branchnumID = dbo.Worker.branchnumID where Worker.WorkerName='" + mangernametxt.Text + "'", da.link());
sqlda.Fill(ds, "selectworkid");
//添加
SqlCommand sqlcomm = new SqlCommand("insert branchnum (branchnumname,branchnumdepict,branchnummanegerID) values(@branchnumname,@branchnumdepict," + ds.Tables["selectworkid"].Rows[0][0] + ")", da.link());
sqlcomm.Parameters.AddWithValue("@branchnumname", branchnametxt.Text);
sqlcomm.Parameters.AddWithValue("@branchnumdepict", miantxt.Text);
//sqlcomm.Parameters.AddWithValue("@branchnummanegerID",Convert.ToInt32(mangernametxt.Text));
sqlda.InsertCommand = sqlcomm;
sqlda.InsertCommand.ExecuteNonQuery();
this.Close();
}
}
}
//取消
private void outbtn_Click(object sender, EventArgs e)
{
DialogResult sss = MessageBox.Show("請確認要退出!", "請確認要退出!", MessageBoxButtons.YesNo);
if (sss == DialogResult.Yes)
{
this.Close();
}
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -