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 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 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 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 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();
}
}
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();
}
}
}
void saveGiaTri(ProcessTransaction pt)
{
if (treeValue.Nodes.Count == 0)
{
return;
}
int paraID = TextUtils.ToInt(grvData.GetFocusedRowCellValue(colID));
if (paraID == 0)
{
return;
}
if (Material.ID <= 0)
{
return;
}
for (int i = 0; i < treeValue.Nodes.Count; i++)
{
int valID = TextUtils.ToInt(treeValue.GetNodeByVisibleIndex(i).GetValue(colIDValue));
DataTable dt = TextUtils.Select("MaterialConnect", new Expression("MaterialID", Material.ID)
.And(new Expression("MaterialParameterID", paraID))
.And(new Expression("MaterialParameterValueID", valID)));
if (dt.Rows.Count > 0)
{
if (!treeValue.GetNodeByVisibleIndex(i).Checked)
{
pt.Delete("MaterialConnect", TextUtils.ToInt(dt.Rows[0]["ID"]));
}
}
else
{
if (treeValue.GetNodeByVisibleIndex(i).Checked)
{
MaterialConnectModel modelM = new MaterialConnectModel();
modelM.MaterialID = Material.ID;
modelM.MaterialParameterID = TextUtils.ToInt(grvData.GetFocusedRowCellValue(colID));
modelM.MaterialParameterValueID = valID;
pt.Insert(modelM);
}
}
}
}
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();
}
}
void save(bool close)
{
ProcessTransaction pt = new ProcessTransaction();
pt.OpenConnection();
pt.BeginTransaction();
try
{
if (!ValidateForm())
{
return;
}
grvThongSo.FocusedRowHandle = -1;
MaterialNS.Name = txtName.Text.Trim().ToUpper();
MaterialNS.Code = txtCode.Text.Trim().Replace(" ", "");
MaterialNS.CustomerID = TextUtils.ToInt(cboHang.EditValue);
MaterialNS.Description = txtDescription.Text.Trim();
MaterialNS.Type = cboType.SelectedIndex;
MaterialNS.NumberTS = TextUtils.ToInt(txtSL.Text);
if (MaterialNS.ID <= 0)
{
MaterialNS.ID = (int)pt.Insert(MaterialNS);
}
else
{
pt.Update(MaterialNS);
}
#region Lưu trữ thông số
for (int i = 0; i < grvThongSo.RowCount; i++)
{
int id = TextUtils.ToInt(grvThongSo.GetRowCellValue(i, colIDThongSo));
string code = TextUtils.ToString(grvThongSo.GetRowCellValue(i, colCodeThongSo));
string name = TextUtils.ToString(grvThongSo.GetRowCellValue(i, colNameThongSo));
if (code == "" || name == "")
{
continue;
}
MaterialParamNSModel para = new MaterialParamNSModel();
if (id > 0)
{
para = (MaterialParamNSModel)MaterialParamNSBO.Instance.FindByPK(id);
}
para.Code = code.ToUpper().Trim().Replace(" ", "");
para.Name = name.Trim();
para.MaterialNSID = MaterialNS.ID;
para.Unit = TextUtils.ToString(grvThongSo.GetRowCellValue(i, colUnitThongSo));
if (para.ID <= 0)
{
pt.Insert(para);
}
else
{
if (i >= TextUtils.ToInt(txtSL.Text))
{
pt.Delete("MaterialParamNS", para.ID);
}
else
{
pt.Update(para);
}
}
}
#endregion
#region Lưu trữ file
for (int i = 0; i < grvData.RowCount; i++)
{
int iD = TextUtils.ToInt(grvData.Rows[i].Cells["colID"].Value);
MaterialFileNSModel fileModel = new MaterialFileNSModel();
if (iD > 0)
{
fileModel = (MaterialFileNSModel)MaterialFileNSBO.Instance.FindByPK(iD);
}
fileModel.FilePath = grvData.Rows[i].Cells["colFilePath"].Value.ToString();
fileModel.Length = TextUtils.ToDecimal(grvData.Rows[i].Cells["colSize"].Value);
fileModel.MaterialNSID = MaterialNS.ID;
fileModel.Name = grvData.Rows[i].Cells["colFileName"].Value.ToString();
fileModel.LocalFilePath = grvData.Rows[i].Cells["colLocalPath"].Value.ToString();
if (iD == 0)
{
pt.Insert(fileModel);
File.Copy(fileModel.LocalFilePath, fileModel.FilePath, true);
}
}
#endregion
pt.CommitTransaction();
if (grvData.Rows.Count > 0)
{
MaterialNS.FilePath = TextUtils.ToString(grvData.Rows[0].Cells["colFilePath"].Value);
MaterialNSBO.Instance.Update(MaterialNS);
}
loadGridFile();
loadGridPara();
_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("Có lỗi xảy ra khi lưu trữ!" + Environment.NewLine + ex.Message, TextUtils.Caption,
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
pt.CloseConnection();
}
}