/// <summary>
/// 删除抽查样
/// </summary>
private void tsmBtnDelete_Click(object sender, EventArgs e)
{
QC_Sample_Mix selData = sourceAllInpsectSamples.Current as QC_Sample_Mix;
if (selData != null)
{
int sampleState = Convert.ToInt32(DbContext.ExecuteScalar("Select SampleState From QC_Sample_Mix where Sample_Mix_ID=" + selData.Sample_Mix_ID));
if (sampleState >= 3)
{
MessageBox.Show("已经制样,不能再删除");
return;
}
if (MessageBox.Show("确实要删除此抽查样吗?", "提示", MessageBoxButtons.OKCancel) == DialogResult.OK)
{
if (selData == curData)
{
CreateSample();
}
sourceAllInpsectSamples.RemoveCurrent();
selData.SaveCheckItems = true;
examineSamples.Save();
}
}
else
{
MessageBox.Show("没有选中数据", "提示");
}
}
private void CreateSample()
{
curData = new QC_Sample_Mix();
this.sourceCurData.DataSource = curData;
// SetCheckItems();
}
private void 查询_Click(object sender, EventArgs e)
{
string storecode = textBox1.Text.Trim();
if (!string.IsNullOrEmpty(storecode))
{
bool find = false;
string jydh = QC_Sample_Mix.FullStoreCode(storecode);
foreach (var item in this.lableiji)
{
if (item.JyCode == jydh)
{
this.curLab = item;
find = true;
break;
}
}
if (find == false)
{
MessageBox.Show("未查到数据");
}
// curLab.CheckVals.LoadDataByWhere("main.Sample_Lab_ID=@Sample_Lab_ID", curLab.Sample_Lab_ID);
SetGridViewFocuse();
}
}
private void button1_Click(object sender, EventArgs e)
{
bool cunzai = false;
QC_Sample_Mix curData = GetCurData();
if (curData != null && textBox1.Text != null && textBox2.Text != null)
{
QC_MixCheckItem a = new QC_MixCheckItem();
a.CheckItemCode = textBox2.Text;
a.CheckItemName = textBox1.Text;
a.Sample_Mix_ID = curData.Sample_Mix_ID;
a.Source = "特殊添加";
a.CheckItemNcId = textBox3.Text;
a.CheckItemUnit = textBox4.Text;
foreach (var item in curData.AddCheckItems)
{
if (item.CheckItemCode == textBox2.Text)
{
cunzai = true;
}
}
if (cunzai == true)
{
MessageBox.Show("该检验项目已经存在");
}
else if (a.CheckItemCode != null && a.CheckItemCode != "" && a.CheckItemName != null && a.CheckItemName != "")
{
curData.AddCheckItems.Add(a);
curData.AddCheckItems.Save();
}
textBox1.Text = null;
textBox2.Text = null;
}
}
/// <summary>
/// 查找留存样
/// </summary>
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 == "")
{
MessageBox.Show("对不起，不认识您录入的字符串格式");
return;
}
QC_Sample_Mix sample = QC_Sample_Mix.GetByZydh(dh);
if (sample != null)
{
curData.CopyData(sample);
}
else
{
MessageBox.Show("没有找到");
}
}
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 gridView1_FocusedRowObjectChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowObjectChangedEventArgs e)
{
QC_Sample_Mix mix = e.Row as QC_Sample_Mix;
if (mix != null)
{
vehs.LoadDataByWhere("main.Sample_mix_id=@Sample_mix_id", mix.Sample_Mix_ID);
}
}
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 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;
}
}
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 查询组批_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();
}
}
}
}
}
private void btnOk_Click(object sender, EventArgs e)
{
QC_Sample_Mix selectedSample = this.qCSampleMixBindingSource.Current as QC_Sample_Mix;
if (selectedSample == null)
{
MessageBox.Show("没有选择数据");
return;
}
DialogResult = DialogResult.OK;
this.Close();
}
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 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 WP_Zhiyangdan_Load(object sender, EventArgs e)
{
zyMixSamples.LoadZyAllData(workpointCode);
this.qCSampleMixZhiYangBindingSource.DataSource = zyMixSamples;
this.qCSampleLabBindingSource1.DataSource = labTable;
LabTabs();
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));
}
}
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>
/// 保存
/// </summary>
private void btnSave_Click(object sender, EventArgs e)
{
QC_Sample_Mix sample = this.curData;
veh.LoadDataByWhere("NoticeBillId=@NoticeBillId", this.curData.NoticeBillId);
if (string.IsNullOrEmpty(sample.NoticeBillId))
{
MessageBox.Show("没有车辆信息，不能保存。");
return;
}
if (string.IsNullOrEmpty(sample.CardID))
{
MessageBox.Show("还没有刷卡。");
return;
}
if (veh.Count > 0)
{
sample.WLLX = veh[0].WLLX;
}
//if (veh[0].WLLX == "火运")
//{ sample.NoticeBillId = veh[0].Sample_Veh_ID.ToString(); }
sample.SampleType = SampleType.抽查样;
sample.Sample_Cylx = this.Cylx;
sample.MixCount = 1;
sample.MixPlanCount = 1;
sample.SampleState = SampleState.组批完成;
sample.Sample_TBZD = true;
sample.ShouTong_User = LocalInfo.Current.user.ID;
sample.ShouTong_Time = DateTime.Now;
if (sample.DataState == DataRowState.Added)
{
sample.MixUser = LocalInfo.Current.user.ID;
sample.Mix_Time = DateTime.Now;
examineSamples.Insert(0, sample);
}
sample.SaveCheckItems = true;
sample.Save();
btnUnBindCard.Visible = false;
CreateSample();
QC_Sample_Mix.UpdateInspectMainSample();
MessageBox.Show("保存完成");
}
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();
}
}
}
}
//private void SetCheckItems()
//{
// allCheckItem.Empty();
// foreach (var item in allCheckItem_back)
// {
// bool find = false;
// foreach (var ci in curData.CheckItems)
// {
// if (ci.CheckItemNcId == item.CheckItemNcId)
// {
// find = true;
// break;
// }
// }
// if (!find)
// {
// item.SetDataStateAsAdded();
// allCheckItem.Add(item);
// }
// }
//}
/// <summary>
/// 修改抽查样
/// </summary>
private void tsmBtnUpdate_Click(object sender, EventArgs e)
{
QC_Sample_Mix selData = sourceAllInpsectSamples.Current as QC_Sample_Mix;
if (selData != null)
{
selData.CheckItems.LoadDataByWhere("Sample_Mix_ID=@Sample_Mix_ID", selData.Sample_Mix_ID);
this.curData = selData;
this.sourceCurData.DataSource = this.curData;
//SetCheckItems();
curData.SaveEnable = false;
btnUnBindCard.Visible = false;
}
else
{
MessageBox.Show("没有选中数据");
}
}
/// <summary>
/// 查找留存样
/// </summary>
private void btnLoadVehData_Click(object sender, EventArgs e)
{
QC_Sample_Mix sample = null;
DbEntityTable <QC_MixCheckGroup> mixCgrp = new DbEntityTable <QC_MixCheckGroup>();
mixCgrp.LoadDataByWhere("main.StoreCode=@StoreCode", txtStoreCode.Text.Trim());
if (mixCgrp.Count > 0)
{
sample = QC_Sample_Mix.GetByID(mixCgrp[0].Sample_Mix_ID);
}
if (sample != null)
{
currentData.CopyData(sample);
}
else
{
MessageBox.Show("没有找到");
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(this.curData.CardID))
{
MessageBox.Show("还没有刷卡。");
return;
}
this.curData.Save();
fjdhs1.LoadDataByWhere("fjdh=@fjdh and wc='否'", QC_Sample_Mix.GetZyDanHao(txtStoreCode.Text.Trim()));
fjdhs1[0].wc = "是";
fjdhs1.Save();
fjdhs.LoadDataByWhere("wc=@wc", "否");
btnUnBindCard.Visible = false;
MessageBox.Show("保存完成");
}
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;
// }
// );
}
private void gridView1_RowStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowStyleEventArgs e)
{
int hand = e.RowHandle;
if (hand < 0)
{
return;
}
QC_Sample_Mix mix = (QC_Sample_Mix)gridView1.GetRow(hand);
DbEntityTable <QC_Sample_Mix> mixs = new DbEntityTable <QC_Sample_Mix>();
mixs.LoadDataByWhere("main.SupplierCode=@SupplierCode and Month(main.Mix_Time)=@Mix_Time and Year(main.Mix_Time)=@year and main.MatCode=@MatCode order by Mix_Time", mix.SupplierCode, mix.Mix_Time.Value.Month, mix.Mix_Time.Value.Year, mix.MatCode);
if (mixs.Count > 0)
{
if (mix.Sample_Mix_ID == mixs[0].Sample_Mix_ID)
{
e.Appearance.ForeColor = Color.Red;
}
}
}
private void printDocument1_PrintPage(object sender, System.Drawing.Printing.PrintPageEventArgs e)
{
QC_Sample_Mix mix = this.qCSampleMixBindingSource.Current as QC_Sample_Mix;
if (mix == null)
{
MessageBox.Show("请选择任务单");
}
else
{
string qydh = QC_Sample_Mix.ShortStoreCode(mix.CardID);
string head = qydh;
string body = mix.MatName;
string body1 = mix.SupplierName;
mix.WCDY = true;
mix.Save();
Rectangle rect = new Rectangle(9, 3, 112, 94);
Font f1 = new System.Drawing.Font("宋体", 21, FontStyle.Bold);
SizeF headSize = e.Graphics.MeasureString(head, f1);
Font f2 = new System.Drawing.Font("宋体", 12f, FontStyle.Bold);
SizeF bodySize = e.Graphics.MeasureString(body, f2);
Font f3 = new System.Drawing.Font("宋体", 12f, FontStyle.Bold);
SizeF body1Size = e.Graphics.MeasureString(body1, f2);
float topMargin = rect.Top + (rect.Height - headSize.Height - bodySize.Height - body1Size.Height - 6) / 2;
float leftMargin = rect.Left + (rect.Width - headSize.Width) / 2;
e.Graphics.DrawString(head, f1, Brushes.Black, new PointF(leftMargin, topMargin));
float topMargin2 = topMargin + Math.Max(headSize.Height + 3, 12);
float leftMargin2 = rect.Left;
e.Graphics.DrawString(body, f2, Brushes.Black, new PointF(leftMargin2, topMargin2));
float topMargin3 = topMargin2 + Math.Max(bodySize.Height + 2, 12);
float leftMargin3 = rect.Left;
e.Graphics.DrawString(body1, f2, Brushes.Black, new PointF(leftMargin3, topMargin3));
}
}
/// <summary>
/// 删除校验样
/// </summary>
private void tsmBtnVSLDelete_Click(object sender, EventArgs e)
{
QC_Sample_Mix sampleMix = sourceAllVerifSamples.Current as QC_Sample_Mix;
if (sampleMix != null)
{
if (MessageBox.Show("你确实要删除此数据吗？", "提示", MessageBoxButtons.OKCancel) == DialogResult.OK)
{
sampleMix.SaveVehSamples = true;
sampleMix.SaveCheckItems = true;
mixSamples.Remove(sampleMix);
mixSamples.Save();
}
}
else
{
MessageBox.Show("没有选中的行");
}
//int[] selIds = this.gridView1.GetSelectedRows();
//if (selIds.Length > 0)
//{
// if (MessageBox.Show("你确实要删除此数据吗？", "提示", MessageBoxButtons.OKCancel) == DialogResult.OK)
// {
// QC_Sample_Mix sampleMix = this.gridView1.GetRow(selIds[0]) as QC_Sample_Mix;
// if (sampleMix != null)
// {
// sampleMix.SaveVehSamples = true;
// mixSamples.Remove(sampleMix);
// mixSamples.Save();
// }
// }
//}
//else
//{
// MessageBox.Show("没有选中的行");
//}
}
private void ReCheck_Load(object sender, EventArgs e)
{
this.sourceCurData.DataSource = curData;
label2.Text = zyzydh;
if (zyzydh != "")
{
QC_Sample_Mix sample = QC_Sample_Mix.GetByZydh(zyzydh);
if (sample != null)
{
if (curData.CheckItems.Count == 0)
{
curData.CopyData(sample);
}
curData.SupplierCode = sample.SupplierCode;
curData.SupplierName = sample.SupplierName;
curData.SampleType = SampleType.检样;
curData.SampleState = SampleState.组批完成;
curData.WLLX = sample.WLLX;
}
}
}
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)
{
string storecode = textBox1.Text.Trim();
if (!string.IsNullOrEmpty(storecode))
{
string fullCode = QC_Sample_Mix.FullStoreCode(storecode);
QC_Sample_Lab sellLab = zyMixSamples.LabTable.FirstOrDefault <QC_Sample_Lab>((lb) => lb.StoreCode == fullCode);
if (sellLab != null)
{
if (xtraTabControl1.SelectedTabPage != null && xtraTabControl1.SelectedTabPage.Text != sellLab.CheckGroupName)
{
foreach (XtraTabPage tabPage in xtraTabControl1.TabPages)
{
if (tabPage.Text == sellLab.CheckGroupName)
{
xtraTabControl1.SelectedTabPage = tabPage;
break;
}
}
}
int idx = this.labTable.IndexOf(sellLab);
this.gridView3.FocusedRowHandle = this.gridView3.GetRowHandle(idx);
;
}
else
{
MessageBox.Show("没有找到样品");
}
}
else
{
MessageBox.Show("样品编码不能为空");
}
}
/// <summary>
/// 更新校验样
/// </summary>
private void tsmBtnVSLUpdate_Click(object sender, EventArgs e)
{
QC_Sample_Mix sampleMix = this.sourceAllVerifSamples.Current as QC_Sample_Mix;
if (sampleMix != null)
{
sampleMix.VehSamples.LoadDataBySampleMixId(sampleMix.Sample_Mix_ID);
sampleMix.CheckItems.LoadDataBySampleMixId(sampleMix.Sample_Mix_ID);
currentData.SaveEnable = false;
currentData = sampleMix;
this.sourceCurData.DataSource = currentData;
}
else
{
MessageBox.Show("没有选中的行");
}
//int[] selIds = this.gridView1.GetSelectedRows();
//if (selIds.Length > 0)
//{
// QC_Sample_Mix sampleMix = this.gridView1.GetRow(selIds[0]) as QC_Sample_Mix;
// if (sampleMix != null)
// {
// sampleMix.VehSamples.LoadDataBySampleMixId(sampleMix.Sample_Mix_ID);
// sampleMix.CheckItems.LoadDataBySampleMixId(sampleMix.Sample_Mix_ID);
// currentData.SaveEnable = false;
// currentData = sampleMix;
// this.sourceCurData.DataSource = currentData;
// }
//}
//else
//{
// MessageBox.Show("没有选中的行");
//}
}
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;
}
}
