private void btnReload_Click(object sender, EventArgs e)
{
if (CurrentQuotation.ID == 0)
{
return;
}
C_CostQuotationLinkBO.Instance.DeleteByAttribute("C_QuotationID", CurrentQuotation.ID);
//DataTable dtLink = LibQLSX.Select("select * from C_Cost where IsWithProject = 1 or CostType = 1");
DataTable dtLink = LibQLSX.Select("select * from C_Cost where IsWithProject = 1 or CostType = 1");
foreach (DataRow row in dtLink.Rows)
{
C_CostQuotationLinkModel link = new C_CostQuotationLinkModel();
link.C_CostID = TextUtils.ToInt(row["ID"]);
link.C_QuotationID = CurrentQuotation.ID;
link.Price = TextUtils.ToDecimal(row["Price"]);
link.Qty = 0;
link.Total = link.Qty * link.Price;
C_CostQuotationLinkBO.Instance.Insert(link);
}
loadCost();
}
void save()
{
ProcessTransaction pt = new ProcessTransaction();
pt.OpenConnection();
pt.BeginTransaction();
try
{
if (!ValidateForm())
{
return;
}
grvLink.FocusedRowHandle = -1;
CurrentQuotation.Code = txtCode.Text.Trim();
CurrentQuotation.CustomerCode = txtCustomerCode.Text.Trim();
CurrentQuotation.CustomerName = txtCustomerName.Text.Trim();
CurrentQuotation.DeliveryTime = TextUtils.ToDecimal(txtDeliveryTime.EditValue);
CurrentQuotation.DepartmentName = txtDepartmentName.Text.Trim();
CurrentQuotation.CustomerCodeF = txtFinishCustomerCode.Text.Trim();
CurrentQuotation.CustomerNameF = txtFinishCustomerName.Text.Trim();
CurrentQuotation.POnumber = txtPOnumber.Text.Trim();
CurrentQuotation.ProjectCode = txtProjectCode.Text.Trim();
CurrentQuotation.ProjectName = txtProjectName.Text.Trim();
CurrentQuotation.Tax = TextUtils.ToDecimal(txtTax.EditValue);
CurrentQuotation.TotalCustomer = TextUtils.ToDecimal(colTotal.SummaryItem.SummaryValue);
//CurrentQuotation.TotalBX = TextUtils.ToDecimal(txtTotalBX.EditValue);
//CurrentQuotation.TotalHD = TextUtils.ToDecimal(txtTotalHD.EditValue);
//CurrentQuotation.TotalNC = TextUtils.ToDecimal(txtTotalNC.EditValue);
//CurrentQuotation.TotalPB = TextUtils.ToDecimal(txtTotalPB.EditValue);
//CurrentQuotation.TotalProfit = TextUtils.ToDecimal(txtTotalProfit.EditValue);
//CurrentQuotation.TotalReal = TextUtils.ToDecimal(txtTotalReal.EditValue);
//CurrentQuotation.TotalTPA = TextUtils.ToDecimal(txtTotalTPA.EditValue);
//CurrentQuotation.TotalVT = TextUtils.ToDecimal(txtTotalVT.EditValue);
CurrentQuotation.Status = cboStatus.SelectedIndex;
CurrentQuotation.DepartmentId = TextUtils.ToInt(cboDepartment.SelectedValue);
CurrentQuotation.CustomerPercent = TextUtils.ToDecimal(txtCustomerPercent.EditValue);
CurrentQuotation.CustomerCash = TextUtils.ToDecimal(txtCustomerCash.EditValue);
//CurrentQuotation.IsCustomerVAT = chkIsCustomerVAT.Checked;
CurrentQuotation.IsVAT = cboIsVAT.SelectedIndex;
CurrentQuotation.UpdatedDate = DateTime.Now;
CurrentQuotation.UpdatedBy = Global.AppUserName;
if (CurrentQuotation.ID <= 0)
{
CurrentQuotation.CreatedDate = DateTime.Now;
CurrentQuotation.CreatedBy = Global.AppUserName;
CurrentQuotation.ID = (int)pt.Insert(CurrentQuotation);
}
else
{
pt.Update(CurrentQuotation);
}
if (grvLink.RowCount > 0)
{
for (int i = 0; i < grvLink.RowCount; i++)
{
int id = TextUtils.ToInt(grvLink.GetRowCellValue(i, colID));
C_CostQuotationLinkModel link = (C_CostQuotationLinkModel)C_CostQuotationLinkBO.Instance.FindByPK(id);
link.Qty = TextUtils.ToDecimal(grvLink.GetRowCellValue(i, colQty));
link.Price = TextUtils.ToDecimal(grvLink.GetRowCellValue(i, colPrice));
link.Total = link.Qty * link.Price;
pt.Update(link);
}
}
else
{
DataTable dtLink = LibQLSX.Select("select * from C_Cost where IsWithProject = 1");
//DataTable dtLink = LibQLSX.Select("select * from C_Cost where IsWithProject = 1 or CostType = 1");
foreach (DataRow row in dtLink.Rows)
{
C_CostQuotationLinkModel link = new C_CostQuotationLinkModel();
link.C_CostID = TextUtils.ToInt(row["ID"]);
link.C_QuotationID = CurrentQuotation.ID;
link.Price = TextUtils.ToDecimal(row["Price"]);
link.Qty = 0;
link.Total = link.Qty * link.Price;
pt.Insert(link);
}
}
pt.CommitTransaction();
_isSaved = true;
loadCost();
MessageBox.Show("Lưu trữ thành công!", TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
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();
}
if (_isSaved)
{
if (this.LoadDataChange != null)
{
this.LoadDataChange(null, null);
}
}
}
protected C_CostQuotationLinkFacade(C_CostQuotationLinkModel model) : base(model)
{
}
