public bool LoadNextLevel(Transform origin)
{
if (progress != GenerationProgress.IDLE)
{
return(false);
}
oldRoom = currentRoom;
oldParams = newParams;
oldRoom.name = "Old Room";
currentRoom = newRoom;
currentParams = newParams;
currentRoom.name = "Room";
levelCounter++;
DeactivateDoor(currentRoom);
currentRoom.position = new Vector3(origin.position.x, 0.0f, origin.position.z);
currentRoom.rotation = origin.rotation;
navMesh.BuildNavMesh();
spawner.SpawnEnemies(currentParams.enemySpawns.ToArray(), 0.5f);
GenerateRoom();
return(true);
}
public static String CallCursorStoreProcExt(DataTable table, String procname, String paramvalue, String dsname)
{
try
{
InParams inparams = SDPClient.NewInParams();
OutParams outparams = SDPClient.NewOutParams();
inparams.SetRequestBody("ServiceName", "DataServices");
inparams.SetRequestBody("ServiceItem", "CallStoreProc");
inparams.SetRequestBody("StoreProcType", "CursorStoreProcExt");
inparams.SetRequestBody("StoreProcName", procname);
inparams.SetRequestBody("DataSource", dsname);
inparams.SetRequestParams(paramvalue);
SDPClient.CallService(inparams, outparams);
DataTable resulttable = outparams.GetTableParamValue(0);
DataUtil.CopyTable(resulttable, table);
return(outparams.GetStrParamValue("Result"));
}
catch (Exception e)
{
System.Console.Out.WriteLine("DataServices.CallCursorStoreProcExt Exception: {0}", e);
throw e;
}
}
public static int ExecTransaction(ITransactior tran)
{
try
{
string tranData = tran.GetTranData();
System.Console.Out.WriteLine("DataServices.ExecTransaction Xml=" + tranData);
if (tranData != null && !tranData.Equals(""))
{
InParams inparams = SDPClient.NewInParams();
OutParams outparams = SDPClient.NewOutParams();
inparams.SetRequestBody("ServiceName", "DataServices");
inparams.SetRequestBody("ServiceItem", "ExecTransaction");
inparams.SetRequestBody("TranType", tran.TranType);
inparams.SetRequestBody("TranData", tranData);
inparams.SetRequestBody("UpdateCheckType", (int)tran.UpdateCheckType);
inparams.SetRequestBody("AutoUpdateLob", "1");
SDPClient.CallService(inparams, outparams);
return(outparams.GetIntParamValue("UpdateRows"));
}
else
{
return(0);
}
}
catch (Exception e)
{
System.Console.Out.WriteLine("DataServices.ExecTransaction Exception: {0}", e);
throw new TransactionException("保存数据失败！", e);
}
}
public static bool LoadData(DataTable table, string rulename, string paramvalue, string pageinfo, string defwhere, string dsname)
{
try
{
InParams inparams = SDPClient.NewInParams();
OutParams outparams = SDPClient.NewOutParams();
inparams.SetRequestBody("ServiceName", "DataServices");
inparams.SetRequestBody("ServiceItem", "LoadData");
inparams.SetRequestBody("RuleName", rulename);
inparams.SetRequestBody("DefWhere", defwhere);
inparams.SetRequestBody("PageInfo", pageinfo);
inparams.SetRequestBody("DataSource", dsname);
inparams.SetRequestParams(paramvalue);
SDPClient.CallService(inparams, outparams);
DataTable resultTable = outparams.GetTableParam(rulename).GetDataTableValue();
if (table.Columns.Count <= 0)
{
DataUtil.InitTableSchemaFromDataRule(table, rulename);
}
return(DataUtil.CopyTable(resultTable, table));
}
catch (Exception e)
{
System.Console.Out.WriteLine("DataServices.LoadData Exception: {0}", e);
throw e;
}
}
public static DataRule LoadDataInfo(DataTable table, String rulename, String paramvalue, String pageinfo, String defwhere, String dsname)
{
try
{
InParams inparams = SDPClient.NewInParams();
OutParams outparams = SDPClient.NewOutParams();
inparams.SetRequestBody("ServiceName", "DataServices");
inparams.SetRequestBody("ServiceItem", "LoadDataInfo");
inparams.SetRequestBody("RuleName", rulename);
inparams.SetRequestBody("DefWhere", defwhere);
inparams.SetRequestBody("PageInfo", pageinfo);
inparams.SetRequestBody("DataSource", dsname);
inparams.SetRequestParams(paramvalue);
SDPClient.CallService(inparams, outparams);
DataRule rule = new DataRule(rulename, outparams);
SystemContext.RuleManager.AppendDataRule(rule);
DataTable resulttable = outparams.GetTableParam(rulename).GetDataTableValue();
DataUtil.InitTableSchemaFromDataRule(table, rule);
DataUtil.CopyTable(resulttable, table);
return(rule);
}
catch (Exception e)
{
System.Console.Out.WriteLine("DataServices.LoadDataInfo Exception: {0}", e);
throw e;
}
}
/// <summary>
/// 输出参数
/// 不推荐直接访问此属性,用AddOutParam和GetOutPut方法代替
/// </summary>
//public List<DbParameter> OutParams
//{
// get { return _outParams; }
// set { _outParams = value; }
//}
/// <summary>
/// 添加一个输出参数
/// 此参数只支持能转换为string类型
/// </summary>
/// <param name="name"></param>
/// <param name="value"></param>
public void AddOutParam(string name, object value = null)
{
if (OutParams == null)
{
OutParams = new Dictionary <string, object>();
}
name = name.Replace("@", "");
OutParams.Add(name, value);
}
/// <summary>
/// 清除参数
/// 在重复执行SQL时需调用进而重新设定新参数
/// </summary>
public void ClearParams()
{
Params.Clear();
if (OutParams == null)
{
return;
}
OutParams.Clear();// 增加了参数OutParamsPut 单独存储
}
private void button_refreshServer_Click(object sender, EventArgs e)
{
InParams inparams = SDPClient.NewInParams("SystemEnter");
OutParams outparams = SDPClient.NewOutParams();
inparams.SetServiceName("RefreshServices");
CallService(inparams, outparams);
}
private void button_refreshProj_Click(object sender, EventArgs e)
{
InParams inparams = SDPClient.NewInParams(comboBox_proCode.Text.Trim());
OutParams outparams = SDPClient.NewOutParams();
inparams.SetServiceName("RefreshServices");
CallService(inparams, outparams);
}
private void button_serverVer_Click(object sender, EventArgs e)
{
InParams inparams = SDPClient.NewInParams(null);
OutParams outparams = SDPClient.NewOutParams();
inparams.SetServiceName("GetSystemVersion");
CallService(inparams, outparams);
}
private void button_callService_Click(object sender, EventArgs e)
{
InParams inparams = SDPClient.NewInParams(comboBox_proCode.Text.Trim());
OutParams outparams = SDPClient.NewOutParams();
inparams.SetRequestBody(textBox_reqBody.Text.Trim());
inparams.SetRequestParams(textBox_reqParams.Text.Trim());
CallService(inparams, outparams);
}
public void SetRowCount()
{
if (OutParams.IsNotNullOrEmpty())
{
RowCount = (int)OutParams.FirstOrDefault().value;
}
else if (Entities.IsNotNullOrEmpty())
{
RowCount = Entities.Count;
}
}
private void BuildLoginInfo(OutParams outparams)
{
IParam param;
int count = outparams.GetStrParamsCount();
for (int i = 0; i < count; i++)
{
param = outparams.GetStrParam(i);
mProperty.SetProperty(param.GetName(), param.GetStrValue());
}
IsLogin = mProperty.GetStrProperty("LoginResult").Equals("Passed");
}
private void button_datarule_Click(object sender, EventArgs e)
{
InParams inparams = SDPClient.NewInParams(comboBox_proCode.Text.Trim());
OutParams outparams = SDPClient.NewOutParams();
string proCode = comboBox_proCode.Text.Trim();
inparams.SetServiceName("DataRuleServices");
inparams.SetServiceItem("SaveDataRuleToFile");
inparams.SetRequestBody("TargetProCode", proCode);
inparams.SetRequestBody("RuleName", "");
inparams.SetRequestBody("Level", "");
CallService(inparams, outparams);
}
private void Update()
{
if (!generateRoom)
{
return;
}
if (progress == GenerationProgress.START)
{
RandomSeed();
Debug.Log("Starting new generation.");
newParams = new OutParams {
enemySpawns = new List <Transform>()
};
progress = GenerationProgress.WIP;
counter++;
StartCoroutine(CreateRoom());
}
else if (progress == GenerationProgress.WIP)
{
}
else if (progress == GenerationProgress.ERROR)
{
Destroy(newRoom.gameObject);
Debug.Log("GENERATION ERROR!!!");
progress = GenerationProgress.START;
}
else if (progress == GenerationProgress.END)
{
if (generationFailed)
{
progress = GenerationProgress.ERROR;
return;
}
generateRoom = false;
progress = GenerationProgress.IDLE;
Debug.Log($"Generation ended in {counter} attempts.");
if (firstLevel)
{
LoadFirstLevel();
}
}
}
public static string RefreshProject(string procode)
{
try
{
InParams inparams = SDPClient.NewInParams(procode);
OutParams outparams = SDPClient.NewOutParams();
inparams.SetRequestBody("ServiceName", "RefreshServices");
SDPClient.RouteService(inparams, outparams);
return(outparams.GetStrParamValue(0));
}
catch (Exception e)
{
System.Console.Out.WriteLine("CommonServices.RefreshProject Exception: {0}", e);
throw e;
}
}
public static string GetServerDateTime()
{
try
{
InParams inparams = SDPClient.NewInParams();
OutParams outparams = SDPClient.NewOutParams();
inparams.SetRequestBody("ServiceName", "DataExServices");
inparams.SetRequestBody("ServiceItem", "GetServerDateTime");
SDPClient.CallService(inparams, outparams);
return(outparams.GetStrParamValue(0));
}
catch (Exception e)
{
System.Console.Out.WriteLine("DataExServices.GetCommonCodeTable Exception: {0}", e);
throw e;
}
}
public static DataTable GetEquipmentInfo()
{
try
{
InParams inparams = SDPClient.NewInParams();
OutParams outparams = SDPClient.NewOutParams();
inparams.SetRequestBody("ServiceName", "com.sdp.monitor.services.MonitorServices");
inparams.SetRequestBody("ServiceItem", "GetEquipmentInfo");
SDPClient.CallService(inparams, outparams);
return(outparams.GetTableParamValue("EquipmentInfo"));
}
catch (Exception e)
{
System.Console.Out.WriteLine("MonitorServices.GetEquipmentInfo Exception: {0}", e);
throw e;
}
}
public static DataTable GetProjectInfo()
{
try
{
InParams inparams = SDPClient.NewInParams(null);
OutParams outparams = SDPClient.NewOutParams();
inparams.SetRequestBody("ServiceName", "EnterServices");
inparams.SetRequestBody("ServiceItem", "GetProjectNames");
SDPClient.RouteService(inparams, outparams);
return(outparams.GetTableParamValue(0));
}
catch (Exception e)
{
System.Console.Out.WriteLine("CommonServices.GetProCodeTable Exception: {0}", e);
throw e;
}
}
public static bool Logout(string loginId)
{
try
{
InParams inparams = SDPClient.NewInParams();
OutParams outparams = SDPClient.NewOutParams();
inparams.SetRequestBody("ServiceName", "LoginServices");
inparams.SetRequestBody("ServiceItem", "Logout");
inparams.SetRequestBody("CurLoginID", loginId);
SDPClient.CallService(inparams, outparams);
return(outparams.GetStrParamValue("Result").Equals("0"));
}
catch (Exception e)
{
System.Console.Out.WriteLine("LoginServices.Logout Exception: {0}", e);
throw e;
}
}
private void LoadFirstLevel()
{
levelCounter++;
currentRoom = newRoom;
currentParams = newParams;
currentRoom.name = "Room";
currentRoom.localPosition = new Vector3();
navMesh.BuildNavMesh();
spawner.SpawnEnemies(currentParams.enemySpawns.ToArray(), 0.5f);
Transform player = Instantiate(playerPrefab).transform;
player.position = newParams.playerSpawn.position;
firstLevel = false;
GenerateRoom();
}
public static String GetStrValueFromService(String servicename, String serviceitem, String serviceparams)
{
try
{
InParams inparams = SDPClient.NewInParams();
OutParams outparams = SDPClient.NewOutParams();
inparams.SetRequestBody("ServiceName", servicename);
inparams.SetRequestBody("ServiceItem", serviceitem);
inparams.SetRequestParams(serviceparams);
SDPClient.RouteService(inparams, outparams);
return(outparams.GetStrParamValue(0));
}
catch (Exception e)
{
System.Console.Out.WriteLine("CommonServices.GetStrValueFromService Exception: {0}", e);
throw e;
}
}
public static DataTable GetCommonCodeTable()
{
try
{
InParams inparams = SDPClient.NewInParams();
OutParams outparams = SDPClient.NewOutParams();
inparams.SetRequestBody("ServiceName", "DataServices");
inparams.SetRequestBody("ServiceItem", "LoadData");
inparams.SetRequestBody("RuleName", "drGetCommonCode");
SDPClient.RouteService(inparams, outparams);
return(outparams.GetTableParamValue(0));
}
catch (Exception e)
{
System.Console.Out.WriteLine("CommonServices.GetCommonCodeTable Exception: {0}", e);
throw e;
}
}
public static DataRule LoadInfo(string rulename)
{
try
{
InParams inparams = SDPClient.NewInParams();
OutParams outparams = SDPClient.NewOutParams();
inparams.SetRequestBody("ServiceName", "DataServices");
inparams.SetRequestBody("ServiceItem", "LoadInfo");
inparams.SetRequestBody("RuleName", rulename);
SDPClient.CallService(inparams, outparams);
return(new DataRule(rulename, outparams));
}
catch (Exception e)
{
System.Console.Out.WriteLine("DataServices.LoadInfo Exception: {0}", e);
throw e;
}
}
public static long GetSEQNextVal(String seqname)
{
try
{
InParams inparams = SDPClient.NewInParams();
OutParams outparams = SDPClient.NewOutParams();
inparams.SetRequestBody("ServiceName", "DataExServices");
inparams.SetRequestBody("ServiceItem", "GetSEQNextVal");
inparams.SetRequestBody("SEQName", seqname);
SDPClient.CallService(inparams, outparams);
return(Convert.ToInt32(outparams.GetStrParam(0).GetStrValue()));
}
catch (Exception e)
{
System.Console.Out.WriteLine("DataExServices.GetSEQNextVal Exception: {0}", e);
throw e;
}
}
public static bool OpenSql(DataTable table, String sql, String paramvalue, String pageinfo, String dsname)
{
try
{
InParams inparams = SDPClient.NewInParams();
OutParams outparams = SDPClient.NewOutParams();
inparams.SetRequestBody("ServiceName", "DataServices");
inparams.SetRequestBody("ServiceItem", "OpenSql");
inparams.SetRequestBody("SQL", sql);
inparams.SetRequestBody("PageInfo", pageinfo);
inparams.SetRequestBody("DataSource", dsname);
if (TableUtil.IsAutoMetaData(table))
{
inparams.SetRequestBody("AutoMetaData", "1");
}
else
{
inparams.SetRequestBody("TableName", table.TableName);
}
inparams.SetRequestParams(paramvalue);
SDPClient.CallService(inparams, outparams);
DataTable resulttable = outparams.GetTableParam(0).GetDataTableValue();
DataUtil.CopyTable(resulttable, table);
TableUtil.SetProperty(table, "DataSource", outparams.GetStrParamValue("DataSource"));
TableUtil.SetProperty(table, "Command", outparams.GetStrParamValue("Command"));
return(true);
}
catch (Exception e)
{
System.Console.Out.WriteLine("DataServices.OpenSql Exception: {0}", e);
throw e;
}
}
public static DataTable GetTableNames(string proCode, string dsName)
{
try
{
InParams inparams = SDPClient.NewInParams();
OutParams outparams = SDPClient.NewOutParams();
inparams.SetRequestBody("ServiceName", "com.gmcc.sysservices.DataRuleServices");
inparams.SetRequestBody("ServiceItem", "GetTableNames");
inparams.SetRequestBody("ProCode", proCode);
inparams.SetRequestBody("DSName", dsName);
SDPClient.RouteService(inparams, outparams);
return(outparams.GetTableParamValue(0));
}
catch (Exception e)
{
System.Console.Out.WriteLine("DataRuleServices.GetTableNames Exception: {0}", e);
throw e;
}
}
public static int ExecSql(String sql, UpdateCheckTypes checkType)
{
try
{
InParams inparams = SDPClient.NewInParams();
OutParams outparams = SDPClient.NewOutParams();
inparams.SetRequestBody("ServiceName", "DataServices");
inparams.SetRequestBody("ServiceItem", "ExecSql");
inparams.SetRequestBody("SQL", sql);
inparams.SetRequestBody("UpdateCheckType", (int)checkType);
SDPClient.CallService(inparams, outparams);
return(outparams.GetIntParamValue("UpdateRows"));
}
catch (Exception e)
{
System.Console.Out.WriteLine("DataServices.ExecSql Exception: {0}", e);
throw e;
}
}
private bool CallService(InParams inparams, OutParams outparams)
{
DateTime begin = DateTime.Now;
try
{
toolStripStatusLabel_time.Text = "正在调用远程服务，请稍候...";
statusStrip_state.Update();
inparams.SetRouteType(textBox_routeType.Text);
SDPClient.RouteService(inparams, outparams);
toolStripStatusLabel_time.Text = String.Format("远程服务执行成功，耗时：{0:c}", DateTime.Now - begin);
ShowServiceResult(outparams);
return(true);
}
catch (Exception e)
{
toolStripStatusLabel_time.Text = String.Format("远程服务执行失败，耗时：{0:c}", DateTime.Now - begin);
richTextBox_result.Text = String.Format("远程服务执行失败：\n\r{0}", e);
ClearResultPage();
return(false);
}
}
public static void CallService(DataTable table, String servicename, String serviceitem, String paramvalue)
{
try
{
InParams inparams = SDPClient.NewInParams();
OutParams outparams = SDPClient.NewOutParams();
inparams.SetRequestBody("ServiceName", servicename);
inparams.SetRequestBody("ServiceItem", serviceitem);
inparams.SetRequestParams(paramvalue);
SDPClient.CallService(inparams, outparams);
DataTable resulttable = outparams.GetTableParamValue(0);
DataUtil.CopyTable(resulttable, table);
}
catch (Exception e)
{
System.Console.Out.WriteLine("DataServices.CallService Exception: {0}", e);
throw e;
}
}
