public void exceptBill()
{
initPrintbill();
if (printbill.Count > 0)
{
return;
}
DbEntityTable <QC_Sample_Mix> temp = new DbEntityTable <QC_Sample_Mix>();
temp.LoadDataByWhere("main.samplestate = @samplestate and main.wllx=@wllx order by SAMPLE_MIX_ID desc", Xg.Lab.Sample.SampleState.组批完成, "火运");
if (temp.Count < 1)
{
return;
}
int sid = temp[0].MainSampleMixId;
printbill.Clear();
if (sid == 0)
{
printbill.Add(temp[0]);
}
else
{
for (int i = 0; i < temp.Count; i++)
{
if (temp[i].Sample_Mix_ID >= sid)
{
printbill.Add(temp[i]);
}
}
}
}
public static DbEntityTable <QC_CardUseType> LoadCardUseType()
{
DbEntityTable <QC_CardUseType> result = new DbEntityTable <QC_CardUseType>();
QC_CardUseType cut1 = new QC_CardUseType();
cut1.CUTCode = QC_IC_Info.CardUseType_Veh;
cut1.CUTName = "车取样扣";
result.Add(cut1);
QC_CardUseType cut2 = new QC_CardUseType();
cut2.CUTCode = "CUT002";
cut2.CUTName = "组批样扣";
result.Add(cut2);
DbEntityTable <QC_CheckGroup> groups = new DbEntityTable <QC_CheckGroup>();
groups.LoadData();
foreach (var item in groups)
{
QC_CardUseType cut = new QC_CardUseType();
cut.CUTCode = "CUT_" + item.CheckGroupCode;
cut.CUTName = item.CheckGroupName + "扣";
result.Add(cut);
}
return(result);
}
public void HandleCardMessage(Device.CardReader device, string cardId)
{
QC_IC_Info icCard = QC_IC_Info.FindByCardId(cardId);
if (icCard == null)
{
MessageBox.Show("此卡未注册");
return;
}
if (!icCard.CardType.StartsWith("CUT_"))
{
MessageBox.Show("磁扣类型不对");
return;
}
if (icCard.SampleId <= 0)
{
MessageBox.Show("此卡没有业务信息");
return;
}
QC_Sample_Lab_Jy tempLab = QC_Sample_Lab_Jy.GetById(icCard.SampleId);
if (tempLab == null)
{
MessageBox.Show("没有找到单据"); return;
}
tempLab.JyCode = DbContext.GetSeq("JY" + DateTime.Now.Date.ToString("yyyyMMdd"), 2);
tempLab.Billtype = "开始检验";
tempLab.LabState = "开始检验";
tempLab.JyUser = LocalInfo.Current.user.ID;
tempLab.JyTime = DateTime.Now;
icCard.SampleId = 0;
IDbConnection conn = DbContext.GetDefaultConnection();
conn.Open();
IDbTransaction trans = conn.BeginTransaction();
icCard.Save(trans);
tempLab.Save(trans);
trans.Commit();
conn.Close();
this.curLab = QC_Sample_Lab_Jy.GetById(tempLab.Sample_Lab_ID);
lableiji.Add(curLab);
DbContext.ExeSql("insert into QC_LabLog(zycode,jycode,jytime) values('" + this.curLab.StoreCode + "','" + this.curLab.JyCode + "',getDate())");
labTable1.LoadDataByWhere("labstate='送检' and checkgroupname like '化验样%' and maketime>=@maketime", DateTime.Today.AddDays(-1));
// labTable2.LoadDataByWhere("labstate='送检' and checkgroupname like '角质层%' and maketime>=@maketime", DateTime.Today.AddDays(-1));
label2.Text = labTable1.Count.ToString();
// label4.Text = labTable2.Count.ToString();
SetGridViewFocuse();
this.printDocument1.Print(); //自动打印
//this.printPreviewDialog1.ShowDialog();
}
private void 查询组批_Click(object sender, EventArgs e)
{
mixs.LoadDataByWhere("main.WLLX='熔剂' and main.SampleState=@SampleState", SampleState.初始状态);
ches.LoadDataByWhere("main.WLLX='熔剂' and main.SampleState=@SampleState", SampleState.初始状态);
if (ches.Count > 0)
{
for (int j = 0; j < ches.Count; j++)
{
if (ches[j].Sample_Mix_ID == 0)
{
bool cunzai = false;
if (mixs.Count > 0)
{
for (int m = 0; m < mixs.Count; m++)
{
if (ches[j].SupplierCode == mixs[m].SupplierCode && ches[j].MatCode == mixs[m].MatCode && mixs[m].MixPlanCount > mixs[m].MixCount)
{
cunzai = true;
ches[j].Sample_Mix_ID = mixs[m].Sample_Mix_ID;
ches[j].Save();
mixs[m].MixCount++;
mixs[m].Save();
}
}
}
if (cunzai == false)
{
QC_Material matInfo = QC_Material.GetByID(ches[j].MatPK);
QC_Sample_Mix mix = new QC_Sample_Mix();
mix.WpCode = "0087";
mix.FangTong_Time = DateTime.Now;
mix.FangTong_User = LocalInfo.Current.user.ID;
mix.MatCode = ches[j].MatCode;
mix.MatPK = ches[j].MatPK;
mix.MixCount = 1;
mix.MixPlanCount = matInfo.BatchNum;
mix.SupplierCode = ches[j].SupplierCode;
mix.MixUser = LocalInfo.Current.user.ID;
mix.SampleState = SampleState.初始状态;
mix.SampleType = SampleType.普通样;
mix.WLLX = ches[j].WLLX;
mix.CardID = Zhc.Data.DbContext.GetSeq("RJ" + DateTime.Now.Date.ToString("yyyyMMdd"), 2);
mix.Save();
mixs.Add(mix);
ches[j].Sample_Mix_ID = mix.Sample_Mix_ID;
ches[j].Save();
}
}
}
}
}
public DlgChe(string cph, DateTime quyangTime)
{
InitializeComponent();
vehs.LoadDataByWhere(string.Format("vehno like '%{0}%' order by Sample_Veh_id desc ", cph)); //, quyangTime.AddHours(12), quyangTime.AddHours(-12)and InTime<=@SamTime1 and (OutTime>=@SamTime2 or OutTime is null) and OutTime<>'null'
if (vehs.Count > 0)
{
vehs1.Add(vehs[0]);
}
this.qCSampleVehBindingSource.DataSource = vehs1;
}
public static QC_NoticeDhdItem_View GetByIcNo(string icno)
{
DbEntityTable <QC_NoticeDhdItem_View> noticeDhd = new DbEntityTable <QC_NoticeDhdItem_View>();
noticeDhd.LoadDataByWhere("icno=@icno and status = 0", icno);
DbEntityTable <QC_NoticeDhdItem_View> noticeDhddui = new DbEntityTable <QC_NoticeDhdItem_View>();
DbEntityTable <TB_TaskFlow> tt = new DbEntityTable <TB_TaskFlow>();
for (int i = 0; i < noticeDhd.Count; i++)
{
bool chumen = false;
tt.LoadDataByWhere("NoticeId=@NoticeId", noticeDhd[i].NoticeId);
for (int j = 0; j < tt.Count; j++)
{
if (tt[j].Result == "出门")
{
chumen = true;
}
}
if (chumen == false)
{
noticeDhddui.Add(noticeDhd[i]);
}
}
if (noticeDhddui.Count > 1)
{
QC_NoticeDhdItem_View noticeDhd1 = new QC_NoticeDhdItem_View();
Xuanze dlg = new Xuanze(noticeDhddui);
if (dlg.ShowDialog() == DialogResult.OK)
{
noticeDhd1 = dlg.SelectedDhdItem;
}
return(noticeDhd1);
}
else if (noticeDhddui.Count == 1)
{
return(noticeDhddui[0]);
}
else
{
return(null);
}
}
private void timer1_Tick(object sender, EventArgs e)
{
mixs.LoadDataByWhere("main.WLLX='外矿' and main.SampleState=@SampleState", SampleState.初始状态);
vehs.LoadDataByWhere("main.WLLX='外矿' and main.SampleState=@SampleState", SampleState.初始状态);
for (int j = 0; j < vehs.Count; j++)
{
if (vehs[j].Sample_Mix_ID == 0)
{
bool cunzai = false;
for (int m = 0; m < mixs.Count; m++)
{
if (vehs[j].SupplierCode == mixs[m].SupplierCode && vehs[j].MatCode == mixs[m].MatCode && mixs[m].MixPlanCount > mixs[m].MixCount)
{
cunzai = true;
vehs[j].Sample_Mix_ID = mixs[m].Sample_Mix_ID;
vehs[j].Save();
mixs[m].MixCount++;
mixs[m].Save();
}
}
if (cunzai == false)
{
QC_Material matInfo = QC_Material.GetByID(vehs[j].MatPK);
QC_Sample_Mix mix = new QC_Sample_Mix();
mix.WpCode = "0090";
mix.MatCode = vehs[j].MatCode;
mix.MatPK = vehs[j].MatPK;
mix.MixCount = 1;
mix.MixPlanCount = matInfo.BatchNum;
mix.SupplierCode = vehs[j].SupplierCode;
mix.MixUser = LocalInfo.Current.user.ID;
mix.SampleState = SampleState.初始状态;
mix.SampleType = SampleType.普通样;
mix.WLLX = vehs[j].WLLX;
mix.CardID = "WK" + Zhc.Data.DbContext.GetSeq(DateTime.Now.Date.ToString("yyyyMMdd"), 2);
mix.Save();
mixs.Add(mix);
vehs[j].Sample_Mix_ID = mix.Sample_Mix_ID;
vehs[j].Save();
}
}
}
}
/// <summary>
/// 从视图读取集中计量火车信息，保存到QC_Sample_Veh表中
/// </summary>
public void initdata()
{
trainData = new DbEntityTable <View_train_to_sample>();
trainData.LoadData();
//没有数据时，返回
if (trainData.Count < 1)
{
return;
}
DbEntityTable <QC_Sample_Veh> veh = new DbEntityTable <QC_Sample_Veh>();
foreach (var item in trainData)
{
QC_Sample_Veh sample = new QC_Sample_Veh();
//物流的主键
sample.FetchPlace = item.matchid;
//发站
sample.zpdh = item.FAZHAN;
//物料名称
sample.rwdh = item.WLMC;
sample.VehNo = item.CPH;
sample.CardID = item.HCPH;
sample.begintime = item.GROSSTIME;
sample.SampleState = Xg.Lab.Sample.SampleState.初始状态;
//加入noticebillid
sample.NoticeBillId = System.Guid.NewGuid().ToString();
sample.WLLX = "火运";
veh.Add(sample);
}
veh.Save();
//trans_train_sample = new DbEntityTable<QC_Sample_Veh>();
//foreach (var item in trainData)
//{
// QC_Sample_Veh sample = new QC_Sample_Veh();
// sample.Sample_Veh_ID = item.matchid;
// sample.FAZHAN = item.FAZHAN;
// sample.WLMC = item.WLMC;
// sample.VehNo = item.CPH;
// sample.CardID = item.HCPH;
// sample.begintime = item.GROSSTIME.ToString("yyyy-MM-dd HH:mm:ss");
// sample.SampleState = Xg.Lab.Sample.SampleState.初始状态;
// trans_train_sample.Add(sample);
//}
//trans_train_sample.Save();
}
private void btnImportJudgeRule_Click(object sender, EventArgs e)
{
if (this.openFileDialog1.ShowDialog() == DialogResult.OK)
{
DbEntityTable <QC_QualityRule> rules = new DbEntityTable <QC_QualityRule>();
DataTable dt = Xg.Tools.ExcelHelper.ImportExcelFile(this.openFileDialog1.FileName);
DbEntityTable <QC_Material> mats = new DbEntityTable <QC_Material>();
mats.LoadData();
for (int i = 1; i < dt.Rows.Count; i++)
{
string matCode = dt.Rows[i][0].ToString().Trim();
var mat = from m in mats
where m.MatCode == matCode
select m;
QC_QualityRule rule = new QC_QualityRule();
rule.MatNcId = mat.First <QC_Material>().MatNcId;
rule.LocalQcLevel = dt.Rows[i][2].ToString().Trim();
switch (rule.LocalQcLevel)
{
case "一级":
rule.RuleOrder = 1;
break;
case "二级":
rule.RuleOrder = 2;
break;
case "三级":
rule.RuleOrder = 3;
break;
default:
rule.RuleOrder = 4;
break;
}
string ruleContent = dt.Rows[i][3].ToString().Trim();
rule.RuleStr2Contents(ruleContent);
rule.QualityLevelID = "1001NC100000002GF3MN";
rules.Add(rule);
}
rules.Save();
}
}
private void 添加物料_Click(object sender, EventArgs e)
{
QC_Material_wl wl = new QC_Material_wl();
DlgMaterial dlg = new DlgMaterial();
if (dlg.ShowDialog() == DialogResult.OK)
{
if (dlg.SelectedMaterial != null)
{
wl.MatNcId = dlg.SelectedMaterial.PK_INVBASDOC;
wl.MatCode = dlg.SelectedMaterial.InvCode;
wl.MatName = dlg.SelectedMaterial.InvName;
wl.InUse = dlg.SelectedMaterial.InUse;
}
wls.Add(wl);
wls.Save();
}
}
public void CopyData(QC_Sample_Mix original)
{
head.MatPK = original.MatPK;
head.MatCode = original.MatCode;
head.MatName = original.MatName;
body2.Empty();
DbEntityTable <QC_Sample_Value> orignalSample_CheckVals = new DbEntityTable <QC_Sample_Value>();
orignalSample_CheckVals.LoadDataByWhere("Sample_Mix_ID=@Sample_Mix_ID", original.Sample_Mix_ID);
foreach (var item in orignalSample_CheckVals)
{
QC_Sample_Value sv = new QC_Sample_Value();
sv.Sample_Lab_ID = -1;
sv.CheckItemNcId = item.CheckItemNcId;
sv.CheckItemCode = item.CheckItemCode;
sv.CheckItemName = item.CheckItemName;
sv.CheckItemUnit = item.CheckItemUnit;
sv.CheckUser = item.CheckUser;
sv.CheckTime = item.CheckTime;
body2.Add(sv);
}
}
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=11 and main.WLLX='煤' order by main.ZyDanHao ", DateTime.Parse(this.dateEdit1.Text.Trim()), DateTime.Parse(this.dateEdit2.Text.Trim()));
for (int i = 0; i < zyMixSamples.Count; i++)
{
if (zyMixSamples[i].SampleType == SampleType.抽查样)
{
zyMixSamples[i].VehSamples.LoadDataByNoticeBillId(zyMixSamples[i].NoticeBillId);
int parentId = InspectSampleParentId(zyMixSamples[i].Sample_Mix_ID);
if (zyMixSamples[i].daycheck() == 0)
{
zyMixSamples[i].CheckVals.LoadInspectSampleAllData(zyMixSamples[i].Sample_Mix_ID, parentId);
}
else
{
zyMixSamples[i].CheckVals.LoadInspectHotAllData(zyMixSamples[i].Sample_Mix_ID, parentId, zyMixSamples[i].daycheck(), "发热量1");
}
}
else if (zyMixSamples[i].SampleType == SampleType.普通样)
{
zyMixSamples[i].VehSamples.LoadDataBySampleMixId(zyMixSamples[i].Sample_Mix_ID);
if (zyMixSamples[i].daycheck() == 0)
{
zyMixSamples[i].CheckVals.LoadZhengSampleAllData(zyMixSamples[i].Sample_Mix_ID);
}
else
{
zyMixSamples[i].CheckVals.LoadHotData(zyMixSamples[i].daycheck(), zyMixSamples[i].Sample_Mix_ID, "发热量1");
}
}
DbEntityTable <QC_MatAllCheckItem> matcheckitems = new DbEntityTable <QC_MatAllCheckItem>();
matcheckitems.LoadDataByWhere("MATNCID=@MATNCID", zyMixSamples[i].MatPK);
if (matcheckitems.Count > 0)
{
foreach (var item in matcheckitems)
{
if (item.CheckGroupName == "可磨样")
{
bool czkm = false;
foreach (var it in zyMixSamples[i].CheckGroupLabs)
{
if (it.CheckGroupName == "可磨样")
{
czkm = true;
}
}
if (!czkm)
{
DbEntityTable <QC_Sample_Mix> lishimixs = new DbEntityTable <QC_Sample_Mix>();
string SQL = "select * from QC_Sample_Mix where MatCode='" + zyMixSamples[i].MatCode + "' and SupplierCode='" + zyMixSamples[i].SupplierCode + "' and mix_time>='" + zyMixSamples[i].ZyRecvTime.Value.Date + "' and mix_time<'" + zyMixSamples[i].ZyRecvTime + "' order by ZyRecvTime desc";
lishimixs.LoadDataBySql(SQL);
foreach (var li in lishimixs)
{
bool czkmy = false;
DbEntityTable <QC_Sample_Lab> labs = new DbEntityTable <QC_Sample_Lab>();
labs.LoadDataByWhere("main.Sample_Mix_ID=@Sample_Mix_ID", li.Sample_Mix_ID);
foreach (var it in labs)
{
if (it.CheckGroupName == "可磨样")
{
DbEntityTable <QC_Sample_Value> vals = new DbEntityTable <QC_Sample_Value>();
vals.LoadDataByWhere("main.Sample_Lab_ID=@Sample_Lab_ID", it.Sample_Lab_ID);
foreach (var va in vals)
{
va.ValSource = "前样";
zyMixSamples[i].CheckVals.Add(va);
}
czkmy = true;
break;
}
}
if (czkmy)
{
break;
}
}
}
}
}
}
zyMixSamples[i].CheckVals.DefaultSort();
if (zyMixSamples[i].SampleType == SampleType.普通样)
{
zyMixSamples[i].CheckVals.DaoxuSort();
}
DbEntityTable <QC_MatQualityLevel_View> levels = new DbEntityTable <QC_MatQualityLevel_View>();
levels.LoadDataByWhere("QUALITYLEVELID=@QUALITYLEVELID", zyMixSamples[i].QualityLevelID);
for (int j = 0; j < zyMixSamples[i].VehSamples.Count; j++)
{
QC_SCNCcx cx = new QC_SCNCcx();
cx.VehNo = zyMixSamples[i].VehSamples[j].VehNo;
cx.FetchTime = zyMixSamples[i].VehSamples[j].FetchTime;
cx.KouShui = zyMixSamples[i].VehSamples[j].KouShui;
cx.KouZa = zyMixSamples[i].VehSamples[j].KouZa;
cx.SampleType = zyMixSamples[i].SampleType;
cx.ZyDanHao = zyMixSamples[i].ZyDanHao;
cx.Wlmc = zyMixSamples[i].MatName;
// cx.Riqi = zyMixSamples[i].Mix_Time.Value.ToString("yyyy-MM-dd");
cx.Gysmc = zyMixSamples[i].SupplierName;
cx.Pddj = levels[0].QUALITYLEVELNAME;
foreach (var item in zyMixSamples[i].CheckVals)
{
if (item.CheckItemName == "水分")
{
if (cx.Sf == "")
{
cx.Sf = item.ReportVal;
}
}
if (item.CheckItemName == "哈氏可磨性")
{
if (cx.KM == "")
{
cx.KM = item.ReportVal;
}
}
else if (item.CheckItemName == "灰分")
{
if (cx.Hf == "")
{
cx.Hf = item.ReportVal;
}
}
else if (item.CheckItemName == "挥发分")
{
if (cx.Hff == "")
{
cx.Hff = item.ReportVal;
}
}
else if (item.CheckItemName == "硫分")
{
if (cx.Lf == "")
{
cx.Lf = item.ReportVal;
}
}
else if (item.CheckItemName == "S")
{
if (cx.Lf == "")
{
cx.Lf = item.ReportVal;
}
}
else if (item.CheckItemName == "X")
{
if (cx.X == "")
{
cx.X = item.ReportVal;
}
}
else if (item.CheckItemName == "Y")
{
if (cx.Y == "")
{
cx.Y = item.ReportVal;
}
}
else if (item.CheckItemName == "G")
{
if (cx.G == "")
{
cx.G = item.ReportVal;
}
}
else if (item.CheckItemName == "发热量1")
{
if (cx.Frl == "")
{
cx.Frl = item.ReportVal;
}
}
else if (item.CheckItemName == "标准差S")
{
if (cx.BzcS == "")
{
cx.BzcS = item.ReportVal;
}
}
else if (item.CheckItemName == "Rmax")
{
if (cx.Rmax == "")
{
cx.Rmax = item.ReportVal;
}
}
else if (item.CheckItemName == "Rran")
{
if (cx.Rran == "")
{
cx.Rran = item.ReportVal;
}
}
else if (item.CheckItemName == "固定碳")
{
if (cx.Gdt == "")
{
cx.Gdt = item.ReportVal;
}
}
}
cxs.Add(cx);
}
}
}
void LabTabs()
{
QC_SampleMix_ZhiYang_Table zyMix = new QC_SampleMix_ZhiYang_Table();
zyMix.LoadDataByWhere("SampleState=@SampleState and Mix_time>=@mixtime", 2, DateTime.Today);
// label4.Text = zyMix.Count.ToString();
List <string> tabs = new List <string>();
foreach (var item in zyMixSamples.LabTable)
{
if ((item.CheckGroupType == "立刻检验" || item.CheckGroupType == "后续检验"))
{
if (!tabs.Contains(item.CheckGroupName))
{
tabs.Add(item.CheckGroupName);
}
}
}
List <string> tabs2 = new List <string>();
foreach (XtraTabPage tabPage in xtraTabControl1.TabPages)
{
tabs2.Add(tabPage.Text);
}
bool xiangdeng = false;
tabs.Sort();
tabs2.Sort();
if (tabs.Count == tabs2.Count)
{
xiangdeng = true;
for (int i = 0; i < tabs.Count; i++)
{
if (tabs[i] != tabs2[i])
{
xiangdeng = false;
break;
}
}
}
if (!xiangdeng)
{
int oldIdx = xtraTabControl1.SelectedTabPageIndex;
xtraTabControl1.TabPages.Clear();
foreach (var item in tabs)
{
xtraTabControl1.TabPages.Add(item);
}
int selIdx = 0;
if (oldIdx >= 0 && oldIdx < xtraTabControl1.TabPages.Count)
{
selIdx = oldIdx;
}
xtraTabControl1.SelectedTabPageIndex = selIdx;
}
labTable.Empty();
if (xtraTabControl1.SelectedTabPage != null)
{
foreach (var item in zyMixSamples.LabTable)
{
if (item.CheckGroupName == xtraTabControl1.SelectedTabPage.Text)
{
labTable.Add(item);
}
}
if (labTable.Count > 0)
{
this.gridView3.FocusedRowHandle = 0;
}
}
}
private void 组批_Click(object sender, EventArgs e)
{
this.hjvehs.Save();
if (MessageBox.Show("确实要组批吗?", "提示", MessageBoxButtons.OKCancel) == DialogResult.OK)
{
Dictionary <string, List <QC_Sample_Veh> > vehFenzu = new Dictionary <string, List <QC_Sample_Veh> >();
vehFenzu.Clear();
foreach (var veh in hjvehs)
{
if (veh.zp)
{
string key = veh.MatPK + "_" + veh.SupplierCode;
if (vehFenzu.ContainsKey(key))
{
vehFenzu[key].Add(veh);
}
else
{
vehFenzu.Add(key, new List <QC_Sample_Veh>()
{
veh
});
}
}
}
foreach (var item in vehFenzu)
{
int xiaotongshu = item.Value.Count;
int datongshu = 1;
QC_Sample_Veh tempVeh = item.Value[0];
QC_Material matInfo = QC_Material.GetByCode(tempVeh.MatCode);
if (matInfo != null)
{
if (xiaotongshu <= matInfo.BatchNum)
{
datongshu = 1;
}
else if (xiaotongshu % matInfo.BatchNum == 0)
{
datongshu = item.Value.Count / matInfo.BatchNum;
}
else if (xiaotongshu % matInfo.BatchNum != 0)
{
datongshu = item.Value.Count / matInfo.BatchNum + 1;
}
}
if (datongshu > xiaotongshu)
{
datongshu = xiaotongshu;
}
Dictionary <int, List <int> > fp = FenZu(xiaotongshu, datongshu);
foreach (var fpItem in fp)
{
List <QC_Sample_Veh> vehs = new List <QC_Sample_Veh>();
foreach (var xtHao in fpItem.Value)
{
QC_Sample_Veh tempVeh2 = item.Value[xtHao];
vehs.Add(tempVeh2);
}
if (vehs.Count > 0)
{
QC_Sample_Mix mix = new QC_Sample_Mix();
mix.WpCode = "0083";
mix.MatCode = vehs[0].MatCode;
mix.MatPK = vehs[0].MatPK;
mix.Mix_Time = DateTime.Now;
mix.FangTong_Time = DateTime.Now;
mix.ShouTong_Time = DateTime.Now;
mix.ShouTong_User = LocalInfo.Current.user.ID;
mix.FangTong_User = LocalInfo.Current.user.ID;
mix.MixCount = vehs.Count;
mix.MixPlanCount = vehs.Count;
mix.SupplierCode = vehs[0].SupplierCode;
mix.MixUser = LocalInfo.Current.user.ID;
mix.SampleState = SampleState.组批完成;
mix.SampleType = SampleType.普通样;
mix.WLLX = vehs[0].WLLX;
mix.CardID = Zhc.Data.DbContext.GetSeq("HB" + DateTime.Now.Date.ToString("yyyyMMdd"), 2);
mix.Save();
hjmixs.Add(mix);
foreach (var veh in vehs)
{
veh.Sample_Mix_ID = mix.Sample_Mix_ID;
veh.Mix_Time = DateTime.Now;
veh.SampleState = SampleState.组批完成;
veh.Save();
}
QC_Sample_Mix mixpb = new QC_Sample_Mix();
mixpb.MatCode = vehs[0].MatCode;
mixpb.MatPK = vehs[0].MatPK;
mixpb.WpCode = "0083";
mixpb.WLLX = vehs[0].WLLX;
mixpb.Mix_Time = DateTime.Now;
mixpb.FangTong_Time = DateTime.Now;
mixpb.ShouTong_Time = DateTime.Now;
mixpb.ShouTong_User = LocalInfo.Current.user.ID;
mixpb.FangTong_User = LocalInfo.Current.user.ID;
mixpb.MixCount = vehs.Count;
mixpb.MixPlanCount = vehs.Count;
mixpb.SupplierCode = vehs[0].SupplierCode;
mixpb.MixUser = LocalInfo.Current.user.ID;
mixpb.CardID = "PB" + mix.CardID.Remove(0, 2);
mixpb.MainSampleMixId = mix.Sample_Mix_ID;
mixpb.SampleType = SampleType.破包样;
mixpb.SampleState = SampleState.组批完成;
mixpb.Save();
}
}
}
PrintZupi();
}
}
//抽取
private void button8_Click(object sender, EventArgs e)
{
initTaskbill();
if (sample_selected.Count > 0)
{
MessageBox.Show("已勾选其他物料，请先处理");
return;
}
int cq = 0;
long vehno = 0;
sampleNum sm = new sampleNum();
sm.showDialogEx("ChouQu");
if (sm.DialogResult != DialogResult.OK)
{
MessageBox.Show("没有确认取样的个数");
return;
}
else
{
cq = sm.chouNum;
vehno = sm.vehno;
}
if ((cq == 0))
{
MessageBox.Show("没有确认取样的个数");
return;
}
if ((vehno == 0))
{
MessageBox.Show("没有输入车号");
return;
}
sample_selected.LoadDataByWhere("vehno=@vehno order by fetchtime desc", vehno.ToString());
if (sample_selected.Count < 1)
{
MessageBox.Show("输入的车号不存在！！");
return;
}
DbEntityTable <QC_Sample_Mix> qc = new DbEntityTable <QC_Sample_Mix>();
for (int i = 0; i < cq; i++)
{
QC_Sample_Mix mix = new QC_Sample_Mix();
mix.WpCode = "Huoyun";
mix.MatCode = sample_selected[0].MatCode;
mix.MatPK = sample_selected[0].MatPK;
mix.Mix_Time = DateTime.Now;
mix.FangTong_Time = DateTime.Now;
mix.ShouTong_Time = DateTime.Now;
mix.ShouTong_User = LocalInfo.Current.user.ID;
mix.FangTong_User = LocalInfo.Current.user.ID;
mix.MixCount = sample_selected.Count;
mix.MixPlanCount = sample_selected.Count;
mix.SupplierCode = sample_selected[0].SupplierCode;
mix.MixUser = LocalInfo.Current.user.ID;
mix.SampleState = SampleState.开始组批;
mix.SampleType = SampleType.抽查样;
mix.WLLX = sample_selected[0].WLLX;
mix.StoreCode = Zhc.Data.DbContext.GetSeq("HY" + DateTime.Now.Date.ToString("yyyyMMdd"), 2);
//记住主样id
mix.MainSampleMixId = sample_selected[0].Sample_Mix_ID;
//记住车id
mix.NoticeBillId = sample_selected[0].Sample_Veh_ID.ToString();
qc.Add(mix);
}
qc.Save();
print();
//sample_selected[0].Sample_Mix_ID = mix.Sample_Mix_ID;
//sample_selected[0].Mix_Time = DateTime.Now;
//sample_selected[0].SampleType = SampleType.抽查样;
//sample_selected[0].SampleState = SampleState.组批完成;
//sample_selected[0].Save();
}
private void timer1_Tick(object sender, EventArgs e)
{
mixs.LoadDataByWhere("main.WLLX='石子' and main.SampleState=@SampleState", SampleState.初始状态);
qvs.LoadDataByWhere("WLLX='石子' and status=7 order by begintime desc");
for (int j = 0; j < qvs.Count; j++)
{
bool cunzai = false;
for (int m = 0; m < mixs.Count; m++)
{
if (qvs[j].CUSTCODE == mixs[m].SupplierCode && qvs[j].INVCODE == mixs[m].MatCode)
{
cunzai = true;
QC_Sample_Veh sm = new QC_Sample_Veh();
sm.begintime = qvs[j].begintime;
sm.WpCode = FrmMain.localinfo.workpoint.Code; //作业点编码
sm.FetchPerson = LocalInfo.Current.user.ID; //取样人ID
sm.VehNo = qvs[j].Cph; //车牌号
sm.NoticeBillId = qvs[j].NoticeId; //磁卡作业单号
// sm.Sample_Mix_ID = 0; //混样ID
sm.FetchTime = System.DateTime.Now; //取样时间
// sm.KouShui = StringTool.FNumVal(koushui.Text);
// sm.KouZa = StringTool.FNumVal(kouza.Text);
sm.WLLX = "石子";
sm.NcDhdBodyId = qvs[j].NcDhdBodyId; //车辆作业单主键
sm.MatCode = qvs[j].INVCODE; //物料编码
sm.MatName = qvs[j].INVNAME;
sm.SupplierCode = qvs[j].CUSTCODE; //供应商编码
sm.SupplierName = qvs[j].CUSTNAME;
sm.MatPK = qvs[j].PK_INVBASDOC; //物料主键
sm.NcDhdHeadNo = qvs[j].NcDhdHeadNo; //NC到货单
sm.Sample_Mix_ID = mixs[m].Sample_Mix_ID;
sm.zpdh = mixs[m].CardID;
sm.SampleState = SampleState.初始状态;
sm.zptime = DateTime.Now.ToString();
vehs.Add(sm);
DbContext.ExeSql("update tb_noticebill_head set status=8 where status=7 and noticebillid=@noticebillid", qvs[j].NoticeId);
vehs.Save();
}
}
if (cunzai == false)
{
QC_Sample_Mix mix = new QC_Sample_Mix();
mix.WpCode = "0091";
mix.MatCode = qvs[j].INVCODE;
mix.MatPK = qvs[j].PK_INVBASDOC;
// mix.MixCount = vehs.Count;
// mix.MixPlanCount = vehs.Count;
mix.SupplierCode = qvs[j].CUSTCODE;
mix.MixUser = LocalInfo.Current.user.ID;
mix.SampleState = SampleState.初始状态;
mix.SampleType = SampleType.普通样;
mix.WLLX = qvs[j].WLLX;
mix.CardID = Zhc.Data.DbContext.GetSeq("SZ" + DateTime.Now.Date.ToString("yyyyMMdd"), 2);
mix.Save();
mixs.Add(mix);
QC_Sample_Veh sm = new QC_Sample_Veh();
sm.begintime = qvs[j].begintime;
sm.WpCode = FrmMain.localinfo.workpoint.Code; //作业点编码
sm.FetchPerson = LocalInfo.Current.user.ID; //取样人ID
sm.VehNo = qvs[j].Cph; //车牌号
sm.NoticeBillId = qvs[j].NoticeId; //磁卡作业单号
// sm.Sample_Mix_ID = 0; //混样ID
sm.FetchTime = System.DateTime.Now; //取样时间
// sm.KouShui = StringTool.FNumVal(koushui.Text);
// sm.KouZa = StringTool.FNumVal(kouza.Text);
sm.WLLX = "石子";
sm.NcDhdBodyId = qvs[j].NcDhdBodyId; //车辆作业单主键
sm.MatCode = qvs[j].INVCODE; //物料编码
sm.MatName = qvs[j].INVNAME;
sm.SupplierCode = qvs[j].CUSTCODE; //供应商编码
sm.SupplierName = qvs[j].CUSTNAME;
sm.MatPK = qvs[j].PK_INVBASDOC; //物料主键
sm.NcDhdHeadNo = qvs[j].NcDhdHeadNo; //NC到货单
sm.Sample_Mix_ID = mix.Sample_Mix_ID;
sm.zpdh = mix.CardID;
sm.SampleState = SampleState.初始状态;
sm.zptime = DateTime.Now.ToString();
vehs.Add(sm);
DbContext.ExeSql("update tb_noticebill_head set status=8 where status=7 and noticebillid=@noticebillid", qvs[j].NoticeId);
vehs.Save();
}
}
}
private void 查询检验单_Click(object sender, EventArgs e)
{
cxs.Clear();
if (comboBox1.Text == "全部" && comboBox2.Text == "全部")
{
lab.LoadDataByWhere("main.JyTime>=@Ksdate and main.JyTime<=@Jsdate order by main.JyCode ", DateTime.Parse(this.dateEdit1.Text.Trim()), DateTime.Parse(this.dateEdit2.Text.Trim()));
}
else if (comboBox2.Text == "全部")
{
lab.LoadDataByWhere("main.JyTime>=@Ksdate and main.JyTime<=@Jsdate and main.CheckGroupName=@CheckGroupName order by main.JyCode ", DateTime.Parse(this.dateEdit1.Text.Trim()), DateTime.Parse(this.dateEdit2.Text.Trim()), comboBox1.Text);
}
else if (comboBox1.Text == "全部")
{
lab.LoadDataByWhere("main.JyTime>=@Ksdate and main.JyTime<=@Jsdate and main.MatName=@MatName order by main.JyCode ", DateTime.Parse(this.dateEdit1.Text.Trim()), DateTime.Parse(this.dateEdit2.Text.Trim()), comboBox2.Text);
}
else
{
lab.LoadDataByWhere("main.JyTime>=@Ksdate and main.JyTime<=@Jsdate and main.CheckGroupName=@CheckGroupName and main.MatName=@MatName order by main.JyCode ", DateTime.Parse(this.dateEdit1.Text.Trim()), DateTime.Parse(this.dateEdit2.Text.Trim()), comboBox1.Text, comboBox2.Text);
}
for (int i = 0; i < lab.Count; i++)
{
QC_Shcx cx = new QC_Shcx();
lab[i].CheckVals.LoadDataByWhere("main.Sample_Lab_ID=@Sample_Lab_ID", lab[i].Sample_Lab_ID);
cx.Sample_Shcx_ID = i + 1;
cx.Yplx = lab[i].CheckGroupName;
cx.Lybm = lab[i].JyCode;
cx.Jyr = lab[i].JyUser;
cx.Jysj = lab[i].JyTime;
if (lab[i].MatName == "")
{
mcg.LoadDataByWhere("main.Sample_Lab_ID=@Sample_Lab_ID", lab[i].Sample_Lab_ID);
mix.LoadDataByWhere("main.Sample_Mix_ID=@Sample_Lab_ID", mcg[0].Sample_Mix_ID);
wl.LoadDataByWhere("PK_INVBASDOC=@PK_INVBASDOC", mix[0].MatPK);
cx.Wlmc = wl[0].INVNAME;
}
else
{
cx.Wlmc = lab[i].MatName;
}
for (int j = 0; j < lab[i].CheckVals.Count; j++)
{
if (lab[i].CheckVals[j].CheckUser != "")
{
cx.Fxry = lab[i].CheckVals[j].CheckUser;
cx.Fxsj = lab[i].CheckVals[j].CheckTime;
}
if (lab[i].CheckVals[j].CheckItemName.Equals("灰分"))
{
cx.Hf = lab[i].CheckVals[j].CheckVal;
}
else if (lab[i].CheckVals[j].CheckItemName.Equals("挥发分"))
{
cx.Hff = lab[i].CheckVals[j].CheckVal;
}
else if (lab[i].CheckVals[j].CheckItemName.Equals("S"))
{
cx.S = lab[i].CheckVals[j].CheckVal;
}
else if (lab[i].CheckVals[j].CheckItemName.Equals("固定碳"))
{
cx.Gdt = lab[i].CheckVals[j].CheckVal;
}
else if (lab[i].CheckVals[j].CheckItemName.Equals("G"))
{
cx.G = lab[i].CheckVals[j].CheckVal;
}
else if (lab[i].CheckVals[j].CheckItemName.Equals("Y"))
{
cx.Y = lab[i].CheckVals[j].CheckVal;
}
else if (lab[i].CheckVals[j].CheckItemName.Equals("P"))
{
cx.P = lab[i].CheckVals[j].CheckVal;
}
else if (lab[i].CheckVals[j].CheckItemName.Equals("MgO"))
{
cx.MgO = lab[i].CheckVals[j].CheckVal;
}
else if (lab[i].CheckVals[j].CheckItemName.Equals("SiO2"))
{
cx.SiO2 = lab[i].CheckVals[j].CheckVal;
}
else if (lab[i].CheckVals[j].CheckItemName.Equals("CaO"))
{
cx.CaO = lab[i].CheckVals[j].CheckVal;
}
else if (lab[i].CheckVals[j].CheckItemName.Equals("Al2O3"))
{
cx.Al2O3 = lab[i].CheckVals[j].CheckVal;
}
else if (lab[i].CheckVals[j].CheckItemName.Equals("TFe"))
{
cx.TFe = lab[i].CheckVals[j].CheckVal;
}
else if (lab[i].CheckVals[j].CheckItemName.Equals("TiO2"))
{
cx.TiO2 = lab[i].CheckVals[j].CheckVal;
}
else if (lab[i].CheckVals[j].CheckItemName.Equals("Cu"))
{
cx.Cu = lab[i].CheckVals[j].CheckVal;
}
else if (lab[i].CheckVals[j].CheckItemName.Equals("MnO"))
{
cx.MnO = lab[i].CheckVals[j].CheckVal;
}
else if (lab[i].CheckVals[j].CheckItemName.Equals("K2O"))
{
cx.K2O = lab[i].CheckVals[j].CheckVal;
}
else if (lab[i].CheckVals[j].CheckItemName.Equals("Na2O"))
{
cx.Na2O = lab[i].CheckVals[j].CheckVal;
}
else if (lab[i].CheckVals[j].CheckItemName.Equals("V2O5"))
{
cx.V2O5 = lab[i].CheckVals[j].CheckVal;
}
else if (lab[i].CheckVals[j].CheckItemName.Equals("Pb"))
{
cx.Pb = lab[i].CheckVals[j].CheckVal;
}
else if (lab[i].CheckVals[j].CheckItemName.Equals("Zn"))
{
cx.Zn = lab[i].CheckVals[j].CheckVal;
}
else if (lab[i].CheckVals[j].CheckItemName.Equals("As"))
{
cx.As = lab[i].CheckVals[j].CheckVal;
}
else if (lab[i].CheckVals[j].CheckItemName.Equals("Sn"))
{
cx.Sn = lab[i].CheckVals[j].CheckVal;
}
else if (lab[i].CheckVals[j].CheckItemName.Equals("Sb"))
{
cx.Sb = lab[i].CheckVals[j].CheckVal;
}
else if (lab[i].CheckVals[j].CheckItemName.Equals("硫分"))
{
cx.Lf = lab[i].CheckVals[j].CheckVal;
}
}
bool cunzai = false;
foreach (var item in cxs)
{
if (item.Sample_Shcx_ID == cx.Sample_Shcx_ID)
{
cunzai = true;
}
}
if (cunzai == false)
{
cxs.Add(cx);
}
}
this.gridControl1.DataSource = cxs;
}
public void regexString(string input)
{
try
{
string str = "";
Match match = Regex.Match(input, @"Sample:\s+(?<Sample>[^\r\s\t]+)");
if ((match != null) && (match.Groups.Count > 0))
{
str = match.Groups["Sample"].Value.Replace(",", "");
}
string strTime = "";
//Date: 17,13 28,07,16
match = Regex.Match(input, @"Date:\s+(?<Date>[^\r\n]+)");
if ((match != null) && (match.Groups.Count > 0))
{
string str1 = match.Groups["Date"].Value.Replace(",", "").Trim();
strTime = "20" + str1.Substring(9, 2) + "-" + str1.Substring(7, 2) + "-" + str1.Substring(5, 2) + " " + str1.Substring(0, 2) + ":" + str1.Substring(2, 2);
}
StringBuilder sb = new StringBuilder();
for (match = Regex.Match(input, @"(?<Element>MnO|Ni|As|Sn|Sb|S|P|MgO|SiO2|CaO|Al2O3|TFe|R|TiO2|Mo|Cr|K2O|Na2O|Pb|V2O5|Zn|Cu)\s?:\s?(?<Value>[0-9.+-]+)"); (match != null) && match.Success; match = match.NextMatch())
{
QC_Sample_Jyjg t2 = new QC_Sample_Jyjg();
t2.CheckItemCode = "";
t2.CheckItemName = match.Groups["Element"].Value.ToString();
t2.Date = strTime;
t2.JYShebei = "荧光";
t2.SampleName = str;
if (Convert.ToDouble(match.Groups["Value"].Value) < 0.0)
{
t2.Value = "0";
}
else
{
t2.Value = match.Groups["Value"].Value.ToString();
}
Boolean flag = true;
for (int i = 0; i < test.Count && flag; i++)
{
if (test[i].SampleName == t2.SampleName && test[i].CheckItemName == t2.CheckItemName)
{
flag = false;
sb.Append("单号：" + test[i].SampleName + "," + "检验项目" + test[i].CheckItemName + "已存在");
sb.Append("\r\n");
}
}
if (flag)
{
test.Add(t2);
}
}
if ((test.Count > 0) && (str != ""))
{
test.Save();
}
test.Clear();
test.LoadDataByWhere("shangchuan=0 and JYShebei=@JYShebei order by date desc", "荧光");
if (sb.Length > 1)
{
MessageBox.Show(sb.ToString());
}
}
catch
{
}
}
private void 查询制样单_Click(object sender, EventArgs e)
{
cxs.Clear();
if (this.dateEdit1.Text != "" && this.dateEdit2.Text != "")
{
if (comboBox2.Text == "全部")
{
zyMixSamples.LoadDataByWhere("main.ZyRecvTime>=@Kssj and main.ZyRecvTime<=@Jssj order by main.ZyRecvTime", DateTime.Parse(this.dateEdit1.Text.Trim()), DateTime.Parse(this.dateEdit2.Text.Trim()));
}
else if (comboBox2.Text == "普通样")
{
zyMixSamples.LoadDataByWhere("main.ZyRecvTime>=@Kssj and main.ZyRecvTime<=@Jssj and main.SampleType=@SampleType order by main.ZyRecvTime", DateTime.Parse(this.dateEdit1.Text.Trim()), DateTime.Parse(this.dateEdit2.Text.Trim()), SampleType.普通样);
}
else if (comboBox2.Text == "抽查样")
{
zyMixSamples.LoadDataByWhere("main.ZyRecvTime>=@Kssj and main.ZyRecvTime<=@Jssj and main.SampleType=@SampleType order by main.ZyRecvTime", DateTime.Parse(this.dateEdit1.Text.Trim()), DateTime.Parse(this.dateEdit2.Text.Trim()), SampleType.抽查样);
}
else if (comboBox2.Text == "快样")
{
zyMixSamples.LoadDataByWhere("main.ZyRecvTime>=@Kssj and main.ZyRecvTime<=@Jssj and main.SampleType=@SampleType and main.Wpcode=@Wpcode order by main.ZyRecvTime", DateTime.Parse(this.dateEdit1.Text.Trim()), DateTime.Parse(this.dateEdit2.Text.Trim()), SampleType.普通样, "");
}
for (int i = 0; i < zyMixSamples.Count; i++)
{
if (comboBox1.Text == "全部")
{
zyMixSamples[i].CheckGroups.LoadDataByWhere("main.Sample_Mix_ID=@Sample_Mix_ID", zyMixSamples[i].Sample_Mix_ID);
}
else
{
zyMixSamples[i].CheckGroups.LoadDataByWhere("main.Sample_Mix_ID=@Sample_Mix_ID and main.CheckGroupName=@CheckGroupName", zyMixSamples[i].Sample_Mix_ID, comboBox1.Text);
}
for (int j = 0; j < zyMixSamples[i].CheckGroups.Count; j++)
{
if (zyMixSamples[i].CheckGroups[j].Sample_Lab_ID != 0)
{
labs.LoadDataByWhere("main.Sample_Lab_ID=@Sample_Lab_ID", zyMixSamples[i].CheckGroups[j].Sample_Lab_ID);
}
QC_Zycx cx = new QC_Zycx();
cx.Sample_Shcx_ID = i + 1;
cx.Sksj = zyMixSamples[i].ZyRecvTime;
cx.Lybm = zyMixSamples[i].ZyDanHao;
cx.Jzcph = zyMixSamples[i].ZyJzZuPiHao;
if (zyMixSamples[i].SampleType == SampleType.普通样 && zyMixSamples[i].WpCode != "")
{
cx.Qylx = "普通样";
}
else if (zyMixSamples[i].SampleType == SampleType.普通样 && zyMixSamples[i].WpCode == "")
{
cx.Qylx = "快样";
}
else if (zyMixSamples[i].SampleType == SampleType.抽查样)
{
cx.Qylx = "抽查样";
}
cx.Jyr = zyMixSamples[i].ZyRecvUser;
cx.Ypbm = zyMixSamples[i].CheckGroups[j].StoreCode;
cx.Yplx = zyMixSamples[i].CheckGroups[j].CheckGroupName;
if (labs.Count > 0)
{
if (labs[0].MakeTime == null)
{
cx.Syr = null;
}
else
{
cx.Syr = labs[0].MakeUser;
}
cx.Sysj = labs[0].MakeTime;
}
labs.Clear();
cxs.Add(cx);
}
}
}
else
{
MessageBox.Show("请输入时间段");
}
}
private void 查询_Click(object sender, EventArgs e)
{
cxs.Clear();
zyMixSamples.LoadDataByWhere("main.Mix_Time>=@Kssj and main.Mix_Time<=@Jssj and (main.LocalQcLevel<> ''or main.Sample_Cylx='管理抽样' or main.Sample_Cylx='普通抽样' ) order by main.Mix_Time ", DateTime.Parse(this.dateEdit1.Text.Trim()), DateTime.Parse(this.dateEdit2.Text.Trim()));
for (int i = 0; i < zyMixSamples.Count; i++)
{
string cph = txtCph.Text.Trim();
if (comboBox2.Text == "全部")
{
vehs.LoadDataByWhere(string.Format("VehNo like '%{0}%' and (Sample_Mix_ID=@Sample_Mix_ID or NoticeBillId=@NoticeBillId) ", cph), zyMixSamples[i].Sample_Mix_ID, zyMixSamples[i].NoticeBillId);
}
else
{
vehs.LoadDataByWhere(string.Format("VehNo like '%{0}%' and (Sample_Mix_ID=@Sample_Mix_ID or NoticeBillId=@NoticeBillId) and dhd.INVNAME=@MatName ", cph), zyMixSamples[i].Sample_Mix_ID, zyMixSamples[i].NoticeBillId, comboBox2.Text);
}
zyMixSamples[i].CheckVals.LoadDataBySampleMixId(zyMixSamples[i].Sample_Mix_ID);
for (int j = 0; j < vehs.Count; j++)
{
QC_Zhkcx cx = new QC_Zhkcx();
cx.Tempid = zyMixSamples[i].TempID;
cx.Sjsl = vehs[j].Sjsl;
cx.Xh = i + 1;
cx.Ch = vehs[j].VehNo;
cx.Wlmc = zyMixSamples[i].MatName;
cx.Qysj = vehs[j].FetchTime;
cx.Gysmc = zyMixSamples[i].SupplierName;
cx.Pddj = zyMixSamples[i].LocalQcLevel;
cx.FetchPlace = zyMixSamples[i].FetchPlace;
cx.FetchPerson = zyMixSamples[i].FetchPerson;
cx.Zyd = zyMixSamples[i].WpCode;
if (zyMixSamples[i].Sample_Cylx == "" || zyMixSamples[i].Sample_Cylx == null)
{
cx.Yplx = zyMixSamples[i].LeiXing;
}
else
{
cx.Yplx = zyMixSamples[i].Sample_Cylx;
}
cx.Ks = vehs[j].KouShui;
cx.Kz = vehs[j].KouZa;
foreach (var item in zyMixSamples[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 == "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 == "标准差S")
{
cx.Bzc = item.ReportVal;
}
else if (item.CheckItemName == "Rmax")
{
cx.Rmax = item.ReportVal;
}
else if (item.CheckItemName == "可磨性")
{
cx.Kmx = item.ReportVal;
}
else if (item.CheckItemName == "发热量")
{
cx.Rz = item.ReportVal;
}
else if (item.CheckItemName == "P")
{
cx.P = item.ReportVal;
}
else if (item.CheckItemName == "S")
{
cx.S = item.ReportVal;
}
}
cxs.Add(cx);
}
}
}
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);
}
}
private void 查询_Click(object sender, EventArgs e)
{
cxs.Clear();
mix.Clear();
mcg.Clear();
mcgzong.Clear();
lab.Clear();
labzong.Clear();
veh.Clear();
if (comboBox1.Text == "全部" && comboBox2.Text == "全部")
{
mix.LoadDataByWhere("main.mix_time>=@Ksdate and main.mix_time<=@Jsdate and main.wllx='煤'", DateTime.Parse(this.dateEdit1.Text.Trim()), DateTime.Parse(this.dateEdit2.Text.Trim()));
}
else if (comboBox2.Text == "全部")
{
mix.LoadDataByWhere("main.mix_time>=@Ksdate and main.mix_time<=@Jsdate and supplier.CUSTSHORTNAME=@SupplierName and main.wllx='煤'", DateTime.Parse(this.dateEdit1.Text.Trim()), DateTime.Parse(this.dateEdit2.Text.Trim()), comboBox1.Text);
}
else if (comboBox1.Text == "全部")
{
mix.LoadDataByWhere("main.mix_time>=@Ksdate and main.mix_time<=@Jsdate and mat.INVNAME=@MatName and main.wllx='煤'", DateTime.Parse(this.dateEdit1.Text.Trim()), DateTime.Parse(this.dateEdit2.Text.Trim()), comboBox2.Text);
}
else
{
mix.LoadDataByWhere("main.mix_time>=@Ksdate and main.mix_time<=@Jsdate and supplier.CUSTSHORTNAME=@SupplierName and mat.INVNAME=@MatName and main.wllx='煤'", DateTime.Parse(this.dateEdit1.Text.Trim()), DateTime.Parse(this.dateEdit2.Text.Trim()), comboBox1.Text, comboBox2.Text);
}
foreach (var item in mix)
{
mcg.LoadDataByWhere("main.Sample_Mix_ID=@Sample_Mix_ID and checkgroupname='化验样'", item.Sample_Mix_ID);
mcgzong.Add(mcg[0]);
}
foreach (var item in mcgzong)
{
lab.LoadDataByWhere("main.Sample_Lab_ID=@Sample_Lab_ID and labstate='审核通过' and billtype='审核通过'", item.Sample_Lab_ID);
if (lab.Count > 0)
{
labzong.Add(lab[0]);
}
}
for (int i = 0; i < labzong.Count; i++)
{
labzong[i].CheckVals.LoadDataByWhere("main.Sample_Lab_ID=@Sample_Lab_ID", labzong[i].Sample_Lab_ID);
mcg.LoadDataByWhere("main.Sample_Lab_ID=@Sample_Lab_ID", labzong[i].Sample_Lab_ID);
mix.LoadDataByWhere("main.Sample_Mix_ID=@Sample_Lab_ID", mcg[0].Sample_Mix_ID);
wl.LoadDataByWhere("PK_INVBASDOC=@PK_INVBASDOC", mix[0].MatPK);
veh.LoadDataByWhere("Sample_Mix_ID=@Sample_Mix_ID", mcg[0].Sample_Mix_ID);
foreach (var item in veh)
{
QC_Shcx cx = new QC_Shcx();
// cx.Sample_Shcx_ID = i + 1;
cx.Yplx = labzong[i].CheckGroupName;
cx.Lybm = labzong[i].JyCode;
cx.Jyr = labzong[i].JyUser;
cx.Jysj = labzong[i].JyTime;
cx.Gys = mix[0].SupplierName;
if (labzong[i].MatName == "")
{
cx.Wlmc = wl[0].INVNAME;
}
else
{
cx.Wlmc = labzong[i].MatName;
}
cx.Cph = item.VehNo;
cx.Qysj = item.FetchTime;
for (int j = 0; j < labzong[i].CheckVals.Count; j++)
{
if (labzong[i].CheckVals[j].CheckItemName.Equals("灰分"))
{
cx.Hf = labzong[i].CheckVals[j].CheckVal;
}
else if (labzong[i].CheckVals[j].CheckItemName.Equals("挥发分"))
{
cx.Hff = labzong[i].CheckVals[j].CheckVal;
}
else if (labzong[i].CheckVals[j].CheckItemName.Equals("S"))
{
cx.S = labzong[i].CheckVals[j].CheckVal;
}
else if (labzong[i].CheckVals[j].CheckItemName.Equals("固定碳"))
{
cx.Gdt = labzong[i].CheckVals[j].CheckVal;
}
else if (labzong[i].CheckVals[j].CheckItemName.Equals("硫分"))
{
cx.Lf = labzong[i].CheckVals[j].CheckVal;
}
else if (labzong[i].CheckVals[j].CheckItemName.Equals("发热量1"))
{
cx.Frl = labzong[i].CheckVals[j].CheckVal;
}
}
cxs.Add(cx);
this.gridControl1.DataSource = cxs;
}
}
}
private void 采集_Click(object sender, EventArgs e)
{
object JQCode = DbContext.ExecuteScalar("select max(JQCode) from QC_Sample_Jyjg where JYShebei='" + DeviceConfigManager.Instance.config.Jysb.ToString() + "'");
// object time = DbContext.ExecuteScalar("select max(date) from QC_Sample_Jyjg where JYShebei='" + DeviceConfigManager.Instance.config.Jysb.ToString() + "'");
//
string str;
if (DeviceConfigManager.Instance.config.Jysbsjk.EndsWith("AutoMac.mdb"))
{
if (!(JQCode is DBNull))
{
str = "SELECT * FROM testresult where SerialNumber>'" + Convert.ToString(JQCode) + "'";
}
else
{
str = "SELECT * FROM testresult where date>#" + DateTime.Now.AddHours(-24).ToString() + "#";
}
}
else
{
if (!(JQCode is DBNull))
{
str = "SELECT * FROM SDS212 where AutoNmb>'" + Convert.ToString(JQCode) + "'";
}
else
{
str = "SELECT * FROM SDS212 where testdate>#" + DateTime.Now.AddHours(-48).ToString() + "#";
}
}
string password = "";
if (DeviceConfigManager.Instance.config.Jysbsjk.EndsWith("AutoMac.mdb"))
{
password = "******";
}
else
{
password = "******";
}
OleDbConnection cn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + DeviceConfigManager.Instance.config.Jysbsjk + ";Jet OLEDB:Database Password="******";Persist Security Info=False");
cn.Open();
OleDbCommand comm = new OleDbCommand(str, cn);
OleDbDataReader dr = comm.ExecuteReader();
// test.Clear();
bool tuichu = true;
int i = 0;
foreach (var item in System.Diagnostics.Process.GetProcesses())
{
if (item.ProcessName.StartsWith("AutoMac"))
{
tuichu = false;
MessageBox.Show("请先退出工业分析仪程序");
return;
}
else if (item.ProcessName.StartsWith("SDS"))
{
tuichu = false;
MessageBox.Show("请先退出硫分仪程序");
return;
}
}
if (tuichu)
{
while (dr.Read())
{
if (DeviceConfigManager.Instance.config.Jysbsjk.EndsWith("AutoMac.mdb"))
{
QC_Sample_Jyjg t = new QC_Sample_Jyjg();
t.CheckItemCode = "10011";
t.CheckItemName = "灰分";
t.JQCode = dr["SerialNumber"].ToString();
t.Date = Convert.ToDateTime(dr["Date"]).ToString("yyyy-MM-dd HH:mm:ss");
t.JYShebei = DeviceConfigManager.Instance.config.Jysb;
t.SampleName = dr["SampleName"].ToString();
t.Value = dr["Ad"].ToString();
QC_Sample_Jyjg t1 = new QC_Sample_Jyjg();
t1.CheckItemCode = "10012";
t1.CheckItemName = "挥发分";
t1.JQCode = dr["SerialNumber"].ToString();
t1.Date = Convert.ToDateTime(dr["Date"]).ToString("yyyy-MM-dd HH:mm:ss");
t1.JYShebei = DeviceConfigManager.Instance.config.Jysb;
t1.SampleName = dr["SampleName"].ToString();
t1.Value = Convert.ToDecimal(dr["Vdaf"]).ToString("0.0");
QC_Sample_Jyjg t2 = new QC_Sample_Jyjg();
t2.CheckItemCode = "10016";
t2.CheckItemName = "固定碳";
t2.JQCode = dr["SerialNumber"].ToString();
t2.Date = Convert.ToDateTime(dr["Date"]).ToString("yyyy-MM-dd HH:mm:ss");
t2.JYShebei = DeviceConfigManager.Instance.config.Jysb;
t2.SampleName = dr["SampleName"].ToString();
t2.Value = dr["Fcad"].ToString();
test.Add(t);
test.Add(t1);
test.Add(t2);
i += 3;
}
else
{
QC_Sample_Jyjg t = new QC_Sample_Jyjg();
t.CheckItemCode = "10002";
t.CheckItemName = "S";
t.JQCode = dr["AutoNmb"].ToString();
t.Date = Convert.ToDateTime(dr["TestDate"]).ToString("yyyy-MM-dd") + " " + Convert.ToDateTime(dr["TestTime"]).ToString("HH:mm:ss");
t.JYShebei = DeviceConfigManager.Instance.config.Jysb;
t.SampleName = dr["Name"].ToString();
t.Value = dr["Stad"].ToString();
test.Add(t);
i++;
}
}
}
test.Save();
cn.Close();
test.LoadDataByWhere("shangchuan=0 and JYShebei='" + DeviceConfigManager.Instance.config.Jysb + "' and Date>'" + DateTime.Now.AddHours(-24).ToString("yyyy-MM-dd HH:mm:ss") + "' order by CheckItemCode asc,date desc");
MessageBox.Show(i.ToString() + "条数据采集完成");
this.gridControl1.DataSource = test;
}
private void gridView1_FocusedRowObjectChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowObjectChangedEventArgs e)
{
if (SelectedMixSample != null && SelectedMixSample.DataState != DataRowState.Unchanged)
{
DialogResult result = MessageBox.Show("当前数据已修改,是否保存?", "询问", MessageBoxButtons.YesNoCancel);
if (result == DialogResult.Yes)
{
SaveSample();
}
else if (result == DialogResult.No)
{
this.SelectedMixSample.VehSamples.RejectChanges();
this.SelectedMixSample.CheckVals.RejectChanges();
this.SelectedMixSample.RejectChanges();
}
else
{
return;
}
}
SelectedMixSample = e.Row as QC_Sample_Mix;
if (SelectedMixSample != null)
{
DbEntityTable <QC_QualityRule_View> quality = new DbEntityTable <QC_QualityRule_View>();
quality.LoadDataByWhere("MATNCID=@MATNCID and LocalQcLevel='一级' and suppliercode=@suppliercode", SelectedMixSample.MatPK, SelectedMixSample.SupplierCode);
if (quality.Count == 0)
{
quality.LoadDataByWhere("MATNCID=@MATNCID and QualityLevelName='合格' and suppliercode=@suppliercode", SelectedMixSample.MatPK, SelectedMixSample.SupplierCode);
}
if (quality.Count == 0)
{
quality.LoadDataByWhere("MATNCID=@MATNCID and LocalQcLevel='一级'", SelectedMixSample.MatPK);
if (quality.Count == 0)
{
quality.LoadDataByWhere("MATNCID=@MATNCID and QualityLevelName='合格'", SelectedMixSample.MatPK);
}
}
foreach (var it in SelectedMixSample.CheckVals)
{
DbEntityTable <QC_QualityRule_View> qualityhege = new DbEntityTable <QC_QualityRule_View>();
if (it.CheckVal != "")
{
foreach (var item in quality)
{
if (item.CheckItemCode == it.CheckItemCode)
{
qualityhege.Add(item);
}
}
if (qualityhege.Count == 1 && !GetBool(it.CheckVal + qualityhege[0].Relation + qualityhege[0].ConstraintVal))
{
it.VisIdx = 100000;
}
else if (qualityhege.Count == 2 && (!GetBool(it.CheckVal + qualityhege[0].Relation + qualityhege[0].ConstraintVal) || !GetBool(it.CheckVal + qualityhege[1].Relation + qualityhege[1].ConstraintVal)))
{
it.VisIdx = 100000;
}
}
}
}
}
private void 新增_Click(object sender, EventArgs e)
{
QC_Sample_zdpdyj i = new QC_Sample_zdpdyj();
yjs.Add(i);
}