/// <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);
}
}