///<summary></summary>
public static void Update(OpenDentBusiness.Screen Cur){
if(RemotingClient.RemotingRole==RemotingRole.ClientWeb) {
Meth.GetVoid(MethodBase.GetCurrentMethod(),Cur);
return;
}
Crud.ScreenCrud.Update(Cur);
}
///<summary></summary>
public static long Insert(OpenDentBusiness.Screen Cur) {
if(RemotingClient.RemotingRole==RemotingRole.ClientWeb) {
Cur.ScreenNum=Meth.GetLong(MethodBase.GetCurrentMethod(),Cur);
return Cur.ScreenNum;
}
return Crud.ScreenCrud.Insert(Cur);
}
///<summary></summary>
public static void Delete(OpenDentBusiness.Screen Cur){
if(RemotingClient.RemotingRole==RemotingRole.ClientWeb) {
Meth.GetVoid(MethodBase.GetCurrentMethod(),Cur);
return;
}
string command = "DELETE from screen WHERE ScreenNum = '"+POut.Long(Cur.ScreenNum)+"'";
Db.NonQ(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;
}
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;
}
