private void btnAddPK_Click(object sender, EventArgs e) { frmListMaterial frm = new frmListMaterial(); if (frm.ShowDialog() == DialogResult.OK) { //dtMaterial = frm.dtAll; //grdVT.DataSource = dtMaterial; foreach (DataRow r in frm.dtAll.Rows) { string code = TextUtils.ToString(r["Code"]); if (code == "") { continue; } DataRow[] drs = dtPK.Select("Code = '" + code + "'"); if (drs.Length > 0) { continue; } DataRow dr = dtPK.NewRow(); dr["Code"] = r["Code"].ToString(); dr["Name"] = r["Name"].ToString(); dr["Qty"] = 1; dtPK.Rows.Add(dr); } } }
private void btnAddVT_Click(object sender, EventArgs e) { frmListMaterial frm = new frmListMaterial(); frm.dtAll = _dtMaterial.Copy(); if (frm.ShowDialog() == DialogResult.OK) { _dtMaterial = frm.dtAll; foreach (DataRow row in _dtMaterial.Rows) { string code = TextUtils.ToString(row["Code"]); DataRow[] drs = _dtListMaterial.Select("Code = '" + code + "'"); if (drs.Length == 0) { DataRow dr = _dtListMaterial.NewRow(); dr["Code"] = TextUtils.ToString(row["Code"]); dr["Name"] = TextUtils.ToString(row["Name"]); dr["Hang"] = TextUtils.ToString(row["Hang"]); dr["Unit"] = TextUtils.ToString(row["Unit"]); dr["Qty"] = TextUtils.ToDecimal(row["Qty"]); dr["TonKho"] = TextUtils.ToDecimal(row["TonKho"]); _dtListMaterial.Rows.Add(dr); } } //grdVT.DataSource = _dtListMaterial; } }
private void btnAddVT_Click(object sender, EventArgs e) { frmListMaterial frm = new frmListMaterial(); if (frm.ShowDialog() == DialogResult.OK) { using (WaitDialogForm fWait = new WaitDialogForm("Vui lòng chờ trong giây lát...", "Đang thêm vật tư...")) { foreach (DataRow r in frm.dtAll.Rows) { string code = TextUtils.ToString(r["Code"]); if (code == "") { continue; } DataRow[] drs = _dtDMVT.Select("Code = '" + code + "'"); if (drs.Length > 0) { continue; } decimal tonKho = TextUtils.ToDecimal(r["TonKho"]); //string sqlM = "SELECT top 1 * FROM vGetPriceOfPart with(nolock)" // + " WHERE Price > 1 AND replace(replace([PartsCode],'/','#'),')','#') = '" // + code.Replace(" ", "").Replace("/", "#").Replace(")", "#") + "'" // + " ORDER BY DateAboutF DESC"; //DataTable dtPrice = LibQLSX.Select(sqlM); string sqlM = "exec spGetPriceOfPart '" + code.Replace(" ", "").Replace("/", "#").Replace(")", "#") + "'"; DataTable dtPrice = LibQLSX.Select(sqlM); DataRow dr = _dtDMVT.NewRow(); dr["Code"] = r["Code"].ToString(); dr["Name"] = r["Name"].ToString(); dr["Hang"] = r["Hang"].ToString(); dr["Unit"] = r["Unit"].ToString(); dr["QtyTon"] = tonKho; dr["SolutionID"] = TextUtils.ToInt(Solution.ID); if (dtPrice.Rows.Count > 0) { dr["Price"] = TextUtils.ToDecimal(dtPrice.Rows[0]["Price"]).ToString("n0"); } else { dr["Price"] = TextUtils.ToDecimal(r["Price"]).ToString("n0"); } dr["TotalPrice"] = TextUtils.ToDecimal(dr["Price"]).ToString("n0"); dr["Qty"] = 1; _dtDMVT.Rows.Add(dr); } } } }
private void btnAddVT_Click(object sender, EventArgs e) { frmListMaterial frm = new frmListMaterial(); if (frm.ShowDialog() == DialogResult.OK) { foreach (DataRow row in frm.dtAll.Rows) { DataRow[] rows = dtMaterial.Select("Code = '" + row["Code"].ToString() + "'"); if (rows.Count() > 0) { continue; } DataRow dr = dtMaterial.NewRow(); dr["ID"] = 0; dr["ProductID"] = Product.ID; dr["Code"] = row["Code"].ToString(); dr["Name"] = row["Name"].ToString(); dr["Qty"] = 1; dr["Hang"] = row["Hang"].ToString(); dr["Type"] = 1; //if (row["Code"].ToString().StartsWith("TPAD")) //{ // DataTable dt = TextUtils.Select("SELECT ISNULL(MAX(Version), 0) FROM dbo.ModuleVersion WHERE (ModuleCode = '" + row["Code"].ToString() + "')"); // dr["CVersion"] = dt.Rows.Count > 0 ? dt.Rows[0][0].ToString() : "0"; // dr["NVersion"] = dr["CVersion"]; //} //else //{ // dr["CVersion"] = "0"; // dr["NVersion"] = "0"; //} dr["CVersion"] = row["CVersion"].ToString(); dr["NVersion"] = row["NVersion"].ToString(); dtMaterial.Rows.Add(dr); //dtMaterial.Rows.Add(0, BaiThucHanh.ID, row["Code"].ToString(), row["Name"].ToString(), 1, row["Hang"].ToString(), 1); } grdVT.DataSource = dtMaterial; } }
private void btnAddVT_Click(object sender, EventArgs e) { frmListMaterial frm = new frmListMaterial(); if (frm.ShowDialog() == DialogResult.OK) { using (WaitDialogForm fWait = new WaitDialogForm("Vui lòng chờ trong giây lát...", "Đang thêm vật tư...")) { foreach (DataRow r in frm.dtAll.Rows) { string code = TextUtils.ToString(r["Code"]); if (code == "") { continue; } DataRow[] drs = _dtVT.Select("Code = '" + code + "'"); if (drs.Length > 0) { continue; } decimal tonKho = TextUtils.ToDecimal(r["TonKho"]); //string sqlM = "SELECT top 1 * FROM vGetPriceOfPart with(nolock)" // + " WHERE Price > 1 AND replace(replace([PartsCode],'/','#'),')','#') = '" // + code.Replace(" ", "").Replace("/", "#").Replace(")", "#") + "'" // + " ORDER BY DateAboutF DESC"; //DataTable dtPrice = LibQLSX.Select(sqlM); string sqlM = "exec spGetPriceOfPart '" + code.Replace(" ", "").Replace("/", "#").Replace(")", "#") + "'"; DataTable dtPrice = LibQLSX.Select(sqlM); DataRow dr = _dtVT.NewRow(); dr["Code"] = r["Code"].ToString(); dr["Name"] = r["Name"].ToString(); dr["Hang"] = r["Hang"].ToString(); dr["Unit"] = r["Unit"].ToString(); dr["TonKho"] = tonKho; dr["DeliveryTime"] = TextUtils.ToInt(dtPrice.Rows[0]["DeliveryTime"]); if (dtPrice.Rows.Count > 0) { dr["Price"] = TextUtils.ToDecimal(dtPrice.Rows[0]["Price"]).ToString("n0"); if (tonKho >= 1) { dr["Time"] = 1; } else { dr["Time"] = TextUtils.ToInt(dtPrice.Rows[0]["DeliveryTime"]); } DateTime dateP = TextUtils.ToDate1(txtDateP.Text); int dateCurrent = TextUtils.ToInt(dr["Time"]); if (dateCurrent < 0) { dr["Description"] = "Chưa phát sinh mua bán"; } else { DateTime dateVT = DateTime.Now.AddDays(dateCurrent); if (dateVT.Date <= dateP.Date) { dr["Status"] = "Đạt"; } else { dr["Status"] = "Không đạt"; } } } else { dr["Price"] = TextUtils.ToDecimal(r["Price"]).ToString("n0"); dr["Description"] = "Chưa phát sinh mua bán"; } dr["Total"] = TextUtils.ToDecimal(dr["Price"]).ToString("n0"); dr["Qty"] = 1; _dtVT.Rows.Add(dr); } txtTotalM.Text = TextUtils.ToDecimal(colMaTotal.SummaryItem.SummaryValue).ToString("n0"); txtDateM.Text = TextUtils.ToDecimal(colMaTime.SummaryItem.SummaryValue).ToString("n0"); } } }