private void btnSaleDelete_Click(object sender, EventArgs e)
{
try
{
if (dgvSale.SelectedRows.Count > 0 && APConfig.SweetAlert(ShowBoxType.confirm, string.Format("是否確定要刪除{0}筆?", dgvSale.SelectedRows.Count)))
{
List <string> sernolist = new List <string>();
string delSernoList = "";
foreach (DataGridViewRow row in dgvSale.SelectedRows)
{
sernolist.Add(string.Format("'{0}'", row.Cells["dgvSale_Serno"].Value.ToString()));
}
delSernoList = string.Join(",", sernolist);
RosterDial entRosterDial = new RosterDial(APConfig.Conn);
string sConditions = entRosterDial.getCondition(RosterDial.ncConditions.sernolist.ToString(), delSernoList);
entRosterDial.deleteAll(sConditions);
saleLoadData(ddlSalePage.SelectedIndex + 1);
APConfig.SweetAlert(ShowBoxType.alert, "刪除完成");
}
}
catch (Exception ex)
{
APConfig.SweetAlert(ShowBoxType.alert, string.Format("刪除失敗 {0}", ex.Message));
}
}
private void btnOK_Click(object sender, EventArgs e)
{
if (mode == mode.Add && checkAdd())
{
foreach (DataGridViewRow row in dgvItem.Rows)
{
RosterDial ent = new RosterDial(APConfig.Conn);
ent.RSD_SERNO = My.GenSerNo();
ent.RST_SERNO = mRosterInfo.RST_SERNO;
ent.RSD_STATUS = ddlStatus.SelectedItem.ToString();
ent.RSD_ITEMTYPE = row.Cells["dgvItem_Type"].Value.ToString();
ent.RSD_ITEM = row.Cells["dgvItem_Item"].Value.ToString();
ent.RSD_AMOUNT = row.Cells["dgvItem_Amount"].Value.ToString();
ent.RSD_COMMENT = txtComment.Text;
ent.RSD_DEALER = ddlDealer.SelectedItem.ToString();
ent.RSD_MODIFIEDBY = APConfig.AccountName;
ent.RSD_MODIFIEDDTTM = DateTime.Now;
ent.RSD_INSERTBY = APConfig.AccountName;
ent.RSD_INSERTDTTM = DateTime.Now;
ent.RSD_DEALDDTTM = DateTime.Parse(dpkDealDTTM.Value.ToString());
ent.insert();
}
APConfig.SweetAlert(ShowBoxType.alert, "新增完成");
this.DialogResult = DialogResult.OK;
this.Close();
}
else if (mode == mode.Edit && checkAdd())
{
RosterDial ent = new RosterDial(APConfig.Conn);
ent.RSD_SERNO = serno;
ent.ModifyFields = string.Format("{0};{1};{2};{3};{4};{5};{6};{7};{8}"
, RosterDial.ncFields.RSD_DEALER.ToString()
, RosterDial.ncFields.RSD_STATUS.ToString()
, RosterDial.ncFields.RSD_ITEMTYPE.ToString()
, RosterDial.ncFields.RSD_ITEM.ToString()
, RosterDial.ncFields.RSD_AMOUNT.ToString()
, RosterDial.ncFields.RSD_COMMENT.ToString()
, RosterDial.ncFields.RSD_MODIFIEDBY.ToString()
, RosterDial.ncFields.RSD_MODIFIEDDTTM.ToString()
, RosterDial.ncFields.RSD_DEALDDTTM.ToString());
ent.RSD_DEALER = ddlDealer.SelectedItem.ToString();
ent.RSD_STATUS = ddlStatus.SelectedItem.ToString();
ent.RSD_ITEMTYPE = ddlType.SelectedItem.ToString();
ent.RSD_ITEM = txtItemInfo.Text;
ent.RSD_AMOUNT = txtAmount.Text;
ent.RSD_COMMENT = txtComment.Text;
ent.RSD_MODIFIEDBY = APConfig.AccountName;
ent.RSD_MODIFIEDDTTM = DateTime.Now;
ent.RSD_DEALDDTTM = DateTime.Parse(dpkDealDTTM.Value.ToString());
ent.update();
APConfig.SweetAlert(ShowBoxType.alert, "修改完成");
this.DialogResult = DialogResult.OK;
this.Close();
}
else if (mode == mode.View)
{
this.DialogResult = DialogResult.OK;
this.Close();
}
else
{
return;
}
}
