private ParameterSchema ParseProcedure_param(CodeObject decl) { //procedure_param ::= // parameter ["AS"] // data_type [varying_tag] // ["=" param_init_value ] // [output_tag] ; ParameterSchema param = new ParameterSchema(); CodeObject obj = decl.FirstChild(); while (obj != null) { switch (obj.Type) { case "parameter": param.Name = obj.Text; break; case "data_type": case "param_init_value": case "output_tag": break; default: throw new NotImplementedException("Not Implemented Type: " + obj.Type); } obj = obj.NextSibling(); } return(param); }
public string GetStorePreceduresParamerDataType(ParameterSchema perameter) { switch (perameter.DataType) { case DbType.AnsiString: return("string"); case DbType.AnsiStringFixedLength: return("string"); case DbType.Binary: return("byte[]"); case DbType.Boolean: return("bool"); case DbType.Byte: return("byte"); case DbType.Currency: return("decimal"); case DbType.Date: return("DateTime"); case DbType.DateTime: return("DateTime"); case DbType.Decimal: return("decimal"); case DbType.Double: return("double"); case DbType.Guid: return("Guid"); case DbType.Int16: return("short"); case DbType.Int32: return("int"); case DbType.Int64: return("long"); case DbType.Object: return("object"); case DbType.SByte: return("sbyte"); case DbType.Single: return("float"); case DbType.String: return("string"); case DbType.StringFixedLength: return("string"); case DbType.Time: return("TimeSpan"); case DbType.UInt16: return("ushort"); case DbType.UInt32: return("uint"); case DbType.UInt64: return("ulong"); case DbType.VarNumeric: return("decimal"); case DbType.Xml: return("string"); default: { return("__UNKNOWN__" + perameter.NativeType); } } }
public object Invoke(string sessionId, WbdlSchema wbdlSchema, WbapRequest request) { Object[] parameters = new Object[methodSchema.Parameters.Count]; for (int j = 0; j < methodSchema.Parameters.Count; j++) { ParameterSchema paramSchema = methodSchema.Parameters[j]; object paramValue = null; if (string.IsNullOrEmpty(paramSchema.Value)) { parameters[j] = null; continue; } if (paramSchema.Value[0] == '#') { paramValue = request.ElementBinds.GetTable(paramSchema.Value.Remove(0, 1), wbdlSchema); } else if (paramSchema.Value[0] == '$') { paramValue = request.ElementBinds[paramSchema.Value]; } else { paramValue = paramSchema.Value; } parameters[j] = paramValue; } Object invokeRet = Umc.InvokeFunction(sessionId, null, methodSchema.MethodName, parameters); return(invokeRet); }
public string GetSqlDbTypeProce(ParameterSchema peramete) { switch (peramete.NativeType) { case "bigint": return("BigInt"); case "binary": return("Binary"); case "bit": return("Bit"); case "char": return("Char"); case "datetime": return("DateTime"); case "decimal": return("Decimal"); case "float": return("Float"); case "image": return("Image"); case "int": return("Int"); case "money": return("Money"); case "nchar": return("NChar"); case "ntext": return("NText"); case "numeric": return("Decimal"); case "nvarchar": return("NVarChar"); case "real": return("Real"); case "smalldatetime": return("SmallDateTime"); case "smallint": return("SmallInt"); case "smallmoney": return("SmallMoney"); case "sql_variant": return("Variant"); case "sysname": return("NChar"); case "text": return("Text"); case "timestamp": return("Timestamp"); case "tinyint": return("TinyInt"); case "uniqueidentifier": return("UniqueIdentifier"); case "varbinary": return("VarBinary"); case "varchar": return("VarChar"); default: return("__UNKNOWN__" + peramete.NativeType); } }
public ParameterContainer(ParameterSchema parameter) { if (parameter == null) { throw new ArgumentNullException("parameter"); } this.parameter = parameter; }
public string GetMemberVariableNameProc(ParameterSchema column) { //string propertyName = GetPropertyName(column); string propertyName = column.Name.Substring(1); string memberVariableName = "_" + propertyName.Substring(0, 1).ToLower() + propertyName.Substring(1); return(memberVariableName); }
public override void BuildNode(ITreeBuilder treeBuilder, object dataObject, ref string label, ref Gdk.Pixbuf icon, ref Gdk.Pixbuf closedIcon) { ParameterSchema parameter = dataObject as ParameterSchema; label = parameter.Name + " (" + parameter.ParameterType.ToString() + ")"; icon = Context.GetIcon("md-db-column"); //TODO: icon based on column type }
public override void BuildNode(ITreeBuilder treeBuilder, object dataObject, NodeInfo nodeInfo) { ParameterSchema parameter = dataObject as ParameterSchema; nodeInfo.Label = parameter.Name + " (" + parameter.ParameterType.ToString() + ")"; nodeInfo.Icon = Context.GetIcon("md-db-column"); //TODO: icon based on column type }
//private WbapResponse InvokeFarAction(WbapRequest wbapRequest) //{ // WbapResponse response = new WbapResponse(); // response.PageName = schema.Id; // Dictionary<string, Object> namedParams = new Dictionary<string, object>(); // foreach (KeyValuePair<string, Object> elementItem in wbapRequest.ElementBinds) // { // string retElement = null; // if (elementItem.Key.Equals("ReturnValue")) // { // retElement = elementItem.Value.ToString(); // } // else // { // namedParams.Add(elementItem.Key, GetParamVarValue(elementItem.Value.ToString())); // } // } // Umc.Umc.InvokeFunction("sid", "msid", wbapRequest.ActionId, namedParams); // return response; //} private void BuildServerRequest(WbapRequest request, ActionFlowSchema action, int Step) { request.Step = Step; request.PageName = WbdlSchema.Id; request.ActionId = action.Id; for (int i = Step; i < action.Actions.Count; i++) { ActionSchema methodSchema = action.Actions[i]; if (methodSchema.IsRunAtClient()) { break; } for (int j = 0; j < methodSchema.Parameters.Count; j++) { ParameterSchema paramSchema = methodSchema.Parameters[j]; if (string.IsNullOrEmpty(paramSchema.Value)) { continue; } string[] realParamValues = paramSchema.Value.Split(PARAM_SPLITOR); foreach (string realParamValue in realParamValues) { if (Array.IndexOf(VAR_TYPES, realParamValue[0]) == (int)VarFlagType.Element) { string key = realParamValue.Remove(0, 1); if (!request.ElementBinds.ContainsKey(key)) { request.ElementBinds.Add(key, ""); } } else if (Array.IndexOf(VAR_TYPES, realParamValue[0]) == (int)VarFlagType.Table) { request.ElementBinds.ImportTableSchema(realParamValue.Remove(0, 1), WbdlSchema); } else if (realParamValue[0].Equals('$')) { request.ElementBinds.Add(realParamValue, ""); } else if (pageCtr.ContainsDataTable(realParamValue)) { pageCtr.BuildRequestDataBodyWithTable(request.ElementBinds, realParamValue, null); } else if (methodSchema.MethodName.Equals("UpdateDataSet", StringComparison.OrdinalIgnoreCase)) { pageCtr.BuildRequestDataBodyWithDataSet(request.ElementBinds); } } } } }
public string GetParameterSize(ParameterSchema parameter) { string parameterSize = parameter.Size.ToString(); if (parameter.NativeType == "numeric" && parameter.Precision != 0) { parameterSize += "(" + parameter.Precision.ToString() + "," + parameter.Scale + ")"; } return(parameterSize); }
internal CanvasDocument(CanvasDocument other) { foreach (var kvp in other._unknownFiles) { _unknownFiles.Add(kvp.Key, new FileEntry(kvp.Value)); } foreach (var kvp in other._assetFiles) { _assetFiles.Add(kvp.Key, new FileEntry(kvp.Value)); } foreach (var kvp in other._screens) { _screens.Add(kvp.Key, kvp.Value.Clone()); } foreach (var kvp in other._components) { _components.Add(kvp.Key, kvp.Value.Clone()); } _editorStateStore = new EditorStateStore(other._editorStateStore); _templateStore = new TemplateStore(other._templateStore); _dataSources = other._dataSources.JsonClone(); _screenOrder = new List <string>(other._screenOrder); _header = other._header.JsonClone(); _properties = other._properties.JsonClone(); _parameterSchema = other._parameterSchema.JsonClone(); _publishInfo = other._publishInfo.JsonClone(); _templates = other._templates.JsonClone(); _themes = other._themes.JsonClone(); _resourcesJson = other._resourcesJson.JsonClone(); _appCheckerResultJson = other._appCheckerResultJson.JsonClone(); _pcfControls = other._pcfControls.JsonClone(); _appInsights = other._appInsights.JsonClone(); _connections = other._connections.JsonClone(); _dataSourceReferences = other._dataSourceReferences.JsonClone(); _libraryReferences = other._libraryReferences.JsonClone(); _logoFile = other._logoFile != null ? new FileEntry(other._logoFile) : null; _entropy = other._entropy.JsonClone(); _checksum = other._checksum.JsonClone(); this._idRestorer = new UniqueIdRestorer(this._entropy); _localAssetInfoJson = other._localAssetInfoJson.JsonClone(); }
public void AddParameter() { var message = new MessageSchema("A"); var parameter = new ParameterSchema("X", new RecordSchema("Y")); Assert.DoesNotThrow( () => message.AddParameter(parameter) ); Assert.Throws( typeof(AvroException), () => message.AddParameter(parameter) ); }
public static string GetCType(ParameterSchema para, SchemaExplorer.ExtendedPropertyCollection extendedProperties) { if (extendedProperties["enum"] != null) { string retEnum = GetEnumFromEp(extendedProperties["enum"].Value.ToString(), para.Name); if (retEnum != null) { return(retEnum); } } return(GetCType(para.DataType, false)); }
protected override DataParameter BuildProcedureParameter(ParameterSchema p) { if (p.DataType == DataType.Structured) return new DataParameter { Name = p.ParameterName, DataType = p.DataType, Direction = p.IsIn ? p.IsOut ? ParameterDirection.InputOutput : ParameterDirection.Input : ParameterDirection.Output, DbType = p.SchemaType }; return base.BuildProcedureParameter(p); }
private void CreateParameter(Function function, ParameterSchema parameterSchema) { Parameter parameter; if (function.Parameters.Contains(parameterSchema.Name)) { parameter = function.Parameters[parameterSchema.Name]; } else { parameter = new Parameter(parameterSchema.Name, GetSystemType(parameterSchema)); function.Parameters.Add(parameter); } //Parameter/@Parameter is safe if (string.IsNullOrEmpty(parameter.ParameterName)) { string parameterName = parameterSchema.Name; if (parameterName.StartsWith("@")) { parameterName = parameterName.Substring(1); } parameter.ParameterName = ToParameterName(parameterName); } parameter.Type = GetSystemType(parameterSchema); parameter.DbType = GetDbType(parameterSchema); switch (parameterSchema.Direction) { case System.Data.ParameterDirection.Input: parameter.Direction = ParameterDirection.In; break; case System.Data.ParameterDirection.InputOutput: parameter.Direction = ParameterDirection.InOut; break; case System.Data.ParameterDirection.Output: parameter.Direction = ParameterDirection.Out; break; } }
private static string GetDbType(ParameterSchema parameterSchema) { if (parameterSchema.Database.Provider.Name != "SqlSchemaProvider") { return(parameterSchema.NativeType); } SqlParameter param = new SqlParameter(); param.DbType = parameterSchema.DataType; return(GetSqlTypeDeclaration( parameterSchema.NativeType, parameterSchema.Size, parameterSchema.Precision, parameterSchema.Scale, false, false)); }
public ParameterSchema[] GetCommandParameters(string connectionString, CommandSchema command) { ADOX.Catalog catalog = GetCatalog(connectionString); ADOX.Procedure adoxprocedure = catalog.Procedures[command.Name]; ADODB.Command cmd = (ADODB.Command)adoxprocedure.Command; cmd.Parameters.Refresh(); ParameterSchema[] parameters = new ParameterSchema[cmd.Parameters.Count]; for (int i = 0; i < cmd.Parameters.Count; i++) { var properties = new ExtendedPropertyCollection(ConvertToExtendedProperties(cmd.Parameters[i].Properties)); bool allowDBNull = false; try { allowDBNull = cmd.Parameters[i].Properties["Nullable"] != null && (bool)cmd.Parameters[i].Properties["Nullable"].Value; if (cmd.Parameters[i].Properties["Default"] != null) { properties.Add(new ExtendedProperty(ExtendedPropertyNames.DefaultValue, cmd.Parameters[i].Properties["Default"].Value, DbType.String, PropertyStateEnum.ReadOnly)); } } catch {} parameters[i] = new ParameterSchema( command, cmd.Parameters[i].Name, GetParameterDirection(cmd.Parameters[i].Direction), GetDbType(cmd.Parameters[i].Type), cmd.Parameters[i].Type.ToString(), cmd.Parameters[i].Size, cmd.Parameters[i].Precision, cmd.Parameters[i].NumericScale, allowDBNull, properties.ToArray()); } Cleanup(); return(parameters); }
public void Create(string filePath, ParameterSchema schema, string path = null, bool overwrite = false) { var fullPath = filePath; if (!string.IsNullOrEmpty(path)) { fullPath = Path.Combine(path, Path.GetFileName(filePath)); } using FileStream fileStream = System.IO.File.Open(fullPath, !overwrite ? FileMode.Append : FileMode.Create); using StreamWriter file = new StreamWriter(fileStream); JsonSerializer serializer = new JsonSerializer() { Formatting = Formatting.Indented }; serializer.Serialize(file, schema); }
public void TestUnknownParamType() { string json = @" { ""Name"": ""i"", ""TypeName"": ""System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"", ""Attributes"": [] }"; ParameterSchema param = JsonConvert.DeserializeObject <ParameterSchema>(json); Assert.IsNotNull(param.Type); json = @" { ""Name"": ""i"", ""TypeName"": ""System.Int33, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"", ""Attributes"": [] }"; param = JsonConvert.DeserializeObject <ParameterSchema>(json); Assert.IsNull(param.Type); Assert.IsTrue(param.TypeName == "System.Int33, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"); }
public string GetMemberVariableDefaultValueProc(ParameterSchema column) { switch (column.DataType) { case DbType.Guid: { return("Guid.Empty"); } case DbType.AnsiString: case DbType.AnsiStringFixedLength: case DbType.String: case DbType.StringFixedLength: { return("String.Empty"); } case DbType.Boolean: return("false"); case DbType.Int32: return("0"); case DbType.DateTime: return("new DateTime(1900,1,1)"); case DbType.Single: return("0"); case DbType.Double: return("0"); default: { return(""); } } }
public ParameterSchema[] GetCommandParameters(string connectionString, CommandSchema command) { var parameters = new List <ParameterSchema>(); var extendedProperties = new List <ExtendedProperty>(); string sql = string.Format("SELECT PARAM_ORDER, PARAM_NAME, PARAM_TYPE, IS_PARAM_OUT, DEFAULT_VALUE FROM sp_stored_procedures() WHERE PROC_NAME = '{0}'", command.Name); using (VistaDBConnection connection = GetConnection(connectionString)) using (var adapter = new VistaDBDataAdapter(sql, connection)) using (var table = new DataTable()) { adapter.Fill(table); foreach (DataRow row in table.Rows) { string name = row["PARAM_NAME"].ToString(); var vistaType = (VistaDBType)(row["PARAM_TYPE"] ?? VistaDBType.Unknown); var isOut = (bool)(row["IS_PARAM_OUT"] ?? false); string defaultValue = row["DEFAULT_VALUE"].ToString(); extendedProperties.Clear(); extendedProperties.Add(ExtendedProperty.Readonly(ExtendedPropertyNames.Description, string.Empty)); extendedProperties.Add(ExtendedProperty.Readonly(ExtendedPropertyNames.DefaultValue, defaultValue)); var parameter = new ParameterSchema(command, name, isOut ? ParameterDirection.InputOutput : ParameterDirection.Input, GetDbType(vistaType.ToString()), vistaType.ToString(), 0, 0, 0, true, extendedProperties.ToArray()); parameters.Add(parameter); } } return(parameters.ToArray()); }
public string GetMemberVariableDeclarationStatementProc(ParameterSchema param) { return(GetMemberVariableDeclarationStatementProc("private", param)); }
public override ParameterSchemaCollection GetProcedureParameters (ProcedureSchema procedure) { ParameterSchemaCollection parameters = new ParameterSchemaCollection (); using (IPooledDbConnection conn = connectionPool.Request ()) { using (IDbCommand command = conn.CreateCommand (string.Concat ( "SELECT param_list FROM mysql.proc where name = '", procedure.Name, "'"))) { try { if (GetMainVersion (command) >= 5) { using (IDataReader r = command.ExecuteReader()) { while (r.Read ()) { if (r.IsDBNull (0)) continue; string[] field = Encoding.ASCII.GetString ( (byte[])r.GetValue (0)).Split ( new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries); foreach (string chunk in field) { ParameterSchema param = new ParameterSchema (this); param.Definition = chunk; string[] tmp = chunk.TrimStart (new char[] { ' ' }).Split (new char[] { ' ' }); int nameIndex = 0; if (String.Compare (tmp[0], "OUT", true) == 0) { nameIndex = 1; param.ParameterType = ParameterType.Out; } else if (String.Compare (tmp[0], "INOUT", true) == 0) { nameIndex = 1; param.ParameterType = ParameterType.InOut; } else { param.ParameterType = ParameterType.In; } param.Name = tmp[nameIndex]; param.OwnerName = procedure.Name; param.DataTypeName = tmp[nameIndex + 1]; parameters.Add (param); } } r.Close (); } } } catch (Exception e) { QueryService.RaiseException (e); } finally { conn.Release (); } } } return parameters; }
private void CreateParameter(Function function, ParameterSchema parameterSchema) { Parameter parameter; if (function.Parameters.Contains(parameterSchema.Name)) { parameter = function.Parameters[parameterSchema.Name]; } else { parameter = new Parameter(parameterSchema.Name, GetSystemType(parameterSchema)); function.Parameters.Add(parameter); } //Parameter/@Parameter is safe if (string.IsNullOrEmpty(parameter.ParameterName)) { string parameterName = parameterSchema.Name; if (parameterName.StartsWith("@")) parameterName = parameterName.Substring(1); parameter.ParameterName = ToParameterName(parameterName); } parameter.Type = GetSystemType(parameterSchema); parameter.DbType = GetDbType(parameterSchema); switch (parameterSchema.Direction) { case System.Data.ParameterDirection.Input: parameter.Direction = ParameterDirection.In; break; case System.Data.ParameterDirection.InputOutput: parameter.Direction = ParameterDirection.InOut; break; case System.Data.ParameterDirection.Output: parameter.Direction = ParameterDirection.Out; break; } }
public override ParameterSchemaCollection GetProcedureParameters(ProcedureSchema procedure) { ParameterSchemaCollection parameters = new ParameterSchemaCollection(); using (IPooledDbConnection conn = connectionPool.Request()) { using (IDbCommand command = conn.CreateCommand(string.Concat( "SELECT param_list FROM mysql.proc where name = '", procedure.Name, "'"))) { try { if (GetMainVersion(command) >= 5) { using (IDataReader r = command.ExecuteReader()) { while (r.Read()) { if (r.IsDBNull(0)) { continue; } string[] field = Encoding.ASCII.GetString( (byte[])r.GetValue(0)).Split( new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries); foreach (string chunk in field) { ParameterSchema param = new ParameterSchema(this); param.Definition = chunk; string[] tmp = chunk.TrimStart(new char[] { ' ' }).Split(new char[] { ' ' }); int nameIndex = 0; if (String.Compare(tmp[0], "OUT", true) == 0) { nameIndex = 1; param.ParameterType = ParameterType.Out; } else if (String.Compare(tmp[0], "INOUT", true) == 0) { nameIndex = 1; param.ParameterType = ParameterType.InOut; } else { param.ParameterType = ParameterType.In; } param.Name = tmp[nameIndex]; param.OwnerName = procedure.Name; param.DataTypeName = tmp[nameIndex + 1]; parameters.Add(param); } } r.Close(); } } } catch (Exception e) { QueryService.RaiseException(e); } finally { conn.Release(); } } } return(parameters); }
public string GetStorePreceduresParamerName(ParameterSchema perameter) { return("obj" + perameter.Name.Replace('@', '.')); }
/// <summary> /// Returns the C# variable type based on the given parameter. /// </summary> /// <param name="column"></param> /// <returns></returns> public string GetVBVariableType(ParameterSchema column) { return(GetVBVariableType(column as DataObjectBase)); }
public static int GetParamSize(ParameterSchema param) { return(GetParamSize(param.NativeType, param.Size)); }
public static string GetUIControlConversionType(ParameterSchema parameter, string value) { switch (parameter.DataType) { case DbType.AnsiString: return string.Format("Convert.ToString({0})",value); case DbType.AnsiStringFixedLength: return string.Format("Convert.ToString({0})",value); case DbType.Binary: return string.Format("Convert.ToString({0})",value); case DbType.Boolean: return string.Format("Convert.ToBoolean({0})",value); case DbType.Byte: return string.Format("Convert.ToBoolean({0})",value); case DbType.Currency: return string.Format("Convert.ToString({0})",value); case DbType.Date: return string.Format("Convert.ToDateTime({0})",value); case DbType.DateTime: return string.Format("Convert.ToDateTime({0})",value); case DbType.Decimal: return string.Format("Convert.ToString({0})",value); case DbType.Double: return string.Format("Convert.ToString({0})",value); case DbType.Guid: return string.Format("Convert.ToString({0})",value); case DbType.Int16: return string.Format("Convert.ToString({0})",value); case DbType.Int32: return string.Format("Convert.ToString({0})",value); case DbType.Int64: return string.Format("Convert.ToString({0})",value); case DbType.Object: return string.Format("Convert.ToString({0})",value); case DbType.SByte: return string.Format("Convert.ToBoolean({0})",value); case DbType.Single: return string.Format("Convert.ToString({0})",value); case DbType.String: return string.Format("Convert.ToString({0})",value); case DbType.StringFixedLength: return string.Format("Convert.ToString({0})",value); //case DbType.Time: return canBeNullable ? "TimeSpan?" : "TimeSpan"; case DbType.UInt16: return string.Format("Convert.ToString({0})",value); case DbType.UInt32: return string.Format("Convert.ToString({0})",value); case DbType.UInt64: return string.Format("Convert.ToString({0})",value); case DbType.VarNumeric: return string.Format("Convert.ToString({0})",value); default: { return string.Format("txt{0}.Text;",GetPropertyName(parameter)); } } }
public static string GetUICheckBoxSetupDeclaration(ParameterSchema parameter, System.Drawing.Point point, System.Drawing.Size size, int tabIndex) { System.Text.StringBuilder builder = new System.Text.StringBuilder(); builder.Append("\t\t// \r\n"); builder.Append(string.Format("\t\t// chk{0}\r\n",GetPropertyName(parameter))); builder.Append("\t\t// \r\n"); builder.Append(string.Format("\t\t this.chk{0}.AutoSize = true;\r\n",GetPropertyName(parameter))); builder.Append(string.Format("\t\t this.chk{0}.Checked = true;\r\n",GetPropertyName(parameter))); builder.Append(string.Format("\t\t this.chk{0}.CheckState = System.Windows.Forms.CheckState.Checked;\r\n",GetPropertyName(parameter))); builder.Append(string.Format("\t\t this.chk{0}.Location = new System.Drawing.Point({1}, {2});\r\n",GetPropertyName(parameter),point.X,point.Y)); builder.Append(string.Format("\t\t this.chk{0}.Name = \"chk{0}\";\r\n",GetPropertyName(parameter))); builder.Append(string.Format("\t\t this.chk{0}.Size = new System.Drawing.Size({1}, {2});\r\n",GetPropertyName(parameter),size.Width,size.Height)); builder.Append(string.Format("\t\t this.chk{0}.TabIndex = {1}\r\n;",GetPropertyName(parameter),tabIndex)); return builder.ToString(); }
public static string GetPublicMemberVariableName(ParameterSchema parameter) { string propertyName = GetPropertyName(parameter); if (propertyName.StartsWith("@")) propertyName = propertyName.Substring(1); string memberVariableName = GetCamelCaseName(propertyName); return memberVariableName; }
public static string GetPropertyName(ParameterSchema parameter) { string propertyName = parameter.Name.Replace(" ", ""); if (propertyName.StartsWith("@")) propertyName = propertyName.Substring(1); return StringUtil.ToPascalCase(propertyName); }
public static string GetOriginalPropertyName(ParameterSchema parameter) { string propertyName = parameter.Name; if (propertyName.StartsWith("@")) propertyName = propertyName.Substring(1); return propertyName; }
public static string GetMemberVariableDeclarationStatement(string protectionLevel, ParameterSchema parameter, bool canBeNullable) { string statement = protectionLevel + " "; statement += GetCSharpVariableType(parameter.DataType, canBeNullable) + " " + GetMemberVariableName(parameter); string defaultValue = GetMemberVariableDefaultValue(parameter.DataType, canBeNullable, parameter.Name == "@TransactionType"); if (defaultValue != "") { statement += " = " + defaultValue; } statement += ";"; return statement; }
public static string GetMemberVariableDeclarationStatement(ParameterSchema parameter, bool canBeNullable) { return GetMemberVariableDeclarationStatement("private", parameter, canBeNullable); }
public static string GetUIControlName(ParameterSchema parameter, bool withInput) { switch (parameter.DataType) { case DbType.AnsiString: return withInput ? string.Format("txt{0}.Text",GetPropertyName(parameter)) : string.Format("txt{0}",GetPropertyName(parameter)); case DbType.AnsiStringFixedLength: return withInput ? string.Format("txt{0}.Text",GetPropertyName(parameter)) : string.Format("txt{0}",GetPropertyName(parameter)); case DbType.Binary: return withInput ? string.Format("txt{0}.Text",GetPropertyName(parameter)) : string.Format("txt{0}",GetPropertyName(parameter)); case DbType.Boolean: return withInput ? string.Format("chk{0}.Checked",GetPropertyName(parameter)) : string.Format("chk{0}",GetPropertyName(parameter)); case DbType.Byte: return withInput ? string.Format("chk{0}.Checked",GetPropertyName(parameter)) : string.Format("chk{0}",GetPropertyName(parameter)); case DbType.Currency: return withInput ? string.Format("mtb{0}.Text",GetPropertyName(parameter)) : string.Format("mtb{0}",GetPropertyName(parameter)); case DbType.Date: return withInput ? string.Format("dtp{0}.Value",GetPropertyName(parameter)) : string.Format("dtp{0}",GetPropertyName(parameter)); case DbType.DateTime: return withInput ? string.Format("dtp{0}.Value",GetPropertyName(parameter)) : string.Format("dtp{0}",GetPropertyName(parameter)); case DbType.Decimal: return withInput ? string.Format("mtb{0}.Text",GetPropertyName(parameter)) : string.Format("mtb{0}",GetPropertyName(parameter)); case DbType.Double: return withInput ? string.Format("mtb{0}.Text",GetPropertyName(parameter)) : string.Format("mtb{0}",GetPropertyName(parameter)); case DbType.Guid: return withInput ? string.Format("txt{0}.Text",GetPropertyName(parameter)) : string.Format("txt{0}",GetPropertyName(parameter)); case DbType.Int16: return withInput ? string.Format("mtb{0}.Text",GetPropertyName(parameter)) : string.Format("mtb{0}",GetPropertyName(parameter)); case DbType.Int32: return withInput ? string.Format("mtb{0}.Text",GetPropertyName(parameter)) : string.Format("mtb{0}",GetPropertyName(parameter)); case DbType.Int64: return withInput ? string.Format("mtb{0}.Text",GetPropertyName(parameter)) : string.Format("mtb{0}",GetPropertyName(parameter)); case DbType.Object: return withInput ? string.Format("txt{0}.Text",GetPropertyName(parameter)) : string.Format("txt{0}",GetPropertyName(parameter)); case DbType.SByte: return withInput ? string.Format("chk{0}.Checked",GetPropertyName(parameter)) : string.Format("chk{0}",GetPropertyName(parameter)); case DbType.Single: return withInput ? string.Format("mtb{0}.Text",GetPropertyName(parameter)) : string.Format("mtb{0}",GetPropertyName(parameter)); case DbType.String: return withInput ? string.Format("txt{0}.Text",GetPropertyName(parameter)) : string.Format("txt{0}",GetPropertyName(parameter)); case DbType.StringFixedLength: return withInput ? string.Format("txt{0}.Text",GetPropertyName(parameter)) : string.Format("txt{0}",GetPropertyName(parameter)); //case DbType.Time: return canBeNullable ? "TimeSpan?" : "TimeSpan"; case DbType.UInt16: return withInput ? string.Format("mtb{0}.Text",GetPropertyName(parameter)) : string.Format("mtb{0}",GetPropertyName(parameter)); case DbType.UInt32: return withInput ? string.Format("mtb{0}.Text",GetPropertyName(parameter)) : string.Format("mtb{0}",GetPropertyName(parameter)); case DbType.UInt64: return withInput ? string.Format("mtb{0}.Text",GetPropertyName(parameter)) : string.Format("mtb{0}",GetPropertyName(parameter)); case DbType.VarNumeric: return withInput ? string.Format("mtb{0}.Text",GetPropertyName(parameter)) : string.Format("mtb{0}",GetPropertyName(parameter)); default: { return string.Format("txt{0}",GetPropertyName(parameter)); } } }
private ParameterSchemaCollection GetParams (string names, string directions, string types, IPooledDbConnection conn) { ParameterSchemaCollection pars = new ParameterSchemaCollection (); if (names == string.Empty || directions == string.Empty || types == String.Empty) return pars; // Array always start with { and end with } if (!names.StartsWith ("{") || !names.EndsWith ("}")) throw new ArgumentOutOfRangeException ("names"); string[] namesArray = names.Substring(1, names.Length -2).Split (','); string[] directionsArray = directions.Substring(1, directions.Length -2).Split (','); string[] typesArray = types.Substring(1, types.Length -2).Split (','); for (int idx = 0; idx < namesArray.Length; idx++) { ParameterSchema ps = new ParameterSchema (this); // Name if (namesArray[idx] != "\"\"") ps.Name = namesArray[idx]; // Direction string d = directionsArray[idx]; if (d == "i") ps.ParameterType = ParameterType.In; else if (d == "o") ps.ParameterType = ParameterType.Out; else ps.ParameterType = ParameterType.InOut; // Type using (IDbCommand cmd = conn.CreateCommand (string.Format ( "select format_type(oid, null) from pg_type WHERE oid = '{0}'::oid", typesArray[idx]))) { using (IDataReader r = cmd.ExecuteReader()) if (r.Read ()) ps.DataTypeName = r.GetString (0); } pars.Add (ps); } return pars;
public static string GetUIControlSetupStatement(ParameterSchema parameter, System.Drawing.Point point, System.Drawing.Size size, int tabIndex) { switch (parameter.DataType) { case DbType.AnsiString: return GetUITextBoxSetupDeclaration(parameter, point, size, tabIndex); case DbType.AnsiStringFixedLength: return GetUITextBoxSetupDeclaration(parameter, point, size, tabIndex); case DbType.Binary: return GetUIMaskedTextBoxSetupDeclaration(parameter, point, size, tabIndex, "#","0"); case DbType.Boolean: return GetUICheckBoxSetupDeclaration(parameter, point, size, tabIndex); case DbType.Byte: return GetUICheckBoxSetupDeclaration(parameter, point, size, tabIndex); case DbType.Currency: return GetUIMaskedTextBoxSetupDeclaration(parameter, point, size, tabIndex, "#######0.00","0000000000"); case DbType.Date: return GetUIDateTimePickerSetupDeclaration(parameter, point, size, tabIndex); case DbType.DateTime: return GetUIDateTimePickerSetupDeclaration(parameter, point, size, tabIndex); case DbType.Decimal: return GetUIMaskedTextBoxSetupDeclaration(parameter, point, size, tabIndex, "#######0.00","0000000000"); case DbType.Double: return GetUIMaskedTextBoxSetupDeclaration(parameter, point, size, tabIndex, "#######0.00","0000000000"); case DbType.Guid: return GetUITextBoxSetupDeclaration(parameter, point, size, tabIndex); case DbType.Int16: return GetUIMaskedTextBoxSetupDeclaration(parameter, point, size, tabIndex, "#######0","0000000)"); case DbType.Int32: return GetUIMaskedTextBoxSetupDeclaration(parameter, point, size, tabIndex, "#######0","0000000)"); case DbType.Int64: return GetUIMaskedTextBoxSetupDeclaration(parameter, point, size, tabIndex, "#######0","0000000)"); case DbType.Object: return GetUITextBoxSetupDeclaration(parameter, point, size, tabIndex); case DbType.SByte: return GetUICheckBoxSetupDeclaration(parameter, point, size, tabIndex); case DbType.Single: return GetUIMaskedTextBoxSetupDeclaration(parameter, point, size, tabIndex, "#######0","0000000)"); case DbType.String: return GetUITextBoxSetupDeclaration(parameter, point, size, tabIndex); case DbType.StringFixedLength: return GetUITextBoxSetupDeclaration(parameter, point, size, tabIndex); //case DbType.Time: return canBeNullable ? "TimeSpan?" : "TimeSpan"; case DbType.UInt16: return GetUIMaskedTextBoxSetupDeclaration(parameter, point, size, tabIndex, "#######0","0000000)"); case DbType.UInt32: return GetUIMaskedTextBoxSetupDeclaration(parameter, point, size, tabIndex, "#######0","0000000)"); case DbType.UInt64: return GetUIMaskedTextBoxSetupDeclaration(parameter, point, size, tabIndex, "#######0","0000000)"); case DbType.VarNumeric: return GetUIMaskedTextBoxSetupDeclaration(parameter, point, size, tabIndex, "#######0","0000000)"); default: { return string.Format("this.txt{0} = new System.Windows.Forms.TextBox();",GetPropertyName(parameter)); } } }
public string GetStorePreceduresParamer(ParameterSchema perameter) { return(perameter.Name); }
public static string GetUIControlValueStatementOUT(ParameterSchema parameter) { switch (parameter.DataType) { case DbType.AnsiString: return string.Format("txt{0}.Text",GetPropertyName(parameter)); case DbType.AnsiStringFixedLength: return string.Format("txt{0}.Text",GetPropertyName(parameter)); case DbType.Binary: return string.Format("new byte[]{Convert.ToByte(txt{0}.Text)}",GetPropertyName(parameter)); case DbType.Boolean: return string.Format("chk{0}.Checked",GetPropertyName(parameter)); case DbType.Byte: return string.Format("Convert.ToByte(chk{0}.Checked)",GetPropertyName(parameter)); case DbType.Currency: return string.Format("Convert.ToDecimal(mtb{0}.Text)",GetPropertyName(parameter)); case DbType.Date: return string.Format("dtp{0}.Value",GetPropertyName(parameter)); case DbType.DateTime: return string.Format("dtp{0}.Value",GetPropertyName(parameter)); case DbType.Decimal: return string.Format("Convert.ToDecimal(mtb{0}.Text)",GetPropertyName(parameter)); case DbType.Double: return string.Format("Convert.ToDouble(mtb{0}.Text)",GetPropertyName(parameter)); case DbType.Guid: return string.Format("new Guid(txt{0}.Text)",GetPropertyName(parameter)); case DbType.Int16: return string.Format("Convert.ToInt16(mtb{0}.Text)",GetPropertyName(parameter)); case DbType.Int32: return string.Format("Convert.ToInt32(mtb{0}.Text)",GetPropertyName(parameter)); case DbType.Int64: return string.Format("Convert.ToInt64(mtb{0}.Text)",GetPropertyName(parameter)); case DbType.Object: return string.Format("txt{0}.Text",GetPropertyName(parameter)); case DbType.SByte: return string.Format("Convert.ToSByte(chk{0}.Checked)",GetPropertyName(parameter)); case DbType.Single: return string.Format("Convert.ToSingle(mtb{0}.Text)",GetPropertyName(parameter)); case DbType.String: return string.Format("txt{0}.Text",GetPropertyName(parameter)); case DbType.StringFixedLength: return string.Format("txt{0}.Text",GetPropertyName(parameter)); //case DbType.Time: return canBeNullable ? "TimeSpan?" : "TimeSpan"; case DbType.UInt16: return string.Format("Convert.ToUInt16(mtb{0}.Text)",GetPropertyName(parameter)); case DbType.UInt32: return string.Format("Convert.ToUInt32(mtb{0}.Text)",GetPropertyName(parameter)); case DbType.UInt64: return string.Format("Convert.ToUInt64(mtb{0}.Text)",GetPropertyName(parameter)); case DbType.VarNumeric: return string.Format("Convert.ToDecimal(mtb{0}.Text)",GetPropertyName(parameter)); default: { return string.Format("txt{0}.Text;",GetPropertyName(parameter)); } } }
public string GetParameterSize(ParameterSchema parameter) { string parameterSize = parameter.Size.ToString(); if (parameter.NativeType == "numeric" && parameter.Precision != 0) { parameterSize += "(" + parameter.Precision.ToString() + "," + parameter.Scale + ")"; } return parameterSize; }
public static string GetUIDateTimePickerSetupDeclaration(ParameterSchema parameter, System.Drawing.Point point, System.Drawing.Size size, int tabIndex) { System.Text.StringBuilder builder = new System.Text.StringBuilder(); builder.Append("\t\t// \r\n"); builder.Append(string.Format("\t\t// dtp{0}\r\n",GetPropertyName(parameter))); builder.Append("\t\t// \r\n"); builder.Append(string.Format("\t\t this.dtp{0}.CustomFormat = \"MM/dd/yyyy hh:mm tt\";\r\n",GetPropertyName(parameter))); builder.Append(string.Format("\t\t this.dtp{0}.Checked = true;\r\n",GetPropertyName(parameter))); builder.Append(string.Format("\t\t this.dtp{0}.Format = System.Windows.Forms.DateTimePickerFormat.Custom;\r\n",GetPropertyName(parameter))); builder.Append(string.Format("\t\t this.dtp{0}.Location = new System.Drawing.Point({1}, {2});\r\n",GetPropertyName(parameter),point.X,point.Y)); builder.Append(string.Format("\t\t this.dtp{0}.Name = \"dtp{0}\";\r\n",GetPropertyName(parameter))); builder.Append(string.Format("\t\t this.dtp{0}.Size = new System.Drawing.Size({1}, {2});\r\n",GetPropertyName(parameter),size.Width,size.Height)); builder.Append(string.Format("\t\t this.dtp{0}.TabIndex = {1};\r\n",GetPropertyName(parameter),tabIndex)); //builder.Append(string.Format("\t\t this.dtp{0}.ShowUpDown = true;\r\n",GetPropertyName(parameter))); return builder.ToString(); }
private static string GetDbType(ParameterSchema parameterSchema) { if (parameterSchema.Database.Provider.Name != "SqlSchemaProvider") return parameterSchema.NativeType; SqlParameter param = new SqlParameter(); param.DbType = parameterSchema.DataType; return GetSqlTypeDeclaration( parameterSchema.NativeType, parameterSchema.Size, parameterSchema.Precision, parameterSchema.Scale, false, false); }
public static string GetUIMaskedTextBoxSetupDeclaration(ParameterSchema parameter, System.Drawing.Point point, System.Drawing.Size size, int tabIndex, string mask, string text) { System.Text.StringBuilder builder = new System.Text.StringBuilder(); builder.Append("// \r\n"); builder.Append(string.Format("\t\t// mtb{0}\r\n",GetPropertyName(parameter))); builder.Append("\t\t// \r\n"); builder.Append(string.Format("\t\t this.mtb{0}.AllowPromptAsInput = true;\r\n",GetPropertyName(parameter))); builder.Append(string.Format("\t\t this.mtb{0}.Enabled = true;\r\n",GetPropertyName(parameter))); builder.Append(string.Format("\t\t this.mtb{0}.HidePromptOnLeave = true;\r\n",GetPropertyName(parameter))); builder.Append(string.Format("\t\t this.mtb{0}.Location = new System.Drawing.Point({1}, {2});\r\n",GetPropertyName(parameter),point.X,point.Y)); builder.Append(string.Format("\t\t this.mtb{0}.Mask = \"{1}\";\r\n",GetPropertyName(parameter),mask)); builder.Append(string.Format("\t\t this.mtb{0}.Name = \"mtb{0}\";\r\n",GetPropertyName(parameter))); builder.Append(string.Format("\t\t this.mtb{0}.Size = new System.Drawing.Size({1}, {2});\r\n",GetPropertyName(parameter),size.Width,size.Height)); builder.Append(string.Format("\t\t this.mtb{0}.TabIndex = {1};\r\n",GetPropertyName(parameter),tabIndex)); builder.Append(string.Format("\t\t this.mtb{0}.Text = \"{1}\";\r\n",GetPropertyName(parameter),text)); return builder.ToString(); }
public string GetMemberVariableDeclarationStatementProc(string protectionLevel, ParameterSchema param) { string statement = protectionLevel + " "; statement += GetCSharpVariableTypeProc(param) + " " + GetMemberVariableNameProc(param); string defaultValue = GetMemberVariableDefaultValueProc(param); if (defaultValue != "") { statement += " = " + defaultValue; } statement += ";"; return(statement); }
public static string GetUITextBoxSetupDeclaration(ParameterSchema parameter, System.Drawing.Point point, System.Drawing.Size size, int tabIndex) { System.Text.StringBuilder builder = new System.Text.StringBuilder(); builder.Append("\t\t// \r\n"); builder.Append(string.Format("\t\t// txt{0}\r\n",GetPropertyName(parameter))); builder.Append("\t\t// \r\n"); builder.Append(string.Format("\t\t this.txt{0}.Enabled = true;\r\n",GetPropertyName(parameter))); builder.Append(string.Format("\t\t this.txt{0}.Location = new System.Drawing.Point({1}, {2});\r\n",GetPropertyName(parameter),point.X,point.Y)); builder.Append(string.Format("\t\t this.txt{0}.Name = \"txt{0}\";\r\n",GetPropertyName(parameter))); builder.Append(string.Format("\t\t this.txt{0}.Size = new System.Drawing.Size({1}, {2});\r\n",GetPropertyName(parameter),size.Width,size.Height)); builder.Append(string.Format("\t\t this.txt{0}.TabIndex = {1};\r\n",GetPropertyName(parameter),tabIndex)); return builder.ToString(); }
public string GetCSharpVariableTypeProc(ParameterSchema column) { if (column.Name.EndsWith("TypeCode")) { return(column.Name); } switch (column.DataType) { case DbType.AnsiString: return("string"); case DbType.AnsiStringFixedLength: return("string"); case DbType.Binary: return("byte[]"); case DbType.Boolean: return("bool"); case DbType.Byte: return("byte"); case DbType.Currency: return("decimal"); case DbType.Date: return("DateTime"); case DbType.DateTime: return("DateTime"); case DbType.Decimal: return("decimal"); case DbType.Double: return("double"); case DbType.Guid: return("Guid"); case DbType.Int16: return("short"); case DbType.Int32: return("int"); case DbType.Int64: return("long"); case DbType.Object: return("object"); case DbType.SByte: return("sbyte"); case DbType.Single: return("float"); case DbType.String: return("string"); case DbType.StringFixedLength: return("string"); case DbType.Time: return("TimeSpan"); case DbType.UInt16: return("ushort"); case DbType.UInt32: return("uint"); case DbType.UInt64: return("ulong"); case DbType.VarNumeric: return("decimal"); case DbType.Xml: return("string"); default: { return("__UNKNOWN__" + column.NativeType); } } }
/// <summary> /// Get the cleaned, camelcased name of a parameter /// </summary> /// <param name="par">Command Parameter</param> /// <returns>the cleaned, camelcased name </returns> public string GetCleanParName(ParameterSchema par) { return GetCleanParName(par.Name); }
private void CreateFunction(CommandSchema commandSchema) { Function function; string key = commandSchema.FullName; bool isNew = !Database.Functions.Contains(key); if (isNew) { function = new Function(key); Database.Functions.Add(function); } else { function = Database.Functions[key]; } //Function/@Method is safe to update if (string.IsNullOrEmpty(function.Method)) { string methodName = ToLegalName(commandSchema.Name); if (ClassNames.Contains(methodName)) { methodName += "Procedure"; } function.Method = MakeUnique(FunctionNames, methodName); } function.IsComposable = IsFunction(commandSchema); ParameterSchema returnParameter = null; function.Parameters.Clear(); foreach (ParameterSchema p in commandSchema.Parameters) { if (p.Direction == System.Data.ParameterDirection.ReturnValue) { returnParameter = p; } else { CreateParameter(function, p); } } try { for (int i = 0; i < commandSchema.CommandResults.Count; i++) { var r = commandSchema.CommandResults[i]; string defaultName = function.Method + "Result"; if (commandSchema.CommandResults.Count > 1) { defaultName += (i + 1).ToString(); } CreateResult(function, r, defaultName, i); } } catch (Exception ex) { Debug.WriteLine("Error reading result schema: " + ex.Message); } function.HasMultipleResults = function.Types.Count > 1; function.IsProcessed = true; if (function.Types.Count != 0) { return; } if (function.Return == null) { function.Return = new Return("System.Int32"); } if (commandSchema.ReturnValueParameter != null) { function.Return.Type = GetSystemType(commandSchema.ReturnValueParameter); function.Return.DbType = GetDbType(commandSchema.ReturnValueParameter); } else if (returnParameter != null) { function.Return.Type = GetSystemType(returnParameter); function.Return.DbType = GetDbType(returnParameter); } else { function.Return.Type = "System.Int32"; function.Return.DbType = "int"; } }
/// <summary> /// Adds a ParameterSchema /// </summary> /// <param name="p"></param> public void AddParameter(ParameterSchema p) { parameters[p.Name] = p; }
public static string GetUIControlInstanceStatement(ParameterSchema parameter) { switch (parameter.DataType) { case DbType.AnsiString: return string.Format("this.txt{0} = new System.Windows.Forms.TextBox();",GetPropertyName(parameter)); case DbType.AnsiStringFixedLength: return string.Format("this.txt{0} = new System.Windows.Forms.TextBox();",GetPropertyName(parameter)); case DbType.Binary: return string.Format("this.mtb{0} = new System.Windows.Forms.TextBox();",GetPropertyName(parameter)); case DbType.Boolean: return string.Format("this.chk{0} = new System.Windows.Forms.CheckBox();",GetPropertyName(parameter)); case DbType.Byte: return string.Format("this.chk{0} = new System.Windows.Forms.CheckBox();",GetPropertyName(parameter)); case DbType.Currency: return string.Format("this.mtb{0} = new System.Windows.Forms.MaskedTextBox();",GetPropertyName(parameter)); case DbType.Date: return string.Format("this.dtp{0} = new System.Windows.Forms.DateTimePicker();",GetPropertyName(parameter)); case DbType.DateTime: return string.Format("this.dtp{0} = new System.Windows.Forms.DateTimePicker();",GetPropertyName(parameter)); case DbType.Decimal: return string.Format("this.mtb{0} = new System.Windows.Forms.MaskedTextBox();",GetPropertyName(parameter)); case DbType.Double: return string.Format("this.mtb{0} = new System.Windows.Forms.MaskedTextBox();",GetPropertyName(parameter)); case DbType.Guid: return string.Format("this.txt{0} = new System.Windows.Forms.TextBox();",GetPropertyName(parameter)); case DbType.Int16: return string.Format("this.mtb{0} = new System.Windows.Forms.MaskedTextBox();",GetPropertyName(parameter)); case DbType.Int32: return string.Format("this.mtb{0} = new System.Windows.Forms.MaskedTextBox();",GetPropertyName(parameter)); case DbType.Int64: return string.Format("this.mtb{0} = new System.Windows.Forms.MaskedTextBox();",GetPropertyName(parameter)); case DbType.Object: return string.Format("this.txt{0} = new System.Windows.Forms.TextBox();",GetPropertyName(parameter)); case DbType.SByte: return string.Format("this.chk{0} = new System.Windows.Forms.CheckBox();",GetPropertyName(parameter)); case DbType.Single: return string.Format("this.mtb{0} = new System.Windows.Forms.MaskedTextBox();",GetPropertyName(parameter)); case DbType.String: return string.Format("this.txt{0} = new System.Windows.Forms.TextBox();",GetPropertyName(parameter)); case DbType.StringFixedLength: return string.Format("this.txt{0} = new System.Windows.Forms.TextBox();",GetPropertyName(parameter)); //case DbType.Time: return canBeNullable ? "TimeSpan?" : "TimeSpan"; case DbType.UInt16: return string.Format("this.mtb{0} = new System.Windows.Forms.MaskedTextBox();",GetPropertyName(parameter)); case DbType.UInt32: return string.Format("this.mtb{0} = new System.Windows.Forms.MaskedTextBox();",GetPropertyName(parameter)); case DbType.UInt64: return string.Format("this.mtb{0} = new System.Windows.Forms.MaskedTextBox();",GetPropertyName(parameter)); case DbType.VarNumeric: return string.Format("this.mtb{0} = new System.Windows.Forms.MaskedTextBox();",GetPropertyName(parameter)); default: { return string.Format("this.txt{0} = new System.Windows.Forms.TextBox();",GetPropertyName(parameter)); } } }
public static string BuildXmlParameterComment(ParameterSchema parameter) { System.Text.StringBuilder builder = new System.Text.StringBuilder(); builder.Append("/// <summary>\r\n"); builder.Append("\t\t/// <param name=\""); builder.Append(parameter.Name); builder.Append("\">"); builder.Append("Type:"); builder.Append(parameter.DataType); builder.Append("\r\n\t\t/// </param>\r\n"); builder.Append("\t\t/// <remarks>"); builder.Append("\r\n\t\t/// " + parameter.Description); builder.Append("\r\n\t\t/// </remarks>\r\n"); builder.Append("\t\t/// </summary>"); return builder.ToString(); }