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