从linq query数据，创建一个实体或者说 class

最新推荐文章于 2022-09-03 15:42:03 发布

weng3998

最新推荐文章于 2022-09-03 15:42:03 发布

阅读量185

点赞数

分类专栏： c#

本文链接：https://blog.csdn.net/weng3998/article/details/84207071

版权

c# 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

从linq query数据，创建一个实体或者说 class
我的工作是做cad开发的基本上是在别人已经做好的架构上做第二次开发有时候需要 linq query 结果，作为一个实体来使或者说是一个类

为了方便我建立子程序用linq query的结果建立一个新的实体贴在这里供大家，讨论完善

linq query 结果，是不能够作为变量传输的它是一个 anonymou

这段程序将 anonymous 作为 dynamic分析建立属性从而构成一个类

类中有一个特殊的Dictionaryn rr 用来兼容大小写 (主要是我的数据来自于oracle和 Sql server)

仅仅是一个例子，

var s_out = pp.
Cfc_list.Select(p => new
{
type = pp.T_br,
len = string.Format("{0:F2}", pp.Len),
Part = pp.P_part
aaa=p.aaa
};

//var test = tool_create_class(s_out, "print_1");

新的类被创建在 test 中类的名字 print_1
所以我们有

List <print_1> outt= s_out.Select(q=> new print_1(q)).Tolist();

private string tool_create_class(IEnumerable<dynamic> onym_s, string class_name)
{
dynamic onym = onym_s.First();
var anonymous_types = onym.GetType().GetProperties();
string r_r = "public class " + class_name + "\n{" +
"\n\tpublic " + class_name + "( DataRow r)\n\t{\t\n";
string r_r_e =
"\n\tpublic " + class_name + "( dynamic onym)\n\t {\t\n";
r_r += "\t var rr = new Dictionary<String, String>();\n";
r_r += "\t foreach (DataColumn a_pro in r.Table.Columns)\n\t {\n";
r_r += "\t rr.Add(((String)a_pro.ColumnName).ToUpper(), (String)a_pro.ColumnName);\n";
r_r += " \t }\n";
r_r_e += "\t var rr = new Dictionary<String, String>();\n";
r_r_e += "\t foreach (PropertyInfo a_pro in onym.GetType().GetProperties())\n\t {\n";
r_r_e += "\t rr.Add(((String)a_pro.Name).ToUpper(), (String)a_pro.Name);\n";
r_r_e += " \t }\n";
string new_eq = "";
string new_eq_e = "";
string prop = "";
int cur_col_num = 0;

foreach (var a_type in anonymous_types)
{
string col_name = a_type.Name;
string col_type = a_type.PropertyType.ToString();
var name_name = a_type.PropertyType.Name;
var full_name = a_type.PropertyType.FullName;
new_eq += "\t" + col_name + " = ";
new_eq_e += "\t" + col_name + " = ";
if (col_type.Contains("System.String"))
{
prop += "\tpublic " + "string" + " " + col_name + " { get; set; } \n";
new_eq += "\t r[rr[\"" + col_name.ToUpper() + "\"]]== DBNull.Value ? \"\" : Convert.ToString(r[rr[\"" + col_name.ToUpper() + "\"]]); \n";
new_eq_e += "onym.GetType().GetProperty(rr[\"" + col_name.ToUpper() + "\"]).GetValue(onym, null) ==null ? \"\" : \n\t" +
" onym.GetType().GetProperty(rr[\"" + col_name.ToUpper() + "\"]).GetValue(onym, null); \n";
}
else if (col_type.Contains("System.Guid"))
{
prop += "\tpublic " + "Guid" + " " + col_name + " { get; set; } \n";
new_eq += " r[rr[\"" + col_name.ToUpper() + "\"]]== DBNull.Value ? \n" +
"\t Guid.NewGuid() : Guid.Parse(r[rr[\"" + col_name.ToUpper() + "\"]].ToString()) ; \n";
new_eq_e += "onym.GetType().GetProperty(rr[\"" + col_name.ToUpper() + "\"]).GetValue(onym, null) ==null ? Guid.NewGuid() : \n\t" +
" Guid.Parse(onym.GetType().GetProperty(rr[\"" + col_name.ToUpper() + "\"]).GetValue(onym, null).ToString() ) ; \n";
}
else if (col_type.Contains("System.Int32"))
{

prop += "\tpublic " + "Int32" + " " + col_name + " { get; set; } \n";
new_eq += " r[rr[\"" + col_name.ToUpper() + "\"]]== DBNull.Value ? 0 : Convert.ToInt32(r[rr[\"" + col_name.ToUpper() + "\"]]); \n";
new_eq_e += "onym.GetType().GetProperty(rr[\"" + col_name.ToUpper() + "\"]).GetValue(onym, null) ==null ? 0 : \n\t" +
" Convert.ToInt32( onym.GetType().GetProperty(rr[\"" + col_name.ToUpper() + "\"]).GetValue(onym, null) ) ; \n";
}
else if (col_type.Contains("System.Double") || col_type.Contains("System.Decimal") || col_type.Contains("System.Single"))
{
prop += "\tpublic " + "Double" + " " + col_name + " { get; set; } \n";
new_eq += " r[rr[\"" + col_name.ToUpper() + "\"]]== DBNull.Value ? 0.0 :Convert.ToDouble(r[rr[\"" + col_name.ToUpper() + "\"]]); \n";
new_eq_e += "onym.GetType().GetProperty(rr[\"" + col_name.ToUpper() + "\"]).GetValue(onym, null) ==null ? 0.0 : \n\t" +
" Convert.ToDouble( onym.GetType().GetProperty(rr[\"" + col_name.ToUpper() + "\"]).GetValue(onym, null) ) ; \n";
}
else if (col_type.Contains("Boolean"))
{
prop += "\tpublic " + "Boolean" + " " + col_name + " { get; set; } \n";
new_eq += " r[rr[\"" + col_name.ToUpper() + "\"]]== DBNull.Value ? false : Convert.ToBoolean(r[rr[\"" + col_name.ToUpper() + "\"]]); \n";
new_eq_e += "onym.GetType().GetProperty(rr[\"" + col_name.ToUpper() + "\"]).GetValue(onym, null) ==null ? false : \n\t" +
" Convert.ToBoolean( onym.GetType().GetProperty(rr[\"" + col_name.ToUpper() + "\"]).GetValue(onym, null) ) ; \n";
}
else if (!col_type.Contains("System"))
{

prop += "\tpublic " + name_name + "_ " + col_name + " { get; set; } \n";
new_eq += "typeof(" + name_name + "_).IsInstanceOfType( r[rr[\"" + col_name.ToUpper() + "\"]]) ? " +
" r[rr[\"" + col_name.ToUpper() + "\"]]:DBNull.Value; \n";
new_eq_e += "onym.GetType().GetProperty(rr[\"" + col_name.ToUpper() + "\"]).GetValue(onym, null) ==null ? false : \n\t" +
" onym.GetType().GetProperty(rr[\"" + col_name.ToUpper() + "\"]).GetValue(onym, null) ) ; \n";
}
else if (col_type.Contains("System.DateTime"))
{
prop += "\tpublic " + "System.DateTime" + " " + col_name + " { get; set; } \n";
new_eq += " r[rr[\"" + col_name.ToUpper() + "\"]]== DBNull.Value ? DateTime.Now : Convert.ToDateTime(r[rr[\"" + col_name.ToUpper() + "\"]]); \n";
new_eq_e += "onym.GetType().GetProperty(rr[\"" + col_name.ToUpper() + "\"]).GetValue(onym, null) ==null ? DateTime.Now : \n\t" +
" Convert.ToDateTime( onym.GetType().GetProperty(rr[\"" + col_name.ToUpper() + "\"]).GetValue(onym, null) ) ; \n";
}
else
{
new_eq += "error error " + col_type;
}
cur_col_num++;
}
new_eq = new_eq.TrimEnd('\n');
prop = prop.TrimEnd('\n');