public static void YyjInfoInsert(Tpjyy tpjyyModel) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into PC_XTPY_STATUS ("); strSql.Append("JH,QK,CSRQ,WD,KHD,SJD,QYFS,TPSJ,ZYHD,CSBHD,TCHD,TCSJC,LTFX,SJHD,TSTL,ZSTL,YQD,KXD,KHBJ,BJ,TGSL,TGJL,TXSBL,YMC,GMC,YYL,YND,GYL,GND,GLJ,SGTS,YLSF,JXSJ,HSSJ,XJFD,YXQ,ZY,BZ,ZT)"); strSql.Append(" values("); strSql.Append("@JH,@QK,@CSRQ,@WD,@KHD,@SJD,@QYFS,@TPSJ,@ZYHD,@CSBHD,@TCHD,@TCSJC,@LTFX,@SJHD,@TSTL,@ZSTL,@YQD,@KXD,@KHBJ,@BJ,@TGSL,@TGJL,@TXSBL,@YMC,@GMC,@YYL,@YND,@GYL,@GND,@GLJ,@SGTS,@YLSF,@JXSJ,@HSSJ,@XJFD,@YXQ,@ZY,@BZ,@ZT)"); OleDbParameter[] parameters = { new OleDbParameter("@JH", tpjyyModel.Jh), new OleDbParameter("@QK", tpjyyModel.Qk), new OleDbParameter("@CSRQ", DateTime.Parse(tpjyyModel.Csrq)), new OleDbParameter("@WD", tpjyyModel.Wd), new OleDbParameter("@KHD", tpjyyModel.Khd), new OleDbParameter("@SJD", tpjyyModel.Sjd), new OleDbParameter("@QYFS", tpjyyModel.Qyfs), new OleDbParameter("@TPSJ", tpjyyModel.Tpsj), new OleDbParameter("@ZYHD", tpjyyModel.Zyhd), new OleDbParameter("@CSBHD", tpjyyModel.Csbhd), new OleDbParameter("@TCHD", tpjyyModel.Tchd), new OleDbParameter("@TCSJC", tpjyyModel.Tcsjc), new OleDbParameter("@LTFX", tpjyyModel.Ltfx), new OleDbParameter("@SJHD", tpjyyModel.Sjhd), new OleDbParameter("@TSTL", tpjyyModel.Tstl), new OleDbParameter("@ZSTL", tpjyyModel.Zstl), new OleDbParameter("@YQD", tpjyyModel.Yqd), new OleDbParameter("@KXD", tpjyyModel.Kxd), new OleDbParameter("@KHBJ", tpjyyModel.Khbj), new OleDbParameter("@BJ", tpjyyModel.Bj), new OleDbParameter("@TGSL", tpjyyModel.Tgsl), new OleDbParameter("@TGJL", tpjyyModel.Tgjl), new OleDbParameter("@TXSBL", tpjyyModel.Txsbl), new OleDbParameter("@YMC", tpjyyModel.Ymc), new OleDbParameter("@GMC", tpjyyModel.Gmc), new OleDbParameter("@YYL", tpjyyModel.Yyl), new OleDbParameter("@YND", tpjyyModel.Ynd), new OleDbParameter("@GYL", tpjyyModel.Gyl), new OleDbParameter("@GND", tpjyyModel.Gnd), new OleDbParameter("@GLJ", tpjyyModel.Glj), new OleDbParameter("@SGTS", tpjyyModel.Sgts), new OleDbParameter("@YLSF", tpjyyModel.Ylsf), new OleDbParameter("@JXSJ", tpjyyModel.Jxsj), new OleDbParameter("@HSSJ", tpjyyModel.Hssj), new OleDbParameter("@XJFD", tpjyyModel.Xjfd), new OleDbParameter("@YXQ", tpjyyModel.Yxq), new OleDbParameter("@ZY", tpjyyModel.Zy), new OleDbParameter("@BZ", tpjyyModel.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(); }