public string GetGroupByGridData(string REPORT_CODE, string FIELD_CAPS, string SQL_SELECT,
string SQL_FROM, string SQL_WHERE, string SQL_ORDER_BY, string QB_GB_SELECT_CLAUSE, string SQL_ORDER_DIR, string START_ROW,
string PAGE_SIZE, string SQL_GROUP_BY, string MULTI_SELECT, string GIS_THEME_LAYER)
{
try
{
//*** decode ecoded single quite(') to char
REPORT_CODE = Microsoft.JScript.GlobalObject.unescape(REPORT_CODE).Replace("@@@", "\"");
FIELD_CAPS = Microsoft.JScript.GlobalObject.unescape(FIELD_CAPS).Replace("@@@", "\"");
SQL_SELECT = Microsoft.JScript.GlobalObject.unescape(SQL_SELECT).Replace("@@@", "\"").Replace(';', ',');
SQL_FROM = Microsoft.JScript.GlobalObject.unescape(SQL_FROM).Replace("@@@", "\"");
SQL_WHERE = Microsoft.JScript.GlobalObject.unescape(SQL_WHERE).Replace("@@@", "\"");
SQL_GROUP_BY = Microsoft.JScript.GlobalObject.unescape(SQL_GROUP_BY).Replace("@@@", "\"");
SQL_ORDER_BY = Microsoft.JScript.GlobalObject.unescape(SQL_ORDER_BY).Replace("@@@", "\"");
QB_GB_SELECT_CLAUSE = Microsoft.JScript.GlobalObject.unescape(QB_GB_SELECT_CLAUSE).Replace("@@@", "\"");
return(OBController.GetGroupByGridData(REPORT_CODE, FIELD_CAPS, SQL_SELECT,
SQL_FROM, SQL_WHERE, SQL_ORDER_BY, SQL_ORDER_DIR, START_ROW,
PAGE_SIZE, SQL_GROUP_BY, MULTI_SELECT, QB_GB_SELECT_CLAUSE, GIS_THEME_LAYER));
}
catch (Exception ex)
{
return(ex.Message);
}
}
public string GetNormalGridData(string REPORT_CODE, string FIELD_CAPS, string SQL_SELECT,
string SQL_FROM, string SQL_WHERE, string SQL_ORDER_BY, string SQL_ORDER_DIR, string START_ROW,
string PAGE_SIZE, string SQL_MANDATORY, string MULTI_SELECT,
string FUNCTION_LIST)
{
try
{
//*** decode ecoded single quite(') to char
REPORT_CODE = Microsoft.JScript.GlobalObject.unescape(REPORT_CODE).Replace("@@@", "\"");
FIELD_CAPS = Microsoft.JScript.GlobalObject.unescape(FIELD_CAPS).Replace("@@@", "\"");
SQL_SELECT = Microsoft.JScript.GlobalObject.unescape(SQL_SELECT).Replace("@@@", "\"");
SQL_FROM = Microsoft.JScript.GlobalObject.unescape(SQL_FROM).Replace("@@@", "\"");
LogWriter.WriteLog("BEFORE:" + SQL_WHERE);
//SQL_WHERE = Server.UrlDecode(SQL_WHERE);
LogWriter.WriteLog("AFTER:" + SQL_WHERE);
SQL_WHERE = Microsoft.JScript.GlobalObject.unescape(SQL_WHERE).Replace("@@@", "\"").Replace("$$$$", "");
LogWriter.WriteLog("AFTER1:" + SQL_WHERE);
SQL_ORDER_BY = Microsoft.JScript.GlobalObject.unescape(SQL_ORDER_BY).Replace("@@@", "\"");
SQL_MANDATORY = Microsoft.JScript.GlobalObject.unescape(SQL_MANDATORY).Replace("@@@", "\"");
FUNCTION_LIST = Microsoft.JScript.GlobalObject.unescape(FUNCTION_LIST).Replace("@@@", "\"");
string gridData = OBController.GetNormalGridData(REPORT_CODE, FIELD_CAPS, SQL_SELECT,
SQL_FROM, SQL_WHERE, SQL_ORDER_BY, SQL_ORDER_DIR, START_ROW,
PAGE_SIZE, SQL_MANDATORY, MULTI_SELECT, FUNCTION_LIST);
return(gridData);
}
catch (Exception ex)
{
return(ex.Message);
}
}
public string GetFieldNameType(string REPORT_CODE, string SQL_FROM)
{
try
{
REPORT_CODE = Microsoft.JScript.GlobalObject.unescape(REPORT_CODE).Replace("@@@", "\"");
SQL_FROM = Microsoft.JScript.GlobalObject.unescape(SQL_FROM).Replace("@@@", "\"");
return(OBController.GetFieldNameType(REPORT_CODE, SQL_FROM));
}
catch (Exception ex)
{
return("Syntax Error!");
}
}
public string ValidateWhereClause(string REPORT_CODE, string SQL_FROM, string whereClause)
{
try
{
REPORT_CODE = Microsoft.JScript.GlobalObject.unescape(REPORT_CODE).Replace("@@@", "\"");
SQL_FROM = Microsoft.JScript.GlobalObject.unescape(SQL_FROM).Replace("@@@", "\"");
whereClause = Microsoft.JScript.GlobalObject.unescape(whereClause).Replace("@@@", "\"");
return(OBController.ValidateWhereClause(REPORT_CODE, SQL_FROM, whereClause));
}
catch (Exception ex)
{
return(ex.StackTrace);
}
}
public string CheckCustomFieldValidation(string REPORT_CODE, string SQL_FROM, string customFields, string groupBy)
{
try
{
REPORT_CODE = Microsoft.JScript.GlobalObject.unescape(REPORT_CODE).Replace("@@@", "\"");
SQL_FROM = Microsoft.JScript.GlobalObject.unescape(SQL_FROM).Replace("@@@", "\"");;
customFields = Microsoft.JScript.GlobalObject.unescape(customFields).Replace(';', ',');
return(OBController.CheckCustomFieldValidation(REPORT_CODE, SQL_FROM, customFields, groupBy));
}
catch (Exception ex)
{
return(ex.StackTrace);
}
}
public string GetFieldValues(string REPORT_CODE, string SQL_FROM, string FIELD_NAME)
{
try
{
REPORT_CODE = Microsoft.JScript.GlobalObject.unescape(REPORT_CODE).Replace("@@@", "\"");
SQL_FROM = Microsoft.JScript.GlobalObject.unescape(SQL_FROM).Replace("@@@", "\"");
FIELD_NAME = Microsoft.JScript.GlobalObject.unescape(FIELD_NAME).Replace("@@@", "\"");
return(OBController.GetFieldValues(REPORT_CODE, SQL_FROM, FIELD_NAME));
}
catch (Exception ex)
{
return(ex.Message);
}
}
public string CheckGroupBySelectValidation(string REPORT_CODE, string SQL_FROM, string QB_GB_SELECT_CLAUSE)
{
try
{
REPORT_CODE = Microsoft.JScript.GlobalObject.unescape(REPORT_CODE);
SQL_FROM = Microsoft.JScript.GlobalObject.unescape(SQL_FROM).Replace("@@@", "\"");;
QB_GB_SELECT_CLAUSE = Microsoft.JScript.GlobalObject.unescape(QB_GB_SELECT_CLAUSE).Replace(';', ',');
return(OBController.CheckGroupBySelectValidation(REPORT_CODE, SQL_FROM, QB_GB_SELECT_CLAUSE));
}
catch (Exception ex)
{
return(ex.StackTrace);
}
}
/// <summary>
/// 绑定主角组件
/// </summary>
/// <returns></returns>
private bool BindHeroComponent()
{
Trace.Log("BindHeroComponent() -> Hero, id=" + ID.ToString());
CreatureProperty property = this.Property;
BaseStateMachine fsm = this.StateMachine;
if (property == null || fsm == null)
{
Trace.Log("BindHeroComponent failed. CreatureProperty==null or BaseStateMachine == null !!!");
return(false);
}
m_gameObject.layer = LayerMask.NameToLayer(Config.LayerHero);
fsm.baseLayer = LayerMask.NameToLayer(Config.LayerHero);
fsm.pickableCount = 1;
fsm.isNotAttack = false;
MouseCtrl mousectrl = m_gameObject.GetComponent <MouseCtrl>();
if (mousectrl == null)
{
mousectrl = m_gameObject.AddComponent <MouseCtrl>();
}
m_DynamicCommopnent.AddLast(mousectrl);
SkillCtrl skillctrl = m_gameObject.GetComponent <SkillCtrl>();
if (skillctrl == null)
{
skillctrl = m_gameObject.AddComponent <SkillCtrl>();
skillctrl.resetOrderset(0);//property.SkillOrderSetName);
}
m_DynamicCommopnent.AddLast(skillctrl);
ScreenRaycast raycast = m_gameObject.GetComponent <ScreenRaycast>();
if (raycast == null)
{
raycast = m_gameObject.AddComponent <ScreenRaycast>();
}
m_DynamicCommopnent.AddLast(raycast);
fsm.isHero = true;
fsm.canControl = true;
SoldierController soliderController = m_gameObject.GetComponent <SoldierController>();
if (soliderController == null)
{
soliderController = m_gameObject.AddComponent <SoldierController>();
}
m_DynamicCommopnent.AddLast(soliderController);
if (StageManager.Instance.CurPermissionState == EStage_PermissionState.ESPS_OB)
{
OBController obController = m_gameObject.GetComponent <OBController>();
if (obController == null)
{
obController = m_gameObject.AddComponent <OBController>();
}
m_DynamicCommopnent.AddLast(obController);
}
fsm.maxRunForwardSpeed = property.runSpeed_Forward;
fsm.maxRunBackwardSpeed = property.runSpeed_Back;
fsm.maxRunSidewaySpeed = property.runSpeed_LeftRight;
//ScreenCastLayer screenCastLayer = m_gameObject.GetComponent<ScreenCastLayer>();
//if (screenCastLayer != null)
//{
// screenCastLayer.setHero(true);
// GameObject.ResNode.DestroyRes(ref screenCastLayer);
//}
return(true);
}
