public override void Test()
{
var guid = Guid.NewGuid();
var _args = new { p1 = CommandParameter.Guid(guid), p2 = CommandParameter.Output(SqlDbType.UniqueIdentifier) };
var dbr = DA.DefaultDb.ExecuteNonQuery("ust_test1", _args);
if (dbr.Success)
{
var s = SafeClrConvert.ToString(_args.p2.Value);
System.Console.WriteLine("p2: " + s);
}
else
{
System.Console.WriteLine(dbr.Exception.Message);
}
}
void test2()
{
var args = new Dictionary <string, object>();
args.Add("Result", CommandParameter.Output(SqlDbType.VarChar, 50));
args.Add("Args", CommandParameter.Output(SqlDbType.NVarChar, 1000));
args.Add("execMode", 0);
args.Add("ClientKey", CommandParameter.Guid("F9FA3F42-7568-4FDC-AF12-A88994997596"));
//(args["ClientKey"] as GuidCommandParameter).Value = "F9FA3F42-7568-4FDC-AF12-A88994997596";
var dbr = DA.DefaultDb.ExecuteSingle("usp1_ApiClient_GetByKey", (IDataReader reader) =>
{
var result = new Locust.Modules.Api.Model.ApiClient.Full();
result.Read(reader);
return(result);
}, args);
if (dbr.Success)
{
switch (dbr.MessageType)
{
case MessageType.SingleSuccess:
//Console.WriteLine(dbr.Data.ClientKey);
//Console.WriteLine(JsonConvert.SerializeObject(dbr.Data));
Console.WriteLine(dbr.Data.ToJson());
break;
case MessageType.SingleNotFound:
Console.WriteLine("Not found");
break;
}
}
else
{
Console.WriteLine("Error: {0}", dbr.Exception.Message);
}
}
