/// <summary> /// Method to Get AutoNumber /// </summary> /// <param name="Description">Description as Input</param> /// <returns>Returns AutoNumber</returns> public string GetAutoNumber(string Description) { string AutoNo = ""; int CurNo = 0; int NoDigit = 0; int AutoCode = 0; int i = 0; string SqlStr; SqlStr = "select * from SAS_AutoNumber where SAAN_Des='" + Description + "'"; try { Microsoft.Practices.EnterpriseLibrary.Data.Database loDbAut = DatabaseFactory.CreateDatabase(csConnectionStr); DbCommand cmd = loDbAut.GetSqlStringCommand(SqlStr); IDataReader loReader = loDbAut.ExecuteReader(cmd); if (loReader.Read()) { AutoCode = Convert.ToInt32(loReader["SAAN_Code"]); CurNo = Convert.ToInt32(loReader["SAAN_CurNo"]) + 1; NoDigit = Convert.ToInt32(loReader["SAAN_NoDigit"]); AutoNo = Convert.ToString(loReader["SAAN_Prefix"]); if (CurNo.ToString().Length < NoDigit) { while (i < NoDigit - CurNo.ToString().Length) { AutoNo = AutoNo + "0"; i = i + 1; } AutoNo = AutoNo + CurNo; } loReader.Close(); } AutoNumberEn loItem = new AutoNumberEn(); loItem.SAAN_Code = AutoCode; AutoNumberDAL cods = new AutoNumberDAL(); cods.GetItem(loItem); loItem.SAAN_Code = Convert.ToInt32(AutoCode); loItem.SAAN_CurNo = CurNo; loItem.SAAN_AutoNo = AutoNo; cods.Update(loItem); return(AutoNo); } catch (Exception ex) { Console.Write("Error in connection : " + ex.Message); return(ex.ToString()); } }
/// <summary> /// Method to Get AutoNumber /// </summary> /// <param name="Description">Description as Input</param> /// <returns>Returns AutoNumber</returns> public string GetAutoNumber(string Description) { string AutoNo = ""; int CurNo = 0; int NoDigit = 0; int AutoCode = 0; int i = 0; string SqlStr; SqlStr = "select * from SAS_AutoNumber where SAAN_Des='" + Description + "'"; try { IDataReader loReader = _DatabaseFactory.ExecuteReader(Helper.GetDataBaseType, DataBaseConnectionString, SqlStr).CreateDataReader(); if (loReader.Read()) { AutoCode = Convert.ToInt32(loReader["SAAN_Code"]); CurNo = Convert.ToInt32(loReader["SAAN_CurNo"]) + 1; NoDigit = Convert.ToInt32(loReader["SAAN_NoDigit"]); AutoNo = Convert.ToString(loReader["SAAN_Prefix"]); if (CurNo.ToString().Length < NoDigit) { while (i < NoDigit - CurNo.ToString().Length) { AutoNo = AutoNo + "0"; i = i + 1; } AutoNo = AutoNo + CurNo; } loReader.Close(); } AutoNumberEn loItem = new AutoNumberEn(); loItem.SAAN_Code = AutoCode; AutoNumberDAL cods = new AutoNumberDAL(); cods.GetItem(loItem); loItem.SAAN_Code = Convert.ToInt32(AutoCode); loItem.SAAN_CurNo = CurNo; loItem.SAAN_AutoNo = AutoNo; cods.Update(loItem); return(AutoNo); } catch (Exception ex) { Console.Write("Error in connection : " + ex.Message); return(ex.ToString()); } }