void InsertLink()
{
DataTable dtItem = LibQLSX.Select("select * from C_QuotationDetail_SX where C_QuotationID = " + C_QuotationID);
foreach (DataRow item in dtItem.Rows)
{
int groupID = TextUtils.ToInt(item["C_ProductGroupID"]);
int id = TextUtils.ToInt(item["ID"]);
//if (groupID == 0)
//{
// C_QuotationDetail_SXModel model = (C_QuotationDetail_SXModel)C_QuotationDetail_SXBO.Instance.FindByPK(id);
// C_CostQuotationItemLinkBO.Instance.DeleteByAttribute("C_QuotationDetail_SXID", id);
// model.TotalNC = 0;
// C_QuotationDetail_SXBO.Instance.Update(model);
//}
//else
if (groupID > 0)
{
string sql = "insert into [C_CostQuotationItemLinkNew] ([C_CostID],[C_QuotationDetail_SXID],[Price],[PersonNumber],[NumberDay],[TotalR],[IsDirect],[CostNCType])"
+ " select ID ," + id + " as [C_QuotationDetail_SXID], 0 as b, 0 as c, 0 as d, 0 as e, 1 as f, 'C' as g"
+ " from [C_Cost] m where m.IsDirectCost = 1 and ((select COUNT(ID) from [C_CostQuotationItemLinkNew] where [C_CostID] = m.ID and [C_QuotationDetail_SXID] = " + id + ") = 0)";
LibQLSX.ExcuteSQL(sql);
}
}
}
private void btnCancelChiThi_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Bạn có chắc muốn hủy chỉ thị cho module không?",
TextUtils.Caption, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
return;
}
int count = 0;
foreach (int i in grvData.GetSelectedRows())
{
string projectModuleId = TextUtils.ToString(grvData.GetRowCellValue(i, colProjectModuleId));
string updateSql = "update [ProjectModule] set [ProjectDirectionID] = NULL Where [ProjectModuleId] = '" + projectModuleId + "'";
LibQLSX.ExcuteSQL(updateSql);
string deleteSql = "delete ProjectDirectionDetail where ProjectModuleId = '" + projectModuleId + "'";
LibQLSX.ExcuteSQL(deleteSql);
count++;
}
if (count > 0)
{
MessageBox.Show("Hủy chỉ thị cho module thành công.", TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Information);
loadGrid();
}
}
private void hủyĐangSảnXuấtToolStripMenuItem_Click(object sender, EventArgs e)
{
string projectId = TextUtils.ToString(grvData.GetFocusedRowCellValue(colID));
string sql = "Update Project set IsAssembly = 0 where ProjectId = '" + projectId + "'";
LibQLSX.ExcuteSQL(sql);
btnReloadData_Click(null, null);
}
void resetAll()
{
grvLink.FocusedRowHandle = -1;
decimal totalNC = 0;
string sql = "update C_QuotationDetail set TotalNC = 0 where C_QuotationID = " + C_QuotationID;
LibQLSX.ExcuteSQL(sql);
using (WaitDialogForm fWait = new WaitDialogForm("Vui lòng chờ trong giây lát...", "Đang xử lý..."))
{
for (int i = 0; i < grvLink.RowCount; i++)
{
int id = TextUtils.ToInt(grvLink.GetRowCellValue(i, colID));
if (id == 0)
{
return;
}
int costID = TextUtils.ToInt(grvLink.GetRowCellValue(i, colC_CostID));
int quotationDetailID = TextUtils.ToInt(grvLink.GetRowCellValue(i, colC_QuotationDetailID));
C_QuotationDetailModel quotationDetail = (C_QuotationDetailModel)C_QuotationDetailBO.Instance.FindByPK(quotationDetailID);
C_CostModel cost = (C_CostModel)C_CostBO.Instance.FindByPK(costID);
C_CostProductGroupLinkModel group = (C_CostProductGroupLinkModel)C_CostProductGroupLinkBO.Instance.FindByExpression(new Expression("C_CostID", cost.ID)
.And(new Expression("C_ProductGroupID", quotationDetail.C_ProductGroupID)))[0];
decimal pricePerDay = TextUtils.ToDecimal(grvLink.GetRowCellValue(i, colPricePerDay));
decimal qty = TextUtils.ToDecimal(grvLink.GetRowCellValue(i, colQty));
C_CostQuotationItemLinkModel link = (C_CostQuotationItemLinkModel)C_CostQuotationItemLinkBO.Instance.FindByPK(id);
link.PersonNumber = group.PersonNumber;// TextUtils.ToDecimal(drs[0]["PersonNumber"]);
if (group.IsFix == 1)
{
link.NumberDay = group.NumberDay;// TextUtils.ToDecimal(drs[0]["NumberDay"]);
}
else
{
link.NumberDay = group.VtuPercent * quotationDetail.PriceVT / cost.Price;
}
link.TotalR = link.NumberDay * link.PersonNumber;
if (cost.ID == 61)//phòng thiết kế
{
link.TotalR *= (1 + 0.3M * (quotationDetail.Qty - 1)) / quotationDetail.Qty;
}
link.Price = link.TotalR * cost.Price;
C_CostQuotationItemLinkBO.Instance.Update(link);
quotationDetail.TotalNC += link.Price;
C_QuotationDetailBO.Instance.Update(quotationDetail);
}
IsSaved = true;
}
MessageBox.Show("Reset thành công.", TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
private void btnDel_Click(object sender, EventArgs e)
{
try
{
if (grvData.DataSource == null)
{
return;
}
int id = TextUtils.ToInt(grvData.GetFocusedRowCellValue(colID));
string code = grvData.GetFocusedRowCellValue(colCode).ToString();
if (id == 0)
{
return;
}
//if (C_CostProductGroupLinkBO.Instance.CheckExist("C_CostID", id))
//{
// MessageBox.Show("Chi phí này đang liên kết với nghành hàng nên không thể xóa được.", TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Stop);
// return;
//}
if (C_CostQuotationItemLinkBO.Instance.CheckExist("C_CostID", id))
{
MessageBox.Show("Chi phí này đang liên kết với thiết bị nên không thể xóa được.", TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Stop);
return;
}
if (MessageBox.Show("Bạn có chắc muốn xóa chi phí [" + grvData.GetFocusedRowCellValue(colName).ToString() + "] không?",
TextUtils.Caption, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
return;
}
//ModulesBO.Instance.Delete(id);
C_CostModel model = (C_CostModel)C_CostBO.Instance.FindByPK(id);
model.IsDeleted = true;
C_CostBO.Instance.Update(model);
LibQLSX.ExcuteSQL("delete C_CostProductGroupLink where C_CostID = " + id);
LibQLSX.ExcuteSQL("delete C_CostQuotationLink where C_CostID = " + id);
LoadInfoSearch();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnDeadlineSXLR_Click(object sender, EventArgs e)
{
string projectCode = TextUtils.ToString(grvProject.GetFocusedRowCellValue(colProjectCode));
if (dtpSXLRDeadline.EditValue != null && projectCode != "")
{
DateTime date = TextUtils.ToDate3(dtpSXLRDeadline.EditValue);
LibQLSX.ExcuteSQL("update Project set AssemblyDeadline = '" + date.Year + "-" + date.Month + "-" + date.Day
+ "' where [ProjectCode] = '" + projectCode + "'");
string id = TextUtils.ToString(cboProject.EditValue);
loadProject();
cboProject.EditValue = id;
MessageBox.Show("Thay đổi deadline SXLR thành công!", TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void btnSetStatus_Click(object sender, EventArgs e)
{
int projectStatusID = TextUtils.ToInt(cboStatus.SelectedValue);
if (projectStatusID == 0)
{
return;
}
foreach (int i in grvData.GetSelectedRows())
{
string projectId = TextUtils.ToString(grvData.GetRowCellValue(i, colID));
string sql = "Update Project set ProjectStatusID = " + projectStatusID + " where ProjectId = '" + projectId + "'";
LibQLSX.ExcuteSQL(sql);
}
btnReloadData_Click(null, null);
}
private void phụcHồiToolStripMenuItem_Click(object sender, EventArgs e)
{
int id = TextUtils.ToInt(grvData.GetFocusedRowCellValue(colID));
if (id == 0)
{
return;
}
string name = TextUtils.ToString(grvData.GetFocusedRowCellValue(colFullName));
DialogResult result = MessageBox.Show("Bạn có thực sự muốn chuyển nhân viên [" + name + "] sang trạng thái đi làm?", TextUtils.Caption,
MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
UsersModel model = (UsersModel)UsersBO.Instance.FindByPK(id);
model.Status = 0;//ngừng hoạt động
UsersBO.Instance.Update(model);
LibQLSX.ExcuteSQL("update Users set IsStop = 0 where Account = '" + model.LoginName + "'");
loadGrid();
}
}
private void btnSave_Click(object sender, EventArgs e)
{
ProcessTransaction pt = new ProcessTransaction();
pt.OpenConnection();
pt.BeginTransaction();
try
{
if (!ValidateForm())
{
return;
}
Model.BankAccount = txtBankAccount.Text.Trim();
Model.BHXH = txtBHXH.Text.Trim();
Model.BHYT = txtBHYT.Text.Trim();
try
{
Model.BirthOfDate = TextUtils.ToDate3(dtpBirthOfDate.EditValue);
}
catch
{
Model.BirthOfDate = DateTime.Now;
}
Model.CMTND = txtCMTND.Text.Trim();
Model.Code = txtCode.Text.Trim();
Model.DepartmentID = TextUtils.ToInt(cboDepartment.SelectedValue);
Model.Email = txtEmail.Text.Trim();
Model.EmailCom = txtEmailCom.Text.Trim();
Model.FullName = txtFullName.Text;
Model.HandPhone = txtTelephone.Text;
Model.HomeAddress = txtHomeAddress.Text;
Model.JobDescription = txtJobDescription.Text.Trim();
Model.MST = txtMST.Text.Trim();
Model.Position = txtPosition.Text;
Model.Qualifications = txtQualifications.Text.Trim();
Model.Sex = cboSex.SelectedIndex;
Model.UserGroupID = TextUtils.ToInt(lookUpEdit1.EditValue);
Model.UserGroupSXID = TextUtils.ToInt(cboGroup.EditValue);
try
{
Model.StartWorking = TextUtils.ToDate3(dtpStartWorking.EditValue);
}
catch
{
Model.StartWorking = DateTime.Now;
}
Model.ImagePath = pictureBox1.ImageLocation;
Model.Status = cboStatus.SelectedIndex;
if (chkHasUser.Checked)
{
Model.LoginName = txtLoginName.Text.Trim();
Model.PasswordHash = MD5.EncryptPassword(txtPasswordHash.Text.Trim());
}
else
{
Model.LoginName = "";
Model.PasswordHash = "";
}
Model.UpdatedDate = Model.CreatedDate;
Model.UpdatedBy = Global.AppUserName;
if (Model.ID == 0)
{
Model.CreatedDate = TextUtils.GetSystemDate();
Model.CreatedBy = Global.AppUserName;
Model.ID = (int)pt.Insert(Model);
}
else
{
pt.Update(Model);
}
pt.CommitTransaction();
//Update mã nhân viên cho bên QLSX
if (Model.LoginName != "")
{
string pId = TextUtils.ToString(TextUtils.ExcuteScalar("select top 1 PId from [Department] with(nolock) where ID = " + TextUtils.ToInt(cboDepartment.SelectedValue)));
LibQLSX.ExcuteSQL("update Users set Code = '" + Model.Code + "', UserGroup1ID = " + Model.UserGroupSXID + ", [DepartmentId1]= '" + pId + "' where Account = '" + Model.LoginName + "'");
}
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(ex.Message, TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
pt.CloseConnection();
}
}
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;
bool isDiffError = TextUtils.ToInt(ProductPartsImport.CountError) < TextUtils.ToInt(txtCountError.EditValue);
if (!isDiffError)
{
//Xóa hết những nhật ký lỗi của vật tư khi KCS, trước khi lưu
//CriteriaImportBO.Instance.DeleteByAttribute("ProductPartsImportId", ProductPartsImport.ProductPartsImportId);
LibQLSX.ExcuteSQL(string.Format("delete CriteriaImport where ProductPartsImportId = '{0}' and CountError = {1}"
, ProductPartsImport.ProductPartsImportId, TextUtils.ToInt(ProductPartsImport.CountError)));
}
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);
// if (arr.Count > 0)
// {
// model = (CriteriaImportModel)arr[0];
// }
// else
// {
// criteriaImportId = "";
// }
//}
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.CountError = TextUtils.ToInt(txtCountError.EditValue);
//if (criteriaImportId != "" && !isDiffError)
//{
// 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 = TextUtils.ToDecimal(txtTotalOK.EditValue); // Qty % 1 == 0 ? OK : Qty;
ProductPartsImport.TotalNG = TextUtils.ToDecimal(txtTotalNG.EditValue); //Qty % 1 == 0 ? NG : Qty; //NG;
ProductPartsImport.TotalKCS = TextUtils.ToDecimal(txtTotalKCS.EditValue);
ProductPartsImport.LevelError = cboLevelError.SelectedIndex;
ProductPartsImport.CountError = TextUtils.ToInt(txtCountError.EditValue);
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);
}
}
}
private void btnCheckHoaDon_Click(object sender, EventArgs e)
{
grvData.ExpandAllGroups();
for (int i = 0; i < grvData.RowCount; i++)
{
string completeDate = TextUtils.ToString(grvData.GetRowCellValue(i, colCompletedDate));
int payVoucherID = TextUtils.ToInt(grvData.GetRowCellValue(i, colPayVoucherID));
string poCode = TextUtils.ToString(grvData.GetRowCellValue(i, colItemCode));
int caseVoucherDebtID = TextUtils.ToInt(grvData.GetRowCellValue(i, colID));
if (caseVoucherDebtID == 0)
{
continue;
}
if (completeDate != "")
{
continue;
}
if (payVoucherID == 1)//Nợ hóa đơn
{
string sqlTotalVat = "SELECT TotalVAT = case when dbo.vOrderNew.IsTranferAfferVAT = 1 then isnull(dbo.vOrderNew.VAT,10)*dbo.vOrderNew.TotalPrice /100" +
" else isnull(dbo.vOrderNew.VAT,10)*(dbo.vOrderNew.TotalPrice+dbo.vOrderNew.DeliveryCost)/100 end " +
" from vOrderNew with(nolock) where vOrderNew.OrderCode = '" + poCode + "'";
string sqlInvoice = "select sum(T_XNTC.C_PSNO) FROM T_XNTC INNER JOIN T_DM_VUVIEC ON T_XNTC.FK_VUVIEC = T_DM_VUVIEC.PK_ID" +
" WHERE (T_DM_VUVIEC.C_MA = '" + poCode + "') AND (T_XNTC.FK_TKNO LIKE '133%')";
decimal totalVAT = TextUtils.ToDecimal(LibQLSX.ExcuteScalar(sqlTotalVat));
decimal totalInvoice = TextUtils.ToDecimal(LibIE.ExcuteScalar(sqlInvoice));
decimal chenhLech = totalVAT - totalInvoice;
if (chenhLech <= 10 && chenhLech >= -10)
{
string sqlDateTra = "select top 1 C_NGAYLAP FROM T_XNTC INNER JOIN T_DM_VUVIEC ON T_XNTC.FK_VUVIEC = T_DM_VUVIEC.PK_ID" +
" WHERE (T_DM_VUVIEC.C_MA = '" + poCode + "') AND (T_XNTC.FK_TKNO LIKE '133%')" +
" order by C_NGAYLAP desc";
DateTime?dateNgayTra = TextUtils.ToDate2(LibIE.ExcuteScalar(sqlDateTra));
if (dateNgayTra.HasValue)
{
string sqlUpdate = "update CaseVoucherDebt set CompletedDate = '" + dateNgayTra.Value.ToString("yyyy-MM-dd") + "' where ID = " + caseVoucherDebtID;
LibQLSX.ExcuteSQL(sqlUpdate);
}
}
if (chenhLech < -10)
{
string sqlUpdateChenhLech = "update CaseVoucherDebt set TotalDiff = " + chenhLech + " where ID = " + caseVoucherDebtID;
LibQLSX.ExcuteSQL(sqlUpdateChenhLech);
}
}
if (payVoucherID == 2)//Nợ báo giá
{
string sql = "SELECT TOP 1 [C_NGAYLAP]"
+ " FROM [tanphat].[dbo].[V_XNTC_VUVIEC] with (nolock)"
+ " where [C_MA] = '" + poCode + "' and FK_TKNO LIKE '133%' and [FK_PHANXUONG] = 115";
DateTime?dateNgayLap = TextUtils.ToDate2(LibIE.ExcuteScalar(sql));
if (dateNgayLap.HasValue)
{
string sqlUpdate = "update CaseVoucherDebt set CompletedDate = '" + dateNgayLap.Value.ToString("yyyy-MM-dd") + "' where ID = " + caseVoucherDebtID;
LibQLSX.ExcuteSQL(sqlUpdate);
}
}
}
loadData();
MessageBox.Show("Hoàn thành Check báo giá, hóa đơn", TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
