/// <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 +
" ]廠商資料!!(資料重複)", "資料新增");
}
}
