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);
}
