Example #1
0
        private void RunDeleteData()
        {
            My.MyDatabase MyDb = new My.MyDatabase();
            SIS.Configuration.ClsCompanyConfig CCC = new Configuration.ClsCompanyConfig();
            CCC.CompanyID         = txtCompanyID.Text;
            CCC.CNAME             = txtCNAME.Text;
            CCC.ENAME             = txtENAME.Text;
            CCC.UnifiedBusinessNo = mtbUnifiedBusinessNo.Text;

            SIS.DBClass.DBClassCompanyInfo DBCCI = new DBClass.DBClassCompanyInfo();

            if (MyDb.AuthPK(CCC.CompanyID, "CompanyID", "CompanyInfo") == true)
            {
                if (DBCCI.DeleteOneData(CCC.CompanyID))
                {
                    MessageBox.Show("刪除[" + CCC.CompanyID + "-" + CCC.CNAME +
                                    "]公司資料成功", "刪除公司資料", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    LoadDefaultValue();
                }
                else
                {
                    MessageBox.Show("刪除[" + CCC.CompanyID + "-" + CCC.CNAME +
                                    "]公司資料失敗", "刪除公司資料", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                }
            }
            else
            {
                MessageBox.Show("對不起,資料庫不存在[ " + CCC.CompanyID + "-" + CCC.CNAME +
                                " ]公司資料!!(資料不存在)", "資料刪除");
            }
        }
Example #2
0
        private void RunUpdateData()
        {
            My.MyDatabase MyDb = new My.MyDatabase();
            SIS.Configuration.ClsCompanyConfig CCC = new Configuration.ClsCompanyConfig();
            CCC.CompanyID         = txtCompanyID.Text;
            CCC.CNAME             = txtCNAME.Text;
            CCC.ENAME             = txtENAME.Text;
            CCC.UnifiedBusinessNo = mtbUnifiedBusinessNo.Text;
            CCC.CompanyType       = cboCompanyType.Text;
            CCC.Owner             = txtOwner.Text;
            CCC.Contact           = txtContact.Text;
            CCC.Phone             = mtbPhone.Text;
            CCC.MobilePhone       = mtbMobilePhone.Text;
            CCC.Fax     = mtbFax.Text;
            CCC.Address = txtAddress.Text;
            CCC.WebSite = txtWebSite.Text;
            CCC.Notes   = rtbNotes.Text;

            SIS.DBClass.DBClassCompanyInfo DBCCI = new DBClass.DBClassCompanyInfo();

            if (MyDb.AuthPK(CCC.CompanyID, "CompanyID", "CompanyInfo") == true)
            {
                if (DBCCI.Update(CCC))
                {
                    MessageBox.Show("更新[" + CCC.CompanyID + "-" + CCC.CNAME +
                                    "]公司資料成功", "更新公司資料", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    LoadDefaultValue();
                }
                else
                {
                    MessageBox.Show("更新[" + CCC.CompanyID + "-" + CCC.CNAME +
                                    "]公司資料失敗", "更新公司資料", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                }
            }
            else
            {
                MessageBox.Show("對不起,資料庫不存在[ " + CCC.CompanyID + "-" + CCC.CNAME +
                                " ]公司資料!!(資料不存在)", "資料更新");
            }
        }