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