Reply to thread

Message

<blockquote data-quote="HAneo" data-source="post: 26465704" data-attributes="member: 17432">මේ වැඩේ තේරෙන්න මම සාම්පල කෝඩ් ටිකක් දෙන්නම්. මේක SQL&nbsp; සහ C# වලින් කරපු වැඩක් කොහොමද ඩේටා ටේබල් එකක් හරහා ගිහින් ඕනේ ටික ඔබ්ජෙක්ට් වලට පුරවා ගන්නේ-----------------------------------------------------------------------------------------------------------------------------------------------[CODE]&nbsp; &nbsp; private static void QueryTable(SqlConnection connection, Table table)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Get a list of the entities in the database&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DataTable dataTable = new DataTable();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SqlDataAdapter dataAdapter = new SqlDataAdapter(Utility.GetColumnQuery(table.Name), connection);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; dataAdapter.Fill(dataTable);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; foreach (DataRow columnRow in dataTable.Rows)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Column column = new Column();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; column.Name = columnRow[&quot;COLUMN_NAME&quot;].ToString();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; column.Type = columnRow[&quot;DATA_TYPE&quot;].ToString();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; column.Precision = columnRow[&quot;NUMERIC_PRECISION&quot;].ToString();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; column.Scale = columnRow[&quot;NUMERIC_SCALE&quot;].ToString();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Determine the column's length&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (columnRow[&quot;CHARACTER_MAXIMUM_LENGTH&quot;] != DBNull.Value)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; column.Length = columnRow[&quot;CHARACTER_MAXIMUM_LENGTH&quot;].ToString();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; else&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; column.Length = columnRow[&quot;COLUMN_LENGTH&quot;].ToString();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Is the column a RowGuidCol column?&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (columnRow[&quot;IS_ROWGUIDCOL&quot;].ToString() == &quot;1&quot;)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; column.IsRowGuidCol = true;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Is the column an Identity column?&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (columnRow[&quot;IS_IDENTITY&quot;].ToString() == &quot;1&quot;)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; column.IsIdentity = true;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Is columnRow column a computed column?&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (columnRow[&quot;IS_COMPUTED&quot;].ToString() == &quot;1&quot;)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; column.IsComputed = true;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; table.Columns.Add(column);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }[/CODE]මේ තියෙන්නේ ටේබල් ඔක්කොම හරහා ගිහින් StoredProcedure සහ&nbsp;&nbsp; DataAccess ක්ලාස් හදාගන්න විදිහ. -------------------------------------------------------------------------------------------------------------------------------------[CODE]&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; foreach (Table table in tableList)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SqlGenerator.CreateSaveStoredProcedure(databaseName, table, grantLoginName, storedProcedurePrefix, sqlPath, createMultipleFiles);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SqlGenerator.CreateInsertStoredProcedure(databaseName, table, grantLoginName, storedProcedurePrefix, sqlPath, createMultipleFiles);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SqlGenerator.CreateUpdateStoredProcedure(databaseName, table, grantLoginName, storedProcedurePrefix, sqlPath, createMultipleFiles);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SqlGenerator.CreateDeleteStoredProcedure(databaseName, table, grantLoginName, storedProcedurePrefix, sqlPath, createMultipleFiles);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SqlGenerator.CreateDeleteAllByStoredProcedures(databaseName, table, grantLoginName, storedProcedurePrefix, sqlPath, createMultipleFiles);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SqlGenerator.CreateSelectStoredProcedure(databaseName, table, grantLoginName, storedProcedurePrefix, sqlPath, createMultipleFiles);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SqlGenerator.CreateSelectAllStoredProcedure(databaseName, table, grantLoginName, storedProcedurePrefix, sqlPath, createMultipleFiles);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SqlGenerator.CreateSelectAllByStoredProcedures(databaseName, table, grantLoginName, storedProcedurePrefix, sqlPath, createMultipleFiles);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CsGenerator.CreateDataTransferClass(table, targetNamespace, dtoSuffix, csPath);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CsGenerator.CreateDataAccessClass(databaseName, table, targetNamespace, storedProcedurePrefix, daoSuffix, dtoSuffix, csPath);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CsGenerator.CreateFORMClasses(databaseName, table, targetNamespace, storedProcedurePrefix, daoSuffix, dtoSuffix, csPath);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; table2 = table;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; count++;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; TableCounted(null, new CountEventArgs(count));&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }[/CODE]මේ තියෙන්නේ උඩ ලුප් එකේ තිබ්බ CreateSaveStoredProcedure එකේ අතුල[CODE]&nbsp; &nbsp; &nbsp; &nbsp; public static void CreateSaveStoredProcedure(string databaseName, Table table, string grantLoginName,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; string storedProcedurePrefix, string path, bool createMultipleFiles)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Create the stored procedure name&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; string procedureName = Utility.FormatPascal(table.Name).Trim() + &quot;Save&quot;;&nbsp; //storedProcedurePrefix + table.Name + &quot;Insert&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; string fileName;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Determine the file name to be used&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (createMultipleFiles)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; path = Path.Combine(path, &quot;SaveSPs&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; fileName = Path.Combine(path, procedureName + &quot;.sql&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; else&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; fileName = Path.Combine(path, &quot;StoredProcedures.sql&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; using (StreamWriter streamWriter = new StreamWriter(fileName, true))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; streamWriter.WriteLine(&quot;USE [&quot; + databaseName + &quot;]&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; streamWriter.WriteLine(&quot;GO&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; streamWriter.WriteLine(&quot;SET ANSI_NULLS ON&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; streamWriter.WriteLine(&quot;GO&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; streamWriter.WriteLine(&quot;SET QUOTED_IDENTIFIER ON&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; streamWriter.WriteLine(&quot;GO&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; streamWriter.WriteLine(&quot;CREATE PROCEDURE [dbo].[&quot; + Utility.FormatPascal(table.Name) + &quot;Save]&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; streamWriter.WriteLine(&quot;/*** ***************************************************************************************************** ****/&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; streamWriter.WriteLine(&quot;-- This procedure was Auto Genarated By A tool created by S.G. Asanga Chandrakumara&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; streamWriter.WriteLine(&quot;-- On 11:30 AM 7/14/2015&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; streamWriter.WriteLine(&quot;/*** ***************************************************************************************************** ****/&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; streamWriter.WriteLine(&quot;&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Create the parameter list&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; for (int i = 0; i &lt; table.Columns.Count; i++)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Column column = table.Columns[i];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (column.IsIdentity == false &amp;&amp; column.IsRowGuidCol == false)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; streamWriter.Write(&quot;\t&quot; + Utility.CreateParameterString(column, true));&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; streamWriter.Write(&quot;,&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (i &lt; (table.Columns.Count - 1))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; streamWriter.WriteLine();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; streamWriter.WriteLine(&quot;\t@InsMode&nbsp; &nbsp; int,&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; streamWriter.WriteLine(&quot;\t@RtnValue int Output&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; streamWriter.WriteLine(&quot;&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; streamWriter.WriteLine(&quot;&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }[/CODE]මේ තියෙන්නේ උඩ ලුප් එකේ තිබ්බ&nbsp; DataTransferClass එකේ අතුල[CODE]&nbsp; &nbsp; public static void CreateDataTransferClass(Table table, string targetNamespace, string dtoSuffix, string path)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; string className = Utility.FormatClassName(table.Name) + dtoSuffix;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; using (StreamWriter streamWriter = new StreamWriter(Path.Combine(path, className + &quot;.cs&quot;)))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Create the header for the class&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; streamWriter.WriteLine(&quot;using System;&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; streamWriter.WriteLine();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; streamWriter.WriteLine(&quot;namespace &quot; + targetNamespace);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; streamWriter.WriteLine(&quot;{&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; streamWriter.WriteLine(&quot;\tpublic class &quot; + className);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; streamWriter.WriteLine(&quot;\t{&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Create an explicit public constructor&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; streamWriter.WriteLine(&quot;\t\t#region Constructors&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; streamWriter.WriteLine();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; streamWriter.WriteLine(&quot;\t\t/// &lt;summary&gt;&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; streamWriter.WriteLine(&quot;\t\t/// Initializes a new instance of the &quot; + className + &quot; class.&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; streamWriter.WriteLine(&quot;\t\t/// &lt;/summary&gt;&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; streamWriter.WriteLine(&quot;\t\tpublic &quot; + className + &quot;()&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; streamWriter.WriteLine(&quot;\t\t{&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; streamWriter.WriteLine(&quot;\t\t}&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; streamWriter.WriteLine();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Create the &quot;partial&quot; constructor&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; int parameterCount = 0;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; streamWriter.WriteLine(&quot;\t\t/// &lt;summary&gt;&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; streamWriter.WriteLine(&quot;\t\t/// Initializes a new instance of the &quot; + className + &quot; class.&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; streamWriter.WriteLine(&quot;\t\t/// &lt;/summary&gt;&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; streamWriter.Write(&quot;\t\tpublic &quot; + className + &quot;(&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; for (int i = 0; i &lt; table.Columns.Count; i++)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Column column = table.Columns[i];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (column.IsIdentity == false &amp;&amp; column.IsRowGuidCol == false)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; streamWriter.Write(Utility.CreateMethodParameter(column));&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (i &lt; (table.Columns.Count - 1))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; streamWriter.Write(&quot;, &quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; parameterCount++;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Close out the class and namespace&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; streamWriter.WriteLine(&quot;\t}&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; streamWriter.WriteLine(&quot;}&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp;&nbsp; [/CODE]</blockquote>

