/// <summary>
/// 帐户/角色封停,帐户:1,角色:2
/// </summary>
public static string URlock(string UserOrRole, string taskid, string locktype)
{
if (!WinUtil.IsNumber(taskid) || !WinUtil.IsNumber(locktype))
{
return("命令传输错误");
}
try
{
int uorr = Convert.ToInt32(UserOrRole);
string sql = @"SELECT F_GameName,F_GameBigZone,F_GUserID,F_GUserName,F_GRoleID,F_GRoleName FROM T_Tasks where F_ID= " + taskid;
DataSet ds = DbHelperSQL.Query(sql);
if (ds == null || ds.Tables[0].Rows.Count == 0)
{
return("此工单已经不存在");
}
DataRow dr = ds.Tables[0].Rows[0];
string url = GetWebServUrl(dr["F_GameName"].ToString(), dr["F_GameBigZone"].ToString());
if (url.Trim().Length == 0)
{
return("服务器:WEBSERVICE地址配置不正确");
}
else
{
webserv.Url = url;
webserv.Credentials = System.Net.CredentialCache.DefaultCredentials;
}
sql = @"SELECT F_ID,F_ParentID,F_Name,F_Value,F_IsUsed,F_Sort FROM T_GameConfig where F_ID=" + locktype;
DataSet dsc = DbHelperSQL.Query(sql);
if (dsc == null)
{
return("服务器WEBSERVICE配置错误");
}
DataRow drc = dsc.Tables[0].Rows[0];
string reback = "";
if (uorr == 1)
{
reback = webserv.SetUserLock(dr["F_GUserID"].ToString(), dr["F_GUserName"].ToString(), locktype, drc["F_Value"].ToString());
}
else if (uorr == 2)
{
reback = webserv.SetRoleLock(dr["F_GRoleID"].ToString(), dr["F_GRoleName"].ToString(), locktype, drc["F_Value"].ToString());
}
return(reback);
}
catch (System.Exception ex)
{
ShareData.Log.Error(ex);
return(ex.Message);
}
}
/// <summary>
/// 删除全服邮件
/// </summary>
public static string DeleteFullServiceEmail(string taskid)
{
if (!WinUtil.IsNumber(taskid))
{
return("命令传输错误");
}
try
{
string reback = string.Empty;
string sql = @"SELECT F_GameName,F_URInfo,F_TUseData FROM T_Tasks WITH(NOLOCK) where F_ID= " + taskid + "";
DataSet ds = DbHelperSQL.Query(sql);
if (ds == null || ds.Tables[0].Rows.Count == 0)
{
return("此工单已经不存在");
}
string str1 = "DELETE FROM OPENQUERY (LKSV_GSS_7_gspara_db_0_1,'SELECT * FROM sys_loss_award_table WHERE DBID=" + taskid + "' )";
string str2 = "DELETE FROM dbo.T_Tasks WHERE F_ID=" + taskid;
int res = DbHelperSQL.ExecuteSql(str1);
int res1 = DbHelperSQL.ExecuteSql(str2);
if (res1 > 0)
{
reback = "true";
}
else
{
reback = "false";
}
return(reback);
}
catch (System.Exception ex)
{
ShareData.Log.Error(ex);
return(ex.Message);
}
}
/// <summary>
/// 帐户/角色解封,帐户:1,角色:2
/// </summary>
public static string URNolock(string UserOrRole, string taskid)
{
if (!WinUtil.IsNumber(taskid))
{
return("命令传输错误");
}
try
{
string.Format("unlock action is user or role (1->user,2->role ),input=[{0}]", UserOrRole);
int uorr = Convert.ToInt32(UserOrRole);
string sql = @"SELECT F_GameName,F_GameBigZone,F_GUserID,F_GUserName,F_GRoleID,F_GRoleName FROM T_Tasks WITH(NOLOCK) where F_ID= " + taskid + "";
DataSet ds = DbHelperSQL.Query(sql);
if (ds == null || ds.Tables[0].Rows.Count == 0)
{
return("此工单已经不存在");
}
DataRow dr = ds.Tables[0].Rows[0];
string url = GetWebServUrl(dr["F_GameName"].ToString(), dr["F_GameBigZone"].ToString());
string.Format("url->{0}", url).Logger();
if (url.Trim().Length == 0)
{
return("服务器:WEBSERVICE地址配置不正确");
}
else
{
webserv.Url = url;
webserv.Credentials = System.Net.CredentialCache.DefaultCredentials;
}
string reback = string.Empty;
if (uorr == 1)
{
"will unlock user unlock".Logger();
reback = webserv.SetUserNoLock(dr["F_GUserID"].ToString());
}
else if (uorr == 2)
{
"will unlock role unlock".Logger();
reback = webserv.SetRoleNoLock(dr["F_GRoleID"].ToString());
}
string.Format("response result:{0}", reback).Logger();
return(reback);
}
catch (System.Exception ex)
{
ex.Message.Logger();
ShareData.Log.Error(ex);
return(ex.Message);
}
}
/// <summary>
/// 检查提交的数据
/// </summary>
private bool CheckData()
{
string msg = "";
if (comboBoxZoneList.SelectedIndex == 0)
{
msg += "请选择要查询的战区\n";
}
//SQL语句查询
if (labelTool0.BorderStyle == BorderStyle.Fixed3D)
{
if (RichTextBoxSql.Text.Trim().Length == 0 || !CheckQuerySql(RichTextBoxSql.Text.Trim()))
{
msg += "SQL查询命令不正确\n";
}
}
//FDBI查询
if (labelTool3.BorderStyle == BorderStyle.Fixed3D)
{
if (comboBoxType0.SelectedIndex == 0)
{
msg += "请选择查询类型\n";
}
if (tboxUID.Text.Length > 0 && !WinUtil.IsNumber(tboxUID.Text))
{
msg += "帐号UID应该为数字\n";
}
if (tboxCID.Text.Length > 0 && !WinUtil.IsNumber(tboxCID.Text))
{
msg += "角色CID应该为数字\n";
}
if (tboxPARA_1.Text.Length > 0 && !WinUtil.IsNumber(tboxPARA_1.Text))
{
msg += "参数1应该为数字\n";
}
if (tboxPARA_2.Text.Length > 0 && !WinUtil.IsNumber(tboxPARA_2.Text))
{
msg += "参数2应该为数字\n";
}
}
if (msg.Length > 0)
{
MsgBox.Show(msg, LanguageResource.Language.Tip_Tip, MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(false);
}
else
{
return(true);
}
}
private void textBoxTs_TextChanged(object sender, EventArgs e)
{
textBoxTs.Text = textBoxTs.Text.Trim();
if (textBoxTs.Text.IndexOf("0") == 0 && textBoxTs.Text.Length > 1)
{
textBoxTs.Text = textBoxTs.Text.Substring(1);
}
if (textBoxTs.Text.Length > 0 && !WinUtil.IsNumber(textBoxTs.Text))
{
textBoxTs.Text = "0";
}
}
/// <summary>
/// 公告工具:发奖工具
/// </summary>
public static string GameGiftAwardDo(string taskid)
{
if (!WinUtil.IsNumber(taskid))
{
return("命令传输错误");
}
try
{
string sql = @"SELECT F_GameName,F_GameBigZone,F_URInfo,F_TUseData,F_TToolUsed,F_COther FROM T_Tasks WITH(NOLOCK) where F_ID= " + taskid + "";
DataSet ds = DbHelperSQL.Query(sql);
if (ds == null || ds.Tables[0].Rows.Count == 0)
{
return("此工单已经不存在");
}
if (ds.Tables[0].Rows[0]["F_TToolUsed"].ToString() == "True")
{
return("此工单下的发奖信息已经执行");
}
DataRow dr = ds.Tables[0].Rows[0];
string giftstr = dr["F_COther"].ToString();
byte[] dsuser = (byte[])GSSCSFrameWork.DataSerialize.GetObjectFromString(dr["F_URInfo"].ToString());
if (dsuser == null)
{
return("工单中的游戏用户列表为空");
}
string url = GetWebServUrl(dr["F_GameName"].ToString(), dr["F_GameBigZone"].ToString());
if (url.Trim().Length == 0)
{
return("GSS服务器:WEBSERVICE地址配置不正确;");
}
else
{
webserv.Url = url;
webserv.Credentials = System.Net.CredentialCache.DefaultCredentials;
return(webserv.GameGiftAwardDoFor5Num(taskid, giftstr, dsuser));
}
}
catch (System.Exception ex)
{
ShareData.Log.Error(ex);
return(ex.Message);
}
}
private void buttonCode_Click(object sender, EventArgs e)
{
if (buttonCode.Text == LanguageResource.Language.LblPreview)
{
buttonCode.Text = LanguageResource.Language.LblEdit;
CodeStr = aRichTextBoxCode.Text;
//转换颜色
string codeBeginStr = "";
string colorlistStr = "";
string Gnotice = aRichTextBoxCode.Text.Replace("\n", "\\par").Replace("&199", "}");
System.Collections.ArrayList colorlist = new System.Collections.ArrayList();
for (int i = 0; i < Gnotice.Length - 10; i++)
{
if (Gnotice.Substring(i, 2) == "&2")
{
codeBeginStr = Gnotice.Substring(i + 2, 9);
if (WinUtil.IsNumber(codeBeginStr))
{
colorlist.Add(codeBeginStr);
}
}
}
int colorindex = 4;
foreach (object colora in colorlist)
{
colorlistStr += "\\red" + colora.ToString().Substring(0, 3) + "\\green" + colora.ToString().Substring(3, 3) + "\\blue" + colora.ToString().Substring(6, 3) + ";";
Gnotice = Gnotice.Replace("&2" + colora.ToString(), @"{\cf" + colorindex.ToString());
colorindex++;
}
changStrColor = @"{\rtf1\ansi\deff0{\fonttbl{\f0\fnil\fcharset134 \'cb\'ce\'cc\'e5;}}{\colortbl ;\red255\green0\blue0;\red30\green20\blue160;\red80\green200\blue60;" + colorlistStr + @"}\viewkind4\uc1\pard\li300\lang2052\f0\fs18 " + Gnotice;
changStrColor += @"}";
aRichTextBoxCode.RTF = changStrColor;
}
else
{
buttonCode.Text = LanguageResource.Language.LblPreview;
aRichTextBoxCode.Text = CodeStr;
}
aRichTextBoxCode.TextChangeds += new GSSUI.AControl.ARichTextBox.ARichTextBoxE.TextChangedkEventHandler(this.aRichTextBoxCode_TextChanged);
}
/// <summary>
/// 清空防沉迷
/// </summary>
public static string GameResetChildInfo(string taskid)
{
if (!WinUtil.IsNumber(taskid))
{
return("命令传输错误");
}
try
{
string sql = @"SELECT F_GameName,F_GameBigZone,F_GUserID,F_GUserName,F_GRoleID,F_GRoleName FROM T_Tasks WITH(NOLOCK) where F_ID= " + taskid + "";
DataSet ds = DbHelperSQL.Query(sql);
if (ds == null || ds.Tables[0].Rows.Count == 0)
{
return("此工单已经不存在");
}
DataRow dr = ds.Tables[0].Rows[0];
string url = GetWebServUrl(dr["F_GameName"].ToString(), dr["F_GameBigZone"].ToString());
if (url.Trim().Length == 0)
{
return("服务器:WEBSERVICE地址配置不正确");
}
else
{
webserv.Url = url;
webserv.Credentials = System.Net.CredentialCache.DefaultCredentials;
}
string reback = "";
reback = webserv.ClearChildDisInfo(dr["F_GUserID"].ToString());
return(reback);
}
catch (System.Exception ex)
{
ShareData.Log.Error(ex);
return(ex.Message);
}
}
/// <summary>
/// 服务端数据保存
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button1_Click(object sender, EventArgs e)
{
try
{
string gssip = cbGSSip.Text;
string gssport = tPort.Text.Trim();
if (!WinUtil.isIpaddres(gssip))
{
MessageBox.Show("服务器IP地址格式不正确!");
return;
}
if (!WinUtil.IsNumber(gssport))
{
MessageBox.Show("服务器端口号应该为数字!");
return;
}
string sql = "UPDATE GSSCONFIG SET GSSIP='" + gssip + "',GSSPORT='" + gssport + "'WHERE ID=1";
int row = DbHelperSQLite.ExecuteSql(sql);
if (row >= 1)
{
MessageBox.Show("服务端参数保存成功!", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("服务端参数保存失败!", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (System.Exception ex)
{
ex.ToString().ErrorLogger();
MessageBox.Show("服务端参数提交失败!", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Error);
//日志记录
ShareData.Log.Warn("服务端参数提交失败!" + ex.Message);
}
}
/// <summary>
/// 保存网络配置
/// </summary>
private void SaveConfig()
{
try
{
string gssip = tGSSIP.Text;
string gssport = tPort.Text.Trim();
if (!WinUtil.isIpaddres(gssip))
{
MsgBox.Show(LanguageResource.Language.Tip_ErrorServiceIPFormat);
return;
}
if (!WinUtil.IsNumber(gssport))
{
MsgBox.Show(LanguageResource.Language.Tip_PortShouldNumber);
return;
}
string sql = "UPDATE GSSCONFIG SET GSSIP='" + gssip + "',GSSPORT='" + gssport + "'WHERE ID=1";
int row = DbHelperSQLite.ExecuteSql(sql);
if (row >= 1)
{
MsgBox.Show(LanguageResource.Language.Tip_SuccessSaveNetConfig, LanguageResource.Language.Tip_Tip, MessageBoxButtons.OK, MessageBoxIcon.Information);
SetConfigView();
}
else
{
MsgBox.Show(LanguageResource.Language.Tip_ErrorSaveNetConfig, LanguageResource.Language.Tip_Tip, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (System.Exception ex)
{
ex.ToString().ErrorLogger();
MsgBox.Show(LanguageResource.Language.Tip_ErrorSaveNetConfigTip, LanguageResource.Language.Tip_Tip, MessageBoxButtons.OK, MessageBoxIcon.Error);
//日志记录
ShareData.Log.Error(ex);
}
}
/// <summary>
/// 公告工具:停止公告
/// </summary>
public static string GameNoticeStop(string taskid)
{
if (!WinUtil.IsNumber(taskid))
{
return("命令传输错误");
}
try
{
string sql = @"SELECT F_GameName,F_URInfo,F_TUseData FROM T_Tasks WITH(NOLOCK) where F_ID= " + taskid + "";
DataSet ds = DbHelperSQL.Query(sql);
if (ds == null || ds.Tables[0].Rows.Count == 0)
{
return("此工单已经不存在");
}
DataRow dr = ds.Tables[0].Rows[0];
string area = dr["F_TUseData"].ToString();
string[] TareaAs = area.Split('|');
foreach (string TareaA in TareaAs)
{
string[] TareaBs = TareaA.Split(',');
if (TareaBs.Length != 3)
{
return("公告范围参数不正确");
}
}
string reback = "";
string[] areaAs = area.Split('|');
foreach (string areaA in areaAs)
{
string[] areaBs = areaA.Split(',');
if (areaBs.Length == 3)
{
reback += "游戏大区" + areaBs[0] + ">>";
string url = GetWebServUrlID(dr["F_GameName"].ToString(), areaBs[0]);
if (url.Trim().Length == 0)
{
reback += "服务器:WEBSERVICE地址配置不正确;";
}
else
{
webserv.Url = url;
webserv.Credentials = System.Net.CredentialCache.DefaultCredentials;
reback += webserv.GameNoticeStop(taskid);
}
}
}
if (reback.Replace("true", "成功").Length + areaAs.Length * 2 == reback.Length)
{
reback = "true";
}
return(reback);
}
catch (System.Exception ex)
{
ShareData.Log.Error(ex);
return(ex.Message);
}
}
/// <summary>
/// 提交工单
/// </summary>
private void CommitTask()
{
GSSModel.Tasks model = GetTaskData();
string strErr = "";
if (model.F_Title.Length == 0)
{
strErr += "公告工单标题不能为空!\n";
}
if (model.F_GPeopleName.Length == 0)
{//在公告数据中是将发起人的数据存储到玩家信息中
strErr += LanguageResource.Language.LblInitiatorNameIsRequire + "!\n";
}
//edit hexw 2017-9-18 取消电话号码必须
//if (model.F_Telphone.Trim().Length == 0)
//{
// // strErr += LanguageResource.Language.LblTelNotAllowBlank + "！\n";
//}
//else if (!WinUtil.IsTelphone(model.F_Telphone) && !WinUtil.IsMobile(model.F_Telphone))
//{
// strErr += LanguageResource.Language.LblTelFormIsError + "！\n(格式:010-88886666或13912341234)\n";
//}
if (string.IsNullOrEmpty(model.F_URInfo))
{
strErr += LanguageResource.Language.Tip_NoticeMessgaeIsRequired + "！\n";
}
else if (model.F_URInfo.Length > 300)
{
strErr += LanguageResource.Language.Tip_LimitNoticeMsgLength + "\r\n";
}
if (model.F_TUseData.Trim().Length == 0)
{
strErr += "请选择接收范围!\n";
}
int row = 1;
foreach (string sstr in aRichTextBoxCode.Lines)
{
string[] param = sstr.Split('|');
if (param.Length != 6)
{
strErr += "公告内容:行" + row + "需要6个参数!\n";
}
else
{
if (param[1].Split(',').Length != 2)
{
strErr += "公告内容:行" + row + "参数2格式不正确!\n";
}
else
{
if (!WinUtil.IsNumber(param[1].Split(',')[0]) || !WinUtil.IsNumber(param[1].Split(',')[1]))
{
strErr += "公告内容:行" + row + "参数2格式不正确!\n";
}
}
if (!WinUtil.IsNumber(param[2]))
{
strErr += "公告内容:行" + row + "参数3格式不正确!\n";
}
if (!WinUtil.IsDateTime(param[3]))
{
strErr += "公告内容:行" + row + "参数4格式不正确!\n";
}
if (!WinUtil.IsDateTime(param[4]))
{
strErr += "公告内容:行" + row + "参数5格式不正确!\n";
}
if (!WinUtil.IsNumber(param[5]))
{
strErr += "公告内容:行" + row + "参数6格式不正确!\n";
}
}
row++;
}
if (model.F_Note.Trim().Length == 0)
{
strErr += LanguageResource.Language.Tip_RemarkNoEmpty + "!\n";
}
if (strErr != "")
{
MsgBox.Show(strErr, LanguageResource.Language.Tip_Tip, MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
string backStr = _clienthandle.AddTaskSyn(model);
ComitDoControl(true);
if (backStr == "0")
{
MsgBox.Show(LanguageResource.Language.Tip_WorkOrderCreateFailure, LanguageResource.Language.Tip_Tip, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
MsgBox.Show(LanguageResource.Language.Tip_WorkOrderCreateSucc + "!", LanguageResource.Language.Tip_Tip, MessageBoxButtons.OK, MessageBoxIcon.Information);
_taskid = backStr;
this.Close();
}
}
