public static DataRow PushChatMessage(ICD.ChatRoomInfo info)
{
if (info.body.mesgs.Length != 1)
{
LOG.warn();
return(null);
}
string sql = string.Format(
"INSERT INTO chatHistory " +
"(chatID, time, user, type, info) " +
"VALUES ('{0}', '{1}', '{2}', '{3}', '{4}')",
info.body.recordID,
info.msgTime,
info.msgUser,
"msg",
info.body.mesgs[0].message);
MySqlCommand cmd = new MySqlCommand(sql, mConn);
cmd.ExecuteNonQuery();
sql = string.Format("SELECT * FROM chatHistory WHERE time='{0}' AND user='******'", info.msgTime, info.msgUser);
MySqlDataAdapter adapter = new MySqlDataAdapter(sql, mConn);
DataSet ds = new DataSet();
adapter.Fill(ds, "Chat");
return(ds.Tables["Chat"].Rows[0]);
}
private void OnRecv_DelChatUser(ICD.HEADER obj)
{
ICD.ChatRoomInfo msg = (ICD.ChatRoomInfo)obj;
if (mChats.ContainsKey(msg.body.recordID))
{
mChats.Remove(msg.body.recordID);
UpdateChatList();
}
}
private void btnNewTask_Click(object sender, EventArgs e)
{
if (cbType.Text == "채팅")
{
ICD.ChatRoomInfo msgNewChat = new ICD.ChatRoomInfo();
msgNewChat.FillClientHeader(ICD.DEF.CMD_NewChat, 0);
msgNewChat.body.access = cbAccess.Text;
if (btnDirector.Text == btnWorker.Text)
{
msgNewChat.body.users = new string[1];
msgNewChat.body.users[0] = btnDirector.Text;
}
else
{
msgNewChat.body.users = new string[2];
msgNewChat.body.users[0] = btnDirector.Text;
msgNewChat.body.users[1] = btnWorker.Text;
}
ICDPacketMgr.GetInst().sendMsgToServer(msgNewChat);
}
else
{
ICD.WorkList msg = new ICD.WorkList();
msg.FillClientHeader(ICD.DEF.CMD_TaskNew, 0);
ICD.Work msgTask = msg.works[0];
//comboBox listing
msgTask.type = cbType.Text;
msgTask.access = cbAccess.Text;
msgTask.mainCate = cbMainCate.Text;
msgTask.subCate = cbSubCate.Text;
//formatting date
msgTask.launch = dtLaunch.Value.ToString("yyyy-MM-dd HH:mm:ss");
msgTask.due = dtDue.Value.ToString("yyyy-MM-dd HH:mm:ss");
msgTask.term = dtTerm.Value.ToString("yyyy-MM-dd HH:mm:ss");
msgTask.priority = cbPriority.Text;
//user listing
msgTask.creator = MyInfo.mMyInfo.userID;
msgTask.director = btnDirector.Text;
msgTask.worker = btnWorker.Text;
msgTask.title = tbTitle.Text;
msgTask.comment = tbComment.Text;
msgTask.state = "예정";
msgTask.timeFirst = msg.msgTime;
msgTask.timeDone = DateTime.MaxValue.ToString("yyyy-MM-dd HH:mm:ss");
ICDPacketMgr.GetInst().sendMsgToServer(msg);
}
Close();
}
private void OnProcChatRoom(int clientID, ICD.HEADER obj)
{
ICD.ChatRoomInfo msg = (ICD.ChatRoomInfo)obj;
switch (msg.msgID)
{
case ICD.DEF.CMD_ChatRoomInfo:
ProcMsgList(msg);
break;
case ICD.DEF.CMD_DelChatUsers:
ProcDelUser(msg);
break;
default:
break;
}
}
private void OnRecv_ChatRoomInfo(ICD.HEADER obj)
{
ICD.ChatRoomInfo msg = (ICD.ChatRoomInfo)obj;
foreach (int id in msg.body.taskIDs)
{
if (!mTasks.ContainsKey(id))
{
continue;
}
mTasks[id].currentState = msg.body.state;
}
UpdateTaskList();
//ICD.ChatRoomInfo msg = (ICD.ChatRoomInfo)obj;
//mChats[msg.body.recordID] = msg.body;
//UpdateChatList();
}
public static void DelChatTasks(ICD.ChatRoomInfo info)
{
foreach (int id in info.body.taskIDs)
{
string sql = string.Format(
"INSERT INTO chatHistory " +
"(chatID, time, user, type, info) " +
"VALUES ('{0}', '{1}', '{2}', '{3}', '{4}')",
info.body.recordID,
info.msgTime,
info.msgUser,
"delTask",
id);
MySqlCommand cmd = new MySqlCommand(sql, mConn);
cmd.ExecuteNonQuery();
}
}
public static void AddChatUsers(ICD.ChatRoomInfo info)
{
foreach (var user in info.body.users)
{
string sql = string.Format(
"INSERT INTO chatHistory " +
"(chatID, time, user, type, info) " +
"VALUES ('{0}', '{1}', '{2}', '{3}', '{4}')",
info.body.recordID,
info.msgTime,
info.msgUser,
"addUser",
user);
MySqlCommand cmd = new MySqlCommand(sql, mConn);
cmd.ExecuteNonQuery();
}
}
public static DataRow PushNewChat(ICD.ChatRoomInfo info)
{
string sql = string.Format(
"INSERT INTO chat " +
"(time, creator, access) " +
"VALUES ('{0}', '{1}', '{2}')",
info.msgTime,
info.msgUser,
info.body.access);
MySqlCommand cmd = new MySqlCommand(sql, mConn);
cmd.ExecuteNonQuery();
sql = string.Format("SELECT * FROM chat WHERE time='{0}' AND creator='{1}'", info.msgTime, info.msgUser);
MySqlDataAdapter adapter = new MySqlDataAdapter(sql, mConn);
DataSet ds = new DataSet();
adapter.Fill(ds, "Chat");
return(ds.Tables["Chat"].Rows[0]);
}
