| | |
| | | //齐套入库 |
| | | sb.Append(" insert into [dbo].[MES_CONFIG](guid,parameter,parameterValue,remark) "); |
| | | sb.Append(" values(newid(),'" + lb_qtRk.Text.Trim() + "','" + txt_qtRk.Text.Trim() + "','" + layoutControlItem18.Text.Trim() + "')"); |
| | | //颜色 |
| | | sb.Append(" insert into [dbo].[MES_CONFIG](guid,parameter,parameterValue,remark) "); |
| | | sb.Append(" values(newid(),'" + lb_colorFinish.Text.Trim() + "','" + txt_colorFinish.Text.Trim() + "','" + layoutControlItem20.Text.Trim() + "')"); |
| | | sb.Append(" insert into [dbo].[MES_CONFIG](guid,parameter,parameterValue,remark) "); |
| | | sb.Append(" values(newid(),'" + lb_colorIng.Text.Trim() + "','" + txt_colorIng.Text.Trim() + "','" + layoutControlItem21.Text.Trim() + "')"); |
| | | sb.Append(" insert into [dbo].[MES_CONFIG](guid,parameter,parameterValue,remark) "); |
| | | sb.Append(" values(newid(),'" + lb_color.Text.Trim() + "','" + txt_color.Text.Trim() + "','" + layoutControlItem22.Text.Trim() + "')"); |
| | | var _obj = new |
| | | { |
| | | sql = sb.ToString(), |
| | |
| | | txt_qtRk.Text = row["parameterValue"].ToString(); |
| | | continue; |
| | | } |
| | | |
| | | if (row["remark"].ToString() == layoutControlItem20.Text) |
| | | { |
| | | txt_colorFinish.Text = row["parameterValue"].ToString(); |
| | | continue; |
| | | } |
| | | if (row["remark"].ToString() == layoutControlItem21.Text) |
| | | { |
| | | txt_colorIng.Text = row["parameterValue"].ToString(); |
| | | continue; |
| | | } |
| | | if (row["remark"].ToString() == layoutControlItem22.Text) |
| | | { |
| | | txt_color.Text = row["parameterValue"].ToString(); |
| | | continue; |
| | | } |
| | | } |
| | | } |
| | | else |