C#自动代码生成器

C#自动代码生成器自动生成数据表和实体类S4E茹印2Uii-ii-iaLr，运.L'a-fk£-uci：">lme」hdKtlu,U/"JfcZItiLkl41PaJL・d£namespaceSQLApplicationAutoGeneratiTool(publicpartialclassForml:Formstring[]strArray={"int","string","decimal","bool","char","object","double","float","DateTime"};类文件\”;publicForm1()InitializeComponent();privatevoid新增文本框ToolStripMenuItem_Click(objectsender,EventArgse){ShengChengKongJian();privatevoidShengChengKongJian()ComboBoxcobm=newComboBox();for(inti=0;i<strArray.Count();i++){cobm.Items.Add(strArray[i]);}TextBoxtextbox=newTextBox();this.flowLayoutPanel1.Controls.Add(cobm);

this.flowLayoutPanel2.Controls.Add(textbox);)StringBuilderstbd=null;List<StringBuilder>strbldList=newList<StringBuilder>();privatevoidbutton1_Click(objectsender,EventArgse){if(comboBox1.Text.Trim()==""){MessageBox.Show("类名不能为空");return;)stbd=newStringBuilder("usingSystem;");strbldList.Add(stbd);stbd=newStringBuilder("usingSystem.Collections.Generic;");strbldList.Add(stbd);stbd=newStringBuilder("usingSystem.Linq;");strbldList.Add(stbd);stbd=newStringBuilder("usingSystem.Text;");strbldList.Add(stbd);stbd=newStringBuilder("usingSystem.Data;");strbldList.Add(stbd);stbd=newStringBuilder("usingSystem.Data.SqlClient;");strbldList.Add(stbd);stbd=newStringBuilder("usingSystem.Windows.Forms;");strbldList.Add(stbd);stbd=newStringBuilder("namespaceHospitalInformationManagmentSystem");strbldList.Add(stbd);stbd=newStringBuilder("{");strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder(版权信息，否则将追究相关责任");/*作者：大理大学软件教研室杜老师");*日期："+dateTimePicker1.Text.Trim());*版权：大理大学");*你可以免费使用或修改以下代码，但请保留strbldList.Add(stbd);stbd=newStringBuilder("*/");strbldList.Add(stbd);stbd=newStringBuilder("publicclass");stbd.Append(comboBox1.Text.Trim());strbldList.Add(stbd);

stbd=newStringBuilder("{");strbldList.Add(stbd);stbd=newStringBuilder("#region属性");strbldList.Add(stbd);for(inti=0;i<flowLayoutPanel1.Controls.Count;i++){StringBuilderstd=newStringBuilder("private");std.Append((flowLayoutPanel1.Controls[i]).Text.Trim());std.Append("");std.Append(flowLayoutPanel2.Controls[i].Text.Trim());std.Append(";");strbldList.Add(std);}stringshuX="";stringst="";strings1="";{shuX="for(inti=0;i<flowLayoutPanel1.Controls.Count;i++){shuX="public"+flowLayoutPanel1.Controls[i].Text.Trim()+"_"+flowLayoutPanel2.Controls[i].Text.Trim();set{"+flowLayoutPanel2.Controls[i].Text.Trim()+"=value;}";s1="";}";stbd=newStringBuilder(shuX);strbldList.Add(stbd);s1="";}";stbd=newStringBuilder(shuX);strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder(st);strbldList.Add(stbd);stbd=newStringBuilder(s1);strbldList.Add(stbd);stbd=newStringBuilder("get{return"+flowLayoutPanel2.Controls[i].Text.Trim()+{");}");strbldList.Add(stbd);}stbd=newStringBuilder("#endregion属性")；strbldList.Add(stbd);stbd=newStringBuilder("HIMSSqlConnectionsqlcon=newHIMSSqlConnection();");strbldList.Add(stbd);stbd=newStringBuilder("〃/〈summary〉")；strbldList.Add(stbd);stbd=newStringBuilder("〃/增加一条记录")；strbldList.Add(stbd);stbd=newStringBuilder("〃/〈/summary〉")；strbldList.Add(stbd);

stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("sqlcon.DataBaseConnection())");strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("{");inti=0;");using(SqlConnectioncon={");if(con.State==ConnectionState.Closed)");{");con.Open();");}");try");{");StringBuilderstrSql=newStringBuilder();");strSql.Append(\"insertinto");stbd.Append(comboBox1.Text.Trim());stbd.Append("(");for(inti=1;i<flowLayoutPanel2.Controls.Count;i++){if(i!=flowLayoutPanel2.Controls.Count-1){stbd.Append(flowLayoutPanel2.Controls[i].Text.Trim());stbd.Append(",");else{stbd.Append(flowLayoutPanel2.Controls[i].Text.Trim());}}stbd.Append(")");stbd.Append("values(");for(inti=1;i<flowLayoutPanel2.Controls.Count;i++)(if(i!=flowLayoutPanel2.Controls.Count-1)(stbd.Append("@");stbd.Append(flowLayoutPanel2.Controls[i].Text.Trim());stbd.Append(",");}else(stbd.Append("@");stbd.Append(flowLayoutPanel2.Controls[i].Text.Trim());}}stbd.Append(")\");");strbldList.Add(stbd);stbd=newStringBuilder("SqlCommandsqlCmd=newSqlCommand(strSql.ToString(),con);");strbldList.Add(stbd);stbd=newStringBuilder("SqlParameter口parameters={");for(inti=1;i<flowLayoutPanel2.Controls.Count;i++){if(i!=flowLayoutPanel2.Controls.Count-1){stbd.Append("newSqlParameter(\"@");stbd.Append(flowLayoutPanel2.Controls[i].Text.Trim());stbd.Append("\"");stbd.Append(",");stbd.Append(flowLayoutPanel2.Controls[i].Text.Trim());stbd.Append(")");stbd.Append(",");}else{stbd.Append("newSqlParameter(\"@");stbd.Append(flowLayoutPanel2.Controls[i].Text.Trim());stbd.Append("\"");stbd.Append(",");stbd.Append(flowLayoutPanel2.Controls[i].Text.Trim());stbd.Append(")};");}}strbldList.Add(stbd);stbd=newStringBuilder("foreach(SqlParameterparameterin

parameters)");strbldList.Add(stbd);parameters)");strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);sqlCmd.Parameters.Add(parameter);");}");i=sqlCmd.ExecuteNonQuery();");}");catch(Exceptionex)");{");stbd=newStringBuilder("MessageBox.Show(\"错误：\"+ex.Message,\"错误提示\",MessageBoxButtons.OKCancel,MessageBoxIcon.Error);");strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("finally");{");if(con.State==ConnectionState.Open)");{");con.Close();");con.Dispose();");}");}");if(i>0)");{");returntrue;");}");

strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);else");{");returnfalse;");}");}");}");〃/〈summary〉")；stbd=newStringBuilder(〃/更新一条数据");stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("sqlcon.DataBaseConnection())");strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("publicboolUpdate()");{");inti=0;");using(SqlConnectioncon={");if(con.State==ConnectionState.Closed)");{");con.Open();");}");try");{");StringBuilderstrSql=newStringBuilder();");strbldList.Add(stbd);stbd=newStringBuilder("strSql.Append(\"update"+comboBox1.Text.Trim()+"set");for(inti=1;i<flowLayoutPanel2.Controls.Count;i++){if(i!=flowLayoutPanel2.Controls.Count-1){stbd.Append(flowLayoutPanel2.Controls[i].Text.Trim());stbd.Append("=@");stbd.Append(flowLayoutPanel2.Controls[i].Text.Trim());stbd.Append(",");}else{stbd.Append(flowLayoutPanel2.Controls[i].Text.Trim());stbd.Append("=@");stbd.Append(flowLayoutPanel2.Controls[i].Text.Trim());stbd.Append("where");stbd.Append(flowLayoutPanel2.Controls[0].Text.Trim());stbd.Append("=\"+");stbd.Append(flowLayoutPanel2.Controls[0].Text.Trim());stbd.Append(");");}}strbldList.Add(stbd);stbd=newStringBuilder("SqlCommandsqlCmd=newSqlCommand(strSql.ToString(),con);");strbldList.Add(stbd);stbd=newStringBuilder("SqlParameter口parameters={");for(inti=1;i<flowLayoutPanel2.Controls.Count;i++){if(i!=flowLayoutPanel2.Controls.Count-1){stbd.Append("newSqlParameter(\"@");stbd.Append(flowLayoutPanel2.Controls[i].Text.Trim());stbd.Append("\"");stbd.Append(",");stbd.Append(flowLayoutPanel2.Controls[i].Text.Trim());stbd.Append(")");stbd.Append(",");}else{stbd.Append("newSqlParameter(\"@");

stbd.Append(flowLayoutPanel2.Controls[i].Text.Trim());stbd.Append("\"");stbd.Append(",");stbd.Append(flowLayoutPanel2.Controls[i].Text.Trim());stbd.Append(")};");}}strbldList.Add(stbd);stbd=newStringBuilder("parameters)");stbd.Append(")};");}}strbldList.Add(stbd);stbd=newStringBuilder("parameters)");strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("{");sqlCmd.Parameters.Add(parameter);");}");i=sqlCmd.ExecuteNonQuery();");}");catch(Exceptionex)");{");MessageBox.Show(\"错误：\"+ex.Message,\"错误提示\",MessageBoxButtons.OKCancel,MessageBoxIcon.Error);");strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);finally");{");if(con.State==ConnectionState.Open)");{");con.Close();");con.Dispose();");}");

stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);//数据查询}");if(i>0)");{");returntrue;");}");else");{");returnfalse;");}");}");}");stbd=newStringBuilder("///〈summary〉")；strbldList.Add(stbd);stbd=newStringBuilder("///数据查询");strbldList.Add(stbd);///</summary>");stbd=newStringBuilder(strbldList.Add(stbd);///</summary>");stbd=newStringBuilder(///<paramname=\"queryWhere\">查询条件</param>");strbldList.Add(stbd);</param>");strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder('sqlcon.DataBaseConnection())");strbldList.Add(stbd);stbd=newStringBuilder("con=///<returns>DataSet</returns>");publicDataSetSelect(stringqueryWhere)");{");DataSetds=newDataSet();");using(SqlConnection{");

strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("comboBox1.Text.Trim()+"\");");strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("queryWhere);");strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("SqlDataAdapter(strSql.ToString(),con);");strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("{");con.Open();");}");try");{");StringBuilderstrSql=newStringBuilder();");strSql.Append(\"select*\");");strSql.Append(\"FROM"+if(queryWhere.Trim()!=\"\")");{");strSql.Append(\"where\"+}");SqlDataAdaptersqlda=newsqlda.Fill(ds);");}");catch(Exceptionex)");{");MessageBox.Show(\"错误：\"+ex.Message,\"错误提示\",MessageBoxButtons.OKCancel,MessageBoxIcon.Error);");strbldList.Add(stbd);}");stbd=newStringBuilder(

}");strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);//删除一条记录stbd=newStringBuilder("{");if(con.State==ConnectionState.Open)");{");con.Close();");con.Dispose();");}");}");}");returnds;");}");///〈///〈summary>");stbd=newStringBuilder("///删除一条记录");strbldList.Add(stbd);stbd=newStringBuilder("///〈/summary〉")；strbldList.Add(stbd);stbdnewStringBuilder(///<paramname=\""flowLayoutPanel2.Controls[0].Text.Trim()+"\">主键</param>");newStringBuilder(///<paramname=\""strbldList.Add(stbd);stbd=newStringBuilder("flowLayoutPanel2.Controls[0].Text.Trim()+")");strbldList.Add(stbd);stbd=newStringBuilder("{");strbldList.Add(stbd);stbd=newStringBuilder("sqlcon.DataBaseConnection())");strbldList.Add(stbd);stbd=newStringBuilder("{");strbldList.Add(stbd);stbd=newStringBuilder(publicboolDelete(intusing(SqlConnectionconintrow=0;");strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);strbldList.Add(stbd);stbd=newStringBuilder(con);");strbldList.Add(stbd);stbd=newStringBuilder(strbldList.Add(stbd);stbd=newStringBuilder(strbldList.Add(stbd);stbd=newStringBuilder(strbldList.Add(stbd);stbd=newStringBuilder(strbldList.Add(stbd);strbldList.Add(stbd);stbd=newStringBuilder(strbldList.Add(stbd);stbd=newStringBuilder(strbldList.Add(stbd);stbd=newStringBuilder(strbldList.Add(stbd);stbd=newStringBuilder(strbldList.Add(stbd);stbd=newStringBuilder(strbldList.Add(stbd);stbd=newStringBuilder(strbldList.Add(stbd);stbd=newStringBuilder(if(con.State==ConnectionState.Closed)");{");con.Open();");}");try");{");stbd=newStringBuilder("stringsql=\"DeleteFrom"+comboBox1.Text.Trim()+"Where"+flowLayoutPanel2.Controls[0].Text.Trim()+"=\"+\"'\"+"+flowLayoutPanel2.Controls[0].Text.Trim()+"+\"'\";");SqlCommandsqlCmd=newSqlCommand(sql,row=sqlCmd.ExecuteNonQuery();");}");catch(Exceptionex)");{");stbd=newStringBuilder("MessageBox.Show(\"错误：\"+ex.Message,\"错误提示\",MessageBoxButtons.OKCancel,MessageBoxIcon.Error);");}");finally");{");if(con.State==ConnectionState.Open)");{");con.Close();");con.Dispose();");

strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);}");}");if(row>0)");{");returntrue;");}");else");{");returnfalse;");}");}");}");〃/〈summary〉")；stbd=newStringBuilder(strbldList.Add(stbd);〃/返回一个sqlReader阅读器");strbldList.Add(stbd);stbd=newStringBuilder("〃/<paramname=\"queryWhere\">查询条件</param>");strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder(queryWhere)");strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder(queryWhere)");strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("publicSqlDataReaderReturnSqlDataReader(string{");SqlDataReadersqlDataReader=null;");SqlConnectioncon=sqlcon.DataBaseConnection();");

strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder(""\");");strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbd=newStringBuilder("strbldList.Add(stbd);stbdnewStringBuilder("{");con.Open();");}");try");{");StringBuilderstrSql=newStringBuilder();");strSql.Append(\"select*\");");strSql.Append(\"FROM"+comboBox1.Text.Trim()+if(queryWhere.Trim()!=\"\")");{");strSql.Append(\"where\"+queryWhere);");}");SqlCommandsqlCmd=newSqlCommand(strSql.ToString(),con);");strbldList.Add(stbd);stbd=newStringBuilder("sqlDataReader=sqlCmd.ExecuteReader();");strbldList.Add(stbd);stbd=newStringBuilder("}");strbldList.Add(stbd);stbd=newStringBuilder(catch(Exceptionex)");strbldList.Add(stbd);catch(Exceptionex)");stbd=newStringBuilder("{");strbldList.Add(stbd);stbd=newStringBuilder("MessageBox.Show(\"错误：\"+ex.Message,\"错误提示\",MessageBoxButtons.OKCancel,MessageBoxIcon.Error);");strbldList.Add(stbd);}");stbd=newStringBuilder(strbldList.Add(stbd);}");returnsqlDataReader;");stbd=newStringBuilder("strbldList.Add(stbd);returnsqlDataReader;");stbd=newStringBuilder("}");strbldList.Add(stbd);stbd=newStringBuilder("}");strbldList.Add(stbd);stbd=newStringBuilder("}");strbldList.Add(stbd);//从这里开始//stbd=newStringBuilder("}");//strbldList.Add(stbd);//stbd=newStringBuilder("}");//strbldList.Add(stbd);stbd=newStringBuilder("");strbldList.Add(stbd);stbd=newStringBuilder("");strbldList.Add(stbd);stbd=newStringBuilder("");strbldList.Add(stbd);stbd=newStringBuilder("");strbldList.Add(stbd);stbd=newStringBuilder("");strbldList.Add(stbd);stbd=newStringBuilder("");strbldList.Add(stbd);stbd=newStringBuilder("");strbldList.Add(stbd);stbd=newStringBuilder("");strbldList.Add(stbd);FileStreamfs=newFileStream(path+comboBox1.Text.Trim()+".cs",FileMode.Create,FileAccess.Write);StreamWriterstreamWriter=newStreamWriter(fs);for(inti=0;i<strbldList.Count();i++){streamWriter.WriteLine(strbldList[i].ToString());richTextBox1.Text=richTextBox1.Text+strbldList[i].ToString()+"\n";}streamWriter.Flush();streamWriter.Close();//存储字段类型fs=newFileStream(path+comboBox1.Text.Trim()+"LeiXing.txt",FileMode.Create,FileAccess.Write);streamWriter=newStreamWriter(fs);for(inti=0;i<flowLayoutPanell.Controls.Count;i++)(streamWriter.WriteLine(flowLayoutPanel1.Controls[i].Text.Trim());)streamWriter.Flush();streamWriter.Close();//存储字段名称fs=newFileStream(path+comboBox1.Text.Trim()+"Ming.txt",FileMode.Create,FileAccess.Write);streamWriter=newStreamWriter(fs);for(inti=0;i<flowLayoutPanel2.Controls.Count;i++)(streamWriter.WriteLine(flowLayoutPanel2.Controls[i].Text.Trim());)streamWriter.Flush();streamWriter.Close();//存储字段数fs=newFileStream(path+comboBox1.Text.Trim()+"Count.txt",FileMode.Create,FileAccess.Write);streamWriter=newStreamWriter(fs);streamWriter.WriteLine(flowLayoutPanel2.Controls.Count.ToString());streamWriter.Flush();streamWriter.Close();)privatevoidbutton2_Click(objectsender,EventArgse)(DirectoryInfofolder=newDirectoryInfo(path);string[]sArray;foreach(FileInfofileinfolder.GetFiles("*.cs"))(sArray=file.Name.Split('.');comboBox1.Items.Add(sArray[0].ToString());))privatevoidbutton3_Click(objectsender,EventArgse)(FileStreamfs=newFileStream(path+comboBox1.Text.Trim()+"Count.txt",FileMode.Open,FileAccess.Read);StreamReaderstreamReader=newStreamReader(fs);stringstrLine=streamReader.ReadLine();for(inti=0;i<int.Parse(strLine);i++)(ShengChengKongJian();

)fs=newFileStream(path+comboBox1.Text.Trim()+"LeiXing.txt",FileMode.Open,FileAccess.Read);streamReader=newStreamReader(fs);strLine=streamReader.ReadLine();List<string>stList=newList<string>();while(strLine!=null