///// <summary>
///// Sets the inherited properties.
///// Really did not wan't this member public
///// </summary>
///// <param name="tableName"></param>
///// <param name="Columns"></param>
//public override void SetDbaseTable_and_Columns(string tableName, string[] Columns)
//{
// this.DbaseStorageTable = tableName;
// this.DbaseTableColumns = Columns;
//}
#endregion
#region SQL Interaction Methods
public static string CreatTableString(OpenDentBusiness.DatabaseType type1)
{
// Note command to create table
// //Db.NonQ(MyAllocator1_ProviderPayment.CreatTableString());
// Put here for reference not for implementation of code. CreatTableString does not check for existance of table.
string command = "";
if (type1 == OpenDentBusiness.DatabaseType.MySql)
{
command = "CREATE TABLE " + TABLENAME + " ("
+ @"AllocNum INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
AllocType TINYINT,
Guarantor BIGINT NOT NULL,
ProvNum bigint DEFAULT 0,
PayTableSource TINYINT,
PaySourceNum bigint,
AllocToTableSource TINYINT,
AllocToSourceNum int,
Amount DECIMAL (10,2) NOT NULL,
IsFullyAllocated TINYINT
)
DEFAULT CHARSET=utf8" ;
}
//else if (type1 == OpenDentBusiness.DatabaseType.Oracle)
//;// not implemented yet
return(command);
}
public static string Create_AP_temp_table_string(OpenDentBusiness.DatabaseType type1)
{
string command = "";
if (type1 == OpenDentBusiness.DatabaseType.MySql)
{
command = "CREATE TABLE " + TABLENAME + "_temp \n(\n"
+ " tempIndex INT NOT NULL AUTO_INCREMENT PRIMARY KEY, \n"
+ " Guarantor bigint NOT NULL, \n"
+ " AllocStatus TINYINT\n)\n"
+ "DEFAULT CHARSET=utf8";
}
//else if(type1 == OpenDentBusiness.DatabaseType.Oracle)
// ;// not implemented yet
return(command);
}