| | |
|---|
| | | private int m_CaseID = 0;
|
|---|
| | | private int m_Year = 0;
|
|---|
| | | private bool m_ChangeYear = false;
|
|---|
| | | private string m_NowYear = string.Empty;
|
|---|
| | | private String m_AcceptTime = "";
|
|---|
| | | private RecordLog _PLog;
|
|---|
| | | private OracleConnection _ConnectionTPC;
|
|---|
| | |
|---|
| | |
|
|---|
| | | if (m_ChangeYear)
|
|---|
| | | SqlStmt = "UPDATE EOS.EVENTNUM SET ACCEPTNUM = '" + (Convert.ToInt32(m_AcceptNum) + 1).ToString() + "',CASEID = "
|
|---|
| | | + (m_CaseID + 1) + ",YEAR = " + (m_Year + 1) + " WHERE CASEID = " + this.m_CaseID;
|
|---|
| | | + (m_CaseID + 1) + ",YEAR = " + m_NowYear + " WHERE CASEID = " + this.m_CaseID;
|
|---|
| | | else
|
|---|
| | | SqlStmt = "UPDATE EOS.EVENTNUM SET ACCEPTNUM = '" + (Convert.ToInt32(m_AcceptNum) + 1).ToString() + "',CASEID = "
|
|---|
| | | + (m_CaseID + 1) + " WHERE CASEID = " + this.m_CaseID;
|
|---|
| | | + (m_CaseID + 1) + " WHERE CASEID = " + this.m_CaseID + " AND ACCEPTNUM = '" + m_AcceptNum + "'";
|
|---|
| | |
|
|---|
| | | OracleCommand Command = new OracleCommand(SqlStmt, _ConnectionTPC);
|
|---|
| | |
|
|---|
| | |
|---|
| | | }
|
|---|
| | | } else {
|
|---|
| | | m_AcceptNum = NowYear.ToString() + "010001"; // 新年度
|
|---|
| | | m_NowYear = NowYear.ToString();
|
|---|
| | | this.m_ChangeYear = true;
|
|---|
| | | }
|
|---|
| | |
|
|---|
