private void btnApprove_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Bạn có chắc muốn xóa hoàn toàn những file này không?",
TextUtils.Caption, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
return;
}
foreach (int item in grvGrid.GetSelectedRows())
{
int mID = TextUtils.ToInt(grvGrid.GetRowCellValue(item, colMaterialFileID));
ProcessTransaction pt = new ProcessTransaction();
pt.OpenConnection();
pt.BeginTransaction();
try
{
//Delete file in ftp
DocUtils.DeleteFile(grvGrid.GetRowCellValue(item, colPath).ToString());
//
pt.Delete("MaterialFile", mID);
pt.DeleteByAttribute("MaterialFileLink", "MaterialFileID", mID.ToString());
pt.CommitTransaction();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
pt.CloseConnection();
}
}
}
private void btnDel_Click(object sender, EventArgs e)
{
ProcessTransaction pt = new ProcessTransaction();
pt.OpenConnection();
pt.BeginTransaction();
try
{
if (grvData.DataSource == null)
{
return;
}
int id = TextUtils.ToInt(grvData.GetFocusedRowCellValue(colID));
if (id == 0)
{
return;
}
if (MaterialFileLinkBO.Instance.CheckExist("MaterialID", id))
{
if (MessageBox.Show("Vật tư [" + grvData.GetFocusedRowCellValue(colName).ToString() + "] đang liên kết với các file thư viện.\n Bạn có thật sự muốn xóa nó không?",
TextUtils.Caption, MessageBoxButtons.YesNo, MessageBoxIcon.Stop) == DialogResult.No)
{
return;
}
DataTable dt = TextUtils.Select("select Path,MaterialID,MaterialCode from vMaterialFile with(nolock) where FileType = 0 and MaterialID = " + id);
if (dt.Rows.Count > 0)
{
DocUtils.InitFTPTK();
DocUtils.DeleteFile(dt.Rows[0][0].ToString());
}
pt.Delete("Material", id);
pt.DeleteByAttribute("MaterialConnect", "MaterialID", id.ToString());
pt.DeleteByAttribute("MaterialParameterLink", "MaterialID", id.ToString());
pt.DeleteByAttribute("MaterialFileLink", "MaterialID", id.ToString());
}
else
{
if (MessageBox.Show("Bạn có chắc muốn xóa vật tư [" + grvData.GetFocusedRowCellValue(colName).ToString() + "] không?",
TextUtils.Caption, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
return;
}
pt.Delete("Material", id);
pt.DeleteByAttribute("MaterialConnect", "MaterialID", id.ToString());
pt.DeleteByAttribute("MaterialParameterLink", "MaterialID", id.ToString());
}
pt.CommitTransaction();
LoadInfoSearch();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
pt.CloseConnection();
}
}
private void btnSave_Click(object sender, EventArgs e)
{
ProcessTransaction pt = new ProcessTransaction();
pt.OpenConnection();
pt.BeginTransaction();
try
{
if (!checkValid())
{
return;
}
ModuleErrorTypeModel model;
if (_isAdd)
{
model = new ModuleErrorTypeModel();
}
else
{
model = (ModuleErrorTypeModel)ModuleErrorTypeBO.Instance.FindByPK(_id);
}
//model.Type = cboType.SelectedIndex;
model.Type = 0;
model.Name = txtName.Text.Trim();
model.GroupID = (int)cboGroup.SelectedValue;
if (_isAdd)
{
pt.Insert(model);
}
else
{
pt.Update(model);
}
pt.CommitTransaction();
if (model.GroupID == 0)
{
loadGroup();
}
loadTree();
SetInterface(false);
ClearInterface();
_isSaved = true;
}
catch (Exception ex)
{
TextUtils.ShowError("Lưu trữ không thành công!", ex);
}
finally
{
pt.CloseConnection();
}
}
private void btnSaveN_Click(object sender, EventArgs e)
{
ProcessTransaction pt = new ProcessTransaction();
pt.OpenConnection();
pt.BeginTransaction();
try
{
if (checkValidN())
{
MaterialParametersModel model = new MaterialParametersModel();
if (isAddN)
{
model.CreatedDate = TextUtils.GetSystemDate();
model.CreatedBy = Global.AppUserName;
model.UpdatedDate = model.CreatedDate;
model.UpdatedBy = Global.AppUserName;
}
else
{
int ID = Convert.ToInt32(grvDataN.GetFocusedRowCellValue(colID).ToString());
model = (MaterialParametersModel)MaterialParametersBO.Instance.FindByPK(ID);
model.UpdatedDate = model.CreatedDate;
model.UpdatedBy = Global.AppUserName;
}
model.Name = txtNameN.Text;
model.MaterialGroupID = TextUtils.ToInt(cboMaterialGroupN.EditValue);
if (isAddN)
{
DataTable dt = TextUtils.Select("SELECT isnull(MAX(STT),0) FROM MaterialParameters with(nolock) where MaterialParameters.MaterialGroupID = " + model.MaterialGroupID);
model.STT = TextUtils.ToInt(dt.Rows[0][0].ToString()) + 1;
pt.Insert(model);
}
else
{
pt.Update(model);
}
pt.CommitTransaction();
loadGridParasN();
SetInterfaceN(false);
cboMaterialGroupN.Enabled = true;
ClearInterfaceN();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
pt.CloseConnection();
}
}
private void btnCopyN_Click(object sender, EventArgs e)
{
//chuyển thông số đích sang nguồns
int groupID = TextUtils.ToInt(cboMaterialGroupN.EditValue);
if (groupID == 0)
{
MessageBox.Show("Bạn hãy chọn nhóm vật tư.", TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Stop);
return;
}
foreach (int rowHandle in grvData.GetSelectedRows())
{
string name = grvData.GetRowCellValue(rowHandle, colNameN).ToString();
DataTable dt;
dt = TextUtils.Select("select Name from MaterialParameters where MaterialGroupID =" + groupID + " and Name = N'" + name + "'");
if (dt != null)
{
if (dt.Rows.Count > 0)
{
MessageBox.Show("Tên thông số [" + name + "] này đã tồn tại!", TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Stop);
continue;
}
}
ProcessTransaction pt = new ProcessTransaction();
pt.OpenConnection();
pt.BeginTransaction();
try
{
MaterialParametersModel model = new MaterialParametersModel();
model.CreatedDate = TextUtils.GetSystemDate();
model.CreatedBy = Global.AppUserName;
model.UpdatedDate = model.CreatedDate;
model.UpdatedBy = Global.AppUserName;
model.Name = grvData.GetRowCellValue(rowHandle, colNameN).ToString();
model.MaterialGroupID = TextUtils.ToInt(cboMaterialGroupN.EditValue);
DataTable dtmax = TextUtils.Select("SELECT isnull(MAX(STT),0) FROM MaterialParameters with(nolock) where MaterialParameters.MaterialGroupID = "
+ model.MaterialGroupID);
model.STT = TextUtils.ToInt(dtmax.Rows[0][0].ToString()) + 1;
pt.Insert(model);
pt.CommitTransaction();
loadGridParasN();
}
catch (Exception)
{
}
finally
{
pt.CloseConnection();
}
}
}
void save(bool close)
{
ProcessTransaction pt = new ProcessTransaction();
pt.OpenConnection();
pt.BeginTransaction();
try
{
if (!ValidateForm())
{
return;
}
if (CoCau.ID == 0)
{
CoCau = new CoCauMauModel();
}
CoCau.Name = txtName.Text.Trim().ToUpper();
CoCau.Code = txtCode.Text.Trim().ToUpper();
CoCau.CoCauGroupID = TextUtils.ToInt(cboGroup.EditValue);
//CoCau.Note = txtDescription.Text.Trim();
CoCau.Description = txtDescription.Text.Trim();
CoCau.Specifications = txtTSKT.Text.Trim();
CoCau.ImagePath = pictureBox1.ImageLocation;
if (CoCau.ID == 0)
{
CoCau.ID = (int)pt.Insert(CoCau);
}
else
{
pt.Update(CoCau);
}
pt.CommitTransaction();
_isSaved = true;
if (close)
{
this.DialogResult = DialogResult.OK;
}
else
{
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();
}
}
void save()
{
mnuMenu.Focus();
ProcessTransaction pt = new ProcessTransaction();
pt.OpenConnection();
pt.BeginTransaction();
try
{
if (!ValidateForm())
{
return;
}
PartBorrow.DateBorrow = (DateTime?)dtpDateBorrow.EditValue;
PartBorrow.DateReturn = (DateTime?)dtpDateReturn.EditValue;
PartBorrow.DateReturnExpected = (DateTime?)dtpDateReturnExpected.EditValue;
PartBorrow.Price = TextUtils.ToDecimal(txtPrice.EditValue);
PartBorrow.Qty = TextUtils.ToDecimal(txtQty.EditValue);
PartBorrow.QtyBorrow = TextUtils.ToDecimal(txtQtyBorrow.EditValue);
PartBorrow.QtyReturn = TextUtils.ToDecimal(txtQtyReturn.EditValue);
PartBorrow.Total = TextUtils.ToDecimal(txtTotal.EditValue);
PartBorrow.Description = txtDescription.Text.Trim();
PartBorrow.PartsId = TextUtils.ToString(cboPart.EditValue);
PartBorrow.Unit = TextUtils.ToString(cboUnit.SelectedValue);
PartBorrow.UserId = TextUtils.ToString(cboUser.EditValue);
if (PartBorrow.ID == 0)
{
PartBorrow.ID = (long)pt.Insert(PartBorrow);
}
else
{
pt.Update(PartBorrow);
}
pt.CommitTransaction();
_isSaved = true;
MessageBox.Show("Lưu trữ thành công!", TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Information);
if (this.LoadDataChange != null)
{
this.LoadDataChange(null, null);
}
}
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();
}
}
private void btnSave_Click(object sender, EventArgs e)
{
ProcessTransaction pt = new ProcessTransaction();
pt.OpenConnection();
pt.BeginTransaction();
try
{
Model.Name = txtName.Text.Trim();
Model.ParentID = TextUtils.ToInt(cboParent.SelectedValue);
Model.Type = Type;
Model.Description = txtDes.Text.Trim();
Model.Extension = txtExtension.Text.Trim();
Model.Contain = txtContain.Text.Trim();
if (ParentID == 0)
{
Model.ParentPath = DPath;
Model.Path = Path.Combine(DPath, txtName.Text.Trim());
}
else
{
Model.ParentPath = ((DesignStructureModel)DesignStructureBO.Instance.FindByPK(ParentID)).Path;
Model.Path = Path.Combine(Model.ParentPath, txtName.Text.Trim());
}
if (Model.ID == 0)
{
Model.CreatedDate = TextUtils.GetSystemDate();
Model.CreatedBy = Global.AppUserName;
Model.UpdatedDate = Model.CreatedDate;
Model.UpdatedBy = Global.AppUserName;
Model.ID = (int)pt.Insert(Model);
}
else
{
Model.UpdatedDate = TextUtils.GetSystemDate();
Model.UpdatedBy = Global.AppUserName;
pt.Update(Model);
}
CurentNode = Model.ID;
pt.CommitTransaction();
this.DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
pt.CloseConnection();
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
using (WaitDialogForm fWait = new WaitDialogForm("Vui lòng chờ trong giây lát...", "Đang xóa file..."))
{
if (grvData.RowCount <= 0)
{
return;
}
int materialFileID = TextUtils.ToInt(grvData.GetFocusedRowCellValue(colID));
if (materialFileID == 0)
{
return;
}
string filePath = grvData.GetFocusedRowCellValue(colPath).ToString();
string fileName = grvData.GetFocusedRowCellValue(colFileName).ToString();
DataTable dt = TextUtils.Select("MaterialFileLink", new Expression("MaterialFileID", materialFileID));
if (dt.Rows.Count >= 1)
{
MessageBox.Show("File [" + fileName + "]" + " đã được đính kèm với nhiều vật tư.\n Bạn không thế xóa file này!", TextUtils.Caption,
MessageBoxButtons.OK, MessageBoxIcon.Question);
return;
}
if (MessageBox.Show("Bạn có thật sự muốn xóa file [" + fileName + "] này không?", TextUtils.Caption,
MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
return;
}
ProcessTransaction pt = new ProcessTransaction();
pt.OpenConnection();
pt.BeginTransaction();
try
{
pt.Delete("MaterialFile", materialFileID);
pt.DeleteByAttribute("MaterialFileLink", "MaterialFileID", materialFileID.ToString());
DocUtils.DeleteFile(filePath);
pt.CommitTransaction();
}
catch (Exception)
{
}
finally
{
pt.CloseConnection();
}
loadGrid();
}
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
if (checkValid())
{
ProcessTransaction pt = new ProcessTransaction();
pt.OpenConnection();
pt.BeginTransaction();
if (!isAdd)
{
_model = (ConfigSystemModel)ConfigSystemBO.Instance.FindByPK(TextUtils.ToInt(grvData.GetFocusedRowCellValue(colID)));
}
_model.KeyName = txtKey.Text.Trim();
_model.KeyValue = txtDuongDan.Text.Trim();
_model.Description = txtMoTa.Text.Trim();
if (isAdd)
{
_model.CreatedDate = TextUtils.GetSystemDate();
_model.CreatedBy = Global.AppUserName;
_model.UpdatedDate = _model.CreatedDate;
_model.UpdatedBy = Global.AppUserName;
_model.ID = (int)pt.Insert(_model);
}
else
{
_model.UpdatedDate = TextUtils.GetSystemDate();
_model.UpdatedBy = Global.AppUserName;
pt.Update(_model);
}
pt.CommitTransaction();
pt.CloseConnection();
LoadData();
if (isAdd)
{
MessageBox.Show("Tạo mới thành công!");
}
else
{
MessageBox.Show("Cập nhật thành công!");
}
SetInterface(false);
ClearInterface();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
ProcessTransaction pt = new ProcessTransaction();
pt.OpenConnection();
pt.BeginTransaction();
try
{
if (!ValidateForm())
{
return;
}
Model.Code = txtCode.Text.Trim();
Model.Name = txtName.Text.Trim();
Model.TotalTime = (double)txtTotalTime.Value;
Model.ProductID = TextUtils.ToInt(leProducts.EditValue);
Model.WorkStatusID = cboStatus.SelectedIndex;
Model.WorkTypeID = cboWorkType.SelectedIndex;
Model.Type = cboType.SelectedIndex;
Model.TotalScore = TextUtils.ToDouble(txtTotalScore.Value);
Model.Priority = TextUtils.ToInt(txtPriority.Value);
Model.Description = txtDescription.Text.Trim();
if (Model.ID == 0)
{
Model.CreatedDate = TextUtils.GetSystemDate();
Model.CreatedBy = Global.AppUserName;
Model.UpdatedDate = Model.CreatedDate;
Model.UpdatedBy = Global.AppUserName;
Model.ID = (int)pt.Insert(Model);
}
else
{
Model.UpdatedDate = TextUtils.GetSystemDate();
Model.UpdatedBy = Global.AppUserName;
pt.Update(Model);
}
pt.CommitTransaction();
MessageBox.Show("Lưu trữ thành công!", "Thông báo");
this.DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{ pt.CloseConnection(); }
}
private void btnSave_Click(object sender, EventArgs e)
{
ProcessTransaction pt = new ProcessTransaction();
pt.OpenConnection();
pt.BeginTransaction();
try
{
if (checkValid())
{
CostDetailModel dModel;
if (_isAdd)
{
dModel = new CostDetailModel();
}
else
{
int ID = TextUtils.ToInt(grvData.GetFocusedRowCellValue(colID));
dModel = (CostDetailModel)CostDetailBO.Instance.FindByPK(ID);
}
dModel.Code = txtCode.Text.Trim();
dModel.Name = txtName.Text.Trim();
dModel.Description = txtDescription.Text.Trim();
dModel.Type = cboCostType.SelectedIndex;
dModel.IsFix = chkIsFix.Checked ? 1 : 0;
dModel.DepartmentID = TextUtils.ToInt(cboDepartment.EditValue);
if (_isAdd)
{
pt.Insert(dModel);
}
else
{
pt.Update(dModel);
}
pt.CommitTransaction();
loadData();
SetInterface(false);
ClearInterface();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
pt.CloseConnection();
}
}
private void btnDeleteFile_Click(object sender, EventArgs e)
{
using (WaitDialogForm fWait = new WaitDialogForm("Vui lòng chờ trong giây lát...", "Đang xóa file lên server!"))
{
DocUtils.InitFTPTK();
if (grvDataImage.RowCount <= 0)
{
return;
}
int id = TextUtils.ToInt(grvDataImage.SelectedRows[0].Cells[colID.Name].Value);
if (id == 0)
{
return;
}
string filePath = grvDataImage.SelectedRows[0].Cells[colFilePath.Name].Value.ToString();
string fileName = grvDataImage.SelectedRows[0].Cells[colFileName.Name].Value.ToString();
if (MessageBox.Show("Bạn có thật sự muốn xóa file [" + fileName + "] này không?", TextUtils.Caption,
MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
return;
}
ProcessTransaction pt = new ProcessTransaction();
pt.OpenConnection();
pt.BeginTransaction();
try
{
pt.Delete("MisMatchImage", id);
if (DocUtils.CheckExits(filePath))
{
DocUtils.DeleteFile(filePath);
}
pt.CommitTransaction();
}
catch (Exception ex)
{
MessageBox.Show("Xóa file [" + fileName + "] không thành công!" + Environment.NewLine + ex.Message,
TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Stop);
}
finally
{
pt.CloseConnection();
}
loadGridImage();
}
}
private void btnDeleteFile_Click(object sender, EventArgs e)
{
DocUtils.InitFTPTK();
if (grvFile.RowCount <= 0)
{
return;
}
int id = TextUtils.ToInt(grvFile.GetFocusedRowCellValue(colFileID));
string filePath = TextUtils.ToString(grvFile.GetFocusedRowCellValue(colFileLocalPath));
string fileName = Path.GetFileName(filePath);
if (MessageBox.Show("Bạn có thật sự muốn xóa file [" + fileName + "] này không?", TextUtils.Caption,
MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
return;
}
if (id == 0)
{
grvFile.DeleteSelectedRows();
}
else
{
ProcessTransaction pt = new ProcessTransaction();
pt.OpenConnection();
pt.BeginTransaction();
try
{
pt.Delete("SolutionFile", id);
if (DocUtils.CheckExits(filePath))
{
DocUtils.DeleteFile(filePath);
}
pt.CommitTransaction();
grvFile.DeleteSelectedRows();
}
catch (Exception ex)
{
MessageBox.Show("Xóa file [" + fileName + "] không thành công!" + Environment.NewLine + ex.Message,
TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Stop);
}
finally
{
pt.CloseConnection();
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
ProcessTransaction pt = new ProcessTransaction();
pt.OpenConnection();
pt.BeginTransaction();
try
{
if (!ValidateForm())
{
return;
}
if (Model == null)
{
Model = new FormAndFunctionModel();
}
Model.Name = txtName.Text.Trim();
Model.Code = txtCode.Text.Trim();
Model.FormAndFunctionGroupID = TextUtils.ToInt(leParentCat.EditValue);
Model.IsHide = false;
if (Model.ID == 0)
{
Model.CreatedDate = TextUtils.GetSystemDate();
Model.CreatedBy = Global.AppUserName;
Model.UpdatedDate = Model.CreatedDate;
Model.UpdatedBy = Global.AppUserName;
Model.ID = (int)pt.Insert(Model);
}
else
{
Model.UpdatedDate = TextUtils.GetSystemDate();
Model.UpdatedBy = Global.AppUserName;
pt.Update(Model);
}
pt.CommitTransaction();
this.DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
pt.CloseConnection();
}
}
void save()
{
ProcessTransaction pt = new ProcessTransaction();
pt.OpenConnection();
pt.BeginTransaction();
try
{
if (!ValidateForm())
{
return;
}
//PartA.Name = txtName.Text.Trim().ToUpper();
//PartA.Code = txtCode.Text.Trim().ToUpper();
//PartA.Type = cboType.SelectedIndex;
//PartA.Unit = txtUnit.Text.Trim();
PartA.QtyMin = TextUtils.ToDecimal(txtQtyMin.EditValue);
PartA.QtyDM = TextUtils.ToDecimal(txtQtyDM.EditValue);
PartA.ProjectPercent = TextUtils.ToDecimal(txtProjectPercent.EditValue);
//PartA.Price = TextUtils.ToDecimal(txtPrice.EditValue);
PartA.IsProject = PartA.ProjectPercent > 0 ? 1 : 0;
PartA.Qty = TextUtils.ToDecimal(txtQty.EditValue);
//PartA.Hang = txtHang.Text.Trim();
//if (PartA.ID == 0)
//{
// PartA.ID = (int)pt.Insert(PartA);
//}
//else
//{
pt.UpdateQLSX(PartA);
//}
pt.CommitTransaction();
_isSaved = true;
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)
{
ProcessTransaction pt = new ProcessTransaction();
pt.OpenConnection();
pt.BeginTransaction();
try
{
PayVouchersModel dModel;
if (_isAdd)
{
dModel = new PayVouchersModel();
}
else
{
int ID = TextUtils.ToInt(grvData.GetFocusedRowCellValue(colID));
dModel = (PayVouchersModel)PayVouchersBO.Instance.FindByPK(ID);
}
if (!checkValid(dModel))
{
return;
}
dModel.Name = txtName.Text.Trim();
dModel.Type = cboType.SelectedIndex;
if (_isAdd)
{
pt.Insert(dModel);
}
else
{
pt.Update(dModel);
}
pt.CommitTransaction();
loadData();
SetInterface(false);
ClearInterface();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
pt.CloseConnection();
}
}
private void btnSave_Click(object sender, EventArgs e)
{
ProcessTransaction pt = new ProcessTransaction();
pt.OpenConnection();
pt.BeginTransaction();
try
{
Model.Name = txtName.Text.Trim();
Model.ParentID = TextUtils.ToInt(cboParent.SelectedValue);
Model.DepartmentID = DepartmentID;
Model.Description = txtDes.Text.Trim();
Model.FolderType = cboFolderType.SelectedIndex;
if (ParentID == 0)
{
Model.ParentPath = DPath;
Model.Path = Path.Combine(DPath, txtName.Text.Trim());
}
else
{
Model.ParentPath = ((PBDLStructureModel)PBDLStructureBO.Instance.FindByPK(ParentID)).Path;
Model.Path = Path.Combine(Model.ParentPath, txtName.Text.Trim());
}
if (Model.ID == 0)
{
Model.ID = (int)pt.Insert(Model);
}
else
{
pt.Update(Model);
}
CurentNode = Model.ID;
pt.CommitTransaction();
this.DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
pt.CloseConnection();
}
}
void CreateVersion(BaiThucHanhModel BaiThucHanh)
{
ProcessTransaction pt = new ProcessTransaction();
pt.OpenConnection();
pt.BeginTransaction();
try
{
// Tạo phiên bản bài thực hành
BaiThucHanhVersionModel versionModel = new BaiThucHanhVersionModel();
versionModel.BaiThucHanhID = BaiThucHanh.ID;
versionModel.Reason = "Tạo phiên bản đầu tiên";
versionModel.Version = BaiThucHanh.Version;
versionModel.ID = (int)pt.Insert(versionModel);
//Tạo các phiên bản module bài thực hành
ArrayList lisModules = BaiThucHanhModuleBO.Instance.FindByAttribute("BaiThucHanhID", BaiThucHanh.ID);
if (lisModules.Count > 0)
{
foreach (var item in lisModules)
{
BaiThucHanhModuleModel thisModule = (BaiThucHanhModuleModel)item;
BaiThucHanhModuleVersionModel moduleVersion = new BaiThucHanhModuleVersionModel();
moduleVersion.BTHVersionID = versionModel.ID;
moduleVersion.Code = thisModule.Code;
moduleVersion.CVersion = thisModule.CVersion;
moduleVersion.Hang = thisModule.Hang;
moduleVersion.Name = thisModule.Name;
moduleVersion.Qty = thisModule.Qty;
moduleVersion.Type = thisModule.Type;
moduleVersion.ID = (int)pt.Insert(moduleVersion);
}
}
pt.CommitTransaction();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
pt.CloseConnection();
}
}
private void btnDeleteApprove_Click(object sender, EventArgs e)
{
ProcessTransaction pt = new ProcessTransaction();
pt.OpenConnection();
pt.BeginTransaction();
try
{
for (int i = 0; i < grvData.RowCount; i++)
{
if (grvData.DataSource == null)
{
return;
}
int id = TextUtils.ToInt(grvData.GetRowCellValue(i, colID));
if (id == 0)
{
return;
}
File3DModel model = (File3DModel)File3DBO.Instance.FindByPK(id);
if (!model.IsDeleted)
{
continue;
}
if (MessageBox.Show("Bạn có chắc muốn duyệt xóa file [" + grvData.GetFocusedRowCellValue(colName).ToString() + "] ?",
TextUtils.Caption, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
continue;
}
pt.Delete("File3D", id);
File.Delete(model.Path);
}
pt.CommitTransaction();
LoadInfoSearch();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
pt.CloseConnection();
}
}
void save(bool close)
{
ProcessTransaction pt = new ProcessTransaction();
pt.OpenConnection();
pt.BeginTransaction();
try
{
if (!ValidateForm())
{
return;
}
MisMatch.StatusTK = cboStatus.SelectedIndex;
if (MisMatch.ID == 0)
{
MisMatch.ID = (int)pt.Insert(MisMatch);
}
else
{
pt.Update(MisMatch);
}
pt.CommitTransaction();
_isSaved = true;
if (close)
{
this.DialogResult = DialogResult.OK;
}
else
{
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 btnChooseFile_Click(object sender, EventArgs e)
{
frmDatasheet frm = new frmDatasheet();
frm.ChooseFile = true;
frm.CustomerID = Material.CustomerID;
frm.Text += ": " + Material.Code + " - " + Material.Name;
bool added = false;
if (frm.ShowDialog() == DialogResult.OK)
{
foreach (int item in frm.ListMaterialFileID)
{
ProcessTransaction pt = new ProcessTransaction();
pt.OpenConnection();
pt.BeginTransaction();
try
{
MaterialFileLinkModel model = new MaterialFileLinkModel();
model.MaterialID = Material.ID;
model.MaterialFileID = item;
pt.Insert(model);
added = true;
if (added)
{
//MaterialModel material = (MaterialModel)MaterialBO.Instance.FindByPK(Material.ID);
Material.FileDatasheet = 1;
pt.Update(Material);
}
pt.CommitTransaction();
}
catch (Exception)
{
}
finally
{
pt.CloseConnection();
}
}
loadDatasheet();
}
}
private void btnDeleteGroup_Click(object sender, EventArgs e)
{
if (grvData.RowCount > 0)
{
if (MessageBox.Show("Bạn có chắc chắn muốn xóa?", TextUtils.Caption, MessageBoxButtons.YesNo) == DialogResult.Yes)
{
ProcessTransaction pt = new ProcessTransaction();
pt.OpenConnection();
pt.BeginTransaction();
int id = (int)grvData.GetRowCellValue(grvData.FocusedRowHandle, "ID");
pt.Delete("VatTuThayThe", id);
pt.CommitTransaction();
pt.CloseConnection();
LoadGrid();
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
ProcessTransaction pt = new ProcessTransaction();
pt.OpenConnection();
pt.BeginTransaction();
try
{
if (!ValidateForm())
{
return;
}
if (Model == null)
{
Model = new BaiThucHanhGroupModel();
}
Model.Name = txtName.Text.Trim().ToUpper();
Model.Code = txtCode.Text.Trim().ToUpper();
Model.Description = txtDescription.Text.Trim();
Model.ParentID = TextUtils.ToInt(leParentCat.EditValue);
if (Model.ID == 0)
{
Model.ID = (int)pt.Insert(Model);
}
else
{
pt.Update(Model);
}
pt.CommitTransaction();
CurentNode = Model.ID;
this.DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
pt.CloseConnection();
}
}
void save(bool close)
{
ProcessTransaction pt = new ProcessTransaction();
pt.OpenConnection();
pt.BeginTransaction();
try
{
if (!ValidateForm())
{
return;
}
Product.CostGroupID = TextUtils.ToInt(cboCostGroup.EditValue);
pt.Update(Product);
pt.CommitTransaction();
_isSaved = true;
if (close)
{
this.DialogResult = DialogResult.OK;
}
else
{
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();
}
if (_isSaved && close)
{
this.Close();
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
ProcessTransaction pt = new ProcessTransaction();
pt.OpenConnection();
pt.BeginTransaction();
try
{
if (grvData.DataSource == null)
{
return;
}
int id = TextUtils.ToInt(grvData.GetFocusedRowCellValue(colID));
if (id == 0)
{
return;
}
if (MessageBox.Show("Bạn có chắc muốn xóa vật tư [" + grvData.GetFocusedRowCellValue(colCode).ToString() + "] không?",
TextUtils.Caption, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
return;
}
pt.DeleteByAttribute("BaoGiaItem", "BaoGiaID", id.ToString());
pt.Delete("BaoGia", id);
pt.CommitTransaction();
LoadInfoSearch();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
pt.CloseConnection();
}
}
private void btnDeleteN_Click(object sender, EventArgs e)
{
if (!grvDataN.IsDataRow(grvDataN.FocusedRowHandle))
{
return;
}
int strID = TextUtils.ToInt(grvDataN.GetRowCellValue(grvDataN.FocusedRowHandle, "ID").ToString());
string strName = grvDataN.GetRowCellValue(grvDataN.FocusedRowHandle, "Name").ToString();
if (MessageBox.Show(String.Format("Bạn có chắc muốn xóa thông số [{0}] không?", strName), TextUtils.Caption, MessageBoxButtons.YesNo,
MessageBoxIcon.Question) == DialogResult.No)
{
return;
}
ProcessTransaction pt = new ProcessTransaction();
pt.OpenConnection();
pt.BeginTransaction();
try
{
pt.Delete("MaterialParameters", strID);
loadGridParasN();
pt.DeleteByAttribute("MaterialConnect", "MaterialParameterID", strID.ToString());
pt.DeleteByAttribute("MaterialParameterValue", "MaterialParameterID", strID.ToString());
pt.CommitTransaction();
}
catch
{
MessageBox.Show("Có lỗi xảy ra khi thực hiện thao tác, xin vui lòng thử lại sau.");
}
finally
{
pt.CloseConnection();
}
}
private void btnSaveTS_Click(object sender, EventArgs e)
{
ProcessTransaction pt = new ProcessTransaction();
pt.OpenConnection();
pt.BeginTransaction();
try
{
//Lưu trữ giá trị thông số
saveGiaTri(pt);
_isSaved = true;
pt.CommitTransaction();
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();
}
}
private void btnAddFile_Click(object sender, EventArgs e)
{
//KcsError
string criteriaImportId = TextUtils.ToString(grvData.GetFocusedRowCellValue(colCriteriaImportId));
//string orderCode = TextUtils.ToString(grvOrder.GetFocusedRowCellValue(colSoDonHang));
if (criteriaImportId == "")
{
return;
}
DocUtils.InitFTPTK();
OpenFileDialog ofd = new OpenFileDialog();
ofd.Multiselect = true;
if (ofd.ShowDialog() == DialogResult.OK)
{
foreach (string filePath in ofd.FileNames)
{
FileInfo fInfo = new FileInfo(filePath);
ProcessTransaction pt = new ProcessTransaction();
pt.OpenConnection();
pt.BeginTransaction();
try
{
CriteriaImportImageModel model = new CriteriaImportImageModel();
model.CriteriaImportId = criteriaImportId;
model.FileName = fInfo.Name;
//model.FileLocalPath = fInfo.FullName;
model.FilePath = "KcsError\\" + criteriaImportId + "\\" + fInfo.Name;
model.Size = fInfo.Length;
model.DateCreated = TextUtils.GetSystemDate();
pt.Insert(model);
if (!DocUtils.CheckExits("KcsError\\" + criteriaImportId + "\\"))
{
DocUtils.MakeDir("KcsError\\" + criteriaImportId + "\\");
}
bool status = DocUtils.UploadFileWithStatus(filePath, "KcsError\\" + criteriaImportId);
if (status)
{
pt.CommitTransaction();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
pt.CloseConnection();
}
}
loadImge(criteriaImportId);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
ProcessTransaction pt = new ProcessTransaction();
pt.OpenConnection();
pt.BeginTransaction();
try
{
if (!ValidateForm())
{
return;
}
WorkDiary.EndDateDK = dtpEndDateDK.Value;
WorkDiary.GhiChu = txtNote.Text.Trim();
WorkDiary.ModuleCode = txtModuleCode.Text.Trim();
WorkDiary.Name = txtName.Text.Trim();
WorkDiary.ProjectCode = txtProjectCode.Text.Trim();
WorkDiary.StartDate = dtpStartDate.Value;
WorkDiary.Status = cboStatus.SelectedIndex;
//WorkDiary.ThoiGianDuKien = TextUtils.ToInt(txtTime.EditValue);
WorkDiary.UserID = TextUtils.ToInt(cboUser.EditValue);
if (cboStatus.SelectedIndex == 1)
{
WorkDiary.EndDate = DateTime.Now;
}
else
{
WorkDiary.EndDate = null;
}
if (WorkDiary.ID == 0)
{
WorkDiary.ID = (int)pt.Insert(WorkDiary);
TheoDoiHistoryModel history = new TheoDoiHistoryModel();
history.EndDateDK = WorkDiary.EndDateDK;
history.TheoDoiID = WorkDiary.ID;
history.Reason = "Thêm mới";
pt.Insert(history);
}
else
{
pt.Update(WorkDiary);
if (_oldEndDateDK.Date != dtpEndDateDK.Value)
{
TheoDoiHistoryModel history = new TheoDoiHistoryModel();
history.EndDateDK = WorkDiary.EndDateDK;
history.TheoDoiID = WorkDiary.ID;
history.Reason = txtReason.Text.Trim();
pt.Insert(history);
}
}
pt.CommitTransaction();
loadHistory();
_isSaved = true;
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 && this.LoadDataChange != null)
{
this.LoadDataChange(null, null);
}
}