private void RunDeleteData()
{
try
{
My.MyDatabase MyDb = new My.MyDatabase();
SIS.Configuration.ClsTakeStockConfig CTSC = new Configuration.ClsTakeStockConfig();
CTSC.TakeStockID = txtTakeStockID.Text;
SIS.DBClass.DBClassTakeStockMaster DBCTSM = new DBClass.DBClassTakeStockMaster();
if (MyDb.AuthPK(CTSC.TakeStockID, "TakeStockID", "TakeStockMaster") == true)
{
if (DBCTSM.DeleteMasterDetailsData(CTSC.TakeStockID))
{
MessageBox.Show("刪除[" + CTSC.TakeStockID +
"]盤點單資料成功", "刪除盤點單資料", MessageBoxButtons.OK, MessageBoxIcon.Information);
LoadDefaultValue();
}
else
{
MessageBox.Show("刪除[" + CTSC.TakeStockID +
"]盤點單資料失敗", "刪除盤點單資料", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
else
{
MessageBox.Show("對不起，資料庫不存在[ " + CTSC.TakeStockID +
" ]刪除單資料!!(資料不存在)", "資料刪除");
}
}
catch (Exception ex)
{
MessageBox.Show("錯誤訊息:" + ex.Message.ToString(), "發生例外");
}
}
private void LoadTakeStockItems()
{
SIS.DBClass.DBClassItemsInfo DBCII = new DBClass.DBClassItemsInfo();
SIS.Configuration.ClsTakeStockConfig CTSC = new Configuration.ClsTakeStockConfig();
bool result = DBCII.QueryAllItems(CTSC);
if (result)
{
dgvTakeStockItemsInfo.Rows.Clear();
for (int i = 0; i < CTSC.TakeStockItems.Length; i++)
{
var index = dgvTakeStockItemsInfo.Rows.Add();
dgvTakeStockItemsInfo.Rows[index].Cells["ItemsID"].Value = CTSC.TakeStockItems[i].ItemsID;
dgvTakeStockItemsInfo.Rows[index].Cells["NAME"].Value = CTSC.TakeStockItems[i].NAME;
dgvTakeStockItemsInfo.Rows[index].Cells["Inventory"].Value = CTSC.TakeStockItems[i].Inventory.ToString();
dgvTakeStockItemsInfo.Rows[index].Cells["TakeStockInventory"].Value = CTSC.TakeStockItems[i].TakeStockInventory.ToString();
dgvTakeStockItemsInfo.Rows[index].Cells["GainLossInventory"].Value = CTSC.TakeStockItems[i].GainLossInventory.ToString();
dgvTakeStockItemsInfo.Rows[index].Cells["IsTakeStock"].Value = CTSC.TakeStockItems[i].IsTakeStock;
dgvTakeStockItemsInfo.Rows[index].Cells["ItemsUnit"].Value = CTSC.TakeStockItems[i].ItemsUnit;
dgvTakeStockItemsInfo.Rows[index].Cells["Price"].Value = CTSC.TakeStockItems[i].Price.ToString();
dgvTakeStockItemsInfo.Rows[index].Cells["Totals"].Value = CTSC.TakeStockItems[i].Totals.ToString();
dgvTakeStockItemsInfo.Rows[index].Cells["Notes"].Value = CTSC.TakeStockItems[i].Notes;
}
}
}
private void RunUpdateData()
{
try
{
My.MyDatabase MyDb = new My.MyDatabase();
SIS.Configuration.ClsTakeStockConfig CTSC = new Configuration.ClsTakeStockConfig();
CTSC.TakeStockID = txtTakeStockID.Text;
CTSC.TakeStockDate = dtpTakeStockDate.Value.ToString("yyyy年MM月dd日");
CTSC.TakeStockStaff = cboTakeStockStaff.Text;
CTSC.Notes = rtbNotes.Text.Replace("'", "''");
CTSC.TakeStockItems = getItemsValueFromDataGridView(dgvTakeStockItemsInfo);
SIS.DBClass.DBClassTakeStockMaster DBCTSM = new DBClass.DBClassTakeStockMaster();
if (MyDb.AuthPK(CTSC.TakeStockID, "TakeStockID", "TakeStockMaster") == true)
{
if (DBCTSM.Update(CTSC))
{
MessageBox.Show("更新[" + CTSC.TakeStockID +
"]盤點單資料成功", "更新盤點單資料", MessageBoxButtons.OK, MessageBoxIcon.Information);
LoadDefaultValue();
}
else
{
MessageBox.Show("更新[" + CTSC.TakeStockID +
"]盤點單資料失敗", "更新盤點單資料", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
else
{
MessageBox.Show("對不起，資料庫不存在[ " + CTSC.TakeStockID +
" ]更新單資料!!(資料不存在)", "資料更新");
}
}
catch (Exception ex)
{
MessageBox.Show("錯誤訊息:" + ex.Message.ToString(), "發生例外");
}
}
//查詢
private void tsbQuery_Click(object sender, EventArgs e)
{
string Msg = "是否要進行盤點單[" + txtTakeStockID.Text + "]查詢動作?\r\n";
DialogResult DR;
DR = MessageBox.Show(Msg, "查詢盤點單", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (DR == DialogResult.Yes)
{
if (CheckField())
{
SIS.DBClass.DBClassTakeStockMaster DBCTSM = new DBClass.DBClassTakeStockMaster();
SIS.Configuration.ClsTakeStockConfig CTSC = new Configuration.ClsTakeStockConfig();
bool result = DBCTSM.QueryData(txtTakeStockID.Text, CTSC);
if (result)
{
MessageBox.Show("有找到盤點單號:[" + txtTakeStockID.Text + "]資料!\r\n是否將盤點單資料載入?", "搜尋結果", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (DR == DialogResult.Yes)
{
//要從最後面資料列開始往上移除才能正確執行
for (int i = dgvTakeStockItemsInfo.Rows.Count - 1; i >= 0; i--)
{
dgvTakeStockItemsInfo.Rows.RemoveAt(i);
//System.Threading.Thread.Sleep(10);
}
txtTakeStockID.Text = CTSC.TakeStockID;
dtpTakeStockDate.Text = CTSC.TakeStockDate;
cboTakeStockStaff.Text = CTSC.TakeStockStaff;
rtbNotes.Text = CTSC.Notes;
for (int i = 0; i < CTSC.TakeStockItems.Length; i++)
{
var index = dgvTakeStockItemsInfo.Rows.Add();
dgvTakeStockItemsInfo.Rows[index].Cells["ItemsID"].Value = CTSC.TakeStockItems[i].ItemsID;
dgvTakeStockItemsInfo.Rows[index].Cells["NAME"].Value = CTSC.TakeStockItems[i].NAME;
dgvTakeStockItemsInfo.Rows[index].Cells["Inventory"].Value = CTSC.TakeStockItems[i].Inventory.ToString();
dgvTakeStockItemsInfo.Rows[index].Cells["TakeStockInventory"].Value = CTSC.TakeStockItems[i].TakeStockInventory.ToString();
dgvTakeStockItemsInfo.Rows[index].Cells["GainLossInventory"].Value = CTSC.TakeStockItems[i].GainLossInventory.ToString();
dgvTakeStockItemsInfo.Rows[index].Cells["IsTakeStock"].Value = CTSC.TakeStockItems[i].IsTakeStock; //Boolean
dgvTakeStockItemsInfo.Rows[index].Cells["ItemsUnit"].Value = CTSC.TakeStockItems[i].ItemsUnit;
dgvTakeStockItemsInfo.Rows[index].Cells["Price"].Value = CTSC.TakeStockItems[i].Price.ToString();
dgvTakeStockItemsInfo.Rows[index].Cells["Totals"].Value = CTSC.TakeStockItems[i].Totals.ToString();
dgvTakeStockItemsInfo.Rows[index].Cells["Notes"].Value = CTSC.TakeStockItems[i].Notes;
}
tsslDataCount.Text = dgvTakeStockItemsInfo.Rows.Count.ToString();
}
}
else
{
MessageBox.Show("沒有找到盤點單號:[" + txtTakeStockID.Text + "]資料!", "搜尋結果");
}
}
}
else
{
MessageBox.Show("取消盤點單查詢動作!!", "查詢盤點單");
}
}