void StringSave() { for (int i = 0; i < dataGridView1.ColumnCount; i++) { for (int j = 0; j < dataGridView1.RowCount; j++) { dataGridView1[i, j].Style.ForeColor = Color.Black; } } //History 추가 IPHostEntry host = Dns.GetHostEntry(Dns.GetHostName()); string strMyIP = host.AddressList[0].ToString(); for (int i = 0; i < m_ModifyIDList.Count; i++) { tblNetError_History.Rows.Add(); DataRow Row_History = tblNetError_History.Rows[tblNetError_History.Rows.Count - 1]; DataRow Row = null; for (int nRow = 0; nRow < tblNetError.Rows.Count; nRow++) { if (tblNetError.Rows[nRow].RowState == DataRowState.Deleted) { continue; } if (tblNetError.Rows[nRow]["ID"].ToString() == m_ModifyIDList[i].ToString()) { Row = tblNetError.Rows[nRow]; } } Row_History["ID"] = Row["ID"]; Row_History["Enum"] = Row["Enum"]; Row_History["String"] = Row["String"]; Row_History["PreProcessor"] = Row["PreProcessor"]; Row_History["UserID"] = m_strID; Row_History["UserIP"] = strMyIP; Row_History["Regdate"] = Row["Regdate"]; Adpt.Update(new DataRow[] { Row }); Adpt_History.Update(new DataRow[] { Row_History }); #if __COUNTRY_KR__ int nRowIndex = -1; DataTable tblErrorTW = Adpt_NetErrorTW.GetData(); for (int twRow = 0; twRow < tblErrorTW.Rows.Count; twRow++) { if (Row["ID"].ToString() == tblErrorTW.Rows[twRow]["ID"].ToString()) { nRowIndex = twRow; break; } } if (nRowIndex != -1) { Adpt_Trans.UpdateNetErrorTable(Row["String"].ToString(), Convert.ToInt32(Row["ID"].ToString()), "KR"); } else { //tblNetError.Clear(); //Adpt.Fill(tblNetError); //추가된 것이므로 무조건 제일 밑 Adpt_Trans.InsertTrans("KR", "ScriptData", "NetErrorTable", "String", Convert.ToInt32(Row["ID"].ToString()), Row["String"].ToString(), Convert.ToDateTime(Row["Regdate"].ToString()), Convert.ToDateTime(Row["Regdate"].ToString())); Adpt_Trans.InsertTrans("TW", "ScriptData_TW", "NetErrorTable", "String", Convert.ToInt32(Row["ID"].ToString()), Row["String"].ToString(), Convert.ToDateTime(Row["Regdate"].ToString()), Convert.ToDateTime(Row["Regdate"].ToString())); Adpt_Trans.InsertTrans("HK", "ScriptData_HK", "NetErrorTable", "String", Convert.ToInt32(Row["ID"].ToString()), Row["String"].ToString(), Convert.ToDateTime(Row["Regdate"].ToString()), Convert.ToDateTime(Row["Regdate"].ToString())); Adpt_Trans.InsertTrans("JP", "ScriptData_JP", "NetErrorTable", "String", Convert.ToInt32(Row["ID"].ToString()), Row["String"].ToString(), Convert.ToDateTime(Row["Regdate"].ToString()), Convert.ToDateTime(Row["Regdate"].ToString())); Adpt_NetErrorTW.InsertNetErrorTable(Row["Enum"].ToString(), Row["String"].ToString(), Row["PreProcessor"].ToString(), Convert.ToDateTime(Row["Regdate"].ToString())); Adpt_NetErrorHK.InsertNetErrorTable(Row["Enum"].ToString(), Row["String"].ToString(), Row["PreProcessor"].ToString(), Convert.ToDateTime(Row["Regdate"].ToString())); Adpt_NetErrorJP.InsertNetErrorTable(Row["Enum"].ToString(), Row["String"].ToString(), Row["PreProcessor"].ToString(), Convert.ToDateTime(Row["Regdate"].ToString())); } } for (int i = 0; i < m_DeleteRowList.Count; i++) { tblNetError_DeleteHistory.Rows.Add(); DataRow Row_History = tblNetError_DeleteHistory.Rows[tblNetError_DeleteHistory.Rows.Count - 1]; DataRow Row = ((sDeleteRow)m_DeleteRowList[i]).drOriginalRow; //09. 06. 22 히스토리 입력부분 간소화 for (int Column = 0; Column < tblNetError.Columns.Count - 1; Column++) { Row_History[Column] = Row[Column]; } Row_History["UserID"] = m_strID; Row_History["UserIP"] = strMyIP; //09. 06. 22 김정협 DeleteBHistory에서 시간을 현재 지우는 시간으로 Row_History["Regdate"] = DateTime.Now; Adpt.Update(new DataRow[] { ((sDeleteRow)m_DeleteRowList[i]).drRow }); Adpt_DeleteHistory.Update(new DataRow[] { Row_History }); ScriptData_TWDataSetTableAdapters.NetErrorTableTableAdapter Adpt_NetErrorTW = new ScriptData_TWDataSetTableAdapters.NetErrorTableTableAdapter(); ScriptData_HKDataSetTableAdapters.NetErrorTableTableAdapter Adpt_NetErrorHK = new ScriptData_HKDataSetTableAdapters.NetErrorTableTableAdapter(); ScriptData_JPDataSetTableAdapters.NetErrorTableTableAdapter Adpt_NetErrorJP = new ScriptData_JPDataSetTableAdapters.NetErrorTableTableAdapter(); TransTableAdapter Adpt_Trans = new TransTableAdapter(); Adpt_NetErrorTW.DeleteNetErrorTable(Convert.ToInt32(Row["ID"].ToString())); Adpt_NetErrorHK.DeleteNetErrorTable(Convert.ToInt32(Row["ID"].ToString())); Adpt_NetErrorJP.DeleteNetErrorTable(Convert.ToInt32(Row["ID"].ToString())); Adpt_Trans.DeleteTrans("NetErrorTable", Convert.ToInt32(Row["ID"].ToString())); } tblNetError.Clear(); Adpt.Fill(tblNetError); tblNetError_History.Clear(); Adpt_History.Fill(tblNetError_History); tblNetError_DeleteHistory.Clear(); Adpt_DeleteHistory.Fill(tblNetError_DeleteHistory); #elif __COUNTRY_TW__ Adpt_Trans.UpdateNetErrorTable(Row["String"].ToString(), Convert.ToInt32(Row["ID"].ToString()), "TW"); }
void StringSave() { for (int i = 0; i < dataGridView1.ColumnCount; i++) { for (int j = 0; j < dataGridView1.RowCount; j++) { dataGridView1[i, j].Style.ForeColor = Color.Black; } } //History 추가 IPHostEntry host = Dns.GetHostEntry(Dns.GetHostName()); string strMyIP = host.AddressList[0].ToString(); for (int i = 0; i < host.AddressList.Length; i++) { if (host.AddressList[i].AddressFamily == System.Net.Sockets.AddressFamily.InterNetwork) { strMyIP = host.AddressList[i].ToString(); break; } } for (int i = 0; i < m_ModifyIDList.Count; i++) { tblTextureStringManager_History.Rows.Add(); DataRow Row_History = tblTextureStringManager_History.Rows[tblTextureStringManager_History.Rows.Count - 1]; DataRow Row = null; for (int nRow = 0; nRow < tblTextureStringManager.Rows.Count; nRow++) { if (tblTextureStringManager.Rows[nRow].RowState == DataRowState.Deleted) { continue; } if (tblTextureStringManager.Rows[nRow]["TextureIDX"].ToString() == m_ModifyIDList[i].ToString()) { Row = tblTextureStringManager.Rows[nRow]; } } Row_History["TextureIDX"] = Row["TextureIDX"]; Row_History["FilePath"] = Row["FilePath"]; Row_History["String"] = Row["String"]; Row_History["IsChange"] = Row["IsChange"]; Row_History["bUse"] = Row["bUse"]; Row_History["UserID"] = m_strID; Row_History["UserIP"] = strMyIP; Row_History["Regdate"] = Row["Regdate"]; Adpt.Update(new DataRow[] { Row }); Adpt_History.Update(new DataRow[] { Row_History }); #if __COUNTRY_KR__ int nRowIndex = -1; //TextureStringManagerTableTableAdapter Adpt_TextureStringManagerTW = new TextureStringManagerTableTableAdapter(); //DataTable tblErrorTW = Adpt_TextureStringManagerTW.GetData(); DataTable tblTextureTW = Adpt_TextureStringManagerTW.GetData(); for (int twRow = 0; twRow < tblTextureTW.Rows.Count; twRow++) { if (Row["TextureIDX"].ToString() == tblTextureTW.Rows[twRow]["TextureIDX"].ToString()) { nRowIndex = twRow; break; } } if (nRowIndex != -1) { Adpt_Trans.UpdateTextureStringManagerTable(Row["String"].ToString(), Convert.ToInt32(Row["TextureIDX"].ToString()), "KR"); } else { // tblTextureStringManager.Clear(); //Adpt.Fill(tblTextureStringManager); //추가된 것이므로 무조건 제일 밑 Adpt_TextureStringManagerTW.InsertTextureStringManagerTable(Row["FilePath"].ToString(), Row["String"].ToString(), false, true, Convert.ToDateTime(Row["Regdate"].ToString())); Adpt_TextureStringManagerHK.InsertTextureStringManagerTable(Row["FilePath"].ToString(), Row["String"].ToString(), false, true, Convert.ToDateTime(Row["Regdate"].ToString())); Adpt_TextureStringManagerJP.InsertTextureStringManagerTable(Row["FilePath"].ToString(), Row["String"].ToString(), false, true, Convert.ToDateTime(Row["Regdate"].ToString())); int nMaxIDX = Convert.ToInt32(Adpt_TextureStringManagerTW.GetMaxIDX().ToString()); Adpt_Trans.InsertTrans("KR", "ScriptData", "TextureStringManagerTable", "String", nMaxIDX, Row["String"].ToString(), Convert.ToDateTime(Row["Regdate"].ToString()), Convert.ToDateTime(Row["Regdate"].ToString())); Adpt_Trans.InsertTrans("TW", "ScriptData_TW", "TextureStringManagerTable", "String", nMaxIDX, Row["String"].ToString(), Convert.ToDateTime(Row["Regdate"].ToString()), Convert.ToDateTime(Row["Regdate"].ToString())); Adpt_Trans.InsertTrans("HK", "ScriptData_HK", "TextureStringManagerTable", "String", nMaxIDX, Row["String"].ToString(), Convert.ToDateTime(Row["Regdate"].ToString()), Convert.ToDateTime(Row["Regdate"].ToString())); Adpt_Trans.InsertTrans("JP", "ScriptData_JP", "TextureStringManagerTable", "String", nMaxIDX, Row["String"].ToString(), Convert.ToDateTime(Row["Regdate"].ToString()), Convert.ToDateTime(Row["Regdate"].ToString())); } } for (int i = 0; i < m_DeleteRowList.Count; i++) { tblTextureStringManager_DeleteHistory.Rows.Add(); DataRow Row_History = tblTextureStringManager_DeleteHistory.Rows[tblTextureStringManager_DeleteHistory.Rows.Count - 1]; DataRow Row = ((sDeleteRow)m_DeleteRowList[i]).drOriginalRow; //09. 06. 22 히스토리 입력부분 간소화 for (int Column = 0; Column < tblTextureStringManager.Columns.Count - 1; Column++) { Row_History[Column] = Row[Column]; } Row_History["UserID"] = m_strID; Row_History["UserIP"] = strMyIP; //09. 06. 22 김정협 DeleteBHistory에서 시간을 현재 지우는 시간으로 Row_History["Regdate"] = DateTime.Now; Adpt.Update(new DataRow[] { ((sDeleteRow)m_DeleteRowList[i]).drRow }); Adpt_DeleteHistory.Update(new DataRow[] { Row_History }); //TextureStringManagerTableTableAdapter Adpt_TextureStringManagerTW = new TextureStringManagerTableTableAdapter(); TransTableAdapter Adpt_Trans = new TransTableAdapter(); Adpt_TextureStringManagerTW.DeleteTextureStringManagerTable(Convert.ToInt32(Row["TextureIDX"].ToString())); Adpt_TextureStringManagerHK.DeleteTextureStringManagerTable(Convert.ToInt32(Row["TextureIDX"].ToString())); Adpt_TextureStringManagerJP.DeleteTextureStringManagerTable(Convert.ToInt32(Row["TextureIDX"].ToString())); Adpt_Trans.DeleteTrans("TextureStringManagerTable", Convert.ToInt32(Row["TextureIDX"].ToString())); } tblTextureStringManager.Clear(); Adpt.Fill(tblTextureStringManager); tblTextureStringManager_History.Clear(); Adpt_History.Fill(tblTextureStringManager_History); tblTextureStringManager_DeleteHistory.Clear(); Adpt_DeleteHistory.Fill(tblTextureStringManager_DeleteHistory); #elif __COUNTRY_TW__ Adpt_Trans.UpdateTextureStringManagerTable(Row["String"].ToString(), Convert.ToInt32(Row["TextureIDX"].ToString()), "TW"); }