/// <summary>
/// 跳过新手按钮点击响应
/// </summary>
protected void skipNewbieButton_Click(object sender, EventArgs e)
{
if (this.selectListBox.Items.Count != 1 ||
string.IsNullOrEmpty(this.selectListBox.Items[0].Value))
{
this.errorLabel.Text = TableManager.GetGMTText(720);
return;
}
if (string.IsNullOrEmpty(this.uidTextBox.Text))
{
this.errorLabel.Text = TableManager.GetGMTText(721);
return;
}
string account = Session["user"] as string;
gmt.Server server = gmt.Server.GetServer(this.selectListBox.Items[0].Value);
uint playerId = this.GetPlayerId();
if (playerId != 0)
{
AGmPage.ExecuteGmCommand(account, server, playerId.ToString(), string.Format("CO({0},1)", playerId), "", true, text => this.errorLabel.Text += text);
}
}
/// <summary>
/// 页面载入响应
/// </summary>
protected override void OnGmPageLoad()
{
this.errorLabel.Text = "";
if (!this.IsPostBack)
{
this.versionLabel.Text = GmNormal.Version;
if (Ban.banList.Count == 0 || Ban.banList == null)
{
Ban.LoadBanList();
}
if (ShutUp.shutupList.Count == 0 || ShutUp.shutupList == null)
{
ShutUp.LoadShutupList();
}
for (int i = 0; i < gmt.Server.Count; ++i)
{
gmt.Server theServer = gmt.Server.GetServerAt(i);
this.serverListBox.Items.Add(new ListItem(theServer.Name));
}
}
}
/// <summary>
/// GM命令按钮点击响应
/// </summary>
protected void gmButton_Click(object sender, EventArgs e)
{
if (this.selectListBox.Items.Count != 1 ||
string.IsNullOrEmpty(this.selectListBox.Items[0].Value))
{
this.errorLabel.Text = TableManager.GetGMTText(720);
return;
}
if (string.IsNullOrEmpty(this.uidTextBox.Text))
{
this.errorLabel.Text = TableManager.GetGMTText(721);
return;
}
string account = Session["user"] as string;
gmt.Server server = gmt.Server.GetServer(this.selectListBox.Items[0].Value);
uint playerId = this.GetPlayerId(false);
if (playerId != 0)
{
//转大写
int starIdx = this.gmTextBox.Text.IndexOfAny("(".ToCharArray());
string textA = this.gmTextBox.Text.Substring(0, starIdx);
string textB = this.gmTextBox.Text.Substring(starIdx);
string commond = textA.ToUpper() + textB;
AGmPage.ExecuteGmCommand(account, server, playerId.ToString(), commond, "", this.needReturn, text => this.errorLabel.Text += text);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
gmt.Server server = Session["Server"] as gmt.Server;
for (int i = 0; i < gmt.Server.Count; ++i)
{
gmt.Server theServer = gmt.Server.GetServerAt(i);
this.Serverlist.Items.Add(theServer.Name);
this.ImitateloginServer.Items.Add(theServer.Name);
if (theServer == server)
{
this.Serverlist.SelectedIndex = i;
}
}
if (server == null)
{
Session["Server"] = gmt.Server.GetServerAt(0);
}
foreach (Channel channel in CreateKey.ChannelSet)
{
this.ChannelList.Items.Add(channel.Name);
}
//服务器端启动的服务
}
}
/// <summary>
/// 页面载入响应
/// </summary>
protected override void OnGmPageLoad()
{
if (!this.IsPostBack)
{
gmt.Server server = Session["Server"] as gmt.Server;
for (int i = 0; i < gmt.Server.Count; ++i)
{
gmt.Server theServer = gmt.Server.GetServerAt(i);
this.serverList.Items.Add(theServer.Name);
if (theServer == server)
{
this.serverList.SelectedIndex = i;
}
}
if (server == null)
{
Session["Server"] = gmt.Server.GetServerAt(0);
}
foreach (Channel channel in CreateKey.ChannelSet)
{
this.channelList.Items.Add(channel.Name);
}
DateTime expiryDate = DateTime.Today + new TimeSpan(1, 0, 0, 0);
ViewState["expiryDate"] = expiryDate;
this.expiryDateTextBox.Text = expiryDate.ToShortDateString();
this.countTextBox.Text = "1";
}
this.expiryDateTextBox.Attributes["onclick"] = ClientScript.GetPostBackEventReference(this.hideButton, null);
}
/// <summary>
/// 页面载入响应
/// </summary>
protected override void OnGmPageLoad()
{
if (!this.IsPostBack)
{
gmt.Server server = Session["Server"] as gmt.Server;
for (int i = 0; i < gmt.Server.Count; ++i)
{
gmt.Server theServer = gmt.Server.GetServerAt(i);
this.serverList.Items.Add(theServer.Name);
this.serverListBox.Items.Add(theServer.Name);
if (theServer == server)
{
this.serverList.SelectedIndex = i;
}
}
if (server == null)
{
Session["Server"] = server = gmt.Server.GetServerAt(0);
}
this.RefreshRevolving();
//this.RefreshNotice();
}
}
/// <summary>
/// 页面载入响应
/// </summary>
protected override void OnGmPageLoad()
{
if (!this.IsPostBack)
{
gmt.Server server = Session["Server"] as gmt.Server;
for (int i = 0; i < gmt.Server.Count; ++i)
{
gmt.Server theServer = gmt.Server.GetServerAt(i);
this.serverList.Items.Add(theServer.Name);
this.sourceList.Items.Add(theServer.Name);
if (theServer == server)
{
this.serverList.SelectedIndex = i;
}
}
if (server == null)
{
Session["Server"] = gmt.Server.GetServerAt(0);
}
if (GiftTable.GiftList != null)
{
foreach (var config in GiftTable.GiftList)
{
this.giftDropDownList.Items.Add(new ListItem(config.id + " | " + TextManager.GetText(config.title), config.id.ToString()));
}
}
}
}
/// <summary>
/// 合服按钮点击响应
/// </summary>
protected void mergeButton_Click(object sender, EventArgs e)
{
if (this.fromDropDownList.SelectedIndex == this.toDropDownList.SelectedIndex)
{
this.outputLabel.Text = TableManager.GetGMTText(754);
return;
}
gmt.Server fromServer = gmt.Server.GetServerAt(this.fromDropDownList.SelectedIndex);
gmt.Server toServer = gmt.Server.GetServerAt(this.toDropDownList.SelectedIndex);
if (DatabaseAssistant.Execute
(
fromServer.DatabaseAddress,
fromServer.DatabasePort,
fromServer.DatabaseCharSet,
fromServer.GameDatabase,
fromServer.DatabaseUserId,
fromServer.DatabasePassword,
"CALL `xp_mix_data`('{0}',{1});", toServer.GameDatabase, fromServer.Id.Split('-')[1]
))
{
this.outputLabel.Text = TableManager.GetGMTText(755);
}
else
{
this.outputLabel.Text = TableManager.GetGMTText(756);
}
}
/// <summary>
/// 确认玩家按钮点击响应
/// </summary>
protected void ensureButton_Click(object sender, EventArgs e)
{
if (this.selectListBox.Items.Count != 1 ||
string.IsNullOrEmpty(this.selectListBox.Items[0].Value))
{
this.errorLabel.Text = TableManager.GetGMTText(720);
return;
}
if (string.IsNullOrEmpty(this.uidTextBox.Text))
{
this.errorLabel.Text = TableManager.GetGMTText(721);
return;
}
StringBuilder builder = new StringBuilder();
gmt.Server server = gmt.Server.GetServer(this.selectListBox.Items[0].Value);
builder.Append(server.Name).Append("<br>");
string sql = "";
if (!string.IsNullOrEmpty(this.uidTextBox.Text))
{
sql = string.Format("SELECT `uname`,`uid`,`cyuid` FROM `user` WHERE `uid`='{0}';", DatabaseAssistant.DetectionSql(this.uidTextBox.Text));
}
DatabaseAssistant.Execute(reader =>
{
bool finded = false;
while (reader.Read())
{
finded = true;
builder.Append(TableManager.GetGMTText(9) + "(").Append(reader.GetString(0));
this.playerNameLabel.Text = reader.GetString(0);
builder.Append(") " + TableManager.GetGMTText(722) + "(").Append(reader.GetUInt32(1));
builder.Append(") " + TableManager.GetGMTText(48) + "(").Append(reader.GetString(2)).Append(")<br>");
}
if (!finded)
{
builder.Append(TableManager.GetGMTText(674) + "<br>");
}
},
server.DatabaseAddress,
server.DatabasePort,
server.DatabaseCharSet,
server.GameDatabase,
server.DatabaseUserId,
server.DatabasePassword,
sql);
//显示玩家信息
//this.playerNameLabel.Text = builder.ToString();
}
/// <summary>
/// 页面载入响应
/// </summary>
protected override void OnGmPageLoad()
{
if (!this.IsPostBack)
{
gmt.Server server = Session["Server"] as gmt.Server;
for (int i = 0; i < gmt.Server.Count; ++i)
{
gmt.Server theServer = gmt.Server.GetServerAt(i);
this.serverList.Items.Add(theServer.Name);
if (theServer == server)
{
this.serverList.SelectedIndex = i;
}
}
if (server == null)
{
Session["Server"] = gmt.Server.GetServerAt(0);
}
foreach (Channel channel in CreateKey.ChannelSet)
{
this.channelList.Items.Add(channel.Name);
}
DateTime expiryDate = DateTime.Today;
ViewState["expiryDate"] = expiryDate;
this.expiryDateTextBox.Text = expiryDate.ToShortDateString();
this.countTextBox.Text = "1";
for (int i = 0; i < 100; i++)
{
this.Mutitimes.Items.Add(new ListItem(i.ToString(), i.ToString()));
}
this.Mutitimes.SelectedIndex = 0;
if (GiftTable.GiftList != null)
{
this.giftDropDownList.Items.Clear();
foreach (var config in GiftTable.GiftList)
{
this.giftDropDownList.Items.Add(new ListItem(config.id + " | " + TextManager.GetText(config.title), config.id.ToString()));
}
this.giftLabel.Text = "*" + TextManager.GetText(GiftTable.GiftList[this.giftDropDownList.SelectedIndex].desc);
}
}
object channelSelected = ViewState["ChannelSelected"];
Channel currentChannel = CreateKey.ChannelSet[this.channelList.SelectedIndex];
this.expiryDateTextBox.Attributes["onclick"] = ClientScript.GetPostBackEventReference(this.hideButton, null);
}
/// <summary>
/// 发放单人礼包按钮点击响应
/// </summary>
protected void singleGiftButton_Click(object sender, EventArgs e)
{
if (this.selectListBox.Items.Count != 1 ||
string.IsNullOrEmpty(this.selectListBox.Items[0].Value))
{
this.errorLabel.Text = TableManager.GetGMTText(720);
return;
}
if (string.IsNullOrEmpty(this.uidTextBox.Text))
{
this.errorLabel.Text = TableManager.GetGMTText(721);
return;
}
string account = Session["user"] as string;
gmt.Server server = gmt.Server.GetServer(this.selectListBox.Items[0].Value);
int giftId = 0;
if (!int.TryParse(this.giftOptionDropDownList.SelectedValue, out giftId))
{
return;
}
uint playerId = this.GetPlayerId();
if (playerId == 0)
{
return;
}
string gmcmd = string.Format("GIFT({0},{1})", playerId, giftId);
bool isGiftTimeOn = (Request.Form["gift_timer_checker"] == "on") ? true : false;
string give_time = this.datetimepicker_1.Value;
if (isGiftTimeOn)
{
STTimedMail stMailInfo = new STTimedMail();
stMailInfo.uid = playerId;
stMailInfo.mailId = giftId;
stMailInfo.serverName = this.selectListBox.Items[0].Value;
stMailInfo.sendTime = CUtils.GetTimestamp(Convert.ToDateTime(give_time));
stMailInfo.cmd = gmcmd;
TimedMailSender.AddTimedMail(stMailInfo);
}
else
{
AGmPage.ExecuteGmCommand(account, server, playerId.ToString(), gmcmd, "", true, text => this.errorLabel.Text += text);
}
}
/// <summary>
/// 执行GM命令
/// </summary>
/// <param name="playerId"></param>
/// <param name="commandText"></param>
/// <param name="operateText"></param>
/// <param name="needReturn"></param>
/// <param name="reportProcess"></param>
/// <returns></returns>
protected override bool ExecuteGmCommand(string playerId, string commandText, string operateText, bool needReturn, Action <string> reportProcess)
{
bool success = true;
string account = Session["user"] as string;
gmt.Server keyServer = gmt.Server.GetServerAt(this.OpentimeserverList.SelectedIndex);
if (keyServer != null)
{
success &= AGmPage.ExecuteGmCommand(account, keyServer, "0", commandText, operateText, needReturn, reportProcess);
}
return(success);
}
public static string QueryTotalCost(string filter)
{
string sqlCondi = "";
if (queryInfo.start_time == null || queryInfo.end_time == null)
{
sqlCondi = string.Format(" last_update_time between '{0}' and '{1}'"
, queryInfo.start_time.ToLocalTime().ToString("yyyy/MM/dd HH:mm:ss")
, queryInfo.end_time.ToLocalTime().ToString("yyyy/MM/dd HH:mm:ss")
);
}
if (queryInfo.playerId != 0)
{
sqlCondi += " and uid = " + queryInfo.playerId;
}
if (!string.IsNullOrEmpty(filter))
{
sqlCondi += GetFilterStringByJson(filter);
}
string sql = string.Format("SELECT orderID FROM receipt where 1 {0}", sqlCondi);
UInt64 totalCost = 0;
gmt.Server server = gmt.Server.GetServerAt(0);
DatabaseAssistant.Execute(reader =>
{
while (reader.Read())
{
string orderInfo = reader.GetString(0);
string[] orderArray = orderInfo.Split(',');
mw.RmbShopConfig config = null;
string index = string.Format("{0}-{1}", orderArray[1], orderArray[4]);
TableManager.RmbShopTable.TryGetValue(index, out config);
int cost = (null == config) ? config.rmb_cost : 0;
totalCost += (uint)cost;
}
},
server.BillDatabaseAddress,
server.BillDatabasePort,
server.BillDatabaseCharSet,
server.BillDatabase,
server.BillDatabaseUserId,
server.BillDatabasePassword,
sql);
return(string.Format(@"{{ ""totalCost"": {0} }}", totalCost));
}
public static string QueryPlayerData(int server_id)
{
gmt.Server server = gmt.Server.GetServerAt(server_id);
GetPlayerDataFromDB(server);
System.Data.DataTable dt = DicToTable();
if (ExportExcel.DoExport(dt, server.Name))
{
return("[{\"error\":0}]");
}
else
{
return("[{\"error\":1}]");
}
}
/// <summary>
/// 发送给服务器
/// </summary>
/// <param name="output">输出文本</param>
/// <param name="server">服务器</param>
/// <param name="sendBuffer">缓冲区</param>
/// <returns>输出文本</returns>
private static string Send2Server(string output, gmt.Server server, byte[] sendBuffer)
{
output += string.Format(TableManager.GetGMTText(235) + "{0}:", server.Name);
if (AGmPage.ExecuteGmCommand(server, "0", Encoding.UTF8.GetBytes("3"), sendBuffer, false, null))
{
output += TableManager.GetGMTText(755) + "<br />";
}
else
{
output += TableManager.GetGMTText(756) + "<br />";
}
return(output);
}
/// <summary>
/// 页面载入响应
/// </summary>
protected override void OnGmPageLoad()
{
if (!this.IsPostBack)
{
for (int i = 0; i < gmt.Server.Count; ++i)
{
gmt.Server server = gmt.Server.GetServerAt(i);
this.fromDropDownList.Items.Add(new ListItem(server.Name, server.Name));
this.toDropDownList.Items.Add(new ListItem(server.Name, server.Name));
}
}
this.outputLabel.Text = "";
}
/// <summary>
/// 获取服务器开服活动时间
/// </summary>
public static bool GetActivityOpenTime(gmt.Server server, out STDateInfo stInfo)
{
mw.GS_SVR_DATE_INFO svrDateInfo = null;
#region 从数据库读取信息
DatabaseAssistant.Execute(
reader =>
{
if (reader.Read())
{
int nIdx = 0;
if (!reader.IsDBNull(nIdx))
{
long size = reader.GetBytes(nIdx, 0, null, 0, int.MaxValue);
if (0 != size)
{
byte[] dateBuffer = new byte[size];
reader.GetBytes(nIdx, 0, dateBuffer, 0, dateBuffer.Length);
using (MemoryStream stream = new MemoryStream(dateBuffer))
{
svrDateInfo = ProtoSerializer.Instance.Deserialize(stream, null, typeof(mw.GS_SVR_DATE_INFO)) as mw.GS_SVR_DATE_INFO;
}
}
}
}
},
server.DatabaseAddress,
server.DatabasePort,
server.DatabaseCharSet,
server.GameDatabase,
server.DatabaseUserId,
server.DatabasePassword,
"SELECT `svr_date_data` FROM `global`;"
);
#endregion
stInfo = new STDateInfo();
if (null != svrDateInfo)
{
stInfo.openDate = svrDateInfo.openDate;
stInfo.curSDate = svrDateInfo.signDate;
stInfo.nextSDate = svrDateInfo.singReset;
stInfo.rmbDate = svrDateInfo.rmbDate;
return(true);
}
return(false);
}
public static string QueryServerData(string channel_id, DateTime date_start, DateTime date_end)
{
List <STServerTableData> listTable = new List <STServerTableData>();
for (int i = 0; i < gmt.Server.Count; ++i)
{
gmt.Server server = gmt.Server.GetServerAt(i);
if (server != null)
{
if (!GetServerDataFromDB(server, channel_id, date_start, date_end, ref listTable))
{
break;
}
}
}
return(JsonConvert.SerializeObject(listTable));
}
protected void firstChargeResetButton_Click(object sender, EventArgs e)
{
if (this.selectListBox.Items.Count == 0)
{
this.errorLabel.Text = TableManager.GetGMTText(734);
return;
}
foreach (var item in this.selectListBox.Items)
{
gmt.Server server = gmt.Server.GetServer(item.ToString());
if (server != null)
{
string gmcmd = "RDATE()";
AGmPage.ExecuteGmCommand("SYSTEM", server, "0", gmcmd, "", true, null);
}
}
}
/// <summary>
/// 确认设置按钮点击响应
/// </summary>
protected void ActivityOpenButton_Click(object sender, EventArgs e)
{
gmt.Server keyServer = gmt.Server.GetServerAt(this.OpentimeserverList.SelectedIndex);
string[] date = this.expiryDateTextBox.Text.Split('/');
if (keyServer != null)
{
if (this.ExecuteGmCommand("0", string.Format("ODATE({0},{1},{2})", date[0], date[1], date[2]), "", true, text => { this.reportLabel.Text = text; }))
{
UpdateActivityOpenTimeListBox();
}
}
else
{
this.reportLabel.Text = TableManager.GetGMTText(423);
}
}
public static string QueryPlayerCnt(string filter)
{
string sqlCondi = "";
if (queryInfo.start_time == null || queryInfo.end_time == null)
{
sqlCondi = string.Format(" last_update_time between '{0}' and '{1}'"
, queryInfo.start_time.ToLocalTime().ToString("yyyy/MM/dd HH:mm:ss")
, queryInfo.end_time.ToLocalTime().ToString("yyyy/MM/dd HH:mm:ss")
);
}
if (queryInfo.playerId != 0)
{
sqlCondi += " and uid = " + queryInfo.playerId;
}
if (!string.IsNullOrEmpty(filter))
{
sqlCondi += GetFilterStringByJson(filter);
}
string sql = string.Format("SELECT COUNT(DISTINCT(userID)) FROM receipt where 1 {0}", sqlCondi);
int playerCnt = 0;
gmt.Server server = gmt.Server.GetServerAt(0);
DatabaseAssistant.Execute(reader =>
{
if (reader.Read())
{
playerCnt = reader.GetInt32(0);
}
},
server.BillDatabaseAddress,
server.BillDatabasePort,
server.BillDatabaseCharSet,
server.BillDatabase,
server.BillDatabaseUserId,
server.BillDatabasePassword,
sql);
return(string.Format(@"{{ ""playerCnt"": {0} }}", playerCnt));
}
public static string GetServerList()
{
List <PHServerData> sList = new List <PHServerData>();
for (int i = 0; i < gmt.Server.Count; i++)
{
PHServerData ph = new PHServerData();
ph.id = i;
gmt.Server server = gmt.Server.GetServerAt(i);
ph.name = server.Name;
sList.Add(ph);
}
if (sList.Count > 0)
{
return(JsonConvert.SerializeObject(sList));
}
return("[{\"error\":1}]");
}
/// <summary>
/// 发放全员礼包按钮点击响应
/// </summary>
protected void wholeGiftButton_Click(object sender, EventArgs e)
{
int giftId = 0;
if (!int.TryParse(this.giftOptionDropDownList.SelectedValue, out giftId))
{
return;
}
uint playerId = 0;
bool isGiftTimeOn = (Request.Form["gift_timer_checker"] == "on") ? true : false;
string give_time = this.datetimepicker_1.Value;
string gmcmd = string.Format("GIFT({0},{1})", playerId, giftId);
string account = Session["user"] as string;
for (int i = 0; i < selectListBox.Items.Count; ++i)
{
gmt.Server server = gmt.Server.GetServer(selectListBox.Items[i].Text);
if (server == null)
{
this.errorLabel.Text += TableManager.GetGMTText(733) + ":" + selectListBox.Items[i].Text;
continue;
}
if (isGiftTimeOn)
{
STTimedMail stMailInfo = new STTimedMail();
stMailInfo.uid = playerId;
stMailInfo.mailId = giftId;
stMailInfo.serverName = selectListBox.Items[i].Text;
stMailInfo.sendTime = CUtils.GetTimestamp(Convert.ToDateTime(give_time));
stMailInfo.cmd = gmcmd;
TimedMailSender.AddTimedMail(stMailInfo);
}
else
{
AGmPage.ExecuteGmCommand(account, server, playerId.ToString(), gmcmd, "", true, text => this.errorLabel.Text += text);
}
}
}
protected void delItemButton_Click(object sender, EventArgs e)
{
if (this.selectListBox.Items.Count != 1 ||
string.IsNullOrEmpty(this.selectListBox.Items[0].Value))
{
this.errorLabel.Text = TableManager.GetGMTText(720);
return;
}
if (string.IsNullOrEmpty(this.uidTextBox.Text))
{
this.errorLabel.Text = TableManager.GetGMTText(721);
return;
}
gmt.Server server = gmt.Server.GetServer(this.selectListBox.Items[0].Value);
uint playerId = this.GetPlayerId();
int count = 0;
string gmCommand = string.Empty;
if (!int.TryParse(this.itemDelCountTextBox.Text, out count) || count == 0)
{
this.errorLabel.Text = TableManager.GetGMTText(732);
return;
}
if (playerId != 0)
{
this.needReturn = true;
int type = GetRwdID4DelItemIdx(this.itemDelTypeDropDownList.SelectedIndex);
if (type == -1)
{
return;
}
gmCommand = string.Format("DI({0},{1},{2})", type, this.itemDelOptionDropDownList.SelectedItem.Value, count);
string account = Session["user"] as string;
AGmPage.ExecuteGmCommand(account, server, playerId.ToString(), gmCommand, "", true, text => this.errorLabel.Text += text);
}
}
/// <summary>
/// 关服按钮点击响应
/// </summary>
protected void shutdownButton_Click(object sender, EventArgs e)
{
if (selectListBox.Items.Count == 0)
{
this.errorLabel.Text = TableManager.GetGMTText(720);
}
string account = Session["user"] as string;
for (int i = 0; i < selectListBox.Items.Count; ++i)
{
gmt.Server server = gmt.Server.GetServer(selectListBox.Items[i].Text);
if (server == null)
{
this.errorLabel.Text += TableManager.GetGMTText(733) + ":" + selectListBox.Items[i].Text;
continue;
}
AGmPage.ExecuteGmCommand(account, server, "0", "SDN()", "", true, text => this.errorLabel.Text += text);
}
}
/// <summary>
/// 复制走马灯按钮点击响应
/// </summary>
protected void copyRevolvingButton_Click(object sender, EventArgs e)
{
gmt.Server server = Session["Server"] as gmt.Server;
if (server == null)
{
return;
}
foreach (var item in this.selectListBox.Items)
{
if (item.ToString() == this.serverList.Text)
{
continue;
}
RevolvingManager.Copy(server, gmt.Server.GetServer(item.ToString()));
}
RevolvingManager.Save();
RevolvingManager.UpdateService();
}
public static string QuerySevenData(string channel_num, int week_num)
{
List <STSevenData> sdList = new List <STSevenData>();
for (int i = 0; i < gmt.Server.Count; ++i)
{
gmt.Server server = gmt.Server.GetServerAt(i);
if (server != null)
{
ActivityOpenTime.STDateInfo stInfo;
ActivityOpenTime.GetActivityOpenTime(server, out stInfo);
//2017-09-15 23:59:59
DateTime dt = TimeZone.CurrentTimeZone.ToLocalTime(new System.DateTime(1970, 1, 1)) + TimeSpan.FromSeconds(stInfo.openDate);
string start_time = dt.AddDays(7 * week_num - 7).ToString("yyyy-MM-dd 00:00:00");
string end_time = dt.AddDays(7 * week_num - 1).ToString("yyyy-MM-dd 23:59:59");
GetSevenDataFromDB(server, channel_num, start_time, end_time, ref sdList);
}
}
return(JsonConvert.SerializeObject(sdList));
}
/// <summary>
/// 复制公告钮点击响应
/// </summary>
protected void copyNoticeButton_Click(object sender, EventArgs e)
{
gmt.Server server = Session["Server"] as gmt.Server;
string account = Session["user"] as string;
if (server == null)
{
return;
}
foreach (var item in this.selectListBox.Items)
{
if (item.ToString() == this.serverList.Text)
{
continue;
}
NoticeManager.Copy(account, server, gmt.Server.GetServer(item.ToString()));
}
NoticeManager.Save();
}
/// <summary>
/// 执行数据库
/// </summary>
/// <param name="server">服务器</param>
/// <param name="fileName">SQL文件名</param>
/// <returns>是否成功</returns>
protected bool Execute(gmt.Server server, string fileName)
{
string file = HttpRuntime.AppDomainAppPath + fileName;
if (File.Exists(file))
{
using (var reader = File.OpenText(file))
{
return(DatabaseAssistant.Execute
(
server.DatabaseAddress,
server.DatabasePort,
server.DatabaseCharSet,
server.GameDatabase,
server.DatabaseUserId,
server.DatabasePassword,
reader.ReadToEnd()
));
}
}
return(false);
}
/// <summary>
/// 执行GM命令
/// </summary>
/// <param name="playerId">玩家编号</param>
/// <param name="commandText">命令文本</param>
/// <param name="operateText">操作文本</param>
/// <param name="needReturn">是否需要返回</param>
/// <param name="reportProcess">报告处理</param>
/// <returns>是否成功</returns>
protected override bool ExecuteGmCommand(string playerId, string commandText, string operateText, bool needReturn, Action <string> reportProcess)
{
if (this.selectListBox.Items.Count == 0)
{
this.errorLabel.Text = TableManager.GetGMTText(740);
return(false);
}
bool success = true;
string account = Session["user"] as string;
foreach (var item in this.selectListBox.Items)
{
gmt.Server server = gmt.Server.GetServer(item.ToString());
if (server != null)
{
success &= AGmPage.ExecuteGmCommand(account, server, playerId, commandText, operateText, needReturn, reportProcess);
}
}
return(success);
}
