/// <summary> /// 將角色編號轉換成角色名稱 /// </summary> /// <param name="UserId">使用者帳號</param> /// <returns></returns> public string RoleIdToRoleName(string UserId) { InitDB(); string selectCmd; string RoleId = ""; selectCmd = "Select * From " + TableName + " Where UserId='" + UserId + "'"; try { cmd = new SqlCommand(selectCmd, conn); dr = cmd.ExecuteReader(); if (dr.Read()) { RoleId = dr["RoleId"].ToString(); conn.Close(); My.MyDatabase MyDB = new My.MyDatabase(); return(MyDB.GetTableFieldData("SysRole", "RoleId", RoleId, "RoleName")); } else { conn.Close(); return("error"); } } catch (Exception ex) { errorMsg = ex.Message; conn.Close(); return(ex.Message.ToString()); } }
private void RunDeleteData() { try { My.MyDatabase MyDb = new My.MyDatabase(); SIS.Configuration.ClsPurchaseConfig CPC = new Configuration.ClsPurchaseConfig(); CPC.PurchaseID = txtPurchaseID.Text; SIS.DBClass.DBClassPurchaseMaster DBCPM = new DBClass.DBClassPurchaseMaster(); if (MyDb.AuthPK(CPC.PurchaseID, "PurchaseID", "PurchaseMaster") == true) { if (DBCPM.DeleteMasterDetailsData(CPC.PurchaseID)) { MessageBox.Show("刪除[" + CPC.PurchaseID + "]採購單資料成功", "刪除採購單資料", MessageBoxButtons.OK, MessageBoxIcon.Information); LoadDefaultValue(); } else { MessageBox.Show("刪除[" + CPC.PurchaseID + "]採購單資料失敗", "刪除採購單資料", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } else { MessageBox.Show("對不起,資料庫不存在[ " + CPC.PurchaseID + " ]採購單資料!!(資料不存在)", "資料刪除"); } } catch (Exception ex) { MessageBox.Show("錯誤訊息:" + ex.Message.ToString(), "發生例外"); } }
/// <summary> /// 刪除資料庫的某一筆資料 /// </summary> private void RunDeleteData() { My.MyDatabase MyDb = new My.MyDatabase(); SIS.Configuration.ClsManufacturerConfig CMC = new Configuration.ClsManufacturerConfig(); CMC.ManufacturerID = txtManufacturerID.Text; CMC.CNAME = txtCNAME.Text; CMC.ENAME = txtENAME.Text; CMC.UnifiedBusinessNo = mtbUnifiedBusinessNo.Text; SIS.DBClass.DBClassManufacturerInfo DBCMI = new DBClass.DBClassManufacturerInfo(); if (MyDb.AuthPK(CMC.ManufacturerID, "ManufacturerID", "ManufacturerInfo") == true) { if (DBCMI.DeleteOneData(CMC.ManufacturerID)) { MessageBox.Show("刪除[" + CMC.ManufacturerID + "-" + CMC.CNAME + "]公司資料成功", "刪除廠商資料", MessageBoxButtons.OK, MessageBoxIcon.Information); LoadDefaultValue(); } else { MessageBox.Show("刪除[" + CMC.ManufacturerID + "-" + CMC.CNAME + "]公司資料失敗", "刪除廠商資料", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } else { MessageBox.Show("對不起,資料庫不存在[ " + CMC.ManufacturerID + "-" + CMC.CNAME + " ]廠商資料!!(資料不存在)", "資料刪除"); } }
private void RunDeleteData() { try { My.MyDatabase MyDb = new My.MyDatabase(); SIS.Configuration.ClsReversalConfig CRC = new Configuration.ClsReversalConfig(); CRC.ReversalID = txtReversalID.Text; SIS.DBClass.DBClassReversal DBCR = new DBClass.DBClassReversal(); if (MyDb.AuthPK(CRC.ReversalID, "ReversalID", "Reversal") == true) { if (DBCR.DeleteOneData(CRC.ReversalID)) { MessageBox.Show("刪除[" + CRC.ReversalID + "]沖銷單資料成功", "刪除沖銷單資料", MessageBoxButtons.OK, MessageBoxIcon.Information); LoadDefaultValue(); } else { MessageBox.Show("刪除[" + CRC.ReversalID + "]沖銷單資料失敗", "刪除沖銷單資料", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } else { MessageBox.Show("對不起,資料庫不存在[ " + CRC.ReversalID + " ]沖銷單資料!!(資料不存在)", "資料刪除"); } } catch (Exception ex) { MessageBox.Show("錯誤訊息:" + ex.Message.ToString(), "發生例外"); } }
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> /// 將TreeView權限內容寫入資料庫中 /// </summary> /// <param name="TNs">傳入節點集合例如:TreeView1.Nodes</param> private void TreeViewNodesAuthorityToDB(TreeNodeCollection TNs) { SIS.DBClass.DBClsSysUserAuthority DbSUA = new SIS.DBClass.DBClsSysUserAuthority(); My.MyDatabase MyDb = new My.MyDatabase(); if (TNs.Count != 0) { foreach (TreeNode TN in TNs) { if (MyDb.AuthPK(tSSL_UserId.Text, "UserId", TN.Tag.ToString(), "FuncId", "SysUserAuthority")) { DbSUA.UpdateAuthStatus(tSSL_UserId.Text, TN.Tag.ToString(), TN.Checked); } else { DbSUA.InsertData(tSSL_UserId.Text, TN.Tag.ToString(), TN.Checked); } if (TN.Nodes.Count > 0) { TreeViewNodesAuthorityToDB(TN.Nodes); } } } }
private void RunDeleteData(SIS.Configuration.Items[] OldItems) { try { My.MyDatabase MyDb = new My.MyDatabase(); SIS.Configuration.ClsShipConfig CSC = new Configuration.ClsShipConfig(); CSC.ShipID = txtShipID.Text; SIS.DBClass.DBClassShipMaster DBCSM = new DBClass.DBClassShipMaster(); if (MyDb.AuthPK(CSC.ShipID, "ShipID", "ShipMaster") == true) { if (DBCSM.DeleteMasterDetailsData(CSC.ShipID, OldItems)) { MessageBox.Show("刪除[" + CSC.ShipID + "]出貨單資料成功", "刪除出貨單資料", MessageBoxButtons.OK, MessageBoxIcon.Information); LoadDefaultValue(); } else { MessageBox.Show("刪除[" + CSC.ShipID + "]出貨單資料失敗", "刪除出貨單資料", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } else { MessageBox.Show("對不起,資料庫不存在[ " + CSC.ShipID + " ]出貨單資料!!(資料不存在)", "資料刪除"); } } catch (Exception ex) { MessageBox.Show("錯誤訊息:" + ex.Message.ToString(), "發生例外"); } }
private void RunDeleteData() { My.MyDatabase MyDb = new My.MyDatabase(); SIS.Configuration.ClsItemsConfig CIC = new Configuration.ClsItemsConfig(); CIC.ItemsID = txtItemsID.Text; CIC.NAME = txtNAME.Text; SIS.DBClass.DBClassItemsInfo DBCII = new DBClass.DBClassItemsInfo(); if (MyDb.AuthPK(CIC.ItemsID, "ItemsID", "ItemsInfo") == true) { if (DBCII.DeleteOneData(CIC.ItemsID)) { MessageBox.Show("刪除[" + CIC.ItemsID + "-" + CIC.NAME + "]商品資料成功", "刪除商品資料", MessageBoxButtons.OK, MessageBoxIcon.Information); LoadDefaultValue(); } else { MessageBox.Show("刪除[" + CIC.ItemsID + "-" + CIC.NAME + "]商品資料失敗", "刪除商品資料", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } else { MessageBox.Show("對不起,資料庫不存在[ " + CIC.ItemsID + "-" + CIC.NAME + " ]商品資料!!(資料不存在)", "資料刪除"); } }
private void cboPurchaseStaff_SelectedIndexChanged(object sender, EventArgs e) { if (cboPurchaseStaff.Text != "") { string EmployeeID = cboPurchaseStaff.Text.Split('-')[0]; My.MyDatabase myDB = new My.MyDatabase(); mtbPurchasePhone.Text = myDB.GetTableFieldData("EmployeeInfo", "EmployeeID", EmployeeID, "Phone"); } }
/// <summary> /// 載入表單控制項相關預設值 /// </summary> public void LoadDefaultValue() { string SQLCommand = "Select A1.ItemsID ,A1.Name,A1.ItemsType , A1.Specifications,A1.ItemsUnit,A1.SellingPrice,A1.CostPrice,A1.MSRP, (A1.ManufacturerID + '-' + A2.CNAME) as Manufacturer , A1.Inventory , A1.SafeInventory , A1.Notes " + "from ItemsInfo A1 INNER JOIN ManufacturerInfo A2 On A1.ManufacturerID = A2.ManufacturerID order by A1.ItemsID "; My.MyDatabase MyDb = new My.MyDatabase(); DataView DV = MyDb.CreateDataView(SQLCommand, "ItemsInfo"); this.dgvItemsInfo.DataSource = DV; //dataGridView表頭名稱中文化 dgvItemsInfo.Columns[0].HeaderText = "商品編號"; dgvItemsInfo.Columns[1].HeaderText = "商品名稱"; dgvItemsInfo.Columns[2].HeaderText = "商品類別"; dgvItemsInfo.Columns[3].HeaderText = "商品規格"; dgvItemsInfo.Columns[4].HeaderText = "基本單位"; dgvItemsInfo.Columns[5].HeaderText = "出貨價格"; dgvItemsInfo.Columns[6].HeaderText = "進貨價格"; dgvItemsInfo.Columns[7].HeaderText = "建議售價"; dgvItemsInfo.Columns[8].HeaderText = "進貨廠商"; dgvItemsInfo.Columns[9].HeaderText = "庫存量"; dgvItemsInfo.Columns[10].HeaderText = "安全庫存量"; dgvItemsInfo.Columns[11].HeaderText = "備註"; tsslDataCount.Text = DV.Count.ToString(); //凍結 中文名稱 欄位 this.dgvItemsInfo.Columns["NAME"].Frozen = true; //設定點選任一儲存格變選取所屬資料列的所有資料 this.dgvItemsInfo.SelectionMode = DataGridViewSelectionMode.FullRowSelect; //替代資料列樣式 this.dgvItemsInfo.RowsDefaultCellStyle.BackColor = Color.AliceBlue; this.dgvItemsInfo.AlternatingRowsDefaultCellStyle.BackColor = Color.Ivory; //自動調整資料列與資料行的高度與寬度 this.dgvItemsInfo.AutoResizeColumns(); this.dgvItemsInfo.AutoResizeRows(); //防止在 DataGridView 控制項中新增和刪除資料列 this.dgvItemsInfo.AllowUserToAddRows = false; this.dgvItemsInfo.AllowUserToDeleteRows = false; //列標頭依據顯示內容自動調整大小 this.dgvItemsInfo.AutoResizeRowHeadersWidth(DataGridViewRowHeadersWidthSizeMode.AutoSizeToAllHeaders); toolTip1.SetToolTip(txtItemsID, "請輸入[商品編號]!"); toolTip1.SetToolTip(txtNAME, "請輸入公司[商品名稱]!"); tsbAddNew.ToolTipText = "按下[新增]鈕,以進行商品新增動作!"; tsbUpdate.ToolTipText = "按下[更改]鈕,以進行商品更改動作!"; tsbDelete.ToolTipText = "按下[刪除]鈕,以進行商品刪除動作!"; tsbClear.ToolTipText = "按下[清除]鈕,以進行輸入欄位資料清除動作!"; tsbExit.ToolTipText = "按下[離開]鈕,會將本表單進行關閉!"; }
private void cboCustomer_SelectedIndexChanged(object sender, EventArgs e) { if (cboCustomer.Text != "") { string CustomerID = cboCustomer.Text.Split('-')[0]; My.MyDatabase myDB = new My.MyDatabase(); mtbPhone.Text = myDB.GetTableFieldData("CustomerInfo", "CustomerID", CustomerID, "Phone"); txtAddress.Text = myDB.GetTableFieldData("CustomerInfo", "CustomerID", CustomerID, "Address"); } }
/// <summary> /// 載入表單控制項相關預設值 /// </summary> public void LoadDefaultValue() { string SQLCommand = "Select * from EmployeeInfo order by EmployeeID "; My.MyDatabase MyDb = new My.MyDatabase(); DataView DV = MyDb.CreateDataView(SQLCommand, "EmployeeInfo"); this.dgvEmployeeInfo.DataSource = DV; //dataGridView表頭名稱中文化 dgvEmployeeInfo.Columns[0].HeaderText = "職員編號"; dgvEmployeeInfo.Columns[1].HeaderText = "中文名稱"; dgvEmployeeInfo.Columns[2].HeaderText = "英文名稱"; dgvEmployeeInfo.Columns[3].HeaderText = "相片"; dgvEmployeeInfo.Columns[4].HeaderText = "性別"; dgvEmployeeInfo.Columns[5].HeaderText = "生日"; dgvEmployeeInfo.Columns[6].HeaderText = "血型"; dgvEmployeeInfo.Columns[7].HeaderText = "身分證字號"; dgvEmployeeInfo.Columns[8].HeaderText = "通訊地址"; dgvEmployeeInfo.Columns[9].HeaderText = "專長"; dgvEmployeeInfo.Columns[10].HeaderText = "到職日期"; dgvEmployeeInfo.Columns[11].HeaderText = "職稱"; dgvEmployeeInfo.Columns[12].HeaderText = "最高學歷"; dgvEmployeeInfo.Columns[13].HeaderText = "電話"; dgvEmployeeInfo.Columns[14].HeaderText = "在職狀態"; tsslDataCount.Text = DV.Count.ToString(); //凍結 中文名稱 欄位 this.dgvEmployeeInfo.Columns["CNAME"].Frozen = true; //設定點選任一儲存格變選取所屬資料列的所有資料 this.dgvEmployeeInfo.SelectionMode = DataGridViewSelectionMode.FullRowSelect; //替代資料列樣式 this.dgvEmployeeInfo.RowsDefaultCellStyle.BackColor = Color.AliceBlue; this.dgvEmployeeInfo.AlternatingRowsDefaultCellStyle.BackColor = Color.Ivory; //自動調整資料列與資料行的高度與寬度 this.dgvEmployeeInfo.AutoResizeColumns(); //this.dgvEmployeeInfo.AutoResizeRows(); //防止在 DataGridView 控制項中新增和刪除資料列 this.dgvEmployeeInfo.AllowUserToAddRows = false; this.dgvEmployeeInfo.AllowUserToDeleteRows = false; toolTip1.SetToolTip(txtEmployeeID, "請輸入[職員編號]!"); toolTip1.SetToolTip(txtCNAME, "請輸入職員[中文名稱]!"); tsbAddNew.ToolTipText = "按下[新增]鈕,以進行職員新增動作!"; tsbUpdate.ToolTipText = "按下[更改]鈕,以進行職員更改動作!"; tsbDelete.ToolTipText = "按下[刪除]鈕,以進行職員刪除動作!"; tsbClear.ToolTipText = "按下[清除]鈕,以進行輸入欄位資料清除動作!"; tsbExit.ToolTipText = "按下[離開]鈕,會將本表單進行關閉!"; }
private void RunUpdateData() { try { My.MyDatabase MyDb = new My.MyDatabase(); SIS.Configuration.ClsReversalConfig CRC = new Configuration.ClsReversalConfig(); CRC.ReversalID = txtReversalID.Text; CRC.ReversalDate = dtpReversalDate.Value.ToString("yyyy年MM月dd日"); CRC.ReversalStaff = cboReversalStaff.Text; if (rdoReversalShip.Checked == true) { CRC.ReversalType = "Customer"; } else { CRC.ReversalType = "Manufacturer"; } CRC.CustomerOrManufacturer = txtCustomerOrManufacturer.Text; CRC.StockIDOrShipID = txtStockIDOrShipID.Text; CRC.PaymentAmount = int.Parse(txtPaymentAmount.Text); CRC.ReversalAmount = int.Parse(mtbReversalAmount.Text); CRC.IsReversal = cbxIsReversal.Checked; CRC.PaymentType = cboPaymentType.Text.Split('-')[1]; CRC.Notes = rtbNotes.Text.Replace("'", "''"); SIS.DBClass.DBClassReversal DBCR = new DBClass.DBClassReversal(); if (MyDb.AuthPK(CRC.ReversalID, "ReversalID", "Reversal") == true) { if (DBCR.Update(CRC)) { MessageBox.Show("更新[" + CRC.ReversalID + "]沖銷單資料成功", "更新沖銷單資料", MessageBoxButtons.OK, MessageBoxIcon.Information); LoadDefaultValue(); } else { MessageBox.Show("更新[" + CRC.ReversalID + "]沖銷單資料失敗", "更新沖銷單資料", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } else { MessageBox.Show("對不起,資料庫不存在[ " + CRC.ReversalID + " ]沖銷單資料!!(資料不存在)", "資料更新"); } } catch (Exception ex) { MessageBox.Show("錯誤訊息:" + ex.Message.ToString(), "發生例外"); } }
/// <summary> /// 載入表單控制項相關預設值 /// </summary> public void LoadDefaultValue() { string SQLCommand = "Select * from CompanyInfo order by CompanyID "; My.MyDatabase MyDb = new My.MyDatabase(); DataView DV = MyDb.CreateDataView(SQLCommand, "CompanyInfo"); this.dgvCompanyInfo.DataSource = DV; //dataGridView表頭名稱中文化 dgvCompanyInfo.Columns[0].HeaderText = "公司編號"; dgvCompanyInfo.Columns[1].HeaderText = "中文名稱"; dgvCompanyInfo.Columns[2].HeaderText = "英文名稱"; dgvCompanyInfo.Columns[3].HeaderText = "統一編號"; dgvCompanyInfo.Columns[4].HeaderText = "公司類型"; dgvCompanyInfo.Columns[5].HeaderText = "負責人"; dgvCompanyInfo.Columns[6].HeaderText = "聯絡人"; dgvCompanyInfo.Columns[7].HeaderText = "公司電話"; dgvCompanyInfo.Columns[8].HeaderText = "聯絡人手機"; dgvCompanyInfo.Columns[9].HeaderText = "公司傳真"; dgvCompanyInfo.Columns[10].HeaderText = "公司地址"; dgvCompanyInfo.Columns[11].HeaderText = "網站"; dgvCompanyInfo.Columns[12].HeaderText = "備註"; tsslDataCount.Text = DV.Count.ToString(); //凍結 中文名稱 欄位 this.dgvCompanyInfo.Columns["CNAME"].Frozen = true; //設定點選任一儲存格變選取所屬資料列的所有資料 this.dgvCompanyInfo.SelectionMode = DataGridViewSelectionMode.FullRowSelect; //替代資料列樣式 this.dgvCompanyInfo.RowsDefaultCellStyle.BackColor = Color.AliceBlue; this.dgvCompanyInfo.AlternatingRowsDefaultCellStyle.BackColor = Color.Ivory; //自動調整資料列與資料行的高度與寬度 this.dgvCompanyInfo.AutoResizeColumns(); this.dgvCompanyInfo.AutoResizeRows(); //防止在 DataGridView 控制項中新增和刪除資料列 this.dgvCompanyInfo.AllowUserToAddRows = false; this.dgvCompanyInfo.AllowUserToDeleteRows = false; toolTip1.SetToolTip(txtCompanyID, "請輸入[公司編號]!"); toolTip1.SetToolTip(txtCNAME, "請輸入公司[中文名稱]!"); tsbAddNew.ToolTipText = "按下[新增]鈕,以進行公司新增動作!"; tsbUpdate.ToolTipText = "按下[更改]鈕,以進行公司更改動作!"; tsbDelete.ToolTipText = "按下[刪除]鈕,以進行公司刪除動作!"; tsbClear.ToolTipText = "按下[清除]鈕,以進行輸入欄位資料清除動作!"; tsbExit.ToolTipText = "按下[離開]鈕,會將本表單進行關閉!"; }
/// <summary> /// 將資料寫入資料庫中 /// </summary> private void RunInsertData() { try { My.MyDatabase MyDb = new My.MyDatabase(); SIS.Configuration.ClsPurchaseConfig CPC = new Configuration.ClsPurchaseConfig(); CPC.PurchaseID = txtPurchaseID.Text; CPC.PurchaseDate = dtpPurchaseDate.Value.ToString("yyyy年MM月dd日"); CPC.DeliveryDate = dtpDeliveryDate.Value.ToString("yyyy年MM月dd日"); CPC.ManufacturerID = cboManufacturer.Text.Substring(0, cboManufacturer.Text.IndexOf("-")); CPC.PurchaseStaff = cboPurchaseStaff.Text; CPC.PurchasePhone = mtbPurchasePhone.Text; CPC.DeliveryAddress = cboDeliveryAddress.Text; CPC.PaymentType = cboPaymentType.Text.Split('-')[1]; CPC.BusinessTaxStockTaxRate = int.Parse(txtBusinessTaxStockTaxRate.Text); CPC.TotalPreTax = int.Parse(txtTotalPreTax.Text); CPC.Tax = int.Parse(txtTax.Text); CPC.TotalAfterTax = int.Parse(txtTotalAfterTax.Text); CPC.Notes = rtbNotes.Text.Replace("'", "''"); CPC.PurchaseItems = getItemsValueFromDataGridView(dgvPurchaseDetails); //SIS.DBClass.DBClassPurchaseMaster DBCPM = new DBClass.DBClassPurchaseMaster(); //實作工廠模式(Factory Pattern) var Processor = SIS.Configuration.SISProcessorFactory.getInstance(SIS.Configuration.SISOperating.Purchase); if (MyDb.AuthPK(CPC.PurchaseID, "PurchaseID", "PurchaseMaster") == false) { if (Processor.Insert(CPC)) //DBCPM.InsertData(CPC) { MessageBox.Show("新增[" + CPC.PurchaseID + "]採購單資料成功", "新增採購單資料", MessageBoxButtons.OK, MessageBoxIcon.Information); LoadDefaultValue(); } else { MessageBox.Show("新增[" + CPC.PurchaseID + "]採購單資料失敗", "新增採購單資料", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } else { MessageBox.Show("對不起,資料庫已存在[ " + CPC.PurchaseID + " ]採購單資料!!(資料重複)", "資料新增"); } } catch (Exception ex) { MessageBox.Show("錯誤訊息:" + ex.Message.ToString(), "發生例外"); } }
/// <summary> /// 更新資料庫中的相關資料 /// </summary> private void RunUpdateData(SIS.Configuration.Items[] OldItems) { try { My.MyDatabase MyDb = new My.MyDatabase(); SIS.Configuration.ClsRMAConfig CRC = new Configuration.ClsRMAConfig(); CRC.RMAID = txtRMAID.Text; CRC.RMADate = dtpRMADate.Value.ToString("yyyy年MM月dd日"); CRC.RMAType = RMAType; CRC.TotalPreTax = int.Parse(txtTotalPreTax.Text); CRC.Tax = int.Parse(txtTax.Text); CRC.TotalAfterTax = int.Parse(txtTotalAfterTax.Text); CRC.StockIDOrShipID = txtStockIDOrShipID.Text; CRC.BusinessTax = int.Parse(txtBusinessTax.Text); CRC.AmountPaid = int.Parse(mtbAmountPaid.Text); CRC.UnpaidAmount = int.Parse(txtUnpaidAmount.Text); CRC.RMAAmount = int.Parse(mtbRMAAmount.Text); CRC.Staff = cboStaff.Text; CRC.PaymentType = cboPaymentType.Text.Split('-')[1]; CRC.Notes = rtbNotes.Text.Replace("'", "''"); CRC.RMAItems = getItemsValueFromDataGridView(dgvRMADetails); SIS.DBClass.DBClassRMAMaster DBCRM = new DBClass.DBClassRMAMaster(); if (MyDb.AuthPK(CRC.RMAID, "RMAID", "RMAMaster") == true) { if (DBCRM.Update(CRC, OldItems)) { MessageBox.Show("更新[" + CRC.RMAID + "]退貨單資料成功", "更新退貨單資料", MessageBoxButtons.OK, MessageBoxIcon.Information); LoadDefaultValue(); } else { MessageBox.Show("更新[" + CRC.RMAID + "]退貨單資料失敗", "更新退貨單資料", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } else { MessageBox.Show("對不起,資料庫不存在[ " + CRC.RMAID + " ]退貨單資料!!(資料不存在)", "資料更新"); } } catch (Exception ex) { MessageBox.Show("錯誤訊息:" + ex.Message.ToString(), "發生例外"); } }
/// <summary> /// 加入事件資料於資料庫中 /// </summary> /// <param name="UserId">使用者編號</param> /// <param name="EventType">事件類型,包含:資訊,錯誤,警告,危險等四種</param> /// <param name="Action">對系統所執行動作</param> /// <param name="Details">動作詳細描述</param> public bool AddEventData(string UserId, string EventType, string Actions, string Details) { ArrayList arrList = new ArrayList(); string EventId; //事件編號 string EventTime; //事件觸發時間 bool IsInsertOK = false; //用來存放bool值,作為判斷新增資料是否成功 EventId = My.MyMethod.RunID("EV"); EventTime = DateTime.Now.ToString("yyyy年MM月dd日 HH:mm:ss"); arrList.Clear(); arrList.Insert(0, EventId); arrList.Insert(1, EventTime); arrList.Insert(2, EventType); arrList.Insert(3, UserId); arrList.Insert(4, Actions); arrList.Insert(5, Details); My.MyDatabase MyDB = new My.MyDatabase(); //檢查要插入的資料其主鍵值(Primary Key)是否有重複,若有重複則會回傳True if (MyDB.AuthPK(EventId, "EventId", "WinApEvents")) { //MessageBox.Show("資料已經存在,請重新送出填寫表單!!", "主鍵值驗證失敗"); return(false); } else { IsInsertOK = InsertData(arrList); //呼叫InsertData方法來進行資料新增動作 if (IsInsertOK) { //MessageBox.Show("資料新增成功!!", "資料新增"); return(true); } else { //MessageBox.Show("資料新增失敗!!", "資料新增"); return(false); } } }
private void RunUpdateData(SIS.Configuration.Items[] OldItems) { try { My.MyDatabase MyDb = new My.MyDatabase(); SIS.Configuration.ClsShipConfig CSC = new Configuration.ClsShipConfig(); CSC.ShipID = txtShipID.Text; CSC.ShipDate = dtpShipDate.Value.ToString("yyyy年MM月dd日"); CSC.TotalPreTax = int.Parse(txtTotalPreTax.Text); CSC.Tax = int.Parse(txtTax.Text); CSC.TotalAfterTax = int.Parse(txtTotalAfterTax.Text); CSC.CustomerID = cboCustomer.Text.Substring(0, cboCustomer.Text.IndexOf("-")); CSC.BusinessTaxShipTaxRate = int.Parse(txtBusinessTaxShipTaxRate.Text); CSC.AmountPaid = int.Parse(mtbAmountPaid.Text); CSC.UnpaidAmount = int.Parse(txtUnpaidAmount.Text); CSC.ShipStaff = cboShipStaff.Text; CSC.PaymentType = cboPaymentType.Text.Split('-')[1]; CSC.Notes = rtbNotes.Text.Replace("'", "''"); CSC.ShipItems = getItemsValueFromDataGridView(dgvShipDetails); SIS.DBClass.DBClassShipMaster DBCSM = new DBClass.DBClassShipMaster(); if (MyDb.AuthPK(CSC.ShipID, "ShipID", "ShipMaster") == true) { if (DBCSM.Update(CSC, OldItems)) { MessageBox.Show("更新[" + CSC.ShipID + "]出貨單資料成功", "更新出貨單資料", MessageBoxButtons.OK, MessageBoxIcon.Information); LoadDefaultValue(); } else { MessageBox.Show("更新[" + CSC.ShipID + "]出貨單資料失敗", "更新出貨單資料", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } else { MessageBox.Show("對不起,資料庫不存在[ " + CSC.ShipID + " ]出貨單資料!!(資料不存在)", "資料更新"); } } catch (Exception ex) { MessageBox.Show("錯誤訊息:" + ex.Message.ToString(), "發生例外"); } }
/// <summary> /// 將資料寫入資料庫中 /// </summary> private void RunInsertData() { try { My.MyDatabase MyDb = new My.MyDatabase(); SIS.Configuration.ClsStockConfig CSC = new Configuration.ClsStockConfig(); CSC.StockID = txtStockID.Text; CSC.StockDate = dtpStockDate.Value.ToString("yyyy年MM月dd日"); CSC.TotalPreTax = int.Parse(txtTotalPreTax.Text); CSC.Tax = int.Parse(txtTax.Text); CSC.TotalAfterTax = int.Parse(txtTotalAfterTax.Text); CSC.ManufacturerID = cboManufacturer.Text.Substring(0, cboManufacturer.Text.IndexOf("-")); CSC.BusinessTaxStockTaxRate = int.Parse(txtBusinessTaxStockTaxRate.Text); CSC.AmountPaid = int.Parse(mtbAmountPaid.Text); CSC.UnpaidAmount = int.Parse(txtUnpaidAmount.Text); CSC.StockStaff = cboStockStaff.Text; CSC.PaymentType = cboPaymentType.Text.Split('-')[1]; CSC.Notes = rtbNotes.Text.Replace("'", "''"); CSC.StockItems = getItemsValueFromDataGridView(dgvStockDetails); SIS.DBClass.DBClassStockMaster DBCSM = new DBClass.DBClassStockMaster(); if (MyDb.AuthPK(CSC.StockID, "StockID", "StockMaster") == false) { if (DBCSM.InsertData(CSC)) { MessageBox.Show("新增[" + CSC.StockID + "]進貨單資料成功", "新增進貨單資料", MessageBoxButtons.OK, MessageBoxIcon.Information); LoadDefaultValue(); } else { MessageBox.Show("新增[" + CSC.StockID + "]進貨單資料失敗", "新增進貨單資料", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } else { MessageBox.Show("對不起,資料庫已存在[ " + CSC.StockID + " ]進貨單資料!!(資料重複)", "資料新增"); } } catch (Exception ex) { MessageBox.Show("錯誤訊息:" + ex.Message.ToString(), "發生例外"); } }
/// <summary> /// 載入表單控制項相關預設值 /// </summary> public void LoadDefaultValue() { string SQLCommand = "Select A1.ItemsID ,A1.Name,A1.ItemsType , A1.ItemsUnit,A1.SellingPrice,A1.CostPrice,A1.MSRP, (A1.ManufacturerID + '-' + A2.CNAME) as Manufacturer " + "from ItemsInfo A1 INNER JOIN ManufacturerInfo A2 On A1.ManufacturerID = A2.ManufacturerID order by A1.ItemsID "; My.MyDatabase MyDb = new My.MyDatabase(); DataView DV = MyDb.CreateDataView(SQLCommand, "ItemsInfo"); this.dgvItemsInfo.DataSource = DV; //dataGridView表頭名稱中文化 dgvItemsInfo.Columns[0].HeaderText = "商品編號"; dgvItemsInfo.Columns[1].HeaderText = "商品名稱"; dgvItemsInfo.Columns[2].HeaderText = "商品類別"; dgvItemsInfo.Columns[3].HeaderText = "基本單位"; dgvItemsInfo.Columns[4].HeaderText = "出貨價格"; dgvItemsInfo.Columns[5].HeaderText = "進貨價格"; dgvItemsInfo.Columns[6].HeaderText = "建議售價"; dgvItemsInfo.Columns[7].HeaderText = "進貨廠商"; tsslDataCount.Text = DV.Count.ToString(); dgvItemsInfo.Columns[0].Visible = false;//隱藏商品編號 //凍結 中文名稱 欄位 this.dgvItemsInfo.Columns["NAME"].Frozen = true; //設定點選任一儲存格變選取所屬資料列的所有資料 this.dgvItemsInfo.SelectionMode = DataGridViewSelectionMode.FullRowSelect; //替代資料列樣式 this.dgvItemsInfo.RowsDefaultCellStyle.BackColor = Color.AliceBlue; this.dgvItemsInfo.AlternatingRowsDefaultCellStyle.BackColor = Color.Ivory; //自動調整資料列與資料行的高度與寬度 this.dgvItemsInfo.AutoResizeColumns(); this.dgvItemsInfo.AutoResizeRows(); //防止在 DataGridView 控制項中新增和刪除資料列 this.dgvItemsInfo.AllowUserToAddRows = false; this.dgvItemsInfo.AllowUserToDeleteRows = false; //列標頭依據顯示內容自動調整大小 this.dgvItemsInfo.AutoResizeRowHeadersWidth(DataGridViewRowHeadersWidthSizeMode.AutoSizeToAllHeaders); }
/// <summary> /// 將資料寫入資料庫中 /// </summary> private void RunInsertData() { try { My.MyDatabase MyDb = new My.MyDatabase(); SIS.Configuration.ClsItemsConfig CIC = new Configuration.ClsItemsConfig(); CIC.ItemsID = txtItemsID.Text; CIC.NAME = txtNAME.Text; CIC.ItemsType = cboItemsType.Text.Substring(0, cboItemsType.Text.IndexOf("-")); CIC.Specifications = txtSpecifications.Text.Replace("'", "''"); //將一個單引號置換成二個單引號避免SQL語法錯誤 CIC.ItemsUnit = cboItemsUnit.Text; CIC.SellingPrice = int.Parse(mtbSellingPrice.Text); CIC.CostPrice = int.Parse(mtbCostPrice.Text); CIC.MSRP = int.Parse(mtbMSRP.Text); CIC.ManufacturerID = cboManufacturer.Text.Substring(0, cboManufacturer.Text.IndexOf("-")); CIC.Inventory = int.Parse(mtbInventory.Text); CIC.SafeInventory = int.Parse(mtbSafeInventory.Text); CIC.Notes = rtbNotes.Text.Replace("'", "''"); SIS.DBClass.DBClassItemsInfo DBCII = new DBClass.DBClassItemsInfo(); if (MyDb.AuthPK(CIC.ItemsID, "ItemsID", "ItemsInfo") == false) { if (DBCII.InsertData(CIC)) { MessageBox.Show("新增[" + CIC.ItemsID + "-" + CIC.NAME + "]商品資料成功", "新增商品資料", MessageBoxButtons.OK, MessageBoxIcon.Information); LoadDefaultValue(); } else { MessageBox.Show("新增[" + CIC.ItemsID + "-" + CIC.NAME + "]商品資料失敗", "新增商品資料", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } else { MessageBox.Show("對不起,資料庫已存在[ " + CIC.ItemsID + "-" + CIC.NAME + " ]商品資料!!(資料重複)", "資料新增"); } } catch (Exception ex) { MessageBox.Show("錯誤訊息:" + ex.Message.ToString(), "發生例外"); } }
/// <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 + " ]職員資料!!(資料不存在)", "資料更新"); } }
private void LoadAccountsReceivableData() { try { SIS.DBClass.DBClassAccountsReceivable DBCAR = new DBClass.DBClassAccountsReceivable(); DBCAR.DeleteAllData(); string SQLCommand = "DECLARE @tempData TABLE( " + "[ShipID] [nvarchar](20) NULL, " + "[CustomerID] [nvarchar](20) NULL, " + "[CNAME] [nvarchar](20) NULL, " + "[UnpaidAmount] [int] NULL, " + "[ReversalAmount] [int] NULL) " + "INSERT INTO @tempData " + "SELECT ShipMaster.ShipID,ShipMaster.CustomerID, " + "CustomerInfo.CNAME , ResultUnpaidAmout = case " + "When RMAMaster.UnpaidAmount is null Then ShipMaster.UnpaidAmount " + "Else " + "RMAMaster.UnpaidAmount " + "End ,ReversalAmount = case " + "When Reversal.ReversalAmount is null Then 0 " + "Else " + "Reversal.ReversalAmount " + "End " + "FROM ShipMaster INNER JOIN " + "CustomerInfo ON ShipMaster.CustomerID = CustomerInfo.CustomerID " + "LEFT JOIN RMAMaster ON ShipMaster.ShipID = RMAMaster.StockIDOrShipID " + "LEFT JOIN Reversal ON Reversal.StockIDOrShipID = ShipMaster.ShipID " + "WHERE ShipMaster.UnpaidAmount < 0 AND (RMAMaster.UnpaidAmount is null or RMAMaster.UnpaidAmount < 0) " + "Select * , (UnpaidAmount + ReversalAmount) as Surplus From @tempData"; My.MyDatabase myDB = new My.MyDatabase(); DataTable dt = myDB.CreateDataTable(SQLCommand, "TempAccountsReceivable"); myDB.BulkCopyToTable(dt, "AccountsReceivable"); } catch (Exception ex) { MessageBox.Show("錯誤訊息:" + ex.Message.ToString(), "發生例外"); } }
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 + " ]公司資料!!(資料不存在)", "資料更新"); } }
/// <summary> /// 載入表單控制項相關預設值 /// </summary> public void LoadDefaultValue2() { string SQLCommand = "Select TOP 100 * from ManagementInfo order by CNAME DESC"; My.MyDatabase MyDb = new My.MyDatabase(); DataView DV = MyDb.CreateDataView(SQLCommand, "ManagementInfo"); this.dataGridView2.DataSource = DV; //dataGridView表頭名稱中文化 dataGridView2.Columns[0].HeaderText = "使用者帳號"; dataGridView2.Columns[1].HeaderText = "中文名稱"; dataGridView2.Columns[2].HeaderText = "英文名稱"; dataGridView2.Columns[3].HeaderText = "性別"; dataGridView2.Columns[4].HeaderText = "生日"; dataGridView2.Columns[5].HeaderText = "血型"; dataGridView2.Columns[6].HeaderText = "身份證字號"; dataGridView2.Columns[7].HeaderText = "通訊地址"; dataGridView2.Columns[8].HeaderText = "電話"; dataGridView2.Columns[9].HeaderText = "職稱"; tSSL_DataCount2.Text = DV.Count.ToString(); //設定點選任一儲存格變選取所屬資料列的所有資料 this.dataGridView2.SelectionMode = DataGridViewSelectionMode.FullRowSelect; //替代資料列樣式 this.dataGridView2.RowsDefaultCellStyle.BackColor = Color.AliceBlue; this.dataGridView2.AlternatingRowsDefaultCellStyle.BackColor = Color.Ivory; //自動調整資料列與資料行的高度與寬度 this.dataGridView2.AutoResizeColumns(); this.dataGridView2.AutoResizeRows(); //防止在 DataGridView 控制項中新增和刪除資料列 this.dataGridView2.AllowUserToAddRows = false; this.dataGridView2.AllowUserToDeleteRows = false; }
/// <summary> /// 將資料寫入資料庫中 /// </summary> private void RunInsertData() { My.MyDatabase MyDb = new My.MyDatabase(); SIS.Configuration.ClsCustomerConfig CCC = new Configuration.ClsCustomerConfig(); CCC.CustomerID = txtCustomerID.Text; CCC.CNAME = txtCNAME.Text; CCC.ENAME = txtENAME.Text; string FilePath = Application.StartupPath + "\\Photos\\Customer\\" + "NoPicture.bmp"; CCC.Photos = My.MyFileIO.FileToByteArray(FilePath); CCC.Birthday = dtpBirthday.Value.ToString("yyyy年MM月dd日"); CCC.CustomerType = cboCustomerType.Text; CCC.Phone = mtbPhone.Text; CCC.MobilePhone = mtbMobilePhone.Text; CCC.Fax = mtbFax.Text; CCC.Address = txtAddress.Text; CCC.Notes = rtbNotes.Text; SIS.DBClass.DBClassCustomerInfo DBCCI = new DBClass.DBClassCustomerInfo(); if (MyDb.AuthPK(CCC.CustomerID, "CustomerID", "CustomerInfo") == false) { if (DBCCI.ParameterInsertData(CCC)) { MessageBox.Show("新增[" + CCC.CustomerID + "-" + CCC.CNAME + "]客戶資料成功", "新增客戶資料", MessageBoxButtons.OK, MessageBoxIcon.Information); LoadDefaultValue(); } else { MessageBox.Show("新增[" + CCC.CustomerID + "-" + CCC.CNAME + "]客戶資料失敗", "新增客戶資料", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } else { MessageBox.Show("對不起,資料庫已存在[ " + CCC.CustomerID + "-" + CCC.CNAME + " ]客戶資料!!(資料重複)", "資料新增"); } }
private void RunUpdateData() { My.MyDatabase MyDb = new My.MyDatabase(); SIS.Configuration.ClsCustomerConfig CCC = new Configuration.ClsCustomerConfig(); CCC.CustomerID = txtCustomerID.Text; CCC.CNAME = txtCNAME.Text; CCC.ENAME = txtENAME.Text; CCC.Photos = My.MyMethod.ImageToByte(PicPhotos.Image); CCC.Birthday = dtpBirthday.Value.ToString("yyyy年MM月dd日"); CCC.CustomerType = cboCustomerType.Text; CCC.Phone = mtbPhone.Text; CCC.MobilePhone = mtbMobilePhone.Text; CCC.Fax = mtbFax.Text; CCC.Address = txtAddress.Text; CCC.Notes = rtbNotes.Text; SIS.DBClass.DBClassCustomerInfo DBCCI = new DBClass.DBClassCustomerInfo(); if (MyDb.AuthPK(CCC.CustomerID, "CustomerID", "CustomerInfo") == true) { if (DBCCI.ParameterUpdateData(CCC)) { MessageBox.Show("更新[" + CCC.CustomerID + "-" + CCC.CNAME + "]客戶資料成功", "更新客戶資料", MessageBoxButtons.OK, MessageBoxIcon.Information); LoadDefaultValue(); } else { MessageBox.Show("更新[" + CCC.CustomerID + "-" + CCC.CNAME + "]客戶資料失敗", "更新客戶資料", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } else { MessageBox.Show("對不起,資料庫不存在[ " + CCC.CustomerID + "-" + CCC.CNAME + " ]客戶資料!!(資料不存在)", "資料更新"); } }
private void RunUpdateData() { My.MyDatabase MyDb = new My.MyDatabase(); SIS.Configuration.ClsItemsConfig CIC = new Configuration.ClsItemsConfig(); CIC.ItemsID = txtItemsID.Text; CIC.NAME = txtNAME.Text; CIC.ItemsType = cboItemsType.Text.Substring(0, cboItemsType.Text.IndexOf("-")); CIC.Specifications = txtSpecifications.Text.Replace("'", "''"); CIC.ItemsUnit = cboItemsUnit.Text; CIC.SellingPrice = int.Parse(mtbSellingPrice.Text); CIC.CostPrice = int.Parse(mtbCostPrice.Text); CIC.MSRP = int.Parse(mtbMSRP.Text); CIC.ManufacturerID = cboManufacturer.Text.Substring(0, cboManufacturer.Text.IndexOf("-")); CIC.Inventory = int.Parse(mtbInventory.Text); CIC.SafeInventory = int.Parse(mtbSafeInventory.Text); CIC.Notes = rtbNotes.Text.Replace("'", "''"); SIS.DBClass.DBClassItemsInfo DBCII = new DBClass.DBClassItemsInfo(); if (MyDb.AuthPK(CIC.ItemsID, "ItemsID", "ItemsInfo") == true) { if (DBCII.Update(CIC)) { MessageBox.Show("更新[" + CIC.ItemsID + "-" + CIC.NAME + "]商品資料成功", "更新商品資料", MessageBoxButtons.OK, MessageBoxIcon.Information); LoadDefaultValue(); } else { MessageBox.Show("更新[" + CIC.ItemsID + "-" + CIC.NAME + "]商品資料失敗", "更新商品資料", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } else { MessageBox.Show("對不起,資料庫不存在[ " + CIC.ItemsID + "-" + CIC.NAME + " ]商品資料!!(資料不存在)", "資料更新"); } }
/// <summary> /// 將資料寫入資料庫中 /// </summary> private void RunInsertData() { My.MyDatabase MyDb = new My.MyDatabase(); SIS.Configuration.ClsManufacturerConfig CMC = new Configuration.ClsManufacturerConfig(); CMC.ManufacturerID = txtManufacturerID.Text; CMC.CNAME = txtCNAME.Text; CMC.ENAME = txtENAME.Text; CMC.UnifiedBusinessNo = mtbUnifiedBusinessNo.Text; CMC.Owner = txtOwner.Text; CMC.Contact = txtContact.Text; CMC.Phone = mtbPhone.Text; CMC.MobilePhone = mtbMobilePhone.Text; CMC.Fax = mtbFax.Text; CMC.Address = txtAddress.Text; CMC.WebSite = txtWebSite.Text; CMC.Notes = rtbNotes.Text; SIS.DBClass.DBClassManufacturerInfo DBCMI = new DBClass.DBClassManufacturerInfo(); if (MyDb.AuthPK(CMC.ManufacturerID, "ManufacturerID", "ManufacturerInfo") == false) { if (DBCMI.InsertData(CMC)) { MessageBox.Show("新增[" + CMC.ManufacturerID + "-" + CMC.CNAME + "]公司資料成功", "新增廠商資料", MessageBoxButtons.OK, MessageBoxIcon.Information); LoadDefaultValue(); } else { MessageBox.Show("新增[" + CMC.ManufacturerID + "-" + CMC.CNAME + "]廠商資料失敗", "新增廠商資料", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } else { MessageBox.Show("對不起,資料庫已存在[ " + CMC.ManufacturerID + "-" + CMC.CNAME + " ]廠商資料!!(資料重複)", "資料新增"); } }