public void ARProxy_GetEntryListStatictisc_avg_qulifier_group_success()
{
ARLoginContext context = new ARLoginContext(TestServer, TestAdmin, TestAdminPwd);
try
{
List<UInt32> groupIds = new List<UInt32>();
groupIds.Add(TestCharacterFieldId);
ARProxy<NRemedy_Test_Regular_Form> proxy = new ARProxy<NRemedy_Test_Regular_Form>(context);
var retlist = proxy.GetListEntryStatictisc(
"'Character Field' LIKE \"%你好%\"",
ARStatictisc.STAT_OP_AVERAGE,
TestIntFieldId,
groupIds
);
Assert.AreEqual(2, retlist.Count);
Dictionary<String, int> assertTable = new Dictionary<string, int>();
//assertTable.Add("Hello Remedy", 7);
assertTable.Add("你好 RemedySet Something", 3);
assertTable.Add("你好 Remedy", 2);
Assert.AreEqual(assertTable[retlist[0].CharacterField], Convert.ToInt32(retlist[0].Statictisc));
Assert.AreEqual(assertTable[retlist[1].CharacterField], Convert.ToInt32(retlist[1].Statictisc));
}
catch (Exception ex)
{
Assert.AreEqual(null, ex);
}
finally
{
context.Dispose();
}
}
public void ARProxy_GetEntryListStatictisc_by_Properties_Str_avg_qulifier_group_success()
{
ARLoginContext context = new ARLoginContext(TestServer, TestAdmin, TestAdminPwd);
try
{
ARProxy <NRemedy_Test_Regular_Form> proxy = new ARProxy <NRemedy_Test_Regular_Form>(context);
var retlist = proxy.GetListEntryStatictisc(
"'Character Field' LIKE \"%你好%\"",
TestIntFieldId,
new string[] { "CharacterField" },
ARStatictisc.STAT_OP_AVERAGE
);
Assert.AreEqual(2, retlist.Count);
Dictionary <String, int> assertTable = new Dictionary <string, int>();
//assertTable.Add("Hello Remedy", 7);
assertTable.Add("你好 RemedySet Something", 3);
assertTable.Add("你好 Remedy", 2);
Assert.AreEqual(assertTable[retlist[0].CharacterField], Convert.ToInt32(retlist[0].Statictisc));
Assert.AreEqual(assertTable[retlist[1].CharacterField], Convert.ToInt32(retlist[1].Statictisc));
}
catch (Exception ex)
{
Assert.AreEqual(null, ex);
}
finally
{
context.Dispose();
}
}
public void ARProxy_GetEntryListStatictisc_count_noqulifier_group_success()
{
ARLoginContext context = new ARLoginContext(TestServer, TestAdmin, TestAdminPwd);
try
{
List <UInt32> groupIds = new List <UInt32>();
groupIds.Add(TestCharacterFieldId);
ARProxy <NRemedy_Test_Regular_Form> proxy = new ARProxy <NRemedy_Test_Regular_Form>(context);
var retlist = proxy.GetListEntryStatictisc(
null,
ARStatictisc.STAT_OP_COUNT,
null,
groupIds
);
Assert.AreEqual(3, retlist.Count);
Dictionary <String, int> assertTable = new Dictionary <string, int>();
assertTable.Add("Hello Remedy", 7);
assertTable.Add("你好 RemedySet Something", 2);
assertTable.Add("你好 Remedy", 9);
Assert.AreEqual(assertTable[retlist[0].CharacterField], Convert.ToInt32(retlist[0].Statictisc));
Assert.AreEqual(assertTable[retlist[1].CharacterField], Convert.ToInt32(retlist[1].Statictisc));
Assert.AreEqual(assertTable[retlist[2].CharacterField], Convert.ToInt32(retlist[2].Statictisc));
}
catch (Exception ex)
{
Assert.AreEqual(null, ex);
}
finally
{
context.Dispose();
}
}
public void ARProxy_GetEntryListStatictisc_count_qulifier_nogroup_success()
{
ARLoginContext context = new ARLoginContext(TestServer, TestAdmin, TestAdminPwd);
try
{
List <UInt32> groupIds = new List <UInt32>();
ARProxy <NRemedy_Test_Regular_Form> proxy = new ARProxy <NRemedy_Test_Regular_Form>(context);
groupIds.Add(TestCharacterFieldId);
var retlist = proxy.GetListEntryStatictisc(
"'Character Field' = \"Hello Remedy\"",
ARStatictisc.STAT_OP_COUNT,
null,
null
);
Assert.AreEqual(1, retlist.Count);
Assert.AreEqual(7, Convert.ToInt32(retlist[0].Statictisc));
}
catch (Exception ex)
{
Assert.AreEqual(null, ex);
}
finally
{
context.Dispose();
}
}
public override object Execute(Expression expression)
{
//translate expression
//visit Evalable expression
expression = Evaluator.PartialEval(expression);
//translate
TranslateResult tr = this.Translate(expression);
//T is model of AR,cache the id and property name map
//if(!_Cache.ContainsKey(typeof(T).FullName))
//{
// Dictionary<string,uint> propertry = new Dictionary<string,uint>();
// _Cache.Add(typeof(T).FullName,propertry);
// foreach (PropertyInfo prop in typeof(T).GetProperties
// //unbinder need at least readable property
// (BindingFlags.GetProperty | BindingFlags.Public | BindingFlags.Instance))
// {
// var fieldAttribute = GetARAttributeField(prop, ModelBinderAccessLevel.OnlyUnBind | ModelBinderAccessLevel.OnlyBind);
// if (fieldAttribute == null) continue;
// propertry.Add(prop.Name,fieldAttribute.DatabaseID);
// }
//}
//string formName = typeof(T).FullName;
//get metadata
var properties = metaProvider.GetPropertyInfoes(
(BindingFlags.SetProperty | BindingFlags.Public | BindingFlags.Instance),
null);
//if no statictisc
//we should invoke GetEntryList
if (tr.HasStatictisc == false)
{
ARProxy <T> proxy = new ARProxy <T>((ARLoginContext)context);
//get select
List <uint> fieldIds = new List <uint>();
if (tr.SelectResult != null && tr.SelectResult.SelectedProperties.Count > 0)
{
foreach (var p in properties)
{
if (tr.SelectResult.SelectedProperties.Find(s => s == p.Property.Name) == null)
{
continue;
}
fieldIds.Add(p.DatabaseId);
}
}
else
{
foreach (var p in properties)
{
fieldIds.Add(p.DatabaseId);
}
}
//if(tr.HasSelect && tr.SelectedProperties.Count > 0){
// foreach(var s in tr.SelectedProperties){
// fieldIds.Add(_Cache[formName][s.SourceMemberName]);
// }
//}
//else{
// foreach(var d in _Cache[formName])
// fieldIds.Add(d.Value);
//}
//get paged
uint StartIndex = 0;
uint?RetrieveCount = null;
if (tr.NoQueryableResult != null && tr.NoQueryableResult.HasSkip)
{
StartIndex = (uint)tr.NoQueryableResult.Skip.Value;
}
if (tr.NoQueryableResult != null && tr.NoQueryableResult.HasTake)
{
RetrieveCount = (uint)tr.NoQueryableResult.Take.Value;
}
//get order by
List <ARSortInfo> sort = new List <ARSortInfo>();
if (tr.OrderByResult != null && tr.OrderByResult.OrderByList.Count > 0)
{
foreach (var p in properties)
{
var ss = tr.OrderByResult.OrderByList.Find(s => s.Property == p.Property.Name);
if (ss == null)
{
continue;
}
sort.Add(new ARSortInfo
{
FieldId = p.DatabaseId,
Order = ss.Method == "OrderBy" ? SortOrder.SORT_ASCENDING : SortOrder.SORT_DESCENDING
});
}
}
IList <T> resultList = proxy.GetEntryList(
tr.ConditionResult == null ? null : tr.ConditionResult.Qulification.ToString(),
fieldIds,
StartIndex,
RetrieveCount,
null,
sort
);
if (tr.SelectResult == null || tr.SelectResult.TargetType == null) //means no explict select clause
{
return(resultList);
}
else
{
Type[] typeArgs = { tr.SelectResult.TargetType, typeof(T) };
return((IEnumerable)Activator.CreateInstance(
typeof(Enumerator <,>).MakeGenericType(typeArgs),
resultList,
tr.SelectResult.SelectExpression));
}
}
else if (tr.HasStatictisc && tr.StatictiscVerb == "Count")
{
ARProxy <T> proxy = new ARProxy <T>((ARLoginContext)context);
List <UInt32> groups = null;
var list = proxy.GetListEntryStatictisc(
tr.ConditionResult == null ? null : tr.ConditionResult.Qulification.ToString(),
ARStatictisc.STAT_OP_COUNT,
null,
groups);
if (list.Count != 1)
{
throw new Exception("GetListEntryStatictisc returns invalid result.");
}
T entry = list[0];
return(Convert.ToInt32((entry as ARBaseForm).Statictisc));
}
else
{
throw new NotImplementedException("Group by and statictisc is not support yet.Please use ARProxy API");
/*
* ARStatictisc stat = ARStatictisc.STAT_OP_COUNT;
* uint? targetFieldId = null;
* List<uint> groupByList = null;
*
* if(tr.HasStatictisc)
* {
* switch (tr.StatictiscVerb)
* {
* case "Sum":
* stat = ARStatictisc.STAT_OP_SUM;
* break;
* case "Max":
* stat = ARStatictisc.STAT_OP_MAXIMUM;
* break;
* case "Min":
* stat = ARStatictisc.STAT_OP_MINIMUM;
* break;
* case "Count":
* stat = ARStatictisc.STAT_OP_COUNT;
* break;
* case "Average":
* stat = ARStatictisc.STAT_OP_AVERAGE;
* break;
* default:
* throw new NotImplementedException(tr.StatictiscVerb + " is not support.");
* }
*
* if(tr.StatictiscTarget == null && tr.StatictiscVerb != "Count")
* throw new InvalidOperationException("TargetFieldId must not null if ARStat is not COUNT");
*
* targetFieldId = _Cache[formName][tr.StatictiscTarget.SourceMemberName];
* }
*
* if(tr.HasGroupBy)
* {
* groupByList = new List<uint>();
* foreach(var g in tr.GroupedProperties){
* groupByList.Add(_Cache[formName][g.SourceMemberName]);
* }
* }
*
*
*
* ARProxy<T> proxy = new ARProxy<T>((ARLoginContext)context, (IARServerFactory)factory);
* IList<T> resultList = proxy.GetListEntryStatictisc(
* tr.Qulification.ToString(),
* stat,
* targetFieldId,
* groupByList);
*
* if (groupByList == null || groupByList.Count == 0)
* return (resultList[0] as ARBaseForm).Statictisc;
* else
* {
* Type[] typeArgs = { tr.GroupType, typeof(T) ,tr.TargetType };
* return (IEnumerable)Activator.CreateInstance(
* typeof(Groupor<,>).MakeGenericType(typeArgs),
* resultList,
* tr.GroupExpression);
*
*
* }
*/
}
#region code dropped
////two mainly type of query
////one with statictisc another without statictisc
////the flag is tr.HasStatictisc
//if (tr.HasStatictisc)
//{
// ARStatictisc stat;
// switch (tr.StatictiscVerb)
// {
// case "Sum":
// stat = ARStatictisc.STAT_OP_SUM;
// break;
// case "Max":
// stat = ARStatictisc.STAT_OP_MAXIMUM;
// break;
// case "Min":
// stat = ARStatictisc.STAT_OP_MINIMUM;
// break;
// case "Count":
// stat = ARStatictisc.STAT_OP_COUNT;
// break;
// case "Average":
// stat = ARStatictisc.STAT_OP_AVERAGE;
// break;
// default:
// throw new NotImplementedException(tr.StatictiscVerb + " is not support.");
// }
// if (tr.HasGroupBy)
// {
// }
// else
// {
// }
// ARProxy<T> proxy = new ARProxy<T>((ARLoginContext)context);
// IList<T> list = proxy.GetListEntryStatictisc(
// tr.Qulification.ToString(),
// stat,
// Convert.ToUInt32(tr.StatictiscTarget.SourceMemberName),
// null);
// //two sub type of query
// //one with group by another without group by
// //the flag is tr.HasGroupBy
//}
//else
//{
//}
//if (tr.HasGroupBy)
//{
// ARProxy<T> proxy = new ARProxy<T>((ARLoginContext)context);
// IList<T> list = proxy.GetListEntryStatictisc(
// tr.Qulification.ToString(),
// ARStatictisc.STAT_OP_SUM,
// Convert.ToUInt32(tr.StatictiscTarget.SourceMemberName),
// null);
//}
//if (tr.Count)
//{
// ARProxy4Linq<T> proxy = (ARProxy4Linq<T>)Activator.CreateInstance(
// typeof(ARProxy4Linq<T>), context, factory);
// return proxy.GetEntryCountByQuery(tr.Qulification.ToString());
//}
////special "Select" clause apply
//else if (tr.Select)
//{
// tr.TargetType = TypeSystem.GetElementType(expression.Type);
// ARProxy4Linq<T> proxy = (ARProxy4Linq<T>)Activator.CreateInstance
// (typeof(ARProxy4Linq<T>), context, factory);
// return proxy.GetEntryByQuery(
// tr.Qulification.ToString(),
// tr.SelectedProperties,
// tr.TargetType,
// tr.SelectExpression
// );
//}
//else
//{
// ARProxy4Linq<T> proxy = (ARProxy4Linq<T>)Activator.CreateInstance(
// typeof(ARProxy4Linq<T>), context, factory);
// return proxy.GetEntryByQuery(tr.Qulification.ToString());
//}
#endregion
}
public void ARProxy_GetEntryListStatictisc_count_qulifier_nogroup_success()
{
ARLoginContext context = new ARLoginContext(TestServer, TestAdmin, TestAdminPwd);
try
{
List<UInt32> groupIds = new List<UInt32>();
ARProxy<NRemedy_Test_Regular_Form> proxy = new ARProxy<NRemedy_Test_Regular_Form>(context);
groupIds.Add(TestCharacterFieldId);
var retlist = proxy.GetListEntryStatictisc(
"'Character Field' = \"Hello Remedy\"",
ARStatictisc.STAT_OP_COUNT,
null,
null
);
Assert.AreEqual(1, retlist.Count);
Assert.AreEqual(7, Convert.ToInt32(retlist[0].Statictisc));
}
catch (Exception ex)
{
Assert.AreEqual(null, ex);
}
finally
{
context.Dispose();
}
}