private void btnSave_Click(object sender, EventArgs e)
{
using (WaitDialogForm fWait = new WaitDialogForm("Vui lòng chờ trong giây lát...", "Đang lưu trữ dữ liệu..."))
{
ProcessTransaction pt = new ProcessTransaction();
pt.OpenConnection();
pt.BeginTransaction();
try
{
//if (!ValidateForm())
// return;
#region FCM
//fcm.FK_DTCP = TextUtils.ToInt(LibIE.ExcuteScalar("SELECT TOP 1 [PK_ID] FROM [T_DM_DTCP] where C_MA = '" + txtProjectCode.Text.Trim() + "'"));
//fcm.C_CODE = txtProjectCode.Text.Trim();
FCM.C_MONTH = cboMonth.SelectedIndex;
FCM.C_YEAR = TextUtils.ToInt(cboYear.SelectedItem);
//fcm.C_SOHOADON = txtHopDong.Text.Trim();
//fcm.C_TYPE = chkIsGiaoDucFCM.Checked ? 1 : 2;
//fcm.C_TYPE = TextUtils.ToInt(cboPhongBan.SelectedValue) == 40 ? 1 : 2;
//fcm.TotalBX = TextUtils.ToDecimal(txtTotalBX.EditValue);
//fcm.TotalTrienKhai = TextUtils.ToDecimal(txtTotalTrienKhai.EditValue);
//fcm.TotalHD = TextUtils.ToDecimal(txtTotalHD.EditValue);
//fcm.TotalNC = TextUtils.ToDecimal(txtTotalNC.EditValue);
//fcm.TotalPB = TextUtils.ToDecimal(txtTotalPB.EditValue);
//fcm.TotalProfit = TextUtils.ToDecimal(txtTotalProfit.EditValue);
//fcm.TotalReal = TextUtils.ToDecimal(txtTotalReal.EditValue);
//fcm.TotalTPA = TextUtils.ToDecimal(txtTotalTPA.EditValue);
//fcm.TotalVAT = TextUtils.ToDecimal(txtTotalVAT.EditValue);
//fcm.TotalBanHang = TextUtils.ToDecimal(txtTotalBanHang.EditValue);
pt.Update(FCM);
#endregion
#region Detail
grvData.FocusedRowHandle = -1;
for (int i = 0; i < grvData.RowCount; i++)
{
T_DM_FCM_DETAILModel detail = (T_DM_FCM_DETAILModel)T_DM_FCM_DETAILBO.Instance.FindByPK(TextUtils.ToInt(grvData.GetRowCellValue(i, colID)));
detail.FK_FCM = FCM.ID;
detail.FK_PHANXUONG = TextUtils.ToInt(grvData.GetRowCellValue(i, colDepartmentID));
detail.FK_KMP = TextUtils.ToInt(grvData.GetRowCellValue(i, colFK_KMP));
detail.C_PRICE = TextUtils.ToDecimal(grvData.GetRowCellValue(i, colValue));
pt.Update(detail);
}
#endregion
pt.CommitTransaction();
if (this.LoadDataChange != null)
{
this.LoadDataChange(null, null);
}
MessageBox.Show("Lưu trữ thành công!", TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
pt.CloseConnection();
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
using (WaitDialogForm fWait = new WaitDialogForm("Vui lòng chờ trong giây lát...", "Đang lưu trữ dữ liệu..."))
{
ProcessTransaction pt = new ProcessTransaction();
pt.OpenConnection();
pt.BeginTransaction();
try
{
if (!ValidateForm())
{
return;
}
#region FCM
fcm.FK_DTCP = TextUtils.ToInt(LibIE.ExcuteScalar("SELECT TOP 1 [PK_ID] FROM [T_DM_DTCP] where C_MA = '" + txtProjectCode.Text.Trim() + "'"));
fcm.C_CODE = txtProjectCode.Text.Trim();
fcm.C_MONTH = cboMonth.SelectedIndex;
fcm.C_YEAR = TextUtils.ToInt(cboYear.SelectedItem);
fcm.C_SOHOADON = txtHopDong.Text.Trim();
//fcm.C_TYPE = chkIsGiaoDucFCM.Checked ? 1 : 2;
fcm.C_TYPE = TextUtils.ToInt(cboPhongBan.SelectedValue) == 40 ? 1 : 2;
fcm.TotalBX = TextUtils.ToDecimal(txtTotalBX.EditValue);
fcm.TotalTrienKhai = TextUtils.ToDecimal(txtTotalTrienKhai.EditValue);
fcm.TotalHD = TextUtils.ToDecimal(txtTotalHD.EditValue);
fcm.TotalNC = TextUtils.ToDecimal(txtTotalNC.EditValue);
fcm.TotalPB = TextUtils.ToDecimal(txtTotalPB.EditValue);
fcm.TotalProfit = TextUtils.ToDecimal(txtTotalProfit.EditValue);
fcm.TotalReal = TextUtils.ToDecimal(txtTotalReal.EditValue);
fcm.TotalTPA = TextUtils.ToDecimal(txtTotalTPA.EditValue);
fcm.TotalVAT = TextUtils.ToDecimal(txtTotalVAT.EditValue);
fcm.TotalBanHang = TextUtils.ToDecimal(txtTotalBanHang.EditValue);
fcm.TotalVT = TextUtils.ToDecimal(txtTotalVT.EditValue);
fcm.ID = (int)pt.Insert(fcm);
#endregion
#region Detail
grvData.FocusedRowHandle = -1;
for (int i = 0; i < grvData.RowCount; i++)
{
decimal c_Price = TextUtils.ToDecimal(grvData.GetRowCellValue(i, colValue));
//if (c_Price == 0) continue;
string kmpCode = TextUtils.ToString(grvData.GetRowCellValue(i, colCode));
int departmentID = TextUtils.ToInt(grvData.GetRowCellValue(i, colDepartmentID));
int pk_KMP = TextUtils.ToInt(LibIE.ExcuteScalar("select top 1 PK_ID from T_DM_KMP where C_MA = '" + kmpCode + "'"));
if (pk_KMP == 0)
{
continue;
}
if (departmentID == 81)
{
DataTable dtLink = LibIE.Select("SELECT [ID],[PK_PHANXUONG],[PK_KMP],[TYLE],[C_MA],[C_MOTA] FROM " +
"[V_DM_PHANXUONG_KMP] where PK_KMP = " + pk_KMP + " and TYLE > 0");
if (dtLink.Rows.Count > 0)
{
foreach (DataRow row in dtLink.Rows)
{
T_DM_FCM_DETAILModel detail = new T_DM_FCM_DETAILModel();
detail.FK_FCM = fcm.ID;
detail.FK_PHANXUONG = TextUtils.ToInt(row["PK_PHANXUONG"]);
detail.FK_KMP = pk_KMP;
detail.C_PRICE = TextUtils.ToDecimal(row["TYLE"]) * c_Price / 100;
pt.Insert(detail);
}
}
}
else
{
T_DM_FCM_DETAILModel detail = new T_DM_FCM_DETAILModel();
detail.FK_FCM = fcm.ID;
detail.FK_PHANXUONG = TextUtils.ToInt(grvData.GetRowCellValue(i, colDepartmentID));
detail.FK_KMP = pk_KMP;
detail.C_PRICE = c_Price;
pt.Insert(detail);
}
}
#endregion
pt.CommitTransaction();
if (this.LoadDataChange != null)
{
this.LoadDataChange(null, null);
}
MessageBox.Show("Lưu trữ thành công!", TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
pt.CloseConnection();
}
}
}
