private void btnDelete_Click(object sender, EventArgs e)
{
if (dataGridViewX1.SelectedRows[0].Index > -1)
{
string name = "" + dataGridViewX1.Rows[dataGridViewX1.SelectedRows[0].Index].Cells[0].Value;
UDT.ScoreRule data = (UDT.ScoreRule)dataGridViewX1.Rows[dataGridViewX1.SelectedRows[0].Index].Tag;
DialogResult result = MsgBox.Show(string.Format("確定刪除「{0}」此分數準則?", name), "提醒", MessageBoxButtons.YesNo);
if (result == DialogResult.Yes)
{
List <UDT.ScoreRule> listDeleteData = new List <UDT.ScoreRule>();
listDeleteData.Add(data);
try
{
this._access.DeletedValues(listDeleteData);
MsgBox.Show("資料刪除成功");
ReloadDataGridView();
}
catch (Exception ex)
{
MsgBox.Show(ex.Message);
}
}
}
}
/// <summary>
/// 設定畫面資料
/// </summary>
/// <param name="data"></param>
public void setData(UDT.ScoreRule data)
{
this._data = data;
tbxName.Text = data.Name;
tbxWeekTotal.Text = "" + data.WeeklyTotal;
tbxScoreLimit.Text = "" + data.MacDailyDeduction;
}
private void fillData(UDT.ScoreRule sr)
{
sr.Name = tbxName.Text;
sr.WeeklyTotal = int.Parse(tbxWeekTotal.Text);
sr.MacDailyDeduction = int.Parse(tbxScoreLimit.Text);
sr.Formula = cbxFormula.SelectedItem.ToString();
sr.CreateTime = DateTime.Parse(lbCreatTime.Text);
sr.CreatedBy = lbAccount.Text;
}
private void btnSave_Click(object sender, EventArgs e)
{
if (tbxName_Validate() && tbxWeekTotal_Validate() && tbxScoreLimit_Validate())
{
List <UDT.ScoreRule> listData = new List <UDT.ScoreRule>();
if (this._mode == FormMode.Add)
{
UDT.ScoreRule sr = new UDT.ScoreRule();
fillData(sr);
listData.Add(sr);
try
{
this._access.InsertValues(listData);
MsgBox.Show("資料儲存成功!");
this.DialogResult = DialogResult.Yes;
this.Close();
}
catch (Exception ex)
{
MsgBox.Show(ex.Message);
}
}
else
{
UDT.ScoreRule sr = this._data;
fillData(sr);
listData.Add(sr);
try
{
this._access.UpdateValues(listData);
MsgBox.Show("資料更新成功!");
this.DialogResult = DialogResult.Yes;
this.Close();
}
catch (Exception ex)
{
MsgBox.Show(ex.Message);
}
}
}
}
