private void RunDeleteData()
{
My.MyDatabase MyDb = new My.MyDatabase();
SIS.Configuration.ClsEmployeeConfig CEC = new Configuration.ClsEmployeeConfig();
CEC.EmployeeID = txtEmployeeID.Text;
CEC.CNAME = txtCNAME.Text;
SIS.DBClass.DBClassEmployeeInfo DBCEI = new DBClass.DBClassEmployeeInfo();
if (MyDb.AuthPK(CEC.EmployeeID, "EmployeeID", "EmployeeInfo") == true)
{
if (DBCEI.DeleteOneData(CEC.EmployeeID))
{
MessageBox.Show("刪除[" + CEC.EmployeeID + "-" + CEC.CNAME +
"]職員資料成功", "刪除職員資料", MessageBoxButtons.OK, MessageBoxIcon.Information);
LoadDefaultValue();
}
else
{
MessageBox.Show("刪除[" + CEC.EmployeeID + "-" + CEC.CNAME +
"]職員資料失敗", "刪除職員資料", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
else
{
MessageBox.Show("對不起，資料庫不存在[ " + CEC.EmployeeID + "-" + CEC.CNAME +
" ]職員資料!!(資料重複)", "資料刪除");
}
}
/// <summary>
/// 將資料寫入資料庫中
/// </summary>
private void RunInsertData()
{
My.MyDatabase MyDb = new My.MyDatabase();
SIS.Configuration.ClsEmployeeConfig CEC = new Configuration.ClsEmployeeConfig();
CEC.EmployeeID = txtEmployeeID.Text;
CEC.CNAME = txtCNAME.Text;
CEC.ENAME = txtENAME.Text;
string FilePath = Application.StartupPath + "\\Photos\\Employee\\" + "NoPicture.bmp";
CEC.Photos = My.MyFileIO.FileToByteArray(FilePath);
CEC.Sex = cboSex.Text;
CEC.Birthday = dtpBirthday.Value.ToString("yyyy年MM月dd日");
CEC.BooldType = cboBooldType.Text;
CEC.ID = mtbID.Text;
CEC.PresentAddress = txtPresentAddress.Text;
CEC.Professional = txtProfessional.Text;
CEC.HireDate = dtpHireDate.Value.ToString("yyyy年MM月dd日");
CEC.Positions = txtPosition.Text;
CEC.Background = txtBackground.Text;
CEC.Phone = mtbPhone.Text;
CEC.Status = cboStatus.Text;
SIS.DBClass.DBClassEmployeeInfo DBCEI = new DBClass.DBClassEmployeeInfo();
if (MyDb.AuthPK(CEC.EmployeeID, "EmployeeID", "EmployeeInfo") == false)
{
if (DBCEI.ParameterInsertData(CEC))
{
MessageBox.Show("新增[" + CEC.EmployeeID + "-" + CEC.CNAME +
"]職員資料成功", "新增職員資料", MessageBoxButtons.OK, MessageBoxIcon.Information);
LoadDefaultValue();
}
else
{
MessageBox.Show("新增[" + CEC.EmployeeID + "-" + CEC.CNAME +
"]職員資料失敗", "新增職員資料", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
else
{
MessageBox.Show("對不起，資料庫已存在[ " + CEC.EmployeeID + "-" + CEC.CNAME +
" ]職員資料!!(資料重複)", "資料新增");
}
}
private void RunUpdateData()
{
My.MyDatabase MyDb = new My.MyDatabase();
SIS.Configuration.ClsEmployeeConfig CEC = new Configuration.ClsEmployeeConfig();
CEC.EmployeeID = txtEmployeeID.Text;
CEC.CNAME = txtCNAME.Text;
CEC.ENAME = txtENAME.Text;
CEC.Photos = My.MyMethod.ImageToByte(PicPhotos.Image);
CEC.Sex = cboSex.Text;
CEC.Birthday = dtpBirthday.Value.ToString("yyyy年MM月dd日");
CEC.BooldType = cboBooldType.Text;
CEC.ID = mtbID.Text;
CEC.PresentAddress = txtPresentAddress.Text;
CEC.Professional = txtProfessional.Text;
CEC.HireDate = dtpHireDate.Value.ToString("yyyy年MM月dd日");
CEC.Positions = txtPosition.Text;
CEC.Background = txtBackground.Text;
CEC.Phone = mtbPhone.Text;
CEC.Status = cboStatus.Text;
SIS.DBClass.DBClassEmployeeInfo DBCEI = new DBClass.DBClassEmployeeInfo();
if (MyDb.AuthPK(CEC.EmployeeID, "EmployeeID", "EmployeeInfo") == true)
{
if (DBCEI.ParameterUpdateData(CEC))
{
MessageBox.Show("更新[" + CEC.EmployeeID + "-" + CEC.CNAME +
"]職員資料成功", "更新職員資料", MessageBoxButtons.OK, MessageBoxIcon.Information);
LoadDefaultValue();
}
else
{
MessageBox.Show("更新[" + CEC.EmployeeID + "-" + CEC.CNAME +
"]職員資料失敗", "更新職員資料", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
else
{
MessageBox.Show("對不起，資料庫不存在[ " + CEC.EmployeeID + "-" + CEC.CNAME +
" ]職員資料!!(資料不存在)", "資料更新");
}
}
/// <summary>
/// 更新資料庫內的圖片二進位資料
/// </summary>
/// <remarks></remarks>
public void UpdateImageIntoDB(string photoFilePath)
{
ArrayList arrList = new ArrayList();
arrList.Clear();
string FilePath = photoFilePath;
string EmployeeID = this.txtEmployeeID.Text;
//將圖片檔案轉換成二進位資料
byte[] Photos = My.MyFileIO.FileToByteArray(FilePath);
arrList.Insert(0, EmployeeID);
//職員編號
arrList.Insert(1, Photos);
//相片
SIS.DBClass.DBClassEmployeeInfo DBCEmployeeInfo = new DBClass.DBClassEmployeeInfo();
My.MyDatabase myDB = new My.MyDatabase();
if (myDB.AuthPK(EmployeeID, "EmployeeID", "EmployeeInfo") == true)
{
if (DBCEmployeeInfo.ParameterUpdateData(arrList))
{
MessageBox.Show("更新" + EmployeeID + "- 圖片資料成功", "更新職員資料", MessageBoxButtons.OK, MessageBoxIcon.Information);
LoadDefaultValue();
}
else
{
MessageBox.Show("更新" + EmployeeID + "-圖片資料失敗", "更新職員資料", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
else
{
MessageBox.Show("對不起，資料庫不存在 " + EmployeeID + "-職員資料!!", "圖片資料無法更新");
return;
}
}
