public string GetRunningNumber(CGeneral.TypeConfig typeConfig)
{
CheckCurrentDate(typeConfig);
string RunningNumber = "";
DataTable dTable = new DataTable();
StringBuilder sbd = new StringBuilder();
sbd.AppendLine("SELECT [TypeConfig],[prefix],[year],[month],[day],[RunningNumber],[DigitLength] ");
sbd.AppendLine("FROM [ConfigRunningNumber] WHERE TypeConfig='" + typeConfig + "'");
dTable = oConn.Query(sbd.ToString());
if (dTable.Rows.Count > 0)
{
string prefix = dTable.Rows[0]["prefix"].ToString();
string year = dTable.Rows[0]["year"].ToString();
string month = dTable.Rows[0]["month"].ToString();
string day = dTable.Rows[0]["day"].ToString();
int running = Convert.ToInt32(dTable.Rows[0]["RunningNumber"]);
int _digit = Convert.ToInt32(dTable.Rows[0]["DigitLength"]);
string digit = "";
for (int i = 0; i < _digit; i++)
{
digit += "0";
}
running++;
RunningNumber = prefix + year.Substring(2, 2) + running.ToString(digit);
UpdateRunningNumber(typeConfig);
}
return(RunningNumber);
}
private void UpdateRunningNumber(CGeneral.TypeConfig typeConfig)
{
StringBuilder sbd = new StringBuilder();
sbd.AppendLine("UPDATE ConfigRunningNumber SET RunningNumber+=1 WHERE TypeConfig='" + typeConfig + "'");
oConn.ExecuteCommand(sbd.ToString());
}
private void CheckCurrentDate(CGeneral.TypeConfig typeConfig)
{
StringBuilder sbd = new StringBuilder();
DataTable dTable = new DataTable();
sbd = new StringBuilder();
sbd.AppendLine("SELECT [TypeConfig],[prefix],[year],[month],[day],[RunningNumber],[DigitLength] ");
sbd.AppendLine("FROM [ConfigRunningNumber] WHERE TypeConfig='" + typeConfig + "'");
dTable = oConn.Query(sbd.ToString());
bool resetRunning = false;
if (dTable.Rows.Count > 0)
{
if (dTable.Rows[0]["year"].ToString() != DateTime.Now.Year.ToString())
{
resetRunning = true;
}
//if (dTable.Rows[0]["month"].ToString() != DateTime.Now.Month.ToString())
//{
// resetRunning = true;
//}
//if (dTable.Rows[0]["day"].ToString() != DateTime.Now.Day.ToString())
//{
// resetRunning = true;
//}
}
if (resetRunning)
{
sbd = new StringBuilder();
sbd.AppendLine("UPDATE ConfigRunningNumber SET RunningNumber=0,year='" + DateTime.Now.Year.ToString() + "'");
sbd.AppendLine(",month='" + DateTime.Now.Month.ToString() + "'");
sbd.AppendLine(",day='" + DateTime.Now.Day.ToString() + "'");
sbd.AppendLine("WHERE TypeConfig='" + typeConfig + "'");
oConn.ExecuteCommand(sbd.ToString());
}
}
