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