?? 副本 addmemberform.cs
字號:
using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Data;
namespace KTMIS
{
/// <summary>
/// AddMember 的摘要說明。
/// </summary>
public class AddMember : System.Windows.Forms.Form
{
private System.Windows.Forms.Button returnBtn;
internal System.Windows.Forms.TextBox MemberCoTextBox;
internal System.Windows.Forms.Button add_updateMemberBtn;
private System.Windows.Forms.Label MemberSNPYlabel;
internal System.Windows.Forms.TextBox MemberSNtextBox;
private System.Windows.Forms.Label MemberSNlabel;
private SqlConnection MemberConnection = null;
private SqlCommand MemberCommand = null;
private SqlCommand CollegeCommand = null;
private ArrayList arrayList = null;
private string sqlString = null;
private System.Windows.Forms.ComboBox MemberNacomboBox;
private System.Windows.Forms.ComboBox CollegeCocomboBox;
internal System.Windows.Forms.TextBox CollegetextBox;
/// <summary>
/// 必需的設計器變量。
/// </summary>
private System.ComponentModel.Container components = null;
public AddMember()
{
//
// Windows 窗體設計器支持所必需的
//
InitializeComponent();
//
// TODO: 在 InitializeComponent 調用后添加任何構造函數代碼
//
}
/// <summary>
/// 清理所有正在使用的資源。
/// </summary>
protected override void Dispose( bool disposing )
{
if( disposing )
{
if(components != null)
{
components.Dispose();
}
}
base.Dispose( disposing );
}
#region Windows 窗體設計器生成的代碼
/// <summary>
/// 設計器支持所需的方法 - 不要使用代碼編輯器修改
/// 此方法的內容。
/// </summary>
private void InitializeComponent()
{
this.MemberCoTextBox = new System.Windows.Forms.TextBox();
this.returnBtn = new System.Windows.Forms.Button();
this.add_updateMemberBtn = new System.Windows.Forms.Button();
this.MemberSNPYlabel = new System.Windows.Forms.Label();
this.MemberSNtextBox = new System.Windows.Forms.TextBox();
this.MemberSNlabel = new System.Windows.Forms.Label();
this.MemberNacomboBox = new System.Windows.Forms.ComboBox();
this.CollegeCocomboBox = new System.Windows.Forms.ComboBox();
this.CollegetextBox = new System.Windows.Forms.TextBox();
this.SuspendLayout();
//
// MemberCoTextBox
//
this.MemberCoTextBox.Location = new System.Drawing.Point(488, 48);
this.MemberCoTextBox.Name = "MemberCoTextBox";
this.MemberCoTextBox.Size = new System.Drawing.Size(88, 30);
this.MemberCoTextBox.TabIndex = 26;
this.MemberCoTextBox.Text = "";
this.MemberCoTextBox.Visible = false;
//
// returnBtn
//
this.returnBtn.Location = new System.Drawing.Point(360, 248);
this.returnBtn.Name = "returnBtn";
this.returnBtn.Size = new System.Drawing.Size(144, 56);
this.returnBtn.TabIndex = 25;
this.returnBtn.Text = "返回";
this.returnBtn.Click += new System.EventHandler(this.returnBtn_Click);
//
// add_updateMemberBtn
//
this.add_updateMemberBtn.Location = new System.Drawing.Point(128, 248);
this.add_updateMemberBtn.Name = "add_updateMemberBtn";
this.add_updateMemberBtn.Size = new System.Drawing.Size(144, 56);
this.add_updateMemberBtn.TabIndex = 24;
this.add_updateMemberBtn.Text = "添加";
this.add_updateMemberBtn.Click += new System.EventHandler(this.add_updateMemberBtn_Click);
//
// MemberSNPYlabel
//
this.MemberSNPYlabel.Location = new System.Drawing.Point(40, 152);
this.MemberSNPYlabel.Name = "MemberSNPYlabel";
this.MemberSNPYlabel.Size = new System.Drawing.Size(224, 32);
this.MemberSNPYlabel.TabIndex = 22;
this.MemberSNPYlabel.Text = "請選擇成員所屬學院：";
//
// MemberSNtextBox
//
this.MemberSNtextBox.Location = new System.Drawing.Point(280, 48);
this.MemberSNtextBox.Name = "MemberSNtextBox";
this.MemberSNtextBox.Size = new System.Drawing.Size(200, 30);
this.MemberSNtextBox.TabIndex = 21;
this.MemberSNtextBox.Text = "";
//
// MemberSNlabel
//
this.MemberSNlabel.Location = new System.Drawing.Point(48, 47);
this.MemberSNlabel.Name = "MemberSNlabel";
this.MemberSNlabel.Size = new System.Drawing.Size(216, 40);
this.MemberSNlabel.TabIndex = 20;
this.MemberSNlabel.Text = "請輸入成員的性名：";
//
// MemberNacomboBox
//
this.MemberNacomboBox.Location = new System.Drawing.Point(280, 152);
this.MemberNacomboBox.Name = "MemberNacomboBox";
this.MemberNacomboBox.Size = new System.Drawing.Size(200, 28);
this.MemberNacomboBox.TabIndex = 27;
this.MemberNacomboBox.Text = "--請選擇--";
this.MemberNacomboBox.SelectedIndexChanged += new System.EventHandler(this.MemberNacomboBox_SelectedIndexChanged);
//
// CollegeCocomboBox
//
this.CollegeCocomboBox.Location = new System.Drawing.Point(488, 152);
this.CollegeCocomboBox.Name = "CollegeCocomboBox";
this.CollegeCocomboBox.Size = new System.Drawing.Size(128, 28);
this.CollegeCocomboBox.TabIndex = 28;
this.CollegeCocomboBox.Visible = false;
//
// CollegetextBox
//
this.CollegetextBox.Location = new System.Drawing.Point(488, 104);
this.CollegetextBox.Name = "CollegetextBox";
this.CollegetextBox.Size = new System.Drawing.Size(88, 30);
this.CollegetextBox.TabIndex = 29;
this.CollegetextBox.Text = "";
this.CollegetextBox.Visible = false;
//
// AddMember
//
this.AutoScaleBaseSize = new System.Drawing.Size(11, 23);
this.ClientSize = new System.Drawing.Size(616, 390);
this.Controls.Add(this.CollegetextBox);
this.Controls.Add(this.CollegeCocomboBox);
this.Controls.Add(this.MemberNacomboBox);
this.Controls.Add(this.MemberCoTextBox);
this.Controls.Add(this.returnBtn);
this.Controls.Add(this.add_updateMemberBtn);
this.Controls.Add(this.MemberSNPYlabel);
this.Controls.Add(this.MemberSNtextBox);
this.Controls.Add(this.MemberSNlabel);
this.Font = new System.Drawing.Font("宋體", 15F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.Name = "AddMember";
this.Text = "添加成員";
this.Load += new System.EventHandler(this.AddMember_Load);
this.ResumeLayout(false);
}
#endregion
private void add_updateMemberBtn_Click(object sender, System.EventArgs e)
{
//string connString = "user id=sa;data source=\".\";initial catalog=KTMIS";
//MemberConnection = new SqlConnection(connString);
if(add_updateMemberBtn.Text == "添加")
{
MemberCommand = new SqlCommand("InsertMember",MemberConnection);
MemberCommand.CommandType = CommandType.StoredProcedure;
MemberCommand.Parameters.Add("@MemberCo",SqlDbType.Int);
MemberCommand.Parameters.Add("@MemberNa",SqlDbType.VarChar,10);
MemberCommand.Parameters.Add("@CollegeCo",SqlDbType.Int);
MemberCommand.Parameters["@MemberCo"].Direction = System.Data.ParameterDirection.Output;
MemberCommand.Parameters["@MemberNa"].Value = MemberSNtextBox.Text.ToString().Trim();
MemberCommand.Parameters["@CollegeCo"].Value = Convert.ToInt16(CollegeCocomboBox.SelectedItem.ToString());
try
{
MemberConnection.Open();
MemberCommand.ExecuteNonQuery();
arrayList = new ArrayList();
arrayList.Add(MemberCommand.Parameters["@MemberCo"].Value);
arrayList.Add(MemberSNtextBox.Text.ToString().Trim());
arrayList.Add(CollegeCocomboBox.SelectedItem);
MessageBox.Show("添加成功！","系統提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
}
catch(Exception ex)
{
MessageBox.Show("添加失敗，原因是："+ex.ToString(),"系統提示",MessageBoxButtons.OK,MessageBoxIcon.Exclamation);
}
finally
{
MemberConnection.Close();
}
}
else if(add_updateMemberBtn.Text == "修改")
{
MemberCommand = new SqlCommand("UpdateMember",MemberConnection);
MemberCommand.CommandType = CommandType.StoredProcedure;
MemberCommand.Parameters.Add("@MemberCo",SqlDbType.Int);
MemberCommand.Parameters.Add("@MemberNa",SqlDbType.VarChar,10);
MemberCommand.Parameters.Add("@CollegeCo",SqlDbType.Int);
MemberCommand.Parameters["@MemberCo"].Value = Convert.ToInt16(MemberCoTextBox.Text.ToString().Trim());
MemberCommand.Parameters["@MemberNa"].Value = MemberSNtextBox.Text.ToString().Trim();
MemberCommand.Parameters["@CollegeCo"].Value = Convert.ToInt16(CollegeCocomboBox.SelectedItem.ToString());
try
{
MemberConnection.Open();
MemberCommand.ExecuteNonQuery();
MessageBox.Show("修改成功！","系統提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
}
catch(Exception ex)
{
MessageBox.Show("修改失敗，原因是："+ex.ToString(),"系統提示",MessageBoxButtons.OK,MessageBoxIcon.Exclamation);
}
finally
{
MemberConnection.Close();
}
}
}
private void returnBtn_Click(object sender, System.EventArgs e)
{
this.Close();
}
public ArrayList GetArrayList()
{
return arrayList;
}
public void SetMemberSNText(string text)
{
MemberSNtextBox.Text = text;
}
public void SetMemberCoText(string text)
{
MemberCoTextBox.Text = text;
}
public void SetFormTital(string tital)
{
this.Text = tital;
}
public void SetMemberBtnText(string text)
{
add_updateMemberBtn.Text = text;
}
public void SetMemberCollegeTextBoxText(string text)
{
CollegetextBox.Text = text;
}
private void AddMember_Load(object sender, System.EventArgs e)
{
string connString = "user id=sa;data source=\".\";initial catalog=KTMIS";
MemberConnection = new SqlConnection(connString);
sqlString = "select CollegeCo,CollegeNa from College";
CollegeCommand = new SqlCommand(sqlString,MemberConnection);
try
{
MemberConnection.Open();
SqlDataReader dr = CollegeCommand.ExecuteReader();
while(dr.Read())
{
CollegeCocomboBox.Items.Add(dr.GetValue(0).ToString());
MemberNacomboBox.Items.Add(dr.GetValue(1).ToString());
}
}
catch(Exception ex)
{
MessageBox.Show(" 讀取數據失敗！原因是"+ex.ToString(),"系統提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
return;
}
finally
{
MemberConnection.Close();
}
MemberNacomboBox.Items.Add("--新增--");
int index = -1;
for(int i=0;i<MemberNacomboBox.Items.Count;i++)
{
if(MemberNacomboBox.Items[i].ToString()==CollegetextBox.Text)
{
index = i;
}
}
MemberNacomboBox.SelectedIndex = index;
}
private void MemberNacomboBox_SelectedIndexChanged(object sender, System.EventArgs e)
{
if(MemberNacomboBox.SelectedIndex<MemberNacomboBox.Items.Count-1)
{
CollegeCocomboBox.SelectedIndex = MemberNacomboBox.SelectedIndex;
}
else
{
AddCollege ac = new AddCollege();
ac.ShowDialog();
Initial();
}
}
private void Initial()
{
MemberNacomboBox.Items.Clear();
CollegeCocomboBox.Items.Clear();
try
{
MemberConnection.Open();
SqlDataReader dr = CollegeCommand.ExecuteReader();
while(dr.Read())
{
CollegeCocomboBox.Items.Add(dr.GetValue(0).ToString());
MemberNacomboBox.Items.Add(dr.GetValue(1).ToString());
}
}
catch(Exception ex)
{
MessageBox.Show(" 讀取數據失敗！原因是"+ex.ToString(),"系統提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
}
finally
{
MemberConnection.Close();
}
MemberNacomboBox.Items.Add("--新增--");
}
public System.Data.SqlClient.SqlConnection Connection
{
set
{
this.MemberConnection = value;
}
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -