// POST api/DepartmentApi/post
public HttpResponseMessage Post([FromBody] string value)
{
string username = UtilFunction.GetCookie("uname");
var list = Newtonsoft.Json.Linq.JObject.Parse(value.Replace("admin", username));
//Newtonsoft.Json.Linq.JArray jArray = new JArray();
Dictionary <string, JArray> dict = new Dictionary <string, JArray>();
string serverName = "";
try
{
FileLog.WriteLog("InfoApiTime：" + DateTime.Now.ToString() + ",调用：QcSystem.ControllersApi/ControllerApi/RoomApiController/Post([FromBody]string value)方法");
if (list != null && list.Count > 0)
{
foreach (var arry in list)
{
switch (arry.Key)
{
case "insert":
serverName = "7_3";
break;
case "update":
serverName = "7_4";
break;
case "delete":
serverName = "7_5";
break;
case "insertRoom":
serverName = "33_11";
break;
case "deleteroom":
serverName = "33_12";
break;
case "roommenulist":
serverName = "33_5";
break;
default:
break;
}
if (serverName.Equals("") == false)
{
dict.Add(serverName, arry.Value as JArray);
}
}
}
if (serverName.Equals("33_1"))
{
return(GetJSONMessage(QueryService.ExecuteScalar(dict)));
}
else
{
return(GetJSONMessage(QueryService.MulteBatch(dict)));
}
}
catch (Exception er)
{
FileLog.WriteLog("Error：调用 QcSystem.ControllersApi/ControllerApi/RoomApiController/Post([FromBody]string value)方法," + er.ToString());
return(GetJSONMessage(""));
}
}
/// <summary>
/// Gets all the recipes the user has saved in their database
/// </summary>
/// <returns></returns>
public async Task <Recipe[]> GetRecipes()
{
var recipes = await _connection.Table <RecipeData>().ToListAsync();
return(UtilFunction.GetRecipesFromID(Convertion.GetIdsFromRecipeData(recipes.ToArray())));
}
private void btnTest_Click(object sender, EventArgs e)
{
UtilFunction.ProcessMathQuestion(" 5 加上 三 + 4");
}
override public void EnterTask(int taskId)
{
base.EnterTask(taskId);
switch (taskId)
{
case 28001: // µ½´ïÁËÂ¥¶¥£¬µØ°åÌ®Ëú
{
Debug.Log(28);
}
break;
case 28002: //Íæ¼Ò×ßµ½±ßÔµºó£¬ó¦Ð·¹Ö·ÉÉÏÀ´
{
GameObject.Find("WarPlatform_Glow").GetComponent <test28Animation>().PlayAnimtion();
CrabManager.Instance.Init();
}
break;
case 28003: //´òËÀó¦Ð·¹Ö£¬³öÏÖ·É´¬
{
}
break;
case 28004: //Íæ¼ÒÌøÉÏ·É´¬£¬·É´¬Æð·É
{
}
break;
case 28005: //ÈÎÎñÍê³É
{
}
break;
case 28006: //ÈÎÎñÍê³É
{
//GameObject.Find("RoofDoor_Collision").GetComponent<Collider>().enabled = false ;
}
break;
case 28007: //ÈÎÎñÍê³É
{
}
break;
case 28008: //ÈÎÎñÍê³É
{
}
break;
case 28009: //ÈÎÎñÍê³É
{
UtilFunction.ResourceLoad("Prefabs/SHP");
}
break;
case 28010: //ÈÎÎñÍê³É
{
PlayerManager.Instance.playerCollider.GetComponent <test12>().Jump();
}
break;
}
}
public void Init()
{
_Fs = UtilFunction.ResourceLoad(FS_PREFAB_PATH);
_fsController = _Fs.GetComponent <FSController>();
_fsController.Init();
}
public void Init()
{
_controlPanel = UtilFunction.ResourceLoad(PREFAB_PATH);
}
public void EnterTask(NPC_StoryConfig task)
{
Debug.Log("Jaycee--当前任务ID" + task.taskId + "---" + task.description);
_curStory = task;
_jayceeAudioController.PlaySound(task.audioId);
_taskStartTime = TimeHelper.GetCurrentRealTimestamp();
if (task.audioId > 0)
{
_audioWaitTime = _jayceeAudioController.GetCurAudioLength(task.audioId);
}
else
{
_audioWaitTime = 0f;
}
switch (jayceeStoryProcess.curTaskID)
{
case 1001: //Jaycee出现
_jayceeHumanController.StartAppear();
FinishCurTaskDelay(0.5f);
break;
case 1002: //走向门口
//_jayceeHumanController.SetTargetPoint(task.targetPos);
//_jayceeHumanController.SetState(JayceeHumanController.JAYCEE_H_STATE.RUN);
FinishCurTask();
break;
case 1003: //回头看
FinishCurTaskImmediately();
break;
case 1004: //向厕所跑
_jayceeHumanController.SetTargetPoint(task.targetPos);
_jayceeHumanController.SetState(JayceeHumanController.JAYCEE_H_STATE.RUN);
break;
case 1005: //在厕所等待玩家,拿起扫把
_isStartDetection = true;
_jayceeHumanController.SetState(JayceeHumanController.JAYCEE_H_STATE.IDLE);
humanState.transform.Rotate(new Vector3(0, 180, 0));
_jayceeHumanController.SetActiveBesom(true);
_jayceeHumanController.isCanRobBesom = true;
TaskStepManagaer.Instance.FinishCurTaskImmediately();
break;
case 1006: //玩家从大厅进门后，说话
_isStartDetection = true;
break;
case 1007: //玩家到达门口，说话
_isStartDetection = true;
break;
case 1008: //进门，打玩家
_isStartDetection = true;
_jayceeHumanController.SetState(JayceeHumanController.JAYCEE_H_STATE.ATTACK);
break;
case 1009: //抢完了扫把，蹲在地上说话
_isStartDetection = true;
_jayceeHumanController.SetState(JayceeHumanController.JAYCEE_H_STATE.CROUCH);
break;
case 1010: //玩家出去之后，到达某一点，跑出去，等玩家
_isStartDetection = true;
_jayceeHumanController.SetCanSkipStep(false);
_jayceeHumanController.SetTargetPoint(task.targetPos);
_jayceeHumanController.SetState(JayceeHumanController.JAYCEE_H_STATE.RUN);
break;
case 1011: //跑向房间
_isStartDetection = true;
_jayceeHumanController.SetCanSkipStep(false);
_jayceeHumanController.SetTargetPoint(task.targetPos);
_jayceeHumanController.SetState(JayceeHumanController.JAYCEE_H_STATE.RUN);
//TaskStepManagaer.Instance.FinishCurTaskImmediately();
break;
case 1012: //玩家到了另一个房间，跑出来
_jayceeHumanController.SetCanSkipStep(true);
_jayceeHumanController.SetTargetPoint(task.targetPos);
_jayceeHumanController.SetState(JayceeHumanController.JAYCEE_H_STATE.RUN);
break;
case 1013: //跑出来之后，骂玩家
_isStartDetection = true;
_jayceeHumanController.SetState(JayceeHumanController.JAYCEE_H_STATE.IDLE);
TaskStepManagaer.Instance.FinishCurTaskImmediately();
break;
case 1014: //玩家走近之后，带领玩家走
FinishCurTaskImmediately();
break;
case 1015: //带玩家走
_jayceeHumanController.SetTarget(_curStory.target.gameObject);
_jayceeHumanController.SetCanSkipStep(true);
_jayceeHumanController.SetTargetPoint(task.targetPos);
_jayceeHumanController.SetState(JayceeHumanController.JAYCEE_H_STATE.LEADER);
TaskStepManagaer.Instance.FinishTaskTo(7001);
break;
case 1016: //楼塌，跳过去
_jayceeHumanController.SetCanSkipStep(false);
_isStartDetection = true;
_jayceeHumanController.SetState(JayceeHumanController.JAYCEE_H_STATE.WALK);
_jayceeHumanController.SetTargetPoint(task.targetPos);
break;
case 1017: //往角落跑
_jayceeHumanController.SetCanSkipStep(true);
_jayceeHumanController.SetState(JayceeHumanController.JAYCEE_H_STATE.WALK);
_jayceeHumanController.SetTargetPoint(task.targetPos);
break;
case 1018: //跑向房间
_jayceeHumanController.SetState(JayceeHumanController.JAYCEE_H_STATE.WALK);
_jayceeHumanController.SetTargetPoint(task.targetPos);
break;
case 1019: //跑向一个房间，关门,等待玩家
_isStartDetection = true;
_jayceeHumanController.SetState(JayceeHumanController.JAYCEE_H_STATE.IDLE);
//FinishCurTaskDelay(0.5f);//test
break;
case 1020: //再次见到玩家，说话
_jayceeHumanController.SetState(JayceeHumanController.JAYCEE_H_STATE.IDLE);
FinishCurTask();
break;
case 1021: //往房间走
_jayceeHumanController.SetTargetPoint(task.targetPos);
_jayceeHumanController.SetTarget(_curStory.target.gameObject);
_jayceeHumanController.SetCanSkipStep(true);
_jayceeHumanController.SetState(JayceeHumanController.JAYCEE_H_STATE.LEADER);
break;
case 1022: //被怪物攻击
//_isStartDetection = true;
break;
case 1023: //怪物被打死之后，继续向房间走
_jayceeHumanController.SetTargetPoint(task.targetPos);
_jayceeHumanController.SetTarget(_curStory.target.gameObject);
_jayceeHumanController.SetCanSkipStep(true);
_jayceeHumanController.SetState(JayceeHumanController.JAYCEE_H_STATE.LEADER);
break;
case 1024: //被怪物攻击
//_isStartDetection = true;
break;
case 1025: //怪物被打死，带领玩家走到柜子旁边
_isStartDetection = true;
_jayceeHumanController.SetTarget(_curStory.target.gameObject);
_jayceeHumanController.SetTargetPoint(task.targetPos);
_jayceeHumanController.SetCanSkipStep(false);
_jayceeHumanController.SetState(JayceeHumanController.JAYCEE_H_STATE.LEADER);
break;
case 1026: //打开柜子
_jayceeHumanController.SetState(JayceeHumanController.JAYCEE_H_STATE.IDLE);
FinishCurTaskDelay(0.5f);
break;
case 1027: //说话
_jayceeHumanController.SetState(JayceeHumanController.JAYCEE_H_STATE.IDLE);
FinishCurTask();
break;
case 1028: //走到另一边
_jayceeHumanController.SetCanSkipStep(true);
_jayceeHumanController.SetTargetPoint(task.targetPos);
_jayceeHumanController.SetState(JayceeHumanController.JAYCEE_H_STATE.WALK);
break;
case 1029: //说话
_jayceeHumanController.SetState(JayceeHumanController.JAYCEE_H_STATE.IDLE);
FinishCurTask();
break;
case 1030: //边走边说，等待玩家拿起注射器
_isStartDetection = true;
_jayceeHumanController.SetCanSkipStep(false);
_jayceeHumanController.SetTargetPoint(task.targetPos);
_jayceeHumanController.SetState(JayceeHumanController.JAYCEE_H_STATE.WALK);
//FinishCurTaskImmediately();//test
break;
case 1031: //玩家拿起了注射器，然后外面发起尖叫,跑出房间，边跑边说
//_isStartDetection = true;
_jayceeHumanController.SetCanSkipStep(true);
_jayceeHumanController.SetTargetPoint(task.targetPos);
_jayceeHumanController.SetState(JayceeHumanController.JAYCEE_H_STATE.RUN);
break;
case 1032: //玩家到达，抱起女孩，说话
//_isStartDetection = true;
//_jayceeHumanController.SetCanSkipStep(true);
_jayceeHumanController.SetState(JayceeHumanController.JAYCEE_H_STATE.IDLE);
FinishCurTask();
break;
case 1033: //跑向房间
_jayceeHumanController.SetCanSkipStep(false);
_jayceeHumanController.SetState(JayceeHumanController.JAYCEE_H_STATE.RUN);
_jayceeHumanController.SetTargetPoint(task.targetPos);
break;
case 1034: //后退，撞墙
_jayceeHumanController.SetCanSkipStep(true);
_jayceeHumanController.SetState(JayceeHumanController.JAYCEE_H_STATE.WALK_BACK);
_jayceeHumanController.SetTargetPoint(task.targetPos);
//FinishCurTaskDelay(3f);//WSM
break;
case 1035: //摔倒
_jayceeHumanController.SetState(JayceeHumanController.JAYCEE_H_STATE.CROUCH);
FinishCurTaskDelay(0.5f);
break;
case 1036: //说话
FinishCurTask();
break;
case 1037: //身体抖动，说话
FinishCurTask();
break;
case 1038: //剧烈抖动，脸变色，说话
FinishCurTask();
break;
case 1039: //变身
humanState.SetActive(false);
monsterState = UtilFunction.ResourceLoad(MONSTER_JAYCEE_PATH);
_jayceeMonsterController = monsterState.GetComponent <JayceeMonsterController>();
break;
case 1040: //起身
FinishCurTask();
break;
case 1041: //打玩家
break;
case 1042: //变boss
break;
case 1043: //追玩家
break;
}
}
// DOWNLOAD api/inputapi/download
public HttpResponseMessage Download([FromBody] Params param)
{
BaseService bs = new BaseService();
UtilFunction uf = new UtilFunction();
if (param.number1 == null || param.number1.Trim().Length == 0)
{
return(GetJSONMessage("{success:'导出失败,请先选择期数!'}"));
}
// 调用存储过程(集团+省)
List <string> list = new List <string>();
list.Add(param.number1);
list.Add(param.number2);
DataSet result = bs.GetDataSetRunProcedure("SP_CollectReportsData2", list, "CollectReports");
result.Tables["CollectReports"].PrimaryKey = new DataColumn[] { result.Tables["CollectReports"].Columns["CITY_NO"] };
// 拆解查询结果
// 保存数据来源、月份
DataSet dsHead = new DataSet();
DataTable tableHead = result.Tables["CollectReports"].Clone();
tableHead.ImportRow(result.Tables["CollectReports"].Rows[0]);
tableHead.ImportRow(result.Tables["CollectReports"].Rows[1]);
dsHead.Tables.Add(tableHead);
// 保存数据主体部分(各城市对应的值)：根据城市名排序，并且将"全网"放到最后
DataSet dsMain = new DataSet();
DataTable tableMain = result.Tables["CollectReports"].Clone();
int length = result.Tables["CollectReports"].Rows.Count;
List <string> city = new List <string>();
bool flag = true;
if (string.IsNullOrEmpty(param.number2)) // 导出所有省
{
city.Add("安徽"); city.Add("北京"); city.Add("福建"); city.Add("甘肃");
city.Add("广东"); city.Add("广西"); city.Add("贵州"); city.Add("海南");
city.Add("河北"); city.Add("河南"); city.Add("黑龙江"); city.Add("湖北");
city.Add("湖南"); city.Add("吉林"); city.Add("江苏"); city.Add("江西");
city.Add("辽宁"); city.Add("内蒙古"); city.Add("宁夏"); city.Add("青海");
city.Add("山东"); city.Add("山西"); city.Add("陕西"); city.Add("上海");
city.Add("四川"); city.Add("天津"); city.Add("西藏"); city.Add("新疆");
city.Add("云南"); city.Add("浙江"); city.Add("重庆"); city.Add("全网");
}
else // 按所选省份导出
{
param.number2 = param.number2.Replace("'", "");
string[] array = param.number2.Split(',');
flag = false;
foreach (string s in array)
{
if (s == "全网")
{
flag = true;
continue;
}
city.Add(s);
}
city.Sort();
if (flag)
{
city.Add("全网");
}
}
foreach (string c in city)
{
flag = true;
for (int i = 2; i < length; i++)
{
DataRow row = result.Tables["CollectReports"].Rows[i];
if (c == row["CITY_NO"].ToString())
{
flag = false;
tableMain.ImportRow(row);
break;
}
}
if (flag)
{
DataRow row = tableMain.NewRow();
row["CITY_NO"] = c;
tableMain.Rows.Add(row);
}
}
dsMain.Tables.Add(tableMain);
// 合并数据来源、月份、主体
dsHead.Merge(dsMain);
// 导出Excel
List <string> tempnames = new List <string>();
//tempnames.Add("(国际)对标指标情况.xlsx");
tempnames.Add("(国内)对标指标情况.xlsx");
tempnames.Add("(业界)对标指标情况.xlsx");
//tempnames.Add("11维度指标梳理情况.xlsx");
tempnames.Add("11维度指标梳理情况v17-6-.xlsx");
// 指标甄核规则
Dictionary <string, DataRow> dicAuditRules = new Dictionary <string, DataRow>();
DataTable tablelist = bs.GetDataTableToID("findAuditRules");
foreach (DataRow row in tablelist.Rows)
{
dicAuditRules.Add(row["Indicatorid"].ToString(), row);
}
// 导出Excel
ExportExcel(tempnames, dsHead, dicAuditRules);
dsHead.Dispose();
tableHead.Dispose();
dsMain.Dispose();
tableMain.Dispose();
list.Clear();
tempnames.Clear();
// 调用存储过程(地市)
list.Add(param.number1);
list.Add("'" + string.Join("','", city) + "'");
DataSet result2 = bs.GetDataSetRunProcedure("SP_CollectReportsData3", list, "CollectReports");
result2.Tables["CollectReports"].PrimaryKey = new DataColumn[] { result2.Tables["CollectReports"].Columns["CITY_NO"] };
// 拆解查询结果
// 保存数据来源、月份
DataSet dsHead2 = new DataSet();
DataTable tableHead2 = result2.Tables["CollectReports"].Clone();
tableHead2.ImportRow(result.Tables["CollectReports"].Rows[0]);
tableHead2.ImportRow(result.Tables["CollectReports"].Rows[1]);
dsHead2.Tables.Add(tableHead2);
// 保存数据主体部分(各城市对应的值)：根据城市名排序，并且将"全网"放到最后
DataSet dsMain2 = new DataSet();
DataTable tableMain2 = result2.Tables["CollectReports"].Clone();
length = result2.Tables["CollectReports"].Rows.Count;
DataTable dtCity = null;
string getCityByProvince = "getCityByProvince";
foreach (string c in city)
{
dtCity = bs.GetResult(bs.getSQL(getCityByProvince, c));
dtCity.PrimaryKey = new DataColumn[] { dtCity.Columns["name"] };
tableMain2.ImportRow(result.Tables["CollectReports"].Rows.Find(c));
for (int i = 0; i < length; i++)
{
DataRow row = result2.Tables["CollectReports"].Rows[i];
if (dtCity.Rows.Contains(row["CITY_NO"].ToString()))
{
tableMain2.ImportRow(row);
}
}
}
dsMain2.Tables.Add(tableMain2);
// 合并数据来源、月份、主体
dsHead2.Merge(dsMain2);
tempnames.Add("省报地市指标情况.xlsx");
// 导出Excel
ExportExcel(tempnames, dsHead2, dicAuditRules);
string message = "{success:'导出成功,请到右上角下载中心下载'}";
return(GetJSONMessage(message));
}
public void UpdateFrontRay()
{
if (Input.GetKeyDown(KeyCode.E))
{
if (TaskStepManagaer.Instance.IsEqualTaskId(28005))
{
GameObject go = GameObject.CreatePrimitive(PrimitiveType.Sphere);
go.transform.position = GameObject.Find("Cube1").transform.position;
go.transform.localScale = new Vector3(2, 2, 2);
}
}
if (Input.GetMouseButtonDown(0))
{
ray = Camera.main.ScreenPointToRay(new Vector3(Screen.width / 2, Screen.height / 2, 0));//射线
RaycastHit hitInfo;
if (Physics.Raycast(ray, out hitInfo, 100f, rayLayer))
{
//if (PlayerPickupDetection.isb)
PickUp(hitInfo.transform);
{
if (hitInfo.transform.name == "muyuanzhuoL1")
{
hitInfo.transform.position = new Vector3(7.157f, 1.054068f, 19f);
}
if (hitInfo.transform.name == "F4_1")
{
Level_04_Manager.Instance.HaveKey = true;
DoorManager.Instance.level_04_Door_Script[17].CanOpen = true;
Destroy(hitInfo.transform.gameObject);
}
if (hitInfo.transform.name == "F4_7")
{
can_4_7 = true;
DoorManager.Instance.level_04_Door_Script[7].CanOpen = true;
Destroy(hitInfo.transform.gameObject);
}
Debug.DrawRay(ray.origin, hitInfo.point, Color.yellow);
if (hitInfo.transform == null)
{
Destroy(this.gameObject);
return;
}
if (hitInfo.transform.name == "knapsack")
{
GameObject.Destroy(hitInfo.transform.gameObject);
}
if (hitInfo.transform.name == "Health_Box")
{
GameObject.Destroy(hitInfo.transform.gameObject);
}
if (hitInfo.transform.name == "Wood3")
{
hitInfo.transform.GetComponent <ChangeLayerToGroup>().ChangePos();
}
if (hitInfo.transform.name == "Grenade")
{
GameObject.Destroy(hitInfo.transform.gameObject);
}
if (hitInfo.transform.name == "StonePillars")
{
hitInfo.transform.GetComponent <test17>().qwe();
}
if (hitInfo.transform.name == "SY1_qiang4" && (TaskStepManagaer.Instance.IsEqualTaskId(3003) || TaskStepManagaer.Instance.IsEqualTaskId(3006)))
{
if (can_1_6)
{
hitInfo.transform.GetComponent <OpenL1Door>().OpenTheDoor();
}
else
{
hitInfo.transform.GetComponent <ClickNextTask>().NextTask();
}
}
if (hitInfo.transform.name == "bijiben21" && TaskStepManagaer.Instance.IsEqualTaskId(3004))
{
hitInfo.transform.GetComponent <test5>().qwe();
}
if (hitInfo.transform.name == "bijiben2")
{
hitInfo.transform.GetComponent <ClickNextTask>().NextTask();
}
if (hitInfo.transform.name == "DianTi_B_KaiGuan_B" && TaskStepManagaer.Instance.IsEqualTaskId(19006))
{
hitInfo.transform.GetComponent <testRiddle>().ShowRiddle();
}
if (hitInfo.transform.name == "panel" && TaskStepManagaer.Instance.IsEqualTaskId(3005))
{
hitInfo.transform.GetComponent <test5>().qwe();
}
if (hitInfo.transform.name == "key")
{
can_1_6 = true;
Destroy(hitInfo.transform.gameObject);
}
if (hitInfo.transform.name == "L13key(Clone)")
{
can_13_1 = true;
Destroy(hitInfo.transform.gameObject);
}
if (hitInfo.transform.name == "L18key(Clone)")
{
can_18_5 = true;
Destroy(GameObject.Find("18wall"));
Destroy(hitInfo.transform.gameObject);
}
if (hitInfo.transform.name == "L18key (1)")
{
can_18_4 = true;
Destroy(hitInfo.transform.gameObject);
}
if (hitInfo.transform.parent)
{
if (hitInfo.transform.parent.name == "hongseguizi2 (18)" && TaskStepManagaer.Instance.IsEqualTaskId(25001))
{
hitInfo.transform.parent.GetComponent <testGuiZiMove>().Move();
}
if (hitInfo.transform.parent.name == "TongXunTa" && can_21_6 && TaskStepManagaer.Instance.IsEqualTaskId(28007))
{
can_21_6 = false;
hitInfo.transform.parent.gameObject.SetActive(false);
UtilFunction.ResourceLoadOnPosition("Effects/BrokenFx/Scene_Model/Object/Scene2/TongXunTa_FX", hitInfo.transform.parent.position, hitInfo.transform.parent.rotation);
TaskStepManagaer.Instance.FinishCurTaskImmediately();
}
}
if (hitInfo.transform.name == "Bashou7" && TaskStepManagaer.Instance.IsEqualTaskId(28003))
{
hitInfo.transform.position = new Vector3(hitInfo.transform.position.x, hitInfo.transform.position.y + 0.1f, hitInfo.transform.position.z);
hitInfo.transform.parent.parent.parent.Find("KongZhiTai3").DOMoveY(-0.4f, 3);
TaskStepManagaer.Instance.FinishCurTaskImmediately();
}
if (hitInfo.transform.name == "Dial6" && TaskStepManagaer.Instance.IsEqualTaskId(28003))
{
hitInfo.transform.DORotate(new Vector3(0, -90, 0), 1);
hitInfo.transform.parent.parent.parent.Find("KongZhiTai3").DOLocalMoveY(0f, 5);
TaskStepManagaer.Instance.FinishCurTaskImmediately();
}
if (hitInfo.transform.name == "DianNao_71")
{
hitInfo.transform.GetComponent <testPWD>().QWE();
}
if (hitInfo.transform.name == "panel (1)" && TaskStepManagaer.Instance.IsEqualTaskId(4003))
{
hitInfo.transform.GetComponent <test5>().qwe();
}
if (hitInfo.transform.name == "DT_KaiGuan 8" && TaskStepManagaer.Instance.IsEqualTaskId(4005))
{
hitInfo.transform.GetComponent <ClickNextTask>().NextTask();
}
if (hitInfo.transform.name == "SY_3_JiSuanQi")
{
GameObject.Find("KongZhiTai/KongZhiTai_2").transform.DOLocalMoveY(0f, 5);
PlaySoundController.Instance.PlaySoundEffect(hitInfo.transform.gameObject, 10001);
}
if (hitInfo.transform.name == "Pao_Gun")
{
can_21_6 = true;
Destroy(hitInfo.transform.gameObject);
}
if (hitInfo.transform.name == "WarPlatform_D" && can_21_6 && TaskStepManagaer.Instance.IsEqualTaskId(28008))
{
can_21_6 = false;
UtilFunction.ResourceLoad("Effects/BrokenFx/WarPlatform_D_Collision");
Destroy(hitInfo.transform.gameObject);
TaskStepManagaer.Instance.FinishCurTaskImmediately();
}
if (hitInfo.transform.name == "bijiben28")
{
PlaySoundController.Instance.PlaySoundEffect(hitInfo.transform.gameObject, 10001);
hitInfo.transform.GetComponent <test5>().qwe();
}
if (hitInfo.transform.name.Contains("ElectricAntenna3"))
{
if (!hitInfo.transform.GetComponent <testElectricute>().isb)
{
hitInfo.transform.gameObject.SetActive(false);
testElectricute.qwe();
}
}
//if (TaskStepManagaer.Instance.IsEqualTaskId(28002) && is_21_5_0 && is_21_5_1 && is_21_5_2 && is_21_5_3 && can_21_4)
{
if (hitInfo.transform.name == "KongZhiTai_Button_1" && can_21_4)
{
hitInfo.transform.GetComponent <testBlue>().qwe();
GameObject.Find("curve_sin_back").GetComponent <CurveSin123>().setI(1);
}
if (hitInfo.transform.name == "KongZhiTai_Button_2" && can_21_4)
{
hitInfo.transform.GetComponent <testBlue>().qwe();
GameObject.Find("curve_sin_back").GetComponent <CurveSin123>().setI(2);
}
if (hitInfo.transform.name == "KongZhiTai_Button_3" && can_21_4)
{
hitInfo.transform.GetComponent <testBlue>().qwe();
GameObject.Find("curve_sin_back").GetComponent <CurveSin123>().setI(0);
}
}
if (hitInfo.transform.name == "KongZhiTai" && !can_21_2)
{
can_21_2 = true;
TaskStepManagaer.Instance.FinishCurTaskImmediately();
}
if (hitInfo.transform.name == "EX_4F_Door_Big_A1")
{
if (can_4_1)
{
hitInfo.transform.GetComponent <OpenDoor>().OpenTheSlidingDoor();
}
//hitInfo.transform.GetComponent<test16>().qwe();
}
if (hitInfo.transform.name == "ElectricAntenna5")
{
if (testElectricute.ist && !is_21_5_0)
{
is_21_5_0 = true;
testElectricute.ewq();
GameObject go1 = UtilFunction.ResourceLoadOnPosition("Prefabs/Tools/ElectricAntenna3", new Vector3(hitInfo.transform.parent.Find("ElectricAntenna2").position.x, hitInfo.transform.parent.Find("ElectricAntenna2").position.y + 2, hitInfo.transform.parent.Find("ElectricAntenna2").position.z), Quaternion.identity);
go1.transform.GetComponent <testElectricute>().setB(true);
}
}
if (hitInfo.transform.name == "Detonator")
{
can_21_3 = true;
Destroy(hitInfo.transform.gameObject);
}
if (hitInfo.transform.name == "ElectricAntenna6")
{
if (testElectricute.ist && !is_21_5_1)
{
is_21_5_1 = true;
testElectricute.ewq();
GameObject go1 = UtilFunction.ResourceLoadOnPosition("Prefabs/Tools/ElectricAntenna3", new Vector3(hitInfo.transform.parent.Find("ElectricAntenna2").position.x, hitInfo.transform.parent.Find("ElectricAntenna2").position.y + 2, hitInfo.transform.parent.Find("ElectricAntenna2").position.z), Quaternion.identity);
go1.transform.GetComponent <testElectricute>().setB(true);
}
}
if (hitInfo.transform.name == "ElectricAntenna7")
{
if (testElectricute.ist && !is_21_5_2)
{
is_21_5_2 = true;
testElectricute.ewq();
GameObject go1 = UtilFunction.ResourceLoadOnPosition("Prefabs/Tools/ElectricAntenna3", new Vector3(hitInfo.transform.parent.Find("ElectricAntenna2").position.x, hitInfo.transform.parent.Find("ElectricAntenna2").position.y + 2, hitInfo.transform.parent.Find("ElectricAntenna2").position.z), Quaternion.identity);
go1.transform.GetComponent <testElectricute>().setB(true);
}
}
if (hitInfo.transform.name == "ElectricAntenna8")
{
if (testElectricute.ist && !is_21_5_3)
{
is_21_5_3 = true;
testElectricute.ewq();
GameObject go1 = UtilFunction.ResourceLoadOnPosition("Prefabs/Tools/ElectricAntenna3", new Vector3(hitInfo.transform.parent.Find("ElectricAntenna2").position.x, hitInfo.transform.parent.Find("ElectricAntenna2").position.y + 2, hitInfo.transform.parent.Find("ElectricAntenna2").position.z), Quaternion.identity);
go1.transform.GetComponent <testElectricute>().setB(true);
}
}
if (hitInfo.transform.name == "Cube12" && !can_21_4 && is_21_5_0 && is_21_5_1 && is_21_5_2 && is_21_5_3)
{
can_21_4 = true;
UtilFunction.ResourceLoadOnPosition("Prefabs/Tools/XinHaoQi", hitInfo.point, Quaternion.identity);
}
if (hitInfo.transform.tag.Contains("Pickup"))
{
GameObject.Destroy(hitInfo.transform.gameObject);
}
if (hitInfo.transform.name.Contains("Notes"))
{
hitInfo.transform.GetComponent <testLookZiLiao>().qwe();
}
if (hitInfo.transform.name.Contains("Men_MianBan 1"))
{
PlaySoundController.Instance.PlaySoundEffect(hitInfo.transform.gameObject, 10001);
can_4_1 = true;
}
if (hitInfo.transform.name == "EX_4F_Door_Big_B1")
{
hitInfo.transform.GetComponent <OpenDoor>().OpenTheSlidingDoor();
//hitInfo.transform.GetComponent<test16>().qwe();
}
if (hitInfo.transform.name == "ID_Key")
{
can_4_4 = true;
GameObject.Destroy(hitInfo.transform.gameObject);
}
if (hitInfo.transform.name == "Computer_B_Keyboard_1")
{
if (TaskStepManagaer.Instance.IsEqualTaskId(19003))
{
//hitInfo.transform.GetComponent<testL10Pwd>().OpenTV("Power0");
Level_10_Manager.Instance.ShowTV();
}
//if (TaskStepManagaer.Instance.IsEqualTaskId(19004))
//{
// TaskStepManagaer.Instance.FinishCurTaskImmediately();
// hitInfo.transform.GetComponent<testL10Pwd>().OpenTV("Power4");
//}
}
if (hitInfo.transform.name == "reshuihu (106)" && TaskStepManagaer.Instance.IsEqualTaskId(19005))
{
if (!testControllerSog.isDeath)
{
hitInfo.transform.GetComponent <testChangePlayer>().qwe();
}
}
if (hitInfo.transform.name == "DianTi_B_KeyHole")
{
hitInfo.transform.GetComponent <testOpenElevator>().OpenElevator();
}
if (hitInfo.transform.name == "EX_5A_Double_Door_L")
{
switch (hitInfo.transform.GetComponent <OpenDoor>().lockDoor)
{
case OpenDoor.Lock.none:
{
hitInfo.transform.GetComponent <OpenDoor>().islockDoor = false;
hitInfo.transform.GetComponent <OpenDoor>().OpenTheDoubleDoorLeft();
}
break;
case OpenDoor.Lock.key1:
{
if (can_4_4)
{
hitInfo.transform.GetComponent <OpenDoor>().islockDoor = false;
hitInfo.transform.GetComponent <OpenDoor>().OpenTheDoubleDoorLeft();
}
}
break;
case OpenDoor.Lock.key2:
{
if (can_4_9)
{
hitInfo.transform.GetComponent <OpenDoor>().islockDoor = false;
hitInfo.transform.GetComponent <OpenDoor>().OpenTheDoubleDoorLeft();
}
}
break;
default:
break;
}
}
if (hitInfo.transform.name == "EX_5A_Double_Door_R")
{
switch (hitInfo.transform.GetComponent <OpenDoor>().lockDoor)
{
case OpenDoor.Lock.none:
{
hitInfo.transform.GetComponent <OpenDoor>().OpenTheDoubleDoorRight();
}
break;
case OpenDoor.Lock.key1:
{
if (can_4_4)
{
hitInfo.transform.GetComponent <OpenDoor>().islockDoor = false;
hitInfo.transform.GetComponent <OpenDoor>().OpenTheDoubleDoorRight();
}
}
break;
case OpenDoor.Lock.key2:
{
if (can_4_9)
{
hitInfo.transform.GetComponent <OpenDoor>().islockDoor = false;
hitInfo.transform.GetComponent <OpenDoor>().OpenTheDoubleDoorRight();
}
}
break;
default:
break;
}
}
if (hitInfo.transform.name == "EX_5C_18F_Door_13" && TaskStepManagaer.Instance.IsEqualTaskId(20001))
{
TaskStepManagaer.Instance.FinishTaskTo(20002);
}
if (hitInfo.transform.name.Contains("EX_5A_Door"))
{
switch (hitInfo.transform.GetComponent <OpenDoor>().lockDoor)
{
case OpenDoor.Lock.none:
hitInfo.transform.GetComponent <OpenDoor>().OpenTheDoor();
break;
case OpenDoor.Lock.key1:
hitInfo.transform.GetComponent <OpenDoor>().islockDoor = false;
hitInfo.transform.GetComponent <OpenDoor>().OpenTheDoor();
break;
case OpenDoor.Lock.key2:
if (can_4_9)
{
hitInfo.transform.GetComponent <OpenDoor>().islockDoor = false;
hitInfo.transform.GetComponent <OpenDoor>().OpenTheDoor();
}
break;
case OpenDoor.Lock.key3:
{
if (can_4_7)
{
hitInfo.transform.GetComponent <OpenDoor>().islockDoor = false;
hitInfo.transform.GetComponent <OpenDoor>().OpenTheDoor();
}
}
break;
case OpenDoor.Lock.key4:
{
if (can_18_4)
{
hitInfo.transform.GetComponent <OpenDoor>().islockDoor = false;
hitInfo.transform.GetComponent <OpenDoor>().OpenTheDoor();
}
}
break;
default:
break;
}
}
if (hitInfo.transform.name.Contains("Standby"))
{
hitInfo.transform.GetComponent <SymbolNew>().SetIsTarget();
}
}
//if (hitInfo.transform.root.name == "SogBoss_1F Root(Clone)")
//{
// hitInfo.transform.root.Find("SogBoss_1F").GetComponent<SogBossController>().OnHurt(10);
//}
//if (hitInfo.transform.name == "18SOG (1)")
//{
// hitInfo.transform.GetComponent<testL18Boss>().ShouShang(1);
//}
//if (hitInfo.transform.name == "SOG")
//{
// hitInfo.transform.GetComponent<testZSQ>().ShoShang(1);
//}
//if (hitInfo.transform.name.Contains("Jaycee"))
//{
// JayceeManager.Instance.jayceeHumanController.RobBesom();
//}
//if (hitInfo.transform.name == "meidikongtiao")
//{
// hitInfo.transform.GetComponent<tset>().flash();
//}
//if (hitInfo.transform.name == "ZMB_1")
//{
// hitInfo.transform.GetComponent<testZMB>().ShoShang(1);
//}
//if (hitInfo.transform.root.name == "Crab")
//{
// if (testCrab.isb || !TaskStepManagaer.Instance.IsEqualTaskId(28005))
// {
// return;
// }
// hitInfo.transform.root.GetComponent<CrabController>().OnHurt(1);
//}
if (hitInfo.transform.name == "Capsule123")
{
if (can_1_7)
{
PlayerManager.Instance.playerCollider.GetComponent <test12>().UseTheTools1(hitInfo.transform.gameObject);
}
//hitInfo.transform.GetComponent<test16>().qwe();
}
}
}
}
private bool PoSui_DiMian = false; //地面
#endregion
#region ---------调用方法----------
public void Init()
{
GameObject go2 = GameObject.Find("SA_INT");
GameObject go = UtilFunction.ResourceLoad("Prefabs/WSM/Level05GameObjectManager");
playerGO = GameObject.Find("ThirdPersonController"); //TODO
FreeLookCameraRig = GameObject.Find("FreeLookCameraRig").transform;
m_FreeLookCam = FreeLookCameraRig.GetComponent <FreeLookCam>();
m_ProtectCameraFromWallClip = FreeLookCameraRig.GetComponent <ProtectCameraFromWallClip>();
PlayerPositions = new Transform[go.transform.Find("PlayerPosition").childCount];
for (int i = 0; i < PlayerPositions.Length; i++)
{
PlayerPositions[i] = go.transform.Find("PlayerPosition").GetChild(i);
}
TaskPosition = new Transform[go.transform.Find("Task").childCount];
for (int i = 0; i < TaskPosition.Length; i++)
{
TaskPosition[i] = go.transform.Find("Task").GetChild(i);
}
//楼梯
LouTi_5_1_PoSui = go2.transform.Find("SA_Exterior_5/EX_5A_Indoor/EX_5B_Indoor_4F/EX_5B_4F_Stairs/EX_5A_4F_Stairs_B/F4_Stairs_Collision").gameObject;
LouTi_5_1_PoSuiAnimator = LouTi_5_1_PoSui.GetComponent <Animator>();
LouTi_5_1_Collider = go2.transform.Find("WALL_Collider/4F/Stairs/PoSuiTiZi").gameObject;
LouTi_5_1_Model = GameObject.Find("LoTi_5_1");
//LouTi_5_1_Collider = go.transform.Find("LouTi_5_1_Collider").gameObject;
DiBan_F5_4PlSun = go2.transform.Find("SA_Exterior_5/EX_5A_Indoor/EX_5B_Indoor_5F/EX_5B_5F_Floor/F5_Floor_Collision").gameObject;
DiBan_F5_4Animator = DiBan_F5_4PlSun.GetComponent <Animator>();
//地板
//DiBan_F5_4_Model = GameObject.Find("EX_5B_5F_Floor1");
DiBan_F5_4_Collider = go.transform.Find("LouTi_5_1_Collider").gameObject;
TiZi_F5_25_Model = GameObject.Find("LouTi_1");
TiZi_F5_25_Collider_Ground = GameObject.Find("F5_25_Ground");
TiZi_F5_25_Collider_Wall = GameObject.Find("F5_25_Wall");
Radio_GameObject = go.transform.Find("Radio").gameObject;
Radio_Script = Radio_GameObject.GetComponent <Level5_Radio>();
Radio_Script.Init();
F5_16Zomeber = go.transform.Find("Enemy/F5_16_Zomber").gameObject;
F5_16ZomeberScript = F5_16Zomeber.GetComponent <Zomber_F5_16>();
F5_16ZomeberScript.Init();
F5_6_Zomber = go.transform.Find("Enemy/F5_06_Zomber").gameObject;
F5_6_Zomber_Script = F5_6_Zomber.GetComponent <Zomber_5F_6>();
F5_13_Zomber = go.transform.Find("Enemy/F5_13_Zomber").gameObject;
F5_13_Zomber_Script = F5_13_Zomber.GetComponent <Zomber_5F_6>();
LianTiao = go.transform.Find("WanZhengSuoLian").gameObject;
JuanLianMen = GameObject.Find("EX_5B_5F_Curtain_2");
X_Window = GameObject.Find("EX_5B_5F_Window_2");
X_WindowScript = X_Window.GetComponent <OpenDoor_WSM>();
JayceeMonster_TiZi = go.transform.Find("Enemy/JayceeBoss_2").gameObject;
JayceeMonster_TiZi_Script = JayceeMonster_TiZi.GetComponent <Level_05_JayceeBoss_2>();
JayceeMonster_TiZi.SetActive(false);
F5_21_Hint = GameObject.Find("F5_21_Hint");
Show_F5_21_Hint(false);
CanLevel5 = true;
}
// POST api/userapi/post
public HttpResponseMessage Post([FromBody] string value)
{
string username = UtilFunction.GetCookie("uname");
var list = Newtonsoft.Json.Linq.JObject.Parse(value.Replace("{admin}", username));
//Newtonsoft.Json.Linq.JArray jArray = new JArray();
Dictionary <string, JArray> dict = new Dictionary <string, JArray>();
try
{
FileLog.WriteLog("InfoApiTime：" + DateTime.Now.ToString() + ",调用：QcSystem.ControllersApi/ControllerApi/UserApiController/Post([FromBody]string value)方法");
string serverName = "";
Newtonsoft.Json.Linq.JArray jArray = new JArray();
if (list != null && list.Count > 0)
{
foreach (var arry in list)
{
switch (arry.Key)
{
case "insert":
serverName = "1_1";
break;
case "update":
serverName = "1_4";
break;
case "updateinfo":
serverName = "1_4_1";
break;
case "delete":
serverName = "1_8";
break;
case "insertroleindicator":
serverName = "1_11";
try
{
JObject model = JObject.FromObject(JsonConvert.DeserializeObject(arry.Value[0].ToString()));
string wsql = string.Empty;
int userid = Convert.ToInt32(model["userid"].ToString());
string indicatorcontent = model["indicatorcontent"].ToString();
wsql = GetSetStringIndicator(indicatorcontent);
// PostCreateUserTemplate(userid, wsql);
}
catch (Exception ex)
{
FileLog.WriteLog("Error：调用 QcSystem.ControllersApi/ControllerApi/UserApiController/Post([FromBody]string value)方法-用户生成模板错误," + ex.ToString());
}
break;
case "insertroomindicator":
serverName = "1_1122";
break;
case "deleteroomindicator":
serverName = "1_1133";
break;
case "maxid":
serverName = "1_12";
break;
case "insertindicators":
serverName = "1_17";
break;
case "deleteindicators":
serverName = "1_18";
break;
try
{
JObject model = JObject.FromObject(JsonConvert.DeserializeObject(arry.Value[0].ToString()));
string wsql = string.Empty;
int userid = Convert.ToInt32(model["userid"].ToString());
string indicatorcontent = model["indicatorcontent"].ToString();
wsql = GetSetStringIndicator(indicatorcontent);
// PostCreateUserTemplate(userid, wsql);
}
catch (Exception ex)
{
FileLog.WriteLog("Error：调用 QcSystem.ControllersApi/ControllerApi/UserApiController/Post([FromBody]string value)方法-用户生成模板错误," + ex.ToString());
}
break;
case "updatepwd":
serverName = "1_16";
break;
default:
break;
}
jArray = arry.Value as JArray;
}
}
if (serverName.Equals("1_12"))
{
return(GetJSONMessage(QueryService.GetData(list, serverName)));
}
else
{
return(GetJSONMessage(QueryService.InsertBatchCheck(jArray, serverName)));
}
}
catch (Exception er)
{
FileLog.WriteLog("Error：调用 QcSystem.ControllersApi/ControllerApi/UserApiController/Post([FromBody]string value)方法," + er.ToString());
return(GetJSONMessage(""));
}
}
//下载列表管理
//GET:/SysManager/DownloadListManager
public ActionResult DownloadListManager()
{
ViewBag.userid = UtilFunction.GetCookie("uid");
return(View());
}
public override void UpdateTask(int taskId)
{
base.UpdateTask(taskId);
switch (taskId)
{
case 9001: //第五层 Boss战之前
{
Level_05_Manager.Instance.UpdateJayceeOpenDoor();
Level_05_Manager.Instance.UpdateRadio();
Level_05_Manager.Instance.UpdateEnemy();
Level_05_Manager.Instance.UpdatePoSui();
if (true) //TODO Jaycee死了
{
TaskStepManagaer.Instance.FinishCurTask();
}
}
break;
case 9002: //第五层 Boss战之后
{
Level_05_Manager.Instance.UpdateJayceeOpenDoor();
Level_05_Manager.Instance.UpdateRadio();
Level_05_Manager.Instance.UpdateEnemy();
Level_05_Manager.Instance.UpdatePoSui();
if (UtilFunction.IsReachDistanceXYZ(Level_05_Manager.Instance.playerGO.transform.position, Level_05_Manager.Instance.TaskPosition[5].position, 1))
{
TaskStepManagaer.Instance.FinishCurTask();
}
}
break;
case 9003: //第五层 到达楼梯口
{
Level_05_Manager.Instance.UpdateJayceeOpenDoor();
Level_05_Manager.Instance.UpdateRadio();
Level_05_Manager.Instance.UpdateEnemy();
Level_05_Manager.Instance.UpdatePoSui();
if (UtilFunction.IsReachDistanceXYZ(Level_05_Manager.Instance.playerGO.transform.position, Level_05_Manager.Instance.TaskPosition[6].position, 1))
{
TaskStepManagaer.Instance.FinishCurTask();
}
}
break;
case 9004: //第十层 开始
{
//TaskStepManagaer.Instance.FinishCurTask();
Level_10_Manager.Instance.NPC_Distance();
if (UtilFunction.IsReachDistanceXYZ(Level_10_Manager.Instance.playerGO.transform.position, Level_10_Manager.Instance.TaskPosition[1].position, 1))
{
TaskStepManagaer.Instance.FinishCurTask();
}
}
break;
case 9005: //第十层 触发NPC剧情后
{
Level_10_Manager.Instance.UpdateJiQiRen();
Level_10_Manager.Instance.NPC_Distance();
if (UtilFunction.IsReachDistanceXYZ(Level_10_Manager.Instance.playerGO.transform.position, Level_10_Manager.Instance.TaskPosition[3].position, 1))
{
TaskStepManagaer.Instance.FinishCurTask();
}
}
break;
case 10001: //第十层 到达Rick房间
{
Level_10_Manager.Instance.UpdateBeiZa();
Level_10_Manager.Instance.UpdateTiShiZhiYao();
if (Level_10_Manager.Instance.CompletePharmaceutical)
{
TaskStepManagaer.Instance.FinishCurTask();
}
}
break;
case 10002: //第十层 制药完成
{
Level_10_Manager.Instance.UpdatFS();
if (Level_10_Manager.Instance.firstKO_SF)
{
TaskStepManagaer.Instance.FinishCurTask();
}
}
break;
case 10003: //第十层 FS_1 完成
{
if (Level_10_Manager.Instance.CompletePuzzle)
{
TaskStepManagaer.Instance.FinishCurTask();
}
}
break;
case 10004: //第十层 谜题完成
{
if (UtilFunction.IsReachDistanceXYZ(Level_10_Manager.Instance.playerGO.transform.position, Level_10_Manager.Instance.TaskPosition[8].position, 2))
{
TaskStepManagaer.Instance.FinishCurTask();
}
}
break;
case 10005: //第十层 回到NPC门口
{
if (UtilFunction.IsReachDistanceXYZ(Level_10_Manager.Instance.playerGO.transform.position, Level_10_Manager.Instance.TaskPosition[9].position, 2))
{
TaskStepManagaer.Instance.FinishCurTask();
}
}
break;
case 10006: //第十层 打开门
{
Level_10_Manager.Instance.GenerateCRI();
if (UtilFunction.IsReachDistanceXYZ(Level_10_Manager.Instance.playerGO.transform.position, Level_10_Manager.Instance.TaskPosition[10].position, 2))
{
TaskStepManagaer.Instance.FinishCurTask();
}
}
break;
case 10007: //第十层 离开第十层
{
}
break;
default:
break;
}
}
// 上传数据模板
// POST api/inputapi/upload
public Object upload()
{
System.Web.HttpFileCollection _file = System.Web.HttpContext.Current.Request.Files;
int count = 0;
if (_file.Count > 0)
{
for (int i = 0; i < _file.Count; i++)
{
//文件大小
//long size = _file[i].ContentLength;
//文件类型
//string type = _file[i].ContentType;
//文件名
string _filename = _file[i].FileName;
//文件格式
string _tp = System.IO.Path.GetExtension(_filename);
if (_tp.ToLower() == ".xlsx")
{
BaseService bs = new BaseService();
string userid = UtilFunction.GetCookie("uid");
string username = UtilFunction.GetCookie("uname");
string _directory2 = "UploadFiles/" + username;
string path = _directory + _directory2;
string key = null;
List <Object> parames = new List <Object>();
Dictionary <string, List <Object> > map = new Dictionary <string, List <Object> >();
//获取文件流
//System.IO.Stream stream = _file[i].InputStream;
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
path += "/" + _filename;
if (File.Exists(path)) // 如果当前用户下已有同名文件，则执行update操作
{
key = "updateFileInfo";
parames.Add(DateTime.Now);
parames.Add(userid);
parames.Add(username);
parames.Add(_filename);
parames.Add(userid);
}
else // insert
{
key = "insertFileInfo";
parames.Add(_filename);
parames.Add(_directory2);
parames.Add(DateTime.Now);
parames.Add(userid);
parames.Add(username);
}
map.Add(key, parames);
// 上传文件
_file[i].SaveAs(path);
XSSFWorkbook workbook = new XSSFWorkbook(_file[i].InputStream);
int index = workbook.GetSheetIndex("填写模板");
if (index > -1)
{
// 上传记录入库
count = bs.InsUpdDelDataTableToParam(map);
}
else
{
File.Delete(path);
return(new { error = "《" + _filename + "》文件中必须有一个sheet名叫“填写模板”!" });
}
}
else
{
return(new { error = "《" + _filename + "》只允许上传后缀为.xlsx的文件!" });
}
}
}
if (count > 0)
{
return(new { msg = "数据模板上传成功!" });
}
else
{
return(new { error = "数据模板上传失败!" });
}
}
public void Init()
{
_sogBoss = UtilFunction.ResourceLoad(SOG_BOSS);
_sogBossController = _sogBoss.transform.Find("SogBoss_1F").GetComponent <SogBossController>();
_sogBossController.Init();
}
/// <summary>获取数据模板管理列表</summary>
/// <param name="param"></param>
/// <returns></returns>
// GET api/inputapi/post
public HttpResponseMessage Post([FromBody] FileInfo param)
{
UtilFunction uf = new UtilFunction();
/*BaseService bs = new BaseService();
* // 获取检索输入框的值(文件名)
* string filename = "";
* if (param.fileName != null && param.fileName.Trim().Length > 0)
* {
* filename = param.fileName.Trim();
* }
* // 组合分页SQL
* string limit = " LIMIT " + param.offset + "," + param.rows;
* // 总记录数
* string c0 = "{\"getFilesTotal\":[{\"[@c0]\":\"" + filename + "\"}]}";
* var list = Newtonsoft.Json.Linq.JObject.Parse(c0);
* Dictionary<string, JArray> jarrays = new Dictionary<string, JArray>();
* foreach (var arry in list)
* {
* jarrays.Add(arry.Key, arry.Value as JArray);
* }
* DataTable tabletotal = bs.GetDataTableToParamID(jarrays);
*
* // 当前页显示的信息集合
* c0 = "{\"getFiles\":[{\"[@c0]\":\"" + (limit) + "\",\"[@c1]\":\"" + filename + "\"}]}";
* list = Newtonsoft.Json.Linq.JObject.Parse(c0);
* jarrays.Clear();
* foreach (var arry in list)
* {
* jarrays.Add(arry.Key, arry.Value as JArray);
* }
* DataTable tablelist = bs.GetDataTableToParamID(jarrays);
*
* // 返回查询结果
* Dictionary<string, object> map = new Dictionary<string, object>();
* if (tabletotal == null)
* {
* map.Add("total", 0);
* }
* else
* {
* map.Add("total", tabletotal.Rows[0]["total"]);
* }
* map.Add("rows", tablelist);*/
string userid = string.IsNullOrEmpty(param.createUserName) ? UtilFunction.GetCookie("uid") : param.createUserName;
string path = _directory + "UploadFiles/template/" + userid;
int total = 0;
DirectoryInfo folder = new DirectoryInfo(path);
List <FileInfo> list = new List <FileInfo>();
//string[] files = Directory.GetFiles(path);
if (Directory.Exists(path))
{
System.IO.FileInfo[] files = folder.GetFiles("*.xlsx");
foreach (System.IO.FileInfo file in files)
{
total++;
FileInfo obj = new FileInfo();
obj.id = total;
obj.fileName = file.Name;
obj.createUserName = userid;
list.Add(obj);
}
}
Dictionary <string, object> map = new Dictionary <string, object>();
map.Add("total", total);
map.Add("rows", list);
string myjson = uf.ToJson(map);
return(GetJSONMessage(myjson));
}
// post api/loginapi/postLogin
/// <summary>
/// 用户登录
/// </summary>
/// <param name="value">实体信息</param>
/// <returns></returns>
public HttpResponseMessage postLogin([FromBody] UserInfos value)
{
IEnumerable <KeyValuePair <string, string> > list = ControllerContext.Request.GetQueryNameValuePairs();
JObject obj = new JObject();
try
{
FileLog.WriteLog("InfoApiTime：" + DateTime.Now.ToString() + ",调用：QcSystem.ControllersApi/ControllerAPI/LoginApiController/Get()方法");
string mycode = value.mycode;
string username = value.username;
obj.Add("username", value.username);
obj.Add("password", value.password);
obj.Add("mycode", value.mycode);
obj.Add("url", value.url);
// 1. 验证码检查
string a = HttpContext.Current.Session["checkcode"].ToString();
if (HttpContext.Current.Session["checkcode"] == null)
{
return(GetJSONMessage("{\"code\":{\"id\":2,\"msg\":\"验证码错误\"}}"));
}
if (mycode == "" || mycode == null)
{
return(GetJSONMessage("{\"code\":{\"id\":2,\"msg\":\"输入验证码错误\"}}"));
}
string b = mycode.ToUpper();
if (String.Compare(a, b, true) != 0)
{
return(GetJSONMessage("{\"code\":{\"id\":2,\"msg\":\"验证码错误\"}}"));
}
string msg = QueryService.GetDataBefor(obj, "1_6");
if (msg.IndexOf("成功") != -1)
{
JObject model = JObject.FromObject(JsonConvert.DeserializeObject(msg));
JToken UserId = model["user"][0]["id"];
JToken UserName = model["user"][0]["username"];
JToken CityId = model["user"][0]["cityid"];
JToken RoleId = model["role"][0]["roleid"];
JToken RoleName = model["role"][0]["rolename"];
JToken Level = model["role"][0]["level"];
int Rid = Convert.ToInt32(RoleId.ToString());
int Uid = int.Parse(UserId.ToString());
string UName = UserName.ToString();
UtilFunction.WriteCookie("uid", Uid.ToString(), 14400); // 用户ID
UtilFunction.WriteCookie("roleid", Rid.ToString(), 14400); //角色ID
UtilFunction.WriteCookie("rolename", HttpUtility.UrlEncode(RoleName.ToString()), 14400); //角色名字
UtilFunction.WriteCookie("uname", UName, 14400); //用户名字
UtilFunction.WriteCookie("cityid", HttpUtility.UrlEncode(CityId.ToString()), 14400); //城市id
UtilFunction.WriteCookie("level", Level.ToString(), 14400); //级别ID
LoginLogService loginbll = new LoginLogService();
string clientip = UtilFunction.GetIPAddress();
loginbll.SaveLog(Uid, UName, Rid, RoleName.ToString(), clientip, UName);
}
return(GetJSONMessage(msg));
}
catch (Exception er)
{
FileLog.WriteLog("Error：调用QcSystem.ControllersApi/ControllerAPI/LoginApiController/Get()方法," + er.ToString());
return(GetJSONMessage(""));
}
}
// GET api/userapi/GetTBTreeView 配置用户指标
/// <summary>
/// 配置用户指标
/// </summary>
/// <param name="userid">用户编号</param>
/// <returns></returns>
public HttpResponseMessage GetTBTreeView(int userid)
{
try
{
FileLog.WriteLog("InfoApiTime：" + DateTime.Now.ToString() + ",调用：Angel.ControllersApi/ControllerApi/UserApiController/GetTBTreeView()方法");
string[] IndicatoryList = { "" };
if (userid > 0)
{
string indicatorlist = IndicatorListdata(userid);
if (indicatorlist.Trim().Length > 2)
{
JObject model = JObject.FromObject(JsonConvert.DeserializeObject("{indicator:" + indicatorlist + "}"));
IndicatoryList = model["indicator"][0]["indicator_content"].ToString().ToUpper().Split(',');
}
else
{
IndicatoryList = null;
}
}
else
{
IndicatoryList = null;
}
BaseService bs = new BaseService();
UtilFunction uf = new UtilFunction();
DataTable TableB = bs.GetDataTableToID("TreeViewBusiness");
List <Tree_t> list = new List <Tree_t>();
foreach (DataRow row in TableB.Rows)
{
Tree_t treeview = new Tree_t();
treeview.text = (string)row["title"];
treeview.id = (string)row["id"];
treeview.pid = "0";
state st = new state();
if (IndicatoryList != null && IndicatoryList.Contains((string)row["id"]))
{
st.@checked = "true";
}
// st.selected = "true";
treeview.state = st;
//查询业务下所有维度信息start
string sql = "{\"BuesinessIDGetDimension\":[{\"[@c0]\": \"" + row["id"].ToString() + "\"}]}";
var listsql = Newtonsoft.Json.Linq.JObject.Parse(sql);
Dictionary <string, JArray> jarrays = new Dictionary <string, JArray>();
foreach (var arry in listsql)
{
jarrays.Add(arry.Key, arry.Value as JArray);
}
DataTable DimTable = bs.GetDataTableToParamID(jarrays);
List <Tree_t> listdim = new List <Tree_t>();
foreach (DataRow rowd in DimTable.Rows)
{
Tree_t treeview_d = new Tree_t();
treeview_d.text = (string)rowd["title"];
treeview_d.id = (string)rowd["id"];
treeview_d.pid = "1";
state std = new state();
if (IndicatoryList != null && IndicatoryList.Contains((string)rowd["id"]))
{
std.@checked = "true";
}
// st.selected = "true";
treeview_d.state = std;
//查询维度下所有指标信息start
string sqli = "{\"DimIdGetIndicator\":[{\"[@c0]\": \"" + rowd["id"].ToString() + "\"}]}";
var listsqli = Newtonsoft.Json.Linq.JObject.Parse(sqli);
Dictionary <string, JArray> jarraysi = new Dictionary <string, JArray>();
foreach (var arryi in listsqli)
{
jarraysi.Add(arryi.Key, arryi.Value as JArray);
}
DataTable InTable = bs.GetDataTableToParamID(jarraysi);
List <Tree_t> listIn = new List <Tree_t>();
foreach (DataRow rowi in InTable.Rows)
{
Tree_t treeview_i = new Tree_t();
treeview_i.text = (string)rowi["title"];
treeview_i.id = (string)rowi["id"];
treeview_i.pid = "2";
state sti = new state();
if (IndicatoryList != null && IndicatoryList.Contains((string)rowi["id"]))
{
sti.@checked = "true";
}
// st.selected = "true";
treeview_i.state = sti;
listIn.Add(treeview_i);
}
//指标end
treeview_d.nodes = listIn;
listdim.Add(treeview_d);
}
//维度end
treeview.nodes = listdim;
list.Add(treeview);
}
//开始解析treeview
string myjson = uf.ToJson(list);
return(GetJSONMessage(myjson));
}
catch (Exception er)
{
FileLog.WriteLog("Error：调用Angel.ControllersApi/ControllerApi/UserApiController/GetTBTreeView()方法," + er.ToString());
return(GetJSONMessage(""));
}
}
// POST api/userapi/post
public HttpResponseMessage Post([FromBody] string value)
{
string username = UtilFunction.GetCookie("uname");
string userid = UtilFunction.GetCookie("uid");
var list = Newtonsoft.Json.Linq.JObject.Parse(value.Replace("{admin}", username).Replace("{1}", userid));
Dictionary <string, JArray> dict = new Dictionary <string, JArray>();
try
{
FileLog.WriteLog("InfoApiTime：" + DateTime.Now.ToString() + ",调用：Angel.ControllersApi/ControllerApi/DownloadListManagerApiController/Post([FromBody]string value)方法");
string serverName = "";
Newtonsoft.Json.Linq.JArray jArray = new JArray();
if (list != null && list.Count > 0)
{
foreach (var arry in list)
{
switch (arry.Key)
{
case "insert":
serverName = "insertDownloadList";
break;
case "delete7daysBefore":
serverName = "delete7daysBefore";
break;
default:
break;
}
jArray = arry.Value as JArray;
}
}
if (serverName == "delete7daysBefore")
{
string selectSql = "SELECT username, filename FROM angel_downloadlist where datediff('" + value.Split('"')[7] + "', createtime)>=" + value.Split('"')[4].Split(':')[1].Split(',')[0] + " and username = '******'"')[11] + "';";
DataTable dt = MySqlHelpers.GetDataTable(selectSql);
string uname = string.Empty, filename = string.Empty, filepath = string.Empty;
if (dt != null && dt.Rows.Count != 0)
{
foreach (DataRow row in dt.Rows)
{
uname = row["username"].ToString();
filename = row["filename"].ToString();
//从磁盘上删除文件
filepath = AppDomain.CurrentDomain.BaseDirectory + "DownFile\\import\\" + uname + "\\" + filename;
File.Delete(filepath);
}
}
else
{
return(GetJSONMessage("{\"code\": {\"id\":-1,\"msg\":\"数据库不存在要删除的数据！\"}}"));
}
}
return(GetJSONMessage(QueryService.InsertBatchCheck(jArray, serverName)));
}
catch (Exception er)
{
FileLog.WriteLog("Error：调用 Angel.ControllersApi/ControllerApi/DownloadListManagerApiController/Post([FromBody]string value)方法," + er.ToString());
return(GetJSONMessage(""));
}
}
