} //end for function
public static SortableBindingList <T> GetSorttableList <T>(int handle) where T : new()
{
SortableBindingList <T> list = new SortableBindingList <T>();
int cnt = 0;
BCCHelper.GetRecordCount(handle, ref cnt);
for (int rowIndex = 0; rowIndex < cnt; rowIndex++)
{
//populate single entity for per row
T obj = new T();
Type t = typeof(T);
PropertyInfo[] pros = t.GetProperties();
foreach (PropertyInfo p in pros)
{
object[] attrs = p.GetCustomAttributes(typeof(CPackAttribute), false);
if (attrs.Length > 0 && attrs[0] is CPackAttribute)
{
CPackAttribute cpa = attrs[0] as CPackAttribute;
if (cpa != null)
{
string field = cpa.FieldName;
if (cpa.FieldType == typeof(int))
{
int iVal = 0;
BCCHelper.GetIntFieldByName(handle, rowIndex, field, ref iVal);
p.SetValue(obj, iVal, null);
}
else if (cpa.FieldType == typeof(double))
{
double dVal = 0.0d;
BCCHelper.GetDoubleFieldByName(handle, rowIndex, field, ref dVal);
p.SetValue(obj, dVal, null);
}
else //char[] type for CPack
{
string sval = BCCHelper.GetStringFieldByName(handle, rowIndex, field);
p.SetValue(obj, sval, null);
}
}
}
} //end for foreach PropertyInfo
//add entity to result list
list.Add(obj);
} //end for each row
return(list);
}
private void PrepareRelations()
{
if (dtRelation == null)
{
dtRelation = new DataTable("relations");
dtRelation.Columns.Add("StaffId", typeof(string));
dtRelation.Columns.Add("Name", typeof(string));
dtRelation.Columns.Add("WalletId", typeof(string));
dtRelation.PrimaryKey = new DataColumn[] { dtRelation.Columns[0] };
}
dtRelation.Rows.Clear();
int handle = 0;
Global.BCCInit();
//make a new bcc handle
handle = BCCHelper.NewXpackHandle(@"KSLib\cpack.dat");
if (BCCHelper.SetRequestType(handle, 841601))
{
int errCode = 0;
int retCode = -1;
bool hasMorePack = false;
StringBuilder errMsg = new StringBuilder(255);
bool requestStatus = BCCHelper.CallRequest(handle, Global.Drtp_NO, Global.Drtp_Branch, Global.BCC_BaseFunction, 5000, ref errCode, errMsg);
if (!requestStatus)
{
Global.Logger.Warn(string.Format("BCCHelper.CallRequest[841601] failed! errorCode ={0} and errMsg= {1}", errCode, errMsg));
return;
}
BCCHelper.GetRetCode(handle, ref retCode);
//int packageCnt = 0;
do
{
if (retCode != 0)
{
continue;
}
//show data rows of package into grid view
int cnt = 0;
BCCHelper.GetRecordCount(handle, ref cnt);
for (int rowIndex = 0; rowIndex < cnt; rowIndex++)
{
DataRow dr = dtRelation.NewRow();
dr["StaffId"] = BCCHelper.GetStringFieldByName(handle, rowIndex, "scust_auth2");
dr["Name"] = BCCHelper.GetStringFieldByName(handle, rowIndex, "sname");
dr["WalletId"] = BCCHelper.GetStringFieldByName(handle, rowIndex, "sname2");
dtRelation.Rows.Add(dr);
}
} while (hasMorePack = BCCHelper.HaveNextPack(handle) && BCCHelper.CallNext(handle, 5000, ref errCode, errMsg));
}
else
{
Global.Logger.Info("BCCHelper.SetRequestType[841601] failed!");
}
//release cpack handle
if (handle != 0)
{
BCCHelper.DeleteXpackHandle(handle);
Global.Logger.Info("delete xpack handle for request type= 841601");
}
}