Esempio n. 1
0
        public override void Insert(CountryRow value)
        {
            var _sqlStr = "DECLARE " + Database.CreateSqlParameterName(CountryRow_Base.country_id_PropName) + " int " +
                          "SET " + Database.CreateSqlParameterName(CountryRow_Base.country_id_PropName) +
                          " = COALESCE((SELECT MAX(" + CountryRow_Base.country_id_DbName + ") FROM Country) + 1, 1) " +

                          "INSERT INTO [dbo].[Country] (" +
                          "[" + CountryRow_Base.country_id_DbName + "], " +
                          "[" + CountryRow_Base.name_DbName + "], " +
                          "[" + CountryRow_Base.country_code_DbName + "], " +
                          "[" + CountryRow_Base.status_DbName + "], " +
                          "[" + CountryRow_Base.version_DbName + "]" +
                          ") VALUES (" +
                          Database.CreateSqlParameterName(CountryRow_Base.country_id_PropName) + ", " +
                          Database.CreateSqlParameterName(CountryRow_Base.name_PropName) + ", " +
                          Database.CreateSqlParameterName(CountryRow_Base.country_code_PropName) + ", " +
                          Database.CreateSqlParameterName(CountryRow_Base.status_PropName) + ", " +
                          Database.CreateSqlParameterName(CountryRow_Base.version_PropName) + ") " +
                          " SELECT " + Database.CreateSqlParameterName(CountryRow_Base.country_id_PropName);
            var _cmd = Database.CreateCommand(_sqlStr);

            AddParameter(_cmd, CountryRow_Base.name_PropName, value.Name);
            AddParameter(_cmd, CountryRow_Base.country_code_PropName, value.Country_code);
            AddParameter(_cmd, CountryRow_Base.status_PropName, value.Status);
            AddParameter(_cmd, CountryRow_Base.version_PropName, value.Version);

            value.Country_id = (int)_cmd.ExecuteScalar();
        }
Esempio n. 2
0
 public bool IsNameChanged(CountryRow pOriginal)
 {
     return(Name != pOriginal.Name);
 }