public JSon listElements(JSon head, List <JSon> tail)
{
var values = new JList(head);
values.AddRange(tail);
return(values);
}
public Message AddPaymentRecord(Olb_PaymentRecord info) {
Message m;
try
{
DataContext dd = new DataContext(System.Configuration.ConfigurationManager.ConnectionStrings[configName].ConnectionString);
Table<Olb_PaymentRecord> tbl = dd.GetTable<Olb_PaymentRecord>();
string guid = Guid.NewGuid().ToString();
info.ID = guid;
tbl.InsertOnSubmit(info);
dd.SubmitChanges();
m = new Message()
{
Result = true,
TxtMessage = JSon.TToJson<Olb_PaymentRecord>(info)
};
}
catch (Exception e)
{
m = new Message()
{
Result = false,
TxtMessage = "警속심롤션쩌呵겨！" + e.Message
};
}
return m;
}
public JSon listElements(JSon head, List <Group <JsonToken, JSon> > tail)
{
var values = new JList(head);
values.AddRange(tail.Select(group => group.Value(0)).ToList());
return(values);
}
/// <summary>
/// Ìí¼ÓȼÆøÕ˺Å
/// </summary>
/// <param name="account"></param>
/// <param name="userId"></param>
/// <param name="companyId"></param>
/// <returns></returns>
public Message AddGasUser(string account, string userId, string companyId)
{
Message m;
try
{
DataContext dd = new DataContext(System.Configuration.ConfigurationManager.ConnectionStrings[configName].ConnectionString);
Table <Olb_GasUserRelation> tbl = dd.GetTable <Olb_GasUserRelation>();
Olb_GasUserRelation relation = new Olb_GasUserRelation()
{
Account = account,
CompanyID = companyId,
GasUserID = userId
};
tbl.InsertOnSubmit(relation);
dd.SubmitChanges();
m = new Message()
{
Result = true,
TxtMessage = JSon.TToJson <Olb_GasUserRelation>(relation)
};
}
catch (Exception e)
{
m = new Message()
{
Result = false,
TxtMessage = "Ìí¼ÓȼÆøÕ˺Åʧ°Ü£¡" + e.Message
};
}
return(m);
}
private string GetJSON()
{
string fp = "";
try
{
string res = "";
string sep = "";
for (int i = 0; i < 1; i++)
{
foreach (Waypoint wp in this.WaypointList)
{
res = "";
res = JSon.ToString(res, "id", wp.ID);
res = JSon.ToString(res, "icao", wp.ICAO);
res = JSon.ToString(res, "desc", wp.WaypointDesc);
res = JSon.ToString(res, "wptype", wp.WaypointType);
res = JSon.ToString(res, "lat", wp.Coord.Lat.Degree);
res = JSon.ToString(res, "lng", wp.Coord.Lng.Degree);
res = JSon.ToString(res, "alt", wp.Altitude);
//res = JSon.ToString(res, "dest", 0);
//res = JSon.ToString(res, "brg", 0);
fp += sep + "{" + res + "}";
sep = ",";
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return("{\"type\":\"flightplan\", \"timestamp\": " + this.LoadDt.Ticks.ToString() + ", \"data\": [" + fp + "]}");
}
//****************************************************************************************************
//
//****************************************************************************************************
public override void OnDBPull(HTTPReq req)
{
JSon json = new JSon(req.response);
if (json["error"] != null)
{
return;
}
if ((json.root is JSonObject) == false)
{
return;
}
JSonObject o = json.root as JSonObject;
m_loginUsername = o["login_username"].value;
m_loginPassword = o["login_password"].value;
name = o["name"].value;
m_rank = ( RANK )System.Enum.Parse(typeof(RANK), o["rank"].value, true);
m_type = ( TYPE )System.Enum.Parse(typeof(TYPE), o["type"].value, true);
}
/// <summary>
/// 编辑订单
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public Message Edit(Olb_ChargeOrder info)
{
Message m;
try
{
DataContext dd = new DataContext(System.Configuration.ConfigurationManager.ConnectionStrings[configName].ConnectionString);
Olb_ChargeOrder dbinfo = dd.GetTable <Olb_ChargeOrder>().Where(p => p.ID == info.ID).SingleOrDefault();
ConvertHelper.Copy <Olb_ChargeOrder>(dbinfo, info);
dd.SubmitChanges();
m = new Message()
{
Result = true,
TxtMessage = JSon.TToJson <Olb_ChargeOrder>(dbinfo)
};
}
catch (Exception e)
{
m = new Message()
{
Result = false,
TxtMessage = "编辑订单失败！" + e.Message
};
}
return(m);
}
public JSon ListElementsMany(JSon value, object comma, JList tail)
{
var elements = new JList(value);
elements.AddRange(tail);
return(elements);
}
public Message Edit(IoT_SetAlarm info)
{
// 定义执行结果
Message m;
string configName = System.Configuration.ConfigurationManager.AppSettings["defaultDatabase"];
//Linq to SQL 上下文对象
DataContext dd = new DataContext(System.Configuration.ConfigurationManager.ConnectionStrings[configName].ConnectionString);
try
{
IoT_SetAlarm dbinfo = dd.GetTable <IoT_SetAlarm>().Where(p => p.CompanyID == info.CompanyID && p.ID == info.ID).SingleOrDefault();
ConvertHelper.Copy <IoT_SetAlarm>(dbinfo, info);
// 更新操作
dd.SubmitChanges();
m = new Message()
{
Result = true,
TxtMessage = JSon.TToJson <IoT_SetAlarm>(dbinfo)
};
}
catch (Exception e)
{
m = new Message()
{
Result = false,
TxtMessage = "编辑设置报警参数失败！" + e.Message
};
}
return(m);
}
/// <summary>
/// 添加订单
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public Message Add(Olb_ChargeOrder info)
{
Message m;
try
{
//需要为每个方法创建一个DataContext实例 原因在于DataContext的缓存机制
DataContext dd = new DataContext(System.Configuration.ConfigurationManager.ConnectionStrings[configName].ConnectionString);
Table <Olb_ChargeOrder> tbl = dd.GetTable <Olb_ChargeOrder>();
//string guid = Guid.NewGuid().ToString();
//info.ID = guid;
tbl.InsertOnSubmit(info);
dd.SubmitChanges();
m = new Message()
{
Result = true,
TxtMessage = JSon.TToJson <Olb_ChargeOrder>(info)
};
}
catch (Exception e)
{
m = new Message()
{
Result = false,
TxtMessage = "添加订单失败！" + e.Message
};
}
return(m);
}
//****************************************************************************************************
//
//****************************************************************************************************
public override void OnDBPull(HTTPReq req)
{
JSon json = new JSon(req.response);
if (json["error"] != null)
{
return;
}
if ((json.root is JSonObject) == false)
{
return;
}
JSonObject o = json.root as JSonObject;
System.DateTime.TryParse(o["date_found"].value, out m_dateFound);
name = o["name"].value;
parentID = long.Parse(o["site_id"].value);
m_coord.latitude.FromAngle(float.Parse(o["lat"].value), GPS.UNIT.DD);
m_coord.longitude.FromAngle(float.Parse(o["lng"].value), GPS.UNIT.DD);
m_coord.altitude = float.Parse(o["alt"].value);
m_pic = o["pic"].value;
}
public async Task SaveGameEvent()
{
var fileStorage = new FileStorage();
var file = await fileStorage.CreateFile(this.FileName());
var json = await JSon.Serialize(this.Game);
fileStorage.Write(file, json);
}
public Message AddCompany(CompanyInfo info)
{
// 定义执行结果
Message m;
string configName = System.Configuration.ConfigurationManager.AppSettings["defaultDatabase"];
//Linq to SQL 上下文对象
DataContext dd = new DataContext(System.Configuration.ConfigurationManager.ConnectionStrings[configName].ConnectionString);
try
{
if (info.CompanyID == string.Empty)
{
m = new Message()
{
Result = false,
TxtMessage = "新增失败！企业编号不能为空。"
};
}
else
{
// 获得上下文对象中的信息表
Table <CompanyInfo> tbl = dd.GetTable <CompanyInfo>();
//判断账号是否存在。
int existsCount = (from p in tbl where p.CompanyID == info.CompanyID select p.CompanyID).Count();
if (existsCount > 0)
{
m = new Message()
{
Result = false,
TxtMessage = string.Format("新增失败！企业编号{0}已存在。", info.CompanyID)
};
}
else
{
// 调用新增方法
tbl.InsertOnSubmit(info);
// 更新操作
dd.SubmitChanges();
ResetCompanyAdmin(info);
m = new Message()
{
Result = true,
TxtMessage = JSon.TToJson <CompanyInfo>(info)
};
}
}
}
catch (Exception e)
{
m = new Message()
{
Result = false,
TxtMessage = "新增失败！" + e.Message
};
}
return(m);
}
public Message AddTemp(IoT_UserTemp info)
{
// 定义执行结果
Message m;
string configName = System.Configuration.ConfigurationManager.AppSettings["defaultDatabase"];
//Linq to SQL 上下文对象
DataContext dd = new DataContext(System.Configuration.ConfigurationManager.ConnectionStrings[configName].ConnectionString);
try
{
var count = dd.GetTable <IoT_Meter>().Where(p =>
p.CompanyID == info.CompanyID && p.MeterNo == info.MeterNo).Count();
if (count > 0)
{
m = new Message()
{
Result = false,
TxtMessage = "表号不能重复!"
};
return(m);
}
Table <IoT_UserTemp> tbl = dd.GetTable <IoT_UserTemp>();
count = tbl.Where(p => p.CompanyID == info.CompanyID && p.MeterNo == info.MeterNo).Count();
if (count > 0)
{
m = new Message()
{
Result = false,
TxtMessage = "表号不能重复!"
};
return(m);
}
// 调用新增方法
tbl.InsertOnSubmit(info);
// 更新操作
dd.SubmitChanges();
m = new Message()
{
Result = true,
TxtMessage = JSon.TToJson <IoT_UserTemp>(info)
};
}
catch (Exception e)
{
m = new Message()
{
Result = false,
TxtMessage = "新增临时用户失败！" + e.Message
};
}
return(m);
}
public Message Add(IoT_SetUploadCycle info, List <IoT_UploadCycleMeter> meterList)
{
// 定义执行结果
Message m;
string configName = System.Configuration.ConfigurationManager.AppSettings["defaultDatabase"];
//Linq to SQL 上下文对象
DataContext dd = new DataContext(System.Configuration.ConfigurationManager.ConnectionStrings[configName].ConnectionString);
try
{
//添加设置上传周期参数任务到通讯队列
string result = new SetMeterParameter().SetUploadCycle(info, meterList);
if (result != "")
{
throw new Exception(result);
}
Table <IoT_SetUploadCycle> tbl = dd.GetTable <IoT_SetUploadCycle>();
// 调用新增方法
tbl.InsertOnSubmit(info);
// 更新操作
dd.SubmitChanges();
// 更新操作
Table <IoT_UploadCycleMeter> tbl_meter = dd.GetTable <IoT_UploadCycleMeter>();
foreach (IoT_UploadCycleMeter meter in meterList)
{
IoT_Meter tempMeter = MeterManageService.QueryMeter(meter.MeterNo);
meter.MeterID = tempMeter.ID;
meter.ID = info.ID;
meter.Context = info.Context;
meter.State = '0';//申请
info.TaskID = meter.TaskID;
tbl_meter.InsertOnSubmit(meter);
}
// 更新操作
dd.SubmitChanges();
m = new Message()
{
Result = true,
TxtMessage = JSon.TToJson <IoT_SetUploadCycle>(info)
};
}
catch (Exception e)
{
m = new Message()
{
Result = false,
TxtMessage = "新增设置上传周期失败！" + e.Message
};
}
return(m);
}
public Message Edit(IoT_Community info)
{
// 定义执行结果
Message m;
string configName = System.Configuration.ConfigurationManager.AppSettings["defaultDatabase"];
//Linq to SQL 上下文对象
DataContext dd = new DataContext(System.Configuration.ConfigurationManager.ConnectionStrings[configName].ConnectionString);
try
{
string checkSQL = $"Select count(*) from IoT_Street where ID={info.ID}";
object[] param = new object[0];
int iCount = dd.ExecuteQuery <int>(checkSQL, param).Single <int>();
if (iCount > 0)
{
throw new Exception("小区已被使用，不能删除");
}
var count = dd.GetTable <IoT_Community>().Where(p => p.StreetID == info.StreetID && p.Ser == info.Ser && p.ID != info.ID).Count();
if (count > 0)
{
m = new Message()
{
Result = false,
TxtMessage = "小区编号不能重复!"
};
return(m);
}
IoT_Community dbinfo = dd.GetTable <IoT_Community>().Where(p =>
p.ID == info.ID).SingleOrDefault();
ConvertHelper.Copy <IoT_Community>(dbinfo, info);
// 更新操作
dd.SubmitChanges();
m = new Message()
{
Result = true,
TxtMessage = JSon.TToJson <IoT_Community>(dbinfo)
};
}
catch (Exception e)
{
m = new Message()
{
Result = false,
TxtMessage = "编辑小区参数失败！" + e.Message
};
}
return(m);
}
public T getComplexValue <T>() where T : class
{
T v;
if (string.IsNullOrEmpty(this.Value))
{
v = null;
}
else
{
v = JSon.deserializeJSON <T>(this.Value);
}
return(v);
}
public Message AddCompanyDefineRight(DefineRight dRight, List <DefineRightMenu> list)
{
string sqlText = string.Empty;
Message m = new Message()
{
Result = true, TxtMessage = "操作成功。"
};
try
{
//先删除再执行添加
if (DelCompanyDefineRight(dRight).Result)
{
sqlText = string.Format("Insert Into S_DefineRight" +
"(RightCode,CompanyID,RightName,Context)" +
"values('{0}','{1}','{2}','{3}')"
, dRight.RightCode, dRight.CompanyID, dRight.RightName, dRight.Context);
SQLHelper.ExecuteScalar(SQLHelper.SchuleConnection, CommandType.Text, sqlText);
foreach (DefineRightMenu tmp in list)
{
sqlText = string.Format("Insert Into S_DefineRightMenu" +
"(CompanyID,RightCode,MenuCode)" +
"values('{0}','{1}','{2}')"
, tmp.CompanyID, tmp.RightCode, tmp.MenuCode);
SQLHelper.ExecuteScalar(SQLHelper.SchuleConnection, CommandType.Text, sqlText);
}
m = new Message()
{
Result = true, TxtMessage = JSon.TToJson <DefineRight>(dRight)
};
}
else
{
m = new Message()
{
Result = false, TxtMessage = "操作失败，【删除相同编码权限出错】。"
};
}
}
catch (Exception e)
{
m = new Message()
{
Result = false, TxtMessage = "操作失败，【" + e.Message + "】。"
};
}
return(m);
}
void GetAchievementData()
{
TextAsset file = Resources.Load <TextAsset>("achievementdata");
StreamReader sr = new StreamReader(new MemoryStream(file.bytes));
string data = sr.ReadLine();
_Dic = JSon.Read(data);
for (int i = 0; i < StaticMng.Instance._MaxAchievementCount; i++)
{
StaticMng.Instance._Achive_Name.Add(_Dic["Achieve_Name_" + i.ToString()]);
StaticMng.Instance._Achive_Explanation.Add(_Dic["Achieve_Explain_" + i.ToString()]);
StaticMng.Instance._Achive_MaxValue.Add(int.Parse(_Dic["Achieve_MaxCount_" + i.ToString()]));
StaticMng.Instance._Achive_Reward.Add(int.Parse(_Dic["Achieve_Reward_" + i.ToString()]));
StaticMng.Instance._Achive_RewardInfo.Add(_Dic["Achieve_RewardI_" + i.ToString()]);
}
}
public Message Add(IoT_Community info)
{
// 定义执行结果
Message m;
string configName = System.Configuration.ConfigurationManager.AppSettings["defaultDatabase"];
//Linq to SQL 上下文对象
DataContext dd = new DataContext(System.Configuration.ConfigurationManager.ConnectionStrings[configName].ConnectionString);
try
{
Table <IoT_Community> tbl = dd.GetTable <IoT_Community>();
var count = tbl.Where(p => p.StreetID == info.StreetID && p.Ser == info.Ser).Count();
if (count > 0)
{
m = new Message()
{
Result = false,
TxtMessage = "小区编号不能重复!"
};
return(m);
}
// 调用新增方法
tbl.InsertOnSubmit(info);
// 更新操作
dd.SubmitChanges();
m = new Message()
{
Result = true,
TxtMessage = JSon.TToJson <IoT_Community>(info)
};
}
catch (Exception e)
{
m = new Message()
{
Result = false,
TxtMessage = "新增小区参数失败！" + e.Message
};
}
return(m);
}
//****************************************************************************************************
//
//****************************************************************************************************
static public void UnitTest()
{
JSon json = new JSon();
bool result = json.Parse("{ \"menu\":{\"test\":\"expression with \"quotes\"\",\"id\":\"file\",\"value\":\"File\",\"popup\":{\"menuitem\":[{\"value\":\"New\",\"onclick\":\"CreateNewDoc()\"},{\"value\":\"Open\",\"onclick\":\"OpenDoc()\"},{\"value\":\"Close\",\"onclick\":\"CloseDoc()\"}]}}}");
Debug.Assert(result == true);
if (result)
{
string value = json["menu.popup.menuitem.[2].onclick"].value;
bool success = (value != null) && (value.CompareTo("CloseDoc()") == 0);
Debug.Assert(success);
}
}
void DataSave()
{
try
{
Dictionary <string, string> dicJson = new Dictionary <string, string>();
for (int i = 0; i < StaticMng.Instance._MaximumChapter; i++)
{
for (int j = 0; j < StaticMng.Instance._MaximumSector[i]; j++)
{
dicJson.Add("sp_" + i.ToString() + "_" + j.ToString(), StaticMng.Instance._StagePeakCount[i, j].ToString());
}
}
string spdata = JSon.Write(dicJson);
Dictionary <string, string> achivejson = new Dictionary <string, string>();
for (int i = 0; i < StaticMng.Instance._MaxAchievementCount; i++)
{
achivejson.Add("Achi_NowVal" + i.ToString(), StaticMng.Instance._Achive_NowValue[i].ToString());
achivejson.Add("Achi_NowInfo" + i.ToString(), StaticMng.Instance._Achive_ClearCheck[i].ToString());
}
string achivedata = JSon.Write(achivejson);
int tempvolume;
if (StaticMng.Instance._Option_Volume_Bool)
{
tempvolume = 1;
}
else
{
tempvolume = 0;
}
string q2 = "update BuskingTest set UserName = '******',Level=" + StaticMng.Instance._Player_Level.ToString() + ",NowExp=" + StaticMng.Instance._Player_NowExp.ToString() + ",Gold=" + StaticMng.Instance._Gold.ToString() + ",DrumLevel = " + StaticMng.Instance._DrumTowerLevel.ToString() + ",GuitarLevel=" + StaticMng.Instance._GuitarTowerLevel.ToString() + ",BassLevel=" + StaticMng.Instance._BassTowerLevel.ToString() + ",KeyBoardLevel=" + StaticMng.Instance._KeyBoardTowerLevel.ToString() + ",Volume=" + tempvolume.ToString() + ",UnlockChapter=" + StaticMng.Instance._UnLock_Chapter.ToString() + ",UnlockSector_1=" + StaticMng.Instance._UnLock_Sector[0].ToString() + ",UnlockSector_2=" + StaticMng.Instance._UnLock_Sector[1].ToString() + ",UnlockSector_3=" + StaticMng.Instance._UnLock_Sector[2].ToString() + ",UnlockSector_4=" + StaticMng.Instance._UnLock_Sector[3].ToString() + ",StagePeak ='" + spdata.ToString() + "',Achievement = '" + achivedata + "',Gem = " + StaticMng.Instance._Gem.ToString() + ",GuitarRank = " + StaticMng.Instance._GuitarTowerRank.ToString() + ",DrumRank = " + StaticMng.Instance._DrumTowerRank.ToString() + ",BassRank = " + StaticMng.Instance._BassTowerRank.ToString() + ",KeyBoardRank = " + StaticMng.Instance._KeyBoardTowerRank.ToString() + ",InfinityGameScore = " + StaticMng.Instance._InfinityGameScore.ToString() + ",IdentityNumber = " + StaticMng.Instance._InfinityScoreIdentity.ToString() + ",InfinityFastValue = " + StaticMng.Instance._Infinity_FastValue.ToString() + " where id='" + StaticMng.Instance._UserId + "';";
conn.Open();
MySqlCommand cmd2 = new MySqlCommand(q2, conn);
MySqlDataReader reader2 = cmd2.ExecuteReader();
//Debug.Log("Save");
conn.Close();
DataLoad();
}
catch (Exception ex)
{
Debug.Log(ex);
conn.Close();
}
}
public Message EditMenu(MenuInfo info)
{
// 定义执行结果
Message m;
string configName = System.Configuration.ConfigurationManager.AppSettings["defaultDatabase"];
//Linq to SQL 上下文对象
DataContext dd = new DataContext(System.Configuration.ConfigurationManager.ConnectionStrings[configName].ConnectionString);
try
{
if (info.MenuCode == string.Empty)
{
m = new Message()
{
Result = false,
TxtMessage = "编辑失败！菜单编号不能为空。"
};
}
else
{
// 获得上下文对象中的用户信息表
MenuInfo dbinfo = dd.GetTable <MenuInfo>().Where(p => p.MenuCode == info.MenuCode).SingleOrDefault();
//定义修改主键
string MenuCode = dbinfo.MenuCode;
ConvertHelper.Copy <MenuInfo>(dbinfo, info);
dbinfo.MenuCode = MenuCode;
// 更新操作
dd.SubmitChanges();
m = new Message()
{
Result = true,
TxtMessage = JSon.TToJson <MenuInfo>(dbinfo)
};
}
}
catch (Exception e)
{
m = new Message()
{
Result = false,
TxtMessage = "编辑失败！" + e.Message
};
}
return(m);
}
public Message Add(IoT_User info)
{
// 定义执行结果
Message m;
string configName = System.Configuration.ConfigurationManager.AppSettings["defaultDatabase"];
//Linq to SQL 上下文对象
DataContext dd = new DataContext(System.Configuration.ConfigurationManager.ConnectionStrings[configName].ConnectionString);
try
{
Table <IoT_User> tbl = dd.GetTable <IoT_User>();
info.UserID = GetUserID();
if (info.UserID == "-1")
{
m = new Message()
{
Result = false,
TxtMessage = "新增用户失败！" + "获取用户id错误"
};
return(m);
}
// 调用新增方法
tbl.InsertOnSubmit(info);
// 更新操作
dd.SubmitChanges();
m = new Message()
{
Result = true,
TxtMessage = JSon.TToJson <IoT_User>(info)
};
}
catch (Exception e)
{
m = new Message()
{
Result = false,
TxtMessage = "新增用户失败！" + e.Message
};
}
return(m);
}
public Message revoke(string ID, string CompanyID)
{
// 定义执行结果
Message m;
string configName = System.Configuration.ConfigurationManager.AppSettings["defaultDatabase"];
//Linq to SQL 上下文对象
DataContext dd = new DataContext(System.Configuration.ConfigurationManager.ConnectionStrings[configName].ConnectionString);
try
{
M_SetParameterService ps = new M_SetParameterService();
//更新主表
IoT_SetSettlementDay dbinfo = dd.GetTable <IoT_SetSettlementDay>().Where(p =>
p.CompanyID == CompanyID && p.ID == int.Parse(ID.Trim())).SingleOrDefault();
dbinfo.State = '1';
ps.UnSetParameter(dbinfo.TaskID);
List <IoT_SettlementDayMeter> LstdbinfoMeter = dd.GetTable <IoT_SettlementDayMeter>().Where(p =>
p.ID == int.Parse(ID.Trim())).ToList();
foreach (var item in LstdbinfoMeter)
{
item.State = '1';
ps.UnSetParameter(item.TaskID);
}
dd.SubmitChanges();
// 更新操作
m = new Message()
{
Result = true,
TxtMessage = JSon.TToJson <IoT_SetSettlementDay>(dbinfo)
};
}
catch (Exception e)
{
m = new Message()
{
Result = false,
TxtMessage = "编辑设置结算日失败！" + e.Message
};
}
return(m);
}
void GetTowerNameData()
{
TextAsset file = Resources.Load <TextAsset>("instrumentdata");
StreamReader sr = new StreamReader(new MemoryStream(file.bytes));
string data = sr.ReadLine();
_Dic = JSon.Read(data);
for (int i = 0; i < 10; i++)
{
_TowerUpgradeMng._GuitarTowerUpgradeCost.Add(int.Parse(_Dic["Guitar_Cost_" + i.ToString()]));
_TowerUpgradeMng._DrumTowerUpgradeCost.Add(int.Parse(_Dic["Bass_Cost_" + i.ToString()]));
_TowerUpgradeMng._BassTowerUpgradeCost.Add(int.Parse(_Dic["Drum_Cost_" + i.ToString()]));
_TowerUpgradeMng._KeyBoardTowerUpgradeCost.Add(int.Parse(_Dic["KeyBoard_Cost_" + i.ToString()]));
}
_TowerUpgradeMng._GuitarTowerUpgradeCost.Add(33000);
_TowerUpgradeMng._DrumTowerUpgradeCost.Add(33000);
_TowerUpgradeMng._BassTowerUpgradeCost.Add(33000);
_TowerUpgradeMng._KeyBoardTowerUpgradeCost.Add(33000);
}
public Message AddSystemLog(SystemLog info)
{
// 定义执行结果
Message m;
string configName = System.Configuration.ConfigurationManager.AppSettings["defaultDatabase"];
//Linq to SQL 上下文对象
DataContext dd = new DataContext(System.Configuration.ConfigurationManager.ConnectionStrings[configName].ConnectionString);
try
{
if (info.CompanyID == string.Empty)
{
m = new Message()
{
Result = false,
TxtMessage = "记录系统日志失败！企业编号不能为空。"
};
}
else
{
// 获得上下文对象中的信息表
Table <SystemLog> tbl = dd.GetTable <SystemLog>();
// 调用新增方法
tbl.InsertOnSubmit(info);
// 更新操作
dd.SubmitChanges();
m = new Message()
{
Result = true,
TxtMessage = JSon.TToJson <SystemLog>(info)
};
}
}
catch (Exception e)
{
m = new Message()
{
Result = false,
TxtMessage = "记录系统日志失败！" + e.Message
};
}
return(m);
}
public override void DoNoLoginHandlerWork(HttpContext context)
{
Message jsonMessage = new Message();
//获取操作类型AType:ADD,EDIT,DELETE,QUERY
WCFServiceProxy <ILoginerManage> proxyLoginer;
string AjaxType = context.Request.QueryString["AType"] == null ? string.Empty : context.Request.QueryString["AType"].ToString().ToUpper();
switch (AjaxType)
{
case "USERLOGIN":
jsonMessage = UserLogin(context);
break;
case "USERLOGINOUT":
proxyLoginer = new WCFServiceProxy <ILoginerManage>();
if (context.Session["LoginCompanyOperator"] != null)
{
context.Session.Remove("LoginCompanyOperator");
}
string webCookie = context.Session.SessionID.ToString();
try
{
jsonMessage = proxyLoginer.getChannel.UnLRegisterClientByMd5Cookie(Md5.GetMd5(webCookie));
}
catch
{ }
finally
{
proxyLoginer.CloseChannel();
}
break;
default:
jsonMessage = new Message()
{
Result = false,
TxtMessage = "操作未定义。"
};
break;
}
context.Response.Write(JSon.TToJson <Message>(jsonMessage));
}
public static JSon Deserialize(StringReader reader)
{
char car;
do
{
car = (char)reader.Peek();
JSon res = null;
switch (car)
{
case '{':
reader.Read();
res = new JSonObject();
break;
case '[':
reader.Read();
res = new JSonArray();
break;
case '"':
reader.Read();
res = new JSonString();
break;
case var x when(x >= '0' && x <= '9') || (x == '-'):
res = new JSonInt();
break;
}
if (res != null)
{
res.Parse(reader);
return(res);
}
reader.Read();
} while (car == ' ' || car == '\n');
return(null);
}
public override void Parse(StringReader reader)
{
while (((char)reader.Peek()) != '}')
{
var name = Deserialize(reader) as JSonString;
if (reader.Read() != ':' || name == null)
{
throw new InvalidOperationException("failed to read object");
}
var val = JSon.Deserialize(reader);
Fields[name.Value] = val;
while (reader.Peek() == ',')
{
reader.Read();
}
}
reader.Read();
}