[QUOTE="HAneo, post: 26465704, member: 17432"] [COLOR=rgb(243, 121, 52)][SIZE=5]මේ වැඩේ තේරෙන්න මම සාම්පල කෝඩ් ටිකක් දෙන්නම්. මේක SQL සහ C# වලින් කරපු වැඩක් [/SIZE][/COLOR] [B][SIZE=5]කොහොමද ඩේටා ටේබල් එකක් හරහා ගිහින් ඕනේ ටික ඔබ්ජෙක්ට් වලට පුරවා ගන්නේ[/SIZE][/B] ----------------------------------------------------------------------------------------------------------------------------------------------- [CODE] private static void QueryTable(SqlConnection connection, Table table) { // Get a list of the entities in the database DataTable dataTable = new DataTable(); SqlDataAdapter dataAdapter = new SqlDataAdapter(Utility.GetColumnQuery(table.Name), connection); dataAdapter.Fill(dataTable); foreach (DataRow columnRow in dataTable.Rows) { Column column = new Column(); column.Name = columnRow["COLUMN_NAME"].ToString(); column.Type = columnRow["DATA_TYPE"].ToString(); column.Precision = columnRow["NUMERIC_PRECISION"].ToString(); column.Scale = columnRow["NUMERIC_SCALE"].ToString(); // Determine the column's length if (columnRow["CHARACTER_MAXIMUM_LENGTH"] != DBNull.Value) { column.Length = columnRow["CHARACTER_MAXIMUM_LENGTH"].ToString(); } else { column.Length = columnRow["COLUMN_LENGTH"].ToString(); } // Is the column a RowGuidCol column? if (columnRow["IS_ROWGUIDCOL"].ToString() == "1") { column.IsRowGuidCol = true; } // Is the column an Identity column? if (columnRow["IS_IDENTITY"].ToString() == "1") { column.IsIdentity = true; } // Is columnRow column a computed column? if (columnRow["IS_COMPUTED"].ToString() == "1") { column.IsComputed = true; } table.Columns.Add(column); }[/CODE] [B][SIZE=5]මේ තියෙන්නේ ටේබල් ඔක්කොම හරහා ගිහින් StoredProcedure සහ DataAccess ක්ලාස් හදාගන්න විදිහ.[/SIZE] [/B] ------------------------------------------------------------------------------------------------------------------------------------- [CODE] foreach (Table table in tableList) { SqlGenerator.CreateSaveStoredProcedure(databaseName, table, grantLoginName, storedProcedurePrefix, sqlPath, createMultipleFiles); SqlGenerator.CreateInsertStoredProcedure(databaseName, table, grantLoginName, storedProcedurePrefix, sqlPath, createMultipleFiles); SqlGenerator.CreateUpdateStoredProcedure(databaseName, table, grantLoginName, storedProcedurePrefix, sqlPath, createMultipleFiles); SqlGenerator.CreateDeleteStoredProcedure(databaseName, table, grantLoginName, storedProcedurePrefix, sqlPath, createMultipleFiles); SqlGenerator.CreateDeleteAllByStoredProcedures(databaseName, table, grantLoginName, storedProcedurePrefix, sqlPath, createMultipleFiles); SqlGenerator.CreateSelectStoredProcedure(databaseName, table, grantLoginName, storedProcedurePrefix, sqlPath, createMultipleFiles); SqlGenerator.CreateSelectAllStoredProcedure(databaseName, table, grantLoginName, storedProcedurePrefix, sqlPath, createMultipleFiles); SqlGenerator.CreateSelectAllByStoredProcedures(databaseName, table, grantLoginName, storedProcedurePrefix, sqlPath, createMultipleFiles); CsGenerator.CreateDataTransferClass(table, targetNamespace, dtoSuffix, csPath); CsGenerator.CreateDataAccessClass(databaseName, table, targetNamespace, storedProcedurePrefix, daoSuffix, dtoSuffix, csPath); CsGenerator.CreateFORMClasses(databaseName, table, targetNamespace, storedProcedurePrefix, daoSuffix, dtoSuffix, csPath); table2 = table; count++; TableCounted(null, new CountEventArgs(count)); } [/CODE] [SIZE=5][B]මේ තියෙන්නේ උඩ ලුප් එකේ තිබ්බ CreateSaveStoredProcedure එකේ අතුල[/B][/SIZE] [CODE] public static void CreateSaveStoredProcedure(string databaseName, Table table, string grantLoginName, string storedProcedurePrefix, string path, bool createMultipleFiles) { // Create the stored procedure name string procedureName = Utility.FormatPascal(table.Name).Trim() + "Save"; //storedProcedurePrefix + table.Name + "Insert"; string fileName; // Determine the file name to be used if (createMultipleFiles) { path = Path.Combine(path, "SaveSPs"); fileName = Path.Combine(path, procedureName + ".sql"); } else { fileName = Path.Combine(path, "StoredProcedures.sql"); } using (StreamWriter streamWriter = new StreamWriter(fileName, true)) { streamWriter.WriteLine("USE [" + databaseName + "]"); streamWriter.WriteLine("GO"); streamWriter.WriteLine("SET ANSI_NULLS ON"); streamWriter.WriteLine("GO"); streamWriter.WriteLine("SET QUOTED_IDENTIFIER ON"); streamWriter.WriteLine("GO"); streamWriter.WriteLine("CREATE PROCEDURE [dbo].[" + Utility.FormatPascal(table.Name) + "Save]"); streamWriter.WriteLine("/*** ***************************************************************************************************** ****/"); streamWriter.WriteLine("-- This procedure was Auto Genarated By A tool created by S.G. Asanga Chandrakumara"); streamWriter.WriteLine("-- On 11:30 AM 7/14/2015"); streamWriter.WriteLine("/*** ***************************************************************************************************** ****/"); streamWriter.WriteLine(""); // Create the parameter list for (int i = 0; i < table.Columns.Count; i++) { Column column = table.Columns[i]; if (column.IsIdentity == false && column.IsRowGuidCol == false) { streamWriter.Write("\t" + Utility.CreateParameterString(column, true)); streamWriter.Write(","); if (i < (table.Columns.Count - 1)) { } streamWriter.WriteLine(); } } streamWriter.WriteLine("\t@InsMode int,"); streamWriter.WriteLine("\t@RtnValue int Output"); streamWriter.WriteLine(""); streamWriter.WriteLine(""); } } [/CODE] [SIZE=5][B]මේ තියෙන්නේ උඩ ලුප් එකේ තිබ්බ DataTransferClass එකේ අතුල[/B][/SIZE] [CODE] public static void CreateDataTransferClass(Table table, string targetNamespace, string dtoSuffix, string path) { string className = Utility.FormatClassName(table.Name) + dtoSuffix; using (StreamWriter streamWriter = new StreamWriter(Path.Combine(path, className + ".cs"))) { // Create the header for the class streamWriter.WriteLine("using System;"); streamWriter.WriteLine(); streamWriter.WriteLine("namespace " + targetNamespace); streamWriter.WriteLine("{"); streamWriter.WriteLine("\tpublic class " + className); streamWriter.WriteLine("\t{"); // Create an explicit public constructor streamWriter.WriteLine("\t\t#region Constructors"); streamWriter.WriteLine(); streamWriter.WriteLine("\t\t/// <summary>"); streamWriter.WriteLine("\t\t/// Initializes a new instance of the " + className + " class."); streamWriter.WriteLine("\t\t/// </summary>"); streamWriter.WriteLine("\t\tpublic " + className + "()"); streamWriter.WriteLine("\t\t{"); streamWriter.WriteLine("\t\t}"); streamWriter.WriteLine(); // Create the "partial" constructor int parameterCount = 0; streamWriter.WriteLine("\t\t/// <summary>"); streamWriter.WriteLine("\t\t/// Initializes a new instance of the " + className + " class."); streamWriter.WriteLine("\t\t/// </summary>"); streamWriter.Write("\t\tpublic " + className + "("); for (int i = 0; i < table.Columns.Count; i++) { Column column = table.Columns[i]; if (column.IsIdentity == false && column.IsRowGuidCol == false) { streamWriter.Write(Utility.CreateMethodParameter(column)); if (i < (table.Columns.Count - 1)) { streamWriter.Write(", "); } parameterCount++; } } // Close out the class and namespace streamWriter.WriteLine("\t}"); streamWriter.WriteLine("}"); } } [/CODE] [/QUOTE]

Verification

Payakata winadi keeyak tibeda?

Search

Latest ads

Reply to thread