private void btnAdd_Click(object sender, EventArgs e)
{
frmPaymentTableItem frm = new frmPaymentTableItem();
frm.LoadDataChange += main_LoadDataChange;
frm.Show();
}
private void grvData_DoubleClick(object sender, EventArgs e)
{
long paymentTableID = TextUtils.ToInt64(grvData.GetFocusedRowCellValue(colPaymentTableID));
if (paymentTableID == 0)
{
return;
}
PaymentTableModel model = (PaymentTableModel)PaymentTableBO.Instance.FindByPK(paymentTableID);
frmPaymentTableItem frm = new frmPaymentTableItem();
frm.PaymentTable = model;
//frm.LoadDataChange += main_LoadDataChange;
frm.Show();
}
private void btnEdit_Click(object sender, EventArgs e)
{
long id = TextUtils.ToInt64(grvData.GetFocusedRowCellValue(colID));
if (id == 0)
{
return;
}
PaymentTableModel model = (PaymentTableModel)PaymentTableBO.Instance.FindByPK(id);
_rownIndex = grvData.FocusedRowHandle;
frmPaymentTableItem frm = new frmPaymentTableItem();
frm.PaymentTable = model;
frm.LoadDataChange += main_LoadDataChange;
frm.Show();
}
private void btnCreateBKTT_Click(object sender, EventArgs e)
{
grvYC.FocusedRowHandle = -1;
DataTable dtYC = (DataTable)grdYC.DataSource;
DataRow[] drsYC = dtYC.Select("Check = 1");
if (drsYC.Length == 0)
{
return;
}
ProcessTransaction pt = new ProcessTransaction();
pt.OpenConnection();
pt.BeginTransaction();
try
{
PaymentTableModel PaymentTable = new PaymentTableModel();
PaymentTable.IsDeleted = false;
PaymentTable.Number = loadNumber(PaymentTable);
//PaymentTable.TotalTM = TextUtils.ToDecimal(colTM.SummaryItem.SummaryValue);
//PaymentTable.TotalCK = TextUtils.ToDecimal(colCK.SummaryItem.SummaryValue);
PaymentTable.UpdatedBy = Global.AppUserName;
PaymentTable.UpdatedDate = DateTime.Now;
PaymentTable.CreatedBy = Global.AppUserName;
PaymentTable.CreatedDate = DateTime.Now;
PaymentTable.ID = (long)pt.Insert(PaymentTable);
int count = 0;
foreach (DataRow row in drsYC)
{
PaymentTableItemModel item = new PaymentTableItemModel();
item.Code = TextUtils.ToString(row["OrderCode"]);
item.Target = TextUtils.ToString(row["Project"]);
item.Name = TextUtils.ToString(row["SupplierName"]);
item.Total = TextUtils.ToDecimal(row["TienThanhToan"]);
item.TotalTH = TextUtils.ToDecimal(row["TotalPrice"]);
item.DeliveryCost = TextUtils.ToDecimal(row["DeliveryCost"]);
item.DiffCost = TextUtils.ToDecimal(row["DiffCost"]);
item.UserId = TextUtils.ToString(row["UserId"]);
//item.ProjectId = TextUtils.ToString(row["Project"]);
item.VAT = TextUtils.ToDecimal(row["VAT"]);
item.OrderRequirePaidID = TextUtils.ToInt(row["ID"]);
item.PaymentTableID = PaymentTable.ID;
item.IsCash = TextUtils.ToInt(row["PaymentType"]) == 1 ? true : false;
item.PercentPay = TextUtils.ToDecimal(row["PayPercent"]);
item.TotalCash = item.IsCash ? TextUtils.ToDecimal(row["TotalPay"]) : 0;
item.TotalCK = item.IsCash ? 0 : TextUtils.ToDecimal(row["TotalPay"]);
pt.Insert(item);
OrdersModel order = (OrdersModel)OrdersBO.Instance.FindByAttribute("OrderId", TextUtils.ToString(row["OrderId"]))[0];
order.StatusTT = 2;
pt.UpdateQLSX(order);
OrderRequirePaidModel paid = (OrderRequirePaidModel)OrderRequirePaidBO.Instance.FindByPK(TextUtils.ToInt(row["ID"]));
paid.Status = 2;
pt.Update(paid);
count++;
}
if (count > 0)
{
pt.CommitTransaction();
MessageBox.Show("Lưu trữ thành công!", TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Information);
loadData();
PaymentTableModel model = (PaymentTableModel)PaymentTableBO.Instance.FindByAttribute("Number", PaymentTable.Number)[0];
frmPaymentTableItem frm = new frmPaymentTableItem();
frm.PaymentTable = model;
frm.Show();
}
}
catch (Exception ex)
{
MessageBox.Show("Lưu trữ không thành công!" + Environment.NewLine + ex.Message, TextUtils.Caption,
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
pt.CloseConnection();
}
}
