/// <summary> /// 删除磁扣信息 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void tsmBtn_DeleteCard_Click(object sender, EventArgs e) { QC_IC_Info bill = getSelectedBill(); if (bill == null) { MessageBox.Show("没有选定数据"); return; } if (bill.SampleId > 0) { MessageBox.Show("磁扣已经绑定数据,需要先解除绑定,才能删除。"); return; } if (MessageBox.Show("您确实要删除数据吗?", "提示", MessageBoxButtons.OKCancel) == DialogResult.OK) { icInfoDatas.Remove(bill); icInfoDatas.Save(); MessageBox.Show("删除数据完成"); } }
private void 查询_Click(object sender, EventArgs e) { cxs.Clear(); QC_Sample_Mix mix = new QC_Sample_Mix(); zyMixSamples.LoadDataByWhere("main.Mix_Time>=@Kssj and main.Mix_Time<=@Jssj and main.samplestate=9 and main.WLLX='煤' and main.Mix_Time>@Mix_Time order by main.Mix_Time ", DateTime.Parse(this.dateEdit1.Text.Trim()), DateTime.Parse(this.dateEdit2.Text.Trim()), Convert.ToDateTime("2017-09-30 18:00:00")); for (int i = 0; i < zyMixSamples.Count; i++) { zyMixSamples[i].CheckVals.LoadDataBySampleMixId(zyMixSamples[i].Sample_Mix_ID); bool cunzai = false; for (int j = 0; j < zyMixSamples1.Count; j++) { if (zyMixSamples[i].MatPK == zyMixSamples1[j].MatPK && zyMixSamples[i].SupplierCode == zyMixSamples1[j].SupplierCode && zyMixSamples[i].Riqi == zyMixSamples1[j].Riqi) { cunzai = true; foreach (var item in zyMixSamples1[j].CheckVals) { if (item.CheckItemName == "S" || item.CheckItemName == "硫分") { foreach (var it in zyMixSamples[i].CheckVals) { if (it.CheckItemName == "S" || it.CheckItemName == "硫分") { if (Convert.ToDouble(it.ReportVal) < Convert.ToDouble(item.ReportVal)) { zyMixSamples1.Remove(zyMixSamples1[j]); zyMixSamples1.Add(zyMixSamples[i]); } } } } } } } if (cunzai == false) { zyMixSamples1.Add(zyMixSamples[i]); } } for (int i = 0; i < zyMixSamples1.Count; i++) { QC_Hbcx cx = new QC_Hbcx(); cx.Xh = i + 1; cx.Wlmc = zyMixSamples1[i].MatName; cx.Riqi = zyMixSamples1[i].Mix_Time.Value.ToString("yyyy-MM-dd"); cx.Gysmc = zyMixSamples1[i].SupplierName; cx.Pddj = zyMixSamples1[i].LocalQcLevel; foreach (var item in zyMixSamples1[i].CheckVals) { if (item.CheckItemName == "水分") { cx.Sf = item.ReportVal; } else if (item.CheckItemName == "灰分") { cx.Hf = item.ReportVal; } else if (item.CheckItemName == "挥发分") { cx.Hff = item.ReportVal; } else if (item.CheckItemName == "硫分") { cx.Lf = item.ReportVal; } else if (item.CheckItemName == "S") { cx.Lf = item.ReportVal; } else if (item.CheckItemName == "X") { cx.X = item.ReportVal; } else if (item.CheckItemName == "Y") { cx.Y = item.ReportVal; } else if (item.CheckItemName == "G") { cx.G = item.ReportVal; } else if (item.CheckItemName == "发热量") { cx.Frl = item.ReportVal; } } cxs.Add(cx); } }