public static void YttpjInsert(Yttpj Ytmodel) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into PC_XTPL_STATUS ("); strSql.Append("MC,DW,TYRQ,NW,NY,NJ,XN,CN,ZN,GJL,SXQ,JG,BZ,ZT)"); strSql.Append(" values("); strSql.Append("@MC,@DW,@TYRQ,@NW,@NY,@NJ,@XN,@CN,@ZN,@GJL,@SXQ,@JG,@BZ,@ZT)"); OleDbParameter[] parameters = { new OleDbParameter("@MC", Ytmodel.Mc), new OleDbParameter("@DW", Ytmodel.Dw), new OleDbParameter("@TYRQ", DateTime.Parse(Ytmodel.Tyrq)), new OleDbParameter("@NW", Ytmodel.Nw), new OleDbParameter("@NY", Ytmodel.Ny), new OleDbParameter("@NJ", Ytmodel.Nj), new OleDbParameter("@XN", Ytmodel.Xn), new OleDbParameter("@CN", Ytmodel.Cn), new OleDbParameter("@ZN", Ytmodel.Zn), new OleDbParameter("@GJL", Ytmodel.Gjl), new OleDbParameter("@SXQ", Ytmodel.Sxq), new OleDbParameter("@JG", Ytmodel.Jg), new OleDbParameter("@BZ", Ytmodel.Bz), new OleDbParameter("@ZT", 1), }; Hashtable sqlTable = new Hashtable { { strSql.ToString(), parameters } }; try { DbHelperOleDb.ExecuteSqlTran(sqlTable); } catch { throw; } }
private void doTpjImport(string tablename) { object targetObject = null; DataTable fieldnames = null; switch (tablename) { case "PC_XTPL_STATUS": targetObject = new Yttpj(); fieldnames = Tpj_Insert_BLL.getChineseFieldName(tablename); break; case "PC_XTPK_STATUS": targetObject = new Kltpj(); fieldnames = Tpj_Insert_BLL.getChineseFieldName(tablename); break; case "PC_XTPY_STATUS": targetObject = new Tpjyy(); fieldnames = Tpj_Insert_BLL.getChineseFieldName(tablename); break; } if (targetObject == null || fieldnames == null) { return; } List <DataRow> dataRows = fieldnames.Rows.OfType <DataRow>().ToList(); //获取父类对象类型信息 TypeInfo parentType = targetObject.GetType().BaseType.GetTypeInfo(); //获取对象类型信息 TypeInfo current = targetObject.GetType().GetTypeInfo(); //获取类声明字段 List <PropertyInfo> properties = parentType.DeclaredProperties.ToList(); properties.AddRange(current.DeclaredProperties.ToList()); //创建控件集合 StackPanel parentStack = new StackPanel() { HorizontalAlignment = HorizontalAlignment.Left, VerticalAlignment = VerticalAlignment.Center, Orientation = Orientation.Horizontal }; foreach (PropertyInfo item in properties) { StackPanel childStack = new StackPanel() { HorizontalAlignment = HorizontalAlignment.Center, VerticalAlignment = VerticalAlignment.Center, Orientation = Orientation.Horizontal }; DataRow findOne = dataRows.Find(x => x.ItemArray[1].ToString().Equals(item.Name, StringComparison.OrdinalIgnoreCase)); if (findOne == null) { continue; } TextBlock lable = new TextBlock() { Text = findOne.ItemArray[2].ToString() + ":" }; FrameworkElement field = null; if (item.Name.Equals("csrq", StringComparison.OrdinalIgnoreCase) || item.Name.Equals("tyrq", StringComparison.OrdinalIgnoreCase)) { field = new DatePicker() { Width = 100, Margin = new Thickness() { Left = 0, Top = 0, Right = 10, Bottom = 0 }, SelectedDateFormat = DatePickerFormat.Short }; Binding binding = new Binding(); binding.Path = new PropertyPath(item.Name); binding.Mode = BindingMode.TwoWay; binding.UpdateSourceTrigger = UpdateSourceTrigger.PropertyChanged; field.SetBinding(DatePicker.TextProperty, binding); } else { field = new TextBox() { Width = 50, Margin = new Thickness() { Left = 0, Top = 0, Right = 10, Bottom = 0 } }; field.SetBinding(TextBox.TextProperty, item.Name); } childStack.Children.Add(lable); childStack.Children.Add(field); parentStack.Children.Add(childStack); } TpjImport tpjImport = new TpjImport(); tpjImport.tpj_info.Content = parentStack; tpjImport.DataContext = targetObject; tpjImport.ShowDialog(); }