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 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); }
private void WP_Shcx_Load(object sender, EventArgs e) { cg.LoadData(); List <String> cgname = new List <String>(); List <String> wl = new List <String>(); cgname.Add("全部"); wl.Add("全部"); foreach (var item in cg) { cgname.Add(item.CheckGroupName); } comboBox1.DataSource = cgname; }
private void UC_Zdpdyj_Load(object sender, EventArgs e) { //if (LocalInfo.Current.user.ID == "17116") //{ // this.保存.Visible = true; // this.新增.Visible = true; //} //else //{ // this.保存.Visible = false; // this.新增.Visible = false; //} yjs.LoadData(); qCSamplezdpdyjBindingSource.DataSource = yjs; }
/// <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 WP_Zycx_Load(object sender, EventArgs e) { this.gridControl1.DataSource = cxs; cg.LoadData(); List <String> cgname = new List <String>(); cgname.Add("全部"); foreach (var item in cg) { cgname.Add(item.CheckGroupName); } comboBox1.DataSource = cgname; List <String> qylx = new List <String>(); qylx.Add("全部"); qylx.Add("快样"); qylx.Add("抽查样"); qylx.Add("普通样"); comboBox2.DataSource = qylx; }
private void DlgCheckItem_Load(object sender, EventArgs e) { // checkGroup.LoadData(); // this.repositoryItemGridLookUpEdit1.DataSource = checkGroup; // this.repositoryItemGridLookUpEdit1.ValueMember = "CheckGroupCode"; if (string.IsNullOrEmpty(matNcId)) { data.LoadData(); } else { data.LoadDataByWhere("CheckItemNcId in (select CHECKITEMNCID from QC_MATALLCHECKITEM where MATNCID=@MATNCID)", this.matNcId); } if (filterCheckItemIds != null) { data.Filter((ck) => !filterCheckItemIds.Contains(ck.CheckItemNcId)); } this.gridControl1.DataSource = data; }
private void UC_MatCheckStandard_Load(object sender, EventArgs e) { matFlView.LoadDataByWhere("invclasscode like '1%'"); // materials.LoadData(); this.treeList1.DataSource = matFlView; foreach (TreeListNode item in this.treeList1.Nodes) { if (SelectTreeNode(item)) { break; } } if (LocalInfo.Current.user.ID != "16870") { textEdit3.Enabled = false; } // this.gridMaterial.DataSource = materialView; this.gridMaterial.DataSource = materials; supplierDoc.LoadData(); QC_SupplierDoc allSupplier = new QC_SupplierDoc(); allSupplier.CustName = "所有厂家"; allSupplier.CustShortName = "所有厂家"; supplierDoc.Insert(0, allSupplier); this.qCSupplierDocBindingSource.DataSource = supplierDoc; //this.gridCheckItem.DataSource = matCheckItemView; //this.gridCheckGroup.DataSource = matCheckGroupView; //this.qCMatQualityLevelViewBindingSource.DataSource = matQualityLevelView; // this.gridQualityRule.DataSource = matQualityRule; repositoryItemGridLookUpEdit1.DataSource = matQualityLevelViewBindingSource; // matQualityRule.ListChanged += matQualityRule_ListChanged; }
private void WP_Shcx_Load(object sender, EventArgs e) { cg.LoadData(); List <String> cgname = new List <String>(); List <String> wl = new List <String>(); cgname.Add("全部"); wl.Add("全部"); foreach (var item in cg) { cgname.Add(item.CheckGroupName); } comboBox1.DataSource = cgname; lab.LoadData(); foreach (var item in lab) { if (!wl.Contains(item.MatName) && item.MatName != "") { wl.Add(item.MatName); } } lab.Clear(); comboBox2.DataSource = wl; }
private void LoadData() { btnSave.Enabled = false; checkGroup.LoadData(); }
private void QC_Gys_Load(object sender, EventArgs e) { gyss.LoadData(); this.qCBDCUBASDOCBindingSource.DataSource = gyss; }
private void DlgCheckItem_Load(object sender, EventArgs e) { data.LoadData(); this.gridControl1.DataSource = data; }
private void LoadData() { checkGroup.LoadData(); data.LoadData(); btnSave.Enabled = false; }
private void QC_Wuliao_Load(object sender, EventArgs e) { wls.LoadData(); this.qCMaterialwlBindingSource.DataSource = wls; }