private void FormQCWateSet_Load(object sender, EventArgs e) { IEnumerable <WaterTestConfigureSet> list = WaterTestConfigureSetDAL.Query(); foreach (WaterTestConfigureSet item in list) { bind(item); } }
private int addTestSet(Control ctr) { //循环groupbox内控件,找到tag=groupbox名称的RadioButton int WaterTestConfigureSet_Project = 0; foreach (Control item in ctr.Controls) { if (item.Tag != null && item.Tag.ToString() == ctr.Name) { RadioButton r = (RadioButton)item; //找到选中的RadioButton if (r.Checked == true) { if (r.Text == "方案一") { WaterTestConfigureSet_Project = 1; } if (r.Text == "方案二") { WaterTestConfigureSet_Project = 2; } if (r.Text == "方案三") { WaterTestConfigureSet_Project = 3; } //循环控件,找到找到tag=RadioButton名称的textBox tbxList = new List <TextBox>(); foreach (Control txtItem in ctr.Controls) { if (txtItem.Tag != null && txtItem.Tag.ToString() == r.Name) { tbxList.Add((TextBox)txtItem); } } } } } //组合对象存入数据库 if (ctr.Parent.Parent is TabControl) { WaterTestConfigureSet w = new WaterTestConfigureSet(); w.WaterTestConfigureSet_frequency = Convert.ToInt32(((TabPage)ctr.Parent).Tag);//第几次检测 DataTable dt = LinQBaseDao.Query("select TestItems_ID from TestItems where TestItems_NAME = '" + ctr.Text + "'").Tables[0]; if (dt.Rows.Count > 0) { w.WaterTestConfigureSet_TestItems_TestItems_ID = Convert.ToInt32(dt.Rows[0][0]);//检测项目编号 } else { return(0); } w.WaterTestConfigureSet_Project = WaterTestConfigureSet_Project;//方案号 if (tbxList.Count == 2) { w.WaterTestConfigureSet_PackCount = Convert.ToInt32(tbxList[0].Text == "" ? "0" : tbxList[0].Text); w.WaterTestConfigureSet_NeedleCount = Convert.ToInt32(tbxList[1].Text == "" ? "0" : tbxList[1].Text); } if (tbxList.Count == 1) { w.WaterTestConfigureSet_NeedleCount = Convert.ToInt32(tbxList[0].Text == "" ? "0" : tbxList[0].Text); } else if (tbxList.Count > 2) { return(0); } Expression <Func <WaterTestConfigureSet, bool> > fn = n => n.WaterTestConfigureSet_frequency == w.WaterTestConfigureSet_frequency && n.WaterTestConfigureSet_TestItems_TestItems_ID == w.WaterTestConfigureSet_TestItems_TestItems_ID; if (WaterTestConfigureSetDAL.Single(fn) == null) { bool b = WaterTestConfigureSetDAL.InsertOneQCRecord(w); } else { Action <WaterTestConfigureSet> a = n => { n.WaterTestConfigureSet_frequency = w.WaterTestConfigureSet_frequency; n.WaterTestConfigureSet_TestItems_TestItems_ID = w.WaterTestConfigureSet_TestItems_TestItems_ID; n.WaterTestConfigureSet_Project = w.WaterTestConfigureSet_Project; n.WaterTestConfigureSet_NeedleCount = w.WaterTestConfigureSet_NeedleCount; n.WaterTestConfigureSet_PackCount = w.WaterTestConfigureSet_PackCount; }; bool b = WaterTestConfigureSetDAL.Update(fn, a); return(1); } } return(0); }