private void WriteLog(string msg)
{
ThreadPool.QueueUserWorkItem(a =>
{
try
{
Dispatcher.Invoke(new Action(() =>
{
if (TxtMsg.LineCount > 10000)
{
TxtMsg.Clear();
}
TxtMsg.AppendText(string.Format("{0}\t{1}\r\n", DateTime.Now.ToString("HH:mm:ss"), msg));
TxtMsg.ScrollToEnd();
}));
}
catch { }
});
}
private void btnImportDetailResult_Click(object sender, EventArgs e)
{
TxtMsg.Clear();
for (int iRowIndx = 0; iRowIndx < dgvImportInfo.Rows.Count - 1; iRowIndx++)
{
string strRoundNo = dgvImportInfo.Rows[iRowIndx].Cells["RoundNo"].Value.ToString();
string strOrderNo = dgvImportInfo.Rows[iRowIndx].Cells["OrderNo"].Value.ToString();
string strDivePoint, strDiveRank, strEventRank, strEventPoint, strDiveHeight;
if (dgvImportInfo.Rows[iRowIndx].Cells["DivePoints"].Value == null)
{
strDivePoint = "-1";
}
else
{
strDivePoint = dgvImportInfo.Rows[iRowIndx].Cells["DivePoints"].Value.ToString();
}
if (dgvImportInfo.Rows[iRowIndx].Cells["DiveRank"].Value == null)
{
strDiveRank = "-1";
}
else
{
strDiveRank = dgvImportInfo.Rows[iRowIndx].Cells["DiveRank"].Value.ToString();
}
if (dgvImportInfo.Rows[iRowIndx].Cells["EventPoint"].Value == null)
{
strEventPoint = "-1";
}
else
{
strEventPoint = dgvImportInfo.Rows[iRowIndx].Cells["EventPoint"].Value.ToString();
}
if (dgvImportInfo.Rows[iRowIndx].Cells["EventRank"].Value == null)
{
strEventRank = "-1";
}
else
{
strEventRank = dgvImportInfo.Rows[iRowIndx].Cells["EventRank"].Value.ToString();
}
string strMatchTypeID = dgvImportInfo.Rows[iRowIndx].Cells["MatchsplitTypeID"].Value.ToString();
int nResult = DVCommon.g_DVDBManager.UpdateDetailMatchResult(m_strInnerMatchID, strRoundNo, strOrderNo, strDivePoint, strDiveRank, strEventPoint, strEventRank, strMatchTypeID);
string strMsg = "";
switch (nResult)
{
case 0:
strMsg = string.Format("Update OrderNo: {0} in RoundNo: {1} DetailResult Failed!", strOrderNo, strRoundNo);
WriteLog(strMsg);
break;
case 1:
strMsg = string.Format("Update OrderNo: {0} in RoundNo: {1} DetailResult Success!", strOrderNo, strRoundNo);
WriteLog(strMsg);
break;
case -1:
strMsg = "Update DetailResult Failed, for the wrong MatchID: " + m_strInnerMatchID;
WriteLog(strMsg);
break;
case -2:
strMsg = "Update DetailResult Failed, for the wrong RoundNo: " + strRoundNo;
WriteLog(strMsg);
break;
case -3:
strMsg = "Update DetailResult Failed, for the wrong OrderNo: " + strOrderNo;
WriteLog(strMsg);
break;
}
}
}
private void btnImprotMatchResult_Click(object sender, EventArgs e)
{
TxtMsg.Clear();
for (int iRowIndx = 0; iRowIndx < dgvImportInfo.Rows.Count - 1; iRowIndx++)
{
string strOrderNo = dgvImportInfo.Rows[iRowIndx].Cells["OrderNo"].Value.ToString();
string strEventPoint, strEventPlace, strQualified, strIRM;
if (dgvImportInfo.Rows[iRowIndx].Cells["EventPoint"].Value == null)
{
strEventPoint = "-1";
}
else
{
strEventPoint = dgvImportInfo.Rows[iRowIndx].Cells["EventPoint"].Value.ToString();
}
if (dgvImportInfo.Rows[iRowIndx].Cells["EventPlace"].Value == null)
{
strEventPlace = "-1";
}
else
{
strEventPlace = dgvImportInfo.Rows[iRowIndx].Cells["EventPlace"].Value.ToString();
}
if (dgvImportInfo.Rows[iRowIndx].Cells["Qualified"].Value == null)
{
strQualified = "-1";
}
else
{
strQualified = dgvImportInfo.Rows[iRowIndx].Cells["Qualified"].Value.ToString();
}
if (dgvImportInfo.Rows[iRowIndx].Cells["Nonuser"].Value == null)
{
strIRM = "-1";
}
else
{
strIRM = dgvImportInfo.Rows[iRowIndx].Cells["Nonuser"].Value.ToString();
}
int nResult = DVCommon.g_DVDBManager.UpdateMatchResult(m_strInnerMatchID, strOrderNo, strEventPoint, strEventPlace, strQualified, strIRM);
string strMsg = "";
switch (nResult)
{
case 0:
strMsg = "Update MatchResult Failed! OrderNo: " + strOrderNo;
WriteLog(strMsg);
break;
case 1:
strMsg = string.Format("Update MatchResult Success! OrderNo: {0}", strOrderNo);
WriteLog(strMsg);
break;
case -1:
strMsg = "Update MatchResult Failed, for the wrong MatchID: " + m_strInnerMatchID;
WriteLog(strMsg);
break;
case -2:
strMsg = "Update MatchResult Failed, for the wrong OrderNo: " + strOrderNo;
WriteLog(strMsg);
break;
}
}
}
private void btnImportActionList_Click(object sender, EventArgs e)
{
TxtMsg.Clear();
for (int iRowIndx = 0; iRowIndx < dgvImportInfo.Rows.Count - 1; iRowIndx++)
{
string strRoundNo = dgvImportInfo.Rows[iRowIndx].Cells["RoundNo"].Value.ToString();
string strOrderNo = dgvImportInfo.Rows[iRowIndx].Cells["OrderNo"].Value.ToString();
string strActionCode, strDiveDiff, strDiveHeight;
if (dgvImportInfo.Rows[iRowIndx].Cells["DiveCode1"].Value == null)
{
strActionCode = "-1";
}
else
{
strActionCode = dgvImportInfo.Rows[iRowIndx].Cells["DiveCode1"].Value.ToString();
}
if (dgvImportInfo.Rows[iRowIndx].Cells["DiveDiff"].Value == null)
{
strDiveDiff = "-1";
}
else
{
strDiveDiff = dgvImportInfo.Rows[iRowIndx].Cells["DiveDiff"].Value.ToString();
}
if (dgvImportInfo.Rows[iRowIndx].Cells["DiveHeight"].Value == null)
{
strDiveHeight = "-1";
}
else
{
strDiveHeight = dgvImportInfo.Rows[iRowIndx].Cells["DiveHeight"].Value.ToString();
}
int nResult = DVCommon.g_DVDBManager.UpdateActionCode(m_strInnerMatchID, strRoundNo, strOrderNo, strActionCode, strDiveDiff, strDiveHeight);
string strMsg = "";
switch (nResult)
{
case 0:
strMsg = string.Format("Update ActionCode Failed! OrderNo: {0} in RoundNo: {1} ", strOrderNo, strRoundNo);
WriteLog(strMsg);
break;
case 1:
strMsg = string.Format("Update OrderNo: {0} in the RoundNo: {1} ActionCode Success! ", strOrderNo, strRoundNo);
WriteLog(strMsg);
break;
case -1:
strMsg = "Update ActionCode Failed, for the wrong MatchID: " + m_strInnerMatchID;
WriteLog(strMsg);
break;
case -2:
strMsg = "Update ActionCode Failed, for the wrong RoundNo: " + strRoundNo;
WriteLog(strMsg);
break;
case -3:
strMsg = "Update ActionCode Failed, for the wrong OrderNo: " + strOrderNo;
WriteLog(strMsg);
break;
case -4:
strMsg = "Update ActionCode Failed, for the wrong ActionCode: " + strActionCode;
WriteLog(strMsg);
break;
}
}
}