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]); }