public static int EditTask(ICD.WorkHistoryList msg)
{
int ret = 0;
foreach (var item in msg.workHistory)
{
string sql = string.Format(
"INSERT INTO taskHistory " +
"(taskID, time, user, columnName, fromInfo, toInfo) " +
"VALUES ('{0}', '{1}', '{2}', '{3}', '{4}', '{5}')",
item.taskID,
msg.msgTime,
msg.msgUser,
item.columnName,
item.fromInfo,
item.toInfo);
MySqlCommand cmd = new MySqlCommand(sql, mConn);
ret += cmd.ExecuteNonQuery();
}
return(ret);
}
private void ProcTaskHistory(HEADER obj)
{
ICD.WorkHistoryList msg = (ICD.WorkHistoryList)obj;
if (msg.workHistory.Length > 0)
{
int taskID = msg.workHistory[0].taskID;
if (!mTracks.ContainsKey(taskID))
{
LOG.warn();
return;
}
mTracks[taskID].his = msg.workHistory;
}
mCount--;
if (mCount <= 0)
{
UpdateTaskTracking();
}
}
private void sendEditInfo()
{
List <WorkHistory> vec = new List <WorkHistory>();
List <string> newUsers = new List <string>();
if (cbAccess.Text != mTask.access)
{
WorkHistory item = new WorkHistory();
item.taskID = mTask.recordID;
item.editor = MyInfo.mMyInfo.userID;
item.columnName = "access";
item.fromInfo = mTask.access;
item.toInfo = cbAccess.Text;
vec.Add(item);
}
if (cbMainCate.Text != mTask.mainCate)
{
WorkHistory item = new WorkHistory();
item.taskID = mTask.recordID;
item.editor = MyInfo.mMyInfo.userID;
item.columnName = "mainCate";
item.fromInfo = mTask.mainCate;
item.toInfo = cbMainCate.Text;
vec.Add(item);
}
if (cbSubCate.Text != mTask.subCate)
{
WorkHistory item = new WorkHistory();
item.taskID = mTask.recordID;
item.editor = MyInfo.mMyInfo.userID;
item.columnName = "subCate";
item.fromInfo = mTask.subCate;
item.toInfo = cbSubCate.Text;
vec.Add(item);
}
if (tbTitle.Text != mTask.title)
{
WorkHistory item = new WorkHistory();
item.taskID = mTask.recordID;
item.editor = MyInfo.mMyInfo.userID;
item.columnName = "title";
item.fromInfo = mTask.title;
item.toInfo = tbTitle.Text;
vec.Add(item);
}
if (tbComment.Text != mTask.comment)
{
WorkHistory item = new WorkHistory();
item.taskID = mTask.recordID;
item.editor = MyInfo.mMyInfo.userID;
item.columnName = "comment";
item.fromInfo = mTask.comment;
item.toInfo = tbComment.Text;
vec.Add(item);
}
if (btnDirector.Text != mTask.director)
{
WorkHistory item = new WorkHistory();
item.taskID = mTask.recordID;
item.editor = MyInfo.mMyInfo.userID;
item.columnName = "director";
item.fromInfo = mTask.director;
item.toInfo = btnDirector.Text;
vec.Add(item);
newUsers.Add(item.toInfo);
}
if (btnWorker.Text != mTask.worker)
{
WorkHistory item = new WorkHistory();
item.taskID = mTask.recordID;
item.editor = MyInfo.mMyInfo.userID;
item.columnName = "worker";
item.fromInfo = mTask.worker;
item.toInfo = btnWorker.Text;
vec.Add(item);
newUsers.Add(item.toInfo);
}
if (dtLaunch.Value.Ticks != DateTime.Parse(mTask.launch).Ticks)
{
WorkHistory item = new WorkHistory();
item.taskID = mTask.recordID;
item.editor = MyInfo.mMyInfo.userID;
item.columnName = "launch";
item.fromInfo = mTask.launch.ToString();
item.toInfo = dtLaunch.Value.ToString("yyyy-MM-dd HH:mm:ss");
vec.Add(item);
}
if (dtDue.Value.Ticks != DateTime.Parse(mTask.due).Ticks)
{
WorkHistory item = new WorkHistory();
item.taskID = mTask.recordID;
item.editor = MyInfo.mMyInfo.userID;
item.columnName = "due";
item.fromInfo = mTask.due.ToString();
item.toInfo = dtDue.Value.ToString("yyyy-MM-dd HH:mm:ss");
vec.Add(item);
}
if (dtTerm.Value.Ticks != DateTime.Parse(mTask.term).Ticks)
{
WorkHistory item = new WorkHistory();
item.taskID = mTask.recordID;
item.editor = MyInfo.mMyInfo.userID;
item.columnName = "term";
item.fromInfo = mTask.term.ToString();
item.toInfo = dtTerm.Value.ToString("yyyy-MM-dd HH:mm:ss");
vec.Add(item);
}
if (cbPriority.Text != mTask.priority)
{
WorkHistory item = new WorkHistory();
item.taskID = mTask.recordID;
item.editor = MyInfo.mMyInfo.userID;
item.columnName = "priority";
item.fromInfo = mTask.priority;
item.toInfo = cbPriority.Text;
vec.Add(item);
}
if (vec.Count == 0)
{
MessageBox.Show("변경점이 없습니다.");
}
else
{
if (newUsers.Count > 0)
{
ChatRoomInfo addUserMsg = new ChatRoomInfo();
addUserMsg.FillClientHeader(DEF.CMD_AddChatUsers, 0);
addUserMsg.body.recordID = mTask.chatID;
addUserMsg.body.users = newUsers.ToArray();
ICDPacketMgr.GetInst().sendMsgToServer(addUserMsg);
}
ICD.WorkHistoryList msg = new ICD.WorkHistoryList();
msg.FillClientHeader(ICD.DEF.CMD_TaskEdit, 0);
msg.workHistory = vec.ToArray();
ICDPacketMgr.GetInst().sendMsgToServer(msg);
string editedInfo = " <Task 변경>\n";
foreach (var item in msg.workHistory)
{
string info = string.Format("[{0}] : {1} => {2}\n",
item.columnName, item.fromInfo, item.toInfo);
editedInfo += info;
}
SendChatMessage(editedInfo, true);
}
}
