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; dataGridView1[i, j].Style.SelectionForeColor = Color.White; } } //History 추가 IPHostEntry host = Dns.GetHostEntry(Dns.GetHostName()); string strMyIP = host.AddressList[0].ToString(); for (int i = 0; i < m_ModifyIDList.Count; i++) { tblString_History.Rows.Add(); DataRow Row_History = tblString_History.Rows[tblString_History.Rows.Count - 1]; DataRow Row = tblString.Rows[Convert.ToInt32(m_ModifyIDList[i].ToString())]; Row_History["ID"] = Row["ID"]; Row_History["ENum"] = Row["ENum"]; Row_History["Type"] = Row["Type"]; Row_History["String"] = Row["String"]; Row_History["UserID"] = m_strID; Row_History["UserIP"] = strMyIP; Row_History["Regdate"] = Row["Regdate"]; try { Adpt.Update(new DataRow[] { Row }); Adpt_History.Update(new DataRow[] { Row_History }); } catch (SqlException ex) { DataTable tblTemp; tblTemp = tblString.Clone(); tblTemp = tblString.Copy(); tblString.Clear(); Adpt.Fill(tblString); int nSamePoint = -1; for (int j = tblTemp.Rows.Count - 1; j >= 0; j--) { if (j >= tblString.Rows.Count) { continue; } if (tblTemp.Rows[j]["ID"].ToString() == tblString.Rows[j]["ID"].ToString() && tblTemp.Rows[j]["String"].ToString() == tblString.Rows[j]["String"].ToString()) { nSamePoint = j; break; } } for (int j = nSamePoint + 1; j < tblTemp.Rows.Count; j++) { /*tblString.Rows.Add(); * Adpt.Update(new DataRow[] { tblString.Rows[tblString.Rows.Count - 1] }); * tblString.Clear(); * Adpt.Fill(tblString);*/ tblString.Rows.Add(); tblString_History.Rows.Add(); for (int k = 2; k < tblString.Columns.Count; k++) { tblString.Rows[tblString.Rows.Count - 1][k] = tblTemp.Rows[j][k]; } tblString.Rows[tblString.Rows.Count - 1]["ID"] = Convert.ToInt32(tblString.Rows[tblString.Rows.Count - 2]["ID"].ToString()) + 1; tblString.Rows[tblString.Rows.Count - 1]["ENum"] = "STR_ID_" + tblString.Rows[tblString.Rows.Count - 1]["ID"].ToString(); tblString_History.Rows[tblString_History.Rows.Count - 1]["ID"] = tblString.Rows[tblString.Rows.Count - 1]["ID"]; tblString_History.Rows[tblString_History.Rows.Count - 1]["ENum"] = tblString.Rows[tblString.Rows.Count - 1]["ENum"]; tblString_History.Rows[tblString_History.Rows.Count - 1]["Type"] = tblString.Rows[tblString.Rows.Count - 1]["Type"]; tblString_History.Rows[tblString_History.Rows.Count - 1]["String"] = tblString.Rows[tblString.Rows.Count - 1]["String"]; tblString_History.Rows[tblString_History.Rows.Count - 1]["UserID"] = m_strID; tblString_History.Rows[tblString_History.Rows.Count - 1]["UserIP"] = strMyIP; tblString_History.Rows[tblString_History.Rows.Count - 1]["Regdate"] = tblString.Rows[tblString.Rows.Count - 1]["Regdate"]; Adpt.Update(new DataRow[] { tblString.Rows[tblString.Rows.Count - 1] }); Adpt_History.Update(new DataRow[] { tblString_History.Rows[tblString_History.Rows.Count - 1] }); } //tblString.Rows.Add(); } int nRowIndex = -1; ScriptData_TWDataSetTableAdapters.StringTableTableAdapter Adpt_StringTW = new ScriptData_TWDataSetTableAdapters.StringTableTableAdapter(); ScriptData_HKDataSetTableAdapters.StringTableTableAdapter Adpt_StringHK = new ScriptData_HKDataSetTableAdapters.StringTableTableAdapter(); ScriptData_JPDataSetTableAdapters.StringTableTableAdapter Adpt_StringJP = new ScriptData_JPDataSetTableAdapters.StringTableTableAdapter(); DataTable tblStringTW = Adpt_StringTW.GetData(); TransTableAdapter Adpt_Trans = new TransTableAdapter(); for (int twRow = 0; twRow < tblStringTW.Rows.Count; twRow++) { if (Row["ID"].ToString() == tblStringTW.Rows[twRow]["ID"].ToString()) { nRowIndex = twRow; break; } } if (nRowIndex != -1) { Adpt_Trans.UpdateStringTable(Row["String"].ToString(), Convert.ToInt32(Row["ID"].ToString())); } else { Adpt_Trans.InsertTrans("KR", "ScriptData", "StringTable", "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", "StringTable", "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", "StringTable", "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", "StringTable", "String", Convert.ToInt32(Row["ID"].ToString()), Row["String"].ToString(), Convert.ToDateTime(Row["Regdate"].ToString()), Convert.ToDateTime(Row["Regdate"].ToString())); Adpt_StringTW.InsertString(Convert.ToInt16(Row["ID"].ToString()), Row["ENum"].ToString(), Row["TYPE"].ToString(), Row["String"].ToString(), Convert.ToDateTime(Row["Regdate"].ToString())); Adpt_StringHK.InsertString(Convert.ToInt16(Row["ID"].ToString()), Row["ENum"].ToString(), Row["TYPE"].ToString(), Row["String"].ToString(), Convert.ToDateTime(Row["Regdate"].ToString())); Adpt_StringJP.InsertString(Convert.ToInt16(Row["ID"].ToString()), Row["ENum"].ToString(), Row["TYPE"].ToString(), Row["String"].ToString(), Convert.ToDateTime(Row["Regdate"].ToString())); } } tblString.Clear(); Adpt.Fill(tblString); tblString_History.Clear(); Adpt_History.Fill(tblString_History); dataGridView1.CurrentCell = dataGridView1[0, dataGridView1.RowCount - 1]; //tblString_History.Rows[tblString_History.Rows.Count - 1] //DataRow Row = tblString.Rows[Convert.ToInt32(m_ModifyIDList[0].ToString())]; m_ModifyIDList.Clear(); m_bSaveEnd = true; }
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"); }