/// <summary>
/// 提交工单
/// </summary>
private void CommitTask()
{
string Title = "";
string Note = rboxNote.Text;
int From = SystemConfig.AppID;//客服中心
int VipLevel = int.Parse(cboxVIP.SelectedValue.ToString());
DateTime?LimitTime = GetLimitTime();
int LimitType = int.Parse(cboxLimitTime.SelectedValue.ToString());
int? Type = _tasktype; //角色异常
int State = SystemConfig.DefaultWorkOrderStatue; //等待处理
int GameName = SystemConfig.GameID; //寻龙记
int? DutyMan = null;
int? PreDutyMan = null;
int CreatMan = int.Parse(ShareData.UserID);
DateTime CreatTime = DateTime.Now;
int EditMan = int.Parse(ShareData.UserID);
DateTime EditTime = DateTime.Now;
string URInfo = lblURinfo.Text;
int Rowtype = 0;
string strErr = "";
if (Note.Trim().Length == 0)
{
strErr += LanguageResource.Language.Tip_RemarkNoEmpty + "！\n";
}
if (strErr != "")
{
MsgBox.Show(strErr, LanguageResource.Language.Tip_Tip, MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
ComitDoControl(false);
GSSModel.Tasks model = new GSSModel.Tasks();
model.F_Title = Title;
model.F_Note = Note;
model.F_From = From;
model.F_VipLevel = VipLevel;
model.F_LimitType = LimitType;
model.F_LimitTime = LimitTime;
model.F_Type = Type;
model.F_State = State;
model.F_GameName = GameName;
model.F_DutyMan = DutyMan;
model.F_PreDutyMan = PreDutyMan;
model.F_CreatMan = CreatMan;
model.F_CreatTime = CreatTime;
model.F_EditMan = EditMan;
model.F_EditTime = EditTime;
model.F_URInfo = URInfo;
model.F_Rowtype = Rowtype;
_clienthandle.AddTask(model);
}
private void ButtonClose_Click(object sender, EventArgs e)
{
if (lblTaskID.Text.Trim().Length == 0)
{
return;
}
tboxNote.Text = "寻龙记感谢您的支持,谢谢!(暂不回复给玩家)";
GSSModel.Tasks model = new GSSModel.Tasks();
model.F_ID = Convert.ToInt32(lblTaskID.Text);
model.F_Note = tboxNote.Text;
model.F_EditMan = Convert.ToInt32(ShareData.UserID);
model.F_EditTime = DateTime.Now;
model.F_TToolUsed = true;
model.F_OCanRestor = true;
model.F_Rowtype = 6;//聊天
string msg = string.Format("【你说:{0}】\n{1}\n", model.F_EditTime, model.F_Note);
tboxNote.Text = "";
model.F_State = 100100100;
model.F_DutyMan = -1;
MsgPrint(msg);
//string back = _clienthandle.EditTaskSyn(model);
GSSBLL.Tasks bll = ClientRemoting.Tasks();
int back = bll.Edit(model);
if (back == 0)
{
MsgPrint("--发送失败--");
}
DGVDelete();
tboxNote.Focus();
}
/// <summary>
/// 发送消息
/// </summary>
private void SendMSG()
{
if (lblTaskID.Text.Trim().Length == 0 || tboxNote.Text.Trim().Length == 0)
{
return;
}
GSSModel.Tasks model = new GSSModel.Tasks();
model.F_ID = Convert.ToInt32(lblTaskID.Text);
model.F_Note = tboxNote.Text;
model.F_EditMan = Convert.ToInt32(ShareData.UserID);
model.F_EditTime = DateTime.Now;
model.F_TToolUsed = true;
model.F_OCanRestor = null;
model.F_Rowtype = 6;//聊天
string msg = string.Format("【你说:{0}】\n{1}\n", model.F_EditTime, model.F_Note);
tboxNote.Text = "";
MsgPrint(msg);
//string back = _clienthandle.EditTaskSyn(model);
GSSBLL.Tasks bll = ClientRemoting.Tasks();
int back = bll.Edit(model);
if (back == 0)
{
MsgPrint("--发送失败--");
}
tboxNote.Focus();
}
/// <summary>
/// 编辑工单(服务端不回复信息)
/// </summary>
public void EditTaskNoReturn(GSSModel.Tasks task)
{
MsgStruts msg = new MsgStruts();
msg.command = msgCommand.EditTaskNoReturn;
msg.msgtype = msgType.SendText;
msg.msgsendstate = msgSendState.single;
msg.Data = DataSerialize.GetByteFromObject(task);
_tcpcli.Send(msg);
}
/// <summary>
/// 窗口之间消息
/// </summary>
/// <param name="m"></param>
protected override void DefWndProc(ref System.Windows.Forms.Message m)
{
switch (m.Msg)
{
case 601:
this.Activate();
if (_taskid == null || _taskid.Trim().Length == 0)
{
ComitDoControl(true);
return;
}
string msg = ShareData.Msg[m.WParam.ToInt32()].ToString(); //分为两段,FORM编号+返回结果(字符串:true或错误结果)
GSSModel.Tasks task = new GSSModel.Tasks();
task.F_ID = int.Parse(_taskid);
task.F_EditMan = int.Parse(ShareData.UserID);
task.F_EditTime = DateTime.Now;
task.F_TToolUsed = true;
task.F_TUseData = LanguageResource.Language.Tip_CloseDownTool + "-" + (_LockUorR == 1 ? LanguageResource.Language.BtnCloseDownAccount : LanguageResource.Language.BtnCloseDownRole) + "\n" + lblUR.Text + " 封停时间:" + cboxTime.Text + "\n";
task.F_Note = rtboxNote.Text;
_isToolUsed = true;
if (msg == "true")
{
task.F_TUseData += LanguageResource.Language.Tip_CloseDownSucc + " !";
_clihandle.EditTaskNoReturn(task);
MsgBox.Show(string.Format(LanguageResource.Language.Tip_CloseDownSuccFormat, lblUR.Text + "!"), LanguageResource.Language.Tip_Tip, MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
else if (msg == "2015")
{ //改用户之前已被封停
task.F_TUseData += LanguageResource.Language.Tip_CloseDownFailure + " !";
_clihandle.EditTaskNoReturn(task);
MsgBox.Show(string.Format(LanguageResource.Language.Tip_CloseDownFailureFormat, lblUR.Text + "!") + LanguageResource.Language.Tip_AccountHasBeenCloseDown, LanguageResource.Language.Tip_Tip, MessageBoxButtons.OK, MessageBoxIcon.Warning);
_clihandle.EditTaskNoReturn(task);
ComitDoControl(true);
}
else
{
task.F_TUseData += LanguageResource.Language.Tip_CloseDownFailure + " !" + msg;
MsgBox.Show(string.Format(LanguageResource.Language.Tip_CloseDownFailureFormat, lblUR.Text + "!") + msg, LanguageResource.Language.Tip_Tip, MessageBoxButtons.OK, MessageBoxIcon.Warning);
_clihandle.EditTaskNoReturn(task);
ComitDoControl(true);
}
base.DefWndProc(ref m);
break;
default:
base.DefWndProc(ref m);
break;
}
}
/// <summary>
/// 插入列表
/// </summary>
/// <param name="dr"></param>
/// <param name="img"></param>
public void DGVInsertF(int taskid, string rolename)
{
if (dgvRoleList.InvokeRequired)
{
delegate_DGVInsertF d = new delegate_DGVInsertF(DGVInsertF);
object arg0 = taskid;
object arg1 = rolename;
this.Invoke(d, arg0, arg1);
}
else
{
string imgTips = Application.StartupPath + "\\GSSData\\Images\\numerbgClear.png";
Image img = GetImage(imgTips);
bool isRoleAdd = true;
foreach (DataGridViewRow dgvr in dgvRoleList.Rows)
{
if (Convert.ToInt32(dgvr.Cells[0].Value) == taskid)
{
isRoleAdd = false;
//dgvRoleList.Rows.Remove(dgvr);
}
}
if (isRoleAdd)
{
try
{
GSSBLL.Tasks bll = ClientRemoting.Tasks();
GSSModel.Tasks model = new GSSModel.Tasks();
model.F_ID = taskid;
model.F_State = 100100101;
model.F_DutyMan = int.Parse(ShareData.UserID);
model.F_EditMan = int.Parse(ShareData.UserID);
model.F_EditTime = DateTime.Now;
model.F_TToolUsed = true;
model.F_OCanRestor = true;
model.F_Rowtype = 6;
model.F_Note = null;
bll.Edit(model);
Thread.Sleep(100);
dgvRoleList.Rows.Insert(0, taskid, rolename, img);
Application.DoEvents();
dgvRoleList.Rows[0].Selected = true;
Application.DoEvents();
dgvRoleList_SelectionChanged(null, null);
Application.DoEvents();
}
catch (System.Exception ex)
{
MsgBox.Show(LanguageResource.Language.Tip_ReceiverOnlineConsumeError, LanguageResource.Language.Tip_Tip, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
}
}
public void BindCommandWithSend(msgCommand cmd, int formid, GSSModel.Tasks task, object sendData)
{
MsgStruts msg = new MsgStruts();
msg.command = cmd;
msg.msgtype = msgType.SendText;
msg.msgsendstate = msgSendState.single;
GSSModel.Request.ClientData client = new GSSModel.Request.ClientData();
client.FormID = formid;
client.Data = new object[] { task, sendData };
//json 序列化
msg.Data = DataSerialize.GetByteFromObject(client);
_tcpcli.Send(msg);
}
/// <summary>
/// 编辑工单(同步)
/// </summary>
/// <param name="task"></param>
public string EditTaskSyn(GSSModel.Tasks task)
{
MsgStruts msg = new MsgStruts();
msg.command = msgCommand.EditTask;
msg.msgtype = msgType.SendText;
msg.msgsendstate = msgSendState.single;
msg.Data = DataSerialize.GetByteFromObject(task);
MsgStruts msgb = _tcpcli.SendAndBack(msg);
string backStr = _coder.GetEncodingString(msgb.Data, msgb.Data.Length);
return(backStr);
}
/// <summary>
/// 窗口之间消息
/// </summary>
/// <param name="m"></param>
protected override void DefWndProc(ref System.Windows.Forms.Message m)
{
switch (m.Msg)
{
case 601:
this.Activate();
string msg = ShareData.Msg[m.WParam.ToInt32()].ToString(); //分为两段,FORM编号+返回结果(字符串:true或错误结果)
if (_taskid == null || _taskid.Trim().Length == 0)
{
ComitDoControl(true);
return;
}
GSSModel.Tasks task = new GSSModel.Tasks();
task.F_ID = int.Parse(_taskid);
task.F_EditMan = int.Parse(ShareData.UserID);
task.F_EditTime = DateTime.Now;
task.F_TToolUsed = true;
task.F_TUseData = "清空防沉迷工具-清空防沉迷" + "\n" + lblUR.Text + "\n";
task.F_Note = rtboxNote.Text;
_isToolUsed = true;
if (msg == "true")
{
task.F_TUseData += " 清空防沉迷成功!";
_clihandle.EditTaskNoReturn(task);
MsgBox.Show("清空防沉迷成功!", LanguageResource.Language.Tip_Tip, MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
else
{
task.F_TUseData += " 清空防沉迷失败!" + msg;
MsgBox.Show("清空防沉迷失败!" + msg, LanguageResource.Language.Tip_Tip, MessageBoxButtons.OK, MessageBoxIcon.Warning);
_clihandle.EditTaskNoReturn(task);
ComitDoControl(true);
}
base.DefWndProc(ref m);
break;
default:
base.DefWndProc(ref m);
break;
}
}
//private void treeView1_AfterCheck(object sender, TreeViewEventArgs e)
//{
// if (e.Action == TreeViewAction.ByMouse)
// {
// //取消节点选中状态之后，取消所有父节点的选中状态
// setChildNodeCheckedState(e.Node, e.Node.Checked);
// //如果节点存在父节点，取消父节点的选中状态
// if (e.Node.Parent != null)
// {
// setParentNodeCheckedState(e.Node, e.Node.Checked);
// }
// //if (e.Node.Checked)
// //{
// // //取消节点选中状态之后，取消所有父节点的选中状态
// // setChildNodeCheckedState(e.Node, true);
// //}
// //else
// //{
// // //取消节点选中状态之后，取消所有父节点的选中状态
// // setChildNodeCheckedState(e.Node, false);
// // //如果节点存在父节点，取消父节点的选中状态
// // if (e.Node.Parent != null)
// // {
// // setParentNodeCheckedState(e.Node, false);
// // }
// //}
// }
//}
////取消节点选中状态之后，取消所有父节点的选中状态
//void setParentNodeCheckedState(TreeNode currNode, bool state)
//{
// TreeNode parentNode = currNode.Parent;
// parentNode.Checked = state;
// int num=0;
// for (int i=0;i<parentNode.Nodes.Count;i++)
// {
// if (parentNode.Nodes[i].Checked)
// {
// num++;
// }
// }
// if (num>0&&!state)
// {
// parentNode.StateImageIndex = 2;
// }
// if (currNode.Parent.Parent != null)
// {
// setParentNodeCheckedState(currNode.Parent, state);
// }
//}
////选中节点之后，选中节点的所有子节点
//void setChildNodeCheckedState(TreeNode currNode, bool state)
//{
// TreeNodeCollection nodes = currNode.Nodes;
// if (nodes.Count > 0)
// foreach (TreeNode tn in nodes)
// {
// tn.Checked = state;
// setChildNodeCheckedState(tn, state);
// }
//}
// // 调用 BuildTree 方法来创建 TreeView
//CreateTreeViewFromDataTable.BuildTree(
// this._dtEmployees, this.treeView1,
// true, "名字", "员工标识", "上级");
private void Button_Click(object sender, EventArgs e)
{//创建并立即执行
GSSModel.Tasks task = GetTaskData();
GSSModel.TaskContainerLogicData wl = new GSSModel.TaskContainerLogicData()
{
WorkOrder = task,
LogicData = new GSSModel.Request.RunTask()
{
Command = GSSCSFrameWork.msgCommand.GameNoticeStart.ToString()
}
};
GSSModel.Request.ClientData cd = new GSSModel.Request.ClientData()
{
Data = wl,
FormID = this.Handle.ToInt32()
};
_clienthandle.SendTaskContainerLogicData(cd);
}
/// <summary>
/// 增加工单(发奖)
/// </summary>
/// <param name="task"></param>
public string AddTaskSynGA(GSSModel.Tasks task, DataSet ds)
{
task.F_URInfo = DataSerialize.GetStringFromObject(DataSerialize.GetDataSetSurrogateZipBYtes(ds));
MsgStruts msg = new MsgStruts();
msg.command = msgCommand.AddTask;
msg.msgtype = msgType.SendText;
msg.msgsendstate = msgSendState.single;
msg.MsgParam.p0 = "AddTaskGA";
msg.Data = DataSerialize.GetByteFromObject(task);
MsgStruts msgb = _tcpcli.SendAndBack(msg);
string backStr = _coder.GetEncodingString(msgb.Data, msgb.Data.Length);
return(backStr);
}
/// <summary>
/// 游戏工具-角色恢复
/// </summary>
/// <param name="value"></param>
/// <returns></returns>
public int GSSTool_RoleRecover(GSSModel.Tasks model)
{
int rowsAffected = 0;
SqlParameter[] parameters =
{
new SqlParameter("@BigZoneID", SqlDbType.Int),
new SqlParameter("@ZoneID", SqlDbType.Int),
new SqlParameter("@UserID", SqlDbType.Int),
new SqlParameter("@RoleID", SqlDbType.Int),
new SqlParameter("@Result", SqlDbType.Int)
};
parameters[0].Value = model.F_GameBigZone;
parameters[1].Value = model.F_GameZone;
parameters[2].Value = model.F_GUserID;
parameters[3].Value = model.F_GRoleID;
parameters[4].Direction = ParameterDirection.Output;
DbHelperSQL.RunProcedure("_GSSTool_RoleRecover", parameters, out rowsAffected);
int id = (int)parameters[4].Value;
return(id);
}
public static string DisChatDel(GSSModel.Tasks task)
{
try
{
string url = "http://127.0.0.1/GSSWebService/ServiceXLJ.asmx";//GetWebServUrl(task.F_GameName.ToString(), "第一大区");//task.F_GameBigZone);
if (url.Trim().Length == 0)
{
return("GSS服务器:WEBSERVICE地址配置不正确;");
}
else
{
webserv.Url = url;
webserv.Credentials = System.Net.CredentialCache.DefaultCredentials;
return(webserv.DisChatDel(task.F_GUserID, task.F_GRoleID));
}
}
catch (System.Exception ex)
{
ShareData.Log.Error(ex);
return(ex.Message);
}
}
GSSModel.Tasks GetTaskData()
{
string Title = tboxTitle.Text.Trim();
string gpeoplename = tboxCreator.Text.Trim();
string telephone = tboxTelephone.Text.Trim();
string Note = rboxNote.Text.Trim();
int From = SystemConfig.AppID;//客服中心
int VipLevel = int.Parse(cboxVIP.SelectedValue.ToString());
DateTime?LimitTime = GetLimitTime();
int LimitType = int.Parse(cboxLimitTime.SelectedValue.ToString());
int? Type = _tasktype; //喊话工单
int State = SystemConfig.DefaultWorkOrderStatue; //等待处理
int GameName = SystemConfig.GameID; //寻龙记
int? DutyMan = null;
int? PreDutyMan = null;
int CreatMan = int.Parse(ShareData.UserID);
DateTime CreatTime = DateTime.Now;
int EditMan = int.Parse(ShareData.UserID);
DateTime EditTime = DateTime.Now;
string URInfo = aRichTextBoxCode.Text;
int Rowtype = 0;
bool isview = false;
if (buttonCode.Text == LanguageResource.Language.LblEdit)
{
isview = true;
buttonCode_Click(null, null);
}
int row1 = 0;
int row2 = 0;
string[] slines = aRichTextBoxCode.Lines;
string[] snewlines = new string[slines.Length];
foreach (string sstr in aRichTextBoxCode.Lines)
{
if (sstr.Replace("\n", "").Trim().Length > 0)
{
snewlines[row1] = slines[row2];
row1++;
}
row2++;
}
string[] snewliness = new string[row1];
Array.Copy(snewlines, 0, snewliness, 0, snewliness.Length);
aRichTextBoxCode.Lines = snewliness;
if (isview)
{
buttonCode_Click(null, null);
}
ComitDoControl(false);
GSSModel.Tasks model = new GSSModel.Tasks();
model.F_Title = Title;
model.F_GPeopleName = gpeoplename;
model.F_Telphone = telephone;
model.F_Note = Note;
model.F_From = From;
model.F_VipLevel = VipLevel;
model.F_LimitType = LimitType;
model.F_LimitTime = LimitTime;
model.F_Type = Type;
model.F_State = State;
model.F_GameName = GameName;
model.F_DutyMan = DutyMan;
model.F_PreDutyMan = PreDutyMan;
model.F_CreatMan = CreatMan;
model.F_CreatTime = CreatTime;
model.F_EditMan = EditMan;
model.F_EditTime = EditTime;
string ReceivArea = GetTreeValue();
model.F_TUseData = ReceivArea;
model.F_Rowtype = Rowtype;
model.F_URInfo = URInfo.Replace("\n", "www");
return(model);
}
/// <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();
}
}
private void aButtonGNUpdate_Click(object sender, EventArgs e)
{
// 发奖
string back = _clihandle.GameGiftAwardDo(_taskid.ToString());
GSSModel.Tasks task = new GSSModel.Tasks();
task.F_ID = _taskid;
task.F_EditMan = int.Parse(ShareData.UserID);
task.F_EditTime = DateTime.Now;
//task.F_Note = "发奖到游戏服务器"; Note改为存储发奖邮件内容,不更新
task.F_TToolUsed = true;
task.F_TUseData = "发奖操作 " + back;
//更新工单
_clihandle.EditTaskNoReturn(task);
// _IsChange = true;
SetGameUR();
if (back == "true")
{
MsgBox.Show("发奖到游戏服务器成功!", LanguageResource.Language.Tip_Tip, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MsgBox.Show("发奖失败," + back, LanguageResource.Language.Tip_Tip, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
//int EditMan = int.Parse(ShareData.UserID);
//DateTime EditTime = DateTime.Now;
//string URInfo = "";
//int? Rowtype = 0;
//string ReceivArea = "";
//string strErr = "";
//if (ReceivArea.Trim().Length == 0)
//{
// strErr += "请选择接收范围!\n";
//}
//if (model.F_URInfo == URInfo && model.F_TUseData == ReceivArea)
//{
// strErr += "公告内容没有更改,不需要更新!\n";
//}
//if (strErr != "")
//{
// MsgBox.Show(strErr, LanguageResource.Language.Tip_Tip, MessageBoxButtons.OK, MessageBoxIcon.Information);
// return;
//}
//GSSModel.Tasks model0 = new GSSModel.Tasks();
//model0.F_ID = _taskid;
//model0.F_EditMan = EditMan;
//model0.F_EditTime = EditTime;
//model0.F_URInfo = URInfo;
//model0.F_TUseData = ReceivArea;
//model0.F_Rowtype = Rowtype;
//string backStr = _clihandle.EditTaskSyn(model0);
//if (backStr == "0")
//{
// MsgBox.Show("已经更新公告到工单失败!", LanguageResource.Language.Tip_Tip, MessageBoxButtons.OK, MessageBoxIcon.Error);
//}
//else
//{
// MsgBox.Show("已经更新公告到工单成功!\n需要重新运行公告才会更新到游戏服务器", LanguageResource.Language.Tip_Tip, MessageBoxButtons.OK, MessageBoxIcon.Information);
//}
//_IsChange = true;
//SetGameUR();
}
/// <summary>
/// 更新数据(存储过程方式)
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int EditS(GSSModel.Tasks model)
{
return(dal.Edit(model));
}
/// <summary>
/// 提交工单
/// </summary>
private void CommitTask()
{
string Title = tboxTitle.Text.Trim();
string gpeoplename = tboxCreator.Text.Trim();
string telephone = tboxTelephone.Text.Trim();
string Note = rboxNote.Text.Trim();
int From = SystemConfig.AppID;//客服中心
int VipLevel = int.Parse(cboxVIP.SelectedValue.ToString());
DateTime?LimitTime = GetLimitTime();
int LimitType = int.Parse(cboxLimitTime.SelectedValue.ToString());
int? Type = _tasktype; //喊话工单
int State = SystemConfig.DefaultWorkOrderStatue; //等待处理
int GameName = SystemConfig.GameID; //寻龙记
int? DutyMan = null;
int? PreDutyMan = null;
int CreatMan = int.Parse(ShareData.UserID);
DateTime CreatTime = DateTime.Now;
int EditMan = int.Parse(ShareData.UserID);
DateTime EditTime = DateTime.Now;
string bigzonename = comboBoxGBigzone.Text.ToString();
// string giftStr = textBoxGiftID.Text + "|" + textBoxGiftName.Text + "|" + (radioButtonGiftType0.Checked ? "0" : "1") + "|" + textBoxGiftNum.Text;
//string URInfo = aRichTextBoxCode.Text;
int Rowtype = 0;
//string ReceivArea = GetTreeValue();
#region 道具赋值
StringBuilder sbItem = new StringBuilder();
int t = 0;
if (int.TryParse(tbItem1.Text, out t))
{
sbItem.Append(t);
if (int.TryParse(tbItemNum1.Text, out t))
{
sbItem.Append("|" + t);
}
else
{
sbItem.Append("|" + 0);
}
}
else
{
sbItem.Append(0 + "|" + 0);
}
if (int.TryParse(tbItem2.Text, out t))
{
sbItem.Append("|" + t);
if (int.TryParse(tbItemNum2.Text, out t))
{
sbItem.Append("|" + t);
}
else
{
sbItem.Append("|" + 0);
}
}
else
{
sbItem.Append("|" + 0 + "|" + 0);
}
if (int.TryParse(tbItem3.Text, out t))
{
sbItem.Append("|" + t);
if (int.TryParse(tbItemNum3.Text, out t))
{
sbItem.Append("|" + t);
}
else
{
sbItem.Append("|" + 0);
}
}
else
{
sbItem.Append("|" + 0 + "|" + 0);
}
if (int.TryParse(tbItem4.Text, out t))
{
sbItem.Append("|" + t);
if (int.TryParse(tbItemNum4.Text, out t))
{
sbItem.Append("|" + t);
}
else
{
sbItem.Append("|" + 0);
}
}
else
{
sbItem.Append("|" + 0 + "|" + 0);
}
if (int.TryParse(tbItem5.Text, out t))
{
sbItem.Append("|" + t);
if (int.TryParse(tbItemNum5.Text, out t))
{
sbItem.Append("|" + t);
}
else
{
sbItem.Append("|" + 0);
}
}
else
{
sbItem.Append("|" + 0 + "|" + 0);
}
if (int.TryParse(txtBlueDiamond.Text, out t))
{
sbItem.Append("|" + t);
}
else
{
sbItem.Append("|" + 0);
}
if (int.TryParse(txtMoney.Text, out t))
{
sbItem.Append("|" + t);
}
else
{
sbItem.Append("|" + 0);
}
#endregion
string giftStr = sbItem.ToString();
string strErr = "";
if (Title.Length == 0)
{
strErr += LanguageResource.Language.Tip_WorkOrderTiltleIsRequire + "!\n";
}
if (gpeoplename.Length == 0)
{
strErr += LanguageResource.Language.LblInitiatorNameIsRequire + "!\n";
}
if (telephone.Trim().Length < 6)
{
//取消电话号码判断
//strErr += LanguageResource.Language.LblTelFormIsError + "!\n";
}
if (Note.Trim().Length == 0)
{
strErr += LanguageResource.Language.Tip_RemarkNoEmpty + "!\n";
}
//if (DGVGameUser.Rows.Count == 0)
//{
// strErr += LanguageResource.Language.Tip_GameUseNotIsRequire + "!\n";
//}
if (aRichTextBoxUserList.Text.Trim().Length == 0)
{
strErr += LanguageResource.Language.Tip_GameUseNotIsRequire + "!\n";
}
GSSModel.Response.GameConfig big = GetComboBoxSelectValue(comboBoxBattlezone);
DataTable dt = new DataTable("table_a");
DataColumn dc = null;
dc = dt.Columns.Add("角色名称", System.Type.GetType("System.String"));
dc = dt.Columns.Add("战区编号", System.Type.GetType("System.String"));
string[] strUserInfo = aRichTextBoxUserList.Text.Trim().Split(Environment.NewLine.ToCharArray());
foreach (string userInfo in strUserInfo)
{
DataRow newRow;
newRow = dt.NewRow();
newRow["角色名称"] = userInfo;
newRow["战区编号"] = "-1";
dt.Rows.Add(newRow);
}
ds = new DataSet();
ds.Tables.Add(dt);
if (strErr != "")
{
MsgBox.Show(strErr, LanguageResource.Language.Tip_Tip, MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (ds == null)
{
MsgBox.Show(LanguageResource.Language.Tip_Error);
}
ComitDoControl(false);
GSSModel.Tasks model = new GSSModel.Tasks();
model.F_Title = Title;
model.F_GPeopleName = gpeoplename;
model.F_Telphone = telephone;
model.F_Note = Note;
model.F_From = From;
model.F_VipLevel = VipLevel;
model.F_LimitType = LimitType;
model.F_LimitTime = LimitTime;
model.F_Type = Type;
model.F_State = State;
model.F_GameName = GameName;
model.F_DutyMan = DutyMan;
model.F_PreDutyMan = rBID.Checked ? 0 : 1;//存储输入类型:ID或Name//PreDutyMan;
model.F_CreatMan = CreatMan;
model.F_CreatTime = CreatTime;
model.F_EditMan = EditMan;
model.F_EditTime = EditTime;
model.F_GameBigZone = bigzonename;
model.F_COther = giftStr;
model.F_Rowtype = Rowtype;
string backStr = _clienthandle.AddTaskSynGA(model, ds);
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();
}
}
/// <summary>
/// 工单:得到工单实体
/// </summary>
public static GSSModel.Tasks GetTaskModel(int taskid)
{
GSSModel.Tasks model = new GSSModel.Tasks();
DataSet ds = GetTaskCache("TaskList");
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
DataRow[] drs = ds.Tables[1].Select("F_ID=" + taskid + "");
if (drs.Length > 0)
{
if (drs[0]["F_ID"].ToString() != "")
{
model.F_ID = int.Parse(drs[0]["F_ID"].ToString());
}
if (drs[0]["F_Title"] != null)
{
model.F_Title = drs[0]["F_Title"].ToString();
}
if (drs[0]["F_Note"] != null)
{
model.F_Note = drs[0]["F_Note"].ToString();
}
if (drs[0]["F_From"].ToString() != "")
{
model.F_From = int.Parse(drs[0]["F_From"].ToString());
}
if (drs[0]["F_VipLevel"].ToString() != "")
{
model.F_VipLevel = int.Parse(drs[0]["F_VipLevel"].ToString());
}
if (drs[0]["F_LimitType"].ToString() != "")
{
model.F_LimitType = int.Parse(drs[0]["F_LimitType"].ToString());
}
if (drs[0]["F_LimitTime"].ToString() != "")
{
model.F_LimitTime = DateTime.Parse(drs[0]["F_LimitTime"].ToString());
}
if (drs[0]["F_Type"].ToString() != "")
{
model.F_Type = int.Parse(drs[0]["F_Type"].ToString());
}
if (drs[0]["F_State"].ToString() != "")
{
model.F_State = int.Parse(drs[0]["F_State"].ToString());
}
if (drs[0]["F_GameName"].ToString() != "")
{
model.F_GameName = int.Parse(drs[0]["F_GameName"].ToString());
}
if (drs[0]["F_GameBigZone"] != null)
{
model.F_GameBigZone = drs[0]["F_GameBigZone"].ToString();
}
if (drs[0]["F_GameZone"] != null)
{
model.F_GameZone = drs[0]["F_GameZone"].ToString();
}
if (drs[0]["F_GUserID"] != null)
{
model.F_GUserID = drs[0]["F_GUserID"].ToString();
}
if (drs[0]["F_GUserName"] != null)
{
model.F_GUserName = drs[0]["F_GUserName"].ToString();
}
if (drs[0]["F_GRoleID"] != null)
{
model.F_GRoleID = drs[0]["F_GRoleID"].ToString();
}
if (drs[0]["F_GRoleName"] != null)
{
model.F_GRoleName = drs[0]["F_GRoleName"].ToString();
}
if (drs[0]["F_Telphone"] != null)
{
model.F_Telphone = drs[0]["F_Telphone"].ToString();
}
if (drs[0]["F_GPeopleName"] != null)
{
model.F_GPeopleName = drs[0]["F_GPeopleName"].ToString();
}
if (drs[0]["F_DutyMan"].ToString() != "")
{
model.F_DutyMan = int.Parse(drs[0]["F_DutyMan"].ToString());
}
if (drs[0]["F_PreDutyMan"].ToString() != "")
{
model.F_PreDutyMan = int.Parse(drs[0]["F_PreDutyMan"].ToString());
}
if (drs[0]["F_CreatMan"].ToString() != "")
{
model.F_CreatMan = int.Parse(drs[0]["F_CreatMan"].ToString());
}
if (drs[0]["F_CreatTime"].ToString() != "")
{
model.F_CreatTime = DateTime.Parse(drs[0]["F_CreatTime"].ToString());
}
if (drs[0]["F_EditMan"].ToString() != "")
{
model.F_EditMan = int.Parse(drs[0]["F_EditMan"].ToString());
}
if (drs[0]["F_EditTime"].ToString() != "")
{
model.F_EditTime = DateTime.Parse(drs[0]["F_EditTime"].ToString());
}
if (drs[0]["F_URInfo"] != null)
{
model.F_URInfo = drs[0]["F_URInfo"].ToString();
}
if (drs[0]["F_Rowtype"].ToString() != "")
{
model.F_Rowtype = int.Parse(drs[0]["F_Rowtype"].ToString());
}
if (drs[0]["F_CUserName"].ToString() != "")
{
if ((drs[0]["F_CUserName"].ToString() == "1") || (drs[0]["F_CUserName"].ToString().ToLower() == "true"))
{
model.F_CUserName = true;
}
else
{
model.F_CUserName = false;
}
}
if (drs[0]["F_CPSWProtect"].ToString() != "")
{
if ((drs[0]["F_CPSWProtect"].ToString() == "1") || (drs[0]["F_CPSWProtect"].ToString().ToLower() == "true"))
{
model.F_CPSWProtect = true;
}
else
{
model.F_CPSWProtect = false;
}
}
if (drs[0]["F_CPersonID"].ToString() != "")
{
if ((drs[0]["F_CPersonID"].ToString() == "1") || (drs[0]["F_CPersonID"].ToString().ToLower() == "true"))
{
model.F_CPersonID = true;
}
else
{
model.F_CPersonID = false;
}
}
if (drs[0]["F_COther"] != null)
{
model.F_COther = drs[0]["F_COther"].ToString();
}
if (drs[0]["F_OLastLoginTime"] != null)
{
model.F_OLastLoginTime = drs[0]["F_OLastLoginTime"].ToString();
}
if (drs[0]["F_OCanRestor"].ToString() != "")
{
if ((drs[0]["F_OCanRestor"].ToString() == "1") || (drs[0]["F_OCanRestor"].ToString().ToLower() == "true"))
{
model.F_OCanRestor = true;
}
else
{
model.F_OCanRestor = false;
}
}
if (drs[0]["F_OAlwaysPlace"] != null)
{
model.F_OAlwaysPlace = drs[0]["F_OAlwaysPlace"].ToString();
}
if (drs[0]["F_TToolUsed"].ToString() != "")
{
if ((drs[0]["F_TToolUsed"].ToString() == "1") || (drs[0]["F_TToolUsed"].ToString().ToLower() == "true"))
{
model.F_TToolUsed = true;
}
else
{
model.F_TToolUsed = false;
}
}
if (drs[0]["F_TUseData"] != null)
{
model.F_TUseData = drs[0]["F_TUseData"].ToString();
}
return(model);
}
else
{
return(null);
}
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public GSSModel.Tasks GetModel(int F_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 F_ID,F_Title,F_Note,F_From,F_VipLevel,F_LimitType,F_LimitTime,F_Type,F_State,F_GameName,F_GameBigZone,F_GameZone,F_GUserID,F_GUserName,F_GRoleID,F_GRoleName,F_Telphone,F_GPeopleName,F_DutyMan,F_PreDutyMan,F_CreatMan,F_CreatTime,F_EditMan,F_EditTime,F_URInfo,F_Rowtype,F_CUserName,F_CPSWProtect,F_CPersonID,F_COther,F_OLastLoginTime,F_OCanRestor,F_OAlwaysPlace,F_TToolUsed,F_TUseData from T_Tasks ");
strSql.Append(" where F_ID=@F_ID");
SqlParameter[] parameters =
{
new SqlParameter("@F_ID", SqlDbType.Int, 4)
};
parameters[0].Value = F_ID;
GSSModel.Tasks model = new GSSModel.Tasks();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["F_ID"].ToString() != "")
{
model.F_ID = int.Parse(ds.Tables[0].Rows[0]["F_ID"].ToString());
}
if (ds.Tables[0].Rows[0]["F_Title"] != null)
{
model.F_Title = ds.Tables[0].Rows[0]["F_Title"].ToString();
}
if (ds.Tables[0].Rows[0]["F_Note"] != null)
{
model.F_Note = ds.Tables[0].Rows[0]["F_Note"].ToString();
}
if (ds.Tables[0].Rows[0]["F_From"].ToString() != "")
{
model.F_From = int.Parse(ds.Tables[0].Rows[0]["F_From"].ToString());
}
if (ds.Tables[0].Rows[0]["F_VipLevel"].ToString() != "")
{
model.F_VipLevel = int.Parse(ds.Tables[0].Rows[0]["F_VipLevel"].ToString());
}
if (ds.Tables[0].Rows[0]["F_LimitType"].ToString() != "")
{
model.F_LimitType = int.Parse(ds.Tables[0].Rows[0]["F_LimitType"].ToString());
}
if (ds.Tables[0].Rows[0]["F_LimitTime"].ToString() != "")
{
model.F_LimitTime = DateTime.Parse(ds.Tables[0].Rows[0]["F_LimitTime"].ToString());
}
if (ds.Tables[0].Rows[0]["F_Type"].ToString() != "")
{
model.F_Type = int.Parse(ds.Tables[0].Rows[0]["F_Type"].ToString());
}
if (ds.Tables[0].Rows[0]["F_State"].ToString() != "")
{
model.F_State = int.Parse(ds.Tables[0].Rows[0]["F_State"].ToString());
}
if (ds.Tables[0].Rows[0]["F_GameName"].ToString() != "")
{
model.F_GameName = int.Parse(ds.Tables[0].Rows[0]["F_GameName"].ToString());
}
if (ds.Tables[0].Rows[0]["F_GameBigZone"] != null)
{
model.F_GameBigZone = ds.Tables[0].Rows[0]["F_GameBigZone"].ToString();
}
if (ds.Tables[0].Rows[0]["F_GameZone"] != null)
{
model.F_GameZone = ds.Tables[0].Rows[0]["F_GameZone"].ToString();
}
if (ds.Tables[0].Rows[0]["F_GUserID"] != null)
{
model.F_GUserID = ds.Tables[0].Rows[0]["F_GUserID"].ToString();
}
if (ds.Tables[0].Rows[0]["F_GUserName"] != null)
{
model.F_GUserName = ds.Tables[0].Rows[0]["F_GUserName"].ToString();
}
if (ds.Tables[0].Rows[0]["F_GRoleID"] != null)
{
model.F_GRoleID = ds.Tables[0].Rows[0]["F_GRoleID"].ToString();
}
if (ds.Tables[0].Rows[0]["F_GRoleName"] != null)
{
model.F_GRoleName = ds.Tables[0].Rows[0]["F_GRoleName"].ToString();
}
if (ds.Tables[0].Rows[0]["F_Telphone"] != null)
{
model.F_Telphone = ds.Tables[0].Rows[0]["F_Telphone"].ToString();
}
if (ds.Tables[0].Rows[0]["F_GPeopleName"] != null)
{
model.F_GPeopleName = ds.Tables[0].Rows[0]["F_GPeopleName"].ToString();
}
if (ds.Tables[0].Rows[0]["F_DutyMan"].ToString() != "")
{
model.F_DutyMan = int.Parse(ds.Tables[0].Rows[0]["F_DutyMan"].ToString());
}
if (ds.Tables[0].Rows[0]["F_PreDutyMan"].ToString() != "")
{
model.F_PreDutyMan = int.Parse(ds.Tables[0].Rows[0]["F_PreDutyMan"].ToString());
}
if (ds.Tables[0].Rows[0]["F_CreatMan"].ToString() != "")
{
model.F_CreatMan = int.Parse(ds.Tables[0].Rows[0]["F_CreatMan"].ToString());
}
if (ds.Tables[0].Rows[0]["F_CreatTime"].ToString() != "")
{
model.F_CreatTime = DateTime.Parse(ds.Tables[0].Rows[0]["F_CreatTime"].ToString());
}
if (ds.Tables[0].Rows[0]["F_EditMan"].ToString() != "")
{
model.F_EditMan = int.Parse(ds.Tables[0].Rows[0]["F_EditMan"].ToString());
}
if (ds.Tables[0].Rows[0]["F_EditTime"].ToString() != "")
{
model.F_EditTime = DateTime.Parse(ds.Tables[0].Rows[0]["F_EditTime"].ToString());
}
if (ds.Tables[0].Rows[0]["F_URInfo"] != null)
{
model.F_URInfo = ds.Tables[0].Rows[0]["F_URInfo"].ToString();
}
if (ds.Tables[0].Rows[0]["F_Rowtype"].ToString() != "")
{
model.F_Rowtype = int.Parse(ds.Tables[0].Rows[0]["F_Rowtype"].ToString());
}
if (ds.Tables[0].Rows[0]["F_CUserName"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["F_CUserName"].ToString() == "1") || (ds.Tables[0].Rows[0]["F_CUserName"].ToString().ToLower() == "true"))
{
model.F_CUserName = true;
}
else
{
model.F_CUserName = false;
}
}
if (ds.Tables[0].Rows[0]["F_CPSWProtect"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["F_CPSWProtect"].ToString() == "1") || (ds.Tables[0].Rows[0]["F_CPSWProtect"].ToString().ToLower() == "true"))
{
model.F_CPSWProtect = true;
}
else
{
model.F_CPSWProtect = false;
}
}
if (ds.Tables[0].Rows[0]["F_CPersonID"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["F_CPersonID"].ToString() == "1") || (ds.Tables[0].Rows[0]["F_CPersonID"].ToString().ToLower() == "true"))
{
model.F_CPersonID = true;
}
else
{
model.F_CPersonID = false;
}
}
if (ds.Tables[0].Rows[0]["F_COther"] != null)
{
model.F_COther = ds.Tables[0].Rows[0]["F_COther"].ToString();
}
if (ds.Tables[0].Rows[0]["F_OLastLoginTime"] != null)
{
model.F_OLastLoginTime = ds.Tables[0].Rows[0]["F_OLastLoginTime"].ToString();
}
if (ds.Tables[0].Rows[0]["F_OCanRestor"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["F_OCanRestor"].ToString() == "1") || (ds.Tables[0].Rows[0]["F_OCanRestor"].ToString().ToLower() == "true"))
{
model.F_OCanRestor = true;
}
else
{
model.F_OCanRestor = false;
}
}
if (ds.Tables[0].Rows[0]["F_OAlwaysPlace"] != null)
{
model.F_OAlwaysPlace = ds.Tables[0].Rows[0]["F_OAlwaysPlace"].ToString();
}
if (ds.Tables[0].Rows[0]["F_TToolUsed"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["F_TToolUsed"].ToString() == "1") || (ds.Tables[0].Rows[0]["F_TToolUsed"].ToString().ToLower() == "true"))
{
model.F_TToolUsed = true;
}
else
{
model.F_TToolUsed = false;
}
}
if (ds.Tables[0].Rows[0]["F_TUseData"] != null)
{
model.F_TUseData = ds.Tables[0].Rows[0]["F_TUseData"].ToString();
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(GSSModel.Tasks model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update T_Tasks set ");
strSql.Append("F_Title=@F_Title,");
strSql.Append("F_Note=@F_Note,");
strSql.Append("F_From=@F_From,");
strSql.Append("F_VipLevel=@F_VipLevel,");
strSql.Append("F_LimitType=@F_LimitType,");
strSql.Append("F_LimitTime=@F_LimitTime,");
strSql.Append("F_Type=@F_Type,");
strSql.Append("F_State=@F_State,");
strSql.Append("F_GameName=@F_GameName,");
strSql.Append("F_GameBigZone=@F_GameBigZone,");
strSql.Append("F_GameZone=@F_GameZone,");
strSql.Append("F_GUserID=@F_GUserID,");
strSql.Append("F_GUserName=@F_GUserName,");
strSql.Append("F_GRoleID=@F_GRoleID,");
strSql.Append("F_GRoleName=@F_GRoleName,");
strSql.Append("F_Telphone=@F_Telphone,");
strSql.Append("F_GPeopleName=@F_GPeopleName,");
strSql.Append("F_DutyMan=@F_DutyMan,");
strSql.Append("F_PreDutyMan=@F_PreDutyMan,");
strSql.Append("F_CreatMan=@F_CreatMan,");
strSql.Append("F_CreatTime=@F_CreatTime,");
strSql.Append("F_EditMan=@F_EditMan,");
strSql.Append("F_EditTime=@F_EditTime,");
strSql.Append("F_URInfo=@F_URInfo,");
strSql.Append("F_Rowtype=@F_Rowtype,");
strSql.Append("F_CUserName=@F_CUserName,");
strSql.Append("F_CPSWProtect=@F_CPSWProtect,");
strSql.Append("F_CPersonID=@F_CPersonID,");
strSql.Append("F_COther=@F_COther,");
strSql.Append("F_OLastLoginTime=@F_OLastLoginTime,");
strSql.Append("F_OCanRestor=@F_OCanRestor,");
strSql.Append("F_OAlwaysPlace=@F_OAlwaysPlace,");
strSql.Append("F_TToolUsed=@F_TToolUsed,");
strSql.Append("F_TUseData=@F_TUseData");
strSql.Append(" where F_ID=@F_ID");
SqlParameter[] parameters =
{
new SqlParameter("@F_Title", SqlDbType.NVarChar, 30),
new SqlParameter("@F_Note", SqlDbType.NVarChar, 500),
new SqlParameter("@F_From", SqlDbType.Int, 4),
new SqlParameter("@F_VipLevel", SqlDbType.Int, 4),
new SqlParameter("@F_LimitType", SqlDbType.Int, 4),
new SqlParameter("@F_LimitTime", SqlDbType.SmallDateTime),
new SqlParameter("@F_Type", SqlDbType.Int, 4),
new SqlParameter("@F_State", SqlDbType.Int, 4),
new SqlParameter("@F_GameName", SqlDbType.Int, 4),
new SqlParameter("@F_GameBigZone", SqlDbType.NVarChar, 16),
new SqlParameter("@F_GameZone", SqlDbType.NVarChar, 16),
new SqlParameter("@F_GUserID", SqlDbType.NVarChar, 16),
new SqlParameter("@F_GUserName", SqlDbType.NVarChar, 16),
new SqlParameter("@F_GRoleID", SqlDbType.NVarChar, 16),
new SqlParameter("@F_GRoleName", SqlDbType.NVarChar, 16),
new SqlParameter("@F_Telphone", SqlDbType.NVarChar, 16),
new SqlParameter("@F_GPeopleName", SqlDbType.NVarChar, 16),
new SqlParameter("@F_DutyMan", SqlDbType.Int, 4),
new SqlParameter("@F_PreDutyMan", SqlDbType.Int, 4),
new SqlParameter("@F_CreatMan", SqlDbType.Int, 4),
new SqlParameter("@F_CreatTime", SqlDbType.SmallDateTime),
new SqlParameter("@F_EditMan", SqlDbType.Int, 4),
new SqlParameter("@F_EditTime", SqlDbType.SmallDateTime),
new SqlParameter("@F_URInfo", SqlDbType.NVarChar, 300),
new SqlParameter("@F_Rowtype", SqlDbType.TinyInt, 1),
new SqlParameter("@F_CUserName", SqlDbType.Bit, 1),
new SqlParameter("@F_CPSWProtect", SqlDbType.Bit, 1),
new SqlParameter("@F_CPersonID", SqlDbType.Bit, 1),
new SqlParameter("@F_COther", SqlDbType.NVarChar, 100),
new SqlParameter("@F_OLastLoginTime", SqlDbType.NVarChar, 50),
new SqlParameter("@F_OCanRestor", SqlDbType.Bit, 1),
new SqlParameter("@F_OAlwaysPlace", SqlDbType.NVarChar, 50),
new SqlParameter("@F_TToolUsed", SqlDbType.Bit, 1),
new SqlParameter("@F_TUseData", SqlDbType.NVarChar, 200),
new SqlParameter("@F_ID", SqlDbType.Int, 4)
};
parameters[0].Value = model.F_Title;
parameters[1].Value = model.F_Note;
parameters[2].Value = model.F_From;
parameters[3].Value = model.F_VipLevel;
parameters[4].Value = model.F_LimitType;
parameters[5].Value = model.F_LimitTime;
parameters[6].Value = model.F_Type;
parameters[7].Value = model.F_State;
parameters[8].Value = model.F_GameName;
parameters[9].Value = model.F_GameBigZone;
parameters[10].Value = model.F_GameZone;
parameters[11].Value = model.F_GUserID;
parameters[12].Value = model.F_GUserName;
parameters[13].Value = model.F_GRoleID;
parameters[14].Value = model.F_GRoleName;
parameters[15].Value = model.F_Telphone;
parameters[16].Value = model.F_GPeopleName;
parameters[17].Value = model.F_DutyMan;
parameters[18].Value = model.F_PreDutyMan;
parameters[19].Value = model.F_CreatMan;
parameters[20].Value = model.F_CreatTime;
parameters[21].Value = model.F_EditMan;
parameters[22].Value = model.F_EditTime;
parameters[23].Value = model.F_URInfo;
parameters[24].Value = model.F_Rowtype;
parameters[25].Value = model.F_CUserName;
parameters[26].Value = model.F_CPSWProtect;
parameters[27].Value = model.F_CPersonID;
parameters[28].Value = model.F_COther;
parameters[29].Value = model.F_OLastLoginTime;
parameters[30].Value = model.F_OCanRestor;
parameters[31].Value = model.F_OAlwaysPlace;
parameters[32].Value = model.F_TToolUsed;
parameters[33].Value = model.F_TUseData;
parameters[34].Value = model.F_ID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 工单修改提交
/// </summary>
private void button1_Click(object sender, EventArgs e)
{
//数据检验
string strErr = "";
if (lblNoteMust.Visible && this.rtxtF_Note.Text.Trim().Length == 0)
{
foreach (Control control in flowLayoutPanelF_State.Controls)
{
if (control.GetType().ToString() == "System.Windows.Forms.RadioButton" && (control as System.Windows.Forms.RadioButton).Checked)
{
if ((control as System.Windows.Forms.RadioButton).Checked)
{
strErr += LanguageResource.Language.Tip_InputInWorkword + (control as System.Windows.Forms.RadioButton).Text + LanguageResource.Language.Tip_ReasonOrText + "!\n";
break;
}
}
}
}
if (rbtnState2.Checked && cboxF_DutyMan.SelectedIndex == 0)
{
strErr += LanguageResource.Language.Tip_SelectTurnToResponsible + "!\n";
}
if (strErr != "")
{
MsgBox.Show(strErr, LanguageResource.Language.Tip_Tip, MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
//数据准备
string F_Note = this.rtxtF_Note.Text.Trim();
int? F_State = GetNextState();
// string F_Telphone = this.tboxTelephone.Text.Trim() == TrimNull(model.F_Telphone).Trim() ? null : this.tboxTelephone.Text.Trim();
int?dutyman = model.F_DutyMan;
int?predutyman = model.F_PreDutyMan;
if (cboxF_DutyMan.Visible && cboxF_DutyMan.Text != dutyman.ToString())
{
predutyman = dutyman;
dutyman = int.Parse(cboxF_DutyMan.SelectedValue.ToString());
}
else if (rbtnState0.Visible && rbtnState0.Checked)
{
dutyman = int.Parse(ShareData.UserID);
}
else
{
predutyman = null;
dutyman = null;
}
//数据保存
GSSModel.Tasks modelN = new GSSModel.Tasks();
modelN.F_ID = _taskid;
modelN.F_Note = F_Note;
modelN.F_State = F_State;
// modelN.F_Telphone = F_Telphone;
modelN.F_DutyMan = dutyman;
modelN.F_PreDutyMan = predutyman;
modelN.F_EditMan = int.Parse(ShareData.UserID);
modelN.F_EditTime = DateTime.Now;
// _clihandle.EditTask(modelN);
ComitDoControl(false);
string backStr = _clihandle.EditTaskSyn(modelN);
if (backStr == "0")
{
MsgBox.Show(LanguageResource.Language.BtnWorkorderDealwithNo, LanguageResource.Language.Tip_Tip, MessageBoxButtons.OK, MessageBoxIcon.Error);
this.DialogResult = DialogResult.Cancel;
}
else
{
MsgBox.Show(LanguageResource.Language.BtnWorkorderDealwithOK, LanguageResource.Language.Tip_Tip, MessageBoxButtons.OK, MessageBoxIcon.Information);
_IsChange = true;
SetGameUR();
}
ComitDoControl(true);
}
/// <summary>
/// 界面初始化
/// </summary>
private void SetGameUR()
{
string userinfo = "";
BindDept(cboxF_DutyManDept, "0");
BindUser(cboxF_DutyMan, "-1");
if (_IsChange)
{
_IsChangeA = true;
_clihandle.GetAllTasksSyn(" and F_ID=" + _taskid + "");
_IsChange = false;
}
model = ClientCache.GetTaskModel(_taskid);
if (model != null)
{
userinfo += LanguageResource.Language.LblWorkOrderNo + ":" + model.F_ID + " ";
userinfo += LanguageResource.Language.LblWorkOrderType + ":" + ClientCache.GetDicPCName(model.F_Type.ToString()) + "\n";
// userinfo += "工单标题:" + model.F_Title+ "\n";
userinfo += LanguageResource.Language.LblWorkOrderSatue + ":" + ClientCache.GetDicName(model.F_State.ToString()) + " ";
userinfo += LanguageResource.Language.LblWorkOrderSource + ":" + ClientCache.GetDicName(model.F_From.ToString()) + " \n";
userinfo += LanguageResource.Language.LblPreviousPersonInCharge + ":" + ClientCache.GetUserNameT(model.F_PreDutyMan.ToString()) + "\n";
userinfo += LanguageResource.Language.LblCurrentPersonInCharge + ":" + ClientCache.GetUserNameT(model.F_DutyMan.ToString()) + "\n";
lblLimitDate.Text = TrimNull(model.F_LimitTime);
lblVip.Text = ClientCache.GetDicName(model.F_VipLevel.ToString());
labelTitle.Text = model.F_Title;
labelCreator.Text = model.F_GPeopleName;
labelTelephone.Text = model.F_Telphone;
cboxNowState.Text = ClientCache.GetDicName(TrimNull(model.F_State.ToString()));
ComitDoControlGN(Convert.ToBoolean(model.F_OCanRestor));
#region 状态显示
rbtnState0.Visible = false;
rbtnState1.Visible = false;
rbtnState2.Visible = false;
rbtnState3.Visible = false;
rbtnState4.Visible = false;
rbtnState5.Visible = false;
rbtnState6.Visible = false;
rbtnState7.Visible = false;
rbtnState8.Visible = false;
string taskstate = cboxNowState.Text;
//权限检测
if (model.F_DutyMan.ToString() != ShareData.UserID && taskstate != "等待处理")
{
taskstate = "工单关闭";
lblPowerNull.Visible = true;
}
else
{
lblPowerNull.Visible = false;
}
switch (taskstate)
{
case "等待处理":
rbtnState0.Visible = true;
rbtnState6.Visible = true;
rbtnState7.Visible = true;
rbtnState0.Checked = true;
break;
case "已经接收":
rbtnState1.Visible = true;
rbtnState2.Visible = true;
rbtnState6.Visible = true;
rbtnState7.Visible = true;
rbtnState1.Checked = true;
break;
case "处理中":
rbtnState2.Visible = true;
rbtnState3.Visible = true;
rbtnState4.Visible = true;
rbtnState6.Visible = true;
rbtnState7.Visible = true;
rbtnState8.Visible = true;
rbtnState3.Checked = true;
break;
case "已经转向":
rbtnState7.Visible = true;
rbtnState7.Checked = true;
rbtnState7.Text = "仅备注(要求或信息)";
break;
case "等待反馈":
rbtnState4.Visible = true;
rbtnState6.Visible = true;
rbtnState7.Visible = true;
rbtnState4.Checked = true;
rbtnState4.Text = "已反馈并需评分";
break;
case "等待评分":
rbtnState5.Visible = true;
rbtnState6.Visible = true;
rbtnState7.Visible = true;
rbtnState5.Checked = true;
rbtnState5.Text = "评分并完成工单";
break;
case "需领导审核":
rbtnState2.Visible = true;
rbtnState5.Visible = true;
rbtnState6.Visible = true;
rbtnState7.Visible = true;
rbtnState2.Checked = true;
rbtnState2.Text = "审核通过并转向";
SetNextUser(model.F_PreDutyMan);
cboxF_DutyManDept.Enabled = false;
cboxF_DutyMan.Enabled = false;
ckboxEditNUser.Visible = true;
break;
case "工单完成":
rbtnState7.Visible = true;
rbtnState7.Checked = true;
break;
case "工单关闭":
rbtnState7.Visible = true;
rbtnState7.Checked = true;
break;
default:
break;
}
}
#endregion
flowLayoutPanelF_State.Location = new Point(9, 55);
lblTaskinfo.Text = userinfo;
//权限
//foreach (System.Windows.Forms.Control control in this.groupBoxTool0.Controls)
//{
// if (control.GetType().ToString() == "System.Windows.Forms.Button" || control.GetType().ToString() == "GSSUI.AControl.AButton.AButton")
// {
// System.Windows.Forms.Button toolbtnActiv = (control as System.Windows.Forms.Button);
// toolbtnActiv.Enabled = false;
// if (ShareData.UserPower.IndexOf("," + toolbtnActiv.Name + ",") >= 0)
// {
// toolbtnActiv.Enabled = true;
// }
// }
//}
labelGAInfo.Text = LanguageResource.Language.LblGameBigZone + ":" + model.F_GameBigZone;
if (model.F_COther.Length > 0)
{
string[] giftstr = model.F_COther.Split('|');
labelGAInfo.Text += " \n" + LanguageResource.Language.LblAwardNo + ":" + giftstr[0] + " 奖品名称:" + giftstr[1] + "\n奖品类型:" + giftstr[2] + " 奖品数量:" + giftstr[3];
}
DataSet ds = GSSCSFrameWork.DataSerialize.GetDatasetFromByte((byte[])GSSCSFrameWork.DataSerialize.GetObjectFromString(model.F_URInfo));
if (ds != null)
{
DGVGameUser.AutoGenerateColumns = false;
DGVGameUser.DataSource = ds.Tables[0];
//string URInfo = "";
//foreach (DataRow dru in ds.Tables[0].Rows)
//{
// URInfo += @"用户编号:" + dru[0] + @LanguageResource.Language.LblRoleNo + dru[1] + "\n";
//}
//aRichTextBoxCode.Text = URInfo;
}
DataSet dsTaskLog = _clihandle.GetTaskLogSyn(" and F_ID=" + _taskid + "");
if (dsTaskLog != null)
{
SetTaskLogValue(dsTaskLog.Tables[0]);
}
}
/// <summary>
/// 提交工单
/// </summary>
private void CommitTask()
{
string Title = "";
string Note = rboxNote.Text;
int From = SystemConfig.AppID;//客服中心
int VipLevel = int.Parse(cboxVIP.SelectedValue.ToString());
DateTime?LimitTime = GetLimitTime();
int LimitType = int.Parse(cboxLimitTime.SelectedValue.ToString());
int? Type = _tasktype; //角色异常
int State = SystemConfig.DefaultWorkOrderStatue; //等待处理
int GameName = SystemConfig.GameID; //寻龙记
string Telphone = tboxTelphone.Text;
int? DutyMan = null;
int? PreDutyMan = null;
int CreatMan = int.Parse(ShareData.UserID);
DateTime CreatTime = DateTime.Now;
int EditMan = int.Parse(ShareData.UserID);
DateTime EditTime = DateTime.Now;
string URInfo = lblURinfo.Text;
string gpeoplename = tboxGPeopleName.Text;
bool CPersonID = ckboxCPersonID.Checked;
string COther = tboxCOther.Text;
int Rowtype = 0;
string strErr = "";
if (ckboxCOther.Checked && COther.Length == 0)
{
strErr += "验证项> 其它: 内容不能为空！\n";
}
//if (Telphone.Trim().Length == 0)
//{
// strErr += "联系电话不能为空！\n";
//}
//else if (!WinUtil.IsTelphone(Telphone) && !WinUtil.IsMobile(Telphone))
//{
// strErr += LanguageResource.Language.LblTelFormIsError+"！\n(格式:010-88886666或13912341234)\n";
//}
//if (Note.Trim().Length < 5)
//{
// strErr += "备注内容不应少于五个字！\n";
//}
if (strErr != "")
{
MsgBox.Show(strErr, LanguageResource.Language.Tip_Tip, MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
ComitDoControl(false);
GSSModel.Tasks model = new GSSModel.Tasks();
model.F_Title = Title;
model.F_Note = Note;
model.F_From = From;
model.F_VipLevel = VipLevel;
model.F_LimitType = LimitType;
model.F_LimitTime = LimitTime;
model.F_Type = Type;
model.F_State = State;
model.F_GameName = GameName;
model.F_Telphone = Telphone;
model.F_GPeopleName = gpeoplename;
model.F_DutyMan = DutyMan;
model.F_PreDutyMan = PreDutyMan;
model.F_CreatMan = CreatMan;
model.F_CreatTime = CreatTime;
model.F_EditMan = EditMan;
model.F_EditTime = EditTime;
model.F_URInfo = URInfo;
model.F_Rowtype = Rowtype;
model.F_CPersonID = CPersonID;
model.F_COther = COther;
_clienthandle.AddTask(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(GSSModel.Tasks model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据(存储过程)
/// </summary>
public int AddP(GSSModel.Tasks model)
{
return(dal.AddP(model));
}
/// <summary>
/// 获得数据列表
/// </summary>
public List <GSSModel.Tasks> DataTableToList(DataTable dt)
{
List <GSSModel.Tasks> modelList = new List <GSSModel.Tasks>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
GSSModel.Tasks model;
for (int n = 0; n < rowsCount; n++)
{
model = new GSSModel.Tasks();
if (dt.Rows[n]["F_ID"].ToString() != "")
{
model.F_ID = int.Parse(dt.Rows[n]["F_ID"].ToString());
}
model.F_Title = dt.Rows[n]["F_Title"].ToString();
model.F_Note = dt.Rows[n]["F_Note"].ToString();
if (dt.Rows[n]["F_From"].ToString() != "")
{
model.F_From = int.Parse(dt.Rows[n]["F_From"].ToString());
}
if (dt.Rows[n]["F_VipLevel"].ToString() != "")
{
model.F_VipLevel = int.Parse(dt.Rows[n]["F_VipLevel"].ToString());
}
if (dt.Rows[n]["F_LimitType"].ToString() != "")
{
model.F_LimitType = int.Parse(dt.Rows[n]["F_LimitType"].ToString());
}
if (dt.Rows[n]["F_LimitTime"].ToString() != "")
{
model.F_LimitTime = DateTime.Parse(dt.Rows[n]["F_LimitTime"].ToString());
}
if (dt.Rows[n]["F_Type"].ToString() != "")
{
model.F_Type = int.Parse(dt.Rows[n]["F_Type"].ToString());
}
if (dt.Rows[n]["F_State"].ToString() != "")
{
model.F_State = int.Parse(dt.Rows[n]["F_State"].ToString());
}
if (dt.Rows[n]["F_GameName"].ToString() != "")
{
model.F_GameName = int.Parse(dt.Rows[n]["F_GameName"].ToString());
}
model.F_GameBigZone = dt.Rows[n]["F_GameBigZone"].ToString();
model.F_GameZone = dt.Rows[n]["F_GameZone"].ToString();
model.F_GUserID = dt.Rows[n]["F_GUserID"].ToString();
model.F_GUserName = dt.Rows[n]["F_GUserName"].ToString();
model.F_GRoleID = dt.Rows[n]["F_GRoleID"].ToString();
model.F_GRoleName = dt.Rows[n]["F_GRoleName"].ToString();
model.F_Telphone = dt.Rows[n]["F_Telphone"].ToString();
model.F_GPeopleName = dt.Rows[n]["F_GPeopleName"].ToString();
if (dt.Rows[n]["F_DutyMan"].ToString() != "")
{
model.F_DutyMan = int.Parse(dt.Rows[n]["F_DutyMan"].ToString());
}
if (dt.Rows[n]["F_PreDutyMan"].ToString() != "")
{
model.F_PreDutyMan = int.Parse(dt.Rows[n]["F_PreDutyMan"].ToString());
}
if (dt.Rows[n]["F_CreatMan"].ToString() != "")
{
model.F_CreatMan = int.Parse(dt.Rows[n]["F_CreatMan"].ToString());
}
if (dt.Rows[n]["F_CreatTime"].ToString() != "")
{
model.F_CreatTime = DateTime.Parse(dt.Rows[n]["F_CreatTime"].ToString());
}
if (dt.Rows[n]["F_EditMan"].ToString() != "")
{
model.F_EditMan = int.Parse(dt.Rows[n]["F_EditMan"].ToString());
}
if (dt.Rows[n]["F_EditTime"].ToString() != "")
{
model.F_EditTime = DateTime.Parse(dt.Rows[n]["F_EditTime"].ToString());
}
model.F_URInfo = dt.Rows[n]["F_URInfo"].ToString();
if (dt.Rows[n]["F_Rowtype"].ToString() != "")
{
model.F_Rowtype = int.Parse(dt.Rows[n]["F_Rowtype"].ToString());
}
if (dt.Rows[n]["F_CUserName"].ToString() != "")
{
if ((dt.Rows[n]["F_CUserName"].ToString() == "1") || (dt.Rows[n]["F_CUserName"].ToString().ToLower() == "true"))
{
model.F_CUserName = true;
}
else
{
model.F_CUserName = false;
}
}
if (dt.Rows[n]["F_CPSWProtect"].ToString() != "")
{
if ((dt.Rows[n]["F_CPSWProtect"].ToString() == "1") || (dt.Rows[n]["F_CPSWProtect"].ToString().ToLower() == "true"))
{
model.F_CPSWProtect = true;
}
else
{
model.F_CPSWProtect = false;
}
}
if (dt.Rows[n]["F_CPersonID"].ToString() != "")
{
if ((dt.Rows[n]["F_CPersonID"].ToString() == "1") || (dt.Rows[n]["F_CPersonID"].ToString().ToLower() == "true"))
{
model.F_CPersonID = true;
}
else
{
model.F_CPersonID = false;
}
}
model.F_COther = dt.Rows[n]["F_COther"].ToString();
model.F_OLastLoginTime = dt.Rows[n]["F_OLastLoginTime"].ToString();
if (dt.Rows[n]["F_OCanRestor"].ToString() != "")
{
if ((dt.Rows[n]["F_OCanRestor"].ToString() == "1") || (dt.Rows[n]["F_OCanRestor"].ToString().ToLower() == "true"))
{
model.F_OCanRestor = true;
}
else
{
model.F_OCanRestor = false;
}
}
model.F_OAlwaysPlace = dt.Rows[n]["F_OAlwaysPlace"].ToString();
if (dt.Rows[n]["F_TToolUsed"].ToString() != "")
{
if ((dt.Rows[n]["F_TToolUsed"].ToString() == "1") || (dt.Rows[n]["F_TToolUsed"].ToString().ToLower() == "true"))
{
model.F_TToolUsed = true;
}
else
{
model.F_TToolUsed = false;
}
}
model.F_TUseData = dt.Rows[n]["F_TUseData"].ToString();
modelList.Add(model);
}
}
return(modelList);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(GSSModel.Tasks model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_Tasks(");
strSql.Append("F_Title,F_Note,F_From,F_VipLevel,F_LimitType,F_LimitTime,F_Type,F_State,F_GameName,F_GameBigZone,F_GameZone,F_GUserID,F_GUserName,F_GRoleID,F_GRoleName,F_Telphone,F_GPeopleName,F_DutyMan,F_PreDutyMan,F_CreatMan,F_CreatTime,F_EditMan,F_EditTime,F_URInfo,F_Rowtype,F_CUserName,F_CPSWProtect,F_CPersonID,F_COther,F_OLastLoginTime,F_OCanRestor,F_OAlwaysPlace,F_TToolUsed,F_TUseData)");
strSql.Append(" values (");
strSql.Append("@F_Title,@F_Note,@F_From,@F_VipLevel,@F_LimitType,@F_LimitTime,@F_Type,@F_State,@F_GameName,@F_GameBigZone,@F_GameZone,@F_GUserID,@F_GUserName,@F_GRoleID,@F_GRoleName,@F_Telphone,@F_GPeopleName,@F_DutyMan,@F_PreDutyMan,@F_CreatMan,@F_CreatTime,@F_EditMan,@F_EditTime,@F_URInfo,@F_Rowtype,@F_CUserName,@F_CPSWProtect,@F_CPersonID,@F_COther,@F_OLastLoginTime,@F_OCanRestor,@F_OAlwaysPlace,@F_TToolUsed,@F_TUseData)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@F_Title", SqlDbType.NVarChar, 30),
new SqlParameter("@F_Note", SqlDbType.NVarChar, 500),
new SqlParameter("@F_From", SqlDbType.Int, 4),
new SqlParameter("@F_VipLevel", SqlDbType.Int, 4),
new SqlParameter("@F_LimitType", SqlDbType.Int, 4),
new SqlParameter("@F_LimitTime", SqlDbType.SmallDateTime),
new SqlParameter("@F_Type", SqlDbType.Int, 4),
new SqlParameter("@F_State", SqlDbType.Int, 4),
new SqlParameter("@F_GameName", SqlDbType.Int, 4),
new SqlParameter("@F_GameBigZone", SqlDbType.NVarChar, 16),
new SqlParameter("@F_GameZone", SqlDbType.NVarChar, 16),
new SqlParameter("@F_GUserID", SqlDbType.NVarChar, 16),
new SqlParameter("@F_GUserName", SqlDbType.NVarChar, 16),
new SqlParameter("@F_GRoleID", SqlDbType.NVarChar, 16),
new SqlParameter("@F_GRoleName", SqlDbType.NVarChar, 16),
new SqlParameter("@F_Telphone", SqlDbType.NVarChar, 16),
new SqlParameter("@F_GPeopleName", SqlDbType.NVarChar, 16),
new SqlParameter("@F_DutyMan", SqlDbType.Int, 4),
new SqlParameter("@F_PreDutyMan", SqlDbType.Int, 4),
new SqlParameter("@F_CreatMan", SqlDbType.Int, 4),
new SqlParameter("@F_CreatTime", SqlDbType.SmallDateTime),
new SqlParameter("@F_EditMan", SqlDbType.Int, 4),
new SqlParameter("@F_EditTime", SqlDbType.SmallDateTime),
new SqlParameter("@F_URInfo", SqlDbType.NVarChar, 300),
new SqlParameter("@F_Rowtype", SqlDbType.TinyInt, 1),
new SqlParameter("@F_CUserName", SqlDbType.Bit, 1),
new SqlParameter("@F_CPSWProtect", SqlDbType.Bit, 1),
new SqlParameter("@F_CPersonID", SqlDbType.Bit, 1),
new SqlParameter("@F_COther", SqlDbType.NVarChar, 100),
new SqlParameter("@F_OLastLoginTime", SqlDbType.NVarChar, 50),
new SqlParameter("@F_OCanRestor", SqlDbType.Bit, 1),
new SqlParameter("@F_OAlwaysPlace", SqlDbType.NVarChar, 50),
new SqlParameter("@F_TToolUsed", SqlDbType.Bit, 1),
new SqlParameter("@F_TUseData", SqlDbType.NVarChar, 200)
};
parameters[0].Value = model.F_Title;
parameters[1].Value = model.F_Note;
parameters[2].Value = model.F_From;
parameters[3].Value = model.F_VipLevel;
parameters[4].Value = model.F_LimitType;
parameters[5].Value = model.F_LimitTime;
parameters[6].Value = model.F_Type;
parameters[7].Value = model.F_State;
parameters[8].Value = model.F_GameName;
parameters[9].Value = model.F_GameBigZone;
parameters[10].Value = model.F_GameZone;
parameters[11].Value = model.F_GUserID;
parameters[12].Value = model.F_GUserName;
parameters[13].Value = model.F_GRoleID;
parameters[14].Value = model.F_GRoleName;
parameters[15].Value = model.F_Telphone;
parameters[16].Value = model.F_GPeopleName;
parameters[17].Value = model.F_DutyMan;
parameters[18].Value = model.F_PreDutyMan;
parameters[19].Value = model.F_CreatMan;
parameters[20].Value = model.F_CreatTime;
parameters[21].Value = model.F_EditMan;
parameters[22].Value = model.F_EditTime;
parameters[23].Value = model.F_URInfo;
parameters[24].Value = model.F_Rowtype;
parameters[25].Value = model.F_CUserName;
parameters[26].Value = model.F_CPSWProtect;
parameters[27].Value = model.F_CPersonID;
parameters[28].Value = model.F_COther;
parameters[29].Value = model.F_OLastLoginTime;
parameters[30].Value = model.F_OCanRestor;
parameters[31].Value = model.F_OAlwaysPlace;
parameters[32].Value = model.F_TToolUsed;
parameters[33].Value = model.F_TUseData;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 编辑工单历史
/// </summary>
/// <param name="value"></param>
/// <returns></returns>
public int EditTaskLog(GSSModel.Tasks model)
{
int rowsAffected = 0;
SqlParameter[] parameters =
{
new SqlParameter("@F_Title", SqlDbType.NVarChar, 30),
new SqlParameter("@F_Note", SqlDbType.VarChar),
new SqlParameter("@F_From", SqlDbType.Int, 4),
new SqlParameter("@F_VipLevel", SqlDbType.Int, 4),
new SqlParameter("@F_LimitType", SqlDbType.Int, 4),
new SqlParameter("@F_LimitTime", SqlDbType.DateTime),
new SqlParameter("@F_Type", SqlDbType.Int, 4),
new SqlParameter("@F_State", SqlDbType.Int, 4),
new SqlParameter("@F_GameName", SqlDbType.Int, 4),
new SqlParameter("@F_GameBigZone", SqlDbType.NVarChar, 16),
new SqlParameter("@F_GameZone", SqlDbType.NVarChar, 16),
new SqlParameter("@F_GUserID", SqlDbType.NVarChar, 16),
new SqlParameter("@F_GUserName", SqlDbType.NVarChar, 16),
new SqlParameter("@F_GRoleID", SqlDbType.NVarChar, 16),
new SqlParameter("@F_GRoleName", SqlDbType.NVarChar, 16),
new SqlParameter("@F_Telphone", SqlDbType.NVarChar, 16),
new SqlParameter("@F_GPeopleName", SqlDbType.NVarChar, 16),
new SqlParameter("@F_DutyMan", SqlDbType.Int, 4),
new SqlParameter("@F_PreDutyMan", SqlDbType.Int, 4),
new SqlParameter("@F_CreatMan", SqlDbType.Int, 4),
new SqlParameter("@F_CreatTime", SqlDbType.DateTime),
new SqlParameter("@F_EditMan", SqlDbType.Int, 4),
new SqlParameter("@F_EditTime", SqlDbType.DateTime),
new SqlParameter("@F_URInfo", SqlDbType.VarChar),
new SqlParameter("@F_Rowtype", SqlDbType.TinyInt, 1),
new SqlParameter("@F_CUserName", SqlDbType.Bit, 1),
new SqlParameter("@F_CPSWProtect", SqlDbType.Bit, 1),
new SqlParameter("@F_CPersonID", SqlDbType.Bit, 1),
new SqlParameter("@F_COther", SqlDbType.NVarChar, 500),
new SqlParameter("@F_OLastLoginTime", SqlDbType.NVarChar, 50),
new SqlParameter("@F_OCanRestor", SqlDbType.Bit, 1),
new SqlParameter("@F_OAlwaysPlace", SqlDbType.NVarChar, 50),
new SqlParameter("@F_TToolUsed", SqlDbType.Bit, 1),
new SqlParameter("@F_TUseData", SqlDbType.VarChar),
new SqlParameter("@F_ID", SqlDbType.Int, 4)
};
parameters[0].Value = model.F_Title;
parameters[1].Value = model.F_Note;
parameters[2].Value = model.F_From;
parameters[3].Value = model.F_VipLevel;
parameters[4].Value = model.F_LimitType;
parameters[5].Value = model.F_LimitTime;
parameters[6].Value = model.F_Type;
parameters[7].Value = model.F_State;
parameters[8].Value = model.F_GameName;
parameters[9].Value = model.F_GameBigZone;
parameters[10].Value = model.F_GameZone;
parameters[11].Value = model.F_GUserID;
parameters[12].Value = model.F_GUserName;
parameters[13].Value = model.F_GRoleID;
parameters[14].Value = model.F_GRoleName;
parameters[15].Value = model.F_Telphone;
parameters[16].Value = model.F_GPeopleName;
parameters[17].Value = model.F_DutyMan;
parameters[18].Value = model.F_PreDutyMan;
parameters[19].Value = model.F_CreatMan;
parameters[20].Value = model.F_CreatTime;
parameters[21].Value = model.F_EditMan;
parameters[22].Value = model.F_EditTime;
parameters[23].Value = model.F_URInfo;
parameters[24].Value = model.F_Rowtype;
parameters[25].Value = model.F_CUserName;
parameters[26].Value = model.F_CPSWProtect;
parameters[27].Value = model.F_CPersonID;
parameters[28].Value = model.F_COther;
parameters[29].Value = model.F_OLastLoginTime;
parameters[30].Value = model.F_OCanRestor;
parameters[31].Value = model.F_OAlwaysPlace;
parameters[32].Value = model.F_TToolUsed;
parameters[33].Value = model.F_TUseData;
parameters[34].Value = model.F_ID;
try
{
DbHelperSQL.RunProcedure("GSS_TasksLog_Update", parameters, out rowsAffected);
return(rowsAffected);
}
catch (System.Exception ex)
{
return(0);
}
}
/// <summary>
/// 角色恢复
/// </summary>
public int GSSTool_RoleRecover(GSSModel.Tasks model)
{
return(dal.GSSTool_RoleRecover(model));
}
