//查询大桶个数 private void simpleButton4_Click(object sender, EventArgs e) { if (isfangtong == false) { sjtnum = 0; jsdtgs1(); if (dtgs == 0) { jsdtgs(); } DbEntityTable <QC_Sample_Mix> dty = new DbEntityTable <QC_Sample_Mix>(); object result = DbContext.ExecuteScalar("select max(TempID) from QC_Sample_Mix where SampleState=" + Convert.ToInt32(SampleState.初始状态) + " and WpCode='" + workpointCode + "' and WLLX='煤'"); if (result != null && result != DBNull.Value) { sjtnum = Convert.ToInt32(result); //目前有的大桶个数 } if (sjtnum >= dtgs) { label5.Text = "大桶已经放好"; } else { sum = dtgs; dtgs = dtgs - sjtnum; label5.Text = "需要" + dtgs + "个大桶"; int a = sjtnum + 1; label2.Text = "选择位置" + a; } } }
//收桶 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(); }
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 UC_ICReg_Load(object sender, EventArgs e) { cardUseType = QC_CardUseType.LoadCardUseType(); this.cmbCardType.Properties.Items.Clear(); foreach (var item in cardUseType) { this.cmbCardType.Properties.Items.Add(item); } this.cmbCardType.SelectedIndex = 0; //reposCardUseType.DataSource = cardUseType; this.repositoryItemGridLookUpEdit1.DataSource = cardUseType; this.gridCtl_IC_Info.DataSource = icInfoDatas; icInfoDatas.LoadData(); foreach (var useType in cardUseType) { ToolStripMenuItem tsmBtnItem = new ToolStripMenuItem(); tsmBtnItem.Name = useType.CUTCode; tsmBtnItem.Size = new Size(0x98, 0x16); tsmBtnItem.Text = useType.CUTName; tsmBtnItem.Tag = useType; this.tsmBtnGroup_UseType.DropDownItems.Add(tsmBtnItem); tsmBtnItem.Click += new EventHandler(tsmBtn_ChgUseType_Click); } }
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); }
/// <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; }
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 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; } }
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(); }
public static QC_CheckMaxMinVal GetMaxMinVal(string rq, string supplierCode, string matNcId) { DbEntityTable <QC_CheckMaxMinVal> table = new DbEntityTable <QC_CheckMaxMinVal>(); table.LoadDataBySql("select max(cast(CheckVal as float)) as MaxVal,min(cast(CheckVal as float)) as MinVal from QC_MixSampleValue_V where SampleState>=" + (int)SampleState.化验审核完成 + " and SampleType=" + (int)SampleType.普通样 + "and CHECKITEMCODE='10001' and checkVal<>'' and convert(varchar(10),Mix_Time,120)=@rq and SUPPLIERCODE=@SUPPLIERCODE and MATPK=@MATPK", rq, supplierCode, matNcId); 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); } }
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); } }
private void btnLoad_Click(object sender, EventArgs e) { cardUseType = QC_CardUseType.LoadCardUseType(); this.cmbCardType.Properties.Items.Clear(); foreach (var item in cardUseType) { this.cmbCardType.Properties.Items.Add(item); } this.cmbCardType.SelectedIndex = 0; //reposCardUseType.DataSource = cardUseType; this.repositoryItemGridLookUpEdit1.DataSource = cardUseType; icInfoDatas.LoadData(); }
public static QC_Material GetByCode(string matCode) { DbEntityTable <QC_Material> ds = new DbEntityTable <QC_Material>(); ds.LoadDataByWhere("inv.INVCODE=@MatCode", matCode); if (ds.Count > 0) { return(ds[0]); } else { return(null); } }
public static QC_Material GetByID(string id) { DbEntityTable <QC_Material> ds = new DbEntityTable <QC_Material>(); ds.LoadDataByWhere("MatNcId=@MatNcId", id); if (ds.Count > 0) { return(ds[0]); } else { return(null); } }
//private string _Djh = ""; //public string Djh //{ // get { return _Djh; } // set // { // if (_Djh != value) // { // _Djh = value; // RaisePropertyChanged("Djh"); // } // } //} //private DateTime? _RegTime; //public DateTime? RegTime //{ // get { return _RegTime; } // set // { // if (_RegTime != value) // { // _RegTime = value; // RaisePropertyChanged("RegTime"); // } // } //} //private string _RegUser = ""; //public string RegUser //{ // get { return _RegUser; } // set // { // if (_RegUser != value) // { // _RegUser = value; // RaisePropertyChanged("RegUser"); // } // } //} //private int _Status; //public int Status //{ // get { return _Status; } // set // { // if (_Status != value) // { // _Status = value; // RaisePropertyChanged("Status"); // } // } //} //private int _IcType; //public int IcType //{ // get { return _IcType; } // set // { // if (_IcType != value) // { // _IcType = value; // RaisePropertyChanged("IcType"); // } // } //} public static Tb_IC GetByICNo(string id) { DbEntityTable <Tb_IC> ds = new DbEntityTable <Tb_IC>(); ds.LoadDataByWhere("ICNo=@ICNo", id); if (ds.Count > 0) { return(ds[0]); } else { return(null); } }
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); } }
/// <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(); }
public void jsdtgs1() { dtgs = 0; int fzcs = 0; //组抽样的 DbEntityTable <cheshu> cheshucy = new DbEntityTable <cheshu>(); cheshucy.LoadDataBySql("select SUPPLIERCODE as cj,MATCODE as wl,WPCODE as dd,COUNT(*) as num from QC_Sample_Veh where sample_mix_id=0 and sample_tbzd=1 and SampleState=@SampleState and WLLX='精粉' group by SUPPLIERCODE,MATCODE,WPCODE", SampleState.开始组批); foreach (var x in cheshucy) { dtgs = dtgs + x.num; } DbEntityTable <cheshu> cheshufl = new DbEntityTable <cheshu>(); cheshufl.LoadDataBySql("select SUPPLIERCODE as cj,MATCODE as wl,WPCODE as dd,COUNT(*) as num from QC_Sample_Veh where sample_mix_id=0 and (sample_jy is null or sample_jy<>1) and sample_tbzd<>1 and SampleState=@SampleState and WLLX='精粉' group by SUPPLIERCODE,MATCODE,WPCODE", SampleState.开始组批); foreach (var x in cheshufl) { fzcs = 0; QC_Material matInfo = QC_Material.GetByCode(x.wl); if (matInfo != null) { // if (matInfo.InUse) // { DbEntityTable <QC_MixRule> labrule = new DbEntityTable <QC_MixRule>(); labrule.LoadDataByWhere("MatNcId=@MatNcId and (CustCode=@CustCode or CustCode='' or CustCode is null) and VehNumber<=@VehNumber", matInfo.MatNcId, x.cj, x.num); if (labrule.Count > 0) { if (labrule[0].PlanMixCount > 0) { fzcs = Convert.ToInt32(Math.Ceiling(Convert.ToDouble(x.num) / labrule[0].PlanMixCount)); } } if (fzcs > 0) { dtgs = fzcs + dtgs; } else { dtgs = dtgs + Convert.ToInt32(Math.Ceiling(Convert.ToDouble(x.num) / matInfo.BatchNum)); } // } } } }
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(); } }
public static QC_IC_Info FindByCardId(string cardId) { DbEntityTable <QC_IC_Info> table = new DbEntityTable <QC_IC_Info>(); table.LoadDataByWhere("CardID=@CardID", cardId); if (table.Count == 1) { return(table[0]); } else if (table.Count > 1) { throw new Exception(string.Format("根据卡号:{0}找到多条记录,但是不允许出现这种情况", cardId)); } else { return(null); } }
/// <summary> /// 初始化火车皮号选择下拉框 /// </summary> public void initcmbHCPH() { DbEntityTable <View_train> train_num = new DbEntityTable <View_train>(); // train_num.LoadDataBySql("select distinct(cardid) from QC_Sample_Veh where samplestate=@samplestate and wllx=@wllx", Xg.Lab.Sample.SampleState.初始状态,"火运"); train_num.LoadDataBySql("select distinct(zpdh+'_'+rwdh) as cardid from QC_Sample_Veh where samplestate=@samplestate and wllx=@wllx", Xg.Lab.Sample.SampleState.初始状态, "火运"); cmbHCPH.DataSource = train_num; if (train_num.Count > 0) { cmbHCPH.SelectedIndex = 0; } else { cmbHCPH.Text = ""; initHCgrid(); } }
public void zupi() { //按厂家,地点,物料分类 int dtmax = 0; //组抽样的 DbEntityTable <cheshu> cheshucy = new DbEntityTable <cheshu>(); cheshucy.LoadDataBySql("select SUPPLIERCODE as cj,MATCODE as wl,WPCODE as dd from QC_Sample_Veh where sample_mix_id=0 and sample_tbzd=1 and SampleState=@SampleState and WLLX='精粉'", SampleState.开始组批); foreach (var x in cheshucy) { dtmax = 1; zupiduoche(x.cj, x.wl, x.dd, dtmax, "抽样"); } DbEntityTable <cheshu> cheshufl = new DbEntityTable <cheshu>(); cheshufl.LoadDataBySql("select SUPPLIERCODE as cj,MATCODE as wl,WPCODE as dd,COUNT(*) as num from QC_Sample_Veh where sample_mix_id=0 and (sample_jy is null or sample_jy<>1) and sample_tbzd<>1 and SampleState=@SampleState and WLLX='精粉' group by SUPPLIERCODE,MATCODE,WPCODE ", SampleState.开始组批); foreach (var x in cheshufl) { //判定是否有车数比较多 QC_Material matInfo = QC_Material.GetByCode(x.wl); if (matInfo != null) { // if (matInfo.InUse) // { dtmax = matInfo.BatchNum; DbEntityTable <QC_MixRule> labrule = new DbEntityTable <QC_MixRule>(); labrule.LoadDataByWhere("MatNcId=@MatNcId and (CustCode=@CustCode or CustCode='' or CustCode is null) and VehNumber<=@VehNumber", matInfo.MatNcId, x.cj, x.num); if (labrule.Count > 0) { if (labrule[0].PlanMixCount > 0) { dtmax = labrule[0].PlanMixCount; } } // } } zupiduoche(x.cj, x.wl, x.dd, dtmax, "正常样"); } }
/// <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("没有找到"); } }
public void LoadByMatNcId(string matNcId) { this.LoadDataByWhere("MATNCID=@MATNCID", matNcId); DbEntityTable <QC_MatCheckGroup_View> matCheckGroups = new DbEntityTable <QC_MatCheckGroup_View>(); matCheckGroups.LoadDataByWhere("MATNCID=@MATNCID", matNcId); foreach (var item in matCheckGroups) { QC_MatCheckGroup gp = new QC_MatCheckGroup(); gp.Id = -1; gp.MatNcId = matNcId; gp.CheckGroupCode = item.CheckGroupCode; gp.CheckGroupName = item.CheckGroupName; gp.CheckGroupType = item.CheckGroupType; gp.ShortWord = item.ShortWord; gp.SetDataStateAsUnchanged(); this.Add(gp); } }
public void HandleCardMessage(Device.CardReader device, string cardId) { CardID = cardId; 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; } foreach (var qcic in hycrds) { if (qcic.SampleId == 0) { label2.Text = System.DateTime.Now.ToString("HH:mm:ss") + "扫扣成功!"; label2.ForeColor = Color.Red; } else { label2.Text = "该扣已经使用!"; label2.ForeColor = Color.Red; CardID = ""; } } //icCard.SampleId = 0; //IDbConnection conn = DbContext.GetDefaultConnection(); //conn.Open(); //IDbTransaction trans = conn.BeginTransaction(); //icCard.Save(trans); //tempLab.Save(trans); //trans.Commit(); //conn.Close(); }
public static QC_Sample_Lab_Jy GetById(int id) { DbEntityTable <QC_Sample_Lab_Jy> table = new DbEntityTable <QC_Sample_Lab_Jy>(); table.LoadInfo = "CheckVals"; table.LoadDataByWhere("main.Sample_Lab_ID = @Sample_Lab_ID", id); if (table.Count == 1) { return(table[0]); } else if (table.Count > 1) { throw new Exception(string.Format("主键不唯一:{0}", id)); } else { return(null); } }
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; } } }
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); } }