private void btnAddModule_Click(object sender, EventArgs e)
{
frmListModules frm = new frmListModules();
if (frm.ShowDialog() == DialogResult.OK)
{
foreach (DataRow row in frm.dtSeleted.Rows)
{
DataRow[] rows = dtModule.Select("Code = '" + row["Code"].ToString() + "'");
if (rows.Count() > 0)
{
continue;
}
DataRow dr = dtModule.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"] = 0;
dr["CVersion"] = row["CVersion"].ToString();
dr["NVersion"] = row["NVersion"].ToString();
dtModule.Rows.Add(dr);
}
grdModule.DataSource = dtModule;
}
}
private void btnAddModule_Click(object sender, EventArgs e)
{
frmListModules frm = new frmListModules();
if (frm.ShowDialog() == DialogResult.OK)
{
using (WaitDialogForm fWait = new WaitDialogForm("Vui lòng chờ trong giây lát...", "Đang thêm module..."))
{
foreach (DataRow r in frm.dtSeleted.Rows)
{
string code = TextUtils.ToString(r["Code"]);
if (code == "")
{
continue;
}
DataRow[] drs = _dtDMVT.Select("Code = '" + code + "'");
if (drs.Length > 0)
{
continue;
}
decimal price = TextUtils.GetPrice(code, true);
DataRow dr = _dtDMVT.NewRow();
dr["Code"] = TextUtils.ToString(r["Code"]);
dr["Name"] = TextUtils.ToString(r["Name"]);
dr["Hang"] = TextUtils.ToString(r["Hang"]);
dr["Unit"] = "Bộ";
dr["Price"] = price;
dr["TotalPrice"] = price;
dr["Qty"] = 1;
dr["SolutionID"] = TextUtils.ToInt(Solution.ID);
_dtDMVT.Rows.Add(dr);
}
}
}
}
private void btnAddModule_Click(object sender, EventArgs e)
{
frmListModules frm = new frmListModules();
if (frm.ShowDialog() == DialogResult.OK)
{
using (WaitDialogForm fWait = new WaitDialogForm("Vui lòng chờ trong giây lát...", "Đang thêm module..."))
{
foreach (DataRow r in frm.dtSeleted.Rows)
{
string code = TextUtils.ToString(r["Code"]);
if (code == "")
{
continue;
}
DataRow[] drs = _dtVT.Select("Code = '" + code + "'");
if (drs.Length > 0)
{
continue;
}
decimal price = TextUtils.GetPrice(code, true);
int deliveryTime = -1;
if (code.StartsWith("PCB."))
{
//string sqlM = "SELECT top 1 * FROM vGetPriceOfPart with(nolock)"
// + " WHERE Price > 1 AND replace(replace([PartsCode],'/','#'),')','#') = '"
// + "TPAT." + code.Substring(4, 7) + "'"
// + " ORDER BY DateAboutF DESC";
//DataTable dtPrice = LibQLSX.Select(sqlM);
string sqlM = "exec spGetPriceOfPart 'TPAT." + code.Substring(4, 7) + "'";
DataTable dtPrice = LibQLSX.Select(sqlM);
deliveryTime = TextUtils.ToInt(dtPrice.Rows[0]["DeliveryTime"]);
}
DataRow dr = _dtVT.NewRow();
dr["Code"] = TextUtils.ToString(r["Code"]);
dr["Name"] = TextUtils.ToString(r["Name"]);
dr["Hang"] = TextUtils.ToString(r["Hang"]);
dr["Unit"] = "Bộ";
dr["Price"] = price.ToString("n0");
dr["Total"] = price.ToString("n0");
dr["Qty"] = 1;
if (deliveryTime != -1)
{
dr["Time"] = deliveryTime;
DateTime dateP = TextUtils.ToDate1(txtDateP.Text);
int dateCurrent = TextUtils.ToInt(dr["Time"]);
if (dateCurrent < 0)
{
dr["Status"] = "Không đạt";
}
else
{
DateTime dateVT = DateTime.Now.AddDays(dateCurrent);
if (dateVT.Date <= dateP.Date)
{
dr["Status"] = "Đạt";
}
else
{
dr["Status"] = "Không đạt";
}
}
}
_dtVT.Rows.Add(dr);
}
txtTotalM.Text = TextUtils.ToDecimal(colMaTotal.SummaryItem.SummaryValue).ToString("n0");
}
}
}