01.public static string GenId()
02. {
03. var strSeqNo = string.Empty;
04. var strPreFix = "FLN-CM";
05. var intLength = 5;
06.
07. var intYear = DateTime.Now.Year;
08. var intSequence = 0;
09.
10. var objConn = new SqlConnection();
11. var objCmd = new SqlCommand();
12. var strSql = string.Empty;
13.
14. var strConnstring = "Data Source=ITSYSTEM\\SQLEXPRESS;Initial Catalog=FrolinaApplication;Persist Security Info=True;User ID=dsi;Password=1234";
15. objConn.ConnectionString = strConnstring;
16. objConn.Open();
17.
18. strSql = "SELECT Sequence FROM GenerateNumber WHERE Year = " + intYear + "";
19. objCmd = new SqlCommand(strSql, objConn);
20. SqlDataReader dr = objCmd.ExecuteReader();
21. if (dr.HasRows)
22. {
23. dr.Read();
24. intSequence = Convert.ToInt32(dr["Sequence"]);
25. }
26. dr.Close();
27.
28. if (intSequence == 0)
29. {
30. intSequence = 1;
31. strSql = "Insert Into GenerateNumber(Year,Sequence)Values(" + intYear + "," + intSequence + ")";
32. objCmd = new SqlCommand(strSql, objConn);
33. objCmd.ExecuteNonQuery();
34. }
35.
36. strSql = "UPDATE GenerateNumber SET Sequence = Sequence + 1 WHERE Year = " + intYear + "";
37. objCmd = new SqlCommand(strSql, objConn);
38. objCmd.ExecuteNonQuery();
39.
40. strSeqNo = string.Format("{0}-{1}-{2}", strPreFix, intYear.ToString().PadLeft(1, '0'), intSequence.ToString().PadLeft(intLength, '0'));
41.
42. objConn.Close();
43. objConn = null;
44. return strSeqNo;
