void Init() { this.lblPODCount.Text = PurchasingOrderUtil.GetPurchasingOrderDetailStatus(); decimal total = 0.0M; SourceListDao slDao = new SourceListDao(); List <Model.PurchasingOrderDetail> pods = PurchasingOrderUtil.GetPurchasingOrderDetail(); var q = from s in pods select s.SourceListOID; DataTable dt = new DataTable(); object resultObj = null; if (!(pods == null || pods.Count == 0)) { dt = slDao.FineSourceListForPOAddMain(q.ToList()); dt.PrimaryKey = new DataColumn[] { dt.Columns["SourceListOID"] }; var qs = from pod in pods select new { 料件編號 = GetDTValue(dt, "料件編號", pod.SourceListOID), 料件品名 = GetDTValue(dt, "料件品名", pod.SourceListOID), 供應商名稱 = GetDTValue(dt, "供應商名稱", pod.SourceListOID), 批量 = GetDTValue(dt, "批量", pod.SourceListOID), 批量單價 = $"{Convert.ToDecimal(GetDTValue(dt, "批量單價", pod.SourceListOID)):#.#}", 採購數量 = $"{pod.Qty:#.#}", 小計 = (Convert.ToDecimal(GetDTValue(dt, "批量單價", pod.SourceListOID)) * pod.Qty).ToString("#.#"), pod.SourceListOID }; var result = qs.ToList(); foreach (var item in result) { total += Convert.ToDecimal(item.小計); } resultObj = result; } this.lblTotal.Text = $"採購單金額總計:{total:0.#}"; this.dataGridView1.Columns.Clear(); if (resultObj != null) { this.DataGridViewAddButton(); } this.POD.DataSource = resultObj; this.dataGridView1.DataSource = this.POD; if (resultObj != null) { this.dataGridView1.Columns[this.dataGridView1.GetColumnIndex("SourceListOID")].Visible = false; } this.btnSendPO.Enabled = !(PurchasingOrderUtil.GetPurchasingOrderDetailCount() == 0); }
void SetShowData(string pn) { //string partNumber = Convert.ToString(Util.GetSessionValueThenRemove("PartNumber")); PartDao pDao = new PartDao(); this.PartData = pDao.FindPartByPartNumber(pn); this.lblPartNumber.Text = PartData.PartNumber; this.lblPartName.Text = PartData.PartName; this.lblPartSpec.Text = PartData.PartSpec; this.lblUnitPrice.Text = PartData.UnitPrice.ToString(); this.lblSupplierName.Text = PartData.GetSupplierInfo().SupplierName; SourceListDao slDao = new SourceListDao(); this.sourceLists = slDao.FindSourceListByPartNumber(PartData.PartNumber); var q = from sl in sourceLists select new { Value = sl.SourceListOID, Display = $"批量:{sl.Batch,4} - 折扣:{Math.Round(sl.Discount * 10, 1)}折 - 單價:{Math.Round(PartData.UnitPrice.Value * sl.Batch * sl.Discount, 0)}" }; this.cbSourceList.DataSource = q.ToList(); this.cbSourceList.DisplayMember = "Display"; this.cbSourceList.ValueMember = "Value"; }
public SourceList GetSourceList() { PMSWin.PurchasingOrder.SourceListDao dao = new PMSWin.PurchasingOrder.SourceListDao(); return(dao.FindSourceListBySourceListOID(this.SourceListOID)); }