public static void InitializeNumberings( ) { #region NumberingTypes NumberingTypes = new Dictionary <Guid, NumberingType>(); DataSet ds = BusinessObjectController.RunQuery(@"SELECT * FROM GENumberingTypes"); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { if (dr["GENumberingTypeID"] == DBNull.Value) { continue; } NumberingType type = new NumberingType(); #region type type.ID = ABCHelper.DataConverter.ConvertToGuid(dr["GENumberingTypeID"]); if (type.ID == Guid.Empty) { continue; } if (dr["PatternType"] != DBNull.Value) { type.PatternType = dr["PatternType"].ToString(); } type.IsByUser = false; if (dr["IsByUser"] != DBNull.Value) { type.IsByUser = Convert.ToBoolean(dr["IsByUser"]); } type.IsByUserGroup = false; if (dr["IsByUserGroup"] != DBNull.Value) { type.IsByUserGroup = Convert.ToBoolean(dr["IsByUserGroup"]); } type.IsByEmployee = false; if (dr["IsByEmployee"] != DBNull.Value) { type.IsByEmployee = Convert.ToBoolean(dr["IsByEmployee"]); } type.IsByCompanyUnit = false; if (dr["IsByCompanyUnit"] != DBNull.Value) { type.IsByCompanyUnit = Convert.ToBoolean(dr["IsByCompanyUnit"]); } type.IsYYMMCount = false; if (dr["IsYYMMCount"] != DBNull.Value) { type.IsYYMMCount = Convert.ToBoolean(dr["IsYYMMCount"]); } type.IsYYMMDDCount = false; if (dr["IsYYMMDDCount"] != DBNull.Value) { type.IsYYMMDDCount = Convert.ToBoolean(dr["IsYYMMDDCount"]); } type.IsMMDDCount = false; if (dr["IsMMDDCount"] != DBNull.Value) { type.IsMMDDCount = Convert.ToBoolean(dr["IsMMDDCount"]); } type.CountingSpace = 2; if (dr["CountingSpace"] != DBNull.Value) { type.CountingSpace = Convert.ToInt32(dr["CountingSpace"]); } type.IsByField = false; if (dr["IsByField"] != DBNull.Value) { type.IsByField = Convert.ToBoolean(dr["IsByField"]); } if (dr["FieldName"] != DBNull.Value) { type.FieldName = dr["FieldName"].ToString(); } #endregion if (!NumberingTypes.ContainsKey(type.ID)) { NumberingTypes.Add(type.ID, type); } } } #endregion #region NumberingConfigs NumberingConfigs = new List <Numbering>(); ds = BusinessObjectController.RunQuery(@"SELECT * FROM GENumberings"); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { if (dr["GENumberingID"] == DBNull.Value) { continue; } Numbering number = new Numbering(); #region Number number.ID = ABCHelper.DataConverter.ConvertToGuid(dr["GENumberingID"]); if (number.ID == Guid.Empty) { continue; } if (dr["TableName"] != DBNull.Value) { number.TableName = dr["TableName"].ToString(); } if (dr["ConditionString"] != DBNull.Value) { number.ConditionString = dr["ConditionString"].ToString(); } if (dr["FieldCondition"] != DBNull.Value) { number.FieldCondition = dr["FieldCondition"].ToString(); } if (dr["FieldValue"] != DBNull.Value) { number.FieldValue = dr["FieldValue"].ToString(); } if (dr["SeperateChar"] != DBNull.Value) { number.SeperateChar = dr["SeperateChar"].ToString(); } if (dr["Prefix"] != DBNull.Value) { number.Prefix = dr["Prefix"].ToString(); } if (dr["Suffix"] != DBNull.Value) { number.Suffix = dr["Suffix"].ToString(); } number.IsUsePattern = false; if (dr["IsUsePattern"] != DBNull.Value) { number.IsUsePattern = Convert.ToBoolean(dr["IsUsePattern"]); } if (dr["NumberPattern"] != DBNull.Value) { number.NumberPattern = dr["NumberPattern"].ToString(); } #endregion #region number.MiddleConfigs number.MiddleConfigs = new List <NumberingType>(); List <Object> lstTypeIDs = BusinessObjectController.GetListObjects(String.Format(@"SELECT FK_GENumberingTypeID FROM GENumberingMiddleItems WHERE FK_GENumberingID ='{0}' ORDER BY MiddleIndex", number.ID)); foreach (Object objID in lstTypeIDs) { Guid typeID = ABCHelper.DataConverter.ConvertToGuid(objID); if (typeID == Guid.Empty) { continue; } if (NumberingTypes.ContainsKey(typeID)) { number.MiddleConfigs.Add(NumberingTypes[typeID]); } } #endregion NumberingConfigs.Add(number); } } #endregion }