private void btnSave_Click(object sender, EventArgs e)
{
DataTable dtUserKCS = LibQLSX.Select("select top 1 * from Users where Account = '" + Global.AppUserName + "'");
if (dtUserKCS.Rows.Count == 0)
{
MessageBox.Show("Tài khoản đăng nhập không có trên QLSX", TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Stop);
//pt.CloseConnection();
return;
}
decimal OK = 0;
decimal NG = 0;
//ProcessTransaction pt = new ProcessTransaction();
//pt.OpenConnection();
//pt.BeginTransaction();
if (!ValidateForm())
{
//pt.CloseConnection();
return;
}
grvData.FocusedRowHandle = -1;
try
{
for (int i = 0; i < grvData.RowCount; i++)
{
string criteriaImportId = TextUtils.ToString(grvData.GetRowCellValue(i, colCriteriaImportId));
CriteriaImportModel model = new CriteriaImportModel();
if (criteriaImportId != "")
{
ArrayList arr = CriteriaImportBO.Instance.FindByAttribute("CriteriaImportId", criteriaImportId);
model = (CriteriaImportModel)arr[0];
}
model.CriteriaName = "Đúng thông số, kích thước kỹ thuật.";
model.ValueRequest = "Vật tư, thiết bị đảm bảo chất lượng.";
model.CriteriaIndex = TextUtils.ToInt(grvData.GetRowCellValue(i, colSTT));
model.IsHalf = TextUtils.ToBoolean(grvData.GetRowCellValue(i, colIsHalf));
model.ProductPartsImportId = ProductPartsImport.ProductPartsImportId;
bool status = TextUtils.ToBoolean(grvData.GetRowCellValue(i, colStatus));
model.Status = status ? 1 : 0;
model.ValueResult = TextUtils.ToString(grvData.GetRowCellValue(i, colValueResult));
//model.CriteriaIndex = TextUtils.ToInt(grvData.GetRowCellValue(i, colCriteriaImportId));
if (criteriaImportId != "")
{
CriteriaImportBO.Instance.UpdateQLSX(model);
}
else
{
DataTable dt = LibQLSX.Select("SELECT top 1 CriteriaImportId FROM CriteriaImport order by CriteriaImportId desc");
if (dt.Rows.Count > 0)
{
criteriaImportId = TextUtils.ToString(dt.Rows[0]["CriteriaImportId"]);
string number = criteriaImportId.Substring(2, 8);
criteriaImportId = "CI" + string.Format("{0:00000000}", TextUtils.ToInt(number) + 1);
}
model.CriteriaImportId = criteriaImportId;
CriteriaImportBO.Instance.InsertQLSX(model);
}
if (model.Status == 1)
{
OK++;
}
else
{
NG++;
}
}
ProductPartsImport.UserId = TextUtils.ToString(dtUserKCS.Rows[0]["UserId"]);
ProductPartsImport.TotalOK = Qty % 1 == 0 ? OK : Qty;
ProductPartsImport.TotalNG = Qty % 1 == 0 ? NG : Qty; //NG;
ProductPartsImportBO.Instance.UpdateQLSX(ProductPartsImport);
//pt.CommitTransaction();
loadGrid();
_isSaved = true;
MessageBox.Show("Tác vụ thành công!", TextUtils.Caption,
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show("Tác vụ 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 CriteriaImportFacade(CriteriaImportModel model) : base(model)
{
}
