internal static HandleRef getCPtrAndSetReference(DBFInfo obj, object parent) {
if (obj != null)
{
obj.swigParentRef = parent;
return obj.swigCPtr;
}
else
{
return new HandleRef(null, IntPtr.Zero);
}
}
internal static HandleRef getCPtrAndDisown(DBFInfo obj, object parent) {
if (obj != null)
{
obj.swigCMemOwn = false;
obj.swigParentRef = parent;
return obj.swigCPtr;
}
else
{
return new HandleRef(null, IntPtr.Zero);
}
}
public static string CreateTableSQL(DBFInfo r, string dbName)
{
StringBuilder s = new StringBuilder();
s.Append($@"
{Environment.NewLine} USE {dbName + Environment.NewLine}
IF NOT EXISTS (SELECT * FROM SYSOBJECTS WHERE NAME='{r.TableName}' AND XTYPE='U')
CREATE TABLE [dbo].[{r.TableName}] ({Environment.NewLine}");
IEnumerable <string> fields = r.Fields.Select(field =>
{
StringBuilder fieldsBuilder = new StringBuilder();
fieldsBuilder.Append($"\t [{field.Name}] ");
string sqlType = "";
switch (field.Type)
{
case 'L': sqlType = "bit"; break;
case 'D': sqlType = "date"; break;
case 'N':
{
if (field.Digits == 0)
{
sqlType = "int";
}
else
{
sqlType = $"numeric({(int)field.Size},{(int)field.Digits})";
}
break;
}
case 'F': sqlType = "double"; break;
default: sqlType = $"nvarchar({(int)field.Size})"; break;
}
fieldsBuilder.Append($"\t { sqlType } null");
return(fieldsBuilder.ToString());
});
s.Append(string.Join("," + Environment.NewLine, fields));
s.Append(")");
return(s.ToString());
}
internal static HandleRef getCPtr(DBFInfo obj) {
return (obj == null) ? new HandleRef(null, IntPtr.Zero) : obj.swigCPtr;
}
