/// <summary>
/// Inserir novo(a) Apresentacao
/// </summary>
/// <returns></returns>
public override bool Inserir()
{
try
{
StringBuilder sql = new StringBuilder();
sql.Append("INSERT INTO tApresentacao(ID) ");
sql.Append("VALUES (@001); SELECT SCOPE_IDENTITY();");
sql.Replace("@ID", this.Control.ID.ToString());
sql.Replace("@001", this.ID.ValorBD);
this.Control.ID = Convert.ToInt32(bd.ConsultaValor(sql.ToString()));
bd.Fechar();
return(this.Control.ID > 0);
}
catch (Exception ex)
{
throw ex;
}
finally
{
bd.Fechar();
}
}
/// <summary>
/// Preenche todos os atributos de Empresa
/// </summary>
/// <param name="id">Informe o ID</param>
/// <returns></returns>
public override void Ler(int id)
{
try
{
string sql = "SELECT * FROM tEmpresa WHERE ID = " + id;
bd.Consulta(sql);
if (bd.Consulta().Read())
{
this.Control.ID = id;
this.ID.ValorBD = bd.LerInt("ID").ToString();
this.EmpresaID.ValorBD = bd.LerInt("EmpresaID").ToString();
this.FormaPagamentoID.ValorBD = bd.LerInt("FormaPagamentoID").ToString();
this.Dias.ValorBD = bd.LerInt("Dias").ToString();
this.TaxaAdm.ValorBD = bd.LerDecimal("TaxaAdm").ToString();
this.IR.ValorBD = bd.LerString("IR");
}
else
{
this.Limpar();
}
bd.Fechar();
}
catch (Exception ex)
{
throw ex;
}
}
public CodeDetails(id, code, message, details)
{
Id = id;
Code = code;
Message = message;
Details = details;
}
protected virtual object CreateId(IColumnMetadata[] keyColumns,ITableMetadata tableMetadata)
{
if (keyColumns.Length == 1)
{
var id = new id();
id.generator = GetGenerator(keyColumns[0],tableMetadata);
id.type1 = typeConverter.GetNHType(keyColumns[0]);
id.name = currentContext.NamingStrategy.GetIdPropertyNameFromColumnName(keyColumns[0].Name);
id.column1 = 0 == string.Compare(id.name, keyColumns[0].Name, true) ? null : keyColumns[0].Name;// keyColumns[0].Name;
return id;
}
else
if (keyColumns.Length > 1)
{
var cid = new compositeid();
string entityName = currentContext.NamingStrategy.GetEntityNameFromTableName(tableMetadata.Name);
cid.@class = currentContext.NamingStrategy.GetClassNameForComponentKey(entityName);
List<keyproperty> keyps = new List<keyproperty>();
cid.name = currentContext.NamingStrategy.GetNameForComponentKey(entityName,cid.@class);
foreach (IColumnMetadata meta in keyColumns)
{
keyproperty kp = new keyproperty();
kp.name = currentContext.NamingStrategy.GetPropertyNameFromColumnName(meta.Name);
kp.column1 = 0 == string.Compare(kp.name, meta.Name, true) ? null : meta.Name;
kp.length = meta.ColumnSize != 0 ? meta.ColumnSize.ToString() : null;
kp.type1 = typeConverter.GetNHType(meta);
keyps.Add(kp);
}
cid.Items = keyps.ToArray();
return cid;
}
return null;
}
protected void Page_Load(object sender, EventArgs e)
{
Act.Pass();
Act.NoCache();
if (!Page.IsPostBack)
{
InitForm();
}
id id = new id();
id.index = 0;
if (HakApp().Rows.Count > 0)
{
DataTable hakapp = Db.Rs("SELECT * FROM ISC064_SECURITY..REF_APPROVAL WHERE Tipe = 3 AND UserID = '" + Act.UserID + "'");
for (int i = 0; i < hakapp.Rows.Count; i++)
{
Fill(Convert.ToInt16(hakapp.Rows[i]["Lvl"]), id);
}
}
else
{
Fill();
}
FeedBack();
if (frm.Visible)
{
Js.Confirm(this, "Jalankan prosedur APPROVAL PEMBATALAN KONTRAK?\\nProses ini akan merubah data kepemilikan unit properti.");
}
}
/// <summary>
/// Preenche todos os atributos de Apresentacao
/// </summary>
/// <param name="id">Informe o ID</param>
/// <returns></returns>
public override void Ler(int id)
{
try
{
string sql = "SELECT * FROM tApresentacao WHERE ID = " + id;
bd.Consulta(sql);
if (bd.Consulta().Read())
{
this.Control.ID = id;
this.ID.ValorBD = bd.LerInt("ID").ToString();
}
else
{
this.Limpar();
}
bd.Fechar();
}
catch (Exception ex)
{
throw ex;
}
finally
{
bd.Fechar();
}
}
protected virtual object CreateId(IColumnMetadata[] keyColumns, ITableMetadata tableMetadata)
{
if (keyColumns.Length == 1)
{
var id = new id();
id.generator = GetGenerator(keyColumns[0], tableMetadata);
id.type1 = typeConverter.GetNHType(keyColumns[0]);
id.name = currentContext.NamingStrategy.GetIdPropertyNameFromColumnName(keyColumns[0].Name);
id.column1 = 0 == string.Compare(id.name, keyColumns[0].Name, true) ? null : keyColumns[0].Name;// keyColumns[0].Name;
return(id);
}
else
if (keyColumns.Length > 1)
{
var cid = new compositeid();
string entityName = currentContext.NamingStrategy.GetEntityNameFromTableName(tableMetadata.Name);
cid.@class = currentContext.NamingStrategy.GetClassNameForComponentKey(entityName);
List <keyproperty> keyps = new List <keyproperty>();
cid.name = currentContext.NamingStrategy.GetNameForComponentKey(entityName, cid.@class);
foreach (IColumnMetadata meta in keyColumns)
{
keyproperty kp = new keyproperty();
kp.name = currentContext.NamingStrategy.GetPropertyNameFromColumnName(meta.Name);
kp.column1 = 0 == string.Compare(kp.name, meta.Name, true) ? null : meta.Name;
kp.length = meta.ColumnSize != 0 ? meta.ColumnSize.ToString() : null;
kp.type1 = typeConverter.GetNHType(meta);
keyps.Add(kp);
}
cid.Items = keyps.ToArray();
return(cid);
}
return(null);
}
public string add_syntagh(id, syntages)
{
for (int i = 0; i < mysyntages.Length; i = i + 2)
{
mysyntages[i - 1] = id;
mysyntages[i] = syntages;
}
}
public static string GenericJsonSingle(id, value)
{
if (value == true | value == false)
return "\""+id+"\":"+value;
else if (int.TryParse(value, out n))
return "\""+id+"\":"+value;
else
return "\""+id+"\":\""+value+"\"";
}
public PlayerData(id player)
{
health = player.health;
saveIndex = player.saveIndex;
x = player.x;
y = player.y;
time = DateTime.Now;
}
public void addPerson(id sender)
{
Person person = new Person();
person.name = "New Person";
person.age = 21;
this.people.addObject(person);
this.tableView.reloadData();
self.updateMessageLabel();
}
async Task <T> IWebService.ProcessBookingAsync(id, booking)
{
if (Interlocked.Decrement(ref RequiredConcurrentRequests) == 0)
{
_signal.TrySetResult(null);
}
await _signal.Task;
return(...);
}
public void onOk(id data)
{
NSLog("Edit dialog has been approved.");
if (DataLayer.sharedInstance.tasks.indexOfObject(data) == NSNotFound)
{
DataLayer.sharedInstance.tasks.addObject(data);
NSLog("New entry has been added.");
}
this.loadDataAction(this);
}
public void addTaskAction(id sender)
{
NSDate tommorow = new NSDate().dateByAddingTimeInterval(60 * 60 * 24 * 1);
TaskModel task =
DataLayer.newTaskWithSubject("New TODO?")
andPriority(5)
datedBy(tommorow);
this.showEditorSheetForTask(task);
}
public void pressBackButton(id sender)
{
var s = edValue.text;
if (s.length > 0)
{
s = s.substringToIndex(s.length - 1);
edValue.text = s;
}
}
public override void Limpar()
{
this.ID.Limpar();
this.EmpresaID.Limpar();
this.FormaPagamentoID.Limpar();
this.Dias.Limpar();
this.TaxaAdm.Limpar();
this.IR.Limpar();
this.Control.ID = 0;
this.Control.Versao = 0;
}
public override void prepareForSegue(UIStoryboardSegue !segue) sender(id sender)
{
if (segue.identifier.isEqualToString("showDetail"))
{
var indexPath = tableView.indexPathForSelectedRow;
var obj = _objects[indexPath.row];
segue.destinationViewController.setDetailItem(obj);
((DetailViewController)segue.destinationViewController).setDetailItem(obj);
}
}
private void deleteAlert(NSAlert alert) result(NSInteger res) context(id ctx)
{
if (res != 1)
{
return;
}
NSInteger index = this.tableViewOutlet.selectedRow();
DataLayer.sharedInstance.tasks.removeObjectAtIndex(index);
this.loadDataAction(this);
}
/// <summary> Содаёт объект-"пустышку" </summary>
public static DBObject GetEmpty(DBEntity entity, id ID)
{
//Создаём объект
DBObject Result = (DBObject)entity.EntityType.GetConstructor(new Type[0]).Invoke(new object[0]);
//Задаём инициализацию по-умолчанию для нового объекта
Result.EmptyInitialization();
//Устанавливаем заданный идентификатор
Result.ID = ID;
return(Result);
}
public void removeTaskAction(id sender)
{
NSInteger row = this.tableViewOutlet.selectedRow();
if (row < 0)
{
return;
}
NSAlert a = NSAlert.alertWithMessageText("Remove task?") defaultButton("Remove") alternateButton("Cancel") otherButton(null) informativeTextWithFormat("Do you really want to delete task?");
a.beginSheetModalForWindow(this.window) modalDelegate(this) didEndSelector(__selector(deleteAlert: result: context:)) contextInfo(null);
}
public void Awake()
{
if (instance)
{
Destroy(gameObject);
}
else
{
_instance = this;
DontDestroyOnLoad(this);
}
}
public void removePerson(id sender)
{
this.tableView.abortEditing();
int row = this.tableView.selectedRow();
if (row > -1 && row < this.people.count())
{
this.people.removeObjectAtIndex(row);
this.tableView.reloadData();
self.updateMessageLabel();
}
}
public void editTaskAction(id sender)
{
NSInteger row = this.tableViewOutlet.selectedRow();
if (row < 0)
{
return;
}
TaskModel task = DataLayer.sharedInstance.tasks[row];
this.showEditorSheetForTask(task);
}
private void InitSectorList()
{
foreach (var w in WuList)
{
SecList.Add(new Sector(w.id, w));
if (w.twine)
{
id nid = w.id;
nid.negate();
SecList.Add(new Sector(nid, w));
}
}
}
public PlayerData(id player)
{
health = player.health;
saveIndex = player.saveIndex;
x = player.x;
y = player.y;
saving = player.saving;
lastSceneSaved = player.lastSceneSaved;
scenesUnlocked = player.scenesUnlocked;
fastTravelSpots = player.fastTravelSpots;
time = DateTime.Now;
}
public void pressEvaluateButton(id sender)
{
try
{
var eval = new Evaluator();
edValue.text = "" + eval.Evaluate(edValue.text);
}
catch (EvaluatorError e)
{
var alert = UIAlertController.alertControllerWithTitle("Calculator!") message("Error evaluation: " + e.reason) preferredStyle(UIAlertControllerStyle.Alert);
presentViewController(alert) animated(true) completion(null);
}
}
public void pressEvaluateButton(id sender)
{
try
{
var eval = new Evaluator();
edValue.text = "" + eval.Evaluate(edValue.text);
}
catch (EvaluatorError e)
{
var alert = new UIAlertView withTitle("Calculator") message("Error evaluation: " + e.reason) @delegate(null) cancelButtonTitle("OK") otherButtonTitles(null);
alert.show();
}
}
public void pressEvaluateButton(id sender)
{
try
{
var eval = new Evaluator();
edValue.stringValue = "" + eval.Evaluate(edValue.stringValue);
}
catch (EvaluatorError e)
{
var alert = new NSAlert();
alert.messageText = "Error evaluating: " + e.reason;
alert.runModal();
}
}
private void tableViewDidDoubleClick(id sender)
{
NSInteger index = this.tableViewOutlet.clickedRow;
if (index == -1)
{
this.addTaskAction(sender);
return;
}
TaskModel task = DataLayer.sharedInstance.tasks[index];
this.showEditorSheetForTask(task);
}
public static void SavePlayer(id player, string path)
{
BinaryFormatter formatter = new BinaryFormatter();
//FileStream file = File.Create(Application.persistentDataPath + "/gamesave.save");
//string path = Application.persistentDataPath + "/gamesave.save";
FileStream stream = new FileStream(path, FileMode.Create);
PlayerData data = new PlayerData(player);
formatter.Serialize(stream, data);
stream.Close();
}
public string add_doctors(id, onoma_giatrou)
{
for (int i = 0; i < account.Length; i = i + 5)
{
if (account[i - 5] = id)
{
for (int i = 0; i < mydoctors.Length; i = i + 2)
{
mydoctors[i - 1] = id;
mydoctors[i] = onoma_giatrou;
}
}
}
}
/// <summary>
/// Inserir novo(a) Empresa
/// </summary>
/// <returns></returns>
public override bool Inserir()
{
try
{
bd.IniciarTransacao();
StringBuilder sql = new StringBuilder();
sql.Append("SELECT MAX(ID) AS ID FROM cEmpresa");
object obj = bd.ConsultaValor(sql);
int id = (obj != null) ? Convert.ToInt32(obj) : 0;
this.Control.ID = ++id;
this.Control.Versao = 0;
sql = new StringBuilder();
sql.Append("INSERT INTO tEmpresa(ID, ID, EmpresaID, FormaPagamentoID, Dias, TaxaAdm, IR) ");
sql.Append("VALUES (@ID,@001,@002,@003,@004,'@005','@006')");
sql.Replace("@ID", this.Control.ID.ToString());
sql.Replace("@001", this.ID.ValorBD);
sql.Replace("@002", this.EmpresaID.ValorBD);
sql.Replace("@003", this.FormaPagamentoID.ValorBD);
sql.Replace("@004", this.Dias.ValorBD);
sql.Replace("@005", this.TaxaAdm.ValorBD);
sql.Replace("@006", this.IR.ValorBD);
int x = bd.Executar(sql.ToString());
bool result = (x == 1);
if (result)
{
InserirControle("I");
}
bd.FinalizarTransacao();
return(result);
}
catch (Exception ex)
{
bd.DesfazerTransacao();
throw ex;
}
finally
{
bd.Fechar();
}
}
public void cancel(id sender)
{
NSApp.endSheet(this.window());
}
public CartProduct (id, name)
{
this.id = id;
this.name = name;
}
new MenuItemViewModel(id: nameof(GalleryViewModel), title: GalleryItemTitle, iconSource: null),
new MenuItemViewModel(id: nameof(CameraViewModel), title: CameraItemTitle, iconSource: null)
public void onLoginClick(id sender)
{
done = true;
NSApp.stopModal();
}
public void validate(id sender)
{
this.validated = true;
}
public void cancel(id sender)
{
}
public void have_petcolawd(id)
{
foreach (awdid in pinfo.petcol.awds)
{
if (id == awdid)
{
return true;
}
}
return false;
}
public void on_petpk_rec(id)
{
// pkrec: {cid, tcid, turn, vic, tm, rec}
local rec = db_obj.select_data_obj("petpk", "id", id.tostring(), null);
if (rec && rec.len() > 0)
{
_add_petpk_rec(rec[0]);
}
else
{
// 数据库中未找到对应id的数据
sys.trace(sys.SLT_ERR, "petpk record not found, id:%d\n", id);
}
}
public void onCancelClick(id sender)
{
done = false;
NSApp.stopModal();
}
