private string GenerateAttachedParameters() { string attached_parameters = string.Empty; foreach (Column column in table.Columns) { string variable_name = PublicEnums.GetPrefix(column.TypeName) + column.ColumnName; attached_parameters += "com" + column.TableName + ".Parameters.AddWithValue" + "(\"" + column.ColumnName + "\", " + variable_name + ");" + Environment.NewLine; } return(attached_parameters); }
private string GeneratePrivateVariables() { string variable_list = string.Empty;; foreach (Column column in table.Columns) { string variable_name = string.Empty; variable_name = GetCSDataType(column.TypeName); variable_name += " " + PublicEnums.GetPrefix(column.TypeName); variable_name += column.ColumnName; variable_name += ";"; variable_list += variable_name + Environment.NewLine; } return(variable_list); }
private string GeneratePublicProperties() { string property_list = string.Empty; string property_template = File.ReadAllText(cs_template_path + "Property.tem"); foreach (Column column in table.Columns) { string public_property = property_template; string data_type = GetCSDataType(column.TypeName); string property_name = column.ColumnName; string variable_name = PublicEnums.GetPrefix(column.TypeName) + column.ColumnName; public_property = public_property.Replace("__DataType", data_type); public_property = public_property.Replace("__PropertyName", property_name); public_property = public_property.Replace("__VariableName", variable_name); public_property += Environment.NewLine; property_list += public_property; } return(property_list); }