private void _Click(object sender, EventArgs e)
{
int i = 0;
StringBuilder sb = new StringBuilder();
try
{
foreach (var item in test)
{
if (item.Shangchuan)
{
hyy.LoadDataByWhere("JyCode=@JyCode", QC_Sample_Mix.FullStoreCode(item.SampleName));
if (hyy.Count > 0)
{
vals.LoadDataByWhere("main.Sample_Lab_ID=@Sample_Lab_ID", hyy[0].Sample_Lab_ID);
if (vals.Count > 0)
{
foreach (var it in vals)
{
if (it.CheckItemName == item.CheckItemName && (it.CheckVal == "" || it.CheckVal == null))
{
it.CheckVal = item.Value;
item.Shangchuan = true;
i++;
sb.Append("单号：" + item.SampleName + "," + "检验项目" + item.CheckItemName + "上传成功");
sb.Append("\r\n");
}
}
vals.Save();
}
}
}
}
test.Save();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
if (i > 0)
{
MessageBox.Show(i.ToString() + "条数据上传完成" + "\r\n" + sb.ToString());
}
else
{
MessageBox.Show("没有可匹配项目");
}
reloadData();
}
/// <summary>
/// 勾兑火车物料到货单
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button1_Click(object sender, EventArgs e)
{
var view3 = gridView3;
View_arrivebill bill = view3.GetFocusedRow() as View_arrivebill;
if (bill == null)
{
MessageBox.Show("没有NC到货单！");
return;
}
if (MessageBox.Show("请确认勾选的是" + bill.custname + "的" + bill.invname, "提示", MessageBoxButtons.YesNo) == DialogResult.No)
{
return;
}
initTaskbill();
if (!checkMat())
{
MessageBox.Show("请检查物料、到货单，必须是同一物料、同一到货单", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
//QC_Sample_Veh train = view.GetRow(0) as QC_Sample_Veh;
//var hc= train.CardID;
//if (hcph != "" && hc != hcph)
//{
// MessageBox.Show("请先取样："+hcph);
// return;
//}
foreach (var item in sample_unselect)
{
if (item.zp)
{
//状态 0 改变成1
item.SampleState = Xg.Lab.Sample.SampleState.开始组批;
item.WpCode = "HYQY";
item.MatCode = bill.invcode;
item.MatPK = bill.cbaseid;
item.NcDhdHeadNo = bill.varrordercode;
item.SupplierCode = bill.custcode;
//取样人
item.FetchPerson = LocalInfo.Current.user.ID;
//取样时间
item.FetchTime = DateTime.Now;
}
}
sample_unselect.Save();
initview();
//gridControl1.DataSource = trainData;
}
/// <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 koushuikouza_Load(object sender, EventArgs e)
{
vehs.LoadDataByWhere("main.Sample_Mix_ID=@Sample_Mix_ID", samplemixid);
mixs.LoadDataByWhere("main.Sample_Mix_ID=@Sample_Mix_ID or main.MainSampleMixId=@MainSampleMixId", samplemixid, samplemixid);
foreach (var item in mixs)
{
item.Memo = textBox1.Text;
}
mixs.Save();
this.qCSampleVehBindingSource.DataSource = vehs;
labelzydh.Text = QC_Sample_Mix.ShortStoreCode(zydanhao);
}
public void print()
{
initPrintbill();
//printPreviewDialog1.ShowDialog();
printDocument1.Print();
//打印完成后，大样状态从开始组批变为组批完成
foreach (var mix in printbill)
{
mix.SampleState = SampleState.组批完成;
}
printbill.Save();
//刷新任务单
initTaskbill();
}
private void _Click(object sender, EventArgs e)
{
int i = 0;
foreach (var item in test)
{
if (item.Shangchuan)
{
hyy.LoadDataByWhere("JyCode=@JyCode", QC_Sample_Mix.FullStoreCode(item.SampleName));
if (hyy.Count > 0)
{
vals.LoadDataByWhere("main.Sample_Lab_ID=@Sample_Lab_ID", hyy[0].Sample_Lab_ID);
}
else
{
vals.Clear();
}
if (vals.Count > 0)
{
foreach (var it in vals)
{
if ((it.CheckItemCode == item.CheckItemCode || (it.CheckItemCode == "10120" && item.CheckItemCode == "10002")) && (it.CheckVal == "" || it.CheckVal == null))
{
it.CheckVal = item.Value;
item.Shangchuan = true;
i++;
}
}
}
else
{
item.Shangchuan = false;
}
}
vals.Save();
}
test.Save();
if (i > 0)
{
MessageBox.Show(i.ToString() + "条数据上传完成");
}
else
{
MessageBox.Show("没有可匹配项目");
}
}
/// <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();
}
}
private void 通过审核_Click(object sender, EventArgs e)
{
if (curLab != null)
{
curLab.Billtype = "审核通过";
curLab.LabState = "审核通过";
foreach (var item in curLab.CheckVals)
{
item.Auditor = FrmMain.localinfo.user.Name;
item.AuditTime = DateTime.Now;
}
curLab.SaveCheckVals = true;
pici.Save();
loadData();
}
else
{
MessageBox.Show("没有选择数据");
}
}
private void btnOk_Click(object sender, EventArgs e)
{
data.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();
}
}
}
/// <summary>
/// 重新勾兑
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button6_Click_1(object sender, EventArgs e)
{
if (MessageBox.Show("确认要进行重新勾兑吗", "确认", MessageBoxButtons.YesNo) == DialogResult.No)
{
return;
}
if (hcph != "")
{
MessageBox.Show("请先打印已勾选的火车");
return;
}
if (cmbHCPH.Text.Trim() == "")
{
MessageBox.Show("请输入火车勾号");
return;
}
//else
//{
// sample_unselect.LoadDataByWhere("wllx='火运' and cardid=@cardid order by begintime", cmbHCPH.Text.Trim());
//}
//foreach (var item in sample_unselect)
//{
// item.SampleState = Xg.Lab.Sample.SampleState.初始状态;
// item.WpCode = "";
// item.MatCode = "";
// item.MatPK = "";
// item.NcDhdHeadNo = "";
// item.SupplierCode = "";
// //取样人
// item.FetchPerson = LocalInfo.Current.user.ID;
// //取样时间
// item.FetchTime = DateTime.Now;
// item.zp = false;
//}
//sample_unselect.Save();
//bstrain.DataSource = sample_unselect;
if (!checkMat())
{
MessageBox.Show("请检查物料、到货单，必须是同一物料、同一到货单");
return;
}
var view3 = gridView3;
View_arrivebill bill = view3.GetFocusedRow() as View_arrivebill;
if (bill == null)
{
MessageBox.Show("没有NC到货单！");
return;
}
foreach (var item in sample_unselect)
{
if (item.zp)
{
//item.SampleState = Xg.Lab.Sample.SampleState.开始组批;
//item.WpCode = "HYQY";
item.MatCode = bill.invcode;
item.MatPK = bill.cbaseid;
item.NcDhdHeadNo = bill.varrordercode;
item.SupplierCode = bill.custcode;
//取样人
item.FetchPerson = item.FetchPerson + "~~" + LocalInfo.Current.user.ID;
//取样时间
item.FetchTime = DateTime.Now;
}
}
sample_unselect.Save();
DbEntityTable <QC_Sample_Mix> dbmix = new DbEntityTable <QC_Sample_Mix>();
dbmix.LoadDataByWhere("main.sample_mix_id in ( select distinct(sample_mix_id) from qc_sample_veh where cardid='" + cmbHCPH.Text.Trim() + "')");
foreach (var item in dbmix)
{
//item.SampleState = SampleState.处理完成;
item.MatCode = bill.invcode;
item.MatPK = bill.cbaseid;
item.SupplierCode = bill.custcode;
}
dbmix.Save();
initview();
MessageBox.Show("操作成功！");
}
private void btnSave_Click(object sender, EventArgs e)
{
checkGroup.Save();
btnSave.Enabled = false;
MessageBox.Show("保存完成");
}
private void button1_Click(object sender, EventArgs e)
{
vehs.Save();
}
private void btnSave_Click(object sender, EventArgs e)
{
wpRoutes.Save();
btnSave.Enabled = false;
}
private void 确定_Click(object sender, EventArgs e)
{
vehs.Save();
this.Close();
}
/// <summary>
/// 绑扣
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button9_Click(object sender, EventArgs e)
{
if (CardID == "")
{
MessageBox.Show("请刷扣");
return;
}
DbEntityTable <QC_IC_Info> hycrds = new DbEntityTable <QC_IC_Info>();
hycrds.LoadDataByWhere("CardID=@CardID and CardType=@CardType ", CardID, "CUT002");
if (hycrds.Count == 0)
{
CardID = "";
label2.Text = "该扣类型不对!";
label2.ForeColor = Color.Red;
return;
}
var view = gridView2;
if (mixDanHao.Count < 1)
{
MessageBox.Show("没有大样单号！请刷新");
return;
}
QC_Sample_Mix bill = view.GetFocusedRow() as QC_Sample_Mix;
if (bill == null)
{
MessageBox.Show("没有大样单号！");
return;
}
bill.CardID = CardID;
bill.StoreCode = QC_Sample_Mix.FullStoreCode(bill.StoreCode);
IDbConnection conn = DbContext.GetDefaultConnection();
conn.Open();
IDbTransaction trans = conn.BeginTransaction();
bill.Save(trans);
foreach (var qcic in hycrds)
{
qcic.SampleId = bill.Sample_Mix_ID;
}
hycrds.Save(trans);
trans.Commit();
conn.Close();
label2.Text = "";
CardID = "";
//foreach (var item in mixDanHao)
//{
// if (item.Sample_Mix_ID == bill.Sample_Mix_ID)
// {
// item.CardID = CardID;
// item.StoreCode = QC_Sample_Mix.FullStoreCode(bill.StoreCode);
// break;
// }
//}
//mixDanHao.Save();
initDanHao();
}
private void btnSave_Click(object sender, EventArgs e)
{
data.Save();
MessageBox.Show("保存完成");
}
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 保存_Click(object sender, EventArgs e)
{
yjs.Save();
MessageBox.Show("保存成功");
}
//抽取
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();
}
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
{
}
}