private void WP_Kuaikuangqy_Load(object sender, EventArgs e)
{
vehs.LoadDataByWhere("main.WLLX='石子' and main.SampleState=@SampleState", SampleState.初始状态);
mixs.LoadDataByWhere("main.WLLX='石子' and main.SampleState=@SampleState", SampleState.初始状态);
this.qC_Sample_VehBindingSource.DataSource = vehs;
this.qCSampleMixBindingSource.DataSource = mixs;
}
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 添加检验项目_Load(object sender, EventArgs e)
{
if (MatNcId != null && MatNcId != "")
{
check.LoadDataByWhere("MatNcId=@MatNcId", MatNcId);
this.qCMatAllCheckItemBindingSource.DataSource = check;
}
}
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();
}
private void btnRefresh_Click(object sender, EventArgs e)
{
rjmixs.LoadDataByWhere("main.SAMPLESTATE=@SAMPLESTATE and main.WLLX='熔剂'", SampleState.组批完成);
comboBox1.Items.Clear();
foreach (var item in rjmixs)
{
comboBox1.Items.Add(QC_Sample_Mix.ShortStoreCode(item.CardID));
}
zyMixSamples.LoadZyAllData(workpointCode);
LabTabs();
}
private void WP_Jianyan_Load(object sender, EventArgs e)
{
lableiji.LoadInfo = "CheckVals";
this.qCSampleLabBindingSource.DataSource = lableiji;
lableiji.LoadDataByWhere("main.BillType=@BillType and main.WLLX='火运' order by main.JyTime desc", "开始检验");
labTable1.LoadDataByWhere("main.labstate='火运' and main.checkgroupname like '化验样%' and main.maketime>=@maketime and main.WLLX='火运'", 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();
}
private void 查询_Click(object sender, EventArgs e)
{
if (!(textBox1.Text == ""))
{
data.LoadDataByWhere("CUSTCODE='" + textBox1.Text + "'");
}
else if (!(textBox2.Text == ""))
{
data.LoadDataByWhere("CUSTSHORTNAME like '%" + textBox2.Text + "%'");
}
}
private void simpleButton1_Click(object sender, EventArgs e)
{
if (this.comboBoxEdit1.SelectedItem.ToString() == "全部")
{
cxs.LoadDataByWhere("取样时间>=@取样时间小 and 取样时间<=@取样时间大", this.dateEdit1.DateTime, this.dateEdit2.DateTime);
}
else
{
cxs.LoadDataByWhere("取样时间>=@组批时间小 and 取样时间<=@取样时间大 and 车牌号 like @车牌号", this.dateEdit1.DateTime, this.dateEdit2.DateTime, "%" + this.comboBoxEdit1.SelectedItem + "%");
}
this.bCXGCXBindingSource.DataSource = cxs;
}
private void loadData()
{
pici.LoadInfo = "CheckVals";
pici.LoadDataByWhere("main.BillType=@BillType and main.CheckGroupType='后续检验' order by main.JyCode desc", "检验完成");
foreach (var item in pici)
{
mcg.LoadDataByWhere("main.Sample_Lab_ID=@Sample_Lab_ID", item.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);
item.MatName = wl[0].INVNAME;
}
}
private void loadData()
{
pici.LoadInfo = "CheckVals";
// if (FrmMain.localinfo.workpoint.Code == "0077")
pici.LoadDataByWhere("main.BillType=@BillType and main.CheckGroupType='后续检验' and main.WLLX='外矿' order by main.JyCode desc", "检验完成");
//else if (FrmMain.localinfo.workpoint.Code == "0078")
// pici.LoadDataByWhere("main.BillType=@BillType and main.CheckGroupType='后续检验' and main.WLLX='煤' order by main.JyCode desc", "检验完成");
foreach (var item in pici)
{
mcg.LoadDataByWhere("main.Sample_Lab_ID=@Sample_Lab_ID", item.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);
item.MatName = wl[0].INVNAME;
}
}
/// <summary>
/// 初始化NC到货单
/// </summary>
public void initArrivebill()
{
arrivebill = new DbEntityTable <View_arrivebill>();
arrivebill.LoadDataByWhere(" 1=1 order by vdef5,custname,invname,varrordercode desc");
string[] leibie = cmbHCPH.Text.Trim().Split('_');
if (leibie.Count() != 2)
{
gridControl3.DataSource = arrivebill;
}
else
{
string fazhan = leibie[0].ToString();
if (arrivebill.Where(o => o.vdef5 == fazhan).Count() > 0)
{
gridControl3.DataSource = arrivebill.Where(o => o.vdef5 == fazhan).ToList();
}
else
{
gridControl3.DataSource = arrivebill;
}
}
// gridControl3.DataSource = arrivebill;
}
//收桶
private void simpleButton3_Click(object sender, EventArgs e)
{
DbEntityTable <QC_Sample_Mix> qcvhs = new DbEntityTable <QC_Sample_Mix>();
qcvhs.LoadDataByWhere("main.WpCode='" + workpointCode + "' and main.SampleState =@SampleState and main.ShouTong_Time is null and main.WLLX='煤'", SampleState.组批完成);
foreach (var qcvh in qcvhs)
{
// qcvh.TempID = 0;
qcvh.ShouTong_Time = System.DateTime.Now;
// qcvh.SampleState = SampleState.开始制样;
qcvh.Save();
//解绑小卡
DbEntityTable <QC_Sample_Veh> vehcrds = new DbEntityTable <QC_Sample_Veh>();
vehcrds.LoadDataByWhere("main.SAMPLE_MIX_ID=@SAMPLE_MIX_ID", qcvh.Sample_Mix_ID);
foreach (var veh in vehcrds)
{
DbEntityTable <QC_IC_Info> hycrds = new DbEntityTable <QC_IC_Info>();
hycrds.LoadDataByWhere("CARDID=@CARDID", veh.CardID);
foreach (var qcic in hycrds)
{
qcic.SampleId = 0;
qcic.Save();
}
}
}
// 更新显示信息
DbEntityTable <BC_DT_State> dtwzs = new DbEntityTable <BC_DT_State>();
dtwzs.LoadDataByWhere("WpCode='" + workpointCode + "' and SHOUTONG_TIME IS NULL and WLLX='煤'");
this.bCDTStateBindingSource.DataSource = dtwzs;
qyts ts = new qyts("收桶成功！可以送去制样！");
ts.ShowDialog();
}
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]);
}
}
}
}
private void 完成取样_Click(object sender, EventArgs e)
{
foreach (var item in mixs)
{
if (item.WCQY == true)
{
DbEntityTable <QC_Sample_Veh> itemvehs = new DbEntityTable <QC_Sample_Veh>();
itemvehs.LoadDataByWhere("main.Sample_Mix_ID=@Sample_Mix_ID", item.Sample_Mix_ID);
item.Mix_Time = DateTime.Now;
item.FangTong_Time = DateTime.Now;
item.ShouTong_Time = DateTime.Now;
item.ShouTong_User = LocalInfo.Current.user.ID;
item.FangTong_User = LocalInfo.Current.user.ID;
item.MixCount = itemvehs.Count;
item.MixPlanCount = itemvehs.Count;
item.MixUser = LocalInfo.Current.user.ID;
item.SampleState = SampleState.组批完成;
item.Save();
foreach (var it in itemvehs)
{
it.Mix_Time = DateTime.Now;
it.SampleState = SampleState.组批完成;
it.Save();
}
}
}
vehs.LoadDataByWhere("main.WLLX='石子' and main.SampleState=@SampleState", SampleState.初始状态);
mixs.LoadDataByWhere("main.WLLX='石子' and main.SampleState=@SampleState", SampleState.初始状态);
}
private void DlgMaterial_Load(object sender, EventArgs e)
{
matFlView.LoadDataByWhere("invclasscode like '1%'");
this.treeList1.DataSource = matFlView;
this.gridMaterial.DataSource = materialView;
}
private void UC_WpRoute_Load(object sender, EventArgs e)
{
wpRoutes.LoadDataByWhere("wc.WCTypeId='02' or wc.WCTypeId='21'");
selecteRoutes.LoadDataByWhere("wc.WCTypeId='21' or wc.WCTypeId='22' ");
this.qCWpRouteBindingSource.DataSource = wpRoutes;
this.qCWpRouteBindingSource1.DataSource = selecteRoutes;
wpRoutes.ListChanged += wpRoutes_ListChanged;
}
private void DlgCheckGroup_Load(object sender, EventArgs e)
{
checkGroups.LoadDataByWhere("CheckGroupType='留存样' or CheckGroupType='中间样' ");
if (curTable != null)
{
checkGroups.Filter((cg) => !curTable.Contains(cg.CheckGroupCode));
}
this.qCCheckGroupBindingSource.DataSource = checkGroups;
}
public void initDanHao()
{
mixDanHao.LoadDataByWhere("main.samplestate = @samplestate and main.wllx=@wllx and main.cardid='' and main.matpk in (SELECT MATNCID FROM QC_Material WHERE WLLX = '煤') ", Xg.Lab.Sample.SampleState.组批完成, "火运");
foreach (var item in mixDanHao)
{
item.StoreCode = QC_Sample_Mix.ShortStoreCode(item.StoreCode);
}
gridControl2.DataSource = mixDanHao;
}
private void Hunyang_Load(object sender, EventArgs e)
{
isfangtong = false;
DbEntityTable <BC_DT_State> dtwzs = new DbEntityTable <BC_DT_State>();
dtwzs.LoadDataByWhere("WpCode='" + workpointCode + "' and SHOUTONG_TIME IS NULL and WLLX='煤'");
this.bCDTStateBindingSource.DataSource = dtwzs;
}
private void printDocument2_PrintPage(object sender, System.Drawing.Printing.PrintPageEventArgs e)
{
List <ZupiData> printData = new List <ZupiData>();
foreach (var mix in hjmixs)
{
List <string> vehnos = new List <string>();
DbEntityTable <QC_Sample_Veh> vehs = new DbEntityTable <QC_Sample_Veh>();
vehs.LoadDataByWhere("main.Sample_Mix_ID=@Sample_Mix_ID", mix.Sample_Mix_ID);
foreach (var item in vehs)
{
vehnos.Add(QC_Sample_Mix.ShortStoreCode(item.CardID));
}
if (vehnos.Count > 0)
{
ZupiData zd = new ZupiData();
zd.Head = QC_Sample_Mix.ShortStoreCode(mix.CardID);
zd.ZupiItems = vehnos;
printData.Add(zd);
ZupiData pbzd = new ZupiData();
pbzd.Head = QC_Sample_Mix.ShortStoreCode("PB" + mix.CardID.Remove(0, 2));
pbzd.ZupiItems = vehnos;
printData.Add(pbzd);
}
}
int totalPage = 1;
foreach (var item in printData)
{
item.BeginPage = totalPage;
totalPage += item.NeadPage;
}
int printPage = totalPage - curZupiPrintPage;
foreach (var item in printData)
{
if (printPage >= item.BeginPage && printPage < item.EndPage)
{
item.Print(e.Graphics, printPage);
break;
}
}
if (curZupiPrintPage < totalPage - 1)
{
curZupiPrintPage++;
e.HasMorePages = true;
}
else
{
curZupiPrintPage = 1;
e.HasMorePages = false;
}
}
/// <summary>
/// 初始化任务单
/// </summary>
public void initTaskbill()
{
sample_selected.LoadDataByWhere("samplestate = @samplestate and wllx=@wllx", Xg.Lab.Sample.SampleState.开始组批, "火运");
if (sample_selected.Count > 0)
{
hcph = sample_selected[0].CardID;
matname = sample_selected[0].rwdh;
ncdhd = sample_selected[0].NcDhdHeadNo;
fazhan = sample_selected[0].zpdh;
lbtask.Text = "等待取样的火车：" + hcph;
}
else
{
hcph = "";
matname = "";
ncdhd = "";
fazhan = "";
lbtask.Text = "请勾选物料到货单！";
}
}
/// <summary>
/// 初始化集中计量火车表格
/// </summary>
public void initHCgrid()
{
if (cmbHCPH.Text.Trim() == "")
{
sample_unselect.LoadDataByWhere("wllx='火运' and samplestate=@samplestate order by begintime ", Xg.Lab.Sample.SampleState.初始状态);
}
else
{
string[] leibie = cmbHCPH.Text.Trim().Split('_');
if (leibie.Count() != 2)
{
return;
}
string fazhan = leibie[0].ToString();
string wuliao = leibie[1].ToString();
sample_unselect.LoadDataByWhere("wllx='火运' and samplestate=@samplestate and zpdh=@zpdh and rwdh=@rwdh order by fetchplace ", Xg.Lab.Sample.SampleState.初始状态, fazhan, wuliao);
}
gridControl1.DataSource = sample_unselect;
// bstrain.DataSource = sample_unselect;
}
private void LoadData()
{
//
QC_Sample_Mix.UpdateSampleState();
//if(FrmMain.localinfo.workpoint.Code=="0075")
mixSamples.LoadDataByWhere(string.Format("main.SampleState>={0} and main.SampleState<{1} and main.WLLX='石子' order by main.ZyRecvTime,main.mix_time", (int)SampleState.开始制样, (int)SampleState.NC报检完成));
//else if(FrmMain.localinfo.workpoint.Code=="0076")
// mixSamples.LoadDataByWhere(string.Format("main.SampleState>={0} and main.SampleState<{1} and main.WLLX='煤' order by main.ZyRecvTime,main.mix_time", (int)SampleState.开始制样, (int)SampleState.NC报检完成));
// LoadDataByWhere("SampleState>=@BeginSampleState And SampleState<@EndSampleState", SampleState.开始组批, SampleState.上传完成);
//mixSamples.Sort((s1, s2) =>
// {
// int result = s1.Riqi.CompareTo(s2.Riqi);
// if (result == 0)
// result = s1.ZyDanHao.CompareTo(s2.ZyDanHao);
// return result;
// }
// );
}
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;
}
private void simpleButton1_Click(object sender, EventArgs e)
{
zupi();
// 更新显示信息
DbEntityTable <BC_DT_State> dtwzs = new DbEntityTable <BC_DT_State>();
dtwzs.LoadDataByWhere("WpCode='" + workpointCode + "' and SHOUTONG_TIME IS NULL and WLLX='煤'");
this.bCDTStateBindingSource.DataSource = dtwzs;
QC_Sample_Mix.UpdateInspectMainSample();
qyts ts = new qyts("组批成功！下一步放小样！");
ts.ShowDialog();
}
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);
}
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("没有可匹配项目");
}
}
public static QC_ChgWater GetByMatCust(string matNcId, string custCode)
{
DbEntityTable <QC_ChgWater> table = new DbEntityTable <QC_ChgWater>();
table.LoadDataByWhere("MatNcId=@MatNcId and CustCode=@CustCode", matNcId, custCode);
if (table.Count > 0)
{
return(table[0]);
}
else
{
return(null);
}
}
public static QC_NoticeDhdItem_View GetByNoticeId(string noticeId)
{
DbEntityTable <QC_NoticeDhdItem_View> noticeDhd = new DbEntityTable <QC_NoticeDhdItem_View>();
noticeDhd.LoadDataByWhere("NoticeId=@NoticeId", noticeId);
if (noticeDhd.Count > 0)
{
return(noticeDhd[0]);
}
else
{
return(null);
}
}
private void btnLoadVehData_Click(object sender, EventArgs e)
{
string code = txtStoreCode.Text.Trim();
if (string.IsNullOrEmpty(code))
{
MessageBox.Show("不能为空");
return;
}
string dh = QC_Sample_Mix.GetZyDanHao(code);
if (dh != "")
{
Samples.LoadDataByWhere("main.ZyDanHao=@ZyDanHao", dh);
mixgroups.LoadDataByWhere("main.Sample_mix_id=@Sample_mix_id and main.checkgroupname='角质层Y'", Samples[0].Sample_Mix_ID);
if (mixgroups.Count > 0)
{
int labid = mixgroups[0].Sample_Lab_ID;
mixgroups.LoadDataByWhere("main.Sample_lab_id=@Sample_lab_id and main.checkgroupname='角质层Y'", labid);
this.qCMixCheckGroupBindingSource.DataSource = mixgroups;
}
DbEntityTable <QC_Sample_Mix> curDatalist = new DbEntityTable <QC_Sample_Mix>();
curDatalist.LoadDataByWhere("parent.ZyDanHao=@MainSampleZyDanHao and main.Sampletype=@Sampletype", dh, SampleType.检样);
if (curDatalist.Count > 0)
{
this.curData = curDatalist[0];
}
this.curData.CheckItems.LoadDataBySampleMixId(this.curData.Sample_Mix_ID);
this.sourceCurData.DataSource = curData;
}
}